From 98fdb31018bde24c16598b98cdd1cf526dc1113f Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 31 十二月 2024 10:37:01 +0800 Subject: [PATCH] 1 --- Model/基础资料/基础资料/ClsGy_InspectInstruMent_Model.cs | 4 APSM/bin/Release/SQLHelper.dll | 0 WebAPI/WebAPI.csproj.user | 8 WebAPI/Controllers/生产管理/质量汇报单/Sc_QualityReportBillController.cs | 3 BaseSet/bin/Release/DBUtility.pdb | 0 DBUtility/bin/Release/Pub_Class.dll | 0 WarM/bin/Release/DBUtility.dll | 0 WebAPI/DLL/ClsGy_InspectInstruMent_Ctl.cs | 10 sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cache | 0 WarM/bin/Release/DBUtility.pdb | 0 PlanM/bin/Release/Pub_Control.pdb | 0 Model/bin/Release/Pub_Control.pdb | 0 Model/bin/Release/Pub_Class.pdb | 0 Model/bin/Release/Pub_Control.dll | 0 Pub_Control/bin/Release/Pub_Class.pdb | 0 WebAPI/Controllers/生产管理/报工台工序/Sc_MESBeginStepWorkBillController.cs | 3 PlanM/bin/Release/Pub_Class.dll | 0 WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormBillController.cs | 13 Pub_Control/bin/Release/Pub_Class.dll | 0 Model/质检管理/ClsQC_MonthTarGetBillSub.cs | 4 WebAPI/WebAPI.csproj | 1 DAL/生产管理/ClsSc_QualityReportBill.cs | 8 PlanM/bin/Release/Pub_Class.pdb | 0 BLL/bin/Release/Pub_Control.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 WebAPI/Controllers/CJGL/Cj_SingleStationController.cs | 2 WebAPI/Controllers/条码管理/WEBSController.cs | 45 APSM/bin/Release/Pub_Control.pdb | 0 APSM/bin/Release/DBUtility.pdb | 0 BLL/bin/Release/Pub_Control.dll | 0 WorkM/bin/Release/Pub_Class.dll | 0 DAL/bin/Release/SQLHelper.pdb | 0 DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache | 0 WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs | 57 + SQLHelper/bin/Release/SQLHelper.pdb | 0 DBUtility/obj/Release/DBUtility.pdb | 0 Model/bin/Release/DBUtility.dll | 0 BLL/bin/Release/DBUtility.dll | 0 DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache | 0 BaseSet/bin/Release/SQLHelper.pdb | 0 WebAPI/Web.config | 2 WorkM/bin/Release/Pub_Class.pdb | 0 Pub_Control/bin/Release/Pub_Control.pdb | 0 BaseSet/bin/Release/SQLHelper.dll | 0 DBUtility/obj/Release/DBUtility.dll | 0 APSM/bin/Release/DBUtility.dll | 0 Model/生产管理/ClsSc_QualityReportBillSub.cs | 1 WorkM/bin/Release/Pub_Control.pdb | 0 BLL/bin/Release/Pub_Class.dll | 0 WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs | 167 +++ WorkM/bin/Release/DBUtility.pdb | 0 PlanM/bin/Release/Pub_Control.dll | 0 DBUtility/bin/Release/SQLHelper.dll | 0 WorkM/bin/Release/DBUtility.dll | 0 DAL/质检管理/ClsQC_MonthTarGetBill.cs | 35 DBUtility/bin/Release/SQLHelper.pdb | 0 Model/bin/Release/Pub_Class.dll | 0 SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache | 0 BLL/bin/Release/Pub_Class.pdb | 0 WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 162 +++ WorkM/bin/Release/Pub_Control.dll | 0 APSM/bin/Release/Pub_Class.dll | 0 APSM/bin/Release/Pub_Control.dll | 0 WebAPI/DLL/ClsSc_MouldProdInBill.cs | 88 + SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt | 19 WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user | 44 BLL/bin/Release/SQLHelper.pdb | 0 DAL/bin/Release/DBUtility.dll | 0 PlanM/bin/Release/SQLHelper.dll | 0 WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs | 99 ++ WebAPI/Controllers/SCGL/日计划管理/JIT_CompleteController..cs | 7 BaseSet/bin/Release/Pub_Control.pdb | 0 WarM/bin/Release/Pub_Control.pdb | 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 BaseSet/bin/Release/Pub_Control.dll | 0 APSM/bin/Release/Pub_Class.pdb | 0 WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 2 DBUtility/bin/Release/Pub_Control.dll | 0 Model/bin/Release/SQLHelper.pdb | 0 WebAPI/Controllers/品质管理/质量月度目标单/QC_MonthTarGetBillController.cs | 34 DAL/bin/Release/Pub_Control.pdb | 0 SQLHelper/obj/Release/SQLHelper.dll | 0 WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs | 4 WebAPI/bin.rar | 0 BaseSet/bin/Release/Pub_Class.dll | 0 WebAPI/Models/Supplier.cs | 2 BaseSet/bin/Release/Pub_Class.pdb | 0 WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs | 2 SQLHelper/obj/Release/SQLHelper.pdb | 0 DBUtility/bin/Release/DBUtility.pdb | 0 DBUtility/bin/Release/DBUtility.dll | 0 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 123 ++ WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | 787 ++++++++++++++++ WebAPI/Controllers/WebAPIController.cs | 45 WarM/bin/Release/Pub_Class.dll | 0 WarM/bin/Release/Pub_Control.dll | 0 WarM/bin/Release/SQLHelper.pdb | 0 PlanM/bin/Release/SQLHelper.pdb | 0 WebAPI/Controllers/品质管理/质量报表/QC_QualityReportsController.cs | 13 sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt | 19 WarM/bin/Release/Pub_Class.pdb | 0 Pub_Class/bin/Release/Pub_Class.pdb | 0 WebAPI/Models/Sc_StationOutBillSub_Sup.cs | 21 PlanM/bin/Release/DBUtility.dll | 0 WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user | 44 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs | 2 SQLHelper/bin/Release/Pub_Class.pdb | 0 WarM/bin/Release/SQLHelper.dll | 0 Pub_Class/bin/Release/Pub_Class.dll | 0 WebAPI/Controllers/BaseSet/Gy_SupplierController.cs | 22 SQLHelper/bin/Release/Pub_Class.dll | 0 DAL/bin/Release/Pub_Class.pdb | 0 WebAPI/Controllers/CJGL/Sc_OEEReportController.cs | 102 ++ PlanM/bin/Release/DBUtility.pdb | 0 WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs | 163 +++ WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml | 16 WorkM/bin/Release/SQLHelper.pdb | 0 WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml.user | 498 ++++++++++ DAL/bin/Release/Pub_Class.dll | 0 DBUtility/bin/Release/Pub_Class.pdb | 0 Model/bin/Release/SQLHelper.dll | 0 BaseSet/bin/Release/DBUtility.dll | 0 WorkM/bin/Release/SQLHelper.dll | 0 APSM/bin/Release/SQLHelper.pdb | 0 WebAPI/Controllers/ReportPlatFormController.cs | 157 +++ 132 files changed, 2,736 insertions(+), 102 deletions(-) diff --git a/APSM/bin/Release/DBUtility.dll b/APSM/bin/Release/DBUtility.dll index 5b73185..e149e84 100644 --- a/APSM/bin/Release/DBUtility.dll +++ b/APSM/bin/Release/DBUtility.dll Binary files differ diff --git a/APSM/bin/Release/DBUtility.pdb b/APSM/bin/Release/DBUtility.pdb index 5868f01..27f69f8 100644 --- a/APSM/bin/Release/DBUtility.pdb +++ b/APSM/bin/Release/DBUtility.pdb Binary files differ diff --git a/APSM/bin/Release/Pub_Class.dll b/APSM/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 100644 --- a/APSM/bin/Release/Pub_Class.dll +++ b/APSM/bin/Release/Pub_Class.dll Binary files differ diff --git a/APSM/bin/Release/Pub_Class.pdb b/APSM/bin/Release/Pub_Class.pdb index 52a6297..9a615cd 100644 --- a/APSM/bin/Release/Pub_Class.pdb +++ b/APSM/bin/Release/Pub_Class.pdb Binary files differ diff --git a/APSM/bin/Release/Pub_Control.dll b/APSM/bin/Release/Pub_Control.dll index 244bf7f..944241b 100644 --- a/APSM/bin/Release/Pub_Control.dll +++ b/APSM/bin/Release/Pub_Control.dll Binary files differ diff --git a/APSM/bin/Release/Pub_Control.pdb b/APSM/bin/Release/Pub_Control.pdb index edce0ca..4a1acf9 100644 --- a/APSM/bin/Release/Pub_Control.pdb +++ b/APSM/bin/Release/Pub_Control.pdb Binary files differ diff --git a/APSM/bin/Release/SQLHelper.dll b/APSM/bin/Release/SQLHelper.dll index 6fdd03e..a358039 100644 --- a/APSM/bin/Release/SQLHelper.dll +++ b/APSM/bin/Release/SQLHelper.dll Binary files differ diff --git a/APSM/bin/Release/SQLHelper.pdb b/APSM/bin/Release/SQLHelper.pdb index 5c090db..04f7af8 100644 --- a/APSM/bin/Release/SQLHelper.pdb +++ b/APSM/bin/Release/SQLHelper.pdb Binary files differ diff --git a/BLL/bin/Release/DBUtility.dll b/BLL/bin/Release/DBUtility.dll index 5b73185..e149e84 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 5868f01..27f69f8 100644 --- a/BLL/bin/Release/DBUtility.pdb +++ b/BLL/bin/Release/DBUtility.pdb Binary files differ diff --git a/BLL/bin/Release/Pub_Class.dll b/BLL/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 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 52a6297..9a615cd 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 244bf7f..944241b 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 edce0ca..4a1acf9 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 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/BLL/bin/Release/SQLHelper.pdb +++ b/BLL/bin/Release/SQLHelper.pdb Binary files differ diff --git a/BaseSet/bin/Release/DBUtility.dll b/BaseSet/bin/Release/DBUtility.dll index 5b73185..e149e84 100644 --- a/BaseSet/bin/Release/DBUtility.dll +++ b/BaseSet/bin/Release/DBUtility.dll Binary files differ diff --git a/BaseSet/bin/Release/DBUtility.pdb b/BaseSet/bin/Release/DBUtility.pdb index 5868f01..27f69f8 100644 --- a/BaseSet/bin/Release/DBUtility.pdb +++ b/BaseSet/bin/Release/DBUtility.pdb Binary files differ diff --git a/BaseSet/bin/Release/Pub_Class.dll b/BaseSet/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 100644 --- a/BaseSet/bin/Release/Pub_Class.dll +++ b/BaseSet/bin/Release/Pub_Class.dll Binary files differ diff --git a/BaseSet/bin/Release/Pub_Class.pdb b/BaseSet/bin/Release/Pub_Class.pdb index 52a6297..9a615cd 100644 --- a/BaseSet/bin/Release/Pub_Class.pdb +++ b/BaseSet/bin/Release/Pub_Class.pdb Binary files differ diff --git a/BaseSet/bin/Release/Pub_Control.dll b/BaseSet/bin/Release/Pub_Control.dll index 244bf7f..944241b 100644 --- a/BaseSet/bin/Release/Pub_Control.dll +++ b/BaseSet/bin/Release/Pub_Control.dll Binary files differ diff --git a/BaseSet/bin/Release/Pub_Control.pdb b/BaseSet/bin/Release/Pub_Control.pdb index edce0ca..4a1acf9 100644 --- a/BaseSet/bin/Release/Pub_Control.pdb +++ b/BaseSet/bin/Release/Pub_Control.pdb Binary files differ diff --git a/BaseSet/bin/Release/SQLHelper.dll b/BaseSet/bin/Release/SQLHelper.dll index 6fdd03e..a358039 100644 --- a/BaseSet/bin/Release/SQLHelper.dll +++ b/BaseSet/bin/Release/SQLHelper.dll Binary files differ diff --git a/BaseSet/bin/Release/SQLHelper.pdb b/BaseSet/bin/Release/SQLHelper.pdb index 5c090db..04f7af8 100644 --- a/BaseSet/bin/Release/SQLHelper.pdb +++ b/BaseSet/bin/Release/SQLHelper.pdb Binary files differ diff --git a/DAL/bin/Release/DBUtility.dll b/DAL/bin/Release/DBUtility.dll index 5b73185..e149e84 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 5868f01..27f69f8 100644 --- a/DAL/bin/Release/DBUtility.pdb +++ b/DAL/bin/Release/DBUtility.pdb Binary files differ diff --git a/DAL/bin/Release/Pub_Class.dll b/DAL/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 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 52a6297..9a615cd 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 244bf7f..944241b 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 edce0ca..4a1acf9 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 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/DAL/bin/Release/SQLHelper.pdb +++ b/DAL/bin/Release/SQLHelper.pdb Binary files differ diff --git "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs" "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs" index 9b570d3..5e7aa38 100644 --- "a/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs" +++ "b/DAL/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBill.cs" @@ -85,7 +85,7 @@ string subSql = "Insert into Sc_QualityReportBillSub " + " (HInterID,HEntryID,HBillNo_bak,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + - ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + + ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" + ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + ",HBarCode,HReportType,HBadProcID" + ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + @@ -108,6 +108,7 @@ "," + oSub.HEmpID.ToString() + "" + "," + oSub.HSourceID.ToString() + "" + "," + oSub.HBadReasonID.ToString() + "" + + "," + oSub.HBadPhenomenaID.ToString() + "" + "," + oSub.HICMOInterID.ToString() + "" + "," + oSub.HICMOEntryID.ToString() + "" + @@ -220,7 +221,7 @@ string subSql = "Insert into Sc_QualityReportBillSub " + " (HInterID,HEntryID,HBillNo_bak,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + - ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + + ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID,HBadPhenomenaID" + ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + ",HBarCode,HReportType,HBadProcID" + ",HAddr,HMaker,HMakeDate,HProcID,HNowProcID" + @@ -243,7 +244,8 @@ "," + oSub.HEmpID.ToString() + "" + "," + oSub.HSourceID.ToString() + "" + "," + oSub.HBadReasonID.ToString() + "" + - + "," + oSub.HBadPhenomenaID.ToString() + "" + + "," + oSub.HICMOInterID.ToString() + "" + "," + oSub.HICMOEntryID.ToString() + "" + ",'" + oSub.HICMOBillNo + "'" + diff --git "a/DAL/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBill.cs" "b/DAL/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBill.cs" index 7569239..a8fd80e 100644 --- "a/DAL/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBill.cs" +++ "b/DAL/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBill.cs" @@ -73,6 +73,26 @@ " where HInterID=" + lngBillKey.ToString()); //鍒犻櫎鍏宠仈 DeleteRelation(ref sReturn, lngBillKey); + //鍒犻櫎瀛愯〃 + DeleteBillSub(lngBillKey); + //鎻掑叆瀛愯〃 + omodel.HInterID = lngBillKey; + + //鎻掑叆瀛愯〃 + foreach (Model.ClsQC_MonthTarGetBillSub oSub in DetailColl) + { + oCn.RunProc("Insert into QC_MonthTarGetBillSub " + + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + + ",HSupID,HSupQty" + + + ") values(" + + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + + ",'" + oSub.HSupID.ToString() + "','" + oSub.HSupQty.ToString() + + "') "); + } + //=========================淇濆瓨鍚庢帶鍒� //DataSet ds2 = oCn.RunProcReturn("Exec h_p_QC_MonthTarGetBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_QC_MonthTarGetBill_AfterSaveCtrl"); //if (ds2 == null) @@ -153,6 +173,21 @@ ")"; oCn.RunProc(mainSql); + //鎻掑叆瀛愯〃 + foreach (Model.ClsQC_MonthTarGetBillSub oSub in DetailColl) + { + oCn.RunProc("Insert into QC_MonthTarGetBillSub " + + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + + ",HSupID,HSupQty" + + + ") values(" + + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + + ",'" + oSub.HSupID.ToString() + "','" + oSub.HSupQty.ToString() + + "') "); + } + //=========================淇濆瓨鍚庢帶鍒� //DataSet ds2 = oCn.RunProcReturn("Exec h_p_QC_MonthTarGetBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_QC_MonthTarGetBill_AfterSaveCtrl"); //if (ds2 == null) diff --git a/DBUtility/bin/Release/DBUtility.dll b/DBUtility/bin/Release/DBUtility.dll index 5b73185..e149e84 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 5868f01..27f69f8 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 5a27deb..6ac1eea 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 52a6297..9a615cd 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 244bf7f..944241b 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 edce0ca..4a1acf9 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 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/DBUtility/bin/Release/SQLHelper.pdb +++ b/DBUtility/bin/Release/SQLHelper.pdb Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache b/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache index d4f0c96..6f47755 100644 --- a/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache +++ b/DBUtility/obj/Release/DBUtility.csproj.GenerateResource.Cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache index 59940f0..7c8776c 100644 --- a/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache +++ b/DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cache Binary files differ diff --git a/DBUtility/obj/Release/DBUtility.dll b/DBUtility/obj/Release/DBUtility.dll index 5b73185..e149e84 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 5868f01..27f69f8 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 5b73185..e149e84 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 5868f01..27f69f8 100644 --- a/Model/bin/Release/DBUtility.pdb +++ b/Model/bin/Release/DBUtility.pdb Binary files differ diff --git a/Model/bin/Release/Pub_Class.dll b/Model/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 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 52a6297..9a615cd 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 244bf7f..944241b 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 edce0ca..4a1acf9 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 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/Model/bin/Release/SQLHelper.pdb +++ b/Model/bin/Release/SQLHelper.pdb Binary files differ diff --git "a/Model/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_InspectInstruMent_Model.cs" "b/Model/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_InspectInstruMent_Model.cs" index ea44833..86d21e2 100644 --- "a/Model/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_InspectInstruMent_Model.cs" +++ "b/Model/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/ClsGy_InspectInstruMent_Model.cs" @@ -12,5 +12,9 @@ public string HMakeEmp; public DateTime HModifyTime; public int HERPItemID; + public string HExpiryDay; + public string HCalibrationStatus; + public DateTime HValidDate; + public DateTime HCalibrationDate; } } diff --git "a/Model/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBillSub.cs" "b/Model/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBillSub.cs" index 89c3905..74e9d1c 100644 --- "a/Model/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBillSub.cs" +++ "b/Model/\347\224\237\344\272\247\347\256\241\347\220\206/ClsSc_QualityReportBillSub.cs" @@ -30,5 +30,6 @@ public int HGroupID;//班组 public int HBadProcID;//班组 public int HNowProcID;//当前工序 + public int HBadPhenomenaID;//不良现象 } } diff --git "a/Model/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBillSub.cs" "b/Model/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBillSub.cs" index 1d8624c..f3126de 100644 --- "a/Model/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBillSub.cs" +++ "b/Model/\350\264\250\346\243\200\347\256\241\347\220\206/ClsQC_MonthTarGetBillSub.cs" @@ -6,7 +6,9 @@ { public class ClsQC_MonthTarGetBillSub : DBUtility.ClsXt_BaseBillSub { - + public int HSupID; //int --供应商(Gy_Supplier) + + public double HSupQty; //money --送货数量 } } diff --git a/PlanM/bin/Release/DBUtility.dll b/PlanM/bin/Release/DBUtility.dll index 5b73185..e149e84 100644 --- a/PlanM/bin/Release/DBUtility.dll +++ b/PlanM/bin/Release/DBUtility.dll Binary files differ diff --git a/PlanM/bin/Release/DBUtility.pdb b/PlanM/bin/Release/DBUtility.pdb index 5868f01..27f69f8 100644 --- a/PlanM/bin/Release/DBUtility.pdb +++ b/PlanM/bin/Release/DBUtility.pdb Binary files differ diff --git a/PlanM/bin/Release/Pub_Class.dll b/PlanM/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 100644 --- a/PlanM/bin/Release/Pub_Class.dll +++ b/PlanM/bin/Release/Pub_Class.dll Binary files differ diff --git a/PlanM/bin/Release/Pub_Class.pdb b/PlanM/bin/Release/Pub_Class.pdb index 52a6297..9a615cd 100644 --- a/PlanM/bin/Release/Pub_Class.pdb +++ b/PlanM/bin/Release/Pub_Class.pdb Binary files differ diff --git a/PlanM/bin/Release/Pub_Control.dll b/PlanM/bin/Release/Pub_Control.dll index 244bf7f..944241b 100644 --- a/PlanM/bin/Release/Pub_Control.dll +++ b/PlanM/bin/Release/Pub_Control.dll Binary files differ diff --git a/PlanM/bin/Release/Pub_Control.pdb b/PlanM/bin/Release/Pub_Control.pdb index edce0ca..4a1acf9 100644 --- a/PlanM/bin/Release/Pub_Control.pdb +++ b/PlanM/bin/Release/Pub_Control.pdb Binary files differ diff --git a/PlanM/bin/Release/SQLHelper.dll b/PlanM/bin/Release/SQLHelper.dll index 6fdd03e..a358039 100644 --- a/PlanM/bin/Release/SQLHelper.dll +++ b/PlanM/bin/Release/SQLHelper.dll Binary files differ diff --git a/PlanM/bin/Release/SQLHelper.pdb b/PlanM/bin/Release/SQLHelper.pdb index 5c090db..04f7af8 100644 --- a/PlanM/bin/Release/SQLHelper.pdb +++ b/PlanM/bin/Release/SQLHelper.pdb Binary files differ diff --git a/Pub_Class/bin/Release/Pub_Class.dll b/Pub_Class/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 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 52a6297..9a615cd 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 5a27deb..6ac1eea 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 52a6297..9a615cd 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 244bf7f..944241b 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 edce0ca..4a1acf9 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 5a27deb..6ac1eea 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 52a6297..9a615cd 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 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/SQLHelper/bin/Release/SQLHelper.pdb +++ b/SQLHelper/bin/Release/SQLHelper.pdb Binary files differ diff --git a/SQLHelper/obj/Release/SQLHelper.dll b/SQLHelper/obj/Release/SQLHelper.dll index 6fdd03e..a358039 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 5c090db..04f7af8 100644 --- a/SQLHelper/obj/Release/SQLHelper.pdb +++ b/SQLHelper/obj/Release/SQLHelper.pdb Binary files differ diff --git a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache new file mode 100644 index 0000000..b04aad7 --- /dev/null +++ b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache Binary files differ diff --git a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt index 5e4a382..6f879bd 100644 --- a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt +++ b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt @@ -8,3 +8,22 @@ C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb +<<<<<<< HEAD +C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache +======= +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb +<<<<<<< HEAD +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll +E:\鏅轰簯mes\mes\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb +======= +>>>>>>> 124dd32a34ced09ae87935e953dec6401d86f9ac +>>>>>>> 7d2677241200a3a1fd110e5d37864571c6d87f67 diff --git a/WarM/bin/Release/DBUtility.dll b/WarM/bin/Release/DBUtility.dll index 5b73185..e149e84 100644 --- a/WarM/bin/Release/DBUtility.dll +++ b/WarM/bin/Release/DBUtility.dll Binary files differ diff --git a/WarM/bin/Release/DBUtility.pdb b/WarM/bin/Release/DBUtility.pdb index 5868f01..27f69f8 100644 --- a/WarM/bin/Release/DBUtility.pdb +++ b/WarM/bin/Release/DBUtility.pdb Binary files differ diff --git a/WarM/bin/Release/Pub_Class.dll b/WarM/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 100644 --- a/WarM/bin/Release/Pub_Class.dll +++ b/WarM/bin/Release/Pub_Class.dll Binary files differ diff --git a/WarM/bin/Release/Pub_Class.pdb b/WarM/bin/Release/Pub_Class.pdb index 52a6297..9a615cd 100644 --- a/WarM/bin/Release/Pub_Class.pdb +++ b/WarM/bin/Release/Pub_Class.pdb Binary files differ diff --git a/WarM/bin/Release/Pub_Control.dll b/WarM/bin/Release/Pub_Control.dll index 244bf7f..944241b 100644 --- a/WarM/bin/Release/Pub_Control.dll +++ b/WarM/bin/Release/Pub_Control.dll Binary files differ diff --git a/WarM/bin/Release/Pub_Control.pdb b/WarM/bin/Release/Pub_Control.pdb index edce0ca..4a1acf9 100644 --- a/WarM/bin/Release/Pub_Control.pdb +++ b/WarM/bin/Release/Pub_Control.pdb Binary files differ diff --git a/WarM/bin/Release/SQLHelper.dll b/WarM/bin/Release/SQLHelper.dll index 6fdd03e..a358039 100644 --- a/WarM/bin/Release/SQLHelper.dll +++ b/WarM/bin/Release/SQLHelper.dll Binary files differ diff --git a/WarM/bin/Release/SQLHelper.pdb b/WarM/bin/Release/SQLHelper.pdb index 5c090db..04f7af8 100644 --- a/WarM/bin/Release/SQLHelper.pdb +++ b/WarM/bin/Release/SQLHelper.pdb Binary files differ diff --git a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs index ffd6a2f..10ac24a 100644 --- a/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_BadReasonController.cs @@ -46,12 +46,12 @@ if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " order by 涓嶈壇鍘熷洜浠g爜 ", "h_v_IF_BadReasonList"); + ds = oCN.RunProcReturn("select * from h_v_IF_BadReasonList " + sWhere+ " ", "h_v_IF_BadReasonList"); } else { string sql1 = "select * from h_v_IF_BadReasonList where 1 = 1"; - string sql = sql1 + sWhere+ " order by 涓嶈壇鍘熷洜浠g爜 "; + string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_BadReasonList"); } diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs index 2dfbf7c..e615122 100644 --- a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs @@ -38,7 +38,7 @@ { List<object> columnNameList = new List<object>(); //缂栬緫鏉冮檺 - if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee", 1, false, user)) + if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; diff --git a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs index 6763499..c298d0f 100644 --- a/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_MaterialController.cs @@ -134,12 +134,14 @@ objJsonResult.data = null; return objJsonResult; } + if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("exec h_p_Gy_MaterialList " + page + "," + size + ",'" + Organization +"'," + "''", "h_p_Gy_MaterialList"); } else { + sWhere = sWhere.Replace("'", "''"); ds = oCN.RunProcReturn("exec h_p_Gy_MaterialList " + page + "," + size + ",'" + Organization + "','" + sWhere + "'", "h_p_Gy_MaterialList"); } diff --git a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs index af67770..2bed7c3 100644 --- a/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_SupplierController.cs @@ -254,19 +254,8 @@ { try { - string sql = string.Format(@"select s.HItemID,s.HUSEORGID,o.Hname 浣跨敤缁勭粐,s.HCREATEORGID ,d.Hname 鍒涘缓缁勭粐,s.HNumber 缂栫爜,s.HName 鍚嶇О,s.HHelpCode 鍔╄鐮�,s.HShortName 绠�绉�,s.HAddress 鍦板潃,s.HLinkMan 鑱旂郴浜�,s.HLinkPhone 鑱旂郴鐢佃瘽 - ,s.HMobilePhone 鎵嬫満,s.HFax 浼犵湡,s.HPostalCode 閭紪,s.HEmail 鐢靛瓙閭欢,s.HCorMan 娉曚汉浠h〃,s.HBank 寮�鎴烽摱琛�,s.HBankAccount 閾惰璐﹀彿,s.HPSStyleID 閲囪喘鏂瑰紡ID,f.HName 閲囪喘鏂瑰紡鍚嶇О, - s.HTaxNum 绋庡姟鐧昏鍙�,s.HEnglishName 鑻辨枃鍚嶇О,s.HEngLishAddress 鑻辨枃鍦板潃,s.HCountry 鍥藉,s.HStopflag 绂佺敤鏍囧織 - ,s.HRemark 澶囨敞,s.HAreaID 鍦板尯ID,a.HName 鍦板尯鍚嶇О,s.HTaxRate 澧炲�肩◣鐜�,s.HCurID 榛樿璐у竵ID,r.HName 榛樿璐у竵, - s.HSSID 缁撶畻鏂瑰紡ID,e.HName 缁撶畻鏂瑰紡,s.HMaterClass 渚涜揣鏉愭枡绫诲埆 from Gy_Supplier s - left join Gy_AreaSet a on s.HAreaID=a.HItemID - left join Gy_Currency r on s.HCurID=r.HItemID - left join Gy_SettleStyle e on s.HSSID=e.HItemID - left join Xt_ORGANIZATIONS o on s.HUSEORGID=o.HItemID - left join Xt_ORGANIZATIONS d on s.HCREATEORGID=d.HItemID - left join Gy_PoStockStyle f on s.HPSStyleID=f.HItemID - where s.HItemID='" + HInterID + "'"); - ds = oCN.RunProcReturn(sql, "Gy_Supplier"); + string sql = string.Format(@"select * from h_v_Gy_SupplierEdit where HItemID='" + HInterID + "'"); + ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierEdit"); DataSet cs = oCN.RunProcReturn("select * from Gy_Supplier_PayPlan where HSupID = '"+ HInterID + "'", "Gy_Supplier_PayPlan"); List<Object> list = new List<object>(); list.Add(cs); @@ -348,6 +337,7 @@ string HRemark = list[0].HRemark; string HMaterClass = list[0].HMaterClass; long HPSStyleID = list[0].HPSStyleID; + long HSupTypeID = list[0].HSupTypeID; if (!DBUtility.ClsPub.AllowNumber(HNumber)) { @@ -366,13 +356,13 @@ ",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" + ",HFax,HPostalCode,HEmail,HBank,HBankAccount" + ",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" + - ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HUSEORGID,HCREATEORGID,HPSStyleID) " + + ",HEnglishAddress,HCurID,HSSID,HAreaID,HMaterClass,HUSEORGID,HCREATEORGID,HPSStyleID,HSupTypeID) " + " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID + "'" + "," + HLevel + ",1,'" + HStopflag + "','" + HRemark + "'" + ",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" + ",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" + ",'" + HTaxNum + "','" + HTaxRate + "','" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" + - ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + " ','" + HUseOrgID + "' ,'" + HCreateOrgID + "' ,'" + HPSStyleID + + ",'" + HEnglishAddress + "'," + HCurID + "," + HSSID + "," + HAreaID +" ,'" + HMaterClass + " ','" + HUseOrgID + "' ,'" + HCreateOrgID + "' ,'" + HPSStyleID+ "' ,'" + HSupTypeID + "') "); //淇敼涓婄骇涓洪潪鏈骇浠g爜 oCN.RunProc("Update Gy_Supplier set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); @@ -528,6 +518,7 @@ string HRemark = list[0].HRemark; string HMaterClass = list[0].HMaterClass; long HPSStyleID = list[0].HPSStyleID; + long HSupTypeID = list[0].HSupTypeID; //鍒ゆ柇鏉冮檺 if (!ClsPub.Security_Log(msg6, 1, false, msg5)) @@ -581,6 +572,7 @@ ",HSSID=" + HSSID.ToString() + ",HMaterClass='" + HMaterClass + "',HPSStyleID='"+ HPSStyleID.ToString() + + "',HSupTypeID='" + HSupTypeID.ToString() + "',HUSEORGID='" + HUseOrgID.ToString() + "',HCREATEORGID='" + HCreateOrgID.ToString() + "',HAreaID=" + HAreaID.ToString() + "Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); diff --git a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs index 2b266d2..ff6da6c 100644 --- a/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_WorkCenterController.cs @@ -405,7 +405,7 @@ { List<object> columnNameList = new List<object>(); //鏌ョ湅鏉冮檺 - if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter", 1, false, user)) + if (!DBUtility.ClsPub.Security_Log("Gy_WorkCenter_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; diff --git a/WebAPI/Controllers/CJGL/Cj_SingleStationController.cs b/WebAPI/Controllers/CJGL/Cj_SingleStationController.cs index eddce9c..e8ee20f 100644 --- a/WebAPI/Controllers/CJGL/Cj_SingleStationController.cs +++ b/WebAPI/Controllers/CJGL/Cj_SingleStationController.cs @@ -330,7 +330,7 @@ } //鍒ゆ柇褰撳墠娴佽浆鍗℃槸鍚︽槸寮�宸� - ds = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBarCode + "' and HICMOStatus='1'", "Sc_ICMOBillStatus_Tmp"); + ds = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBarCode + "' and HICMOStatus<>'0'", "Sc_ICMOBillStatus_Tmp"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index 25f15f5..ceb4d6b 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -1871,7 +1871,10 @@ case "Emp": sql = "select * from h_v_Sc_StationOutBillSubQuery_Emp where 1 = 1 and HInterID=" + sWhere; break; - + case "Sup": + sql = "select * from h_v_Sc_StationOutBillSubQuery_Sup where 1 = 1 and HInterID=" + sWhere; + break; + } ds = oCN.RunProcReturn(sql, TableName); @@ -4066,5 +4069,123 @@ } } #endregion + + #region 鍑虹珯鍗曞垪琛�-涓嬫帹PPM鏁版嵁褰曞叆淇濆瓨,鍒犻櫎 + + [Route("Cj_StationOutBill/PPMSupAddBill")] + [HttpPost] + public object PPMSupAddBill([FromBody] JObject sSubStr) + { + var _value = sSubStr["sSubStr"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + try + { + //鍙嶅簭鍒楀寲 + string msg2 = sArray[0].ToString(); //琛ㄤ綋 + string refSav = sArray[1].ToString();//鎿嶄綔绫诲瀷 + string user = sArray[2].ToString(); //鐢ㄦ埛 + msg2 = msg2.Substring(1, msg2.Length - 2); + msg2 = msg2.Replace("\\", ""); + msg2 = msg2.Replace("\n", ""); + msg2 = "[" + msg2 + "]"; + //鍒ゆ柇鏄惁鏈夌紪杈戞潈闄� + if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犵紪杈戞潈闄�!"; + objJsonResult.data = null; + return objJsonResult; + } + + + List<Sc_StationOutBillSub_Sup> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_StationOutBillSub_Sup>>(msg2); + + oCN.BeginTran(); + for (int i = 0; i < list.Count; i++) + { + int HInterID = list[i].HInterID; + int HEntryID = i+1; + int HSupID = list[i].HSupID; + double HWasterQty_Mater = list[i].HWasterQty_Mater; + double HBackWorkQty = list[i].HBackWorkQty; + + oCN.RunProc("Insert Into Sc_StationOutBillSub_Sup " + + "(HInterID, HEntryID, HSupID, HWasterQty_Mater, HBackWorkQty) " + + "values ('" + HInterID + "', '" + HEntryID + "', '" + HSupID + "', '" + HWasterQty_Mater + "', '" + HBackWorkQty + "')"); + + } + + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鏂板鍗曟嵁鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + [Route("Cj_StationOutBill/PPMSupDelete")] + [HttpGet] + public object PPMSupDelete(int HInterID,string user) + { + try + { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄�!"; + objJsonResult.data = null; + return objJsonResult; + } + + ds = oCN.RunProcReturn("select * from Sc_StationOutBillSub_Sup WITH(NOLOCK) where HInterID = " + HInterID, "Sc_StationOutBillSub_Sup"); + + if (ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ユ棤鏁版嵁锛�"; + objJsonResult.data = null; + } + + oCN.BeginTran(); + + string sql = ""; + + sql = "delete from Sc_StationOutBillSub_Sup where HInterID = " + HInterID; + oCN.RunProc(sql); + + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file diff --git a/WebAPI/Controllers/CJGL/Sc_OEEReportController.cs b/WebAPI/Controllers/CJGL/Sc_OEEReportController.cs index e648bcb..9bcb6b8 100644 --- a/WebAPI/Controllers/CJGL/Sc_OEEReportController.cs +++ b/WebAPI/Controllers/CJGL/Sc_OEEReportController.cs @@ -75,5 +75,107 @@ } } #endregion + + #region OEE鎶ヨ〃 鏌ヨ鏄庣粏 + /// <summary> + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Sc_OEEReport/getSc_OEEReportDetailist")] + [HttpGet] + public object getSc_OEEReportDetailist(string HSourceCode, string HDate, string HType, string user) + { + try + { + List<object> columnNameList = new List<object>(); + ////鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Sc_OEEReport", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + string sql = "exec h_p_SB_getLatestDataOfOEEDataDetailist '" + HSourceCode + "','" + HDate + "','" + HType + "'"; + ds = oCN.RunProcReturn(sql, "h_p_SB_getLatestDataOfOEEDataDetailist"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region OEE鎶ヨ〃 鏌ヨ(鐝) + /// <summary> + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Sc_OEEReport/getSc_OEEReport_WorkShift")] + [HttpGet] + public object getSc_OEEReport_WorkShift(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + ////鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Sc_OEEReport", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + string sql = "exec h_p_Sc_OEEReport_WorkShift " + sWhere; + ds = oCN.RunProcReturn(sql, "h_p_Sc_OEEReport_WorkShift"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 68339de..5fca15a 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs @@ -962,6 +962,22 @@ DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { if (oBill.omodel.HBillStatus == 2) @@ -985,7 +1001,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -1017,6 +1033,150 @@ } #endregion + #region 鍣ㄥ叿閲囪喘鍏ュ簱鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldProdInBill/CloseSc_MouldProdInBill")] + [HttpGet] + public object CloseSc_MouldProdInBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldProdInBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldProdInBill oBill = new DAL.ClsSc_MouldProdInBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs index 4c57f43..b071139 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs @@ -683,9 +683,25 @@ objJsonResult.data = null; return objJsonResult; } - DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); + DLL.ClsSc_MouldProdMoveBill oBill = new DLL.ClsSc_MouldProdMoveBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { if (oBill.omodel.HBillStatus == 2) @@ -709,7 +725,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -741,7 +757,152 @@ } #endregion + #region 鍣ㄥ叿棰嗙敤鍑哄簱鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldProdMoveBill/CloseSc_MouldProdMoveBill")] + [HttpGet] + public object CloseSc_MouldProdMoveBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldProdMoveBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldProdMoveBill oBill = new DAL.ClsSc_MouldProdMoveBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #endregion } } - #endregion + #endregion \ No newline at end of file diff --git a/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs index 82d5bda..94f5845 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldScrapInBillController.cs @@ -346,6 +346,22 @@ DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { if (oBill.omodel.HBillStatus == 2) @@ -369,7 +385,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -520,6 +536,151 @@ } #endregion + #region 鍣ㄥ叿鎶ュ簾鍏ュ簱鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldScrapInBill/CloseSc_MouldScrapInBill")] + [HttpGet] + public object CloseSc_MouldScrapOutHouseBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldScrapInBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldScrapInBill oBill = new DAL.ClsSc_MouldScrapInBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + } } \ No newline at end of file diff --git a/WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs index 97be4fa..999c60d 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs @@ -9,6 +9,7 @@ using Newtonsoft.Json; using Model; using DBUtility; +using SyntacticSugar.constant; namespace WebAPI.Controllers.MJGL { @@ -61,6 +62,55 @@ objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 涓婃ā鍗� 鍒楄〃鍒嗛〉鏌ヨ + [Route("Sc_MouldUpperBill/Sc_MouldUpperBillListPage")] + [HttpGet] + public object Sc_MouldUpperBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Sc_MouldUpperBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldUpperBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldUpperBillList"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } @@ -857,6 +907,55 @@ } #endregion + #region 涓嬫ā鍗� 鍒楄〃鍒嗛〉鏌ヨ + [Route("Sc_MouldUpperBill/Sc_MouldLowerBillListPage")] + [HttpGet] + public object Sc_MouldLowerBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Sc_MouldLowerBill_Query", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldLowerBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldLowerBillList"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 涓嬫ā鍗� 淇濆瓨鍓嶃�佷繚瀛樺悗鎺у埗 //淇濆瓨鍓嶆帶鍒� diff --git a/WebAPI/Controllers/ReportPlatFormController.cs b/WebAPI/Controllers/ReportPlatFormController.cs index 34de546..badc91b 100644 --- a/WebAPI/Controllers/ReportPlatFormController.cs +++ b/WebAPI/Controllers/ReportPlatFormController.cs @@ -1,4 +1,5 @@ -锘縰sing Newtonsoft.Json.Linq; +锘縰sing Newtonsoft.Json; +using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; @@ -279,5 +280,159 @@ return objJsonResult; } #endregion + + #region 鎶ュ伐骞冲彴鎸夐挳鏌ヨ + [Route("ReportPlatForm/getButtonlist")] + [HttpGet] + public object getButtonlist(string user) + { + try + { + List<object> columnNameList = new List<object>(); + + ds = oCN.RunProcReturn("select * from h_v_Gy_UserButton where 鐢ㄦ埛鍚嶇О='" + user+ "' order by 鎸夐挳鎺掑簭", "h_v_Gy_UserButton"); + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鎶ュ伐骞冲彴鎸夐挳娣诲姞 + [Route("ReportPlatForm/AddButtonlist")] + [HttpGet] + public object AddButtonlist(string HUserName,string HButtonID, string HButtonName, string HButtonSize, string HButtonOrder) + { + try + { + + ds = oCN.RunProcReturn("select * from Gy_UserButtons where HButtonID='" + HButtonID + "' and HUserName='" + HUserName + "'", "Gy_UserButtons"); + + if (ds.Tables[0].Rows.Count > 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "褰撳墠浜哄憳宸插垱寤烘敼鎸夐挳,涓嶅厑璁搁噸澶嶅垱寤猴紒"; + objJsonResult.data = null; + + } + else + { + oCN.BeginTran(); + //鍐欏叆鎸夐挳缁戝畾 + oCN.RunProc("insert into Gy_UserButtons(HUserName,HButtonID,HButtonName,HButtonSize,HButtonOrder)values('" + HUserName+"','"+HButtonID+ "','" + HButtonName + "','" + HButtonSize + "','" + HButtonOrder + "')"); + oCN.Commit(); + + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; + objJsonResult.data = null; + } + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion + + #region 鎶ュ伐骞冲彴鎸夐挳鍒犻櫎 + [Route("ReportPlatForm/DeleteButtonlist")] + [HttpGet] + public object DeleteButtonlist(int HItemID) + { + try + { + oCN.BeginTran(); + oCN.RunProc("delete from Gy_UserButtons where HItemID ='" + HItemID + "'"); + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎鎸夐挳鎴愬姛锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = e.Message.ToString(); + objJsonResult.data = null; + + } + return objJsonResult; + } + #endregion + + #region 鎶ュ伐骞冲彴鎸夐挳鍩虹璧勬枡鏌ヨ + [Route("ReportPlatForm/GetGy_BGButtons")] + [HttpGet] + public object GetGy_BGButtons(string sWhere) + { + try + { + List<object> columnNameList = new List<object>(); + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("select HItemID 鎸夐挳id,HNumber 鎸夐挳浠g爜,HName 鎸夐挳鍚嶇О from Gy_BGButtons", "Gy_BGButtons"); + } + else + { + string sql1 = "select HItemID 鎸夐挳id,HNumber 鎸夐挳浠g爜,HName 鎸夐挳鍚嶇О from Gy_BGButtons where 1 = 1 "; + string sql = sql1 + sWhere; + ds = oCN.RunProcReturn(sql, "Gy_BGButtons"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" index ab2a68d..6277fa9 100644 --- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" +++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_CompleteController..cs" @@ -180,10 +180,13 @@ { public int? HORGID;//缁勭粐 public int? HMATERIALID;//鐗╂枡 - public int? HDeptID;//鐢熶骇杞﹂棿 + public string HDeptID;//鐢熶骇杞﹂棿 public int? HSCZYID;//鐢熶骇璧勬簮 public string HXQD;//闇�姹傚崟鍙� public string HMOBILLNO;//鐢熶骇璁㈠崟鍙� + public string HBeginDate; //鎺掍骇璁″垝鏃ユ湡锛堝紑濮嬫椂闂达級 + public string HEndDate; //鎺掍骇璁″垝鏃ユ湡锛堢粨鏉熸椂闂达級 + public string HMaterAtt; //鐗╂枡灞炴�� } /// <summary> /// @@ -198,7 +201,7 @@ ReportMOMaterReadysBill Report = JsonConvert.DeserializeObject<ReportMOMaterReadysBill>(sWhere); - ds = oCN.RunProcReturn($"exec PR_Complete_Report '{Report.HXQD}','{Report.HMOBILLNO}',{Report.HORGID},{Report.HDeptID},{Report.HSCZYID},{Report.HMATERIALID}", "PR_Complete_Report"); + ds = oCN.RunProcReturn($"exec PR_Complete_Report '{Report.HXQD}','{Report.HMOBILLNO}',{Report.HORGID},'{Report.HDeptID}',{Report.HSCZYID},{Report.HMATERIALID},'{Report.HBeginDate}','{Report.HEndDate}','{Report.HMaterAtt}'", "PR_Complete_Report"); objJsonResult.code = "1"; objJsonResult.count = 1; diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" index c416d59..d4efe32 100644 --- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" +++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" @@ -804,6 +804,19 @@ //LogService.Write("榻愬鍒嗘瀽sql:" + sql); List<PRD_PPBOM> BomList = new List<PRD_PPBOM>(); DataTable resulTable = ds.Tables[0]; + + if (ds.Tables[0].Rows.Count < 1 || ds == null) + { + //閲婃斁榻愬鎿嶄綔 閬垮厤澶氫汉鍚屾椂杩涜榻愬鍒嗘瀽 + oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 "); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "娌℃湁闇�瑕佽繘琛岄綈濂楀垎鏋愮殑鏁版嵁"; + objJsonResult.data = null; + return objJsonResult; + } + if (resulTable.Rows[0][0].ToString().Contains("澶辫触")) { //閲婃斁榻愬鎿嶄綔 閬垮厤澶氫汉鍚屾椂杩涜榻愬鍒嗘瀽 diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs index 1b5a2a6..2aa8188 100644 --- a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs @@ -243,6 +243,63 @@ } } + /// <summary> + /// 妯″叿淇濆吇璁板綍琛ㄥ垎椤靛垪琛� + /// </summary> + /// <returns></returns> + [Route("Sc_MouldMaintainBill/GetMouldMaintainBillListPage")] + [HttpGet] + public object GetMouldMaintainBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + + if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldMaintainList " + page + "," + size + ",''", "h_p_Sc_MouldMaintainList"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldMaintainList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldMaintainList"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #region sql璇彞 @@ -355,6 +412,63 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + + /// <summary> + /// 妯″叿鐐规璁板綍琛ㄥ垎椤靛垪琛� + /// </summary> + /// <returns></returns> + [Route("Sc_MouldDotCheckBill/GetMouldDotCheckBillListPage")] + [HttpGet] + public object GetMouldDotCheckBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldDotCheckBillList " + page + "," + size + ",''", "h_p_Sc_MouldDotCheckBillList"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldDotCheckBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldDotCheckBillList"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); objJsonResult.data = null; return objJsonResult; @@ -535,6 +649,63 @@ } } + /// <summary> + /// 妯″叿鏁呴殰鐧昏琛ㄥ垎椤靛垪琛� + /// </summary> + /// <returns></returns> + [Route("Sc_MouldConkBookBill/GetMouldConkBookBillListPage")] + [HttpGet] + public object GetMouldConkBookBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + if (!DBUtility.ClsPub.Security_Log("Sc_MouldConkBookBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldConkBookBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldConkBookBillList"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldConkBookBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldConkBookBillList"); + } + + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #region 鍣ㄥ叿鏁呴殰璁板綍缁熻鍒嗘瀽 /// <summary> /// 鍣ㄥ叿缁翠慨璁板綍缁熻鍒嗘瀽 鍒楄〃 @@ -685,6 +856,62 @@ objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + + /// <summary> + /// 妯″叿缁翠慨楠屾敹鍗曞垎椤靛垪琛� + /// </summary> + /// <returns></returns> + [Route("Sc_MouldRepairCheckBill/GetMouldRepairCheckBillListPage")] + [HttpGet] + public object GetMouldRepairCheckBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairCheckBillList " + page + "," + size + ",''", "h_p_Sc_MouldRepairCheckBillList"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairCheckBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldRepairCheckBillList"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.list = columnNameList; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "Exception锛�" + e.ToString(); objJsonResult.data = null; return objJsonResult; } @@ -4607,7 +4834,7 @@ objJsonResult.data = null; return objJsonResult; } - } + } public static DataSet Sc_MouldRepairWorkBillList_s(string sWhere) { @@ -4622,6 +4849,62 @@ return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldRepairWorkBillList"); } } + #endregion + + #region 妯″叿缁翠慨璁板綍琛ㄥ垎椤靛垪琛� + [Route("Sb_MouldRepairWorkBill/GetMouldRepairWorkBillListPage")] + [HttpGet] + public object GetMouldRepairWorkBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + if (!DBUtility.ClsPub.Security_Log("Sb_MouldRepairWorkBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairWorkBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldRepairWorkBillList"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairWorkBillList " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldRepairWorkBillList"); + } + + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion #region 妯″叿缁翠慨璁板綍琛ㄥ垪琛� @@ -8556,6 +8839,22 @@ DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { if (oBill.omodel.HBillStatus == 2) @@ -8579,7 +8878,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -8610,6 +8909,152 @@ } } #endregion + + #region 鍣ㄥ叿澶勭悊鍑哄簱鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldScrapOutHouseBill/CloseSc_MouldScrapOutHouseBill")] + [HttpGet] + public object CloseSc_MouldScrapOutHouseBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldScrapOutBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldProdOutBill oBill = new DAL.ClsSc_MouldProdOutBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #endregion @@ -9225,6 +9670,22 @@ DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { if (oBill.omodel.HBillStatus == 2) @@ -9248,7 +9709,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -9279,6 +9740,153 @@ } } #endregion + + #region 鍣ㄥ叿棰嗙敤閫�搴撳崟 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldProdBackBill/CloseSc_MouldProdBackBill")] + [HttpGet] + public object CloseSc_MouldProdBackBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldProdBackBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldProdBackBill oBill = new DAL.ClsSc_MouldProdBackBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #endregion #region 妯″叿棰嗙敤鍗� @@ -9923,8 +10531,32 @@ DLL.ClsSc_MouldProdOutBill oBill = new DLL.ClsSc_MouldProdOutBill(); if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (flag == 1) { + if (oBill.omodel.HChecker.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } if (oBill.omodel.HBillStatus == 2) { objJsonResult.code = "0"; @@ -9946,7 +10578,7 @@ } else { - if (oBill.omodel.HBillStatus == 1) + if (oBill.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -9977,6 +10609,153 @@ } } #endregion + + #region 鍣ㄥ叿棰嗙敤鍑哄簱鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Sc_MouldProdOutBill/CloseSc_MouldProdOutBill")] + [HttpGet] + public object CloseSc_MouldProdOutBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Sc_MouldProdOutBill_Close"; + DBUtility.ClsPub.CurUserName = CurUserName; + try + { + //妫�鏌ユ潈闄� + if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触锛佹棤鏉冮檺锛�"; + objJsonResult.data = null; + return objJsonResult; + } + //HInterID鏁版嵁鍒ゆ柇 + if (HInterID <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID灏忎簬0锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); //瀵笻InterID杩涜绫诲瀷鐨勮浆鎹� + DAL.ClsSc_MouldProdOutBill oBill = new DAL.ClsSc_MouldProdOutBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶈兘杩涜鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //鍏抽棴鍒ゆ柇 + { + if (oBill.omodel.HCloseMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插叧闂�!涓嶈兘鍐嶆鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂垽鏂� + { + if (oBill.omodel.HCloseMan.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈叧闂�!涓嶉渶瑕佸弽鍏抽棴锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓嶅瓨鍦�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + + + //杩涜闇�瑕佽繘琛岀殑鍏抽棴/鍙嶅叧闂搷浣� + if (IsAudit == 0) //鍏抽棴鎻愪氦 + { + //鍏抽棴鎻愪氦 + if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍏抽棴鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅叧闂彁浜� + { + //鍙嶅叧闂彁浜� + if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅叧闂垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅叧闂け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍏抽棴澶辫触鎴栬�呭弽鍏抽棴澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #endregion #region 妯″叿瀵垮懡璋冩暣鍗� diff --git a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs index 90d4350..572840a 100644 --- a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs @@ -8,6 +8,8 @@ using WebAPI.Models; using WebAPI.DLL; using DBUtility; +using SyntacticSugar.constant; +using Newtonsoft.Json; namespace WebAPI.Controllers { @@ -76,6 +78,61 @@ } #endregion + #region 鍣ㄥ叿缁翠慨娲惧伐鍗曟煡璇� + [Route("Sc_MouldRepairSendWorkBill/GetMouldRepairSendWorkBillListPage")] + [HttpGet] + public object GetMouldRepairSendWorkBillListPage(string sWhere, string user, int page, int size) + { + try + { + List<object> columnNameList = new List<object>(); + if (!DBUtility.ClsPub.Security_Log("Sc_MouldRepairSendWorkBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairSendWorkBill " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldRepairSendWorkBill"); + } + else + { + sWhere = sWhere.Replace("'", "''"); + ds = oCN.RunProcReturn("exec h_p_Sc_MouldRepairSendWorkBill " + page + "," + size + ",'" + sWhere + "'", "h_p_Sc_MouldRepairSendWorkBill"); + } + + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + + objJsonResult.code = CodeConstant.SUCCEED; + objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception ex) + { + objJsonResult.code = CodeConstant.FAIL; + objJsonResult.count = CountConstant.FAIL; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #region 鍣ㄥ叿缁翠慨娲惧伐鍗� 娣诲姞/淇敼 [Route("Sc_MouldRepairSendWorkBill/AddBill")] [HttpPost] diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 19c0d36..c49d34c 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -388,6 +388,51 @@ } } /// <summary> + /// 鐧诲綍鏍规嵁ic鍗¤幏鍙栦俊鎭� + /// </summary> + /// <param name="HBarCode"></param> + /// <returns></returns> + [Route("Web/GetUserByICCard")] + [HttpGet] + public object GetUserByICCard(string HBarCode) + { + try + { + DataSet ds = null; + ClsCN oCnLoc = new ClsCN(); + DAL.ClsUser oUser = new DAL.ClsUser(); + string sql = string.Format(@" select a.* from h_v_Gy_Czygl_Login a + where a.HICNumber = '{0}'", HBarCode); + ds = oCnLoc.RunProcReturn(sql, "h_v_Gy_Czygl_Login"); + + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鏃犳ic鍗″搴斿憳宸ヤ俊鎭紒"; + objjson.data = null; + return objjson; + } + + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "淇℃伅鑾峰彇鎴愬姛锛�"; + objjson.data = ds.Tables[0]; + return objjson; + + } + catch (Exception e) + { + + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鐧诲綍寮傚父锛�" + e.Message; + objjson.data = null; + return objjson; ; + } + } + + /// <summary> /// 鑿滃崟鏍� /// </summary> /// <returns></returns> diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" index 35b30b8..f0eb048 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" @@ -1755,7 +1755,7 @@ /// PPM缁╂晥瓒嬪娍鍥炬姤琛� /// </summary> /// <returns></returns> - [Route("QC_QualityReportsController/GetQC_PPMReport_Json")] + [Route("QC_CustomerAppealReport/GetQC_PPMReport_Json")] [HttpGet] public object GetQC_PPMReport_Json(string sWhere) { @@ -1764,12 +1764,14 @@ Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); string HYear = dic["HYear"].ToString();//骞� - string HDeptID = dic["HDeptID"].ToString();//閮ㄩ棬 + string HMonth = dic["HMonth"].ToString();//鏈� + string HSupID = dic["HSupID"].ToString();//渚涘簲鍟� + string HDivisionName = dic["HDivisionName"].ToString();//浜嬩笟閮� string HProject = dic["HProject"].ToString();//椤圭洰鍙� string HBatchWork = dic["HBatchWork"].ToString();//鏄惁閲忎骇 - string HDivisionName = dic["HDivisionName"].ToString();//浜嬩笟閮� + string HDeptID = dic["HDeptID"].ToString();//閮ㄩ棬 - ds = oCN.RunProcReturn("exec h_p_QC_PPMReport '" + HYear.ToString() + "'," + HDeptID.ToString() + ",'" + HProject + "','" + HBatchWork + "','" + HDivisionName + "'", "h_p_QC_PPMReport"); + ds = oCN.RunProcReturn("exec h_p_QC_PPMReport '" + HYear + "','" + HMonth + "','" + HDivisionName + "','" + HProject + "','" + HBatchWork + "','" + HDeptID + "','" + HSupID + "'", "h_p_QC_PPMReport"); List<object> columnNameList = new List<object>(); //娣诲姞鍒楀悕 foreach (DataColumn col in ds.Tables[0].Columns) @@ -1909,6 +1911,7 @@ string HBeginDate = dic["HBeginDate"].ToString(); string HEndDate = dic["HEndDate"].ToString(); string HBatchNo = dic["HBatchNo"].ToString();//鎵规鍙� + string HBatchNo1 = dic["HBatchNo1"].ToString();//ID鍙� string HProject = dic["HProject"].ToString();//椤圭洰鍙� string HBatchWork = dic["HBatchWork"].ToString();//鏄惁閲忎骇 string HDivisionName = dic["HDivisionName"].ToString();//浜嬩笟閮� @@ -1916,7 +1919,7 @@ string HReceiveMan = dic["HReceiveMan"].ToString();//鎿嶄綔鍛� string HEquipNumber = dic["HEquipNumber"].ToString();//璁惧缂栫爜 - ds = oCN.RunProcReturn("exec h_p_QC_QualityDailyReprot '" + HBeginDate + "','" + HEndDate + "','" + HBatchNo + "','" + HProject + "','" + HBatchWork + "','" + HDivisionName + "','" + HProcName + "','" + HReceiveMan + "','" + HEquipNumber + "'", "h_p_QC_QualityDailyReprot"); + ds = oCN.RunProcReturn("exec h_p_QC_QualityDailyReprot '" + HBeginDate + "','" + HEndDate + "','" + HBatchNo + "','" + HBatchNo1 + "','" + HProject + "','" + HBatchWork + "','" + HDivisionName + "','" + HProcName + "','" + HReceiveMan + "','" + HEquipNumber + "'", "h_p_QC_QualityDailyReprot"); //娣诲姞鍒楀悕 foreach (DataColumn col in ds.Tables[0].Columns) diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBillController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBillController.cs" index bcde6de..ec67edd 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBillController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBillController.cs" @@ -94,9 +94,11 @@ var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - string msg2 = sArray[0].ToString(); - string refSav = sArray[1].ToString();//鎿嶄綔鏂瑰紡鏁版嵁绫诲瀷 1娣诲姞 3淇敼 2 澶嶅埗 - string user = sArray[2].ToString();//鐢ㄦ埛鍚� + string msg2 = sArray[0].ToString(); + string msg3 = sArray[1].ToString(); //瀛愯〃 + string refSav = sArray[2].ToString();//鎿嶄綔鏂瑰紡鏁版嵁绫诲瀷 1娣诲姞 3淇敼 2 澶嶅埗 + string user = sArray[3].ToString();//鐢ㄦ埛鍚� + string UserName = ""; string s = ""; @@ -189,6 +191,29 @@ } oBill.omodel = oItem; } + + + // 琛ㄤ綋鏁版嵁 + //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆� + msg3 = msg3.Substring(1, msg3.Length - 2); + msg3 = msg3.Replace("\\", ""); + msg3 = msg3.Replace("\n", ""); //\n + string jsonString1 = "[" + msg3.ToString() + "]"; + List<ClsQC_MonthTarGetBillSub> ls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_MonthTarGetBillSub>>(jsonString1); + int i = 0; + foreach (Model.ClsQC_MonthTarGetBillSub oItemSub in ls) + { + i++; + oItemSub.HEntryID = i; + + + oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); + oItemSub.HCloseType = false; //鍏抽棴绫诲瀷 + + oBill.DetailColl.Add(oItemSub); + + } + //淇濆瓨 //淇濆瓨瀹屾瘯鍚庡鐞� bool bResult; @@ -257,6 +282,7 @@ } oCN.BeginTran(); oCN.RunProc("Delete From QC_MonthTarGetBillMain where HInterID = " + HInterID); + oCN.RunProc("Delete From QC_MonthTarGetBillSub where HInterID = " + HInterID); oCN.Commit(); objJsonResult.code = "1"; @@ -290,7 +316,7 @@ try { - ds = oCN.RunProcReturn("select * from h_v_QC_MonthTarGetBillList where hmainid =" + HInterID, "h_v_QC_MonthTarGetBillList"); + ds = oCN.RunProcReturn("select * from h_v_QC_MonthTarGetBill_Edit where hmainid =" + HInterID, "h_v_QC_MonthTarGetBill_Edit"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; diff --git "a/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs" "b/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs" index 7d730ae..f657688 100644 --- "a/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs" +++ "b/WebAPI/Controllers/\346\235\241\347\240\201\347\256\241\347\220\206/WEBSController.cs" @@ -1345,6 +1345,9 @@ { try { + //鏍规嵁鎵樻潯鐮佸瓧娈靛垹闄ゆ湰鍗曟潯鐮佸嚭鍏ュ簱缂撳瓨琛ㄦ暟鎹� + oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HBarCode_Pack<>'' and HInterID=" + HInterID.ToString() + " and HBillType='" + HBillType + "' and HBarCode_Pack='" + HBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo); + //鏍规嵁鏉$爜瀛楁鍒犻櫎鏈崟鏉$爜鍑哄叆搴撶紦瀛樿〃鏁版嵁 oCn.RunProc("Delete from KF_PonderationBillMain_Temp where HBarCode<>'' and HInterID=" + HInterID.ToString() + " and HBillType='" + HBillType + "' and HBarCode='" + HBarCode + "'", ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "0"; objJsonResult.count = 1; @@ -4487,8 +4490,6 @@ string sJXCode = ""; if (oSystemParameter.ShowBill(ref sErrMsg) == true) { - LogService.Write("妫シ鎵爜鍙傛暟鍊硷紝瀹㈡埛锛�" + oSystemParameter.omodel.WMS_CampanyName + " ,婧愬崟绫诲瀷锛�" + HSourceBillType); - if (oSystemParameter.omodel.WMS_CampanyName == "瀹夌憺") //绯荤粺鍙傛暟 瀹㈡埛瀹氬埗鍖栧悕绉� 绌虹櫧涓洪�氱敤 { sJXCode = POStockInBillController.JX_Json(sBarCode, HInterID, HBillType, HStockOrgID, HBillNo, HMaker); @@ -8885,6 +8886,46 @@ } } #endregion + + #region 閿�鍞嚭搴撹拷婧褰曟姤琛� + /// <summary> + /// 鑾峰彇閿�鍞嚭搴撹拷婧褰� + /// </summary> + /// <returns></returns> + [Route("WEBSController/GetKf_SellOutBarTraceReport_Json")] + [HttpGet] + public object GetKf_SellOutBarTraceReport_Json(DateTime HBeginDate, DateTime HEndDate, string HBarCode, Int64 HStockOrgID, string HWhere) + { + try + { + ds = oCn.RunProcReturn("exec h_p_Kf_SellOutBarTraceReport '" + HBeginDate.ToShortDateString() + "','" + HEndDate.ToShortDateString() + "','" + HBarCode + "'," + HStockOrgID.ToString() + ",'" + HWhere + "'", "h_p_Kf_SellOutBarTraceReport"); + + List<object> columnNameList = new List<object>(); + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString)); //鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ヨ閿�鍞嚭搴撹拷婧褰曚俊鎭け璐ワ紒" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + #endregion #region 瀹㈡埛鏉$爜鎵弿璁板綍鍗� diff --git "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" index 6cfe6fd..13636b3 100644 --- "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" +++ "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/Sc_MESBeginStepWorkBillController.cs" @@ -46,8 +46,6 @@ try { List<object> a = new List<object>(); - LogService.Write("鎵ц浜�0"); - //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� if (!DBUtility.ClsPub.Security_Log("MES_MESBeginWorkBill_Query", 1, false, user)) { @@ -57,7 +55,6 @@ objJsonResult.data = null; return objJsonResult; } - LogService.Write("鎵ц浜�"); ds = Sc_GetMESBeginStepWorkBill(sWhere); foreach (DataColumn col in ds.Tables[0].Columns)//閬嶅巻ds涓涓�涓〃锛圱ables[0]锛夌殑鎵�鏈夊垪锛圕olumns锛夋瘡娆″惊鐜腑锛宑ol鍙橀噺浼氭寔鏈夊綋鍓嶅垪鐨勫紩鐢� { diff --git "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs" "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs" index bc57896..168e56a 100644 --- "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs" +++ "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs" @@ -799,7 +799,7 @@ string subSql = "Insert into Sc_QualityReportBillSub " + " (HInterID,HEntryID,HBillNo_bak,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + - ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HProcID,HBadReasonID,HBadReasonNumber,HGroupID" + + ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HProcID,HBadReasonID,HBadReasonNumber,HBadPhenomenaID,HGroupID" + ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + ",HBarCode,HReportType" + ",HAddr,HMaker,HMakeDate" + @@ -824,6 +824,7 @@ "," + oSub.HProcID.ToString() + "" + "," + oSub.HBadReasonID.ToString() + "" + ",'" + oSub.HBadReasonNumber.ToString() + "'" + + "," + oSub.HBadPhenomenaID.ToString() + "" + ",'" + oSub.HGroupID.ToString() + "'" + "," + oSub.HICMOInterID.ToString() + "" + diff --git a/WebAPI/DLL/ClsGy_InspectInstruMent_Ctl.cs b/WebAPI/DLL/ClsGy_InspectInstruMent_Ctl.cs index 3349773..7640ef2 100644 --- a/WebAPI/DLL/ClsGy_InspectInstruMent_Ctl.cs +++ b/WebAPI/DLL/ClsGy_InspectInstruMent_Ctl.cs @@ -20,9 +20,11 @@ oCn.BeginTran(); oCn.RunProc("Insert into " + MvarItemKey + " " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + - ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HERPItemID) " + + ",HLevel,HEndFlag,HStopflag,HRemark,HMakeTime,HUSEORGID,HUseFlag,HMakeEmp,HCREATEORGID,HERPItemID" + + ",HCalibrationStatus,HCalibrationDate,HValidDate,HExpiryDay) " + " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + - "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HUSEORGID + "','" + 0 + "')", ref DBUtility.ClsPub.sExeReturnInfo); + "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "','" +DateTime.Now+ "','" + oModel.HUSEORGID + "','" + oModel.HUseFlag + "','" + oModel.HMakeEmp+ "','" + oModel.HUSEORGID + "','" + 0 + "'" + + ",'" + oModel.HCalibrationStatus.ToString() + "','" + oModel.HCalibrationDate.ToString() + "','" + oModel.HValidDate.ToString() + "','" + oModel.HExpiryDay.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); //淇敼涓婄骇涓洪潪鏈骇浠g爜 oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCn.Commit(); @@ -51,6 +53,10 @@ ",HUSEORGID='" + oModel.HUSEORGID + "'" + ",HModifyEmp ='" + oModel.HMakeEmp + "'" + ",HUseFlag='" + oModel.HUseFlag + "'" + + ",HCalibrationStatus='" + oModel.HCalibrationStatus + "'" + + ",HCalibrationDate='" + oModel.HCalibrationDate + "'" + + ",HValidDate='" + oModel.HValidDate + "'" + + ",HExpiryDay='" + oModel.HExpiryDay + "'" + ",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",HRemark= '" + oModel.HRemark + "' Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo); //淇敼瀛愰」鐩唬鐮� diff --git a/WebAPI/DLL/ClsSc_MouldProdInBill.cs b/WebAPI/DLL/ClsSc_MouldProdInBill.cs index e8e74ee..ed94f9b 100644 --- a/WebAPI/DLL/ClsSc_MouldProdInBill.cs +++ b/WebAPI/DLL/ClsSc_MouldProdInBill.cs @@ -186,5 +186,93 @@ } } + + //鏄剧ず鍗曟嵁 + public override bool ShowBill(Int64 lngBillKey, ref string sReturn) + { + try + { + //鏌ヨ涓昏〃 + DataSet Ds; + Ds = oCn.RunProcReturn("Select * from Sc_MouldStockBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_MouldStockBillMain"); + if (Ds.Tables[0].Rows.Count == 0) + { + sReturn = "鍗曟嵁鏈壘鍒帮紒"; + return false; + } + //鍥哄畾璧嬪��=========================================== + omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]); + omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]); + omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]); + omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]); + omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); + omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]); + omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim(); + omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]); + omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]); + omodel.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNextID"]); + omodel.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckFlowID"]); + omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim(); + omodel.HBackDate = Ds.Tables[0].Rows[0]["HBackDate"].ToString().Trim(); + omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim(); + omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim(); + omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim(); + omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim(); + omodel.HMakeDate = Ds.Tables[0].Rows[0]["HMakeDate"].ToString().Trim(); + omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim(); + omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim(); + omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim(); + omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim(); + omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]); + omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim(); + omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim(); + //======================================================== + omodel.HSupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"]); + omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); + omodel.HManagerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HManagerID"]); + omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]); + omodel.HExplanation = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HExplanation"]); + omodel.HInnerBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInnerBillNo"]); + // + + //寰幆 + DataSet DsSub; + DsSub = oCn.RunProcReturn("Select * from Sc_MouldStockBillSub Where HInterID=" + lngBillKey.ToString(), "Sc_MouldStockBillSub"); + DetailColl.Clear();//娓呯┖ + for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) + { + Models.ClsSc_MouldProdBillSub oSub = new Models.ClsSc_MouldProdBillSub(); + // 鍥哄畾璧嬪��=============================================== + oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); + oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); + oSub.HSourceBillType = DsSub.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim(); + oSub.HSourceBillNo = DsSub.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim(); + oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]); + oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]); + oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCloseMan"]); + oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HCloseType"]); + oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]); + oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim(); + //=================================================== + oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]); + oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]); + oSub.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]); + oSub.HPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HPrice"]); + oSub.HMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HMoney"]); + oSub.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSeOrderBillNo"]); + oSub.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderInterID"]); + oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]); + DetailColl.Add(oSub); + } + sReturn = "鏄剧ず鍗曟嵁鎴愬姛锛�"; + return true; + } + catch (Exception e) + { + sReturn = e.Message; + throw (e); + } + } + } } \ No newline at end of file diff --git a/WebAPI/Models/Sc_StationOutBillSub_Sup.cs b/WebAPI/Models/Sc_StationOutBillSub_Sup.cs new file mode 100644 index 0000000..431d3eb --- /dev/null +++ b/WebAPI/Models/Sc_StationOutBillSub_Sup.cs @@ -0,0 +1,21 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Linq; +using System.Web; + +namespace WebAPI.Models +{ + public class Sc_StationOutBillSub_Sup + { + public int HInterID { get; set; } + public int HEntryID { get; set; } + public int HSupID { get; set; } + public double HWasterQty_Mater { get; set; } + public double HBackWorkQty { get; set; } + public string HRemark { get; set; } + public int HSourceInterID { get; set; } + public int HSourceEntryID { get; set; } + public string HSourceBillNo { get; set; } + public string HSourceBillType { get; set; } + } +} \ No newline at end of file diff --git a/WebAPI/Models/Supplier.cs b/WebAPI/Models/Supplier.cs index d999373..c532d03 100644 --- a/WebAPI/Models/Supplier.cs +++ b/WebAPI/Models/Supplier.cs @@ -76,7 +76,7 @@ public string HMaterClass { get; set; } public int HPSStyleID { get; set; } - + public int HSupTypeID { get; set; } } } \ No newline at end of file diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml b/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml new file mode 100644 index 0000000..86e2fec --- /dev/null +++ b/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml @@ -0,0 +1,16 @@ +锘�<?xml version="1.0" encoding="utf-8"?> +<!-- +https://go.microsoft.com/fwlink/?LinkID=208121. +--> +<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> + <PropertyGroup> + <DeleteExistingFiles>true</DeleteExistingFiles> + <ExcludeApp_Data>False</ExcludeApp_Data> + <LaunchSiteAfterPublish>True</LaunchSiteAfterPublish> + <LastUsedBuildConfiguration>Release</LastUsedBuildConfiguration> + <LastUsedPlatform>Any CPU</LastUsedPlatform> + <PublishProvider>FileSystem</PublishProvider> + <PublishUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</PublishUrl> + <WebPublishMethod>FileSystem</WebPublishMethod> + </PropertyGroup> +</Project> \ No newline at end of file diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml.user new file mode 100644 index 0000000..7c12bdc --- /dev/null +++ b/WebAPI/Properties/PublishProfiles/FolderProfile9.pubxml.user @@ -0,0 +1,498 @@ +锘�<?xml version="1.0" encoding="utf-8"?> +<!-- +https://go.microsoft.com/fwlink/?LinkID=208121. +--> +<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> + <PropertyGroup> + <History>True|2024-12-30T03:17:50.7918409Z;True|2024-12-30T11:17:26.1353379+08:00;False|2024-12-30T11:16:45.7291107+08:00;</History> + <_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl> + </PropertyGroup> + <ItemGroup> + <File Include="apiapp.json"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="bin/AlibabaCloud.EndpointUtil.dll"> + <publishTime>04/07/2020 16:33:48</publishTime> + </File> + <File Include="bin/AlibabaCloud.GatewayDingTalk.dll"> + <publishTime>04/25/2023 17:49:04</publishTime> + </File> + <File Include="bin/AlibabaCloud.GatewaySpi.dll"> + <publishTime>07/31/2024 20:50:30</publishTime> + </File> + <File Include="bin/AlibabaCloud.OpenApiClient.dll"> + <publishTime>08/06/2024 18:07:52</publishTime> + </File> + <File Include="bin/AlibabaCloud.OpenApiUtil.dll"> + <publishTime>11/22/2022 11:24:18</publishTime> + </File> + <File Include="bin/AlibabaCloud.SDK.Dingtalk.dll"> + <publishTime>08/08/2024 19:43:22</publishTime> + </File> + <File Include="bin/AlibabaCloud.TeaUtil.dll"> + <publishTime>07/15/2024 20:25:56</publishTime> + </File> + <File Include="bin/AlibabaCloud.TeaXML.dll"> + <publishTime>08/03/2022 21:46:08</publishTime> + </File> + <File Include="bin/Aliyun.Credentials.dll"> + <publishTime>07/24/2024 10:36:58</publishTime> + </File> + <File Include="bin/Antlr3.Runtime.dll"> + <publishTime>02/22/2013 16:43:40</publishTime> + </File> + <File Include="bin/Antlr3.Runtime.pdb"> + <publishTime>02/22/2013 16:43:40</publishTime> + </File> + <File Include="bin/BLL.dll"> + <publishTime>12/30/2024 11:16:58</publishTime> + </File> + <File Include="bin/BLL.pdb"> + <publishTime>12/30/2024 11:16:58</publishTime> + </File> + <File Include="bin/BouncyCastle.Crypto.dll"> + <publishTime>12/18/2020 05:32:28</publishTime> + </File> + <File Include="bin/DAL.dll"> + <publishTime>12/30/2024 11:16:56</publishTime> + </File> + <File Include="bin/DAL.pdb"> + <publishTime>12/30/2024 11:16:56</publishTime> + </File> + <File Include="bin/Dapper.dll"> + <publishTime>07/22/2016 22:52:40</publishTime> + </File> + <File Include="bin/DBUtility.dll"> + <publishTime>12/30/2024 11:16:53</publishTime> + </File> + <File Include="bin/DBUtility.pdb"> + <publishTime>12/30/2024 11:16:53</publishTime> + </File> + <File Include="bin/Grpc.Core.Api.dll"> + <publishTime>03/22/2022 13:17:26</publishTime> + </File> + <File Include="bin/Grpc.Core.Api.pdb"> + <publishTime>03/19/2022 07:39:42</publishTime> + </File> + <File Include="bin/Grpc.Core.dll"> + <publishTime>03/22/2022 13:17:20</publishTime> + </File> + <File Include="bin/Grpc.Core.pdb"> + <publishTime>03/19/2022 07:39:48</publishTime> + </File> + <File Include="bin/grpc_csharp_ext.x64.dll"> + <publishTime>03/22/2022 13:17:22</publishTime> + </File> + <File Include="bin/grpc_csharp_ext.x86.dll"> + <publishTime>03/22/2022 13:17:22</publishTime> + </File> + <File Include="bin/ICSharpCode.SharpZipLib.dll"> + <publishTime>05/09/2021 01:08:30</publishTime> + </File> + <File Include="bin/ICSharpCode.SharpZipLib.pdb"> + <publishTime>05/09/2021 01:08:30</publishTime> + </File> + <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> + <publishTime>02/08/2023 09:47:46</publishTime> + </File> + <File Include="bin/libgrpc_csharp_ext.x64.dylib"> + <publishTime>03/19/2022 07:38:44</publishTime> + </File> + <File Include="bin/libgrpc_csharp_ext.x64.so"> + <publishTime>03/19/2022 07:38:42</publishTime> + </File> + <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> + <publishTime>03/19/2015 01:02:50</publishTime> + </File> + <File Include="bin/Microsoft.CSharp.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/Microsoft.Web.Infrastructure.dll"> + <publishTime>07/25/2012 19:48:56</publishTime> + </File> + <File Include="bin/Model.dll"> + <publishTime>12/30/2024 11:16:54</publishTime> + </File> + <File Include="bin/Model.pdb"> + <publishTime>12/30/2024 11:16:54</publishTime> + </File> + <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="bin/Newtonsoft.Json.dll"> + <publishTime>03/08/2023 15:09:56</publishTime> + </File> + <File Include="bin/NPOI.dll"> + <publishTime>10/23/2021 09:07:54</publishTime> + </File> + <File Include="bin/NPOI.OOXML.dll"> + <publishTime>10/23/2021 09:07:56</publishTime> + </File> + <File Include="bin/NPOI.OOXML.pdb"> + <publishTime>10/23/2021 17:07:56</publishTime> + </File> + <File Include="bin/NPOI.OpenXml4Net.dll"> + <publishTime>10/23/2021 09:07:54</publishTime> + </File> + <File Include="bin/NPOI.OpenXml4Net.pdb"> + <publishTime>10/23/2021 17:07:54</publishTime> + </File> + <File Include="bin/NPOI.OpenXmlFormats.dll"> + <publishTime>10/23/2021 09:07:54</publishTime> + </File> + <File Include="bin/NPOI.OpenXmlFormats.pdb"> + <publishTime>10/23/2021 17:07:54</publishTime> + </File> + <File Include="bin/NPOI.pdb"> + <publishTime>10/23/2021 17:07:54</publishTime> + </File> + <File Include="bin/Pub_Class.dll"> + <publishTime>12/30/2024 11:16:51</publishTime> + </File> + <File Include="bin/Pub_Class.pdb"> + <publishTime>12/30/2024 11:16:51</publishTime> + </File> + <File Include="bin/Pub_Control.dll"> + <publishTime>12/30/2024 11:16:52</publishTime> + </File> + <File Include="bin/Pub_Control.pdb"> + <publishTime>12/30/2024 11:16:52</publishTime> + </File> + <File Include="bin/RestSharp.dll"> + <publishTime>08/31/2012 06:22:50</publishTime> + </File> + <File Include="bin/SQLHelper.dll"> + <publishTime>12/30/2024 11:16:52</publishTime> + </File> + <File Include="bin/SQLHelper.pdb"> + <publishTime>12/30/2024 11:16:52</publishTime> + </File> + <File Include="bin/Swashbuckle.Core.dll"> + <publishTime>02/16/2015 01:57:08</publishTime> + </File> + <File Include="bin/SyntacticSugar.dll"> + <publishTime>12/18/2024 11:02:10</publishTime> + </File> + <File Include="bin/SyntacticSugar.pdb"> + <publishTime>12/18/2024 11:02:10</publishTime> + </File> + <File Include="bin/System.Buffers.dll"> + <publishTime>07/19/2017 18:01:28</publishTime> + </File> + <File Include="bin/System.ComponentModel.DataAnnotations.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Configuration.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Data.DataSetExtensions.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Data.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Drawing.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.EnterpriseServices.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> + <publishTime>08/19/2014 18:03:34</publishTime> + </File> + <File Include="bin/System.Memory.dll"> + <publishTime>04/18/2019 00:24:34</publishTime> + </File> + <File Include="bin/System.Net.Http.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Net.Http.Extensions.dll"> + <publishTime>02/20/2015 04:10:46</publishTime> + </File> + <File Include="bin/System.Net.Http.Formatting.dll"> + <publishTime>11/28/2018 21:00:36</publishTime> + </File> + <File Include="bin/System.Net.Http.Primitives.dll"> + <publishTime>02/20/2015 04:10:46</publishTime> + </File> + <File Include="bin/System.Runtime.CompilerServices.Unsafe.dll"> + <publishTime>09/19/2018 03:38:10</publishTime> + </File> + <File Include="bin/System.Runtime.Serialization.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.ApplicationServices.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.Cors.dll"> + <publishTime>11/28/2018 20:58:44</publishTime> + </File> + <File Include="bin/System.Web.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.DynamicData.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.Entity.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.Extensions.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.Helpers.dll"> + <publishTime>01/28/2015 12:04:30</publishTime> + </File> + <File Include="bin/System.Web.Http.Cors.dll"> + <publishTime>11/28/2018 21:01:26</publishTime> + </File> + <File Include="bin/System.Web.Http.dll"> + <publishTime>11/28/2018 21:01:00</publishTime> + </File> + <File Include="bin/System.Web.Http.WebHost.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="bin/System.Web.Mvc.dll"> + <publishTime>01/28/2015 12:02:18</publishTime> + </File> + <File Include="bin/System.Web.Optimization.dll"> + <publishTime>02/11/2014 23:26:04</publishTime> + </File> + <File Include="bin/System.Web.Razor.dll"> + <publishTime>01/28/2015 12:02:32</publishTime> + </File> + <File Include="bin/System.Web.Services.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Web.WebPages.Deployment.dll"> + <publishTime>01/28/2015 12:04:30</publishTime> + </File> + <File Include="bin/System.Web.WebPages.dll"> + <publishTime>01/28/2015 12:04:30</publishTime> + </File> + <File Include="bin/System.Web.WebPages.Razor.dll"> + <publishTime>01/28/2015 12:04:30</publishTime> + </File> + <File Include="bin/System.Xml.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/System.Xml.Linq.dll"> + <publishTime>09/26/2012 03:16:08</publishTime> + </File> + <File Include="bin/Tea.dll"> + <publishTime>05/09/2023 10:43:40</publishTime> + </File> + <File Include="bin/TopSdk.dll"> + <publishTime>12/18/2024 11:03:19</publishTime> + </File> + <File Include="bin/TopSdk.pdb"> + <publishTime>12/18/2024 11:03:19</publishTime> + </File> + <File Include="bin/WebActivatorEx.dll"> + <publishTime>11/24/2014 19:18:48</publishTime> + </File> + <File Include="bin/WebAPI.dll"> + <publishTime>12/30/2024 11:17:44</publishTime> + </File> + <File Include="bin/WebAPI.pdb"> + <publishTime>12/30/2024 11:17:44</publishTime> + </File> + <File Include="bin/WebAPI.XmlSerializers.dll"> + <publishTime>12/30/2024 11:17:48</publishTime> + </File> + <File Include="bin/WebGrease.dll"> + <publishTime>07/18/2013 01:03:52</publishTime> + </File> + <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> + <publishTime>11/29/2018 21:26:02</publishTime> + </File> + <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> + <publishTime>11/29/2018 21:26:30</publishTime> + </File> + <File Include="Config/kdapi.config"> + <publishTime>08/15/2022 15:46:13</publishTime> + </File> + <File Include="Content/bootstrap.css"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Content/bootstrap.min.css"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Content/Site.css"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/BLL.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/DAL.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/DBUtility.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> + <publishTime>02/08/2023 09:47:46</publishTime> + </File> + <File Include="DLL/Model.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/Newtonsoft.Json.Net35.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/Pub_Class.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/Pub_Control.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="DLL/SQLHelper.dll"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="fonts/glyphicons-halflings-regular.eot"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="fonts/glyphicons-halflings-regular.svg"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="fonts/glyphicons-halflings-regular.ttf"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="fonts/glyphicons-halflings-regular.woff"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Global.asax"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="grpc_csharp_ext.x64.dll"> + <publishTime>03/22/2022 13:17:22</publishTime> + </File> + <File Include="grpc_csharp_ext.x86.dll"> + <publishTime>03/22/2022 13:17:22</publishTime> + </File> + <File Include="Index.html"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="libgrpc_csharp_ext.x64.dylib"> + <publishTime>03/19/2022 07:38:44</publishTime> + </File> + <File Include="libgrpc_csharp_ext.x64.so"> + <publishTime>03/19/2022 07:38:42</publishTime> + </File> + <File Include="libman.json"> + <publishTime>07/18/2023 17:26:29</publishTime> + </File> + <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="packages.config"> + <publishTime>09/19/2024 08:47:56</publishTime> + </File> + <File Include="Views/Scripts/bootstrap.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/bootstrap.min.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery-1.10.2.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery-1.10.2.min.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery-1.10.2.min.map"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery.validate.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery.validate.min.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Scripts/modernizr-2.6.2.js"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Shared/Error.cshtml"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/Shared/_Layout.cshtml"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/web.config"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Views/_ViewStart.cshtml"> + <publishTime>03/15/2022 10:06:42</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> + <publishTime>03/31/2023 09:57:09</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsKf_ICStockBill_Mould.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> + <publishTime>03/31/2023 09:57:08</publishTime> + </File> + <File Include="Web.config"> + <publishTime>12/30/2024 11:17:21</publishTime> + </File> + </ItemGroup> +</Project> \ No newline at end of file diff --git a/WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user index e76231d..e0bd574 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user @@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> - <History>True|2024-12-18T00:34:56.1537647Z;True|2024-12-17T13:56:47.7915112+08:00;True|2024-12-17T11:13:27.2665832+08:00;True|2024-12-16T16:01:15.5110052+08:00;True|2024-12-16T15:53:18.1111331+08:00;True|2024-12-16T15:13:43.9719840+08:00;True|2024-12-16T15:08:49.2287341+08:00;True|2024-12-16T14:59:21.3003410+08:00;True|2024-12-16T10:16:34.6636364+08:00;True|2024-12-16T10:12:38.1827164+08:00;False|2024-12-16T10:12:16.1621752+08:00;True|2024-12-13T15:44:29.9921182+08:00;False|2024-12-13T15:43:36.1775569+08:00;True|2024-12-11T09:06:23.2065068+08:00;True|2024-12-11T09:02:10.9767948+08:00;True|2024-12-11T08:26:16.2292105+08:00;True|2024-12-10T16:17:47.2702447+08:00;True|2024-12-10T14:47:18.4352590+08:00;True|2024-12-10T14:10:37.0165625+08:00;True|2024-12-10T13:59:25.4712057+08:00;True|2024-12-10T13:46:02.3070111+08:00;True|2024-12-10T13:39:19.2434918+08:00;True|2024-12-10T10:42:47.3763447+08:00;True|2024-12-10T10:28:20.0524748+08:00;True|2024-12-09T11:01:35.7691980+08:00;True|2024-12-09T09:20:22.9742701+08:00;True|2024-12-09T08:47:26.0470083+08:00;True|2024-12-06T13:13:33.9776030+08:00;True|2024-12-05T14:33:41.1542437+08:00;True|2024-12-05T14:21:02.3120095+08:00;True|2024-12-05T14:13:09.2733831+08:00;True|2024-12-05T13:27:25.9831554+08:00;True|2024-12-05T13:23:25.4183580+08:00;True|2024-12-05T11:27:26.9609695+08:00;True|2024-12-05T09:20:29.4596887+08:00;True|2024-12-05T08:47:57.2553570+08:00;True|2024-12-05T08:41:06.4860297+08:00;True|2024-12-05T08:32:16.9785572+08:00;True|2024-12-04T15:54:19.4995372+08:00;True|2024-12-04T11:10:12.2273624+08:00;True|2024-12-04T10:21:44.8769236+08:00;False|2024-12-04T10:20:59.8206595+08:00;True|2024-12-04T09:52:03.8506923+08:00;True|2024-12-03T15:09:48.8710712+08:00;False|2024-12-03T15:08:46.8904626+08:00;True|2024-11-28T10:42:45.3823067+08:00;True|2024-11-28T09:58:38.0983021+08:00;True|2024-11-27T16:16:28.4276838+08:00;True|2024-11-27T16:09:08.0834912+08:00;True|2024-11-27T14:32:21.1684294+08:00;True|2024-11-27T13:24:51.2115157+08:00;True|2024-11-27T13:16:51.5888615+08:00;True|2024-11-26T10:47:18.1958719+08:00;False|2024-11-26T10:46:22.2016963+08:00;False|2024-11-25T10:22:55.3420353+08:00;True|2024-11-20T09:08:48.6293480+08:00;True|2024-11-19T17:01:27.8454996+08:00;True|2024-11-19T08:20:49.6371464+08:00;True|2024-11-18T15:27:25.3419580+08:00;True|2024-11-18T15:19:07.4691728+08:00;True|2024-11-18T14:57:25.8637252+08:00;True|2024-11-18T14:52:10.6158576+08:00;True|2024-11-18T14:46:03.5051743+08:00;True|2024-11-18T13:42:14.5146469+08:00;True|2024-11-18T13:27:53.4498275+08:00;True|2024-11-18T11:26:05.8168670+08:00;True|2024-11-18T11:04:00.4711300+08:00;True|2024-11-18T10:54:15.6267907+08:00;True|2024-11-18T10:45:29.5275370+08:00;True|2024-11-15T16:58:39.1926238+08:00;True|2024-11-15T16:45:12.0168760+08:00;True|2024-11-15T16:37:11.8513587+08:00;True|2024-11-15T16:31:13.0430714+08:00;True|2024-11-15T16:27:45.3575015+08:00;False|2024-11-15T16:26:49.5306586+08:00;True|2024-11-15T16:16:54.0542122+08:00;True|2024-11-15T15:51:41.6920560+08:00;False|2024-11-15T15:50:37.8798414+08:00;True|2024-11-06T14:13:46.3129972+08:00;False|2024-11-06T14:12:47.9022879+08:00;False|2024-11-05T20:45:28.3960353+08:00;True|2024-11-05T19:04:11.0417788+08:00;False|2024-11-05T19:03:03.9263878+08:00;True|2024-11-05T15:54:24.8374699+08:00;False|2024-11-05T15:53:24.4214141+08:00;True|2024-10-25T16:51:46.3066612+08:00;True|2024-10-25T12:16:27.8737941+08:00;True|2024-10-25T10:12:38.8056269+08:00;False|2024-10-25T10:11:44.1117608+08:00;True|2024-10-25T09:54:06.8572059+08:00;True|2024-10-25T08:21:42.6333993+08:00;True|2024-10-24T17:56:19.5319332+08:00;True|2024-10-24T17:50:10.0801119+08:00;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> + <History>True|2024-12-28T06:22:43.5822832Z;True|2024-12-28T14:10:54.9885289+08:00;True|2024-12-28T13:56:42.0405943+08:00;True|2024-12-28T13:18:42.1604585+08:00;True|2024-12-28T10:48:49.0559287+08:00;False|2024-12-28T10:48:41.8813560+08:00;True|2024-12-27T16:41:50.4368711+08:00;True|2024-12-27T14:31:25.7129706+08:00;True|2024-12-27T11:24:16.6524093+08:00;False|2024-12-27T11:23:25.9617516+08:00;True|2024-12-18T08:34:56.1537647+08:00;True|2024-12-17T13:56:47.7915112+08:00;True|2024-12-17T11:13:27.2665832+08:00;True|2024-12-16T16:01:15.5110052+08:00;True|2024-12-16T15:53:18.1111331+08:00;True|2024-12-16T15:13:43.9719840+08:00;True|2024-12-16T15:08:49.2287341+08:00;True|2024-12-16T14:59:21.3003410+08:00;True|2024-12-16T10:16:34.6636364+08:00;True|2024-12-16T10:12:38.1827164+08:00;False|2024-12-16T10:12:16.1621752+08:00;True|2024-12-13T15:44:29.9921182+08:00;False|2024-12-13T15:43:36.1775569+08:00;True|2024-12-11T09:06:23.2065068+08:00;True|2024-12-11T09:02:10.9767948+08:00;True|2024-12-11T08:26:16.2292105+08:00;True|2024-12-10T16:17:47.2702447+08:00;True|2024-12-10T14:47:18.4352590+08:00;True|2024-12-10T14:10:37.0165625+08:00;True|2024-12-10T13:59:25.4712057+08:00;True|2024-12-10T13:46:02.3070111+08:00;True|2024-12-10T13:39:19.2434918+08:00;True|2024-12-10T10:42:47.3763447+08:00;True|2024-12-10T10:28:20.0524748+08:00;True|2024-12-09T11:01:35.7691980+08:00;True|2024-12-09T09:20:22.9742701+08:00;True|2024-12-09T08:47:26.0470083+08:00;True|2024-12-06T13:13:33.9776030+08:00;True|2024-12-05T14:33:41.1542437+08:00;True|2024-12-05T14:21:02.3120095+08:00;True|2024-12-05T14:13:09.2733831+08:00;True|2024-12-05T13:27:25.9831554+08:00;True|2024-12-05T13:23:25.4183580+08:00;True|2024-12-05T11:27:26.9609695+08:00;True|2024-12-05T09:20:29.4596887+08:00;True|2024-12-05T08:47:57.2553570+08:00;True|2024-12-05T08:41:06.4860297+08:00;True|2024-12-05T08:32:16.9785572+08:00;True|2024-12-04T15:54:19.4995372+08:00;True|2024-12-04T11:10:12.2273624+08:00;True|2024-12-04T10:21:44.8769236+08:00;False|2024-12-04T10:20:59.8206595+08:00;True|2024-12-04T09:52:03.8506923+08:00;True|2024-12-03T15:09:48.8710712+08:00;False|2024-12-03T15:08:46.8904626+08:00;True|2024-11-28T10:42:45.3823067+08:00;True|2024-11-28T09:58:38.0983021+08:00;True|2024-11-27T16:16:28.4276838+08:00;True|2024-11-27T16:09:08.0834912+08:00;True|2024-11-27T14:32:21.1684294+08:00;True|2024-11-27T13:24:51.2115157+08:00;True|2024-11-27T13:16:51.5888615+08:00;True|2024-11-26T10:47:18.1958719+08:00;False|2024-11-26T10:46:22.2016963+08:00;False|2024-11-25T10:22:55.3420353+08:00;True|2024-11-20T09:08:48.6293480+08:00;True|2024-11-19T17:01:27.8454996+08:00;True|2024-11-19T08:20:49.6371464+08:00;True|2024-11-18T15:27:25.3419580+08:00;True|2024-11-18T15:19:07.4691728+08:00;True|2024-11-18T14:57:25.8637252+08:00;True|2024-11-18T14:52:10.6158576+08:00;True|2024-11-18T14:46:03.5051743+08:00;True|2024-11-18T13:42:14.5146469+08:00;True|2024-11-18T13:27:53.4498275+08:00;True|2024-11-18T11:26:05.8168670+08:00;True|2024-11-18T11:04:00.4711300+08:00;True|2024-11-18T10:54:15.6267907+08:00;True|2024-11-18T10:45:29.5275370+08:00;True|2024-11-15T16:58:39.1926238+08:00;True|2024-11-15T16:45:12.0168760+08:00;True|2024-11-15T16:37:11.8513587+08:00;True|2024-11-15T16:31:13.0430714+08:00;True|2024-11-15T16:27:45.3575015+08:00;False|2024-11-15T16:26:49.5306586+08:00;True|2024-11-15T16:16:54.0542122+08:00;True|2024-11-15T15:51:41.6920560+08:00;False|2024-11-15T15:50:37.8798414+08:00;True|2024-11-06T14:13:46.3129972+08:00;False|2024-11-06T14:12:47.9022879+08:00;False|2024-11-05T20:45:28.3960353+08:00;True|2024-11-05T19:04:11.0417788+08:00;False|2024-11-05T19:03:03.9263878+08:00;True|2024-11-05T15:54:24.8374699+08:00;False|2024-11-05T15:53:24.4214141+08:00;True|2024-10-25T16:51:46.3066612+08:00;True|2024-10-25T12:16:27.8737941+08:00;True|2024-10-25T10:12:38.8056269+08:00;False|2024-10-25T10:11:44.1117608+08:00;True|2024-10-25T09:54:06.8572059+08:00;True|2024-10-25T08:21:42.6333993+08:00;True|2024-10-24T17:56:19.5319332+08:00;True|2024-10-24T17:50:10.0801119+08:00;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <_PublishTargetUrl>G:\issWeb\缃戠珯鍙戝竷\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>12/20/2024 16:25:53</publishTime> + <publishTime>12/28/2024 14:21:11</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>12/20/2024 16:25:53</publishTime> + <publishTime>12/28/2024 14:21:11</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>12/20/2024 16:25:51</publishTime> + <publishTime>12/28/2024 14:21:09</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>12/20/2024 16:25:51</publishTime> + <publishTime>12/28/2024 14:21:09</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>12/20/2024 16:25:45</publishTime> + <publishTime>12/28/2024 14:21:04</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>12/20/2024 16:25:45</publishTime> + <publishTime>12/28/2024 14:21:04</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>12/20/2024 16:25:46</publishTime> + <publishTime>12/28/2024 14:21:04</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>12/20/2024 16:25:46</publishTime> + <publishTime>12/28/2024 14:21:04</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/15/2024 12:55:45</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>12/20/2024 16:25:43</publishTime> + <publishTime>12/28/2024 14:21:02</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>12/20/2024 16:25:43</publishTime> + <publishTime>12/28/2024 14:21:02</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>12/20/2024 16:25:44</publishTime> + <publishTime>12/28/2024 14:21:03</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>12/20/2024 16:25:44</publishTime> + <publishTime>12/28/2024 14:21:03</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>12/20/2024 16:25:44</publishTime> + <publishTime>12/28/2024 14:21:02</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>12/20/2024 16:25:44</publishTime> + <publishTime>12/28/2024 14:21:02</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> - <publishTime>12/20/2024 16:23:35</publishTime> + <publishTime>12/27/2024 10:15:52</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> - <publishTime>12/20/2024 16:23:35</publishTime> + <publishTime>12/27/2024 10:15:52</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> - <publishTime>12/20/2024 16:23:41</publishTime> + <publishTime>12/25/2024 16:28:00</publishTime> </File> <File Include="bin/TopSdk.pdb"> - <publishTime>12/20/2024 16:23:41</publishTime> + <publishTime>12/25/2024 16:28:00</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>12/20/2024 16:26:26</publishTime> + <publishTime>12/28/2024 14:21:47</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>12/20/2024 16:26:26</publishTime> + <publishTime>12/28/2024 14:21:47</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>08/16/2024 16:55:28</publishTime> @@ -495,7 +495,7 @@ <publishTime>04/29/2024 08:30:03</publishTime> </File> <File Include="Web.config"> - <publishTime>12/06/2024 13:13:33</publishTime> + <publishTime>12/28/2024 14:22:42</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user b/WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user index bf7e301..75dc922 100644 --- a/WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/JFAPI.pubxml.user @@ -5,7 +5,7 @@ <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl> - <History>True|2024-12-20T04:51:29.2354841Z;True|2024-12-20T12:46:13.7636932+08:00;False|2024-12-20T12:44:21.1473486+08:00;False|2024-12-20T12:44:06.5427106+08:00;True|2024-12-20T12:29:33.9971940+08:00;False|2024-12-20T12:29:01.0285205+08:00;True|2024-12-19T15:49:19.9906264+08:00;True|2024-12-19T14:55:54.3323405+08:00;True|2024-12-19T14:17:50.5086161+08:00;True|2024-12-19T14:08:16.0919011+08:00;True|2024-12-19T14:02:50.3092759+08:00;True|2024-12-19T13:54:41.2332165+08:00;False|2024-12-19T13:54:07.6973483+08:00;True|2024-12-19T09:34:54.5332110+08:00;True|2024-12-19T08:49:05.5690428+08:00;False|2024-12-19T08:48:51.0618113+08:00;True|2024-12-18T15:45:34.7174246+08:00;False|2024-12-18T15:45:10.3226822+08:00;True|2024-12-18T15:32:03.5983267+08:00;True|2024-12-18T15:31:20.1219502+08:00;True|2024-12-18T11:57:09.1595607+08:00;True|2024-12-18T11:13:37.4765697+08:00;True|2024-12-18T10:07:54.1294714+08:00;True|2024-12-18T10:04:16.0967342+08:00;False|2024-12-18T10:04:04.1561560+08:00;True|2024-12-16T17:07:07.3386872+08:00;True|2024-12-16T16:34:59.1101964+08:00;True|2024-12-16T16:19:07.9287470+08:00;False|2024-12-16T16:18:46.4617432+08:00;True|2024-12-13T18:06:11.0778539+08:00;True|2024-12-13T16:53:52.2283177+08:00;True|2024-12-13T16:23:15.9531944+08:00;True|2024-12-13T13:58:03.7464045+08:00;True|2024-12-13T10:40:33.9285602+08:00;True|2024-12-13T10:38:03.8494063+08:00;False|2024-12-13T10:37:52.4251132+08:00;True|2024-12-13T10:31:07.4994631+08:00;False|2024-12-13T10:30:40.8021885+08:00;True|2024-12-12T10:01:42.4944750+08:00;False|2024-12-12T10:01:15.7147977+08:00;True|2024-12-11T17:21:58.0453583+08:00;True|2024-12-11T10:59:15.3836831+08:00;True|2024-12-11T09:49:19.4060272+08:00;False|2024-12-11T09:48:51.7603525+08:00;True|2024-12-11T08:58:41.4567855+08:00;False|2024-12-11T08:58:09.2160433+08:00;True|2024-12-10T17:25:49.3068154+08:00;True|2024-12-10T17:21:30.0155027+08:00;True|2024-12-10T17:16:56.7587487+08:00;False|2024-12-10T17:16:34.7816611+08:00;True|2024-12-10T16:55:40.3777585+08:00;False|2024-12-10T16:55:13.2621448+08:00;False|2024-12-09T13:59:27.6362265+08:00;True|2024-12-06T16:55:30.6422980+08:00;True|2024-12-06T15:08:49.5834939+08:00;True|2024-12-06T14:31:56.0968616+08:00;False|2024-12-06T14:31:44.2264009+08:00;True|2024-12-06T13:59:52.8150929+08:00;False|2024-12-06T13:48:22.6073939+08:00;True|2024-12-05T17:33:27.9247467+08:00;True|2024-12-05T17:30:23.1740838+08:00;False|2024-12-05T17:30:03.9977311+08:00;True|2024-12-04T15:18:41.4963816+08:00;True|2024-12-04T15:16:45.1121101+08:00;True|2024-12-04T15:14:33.5954776+08:00;True|2024-12-04T15:12:27.2913137+08:00;True|2024-12-04T14:10:19.6190673+08:00;False|2024-12-04T14:10:02.0319713+08:00;True|2024-12-03T16:08:46.6721098+08:00;True|2024-12-03T15:16:04.1754554+08:00;True|2024-12-03T15:13:25.4927626+08:00;True|2024-12-03T14:55:09.4413291+08:00;True|2024-12-03T14:43:11.8243897+08:00;True|2024-12-03T14:29:16.1511932+08:00;True|2024-12-03T14:24:07.9561838+08:00;False|2024-12-03T14:23:55.1293602+08:00;True|2024-12-02T16:31:22.0404862+08:00;False|2024-12-02T16:28:53.1721961+08:00;True|2024-12-02T15:41:24.9462025+08:00;True|2024-12-02T14:12:12.9356193+08:00;False|2024-12-02T14:11:35.7159488+08:00;True|2024-12-02T10:59:31.5582757+08:00;True|2024-11-29T12:08:55.4868083+08:00;False|2024-11-29T12:08:37.0353185+08:00;True|2024-11-28T10:47:27.2071355+08:00;False|2024-11-28T10:47:13.6670955+08:00;True|2024-11-27T15:21:57.6747082+08:00;False|2024-11-27T15:20:07.2403056+08:00;True|2024-11-27T15:13:36.1461091+08:00;True|2024-11-27T14:34:35.5908753+08:00;False|2024-11-27T14:33:30.7118923+08:00;True|2024-11-26T15:16:44.1854927+08:00;True|2024-11-26T15:14:33.4021067+08:00;False|2024-11-26T15:14:07.9955135+08:00;True|2024-11-26T14:48:35.6408418+08:00;True|2024-11-26T14:45:00.7251556+08:00;True|2024-11-26T14:04:58.4232988+08:00;False|2024-11-26T14:04:28.1286675+08:00;True|2024-11-25T13:45:07.6935933+08:00;True|2024-11-25T13:43:59.0788650+08:00;False|2024-11-25T13:43:44.2225194+08:00;True|2024-11-25T08:54:05.5144014+08:00;False|2024-11-25T08:53:49.2284063+08:00;False|2024-11-22T09:53:13.7879664+08:00;True|2024-11-21T13:48:31.7056264+08:00;True|2024-11-21T13:46:55.0891551+08:00;True|2024-11-21T13:44:05.5221110+08:00;True|2024-11-21T13:43:39.1385899+08:00;False|2024-11-21T13:43:19.9351488+08:00;True|2024-11-20T11:33:52.0324053+08:00;True|2024-11-20T11:20:58.4917889+08:00;True|2024-11-20T11:03:46.9552623+08:00;True|2024-11-20T10:45:10.9517109+08:00;False|2024-11-20T10:44:58.3221116+08:00;False|2024-11-19T15:39:27.3889104+08:00;True|2024-11-19T14:42:32.0854561+08:00;True|2024-11-19T14:19:19.6198070+08:00;True|2024-11-19T14:13:08.2003750+08:00;False|2024-11-19T14:12:15.5442850+08:00;True|2024-11-18T13:05:41.0455534+08:00;True|2024-11-18T11:05:30.2819404+08:00;True|2024-11-18T10:51:07.1852818+08:00;False|2024-11-18T10:50:21.5098527+08:00;True|2024-11-18T10:15:38.5429366+08:00;True|2024-11-18T10:00:51.0847524+08:00;True|2024-11-18T09:34:52.1772715+08:00;True|2024-11-18T09:27:23.6013754+08:00;False|2024-11-18T09:26:00.9323551+08:00;True|2024-11-15T11:20:51.7576376+08:00;True|2024-11-15T11:11:17.5580168+08:00;True|2024-11-15T11:03:58.4142996+08:00;True|2024-11-15T10:44:50.5207827+08:00;True|2024-11-15T10:10:05.5550418+08:00;True|2024-11-15T09:49:30.6631382+08:00;False|2024-11-15T09:47:05.3973379+08:00;True|2024-11-14T18:31:54.8247681+08:00;True|2024-11-14T17:14:56.3660185+08:00;True|2024-11-14T16:49:44.7526912+08:00;True|2024-11-14T16:49:09.3427608+08:00;True|2024-11-14T15:59:00.2572264+08:00;True|2024-11-14T11:21:03.5110818+08:00;True|2024-11-14T10:51:10.7864658+08:00;False|2024-11-14T10:50:55.5384248+08:00;True|2024-11-14T10:29:13.6760158+08:00;False|2024-11-14T10:28:09.8622863+08:00;True|2024-11-13T17:48:46.4827219+08:00;True|2024-11-13T17:45:13.0659280+08:00;True|2024-11-13T16:01:55.2278671+08:00;False|2024-11-13T16:01:03.0040446+08:00;True|2024-11-12T17:24:06.3763535+08:00;True|2024-11-12T17:21:51.8459552+08:00;True|2024-11-12T17:11:57.9239909+08:00;True|2024-11-12T17:09:04.4322824+08:00;True|2024-11-12T17:07:12.1839548+08:00;True|2024-11-12T17:04:27.4579152+08:00;True|2024-11-12T17:03:59.6843282+08:00;True|2024-11-12T16:40:44.0714862+08:00;True|2024-11-12T16:36:27.7792764+08:00;True|2024-11-12T16:32:36.5262040+08:00;False|2024-11-12T16:32:23.9550194+08:00;True|2024-11-12T10:58:16.1987697+08:00;False|2024-11-12T10:58:04.8469631+08:00;True|2024-11-11T13:40:53.2582255+08:00;True|2024-11-11T13:37:45.0401833+08:00;True|2024-11-11T12:35:13.2429166+08:00;True|2024-11-11T11:27:29.0530688+08:00;False|2024-11-11T11:27:12.2765506+08:00;True|2024-11-08T15:52:17.1278870+08:00;False|2024-11-08T15:52:04.4379380+08:00;True|2024-11-07T18:27:41.8163960+08:00;False|2024-11-07T18:27:30.6037983+08:00;True|2024-11-06T15:55:27.6450488+08:00;True|2024-11-06T15:54:13.5957004+08:00;True|2024-11-06T15:25:33.3862531+08:00;True|2024-11-06T13:33:57.8502278+08:00;False|2024-11-06T13:33:39.2337086+08:00;True|2024-11-06T11:33:12.6755239+08:00;True|2024-11-05T18:34:17.7048247+08:00;True|2024-11-05T18:30:08.5724471+08:00;True|2024-11-05T18:24:35.5372980+08:00;True|2024-11-05T18:06:29.7644779+08:00;True|2024-11-05T17:53:50.9554703+08:00;True|2024-11-05T17:50:05.6376900+08:00;True|2024-11-05T11:13:46.2906508+08:00;True|2024-11-05T10:35:55.5423834+08:00;False|2024-11-05T10:35:20.4104039+08:00;True|2024-11-01T10:22:05.7636122+08:00;False|2024-11-01T10:21:33.2954398+08:00;True|2024-10-31T20:03:37.9075888+08:00;True|2024-10-31T18:35:31.6618415+08:00;True|2024-10-31T18:34:56.2479021+08:00;True|2024-10-31T09:43:29.0841188+08:00;False|2024-10-31T09:43:04.8780818+08:00;True|2024-10-30T18:42:11.0523067+08:00;True|2024-10-30T18:07:05.5603627+08:00;True|2024-10-30T18:03:15.3516621+08:00;True|2024-10-30T17:58:14.3276504+08:00;False|2024-10-30T17:57:44.5353118+08:00;True|2024-10-30T17:47:41.2889491+08:00;True|2024-10-30T17:19:36.6172721+08:00;True|2024-10-30T17:10:00.4399703+08:00;False|2024-10-30T17:08:57.6500450+08:00;True|2024-10-29T16:58:15.6006676+08:00;True|2024-10-29T16:51:56.8406649+08:00;True|2024-10-29T16:05:48.4297695+08:00;True|2024-10-29T15:12:15.1522377+08:00;True|2024-10-29T15:10:51.8431754+08:00;True|2024-10-29T11:21:01.5660940+08:00;False|2024-10-29T11:20:33.3958980+08:00;True|2024-10-28T17:51:26.7156861+08:00;False|2024-10-28T17:50:41.4388196+08:00;True|2024-10-28T13:34:14.8764262+08:00;True|2024-10-28T12:44:27.2083620+08:00;False|2024-10-28T12:43:57.5942717+08:00;True|2024-10-25T11:49:47.9817458+08:00;True|2024-10-25T11:49:34.4754546+08:00;True|2024-10-25T09:59:35.6471379+08:00;True|2024-10-25T09:47:46.8035540+08:00;True|2024-10-25T09:25:57.7872618+08:00;False|2024-10-25T09:25:30.0950732+08:00;True|2024-10-24T20:39:06.1992535+08:00;False|2024-10-24T20:38:33.1009731+08:00;True|2024-10-24T11:17:46.9974483+08:00;False|2024-10-24T11:17:17.0925356+08:00;True|2024-10-23T19:16:25.5189930+08:00;True|2024-10-23T17:10:44.4267777+08:00;False|2024-10-23T17:10:10.2947971+08:00;True|2024-10-23T14:13:22.6901287+08:00;False|2024-10-23T14:12:24.3997100+08:00;True|2024-10-22T16:25:12.9514711+08:00;False|2024-10-22T16:24:42.9025167+08:00;True|2024-10-22T10:22:33.9932601+08:00;False|2024-10-22T10:22:05.3030308+08:00;True|2024-10-21T17:53:29.9552741+08:00;True|2024-10-21T16:37:31.4159544+08:00;True|2024-10-21T16:35:43.6207036+08:00;True|2024-10-21T16:00:05.5040651+08:00;False|2024-10-21T15:59:35.9279259+08:00;True|2024-10-21T12:06:42.5768961+08:00;False|2024-10-21T12:06:16.6344662+08:00;True|2024-10-18T10:44:02.6495536+08:00;True|2024-10-18T09:55:47.9769914+08:00;True|2024-10-18T09:47:46.6365831+08:00;True|2024-10-18T09:46:40.4036657+08:00;True|2024-10-18T09:44:25.4598960+08:00;True|2024-10-18T09:30:07.6972377+08:00;False|2024-10-18T09:28:18.9251743+08:00;True|2024-10-17T12:13:34.8639685+08:00;True|2024-10-17T12:02:26.5251711+08:00;False|2024-10-17T12:01:31.3822430+08:00;True|2024-10-17T11:49:09.2395208+08:00;False|2024-10-17T11:48:38.0189241+08:00;True|2024-10-16T19:35:29.2047484+08:00;False|2024-10-16T19:32:43.0637947+08:00;True|2024-10-16T11:27:13.1263407+08:00;False|2024-10-16T11:25:49.8688677+08:00;True|2024-10-15T18:26:50.9948482+08:00;False|2024-10-15T18:26:23.6998750+08:00;True|2024-08-26T14:17:37.8502046+08:00;False|2024-08-26T14:16:09.8501361+08:00;True|2024-08-22T11:12:48.4249984+08:00;</History> + <History>True|2024-12-30T01:32:44.3898729Z;True|2024-12-30T09:31:24.5771941+08:00;False|2024-12-30T09:30:52.4031391+08:00;True|2024-12-27T16:12:20.2836752+08:00;False|2024-12-27T16:11:04.6614343+08:00;True|2024-12-27T15:07:23.0750147+08:00;True|2024-12-27T15:04:52.7876532+08:00;True|2024-12-27T14:37:54.3154829+08:00;False|2024-12-27T14:37:26.9546174+08:00;True|2024-12-26T16:33:56.0452167+08:00;True|2024-12-26T16:29:21.4115458+08:00;True|2024-12-26T16:29:02.0242815+08:00;True|2024-12-26T15:17:24.7390981+08:00;False|2024-12-26T15:13:26.8863189+08:00;True|2024-12-26T15:06:35.4541902+08:00;True|2024-12-26T11:35:42.2760106+08:00;False|2024-12-26T11:35:08.9255789+08:00;True|2024-12-26T10:10:29.7487991+08:00;True|2024-12-26T09:27:40.2637311+08:00;False|2024-12-26T09:25:52.1339136+08:00;True|2024-12-24T15:11:48.9968778+08:00;True|2024-12-24T15:06:55.0283993+08:00;True|2024-12-24T14:36:29.6466740+08:00;True|2024-12-24T10:28:42.7489880+08:00;False|2024-12-24T10:28:08.6809715+08:00;True|2024-12-24T10:06:05.9449103+08:00;False|2024-12-24T10:05:32.8409161+08:00;True|2024-12-23T14:56:40.3416256+08:00;True|2024-12-23T14:50:50.2677378+08:00;True|2024-12-23T14:48:27.8169391+08:00;True|2024-12-23T14:45:25.5341474+08:00;True|2024-12-23T14:42:23.7825087+08:00;True|2024-12-23T14:35:53.8876449+08:00;True|2024-12-23T14:14:00.4257926+08:00;True|2024-12-23T11:10:54.5874876+08:00;True|2024-12-23T11:08:44.0250304+08:00;False|2024-12-23T11:08:18.5757850+08:00;True|2024-12-20T12:51:29.2354841+08:00;True|2024-12-20T12:46:13.7636932+08:00;False|2024-12-20T12:44:21.1473486+08:00;False|2024-12-20T12:44:06.5427106+08:00;True|2024-12-20T12:29:33.9971940+08:00;False|2024-12-20T12:29:01.0285205+08:00;True|2024-12-19T15:49:19.9906264+08:00;True|2024-12-19T14:55:54.3323405+08:00;True|2024-12-19T14:17:50.5086161+08:00;True|2024-12-19T14:08:16.0919011+08:00;True|2024-12-19T14:02:50.3092759+08:00;True|2024-12-19T13:54:41.2332165+08:00;False|2024-12-19T13:54:07.6973483+08:00;True|2024-12-19T09:34:54.5332110+08:00;True|2024-12-19T08:49:05.5690428+08:00;False|2024-12-19T08:48:51.0618113+08:00;True|2024-12-18T15:45:34.7174246+08:00;False|2024-12-18T15:45:10.3226822+08:00;True|2024-12-18T15:32:03.5983267+08:00;True|2024-12-18T15:31:20.1219502+08:00;True|2024-12-18T11:57:09.1595607+08:00;True|2024-12-18T11:13:37.4765697+08:00;True|2024-12-18T10:07:54.1294714+08:00;True|2024-12-18T10:04:16.0967342+08:00;False|2024-12-18T10:04:04.1561560+08:00;True|2024-12-16T17:07:07.3386872+08:00;True|2024-12-16T16:34:59.1101964+08:00;True|2024-12-16T16:19:07.9287470+08:00;False|2024-12-16T16:18:46.4617432+08:00;True|2024-12-13T18:06:11.0778539+08:00;True|2024-12-13T16:53:52.2283177+08:00;True|2024-12-13T16:23:15.9531944+08:00;True|2024-12-13T13:58:03.7464045+08:00;True|2024-12-13T10:40:33.9285602+08:00;True|2024-12-13T10:38:03.8494063+08:00;False|2024-12-13T10:37:52.4251132+08:00;True|2024-12-13T10:31:07.4994631+08:00;False|2024-12-13T10:30:40.8021885+08:00;True|2024-12-12T10:01:42.4944750+08:00;False|2024-12-12T10:01:15.7147977+08:00;True|2024-12-11T17:21:58.0453583+08:00;True|2024-12-11T10:59:15.3836831+08:00;True|2024-12-11T09:49:19.4060272+08:00;False|2024-12-11T09:48:51.7603525+08:00;True|2024-12-11T08:58:41.4567855+08:00;False|2024-12-11T08:58:09.2160433+08:00;True|2024-12-10T17:25:49.3068154+08:00;True|2024-12-10T17:21:30.0155027+08:00;True|2024-12-10T17:16:56.7587487+08:00;False|2024-12-10T17:16:34.7816611+08:00;True|2024-12-10T16:55:40.3777585+08:00;False|2024-12-10T16:55:13.2621448+08:00;False|2024-12-09T13:59:27.6362265+08:00;True|2024-12-06T16:55:30.6422980+08:00;True|2024-12-06T15:08:49.5834939+08:00;True|2024-12-06T14:31:56.0968616+08:00;False|2024-12-06T14:31:44.2264009+08:00;True|2024-12-06T13:59:52.8150929+08:00;False|2024-12-06T13:48:22.6073939+08:00;True|2024-12-05T17:33:27.9247467+08:00;True|2024-12-05T17:30:23.1740838+08:00;False|2024-12-05T17:30:03.9977311+08:00;True|2024-12-04T15:18:41.4963816+08:00;True|2024-12-04T15:16:45.1121101+08:00;True|2024-12-04T15:14:33.5954776+08:00;True|2024-12-04T15:12:27.2913137+08:00;True|2024-12-04T14:10:19.6190673+08:00;False|2024-12-04T14:10:02.0319713+08:00;True|2024-12-03T16:08:46.6721098+08:00;True|2024-12-03T15:16:04.1754554+08:00;True|2024-12-03T15:13:25.4927626+08:00;True|2024-12-03T14:55:09.4413291+08:00;True|2024-12-03T14:43:11.8243897+08:00;True|2024-12-03T14:29:16.1511932+08:00;True|2024-12-03T14:24:07.9561838+08:00;False|2024-12-03T14:23:55.1293602+08:00;True|2024-12-02T16:31:22.0404862+08:00;False|2024-12-02T16:28:53.1721961+08:00;True|2024-12-02T15:41:24.9462025+08:00;True|2024-12-02T14:12:12.9356193+08:00;False|2024-12-02T14:11:35.7159488+08:00;True|2024-12-02T10:59:31.5582757+08:00;True|2024-11-29T12:08:55.4868083+08:00;False|2024-11-29T12:08:37.0353185+08:00;True|2024-11-28T10:47:27.2071355+08:00;False|2024-11-28T10:47:13.6670955+08:00;True|2024-11-27T15:21:57.6747082+08:00;False|2024-11-27T15:20:07.2403056+08:00;True|2024-11-27T15:13:36.1461091+08:00;True|2024-11-27T14:34:35.5908753+08:00;False|2024-11-27T14:33:30.7118923+08:00;True|2024-11-26T15:16:44.1854927+08:00;True|2024-11-26T15:14:33.4021067+08:00;False|2024-11-26T15:14:07.9955135+08:00;True|2024-11-26T14:48:35.6408418+08:00;True|2024-11-26T14:45:00.7251556+08:00;True|2024-11-26T14:04:58.4232988+08:00;False|2024-11-26T14:04:28.1286675+08:00;True|2024-11-25T13:45:07.6935933+08:00;True|2024-11-25T13:43:59.0788650+08:00;False|2024-11-25T13:43:44.2225194+08:00;True|2024-11-25T08:54:05.5144014+08:00;False|2024-11-25T08:53:49.2284063+08:00;False|2024-11-22T09:53:13.7879664+08:00;True|2024-11-21T13:48:31.7056264+08:00;True|2024-11-21T13:46:55.0891551+08:00;True|2024-11-21T13:44:05.5221110+08:00;True|2024-11-21T13:43:39.1385899+08:00;False|2024-11-21T13:43:19.9351488+08:00;True|2024-11-20T11:33:52.0324053+08:00;True|2024-11-20T11:20:58.4917889+08:00;True|2024-11-20T11:03:46.9552623+08:00;True|2024-11-20T10:45:10.9517109+08:00;False|2024-11-20T10:44:58.3221116+08:00;False|2024-11-19T15:39:27.3889104+08:00;True|2024-11-19T14:42:32.0854561+08:00;True|2024-11-19T14:19:19.6198070+08:00;True|2024-11-19T14:13:08.2003750+08:00;False|2024-11-19T14:12:15.5442850+08:00;True|2024-11-18T13:05:41.0455534+08:00;True|2024-11-18T11:05:30.2819404+08:00;True|2024-11-18T10:51:07.1852818+08:00;False|2024-11-18T10:50:21.5098527+08:00;True|2024-11-18T10:15:38.5429366+08:00;True|2024-11-18T10:00:51.0847524+08:00;True|2024-11-18T09:34:52.1772715+08:00;True|2024-11-18T09:27:23.6013754+08:00;False|2024-11-18T09:26:00.9323551+08:00;True|2024-11-15T11:20:51.7576376+08:00;True|2024-11-15T11:11:17.5580168+08:00;True|2024-11-15T11:03:58.4142996+08:00;True|2024-11-15T10:44:50.5207827+08:00;True|2024-11-15T10:10:05.5550418+08:00;True|2024-11-15T09:49:30.6631382+08:00;False|2024-11-15T09:47:05.3973379+08:00;True|2024-11-14T18:31:54.8247681+08:00;True|2024-11-14T17:14:56.3660185+08:00;True|2024-11-14T16:49:44.7526912+08:00;True|2024-11-14T16:49:09.3427608+08:00;True|2024-11-14T15:59:00.2572264+08:00;True|2024-11-14T11:21:03.5110818+08:00;True|2024-11-14T10:51:10.7864658+08:00;False|2024-11-14T10:50:55.5384248+08:00;True|2024-11-14T10:29:13.6760158+08:00;False|2024-11-14T10:28:09.8622863+08:00;True|2024-11-13T17:48:46.4827219+08:00;True|2024-11-13T17:45:13.0659280+08:00;True|2024-11-13T16:01:55.2278671+08:00;False|2024-11-13T16:01:03.0040446+08:00;True|2024-11-12T17:24:06.3763535+08:00;True|2024-11-12T17:21:51.8459552+08:00;True|2024-11-12T17:11:57.9239909+08:00;True|2024-11-12T17:09:04.4322824+08:00;True|2024-11-12T17:07:12.1839548+08:00;True|2024-11-12T17:04:27.4579152+08:00;True|2024-11-12T17:03:59.6843282+08:00;True|2024-11-12T16:40:44.0714862+08:00;True|2024-11-12T16:36:27.7792764+08:00;True|2024-11-12T16:32:36.5262040+08:00;False|2024-11-12T16:32:23.9550194+08:00;True|2024-11-12T10:58:16.1987697+08:00;False|2024-11-12T10:58:04.8469631+08:00;True|2024-11-11T13:40:53.2582255+08:00;True|2024-11-11T13:37:45.0401833+08:00;True|2024-11-11T12:35:13.2429166+08:00;True|2024-11-11T11:27:29.0530688+08:00;False|2024-11-11T11:27:12.2765506+08:00;True|2024-11-08T15:52:17.1278870+08:00;False|2024-11-08T15:52:04.4379380+08:00;True|2024-11-07T18:27:41.8163960+08:00;False|2024-11-07T18:27:30.6037983+08:00;True|2024-11-06T15:55:27.6450488+08:00;True|2024-11-06T15:54:13.5957004+08:00;True|2024-11-06T15:25:33.3862531+08:00;True|2024-11-06T13:33:57.8502278+08:00;False|2024-11-06T13:33:39.2337086+08:00;True|2024-11-06T11:33:12.6755239+08:00;True|2024-11-05T18:34:17.7048247+08:00;True|2024-11-05T18:30:08.5724471+08:00;True|2024-11-05T18:24:35.5372980+08:00;True|2024-11-05T18:06:29.7644779+08:00;True|2024-11-05T17:53:50.9554703+08:00;True|2024-11-05T17:50:05.6376900+08:00;True|2024-11-05T11:13:46.2906508+08:00;True|2024-11-05T10:35:55.5423834+08:00;False|2024-11-05T10:35:20.4104039+08:00;True|2024-11-01T10:22:05.7636122+08:00;False|2024-11-01T10:21:33.2954398+08:00;True|2024-10-31T20:03:37.9075888+08:00;True|2024-10-31T18:35:31.6618415+08:00;True|2024-10-31T18:34:56.2479021+08:00;True|2024-10-31T09:43:29.0841188+08:00;False|2024-10-31T09:43:04.8780818+08:00;True|2024-10-30T18:42:11.0523067+08:00;True|2024-10-30T18:07:05.5603627+08:00;True|2024-10-30T18:03:15.3516621+08:00;True|2024-10-30T17:58:14.3276504+08:00;False|2024-10-30T17:57:44.5353118+08:00;True|2024-10-30T17:47:41.2889491+08:00;True|2024-10-30T17:19:36.6172721+08:00;True|2024-10-30T17:10:00.4399703+08:00;False|2024-10-30T17:08:57.6500450+08:00;True|2024-10-29T16:58:15.6006676+08:00;True|2024-10-29T16:51:56.8406649+08:00;True|2024-10-29T16:05:48.4297695+08:00;True|2024-10-29T15:12:15.1522377+08:00;True|2024-10-29T15:10:51.8431754+08:00;True|2024-10-29T11:21:01.5660940+08:00;False|2024-10-29T11:20:33.3958980+08:00;True|2024-10-28T17:51:26.7156861+08:00;False|2024-10-28T17:50:41.4388196+08:00;True|2024-10-28T13:34:14.8764262+08:00;True|2024-10-28T12:44:27.2083620+08:00;False|2024-10-28T12:43:57.5942717+08:00;True|2024-10-25T11:49:47.9817458+08:00;True|2024-10-25T11:49:34.4754546+08:00;True|2024-10-25T09:59:35.6471379+08:00;True|2024-10-25T09:47:46.8035540+08:00;True|2024-10-25T09:25:57.7872618+08:00;False|2024-10-25T09:25:30.0950732+08:00;True|2024-10-24T20:39:06.1992535+08:00;False|2024-10-24T20:38:33.1009731+08:00;True|2024-10-24T11:17:46.9974483+08:00;False|2024-10-24T11:17:17.0925356+08:00;True|2024-10-23T19:16:25.5189930+08:00;True|2024-10-23T17:10:44.4267777+08:00;False|2024-10-23T17:10:10.2947971+08:00;True|2024-10-23T14:13:22.6901287+08:00;False|2024-10-23T14:12:24.3997100+08:00;True|2024-10-22T16:25:12.9514711+08:00;False|2024-10-22T16:24:42.9025167+08:00;True|2024-10-22T10:22:33.9932601+08:00;False|2024-10-22T10:22:05.3030308+08:00;True|2024-10-21T17:53:29.9552741+08:00;True|2024-10-21T16:37:31.4159544+08:00;True|2024-10-21T16:35:43.6207036+08:00;True|2024-10-21T16:00:05.5040651+08:00;False|2024-10-21T15:59:35.9279259+08:00;True|2024-10-21T12:06:42.5768961+08:00;False|2024-10-21T12:06:16.6344662+08:00;True|2024-10-18T10:44:02.6495536+08:00;True|2024-10-18T09:55:47.9769914+08:00;True|2024-10-18T09:47:46.6365831+08:00;True|2024-10-18T09:46:40.4036657+08:00;True|2024-10-18T09:44:25.4598960+08:00;True|2024-10-18T09:30:07.6972377+08:00;False|2024-10-18T09:28:18.9251743+08:00;True|2024-10-17T12:13:34.8639685+08:00;True|2024-10-17T12:02:26.5251711+08:00;False|2024-10-17T12:01:31.3822430+08:00;True|2024-10-17T11:49:09.2395208+08:00;False|2024-10-17T11:48:38.0189241+08:00;True|2024-10-16T19:35:29.2047484+08:00;False|2024-10-16T19:32:43.0637947+08:00;True|2024-10-16T11:27:13.1263407+08:00;False|2024-10-16T11:25:49.8688677+08:00;True|2024-10-15T18:26:50.9948482+08:00;False|2024-10-15T18:26:23.6998750+08:00;True|2024-08-26T14:17:37.8502046+08:00;False|2024-08-26T14:16:09.8501361+08:00;True|2024-08-22T11:12:48.4249984+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>12/20/2024 12:29:12</publishTime> + <publishTime>12/30/2024 10:55:01</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>12/20/2024 12:29:12</publishTime> + <publishTime>12/30/2024 10:55:01</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>12/20/2024 12:29:11</publishTime> + <publishTime>12/30/2024 10:54:59</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>12/20/2024 12:29:11</publishTime> + <publishTime>12/30/2024 10:54:59</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> - <publishTime>12/13/2024 10:30:47</publishTime> + <publishTime>12/30/2024 09:31:01</publishTime> </File> <File Include="bin/DBUtility.pdb"> - <publishTime>12/13/2024 10:30:47</publishTime> + <publishTime>12/30/2024 09:31:01</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>12/20/2024 12:29:08</publishTime> + <publishTime>12/30/2024 10:54:56</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>12/20/2024 12:29:08</publishTime> + <publishTime>12/30/2024 10:54:56</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>05/25/2024 09:46:41</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> - <publishTime>12/13/2024 10:30:45</publishTime> + <publishTime>12/30/2024 09:30:59</publishTime> </File> <File Include="bin/Pub_Class.pdb"> - <publishTime>12/13/2024 10:30:45</publishTime> + <publishTime>12/30/2024 09:30:59</publishTime> </File> <File Include="bin/Pub_Control.dll"> - <publishTime>12/13/2024 10:30:46</publishTime> + <publishTime>12/30/2024 09:31:00</publishTime> </File> <File Include="bin/Pub_Control.pdb"> - <publishTime>12/13/2024 10:30:46</publishTime> + <publishTime>12/30/2024 09:31:00</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> - <publishTime>12/13/2024 10:30:46</publishTime> + <publishTime>12/30/2024 09:31:00</publishTime> </File> <File Include="bin/SQLHelper.pdb"> - <publishTime>12/13/2024 10:30:46</publishTime> + <publishTime>12/30/2024 09:31:00</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> - <publishTime>12/13/2024 08:23:31</publishTime> + <publishTime>12/30/2024 09:27:53</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> - <publishTime>12/13/2024 08:23:31</publishTime> + <publishTime>12/30/2024 09:27:53</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> - <publishTime>12/13/2024 10:12:31</publishTime> + <publishTime>12/30/2024 09:29:28</publishTime> </File> <File Include="bin/TopSdk.pdb"> - <publishTime>12/13/2024 10:12:32</publishTime> + <publishTime>12/30/2024 09:29:33</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>12/20/2024 12:51:14</publishTime> + <publishTime>12/30/2024 10:54:44</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>12/20/2024 12:51:14</publishTime> + <publishTime>12/30/2024 10:54:44</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> @@ -492,7 +492,7 @@ <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web.config"> - <publishTime>12/11/2024 09:49:18</publishTime> + <publishTime>12/30/2024 09:31:22</publishTime> </File> </ItemGroup> </Project> \ No newline at end of file diff --git a/WebAPI/Web.config b/WebAPI/Web.config index 77d3f96..352a956 100644 --- a/WebAPI/Web.config +++ b/WebAPI/Web.config @@ -35,7 +35,7 @@ <!--<add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/> --> <!--娴嬭瘯鏈嶅姟鍣�--> <!--<add key="surl" value="http://localhost:8082/webs/webservice1.asmx"/> 鏈湴--> <!--<add key="sUrl" value="http://192.168.110.57:81/WEBS/WebService1.asmx"/>--> <!--闄堥洴闈欐湰鍦伴厤缃�--> - <!--<add key="surl" value="http://localhost/webs-web/webservice1.asmx" />--> <!--缈佹稕娑涙湰鍦伴厤缃�--> + <add key="surl" value="http://localhost/webs-web/webservice1.asmx" /> <!--缈佹稕娑涙湰鍦伴厤缃�--> <!--<add key="sUrl" value="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx"/>涔濊彵--> <!--<add key="sUrl" value="http://61.130.182.102:18181/WEBSCS/WebService1.asmx"/>--><!--鏂帿灏�--> diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj index f1aa900..a6f23d6 100644 --- a/WebAPI/WebAPI.csproj +++ b/WebAPI/WebAPI.csproj @@ -830,6 +830,7 @@ <Compile Include="Models\QC_OutCompCheckBillSub_ValueGrid.cs" /> <Compile Include="Models\SBGL\SBBB\Sb_EquipMentCollectionTechParam_Temp.cs" /> <Compile Include="Models\SBGL\SBBB\Sb_EquipMentCollectionTechParam.cs" /> + <Compile Include="Models\Sc_StationOutBillSub_Sup.cs" /> <Compile Include="Models\鍩虹璧勬枡\Gy_ColorClass.cs" /> <Compile Include="Models\Employee.cs" /> <Compile Include="Models\Gy_UserCustomer.cs" /> diff --git a/WebAPI/WebAPI.csproj.user b/WebAPI/WebAPI.csproj.user index b04473a..09aa3a5 100644 --- a/WebAPI/WebAPI.csproj.user +++ b/WebAPI/WebAPI.csproj.user @@ -1,8 +1,12 @@ 锘�<?xml version="1.0" encoding="utf-8"?> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> - <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig> - <NameOfLastUsedPublishProfile>D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile1.pubxml</NameOfLastUsedPublishProfile> + <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> +<<<<<<< HEAD + <NameOfLastUsedPublishProfile>E:\鏅轰簯mes\mes\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile9.pubxml</NameOfLastUsedPublishProfile> +======= + <NameOfLastUsedPublishProfile>C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfilewtt.pubxml</NameOfLastUsedPublishProfile> +>>>>>>> 7d2677241200a3a1fd110e5d37864571c6d87f67 <UseIISExpress>true</UseIISExpress> <Use64BitIISExpress /> <IISExpressSSLPort /> diff --git a/WebAPI/bin.rar b/WebAPI/bin.rar new file mode 100644 index 0000000..59234d1 --- /dev/null +++ b/WebAPI/bin.rar Binary files differ diff --git a/WorkM/bin/Release/DBUtility.dll b/WorkM/bin/Release/DBUtility.dll index 5b73185..e149e84 100644 --- a/WorkM/bin/Release/DBUtility.dll +++ b/WorkM/bin/Release/DBUtility.dll Binary files differ diff --git a/WorkM/bin/Release/DBUtility.pdb b/WorkM/bin/Release/DBUtility.pdb index 5868f01..27f69f8 100644 --- a/WorkM/bin/Release/DBUtility.pdb +++ b/WorkM/bin/Release/DBUtility.pdb Binary files differ diff --git a/WorkM/bin/Release/Pub_Class.dll b/WorkM/bin/Release/Pub_Class.dll index 5a27deb..6ac1eea 100644 --- a/WorkM/bin/Release/Pub_Class.dll +++ b/WorkM/bin/Release/Pub_Class.dll Binary files differ diff --git a/WorkM/bin/Release/Pub_Class.pdb b/WorkM/bin/Release/Pub_Class.pdb index 52a6297..9a615cd 100644 --- a/WorkM/bin/Release/Pub_Class.pdb +++ b/WorkM/bin/Release/Pub_Class.pdb Binary files differ diff --git a/WorkM/bin/Release/Pub_Control.dll b/WorkM/bin/Release/Pub_Control.dll index 244bf7f..944241b 100644 --- a/WorkM/bin/Release/Pub_Control.dll +++ b/WorkM/bin/Release/Pub_Control.dll Binary files differ diff --git a/WorkM/bin/Release/Pub_Control.pdb b/WorkM/bin/Release/Pub_Control.pdb index edce0ca..4a1acf9 100644 --- a/WorkM/bin/Release/Pub_Control.pdb +++ b/WorkM/bin/Release/Pub_Control.pdb Binary files differ diff --git a/WorkM/bin/Release/SQLHelper.dll b/WorkM/bin/Release/SQLHelper.dll index 6fdd03e..a358039 100644 --- a/WorkM/bin/Release/SQLHelper.dll +++ b/WorkM/bin/Release/SQLHelper.dll Binary files differ diff --git a/WorkM/bin/Release/SQLHelper.pdb b/WorkM/bin/Release/SQLHelper.pdb index 5c090db..04f7af8 100644 --- a/WorkM/bin/Release/SQLHelper.pdb +++ b/WorkM/bin/Release/SQLHelper.pdb Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cache b/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cache new file mode 100644 index 0000000..b45cbe2 --- /dev/null +++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cache Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt b/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt index 65df6de..cf38133 100644 --- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt +++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt @@ -8,3 +8,22 @@ C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb +<<<<<<< HEAD +C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache +======= +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.dll +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.pdb +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll +D:\鏅轰簯杩堟�漒MES\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb +<<<<<<< HEAD +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.dll +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.pdb +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll +E:\鏅轰簯mes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb +======= +>>>>>>> 124dd32a34ced09ae87935e953dec6401d86f9ac +>>>>>>> 7d2677241200a3a1fd110e5d37864571c6d87f67 -- Gitblit v1.9.1