From 2566524594675a8d742f9ba0eff35dd5d8d33fa2 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 31 三月 2025 12:43:22 +0800 Subject: [PATCH] 排产:Excel导入功能,上传文件时,如果时宝工,则返回excel文件中维护的数量,不然则取生产订单的数量 --- BLL/bin/Release/DAL.dll | 0 BLL/bin/Release/SQLHelper.pdb | 0 DAL/bin/Release/DBUtility.dll | 0 DAL/bin/Release/Pub_Control.dll | 0 DBUtility/bin/Release/Pub_Control.pdb | 0 BLL/bin/Release/SQLHelper.dll | 0 DAL/bin/Release/DBUtility.pdb | 0 DAL/bin/Release/Model.dll | 0 WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormImportController.cs | 15 ++++++- WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user | 46 +++++++++++----------- DBUtility/bin/Release/Pub_Class.dll | 0 DBUtility/bin/Release/Pub_Control.dll | 0 Model/bin/Release/SQLHelper.pdb | 0 DAL/bin/Release/Pub_Control.pdb | 0 DAL/bin/Release/DAL.pdb | 0 SQLHelper/obj/Release/SQLHelper.dll | 0 Model/bin/Release/Pub_Control.pdb | 0 BLL/bin/Release/Model.dll | 0 sdk_dingding/TopSdk/obj/Release/TopSdk.pdb | 0 BLL/bin/Release/DAL.pdb | 0 Model/bin/Release/Pub_Class.pdb | 0 BLL/bin/Release/Model.pdb | 0 DAL/bin/Release/DAL.dll | 0 DAL/bin/Release/Model.pdb | 0 sdk_dingding/TopSdk/obj/Release/TopSdk.dll | 0 SQLHelper/obj/Release/SQLHelper.pdb | 0 sdk_dingding/TopSdk/bin/Release/TopSdk.dll | 0 Model/obj/Release/Model.pdb | 0 BLL/bin/Release/BLL.pdb | 0 DBUtility/bin/Release/DBUtility.pdb | 0 DBUtility/bin/Release/DBUtility.dll | 0 Model/bin/Release/Pub_Control.dll | 0 sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.AssemblyReference.cache | 0 DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache | 0 Pub_Control/bin/Release/Pub_Class.pdb | 0 sdk_dingding/TopSdk/bin/Release/TopSdk.pdb | 0 Pub_Control/bin/Release/Pub_Class.dll | 0 BLL/bin/Release/Pub_Control.pdb | 0 Pub_Class/bin/Release/Pub_Class.pdb | 0 Pub_Control/bin/Release/Pub_Control.dll | 0 BLL/bin/Release/DBUtility.pdb | 0 DAL/bin/Release/SQLHelper.dll | 0 Model/bin/Release/DBUtility.pdb | 0 SQLHelper/bin/Release/SQLHelper.dll | 0 SQLHelper/bin/Release/Pub_Class.pdb | 0 BLL/bin/Release/Pub_Control.dll | 0 Pub_Class/bin/Release/Pub_Class.dll | 0 DAL/bin/Release/SQLHelper.pdb | 0 SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache | 0 SQLHelper/bin/Release/Pub_Class.dll | 0 SQLHelper/bin/Release/SQLHelper.pdb | 0 DBUtility/obj/Release/DBUtility.pdb | 0 Model/bin/Release/DBUtility.dll | 0 DAL/bin/Release/Pub_Class.pdb | 0 BLL/bin/Release/DBUtility.dll | 0 BLL/bin/Release/BLL.dll | 0 Pub_Control/bin/Release/Pub_Control.pdb | 0 DBUtility/obj/Release/DBUtility.dll | 0 Model/obj/Release/Model.dll | 0 BLL/bin/Release/Pub_Class.dll | 0 DBUtility/bin/Release/SQLHelper.dll | 0 sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt | 1 Model/obj/Release/Model.csproj.AssemblyReference.cache | 0 Model/bin/Release/Model.pdb | 0 DBUtility/bin/Release/SQLHelper.pdb | 0 DAL/bin/Release/Pub_Class.dll | 0 Model/bin/Release/Pub_Class.dll | 0 Model/bin/Release/Model.dll | 0 DBUtility/bin/Release/Pub_Class.pdb | 0 BLL/bin/Release/Pub_Class.pdb | 0 Model/bin/Release/SQLHelper.dll | 0 71 files changed, 36 insertions(+), 26 deletions(-) diff --git a/BLL/bin/Release/BLL.dll b/BLL/bin/Release/BLL.dll index 053b09b..568ff23 100644 --- a/BLL/bin/Release/BLL.dll +++ b/BLL/bin/Release/BLL.dll Binary files differ diff --git a/BLL/bin/Release/BLL.pdb b/BLL/bin/Release/BLL.pdb index ddc0f72..8933f24 100644 --- a/BLL/bin/Release/BLL.pdb +++ b/BLL/bin/Release/BLL.pdb Binary files differ diff --git a/BLL/bin/Release/DAL.dll b/BLL/bin/Release/DAL.dll index 2d703be..811f182 100644 --- a/BLL/bin/Release/DAL.dll +++ b/BLL/bin/Release/DAL.dll Binary files differ diff --git a/BLL/bin/Release/DAL.pdb b/BLL/bin/Release/DAL.pdb index d156554..cd8d8e0 100644 --- a/BLL/bin/Release/DAL.pdb +++ b/BLL/bin/Release/DAL.pdb Binary files differ diff --git a/BLL/bin/Release/DBUtility.dll b/BLL/bin/Release/DBUtility.dll index 51b6f6b..eb94298 100644 --- a/BLL/bin/Release/DBUtility.dll +++ b/BLL/bin/Release/DBUtility.dll Binary files differ diff --git a/BLL/bin/Release/DBUtility.pdb b/BLL/bin/Release/DBUtility.pdb index cce4fdb..20c1ed7 100644 --- a/BLL/bin/Release/DBUtility.pdb +++ b/BLL/bin/Release/DBUtility.pdb Binary files differ diff --git a/BLL/bin/Release/Model.dll b/BLL/bin/Release/Model.dll index 870cd12..94efa64 100644 --- a/BLL/bin/Release/Model.dll +++ b/BLL/bin/Release/Model.dll Binary files differ diff --git a/BLL/bin/Release/Model.pdb b/BLL/bin/Release/Model.pdb index b80b684..f4df294 100644 --- a/BLL/bin/Release/Model.pdb +++ b/BLL/bin/Release/Model.pdb Binary files differ diff --git a/BLL/bin/Release/Pub_Class.dll b/BLL/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/BLL/bin/Release/Pub_Class.dll +++ b/BLL/bin/Release/Pub_Class.dll Binary files differ diff --git a/BLL/bin/Release/Pub_Class.pdb b/BLL/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/BLL/bin/Release/Pub_Class.pdb +++ b/BLL/bin/Release/Pub_Class.pdb Binary files differ diff --git a/BLL/bin/Release/Pub_Control.dll b/BLL/bin/Release/Pub_Control.dll index 95eee4a..bbdbb15 100644 --- a/BLL/bin/Release/Pub_Control.dll +++ b/BLL/bin/Release/Pub_Control.dll Binary files differ diff --git a/BLL/bin/Release/Pub_Control.pdb b/BLL/bin/Release/Pub_Control.pdb index 5b8b319..f1175cc 100644 --- a/BLL/bin/Release/Pub_Control.pdb +++ b/BLL/bin/Release/Pub_Control.pdb Binary files differ diff --git a/BLL/bin/Release/SQLHelper.dll b/BLL/bin/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/BLL/bin/Release/SQLHelper.dll +++ b/BLL/bin/Release/SQLHelper.dll Binary files differ diff --git a/BLL/bin/Release/SQLHelper.pdb b/BLL/bin/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/BLL/bin/Release/SQLHelper.pdb +++ b/BLL/bin/Release/SQLHelper.pdb Binary files differ diff --git a/DAL/bin/Release/DAL.dll b/DAL/bin/Release/DAL.dll index 2d703be..811f182 100644 --- a/DAL/bin/Release/DAL.dll +++ b/DAL/bin/Release/DAL.dll Binary files differ diff --git a/DAL/bin/Release/DAL.pdb b/DAL/bin/Release/DAL.pdb index d156554..cd8d8e0 100644 --- a/DAL/bin/Release/DAL.pdb +++ b/DAL/bin/Release/DAL.pdb Binary files differ diff --git a/DAL/bin/Release/DBUtility.dll b/DAL/bin/Release/DBUtility.dll index 51b6f6b..eb94298 100644 --- a/DAL/bin/Release/DBUtility.dll +++ b/DAL/bin/Release/DBUtility.dll Binary files differ diff --git a/DAL/bin/Release/DBUtility.pdb b/DAL/bin/Release/DBUtility.pdb index cce4fdb..20c1ed7 100644 --- a/DAL/bin/Release/DBUtility.pdb +++ b/DAL/bin/Release/DBUtility.pdb Binary files differ diff --git a/DAL/bin/Release/Model.dll b/DAL/bin/Release/Model.dll index 870cd12..94efa64 100644 --- a/DAL/bin/Release/Model.dll +++ b/DAL/bin/Release/Model.dll Binary files differ diff --git a/DAL/bin/Release/Model.pdb b/DAL/bin/Release/Model.pdb index b80b684..f4df294 100644 --- a/DAL/bin/Release/Model.pdb +++ b/DAL/bin/Release/Model.pdb Binary files differ diff --git a/DAL/bin/Release/Pub_Class.dll b/DAL/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/DAL/bin/Release/Pub_Class.dll +++ b/DAL/bin/Release/Pub_Class.dll Binary files differ diff --git a/DAL/bin/Release/Pub_Class.pdb b/DAL/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/DAL/bin/Release/Pub_Class.pdb +++ b/DAL/bin/Release/Pub_Class.pdb Binary files differ diff --git a/DAL/bin/Release/Pub_Control.dll b/DAL/bin/Release/Pub_Control.dll index 95eee4a..bbdbb15 100644 --- a/DAL/bin/Release/Pub_Control.dll +++ b/DAL/bin/Release/Pub_Control.dll Binary files differ diff --git a/DAL/bin/Release/Pub_Control.pdb b/DAL/bin/Release/Pub_Control.pdb index 5b8b319..f1175cc 100644 --- a/DAL/bin/Release/Pub_Control.pdb +++ b/DAL/bin/Release/Pub_Control.pdb Binary files differ diff --git a/DAL/bin/Release/SQLHelper.dll b/DAL/bin/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/DAL/bin/Release/SQLHelper.dll +++ b/DAL/bin/Release/SQLHelper.dll Binary files differ diff --git a/DAL/bin/Release/SQLHelper.pdb b/DAL/bin/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/DAL/bin/Release/SQLHelper.pdb +++ b/DAL/bin/Release/SQLHelper.pdb Binary files differ diff --git a/DBUtility/bin/Release/DBUtility.dll b/DBUtility/bin/Release/DBUtility.dll index 51b6f6b..eb94298 100644 --- a/DBUtility/bin/Release/DBUtility.dll +++ b/DBUtility/bin/Release/DBUtility.dll Binary files differ diff --git a/DBUtility/bin/Release/DBUtility.pdb b/DBUtility/bin/Release/DBUtility.pdb index cce4fdb..20c1ed7 100644 --- a/DBUtility/bin/Release/DBUtility.pdb +++ b/DBUtility/bin/Release/DBUtility.pdb Binary files differ diff --git a/DBUtility/bin/Release/Pub_Class.dll b/DBUtility/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/DBUtility/bin/Release/Pub_Class.dll +++ b/DBUtility/bin/Release/Pub_Class.dll Binary files differ diff --git a/DBUtility/bin/Release/Pub_Class.pdb b/DBUtility/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/DBUtility/bin/Release/Pub_Class.pdb +++ b/DBUtility/bin/Release/Pub_Class.pdb Binary files differ diff --git a/DBUtility/bin/Release/Pub_Control.dll b/DBUtility/bin/Release/Pub_Control.dll index 95eee4a..bbdbb15 100644 --- a/DBUtility/bin/Release/Pub_Control.dll +++ b/DBUtility/bin/Release/Pub_Control.dll Binary files differ diff --git a/DBUtility/bin/Release/Pub_Control.pdb b/DBUtility/bin/Release/Pub_Control.pdb index 5b8b319..f1175cc 100644 --- a/DBUtility/bin/Release/Pub_Control.pdb +++ b/DBUtility/bin/Release/Pub_Control.pdb Binary files differ diff --git a/DBUtility/bin/Release/SQLHelper.dll b/DBUtility/bin/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/DBUtility/bin/Release/SQLHelper.dll +++ b/DBUtility/bin/Release/SQLHelper.dll Binary files differ diff --git a/DBUtility/bin/Release/SQLHelper.pdb b/DBUtility/bin/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/DBUtility/bin/Release/SQLHelper.pdb +++ b/DBUtility/bin/Release/SQLHelper.pdb Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache b/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache index 2a7938d..9212279 100644 --- a/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache +++ b/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.dll b/DBUtility/obj/Release/DBUtility.dll index 51b6f6b..eb94298 100644 --- a/DBUtility/obj/Release/DBUtility.dll +++ b/DBUtility/obj/Release/DBUtility.dll Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.pdb b/DBUtility/obj/Release/DBUtility.pdb index cce4fdb..20c1ed7 100644 --- a/DBUtility/obj/Release/DBUtility.pdb +++ b/DBUtility/obj/Release/DBUtility.pdb Binary files differ diff --git a/Model/bin/Release/DBUtility.dll b/Model/bin/Release/DBUtility.dll index 51b6f6b..eb94298 100644 --- a/Model/bin/Release/DBUtility.dll +++ b/Model/bin/Release/DBUtility.dll Binary files differ diff --git a/Model/bin/Release/DBUtility.pdb b/Model/bin/Release/DBUtility.pdb index cce4fdb..20c1ed7 100644 --- a/Model/bin/Release/DBUtility.pdb +++ b/Model/bin/Release/DBUtility.pdb Binary files differ diff --git a/Model/bin/Release/Model.dll b/Model/bin/Release/Model.dll index 870cd12..94efa64 100644 --- a/Model/bin/Release/Model.dll +++ b/Model/bin/Release/Model.dll Binary files differ diff --git a/Model/bin/Release/Model.pdb b/Model/bin/Release/Model.pdb index b80b684..f4df294 100644 --- a/Model/bin/Release/Model.pdb +++ b/Model/bin/Release/Model.pdb Binary files differ diff --git a/Model/bin/Release/Pub_Class.dll b/Model/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/Model/bin/Release/Pub_Class.dll +++ b/Model/bin/Release/Pub_Class.dll Binary files differ diff --git a/Model/bin/Release/Pub_Class.pdb b/Model/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/Model/bin/Release/Pub_Class.pdb +++ b/Model/bin/Release/Pub_Class.pdb Binary files differ diff --git a/Model/bin/Release/Pub_Control.dll b/Model/bin/Release/Pub_Control.dll index 95eee4a..bbdbb15 100644 --- a/Model/bin/Release/Pub_Control.dll +++ b/Model/bin/Release/Pub_Control.dll Binary files differ diff --git a/Model/bin/Release/Pub_Control.pdb b/Model/bin/Release/Pub_Control.pdb index 5b8b319..f1175cc 100644 --- a/Model/bin/Release/Pub_Control.pdb +++ b/Model/bin/Release/Pub_Control.pdb Binary files differ diff --git a/Model/bin/Release/SQLHelper.dll b/Model/bin/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/Model/bin/Release/SQLHelper.dll +++ b/Model/bin/Release/SQLHelper.dll Binary files differ diff --git a/Model/bin/Release/SQLHelper.pdb b/Model/bin/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/Model/bin/Release/SQLHelper.pdb +++ b/Model/bin/Release/SQLHelper.pdb Binary files differ diff --git a/Model/obj/Release/Model.csproj.AssemblyReference.cache b/Model/obj/Release/Model.csproj.AssemblyReference.cache index 07d60d2..22e6329 100644 --- a/Model/obj/Release/Model.csproj.AssemblyReference.cache +++ b/Model/obj/Release/Model.csproj.AssemblyReference.cache Binary files differ diff --git a/Model/obj/Release/Model.dll b/Model/obj/Release/Model.dll index 870cd12..94efa64 100644 --- a/Model/obj/Release/Model.dll +++ b/Model/obj/Release/Model.dll Binary files differ diff --git a/Model/obj/Release/Model.pdb b/Model/obj/Release/Model.pdb index b80b684..f4df294 100644 --- a/Model/obj/Release/Model.pdb +++ b/Model/obj/Release/Model.pdb Binary files differ diff --git a/Pub_Class/bin/Release/Pub_Class.dll b/Pub_Class/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/Pub_Class/bin/Release/Pub_Class.dll +++ b/Pub_Class/bin/Release/Pub_Class.dll Binary files differ diff --git a/Pub_Class/bin/Release/Pub_Class.pdb b/Pub_Class/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/Pub_Class/bin/Release/Pub_Class.pdb +++ b/Pub_Class/bin/Release/Pub_Class.pdb Binary files differ diff --git a/Pub_Control/bin/Release/Pub_Class.dll b/Pub_Control/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/Pub_Control/bin/Release/Pub_Class.dll +++ b/Pub_Control/bin/Release/Pub_Class.dll Binary files differ diff --git a/Pub_Control/bin/Release/Pub_Class.pdb b/Pub_Control/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/Pub_Control/bin/Release/Pub_Class.pdb +++ b/Pub_Control/bin/Release/Pub_Class.pdb Binary files differ diff --git a/Pub_Control/bin/Release/Pub_Control.dll b/Pub_Control/bin/Release/Pub_Control.dll index 95eee4a..bbdbb15 100644 --- a/Pub_Control/bin/Release/Pub_Control.dll +++ b/Pub_Control/bin/Release/Pub_Control.dll Binary files differ diff --git a/Pub_Control/bin/Release/Pub_Control.pdb b/Pub_Control/bin/Release/Pub_Control.pdb index 5b8b319..f1175cc 100644 --- a/Pub_Control/bin/Release/Pub_Control.pdb +++ b/Pub_Control/bin/Release/Pub_Control.pdb Binary files differ diff --git a/SQLHelper/bin/Release/Pub_Class.dll b/SQLHelper/bin/Release/Pub_Class.dll index 514d832..2fffa22 100644 --- a/SQLHelper/bin/Release/Pub_Class.dll +++ b/SQLHelper/bin/Release/Pub_Class.dll Binary files differ diff --git a/SQLHelper/bin/Release/Pub_Class.pdb b/SQLHelper/bin/Release/Pub_Class.pdb index 1d7c2ac..e2ff978 100644 --- a/SQLHelper/bin/Release/Pub_Class.pdb +++ b/SQLHelper/bin/Release/Pub_Class.pdb Binary files differ diff --git a/SQLHelper/bin/Release/SQLHelper.dll b/SQLHelper/bin/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/SQLHelper/bin/Release/SQLHelper.dll +++ b/SQLHelper/bin/Release/SQLHelper.dll Binary files differ diff --git a/SQLHelper/bin/Release/SQLHelper.pdb b/SQLHelper/bin/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/SQLHelper/bin/Release/SQLHelper.pdb +++ b/SQLHelper/bin/Release/SQLHelper.pdb Binary files differ diff --git a/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache b/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache index 9e01b1d..d88cbfb 100644 --- a/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache +++ b/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache Binary files differ diff --git a/SQLHelper/obj/Release/SQLHelper.dll b/SQLHelper/obj/Release/SQLHelper.dll index 45dec64..b3c5c52 100644 --- a/SQLHelper/obj/Release/SQLHelper.dll +++ b/SQLHelper/obj/Release/SQLHelper.dll Binary files differ diff --git a/SQLHelper/obj/Release/SQLHelper.pdb b/SQLHelper/obj/Release/SQLHelper.pdb index c895d4d..af2dfbb 100644 --- a/SQLHelper/obj/Release/SQLHelper.pdb +++ b/SQLHelper/obj/Release/SQLHelper.pdb Binary files differ diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs" index d2f183c..c3e0626 100644 --- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs" +++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs" @@ -158,7 +158,15 @@ tb2.Rows[i]["HWorkShopID"] = ds.Tables[0].Rows[0]["HDeptID"].ToString(); tb2.Rows[i]["ICMOBillHInterID"] = ds.Tables[0].Rows[0]["hmainid"].ToString();//鐢熶骇璁㈠崟涓籭d tb2.Rows[i]["ICMOBillHEntryID"] = ds.Tables[0].Rows[0]["HEntryID"].ToString();//鐢熶骇璁㈠崟瀛恑d - tb2.Rows[i]["鐢熶骇璁㈠崟鏁伴噺"] = ds.Tables[0].Rows[0]["鐢熶骇浠诲姟鍗曟暟閲�"].ToString();//鐢熶骇璁㈠崟鏁伴噺 + string sErr = ""; + if (oSystemParameter.ShowBill(ref sErr)) + { + if (oSystemParameter.omodel.WMS_CampanyName != "瀹濆伐") + { + tb2.Rows[i]["鐢熶骇璁㈠崟鏁伴噺"] = ds.Tables[0].Rows[0]["鐢熶骇浠诲姟鍗曟暟閲�"].ToString();//鐢熶骇璁㈠崟鏁伴噺 + } + } + //tb2.Rows[i]["鐢熶骇璁㈠崟鏁伴噺"] = ds.Tables[0].Rows[0]["鐢熶骇浠诲姟鍗曟暟閲�"].ToString();//鐢熶骇璁㈠崟鏁伴噺 tb2.Rows[i]["HSeOrderBillNo"] = ds.Tables[0].Rows[0]["閿�鍞鍗曞彿"].ToString();//閿�鍞鍗曞彿 } @@ -341,6 +349,7 @@ var HProdORGID = list[i]["HProdORGID"].ToString(); var HWorkShopID = list[i]["HWorkShopID"].ToString(); var HSourceID = list[i]["HSourceID"].ToString(); + var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["浜ц兘"]); var HYX = list[i]["浼樺厛绾�"].ToString(); var HEmpID = list[i]["HEmpID"].ToString(); var HMaterID = list[i]["HMaterID"].ToString(); @@ -373,14 +382,14 @@ //涓昏〃 oCN.RunProc("insert into Sc_WorkBillSortBillMain(HInterID,HBillNo,HYear,HPeriod,HBillType," + "HBillSubType,HDate,HBillStatus,HMaker,HMakeDate,HICMOBillNo,HOrderType," + - "HICMOEntrySEQ,HWorkShopID,HSourceID, HYX, HEmpID," + + "HICMOEntrySEQ,HWorkShopID,HSourceID, HYX,HWorkQty, HEmpID," + " HMaterID, HMaterName, HMaterModel, HUnitID, HBatchNo," + " HSeOrderBillQty, HPlanQty, HCompleteQty,HPreparatDate," + "HMainSourceInterID,HMainSourceEntryID,HICMOInterID,HICMOEntryID,HProdORGID,HICMOInterID_Sec,HICMOEntryID_Sec" + ",HSeOrderBillNo)values" + $"({HInterID},'{HBillNo}',{DateTime.Now.Year},{DateTime.Now.Month},'{BillType}'," + $"'{BillType}',GETDATE(),1,'{user}','{HDate}','{HICMOBillNo}','{HOrderType}'," + - $"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)}, {(HEmpID == "" ? 0.ToString() : HEmpID)}," + + $"{(HICMOEntrySEQ == "" ? 0.ToString() : HICMOEntrySEQ)},{(HWorkShopID == "" ? 0.ToString() : HWorkShopID)},{(HSourceID == "" ? 0.ToString() : HSourceID)}, {(HYX == "" ? 0.ToString() : HYX)},{(HWorkQty)}, {(HEmpID == "" ? 0.ToString() : HEmpID)}," + $" {(HMaterID == "" ? 0.ToString() : HMaterID)}, '{HMaterName}', '{HMaterModel}', {(HUnitID == "" ? 0.ToString() : HUnitID)}, '{HBatchNo}'," + $" {(HSeOrderBillQty == "" ? 0.ToString() : HSeOrderBillQty)}, {(HPlanQty == "" ? 0.ToString() : HPlanQty)}, {(HCompleteQty == "" ? 0.ToString() : HCompleteQty)},getdate()," + $" {HMainSourceInterID},{HMainSourceEntryID},{HMainSourceInterID},{HMainSourceEntryID},{HProdORGID}, {HMainSourceInterID},{HMainSourceEntryID}" + diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user index 76439ed..32cf07b 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile1.pubxml.user @@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> - <History>True|2025-03-26T04:42:08.9630741Z;True|2025-03-26T12:40:07.7144561+08:00;True|2025-03-26T12:30:37.3503331+08:00;True|2025-03-26T12:26:47.5061658+08:00;True|2025-03-26T10:54:47.2556717+08:00;True|2025-03-26T10:49:59.7897145+08:00;True|2025-03-26T10:47:02.6195828+08:00;False|2025-03-26T10:46:54.9421244+08:00;True|2025-03-26T01:10:19.1227462+08:00;True|2025-03-26T01:00:04.3583740+08:00;True|2025-03-26T00:38:57.4757071+08:00;True|2025-03-26T00:28:24.9370188+08:00;True|2025-03-26T00:04:05.4507425+08:00;True|2025-03-25T23:06:56.2284828+08:00;False|2025-03-25T23:06:46.7023339+08:00;True|2025-03-25T22:57:08.3127897+08:00;False|2025-03-25T22:55:05.8028873+08:00;False|2025-03-25T22:54:51.2053101+08:00;False|2025-03-04T11:23:36.7757604+08:00;True|2025-02-12T14:05:06.1068587+08:00;False|2025-02-12T14:03:43.3961038+08:00;True|2025-01-18T09:42:50.3629397+08:00;True|2025-01-18T09:39:16.1773412+08:00;True|2025-01-17T11:15:39.4147082+08:00;False|2025-01-17T11:15:09.0033498+08:00;True|2025-01-14T10:20:31.1504093+08:00;False|2025-01-14T10:19:59.1429931+08:00;True|2025-01-10T16:29:54.8671377+08:00;False|2025-01-10T16:29:05.0650370+08:00;True|2025-01-04T14:30:56.5041884+08:00;True|2025-01-04T14:26:52.7448761+08:00;True|2025-01-04T14:23:27.9956967+08:00;True|2025-01-04T14:12:46.2410106+08:00;True|2025-01-04T14:09:33.1727375+08:00;True|2025-01-04T14:07:16.3373347+08:00;False|2025-01-04T14:06:33.4982458+08:00;True|2024-12-31T13:36:55.7394582+08:00;False|2024-12-31T13:35:58.6205647+08:00;True|2024-12-28T15:59:32.1394796+08:00;True|2024-12-28T13:48:20.4283118+08:00;True|2024-12-28T13:43:39.8159616+08:00;True|2024-12-28T13:23:58.4183285+08:00;True|2024-12-28T13:19:13.0583263+08:00;True|2024-12-28T13:12:03.2648502+08:00;True|2024-12-28T13:04:22.6803754+08:00;False|2024-12-28T13:03:56.5993252+08:00;True|2024-12-28T10:50:06.1597154+08:00;True|2024-12-28T10:27:58.7075320+08:00;False|2024-12-28T10:27:09.9450571+08:00;True|2024-12-24T10:52:25.3403292+08:00;False|2024-12-24T10:51:41.8017370+08:00;True|2024-12-23T15:45:21.7729300+08:00;True|2024-12-23T15:31:38.8549407+08:00;True|2024-12-23T15:20:26.2361671+08:00;True|2024-12-23T13:40:03.2774116+08:00;False|2024-12-23T13:39:39.8510770+08:00;True|2024-12-23T13:11:15.3232454+08:00;True|2024-12-23T13:05:43.3057458+08:00;True|2024-12-16T10:57:23.0694936+08:00;True|2024-12-16T10:03:48.1938775+08:00;True|2024-12-16T09:38:57.3052219+08:00;False|2024-12-16T09:38:31.7097388+08:00;True|2024-12-16T09:25:38.3751534+08:00;False|2024-12-16T09:24:19.3952981+08:00;True|2024-12-11T22:41:13.2881405+08:00;False|2024-12-11T22:40:26.3239379+08:00;True|2024-12-11T22:14:41.4392948+08:00;True|2024-12-11T22:03:03.6823866+08:00;True|2024-12-11T21:48:51.7423044+08:00;False|2024-12-11T21:47:55.6236616+08:00;True|2024-12-02T14:57:10.0773563+08:00;False|2024-12-02T14:56:35.6440156+08:00;True|2024-11-26T08:55:53.9125170+08:00;True|2024-11-26T08:24:31.3112433+08:00;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History> + <History>True|2025-03-28T08:22:29.8664470Z;True|2025-03-28T15:53:12.1106288+08:00;False|2025-03-28T15:53:01.4674242+08:00;True|2025-03-28T13:34:17.5506822+08:00;False|2025-03-28T13:34:09.5853308+08:00;True|2025-03-26T12:42:08.9630741+08:00;True|2025-03-26T12:40:07.7144561+08:00;True|2025-03-26T12:30:37.3503331+08:00;True|2025-03-26T12:26:47.5061658+08:00;True|2025-03-26T10:54:47.2556717+08:00;True|2025-03-26T10:49:59.7897145+08:00;True|2025-03-26T10:47:02.6195828+08:00;False|2025-03-26T10:46:54.9421244+08:00;True|2025-03-26T01:10:19.1227462+08:00;True|2025-03-26T01:00:04.3583740+08:00;True|2025-03-26T00:38:57.4757071+08:00;True|2025-03-26T00:28:24.9370188+08:00;True|2025-03-26T00:04:05.4507425+08:00;True|2025-03-25T23:06:56.2284828+08:00;False|2025-03-25T23:06:46.7023339+08:00;True|2025-03-25T22:57:08.3127897+08:00;False|2025-03-25T22:55:05.8028873+08:00;False|2025-03-25T22:54:51.2053101+08:00;False|2025-03-04T11:23:36.7757604+08:00;True|2025-02-12T14:05:06.1068587+08:00;False|2025-02-12T14:03:43.3961038+08:00;True|2025-01-18T09:42:50.3629397+08:00;True|2025-01-18T09:39:16.1773412+08:00;True|2025-01-17T11:15:39.4147082+08:00;False|2025-01-17T11:15:09.0033498+08:00;True|2025-01-14T10:20:31.1504093+08:00;False|2025-01-14T10:19:59.1429931+08:00;True|2025-01-10T16:29:54.8671377+08:00;False|2025-01-10T16:29:05.0650370+08:00;True|2025-01-04T14:30:56.5041884+08:00;True|2025-01-04T14:26:52.7448761+08:00;True|2025-01-04T14:23:27.9956967+08:00;True|2025-01-04T14:12:46.2410106+08:00;True|2025-01-04T14:09:33.1727375+08:00;True|2025-01-04T14:07:16.3373347+08:00;False|2025-01-04T14:06:33.4982458+08:00;True|2024-12-31T13:36:55.7394582+08:00;False|2024-12-31T13:35:58.6205647+08:00;True|2024-12-28T15:59:32.1394796+08:00;True|2024-12-28T13:48:20.4283118+08:00;True|2024-12-28T13:43:39.8159616+08:00;True|2024-12-28T13:23:58.4183285+08:00;True|2024-12-28T13:19:13.0583263+08:00;True|2024-12-28T13:12:03.2648502+08:00;True|2024-12-28T13:04:22.6803754+08:00;False|2024-12-28T13:03:56.5993252+08:00;True|2024-12-28T10:50:06.1597154+08:00;True|2024-12-28T10:27:58.7075320+08:00;False|2024-12-28T10:27:09.9450571+08:00;True|2024-12-24T10:52:25.3403292+08:00;False|2024-12-24T10:51:41.8017370+08:00;True|2024-12-23T15:45:21.7729300+08:00;True|2024-12-23T15:31:38.8549407+08:00;True|2024-12-23T15:20:26.2361671+08:00;True|2024-12-23T13:40:03.2774116+08:00;False|2024-12-23T13:39:39.8510770+08:00;True|2024-12-23T13:11:15.3232454+08:00;True|2024-12-23T13:05:43.3057458+08:00;True|2024-12-16T10:57:23.0694936+08:00;True|2024-12-16T10:03:48.1938775+08:00;True|2024-12-16T09:38:57.3052219+08:00;False|2024-12-16T09:38:31.7097388+08:00;True|2024-12-16T09:25:38.3751534+08:00;False|2024-12-16T09:24:19.3952981+08:00;True|2024-12-11T22:41:13.2881405+08:00;False|2024-12-11T22:40:26.3239379+08:00;True|2024-12-11T22:14:41.4392948+08:00;True|2024-12-11T22:03:03.6823866+08:00;True|2024-12-11T21:48:51.7423044+08:00;False|2024-12-11T21:47:55.6236616+08:00;True|2024-12-02T14:57:10.0773563+08:00;False|2024-12-02T14:56:35.6440156+08:00;True|2024-11-26T08:55:53.9125170+08:00;True|2024-11-26T08:24:31.3112433+08:00;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History> <_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>03/26/2025 12:41:06</publishTime> + <publishTime>03/28/2025 16:21:56</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>03/26/2025 12:41:06</publishTime> + <publishTime>03/28/2025 16:21:56</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>03/26/2025 12:41:04</publishTime> + <publishTime>03/28/2025 16:21:52</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>03/26/2025 12:41:04</publishTime> + <publishTime>03/28/2025 16:21:52</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>03/26/2025 12:41:00</publishTime> + <publishTime>03/28/2025 16:21:44</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>03/26/2025 12:41:00</publishTime> + <publishTime>03/28/2025 16:21:44</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>03/26/2025 12:41:01</publishTime> + <publishTime>03/28/2025 16:21:46</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>03/26/2025 12:41:01</publishTime> + <publishTime>03/28/2025 16:21:46</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/06/2023 15:57:02</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>03/26/2025 12:40:57</publishTime> + <publishTime>03/28/2025 16:21:41</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>03/26/2025 12:40:57</publishTime> + <publishTime>03/28/2025 16:21:41</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>03/26/2025 12:40:59</publishTime> + <publishTime>03/28/2025 16:21:42</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>03/26/2025 12:40:59</publishTime> + <publishTime>03/28/2025 16:21:42</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>03/26/2025 12:40:59</publishTime> + <publishTime>03/28/2025 16:21:42</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>03/26/2025 12:40:59</publishTime> + <publishTime>03/28/2025 16:21:42</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> - <publishTime>03/26/2025 12:40:57</publishTime> + <publishTime>03/28/2025 16:21:38</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> - <publishTime>03/26/2025 12:40:57</publishTime> + <publishTime>03/28/2025 16:21:38</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,22 +285,22 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> - <publishTime>03/26/2025 12:41:01</publishTime> + <publishTime>03/28/2025 16:21:43</publishTime> </File> <File Include="bin/TopSdk.pdb"> - <publishTime>03/26/2025 12:41:01</publishTime> + <publishTime>03/28/2025 16:21:43</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>03/26/2025 12:41:12</publishTime> + <publishTime>03/28/2025 16:22:08</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>03/26/2025 12:41:12</publishTime> + <publishTime>03/28/2025 16:22:08</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> - <publishTime>03/26/2025 12:41:16</publishTime> + <publishTime>03/28/2025 16:22:15</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> @@ -495,7 +495,7 @@ <publishTime>05/06/2024 13:47:57</publishTime> </File> <File Include="Web.config"> - <publishTime>03/26/2025 12:42:08</publishTime> + <publishTime>03/28/2025 16:22:28</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/sdk_dingding/TopSdk/bin/Release/TopSdk.dll b/sdk_dingding/TopSdk/bin/Release/TopSdk.dll index 2ea4fea..67fe6d2 100644 --- a/sdk_dingding/TopSdk/bin/Release/TopSdk.dll +++ b/sdk_dingding/TopSdk/bin/Release/TopSdk.dll Binary files differ diff --git a/sdk_dingding/TopSdk/bin/Release/TopSdk.pdb b/sdk_dingding/TopSdk/bin/Release/TopSdk.pdb index 486e2a6..bd99fe2 100644 --- a/sdk_dingding/TopSdk/bin/Release/TopSdk.pdb +++ b/sdk_dingding/TopSdk/bin/Release/TopSdk.pdb Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.AssemblyReference.cache b/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.AssemblyReference.cache new file mode 100644 index 0000000..b3a6f35 --- /dev/null +++ b/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.AssemblyReference.cache Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt b/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt index dd9e641..35ce590 100644 --- a/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt +++ b/sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt @@ -3,3 +3,4 @@ D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.csproj.CoreCompileInputs.cache D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.dll D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.pdb +D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.csproj.AssemblyReference.cache diff --git a/sdk_dingding/TopSdk/obj/Release/TopSdk.dll b/sdk_dingding/TopSdk/obj/Release/TopSdk.dll index 2ea4fea..67fe6d2 100644 --- a/sdk_dingding/TopSdk/obj/Release/TopSdk.dll +++ b/sdk_dingding/TopSdk/obj/Release/TopSdk.dll Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Release/TopSdk.pdb b/sdk_dingding/TopSdk/obj/Release/TopSdk.pdb index 486e2a6..bd99fe2 100644 --- a/sdk_dingding/TopSdk/obj/Release/TopSdk.pdb +++ b/sdk_dingding/TopSdk/obj/Release/TopSdk.pdb Binary files differ -- Gitblit v1.9.1