谢谢summer老师,这是测试代码,问题完美解决 int main() { string sql; int a, b; sql = "declare @v int"; sql = sql + " select @v=count(1) from res_catalog where res_cat_id='2000'"; sql = sql + " if @v=0 insert into res_catalog(res_cat_id,res_cat_name,order_id,batch_flag,cost_cal_method,edt_io_flag)"; sql = sql + "values('2000','测试主用','2000','N','B','Y')"; sql = sql + " select @v=count(1) from res_catalog where res_cat_id='3000'"; sql = sql + " if @v=0 insert into res_catalog(res_cat_id,res_cat_name,order_id,batch_flag,cost_cal_method,edt_io_flag)"; sql = sql + "values('3000','测试产品组成','3000','N','B','Y')"; db_run(sql); db_run("delete from res where res_cat_id in('2000','3000') delete from res_composing where note_info='测试用' commit"); sql = "insert into res(res_id,res_name,res_cat_id,res_unit_type,res_spec)values('"; sql = sql + "200','测试主产品','2000','B','测试') commit"; db_run(sql); for (a = 100; a <= 150; a++) { sql = "insert into res(res_id,res_name,res_cat_id,res_unit_type,res_spec)values('"; sql = sql + a + "','测试子产品" + a + "','3000','B','" + a + "测试')"; db_run(sql); sql = "insert into res_composing(res_id,sub_res_id,note_info)values('200','" + a + "','测试用')commit"; db_run(sql); dt_refresh_key("res",a); } view_app_obj("res", '200'); return 1; }; |