From ad6942e580b2f5391244401a02bdbad04ec96d9b Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期二, 29 十一月 2022 11:25:16 +0800 Subject: [PATCH] 产品与器具;工序流转卡;销售订单 --- WebAPI/Controllers/SCGL/日计划管理/Sc_WorkBillSortBillController.cs | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/Sc_WorkBillSortBillController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/Sc_WorkBillSortBillController.cs" index c8f9d5b..4a507a7 100644 --- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/Sc_WorkBillSortBillController.cs" +++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/Sc_WorkBillSortBillController.cs" @@ -35,7 +35,7 @@ return objJsonResult; } - ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + "order by 鍗曟嵁鍙� desc ", "h_v_JIT_Sc_WorkBillSortBillList"); + ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + " order by 鍗曟嵁鍙� desc ", "h_v_JIT_Sc_WorkBillSortBillList"); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -219,7 +219,7 @@ //鎻掑叆瀛愯〃 foreach (Models.Sc_WorkBillSortBillSub oSub in omodelsub) { - oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID,HRemark,HMasterDate,HQty" + + oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ,HRemark,HMasterDate,HQty" + ", HRptFinishQty, HTimes, HUseTimes, HBTimes, HETimes" + ", HDateSub, HCloseMan, HEntryCloseDate, HCloseTypeSub, HColumn" + ", HLockedSub, HComplete, HStatusTag, HIsHandModify)" + -- Gitblit v1.9.1