blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-05-23 3db477ccda04b391872cbd570b7d1c1253e1f6e0 
 WebAPI/Controllers/LMESController.cs


@@ -74,6 +74,7 @@


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");






                //添加列名


                foreach (DataColumn col in ds.Tables[0].Columns)


                {


@@ -430,7 +431,7 @@


                    return objJsonResult;


                }


                oCN.BeginTran();//开始事务


                ds = oCN.RunProcReturn("select * from Gy_RoutingBillmain where HInterID=" + lngBillKey, "Gy_RoutingBillmain");


                ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + lngBillKey, "Gy_RoutingBillmain");


                if (ds == null || ds.Tables[0].Rows.Count == 0)


                {


                    objJsonResult.code = "0";


@@ -459,6 +460,9 @@


                //}


                oCN.RunProc("delete from Gy_RoutingBillmain where HInterID=" + lngBillKey);


                oCN.RunProc("delete from Gy_RoutingBillSub where HInterID=" + lngBillKey);




                LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",删除工艺路线单据:" + ds.Tables[0].Rows[0]["HBillNo"].ToString());




                oCN.Commit();//提交事务


                objJsonResult.code = "0";


                objJsonResult.count = 1;