From ee9f4215d0750a15031bfb89f0f347dadc8c1b70 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期三, 07 十二月 2022 13:10:46 +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