From 380127b84c3fa9cfc8c9753d8ffed5b20e927720 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期三, 16 十月 2024 15:49:00 +0800 Subject: [PATCH] 出门确认单 --- SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt | 1 APSM/bin/Release/BLL.dll | 0 BLL/bin/Release/DAL.dll | 0 PlanM/bin/Release/PlanM.dll | 0 APSM/bin/Release/BaseSet.dll | 0 BaseSet/bin/Release/BLL.pdb | 0 DAL/bin/Release/Model.dll | 0 APSM/bin/Release/BLL.pdb | 0 APSM/bin/Release/BaseSet.pdb | 0 APSM/bin/Release/WorkM.dll | 0 DAL/bin/Release/DAL.pdb | 0 BaseSet/bin/Release/Model.pdb | 0 BLL/bin/Release/Model.dll | 0 BLL/bin/Release/DAL.pdb | 0 BaseSet/bin/Release/BLL.dll | 0 BaseSet/bin/Release/Model.dll | 0 BLL/bin/Release/Model.pdb | 0 DAL/bin/Release/DAL.dll | 0 PlanM/bin/Release/BLL.dll | 0 BaseSet/bin/Release/BaseSet.dll | 0 DAL/bin/Release/Model.pdb | 0 sdk_dingding/TopSdk/bin/Debug/TopSdk.dll | 0 WarM/bin/Release/BLL.dll | 0 APSM/bin/Release/WarM.pdb | 0 WorkM/bin/Release/WorkM.pdb | 0 WarM/bin/Release/WarM.pdb | 0 WorkM/bin/Release/BLL.dll | 0 BaseSet/bin/Release/BaseSet.pdb | 0 Model/obj/Release/Model.pdb | 0 BLL/bin/Release/BLL.pdb | 0 PlanM/bin/Release/BLL.pdb | 0 WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs | 18 APSM/bin/Release/PlanM.dll | 0 APSM/bin/Release/DAL.dll | 0 APSM/bin/Release/WarM.dll | 0 sdk_dingding/TopSdk/obj/Debug/TopSdk.dll | 0 WarM/bin/Release/WarM.dll | 0 APSM/bin/Release/PlanM.pdb | 0 DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache | 0 WorkM/bin/Release/BLL.pdb | 0 WebAPI/ListModels.cs | 15 WorkM/bin/Release/Model.dll | 0 WorkM/bin/Release/WorkM.dll | 0 PlanM/bin/Release/Model.pdb | 0 sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt | 1 sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb | 0 DAL/DAL.csproj | 1 WarM/bin/Release/Model.pdb | 0 Model/销售管理/ClsXs_OutDoorBillSub.cs | 13 WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs | 1220 ++++++++++++++++++++++++++++++++++++++++ DAL/销售管理/ClsXs_OutDoorBill.cs | 441 ++++++++++++++ WebAPI/WebAPI.csproj | 1 WarM/bin/Release/Model.dll | 0 APSM/bin/Release/DAL.pdb | 0 PlanM/bin/Release/Model.dll | 0 Model/销售管理/ClsXs_OutDoorBillMain.cs | 22 PlanM/bin/Release/DAL.dll | 0 Model/Model.csproj | 2 WorkM/bin/Release/Model.pdb | 0 WarM/bin/Release/DAL.dll | 0 SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache | 0 WarM/bin/Release/DAL.pdb | 0 WorkM/bin/Release/WarM.pdb | 0 WarM/bin/Release/BLL.pdb | 0 BLL/bin/Release/BLL.dll | 0 BaseSet/bin/Release/DAL.pdb | 0 PlanM/bin/Release/DAL.pdb | 0 sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb | 0 Model/obj/Release/Model.dll | 0 WorkM/bin/Release/WarM.dll | 0 Model/obj/Release/Model.csproj.AssemblyReference.cache | 0 Model/bin/Release/Model.pdb | 0 BaseSet/bin/Release/DAL.dll | 0 APSM/bin/Release/Model.dll | 0 APSM/bin/Release/APSM.pdb | 0 PlanM/bin/Release/PlanM.pdb | 0 Model/bin/Release/Model.dll | 0 /dev/null | 0 APSM/bin/Release/WorkM.pdb | 0 APSM/bin/Release/Model.pdb | 0 WorkM/bin/Release/DAL.pdb | 0 WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user | 20 APSM/bin/Release/APSM.dll | 0 WorkM/bin/Release/DAL.dll | 0 84 files changed, 1,734 insertions(+), 21 deletions(-) diff --git a/APSM/bin/Release/APSM.dll b/APSM/bin/Release/APSM.dll index e4b16be..2f8d1c1 100644 --- a/APSM/bin/Release/APSM.dll +++ b/APSM/bin/Release/APSM.dll Binary files differ diff --git a/APSM/bin/Release/APSM.pdb b/APSM/bin/Release/APSM.pdb index 9fa341d..68341fc 100644 --- a/APSM/bin/Release/APSM.pdb +++ b/APSM/bin/Release/APSM.pdb Binary files differ diff --git a/APSM/bin/Release/BLL.dll b/APSM/bin/Release/BLL.dll index d527af4..d28d427 100644 --- a/APSM/bin/Release/BLL.dll +++ b/APSM/bin/Release/BLL.dll Binary files differ diff --git a/APSM/bin/Release/BLL.pdb b/APSM/bin/Release/BLL.pdb index 3cd3d4f..3f09c4c 100644 --- a/APSM/bin/Release/BLL.pdb +++ b/APSM/bin/Release/BLL.pdb Binary files differ diff --git a/APSM/bin/Release/BaseSet.dll b/APSM/bin/Release/BaseSet.dll index 7100fdd..27d97c6 100644 --- a/APSM/bin/Release/BaseSet.dll +++ b/APSM/bin/Release/BaseSet.dll Binary files differ diff --git a/APSM/bin/Release/BaseSet.pdb b/APSM/bin/Release/BaseSet.pdb index fd0f4c8..717bc0f 100644 --- a/APSM/bin/Release/BaseSet.pdb +++ b/APSM/bin/Release/BaseSet.pdb Binary files differ diff --git a/APSM/bin/Release/DAL.dll b/APSM/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/APSM/bin/Release/DAL.dll +++ b/APSM/bin/Release/DAL.dll Binary files differ diff --git a/APSM/bin/Release/DAL.pdb b/APSM/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/APSM/bin/Release/DAL.pdb +++ b/APSM/bin/Release/DAL.pdb Binary files differ diff --git a/APSM/bin/Release/Model.dll b/APSM/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/APSM/bin/Release/Model.dll +++ b/APSM/bin/Release/Model.dll Binary files differ diff --git a/APSM/bin/Release/Model.pdb b/APSM/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/APSM/bin/Release/Model.pdb +++ b/APSM/bin/Release/Model.pdb Binary files differ diff --git a/APSM/bin/Release/PlanM.dll b/APSM/bin/Release/PlanM.dll index 68e5efb..feb5b44 100644 --- a/APSM/bin/Release/PlanM.dll +++ b/APSM/bin/Release/PlanM.dll Binary files differ diff --git a/APSM/bin/Release/PlanM.pdb b/APSM/bin/Release/PlanM.pdb index c590eb1..6c9254b 100644 --- a/APSM/bin/Release/PlanM.pdb +++ b/APSM/bin/Release/PlanM.pdb Binary files differ diff --git a/APSM/bin/Release/WarM.dll b/APSM/bin/Release/WarM.dll index 521e315..388883d 100644 --- a/APSM/bin/Release/WarM.dll +++ b/APSM/bin/Release/WarM.dll Binary files differ diff --git a/APSM/bin/Release/WarM.pdb b/APSM/bin/Release/WarM.pdb index 38afaea..98d465b 100644 --- a/APSM/bin/Release/WarM.pdb +++ b/APSM/bin/Release/WarM.pdb Binary files differ diff --git a/APSM/bin/Release/WorkM.dll b/APSM/bin/Release/WorkM.dll index c715704..8acc8fa 100644 --- a/APSM/bin/Release/WorkM.dll +++ b/APSM/bin/Release/WorkM.dll Binary files differ diff --git a/APSM/bin/Release/WorkM.pdb b/APSM/bin/Release/WorkM.pdb index d29c979..4161282 100644 --- a/APSM/bin/Release/WorkM.pdb +++ b/APSM/bin/Release/WorkM.pdb Binary files differ diff --git a/BLL/bin/Release/BLL.dll b/BLL/bin/Release/BLL.dll index d527af4..d28d427 100644 --- a/BLL/bin/Release/BLL.dll +++ b/BLL/bin/Release/BLL.dll Binary files differ diff --git a/BLL/bin/Release/BLL.pdb b/BLL/bin/Release/BLL.pdb index 3cd3d4f..3f09c4c 100644 --- a/BLL/bin/Release/BLL.pdb +++ b/BLL/bin/Release/BLL.pdb Binary files differ diff --git a/BLL/bin/Release/DAL.dll b/BLL/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/BLL/bin/Release/DAL.dll +++ b/BLL/bin/Release/DAL.dll Binary files differ diff --git a/BLL/bin/Release/DAL.pdb b/BLL/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/BLL/bin/Release/DAL.pdb +++ b/BLL/bin/Release/DAL.pdb Binary files differ diff --git a/BLL/bin/Release/Model.dll b/BLL/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/BLL/bin/Release/Model.dll +++ b/BLL/bin/Release/Model.dll Binary files differ diff --git a/BLL/bin/Release/Model.pdb b/BLL/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/BLL/bin/Release/Model.pdb +++ b/BLL/bin/Release/Model.pdb Binary files differ diff --git a/BaseSet/bin/Release/BLL.dll b/BaseSet/bin/Release/BLL.dll index d527af4..d28d427 100644 --- a/BaseSet/bin/Release/BLL.dll +++ b/BaseSet/bin/Release/BLL.dll Binary files differ diff --git a/BaseSet/bin/Release/BLL.pdb b/BaseSet/bin/Release/BLL.pdb index 3cd3d4f..3f09c4c 100644 --- a/BaseSet/bin/Release/BLL.pdb +++ b/BaseSet/bin/Release/BLL.pdb Binary files differ diff --git a/BaseSet/bin/Release/BaseSet.dll b/BaseSet/bin/Release/BaseSet.dll index 7100fdd..27d97c6 100644 --- a/BaseSet/bin/Release/BaseSet.dll +++ b/BaseSet/bin/Release/BaseSet.dll Binary files differ diff --git a/BaseSet/bin/Release/BaseSet.pdb b/BaseSet/bin/Release/BaseSet.pdb index fd0f4c8..717bc0f 100644 --- a/BaseSet/bin/Release/BaseSet.pdb +++ b/BaseSet/bin/Release/BaseSet.pdb Binary files differ diff --git a/BaseSet/bin/Release/DAL.dll b/BaseSet/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/BaseSet/bin/Release/DAL.dll +++ b/BaseSet/bin/Release/DAL.dll Binary files differ diff --git a/BaseSet/bin/Release/DAL.pdb b/BaseSet/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/BaseSet/bin/Release/DAL.pdb +++ b/BaseSet/bin/Release/DAL.pdb Binary files differ diff --git a/BaseSet/bin/Release/Model.dll b/BaseSet/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/BaseSet/bin/Release/Model.dll +++ b/BaseSet/bin/Release/Model.dll Binary files differ diff --git a/BaseSet/bin/Release/Model.pdb b/BaseSet/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/BaseSet/bin/Release/Model.pdb +++ b/BaseSet/bin/Release/Model.pdb Binary files differ diff --git a/DAL/DAL.csproj b/DAL/DAL.csproj index 584e6f2..fb3b1e8 100644 --- a/DAL/DAL.csproj +++ b/DAL/DAL.csproj @@ -812,6 +812,7 @@ <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchQualityReport.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchReport.cs" /> <Compile Include="閿�鍞鐞哱ClsKf_ICStockBackBill.cs" /> + <Compile Include="閿�鍞鐞哱ClsXs_OutDoorBill.cs" /> <Compile Include="閿�鍞鐞哱ClsXs_SellOutChangeBill.cs" /> <Compile Include="閿�鍞鐞哱ClsXs_ReceivableBill.cs" /> <Compile Include="閿�鍞鐞哱ClsXs_OutDoorCheckBill.cs" /> diff --git a/DAL/bin/Release/DAL.dll b/DAL/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/DAL/bin/Release/DAL.dll +++ b/DAL/bin/Release/DAL.dll Binary files differ diff --git a/DAL/bin/Release/DAL.pdb b/DAL/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/DAL/bin/Release/DAL.pdb +++ b/DAL/bin/Release/DAL.pdb Binary files differ diff --git a/DAL/bin/Release/Model.dll b/DAL/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/DAL/bin/Release/Model.dll +++ b/DAL/bin/Release/Model.dll Binary files differ diff --git a/DAL/bin/Release/Model.pdb b/DAL/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/DAL/bin/Release/Model.pdb +++ b/DAL/bin/Release/Model.pdb Binary files differ diff --git "a/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBill.cs" "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBill.cs" new file mode 100644 index 0000000..789d070 --- /dev/null +++ "b/DAL/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBill.cs" @@ -0,0 +1,441 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Text; +using System.Data; + +namespace DAL +{ + public class ClsXs_OutDoorBill : DBUtility.ClsXt_BaseBill + { + public Model.ClsXs_OutDoorBillMain omodel = new Model.ClsXs_OutDoorBillMain(); + public List<Model.ClsXs_OutDoorBillSub> DetailColl = new List<Model.ClsXs_OutDoorBillSub>(); + + public ClsXs_OutDoorBill() + { + base.MvarItemKeySub = "Xs_OutDoorBillSub"; + base.MvarItemKeySub2 = ""; + base.MvarItemKeySub3 = ""; + base.MvarItemKeySub4 = ""; + base.MvarItemKey = "Xs_OutDoorBillMain"; + base.MvarReportTitle = "鍑洪棬纭鍗�"; + base.BillType = "1427"; + base.HBillSubType = "1427"; + + } + + #region 鍥哄畾浠g爜 + + ~ClsXs_OutDoorBill() + { + DetailColl = null; + } + + #endregion 鑷畾涔夋柟娉� + //淇敼鍗曟嵁 + public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) + { + try + { + //淇濆瓨鍓嶆帶鍒�========================================= + string HBillNote = ""; + DataSet ds = oCn.RunProcReturn("Exec h_p_Xs_OutDoorBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Xs_OutDoorBill_BeforeSaveCtrl"); + if (ds == null) + { + sReturn = "淇濆瓨鍓嶅垽鏂け璐ワ紒"; + return false; + } + if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") + { + sReturn = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); + return false; + } + //========================================================= + + oCn.BeginTran(); + string mainSql = "UpDate Xs_OutDoorBillMain set " + + " HBillSubType='" + omodel.HBillSubType + "'" + + ",HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��=============== + ",HDate='" + omodel.HDate + "'" + + ",HYear='" + omodel.HDate.Year + "'" + + ",HPeriod='" + omodel.HDate.Month + "'" + + ",HRemark='" + omodel.HRemark + "'" + + ",HUpDater='" + omodel.HUpDater + "'" + + ",HUpDateDate=getdate()" + + ",HStockOrgID=" + omodel.HStockOrgID + + //======================================== + ",HCusID=" + omodel.HCusID.ToString() + + ",HEmpID=" + omodel.HEmpID + "" + + ",HShipper='" + omodel.HShipper + "'" + + ",HCarNumber='" + omodel.HCarNumber + "'" + + ",HPhone='" + omodel.HPhone + "'" + + ",HOutReason='" + omodel.HOutReason + "'" + + ",HMaterName='" + omodel.HMaterName + "'" + + " where HInterID=" + lngBillKey.ToString(); + + oCn.RunProc(mainSql); + //鍒犻櫎鍏宠仈 + DeleteRelation(ref sReturn, lngBillKey); + //鍒犻櫎瀛愯〃 + DeleteBillSub(lngBillKey); + //鎻掑叆瀛愯〃 + omodel.HInterID = lngBillKey; + foreach (Model.ClsXs_OutDoorBillSub oSub in DetailColl) + { + string subSql = "Insert into Xs_OutDoorBillSub" + + "(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HQty,HPieceQty" + + ") " + + "values(" + + "" + omodel.HInterID + "" + + ",'" + omodel.HBillNo + "'" + + "," + oSub.HEntryID + "" + + ",'" + oSub.HRemark + "'" + + "," + oSub.HSourceInterID + "" + + "," + oSub.HSourceEntryID + "" + + ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) + "'" + + ",'" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) + "'" + + "," + oSub.HRelationQty + "" + + "," + oSub.HRelationMoney + "" + + "," + oSub.HMaterID + "" + + "," + oSub.HQty + "" + + "," + oSub.HPieceQty + "" + + ")"; + oCn.RunProc(subSql); + } + + //=========================淇濆瓨鍚庢帶鍒� + DataSet ds2 = oCn.RunProcReturn("h_p_Xs_OutDoorBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Xs_OutDoorBill_AfterSaveCtrl"); + if (ds2 == null) + { + sReturn = "淇濆瓨鍚庢帶鍒跺垽鏂け璐ワ紒"; + oCn.RollBack(); + return false; + } + if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") + { + sReturn = "淇濆瓨澶辫触2锛�" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); + oCn.RollBack(); + return false; + } + //============================================================================== + + //鍙嶅啓婧愬崟鍏宠仈鏁伴噺 + oCn.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBill " + omodel.HInterID.ToString()); + + sReturn = "淇敼鍗曟嵁鎴愬姛锛�"; + oCn.Commit(); + return true; + } + catch (Exception e) + { + sReturn = e.Message; + oCn.RollBack(); + throw (e); + } + } + //鏂板鍗曟嵁 + public override bool AddBill(ref string sReturn) + { + try + { + //淇濆瓨鍓嶆帶鍒�========================================= + string HBillNote = ""; + DataSet ds = oCn.RunProcReturn("Exec h_p_Xs_OutDoorBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Xs_OutDoorBill_BeforeSaveCtrl"); + if (ds == null) + { + sReturn = "淇濆瓨鍓嶅垽鏂け璐ワ紒"; + return false; + } + if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") + { + sReturn = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); + return false; + } + //========================================================= + + oCn.BeginTran(); + + //妫�鏌ヤ富琛ㄥ唴鐮佹槸鍚﹂噸澶嶏紝鑻ラ噸澶嶅垯閲嶆柊鐢熸垚骞剁户缁鏌ワ紝鐩村埌涓嶅啀閲嶅 + while (true) + { + ds = oCn.RunProcReturn("select * from Xs_OutDoorBillMain where HInterID = " + omodel.HInterID, "Xs_OutDoorBillMain"); + if (ds != null && ds.Tables[0].Rows.Count > 0) + { + omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); + } + else + { + break; + } + } + + //鎻掑叆涓昏〃 + string mainSql = "Insert Into Xs_OutDoorBillMain" + + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate,HBillStatus,HMaker,HMakeDate,HRemark,HStockOrgID" + + ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HMaterName) " + + "values(" + + "" + omodel.HDate.Year + "" + + "," + omodel.HDate.Month + "" + + ",'" + this.BillType + "'" + + ",'" + omodel.HBillSubType + "'" + + "," + omodel.HInterID + "" + + ",'" + omodel.HBillNo + "'" + + ",'" + omodel.HDate + "'" + + "," + "1" + "" + + ",'" + omodel.HMaker + "'" + + "," + "getdate()" + "" + + ",'" + omodel.HRemark + "'" + + "," + omodel.HStockOrgID + "" + + + "," + omodel.HCusID + "" + + "," + omodel.HEmpID + "" + + ",'" + omodel.HShipper + "'" + + ",'" + omodel.HCarNumber + "'" + + ",'" + omodel.HPhone + "'" + + ",'" + omodel.HOutReason + "'" + + ",'" + omodel.HMaterName + "'" + + ")"; + + oCn.RunProc(mainSql); + //鎻掑叆瀛愯〃 + foreach (Model.ClsXs_OutDoorBillSub oSub in DetailColl) + { + string subSql = "Insert into Xs_OutDoorBillSub" + + "(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HQty,HPieceQty" + + ") " + + "values(" + + "" + omodel.HInterID + "" + + ",'" + omodel.HBillNo + "'" + + "," + oSub.HEntryID + "" + + ",'" + oSub.HRemark + "'" + + "," + oSub.HSourceInterID + "" + + "," + oSub.HSourceEntryID + "" + + ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) + "'" + + ",'" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) + "'" + + "," + oSub.HRelationQty + "" + + "," + oSub.HRelationMoney + "" + + "," + oSub.HMaterID + "" + + "," + oSub.HQty + "" + + "," + oSub.HPieceQty + "" + + ")"; + oCn.RunProc(subSql); + } + + //=========================淇濆瓨鍚庢帶鍒� + DataSet ds2 = oCn.RunProcReturn("h_p_Xs_OutDoorBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Xs_OutDoorBill_AfterSaveCtrl"); + if (ds2 == null) + { + sReturn = "淇濆瓨鍚庢帶鍒跺垽鏂け璐ワ紒"; + oCn.RollBack(); + return false; + } + if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") + { + sReturn = "淇濆瓨澶辫触2锛�" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); + oCn.RollBack(); + return false; + } + //=============================================================== + + //鍙嶅啓婧愬崟鍏宠仈鏁伴噺 + oCn.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBill " + omodel.HInterID.ToString()); + + sReturn = "鏂板鍗曟嵁鎴愬姛锛�"; + oCn.Commit(); + return true; + } + catch (Exception e) + { + sReturn = e.Message; + oCn.RollBack(); + throw (e); + } + } + //鏄剧ず鍗曟嵁 + public override bool ShowBill(Int64 lngBillKey, ref string sReturn) + { + try + { + //鏌ヨ涓昏〃 + DataSet Ds; + Ds = oCn.RunProcReturn("Select * from Xs_OutDoorBillMain Where HInterID=" + lngBillKey.ToString(), "Xs_OutDoorBillMain"); + 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.HPrintQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPrintQty"]); + + + omodel.HStockOrgID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HStockOrgID"]); + //======================================================== + omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]); + omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); + omodel.HShipper = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HShipper"]); + omodel.HCarNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCarNumber"]); + omodel.HPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPhone"]); + omodel.HOutReason = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutReason"]); + omodel.HMaterName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterName"]); + omodel.HOutCheckMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckMan"]); + omodel.HOutCheckDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckDate"]); + // + + //寰幆 + DataSet DsSub; + DsSub = oCn.RunProcReturn("Select * from Xs_OutDoorBillSub Where HInterID=" + lngBillKey.ToString(), "Xs_OutDoorBillSub"); + DetailColl.Clear();//娓呯┖ + for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) + { + Model.ClsXs_OutDoorBillSub oSub = new Model.ClsXs_OutDoorBillSub(); + // 鍥哄畾璧嬪��=============================================== + oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); + oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); + oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBillNo_bak"]); + oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceInterID"]); + oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceEntryID"]); + 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.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]); + oSub.HPieceQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPieceQty"]); + + DetailColl.Add(oSub); + } + sReturn = "鏄剧ず鍗曟嵁鎴愬姛锛�"; + return true; + } + catch (Exception e) + { + sReturn = e.Message; + throw (e); + } + } + public void BackPrintQty(Int64 sInterID) + { + //鍥炲~鎵撳嵃娆℃暟 + oCn.RunProc("update " + this.MvarItemKey + " set HPrintQty=HPrintQty + 1 Where HInterID= " + sInterID.ToString()); + } + + //鍙戣捣瀹℃壒 + public bool startCheckFlow(Int64 lngBillKey, Int64 HCheckFlowID_select, ref string sReturn) + { + try + { + string HBillNo = ""; //鍗曟嵁鍙� + string HCheckFlowID = ""; //瀹℃壒娴両D + string HCheckItemNowID = ""; //褰撳墠瀹℃牳椤圭洰ID + string HCheckItemNextID = ""; //寰呭鏍搁」鐩甀D + + //鍒ゆ柇鏄惁宸茬粡鍙戣捣瀹℃壒 + string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "'"; + DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); + if (ds0 != null && ds0.Tables[0].Rows.Count > 0) + { + sReturn = "鍗曟嵁宸插彂璧峰鎵癸紝涓嶅彲閲嶅瀹℃壒锛�"; + return false; + } + + //鑾峰彇鍗曟嵁鏁版嵁 + string sql = "select * from " + this.MvarItemKey + " where HInterID = " + lngBillKey; + DataSet ds = oCn.RunProcReturn(sql, this.MvarItemKey); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + sReturn = "鍗曟嵁涓嶅瓨鍦紒"; + return false; + } + HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); + + //鑾峰彇鍗曟嵁绫诲瀷瀵瑰簲鐨勯粯璁ゅ鎵规祦 + string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " + + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + + "where a.HBillTypeID = '" + this.BillType + "' " + + "and a.HInterID = " + HCheckFlowID_select + " " + + "order by b.HFlowNo asc"; + DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain"); + if (ds1 == null || ds1.Tables[0].Rows.Count == 0) + { + sReturn = "榛樿瀹℃壒娴佷笉瀛樺湪锛�"; + return false; + } + + HCheckFlowID = ds1.Tables[0].Rows[0]["HInterID"].ToString(); + HCheckItemNowID = ds1.Tables[0].Rows[0]["HCheckItemID"].ToString(); + if (ds1.Tables[0].Rows.Count >= 2) + { + HCheckItemNextID = ds1.Tables[0].Rows[1]["HCheckItemID"].ToString(); + } + else + { + HCheckItemNextID = "0"; + } + + oCn.BeginTran(); + //澧炲姞 鍗曟嵁瀹℃壒鐘舵�佽〃 鏁版嵁 + for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) + { + string sql2 = "insert into Xt_BillCheckFlowStatus" + + "(HBillTypeID,HBillInterID,HBillNo,HCheckFlowID,HCheckItemID,HChecker,HCheckDate,HCheckNote) " + + "values(" + + "'" + this.BillType + "'," + + "" + lngBillKey + "," + + "'" + HBillNo + "'," + + "" + ds1.Tables[0].Rows[i]["HInterID"].ToString() + "," + + "" + ds1.Tables[0].Rows[i]["HCheckItemID"].ToString() + "," + + "" + "''" + "," + + "" + "''" + "," + + "" + "''" + "" + + ")"; + + oCn.RunProc(sql2); + } + + //鏇存柊涓昏〃 瀹℃壒娴� 鏁版嵁 + string sql3 = "update " + this.MvarItemKey + " set HCheckFlowID = " + HCheckFlowID + ",HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey; + oCn.RunProc(sql3); + + + oCn.Commit(); + + return true; + } + catch (Exception e) + { + sReturn += e.Message; + return false; + } + } + } + +} diff --git a/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache b/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache index 0f15254..f5e894a 100644 --- a/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache +++ b/DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cache Binary files differ diff --git a/Model/Model.csproj b/Model/Model.csproj index 9a9d60a..b0706b8 100644 --- a/Model/Model.csproj +++ b/Model/Model.csproj @@ -1036,6 +1036,8 @@ <Compile Include="閲戣澏鍗曟嵁\閿�鍞鐞哱ClsXs_SeOutStockBackBillSub_K3.cs" /> <Compile Include="閲戣澏鍗曟嵁\閿�鍞鐞哱ClsXs_SeOutStockBillMain_K3.cs" /> <Compile Include="閲戣澏鍗曟嵁\閿�鍞鐞哱ClsXs_SeOutStockBillSub_K3.cs" /> + <Compile Include="閿�鍞鐞哱ClsXs_OutDoorBillMain.cs" /> + <Compile Include="閿�鍞鐞哱ClsXs_OutDoorBillSub.cs" /> <Compile Include="閿�鍞鐞哱ClsXs_SellOutChangeBillSub.cs" /> <Compile Include="閿�鍞鐞哱ClsXs_SellOutChangeBillMain.cs" /> <Compile Include="閿�鍞鐞哱ClsKf_ICStockBackBillMain.cs" /> diff --git a/Model/bin/Release/Model.dll b/Model/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/Model/bin/Release/Model.dll +++ b/Model/bin/Release/Model.dll Binary files differ diff --git a/Model/bin/Release/Model.pdb b/Model/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/Model/bin/Release/Model.pdb +++ b/Model/bin/Release/Model.pdb Binary files differ diff --git a/Model/obj/Release/Model.csproj.AssemblyReference.cache b/Model/obj/Release/Model.csproj.AssemblyReference.cache index c17771a..f2f1252 100644 --- a/Model/obj/Release/Model.csproj.AssemblyReference.cache +++ b/Model/obj/Release/Model.csproj.AssemblyReference.cache Binary files differ diff --git a/Model/obj/Release/Model.dll b/Model/obj/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/Model/obj/Release/Model.dll +++ b/Model/obj/Release/Model.dll Binary files differ diff --git a/Model/obj/Release/Model.pdb b/Model/obj/Release/Model.pdb index 1270e49..13f78da 100644 --- a/Model/obj/Release/Model.pdb +++ b/Model/obj/Release/Model.pdb Binary files differ diff --git "a/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillMain.cs" "b/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillMain.cs" new file mode 100644 index 0000000..c243204 --- /dev/null +++ "b/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillMain.cs" @@ -0,0 +1,22 @@ +using System; +using System.Collections.Generic; +using System.Text; + +namespace Model +{ + public class ClsXs_OutDoorBillMain : DBUtility.ClsXt_BaseBillMain + { + public Int64 HEmpID; //业务员 + public Int64 HCusID;// int --客户 + public string HShipper; //varchar 司机 + public string HCarNumber; //车牌号 + public string HPhone; //联系电话 + public string HOutReason; //出门原因 + public string HMaterName; //装运何物 + public string HOutCheckMan; //出门确认人 + public string HOutCheckDate; //出门确认时间 + public Int64 HStockOrgID; + public Int64 HPrintQty; //打印次数 + + } +} diff --git "a/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillSub.cs" "b/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillSub.cs" new file mode 100644 index 0000000..651b1e5 --- /dev/null +++ "b/Model/\351\224\200\345\224\256\347\256\241\347\220\206/ClsXs_OutDoorBillSub.cs" @@ -0,0 +1,13 @@ +using System; +using System.Collections.Generic; +using System.Text; + +namespace Model +{ + public class ClsXs_OutDoorBillSub : DBUtility.ClsXt_BaseBillSub + { + public Int64 HMaterID; + public Double HQty; + public Int64 HPieceQty; + } +} diff --git a/PlanM/bin/Release/BLL.dll b/PlanM/bin/Release/BLL.dll index d527af4..d28d427 100644 --- a/PlanM/bin/Release/BLL.dll +++ b/PlanM/bin/Release/BLL.dll Binary files differ diff --git a/PlanM/bin/Release/BLL.pdb b/PlanM/bin/Release/BLL.pdb index 3cd3d4f..3f09c4c 100644 --- a/PlanM/bin/Release/BLL.pdb +++ b/PlanM/bin/Release/BLL.pdb Binary files differ diff --git a/PlanM/bin/Release/DAL.dll b/PlanM/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/PlanM/bin/Release/DAL.dll +++ b/PlanM/bin/Release/DAL.dll Binary files differ diff --git a/PlanM/bin/Release/DAL.pdb b/PlanM/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/PlanM/bin/Release/DAL.pdb +++ b/PlanM/bin/Release/DAL.pdb Binary files differ diff --git a/PlanM/bin/Release/Model.dll b/PlanM/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/PlanM/bin/Release/Model.dll +++ b/PlanM/bin/Release/Model.dll Binary files differ diff --git a/PlanM/bin/Release/Model.pdb b/PlanM/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/PlanM/bin/Release/Model.pdb +++ b/PlanM/bin/Release/Model.pdb Binary files differ diff --git a/PlanM/bin/Release/PlanM.dll b/PlanM/bin/Release/PlanM.dll index 68e5efb..feb5b44 100644 --- a/PlanM/bin/Release/PlanM.dll +++ b/PlanM/bin/Release/PlanM.dll Binary files differ diff --git a/PlanM/bin/Release/PlanM.pdb b/PlanM/bin/Release/PlanM.pdb index c590eb1..6c9254b 100644 --- a/PlanM/bin/Release/PlanM.pdb +++ b/PlanM/bin/Release/PlanM.pdb Binary files differ diff --git a/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache b/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache index 3840c7f..f5e894a 100644 --- a/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache +++ b/SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cache Binary files differ diff --git a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache deleted file mode 100644 index fea44e6..0000000 --- a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cache +++ /dev/null Binary files differ diff --git a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt index 7143ce1..a84a65c 100644 --- a/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt +++ b/SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt @@ -3,4 +3,3 @@ D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb -D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache diff --git a/WarM/bin/Release/BLL.dll b/WarM/bin/Release/BLL.dll index 229361e..d28d427 100644 --- a/WarM/bin/Release/BLL.dll +++ b/WarM/bin/Release/BLL.dll Binary files differ diff --git a/WarM/bin/Release/BLL.pdb b/WarM/bin/Release/BLL.pdb index c4d2cc1..3f09c4c 100644 --- a/WarM/bin/Release/BLL.pdb +++ b/WarM/bin/Release/BLL.pdb Binary files differ diff --git a/WarM/bin/Release/DAL.dll b/WarM/bin/Release/DAL.dll index f665d05..c344f61 100644 --- a/WarM/bin/Release/DAL.dll +++ b/WarM/bin/Release/DAL.dll Binary files differ diff --git a/WarM/bin/Release/DAL.pdb b/WarM/bin/Release/DAL.pdb index 2836e5c..e8f8e7c 100644 --- a/WarM/bin/Release/DAL.pdb +++ b/WarM/bin/Release/DAL.pdb Binary files differ diff --git a/WarM/bin/Release/Model.dll b/WarM/bin/Release/Model.dll index e84bd3f..5a9709c 100644 --- a/WarM/bin/Release/Model.dll +++ b/WarM/bin/Release/Model.dll Binary files differ diff --git a/WarM/bin/Release/Model.pdb b/WarM/bin/Release/Model.pdb index adc2540..13f78da 100644 --- a/WarM/bin/Release/Model.pdb +++ b/WarM/bin/Release/Model.pdb Binary files differ diff --git a/WarM/bin/Release/WarM.dll b/WarM/bin/Release/WarM.dll index bfb7762..388883d 100644 --- a/WarM/bin/Release/WarM.dll +++ b/WarM/bin/Release/WarM.dll Binary files differ diff --git a/WarM/bin/Release/WarM.pdb b/WarM/bin/Release/WarM.pdb index 5ee2370..98d465b 100644 --- a/WarM/bin/Release/WarM.pdb +++ b/WarM/bin/Release/WarM.pdb Binary files differ diff --git a/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs b/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs index f8d185c..5c0eccf 100644 --- a/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs +++ b/WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs @@ -1257,7 +1257,7 @@ { List<object> columnNameListSum = new List<object>(); List<object> columnNameList0 = new List<object>(); - //List<object> columnNameList1 = new List<object>(); + List<object> columnNameList1 = new List<object>(); //List<object> columnNameList2 = new List<object>(); //List<object> columnNameList3 = new List<object>(); //List<object> columnNameList4 = new List<object>(); @@ -1273,13 +1273,13 @@ columnNameList0.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 } - ////娣诲姞 鐢熶骇璁㈠崟 鍒楀悕 - //foreach (DataColumn col in ds.Tables[1].Columns) - //{ - // Type dataType = col.DataType; - // string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; - // columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 - //} + //娣诲姞 鐢熶骇璁㈠崟 鍒楀悕 + foreach (DataColumn col in ds.Tables[1].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } ////娣诲姞 鐗规壒鐢宠鍗� 鍒楀悕 //foreach (DataColumn col in ds.Tables[2].Columns) @@ -1306,7 +1306,7 @@ //} columnNameListSum.Add(columnNameList0); - //columnNameListSum.Add(columnNameList1); + columnNameListSum.Add(columnNameList1); //columnNameListSum.Add(columnNameList2); //columnNameListSum.Add(columnNameList3); //columnNameListSum.Add(columnNameList4); diff --git a/WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs b/WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs new file mode 100644 index 0000000..aad82df --- /dev/null +++ b/WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs @@ -0,0 +1,1220 @@ +锘縰sing Newtonsoft.Json; +using Newtonsoft.Json.Linq; +using Pub_Class; +using System; +using System.Collections; +using System.Collections.Generic; +using System.Data; +using System.Data.SqlClient; +using System.Net; +using System.Web.Http; +using System.Windows.Forms; +using WebAPI.Models; + +namespace WebAPI.Controllers +{ + //鍑洪棬纭鍗旵ontroller + public class Xs_OutDoorBillController : ApiController + { + //鑾峰彇绯荤粺鍙傛暟 + Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); + public DBUtility.ClsPub.Enum_BillStatus BillStatus; + public DAL.ClsXs_OutDoorBill BillOld = new DAL.ClsXs_OutDoorBill(); + public DAL.ClsXs_OutDoorBill BillNew0 = new DAL.ClsXs_OutDoorBill(); + + private json objJsonResult = new json(); + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + DataSet ds; + + #region 鍑洪棬纭鍗曞垪琛� 鏌ヨ + /// <summary> + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Xs_OutDoorBill/list")] + [HttpGet] + public object getXs_OutDoorBill(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_Query order by 鍗曟嵁鍙� desc", "h_v_Xs_OutDoorBillList_Query"); + } + else + { + string sql1 = "select * from h_v_Xs_OutDoorBillList_Query where 1 = 1 "; + string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� desc"; + ds = oCN.RunProcReturn(sql, "h_v_Xs_OutDoorBillList_Query"); + } + + //娣诲姞鍒楀悕 + 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 鍑洪棬纭鍗曞垪琛� 宸茬‘璁ゅ嚭闂ㄥ垪琛ㄦ煡璇� + /// <summary> + ///鍙傛暟锛歴tring sql銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Xs_OutDoorBill/list_checked")] + [HttpGet] + public object getXs_OutDoorBill_Checked(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBillList", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_Checked_Query order by 鍗曟嵁鍙� desc", "h_v_Xs_OutDoorBillList_Checked_Query"); + } + else + { + string sql1 = "select * from h_v_Xs_OutDoorBillList_Checked_Query where 1 = 1 "; + string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� desc"; + ds = oCN.RunProcReturn(sql, "h_v_Xs_OutDoorBillList_Checked_Query"); + } + + //娣诲姞鍒楀悕 + 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("Xs_OutDoorBill/SaveXs_OutDoorBill")] + [HttpPost] + public object SaveXs_OutDoorBill([FromBody] JObject msg) + { + var _value = msg["msg"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁 + string msg3 = sArray[1].ToString(); //瀛愯〃1鏁版嵁 + string refSav = sArray[2].ToString(); //鎿嶄綔鏂瑰紡 + string msg4 = sArray[3].ToString(); //鐢ㄦ埛 + + DBUtility.ClsPub.CurUserName = msg4; + + string UserName = ""; + string s = ""; + ListModels oListModels = new ListModels(); + try + { + //缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log_second("Xs_OutDoorCheckBill_Edit", 1, false, msg4)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); + List<Model.ClsXs_OutDoorBillMain> lsmain = new List<Model.ClsXs_OutDoorBillMain>(); + msg2 = msg2.Replace("\\", ""); + msg2 = msg2.Replace("\n", ""); //\n + lsmain = oListModels.getObjectByJson_Xs_OutDoorBillMain(msg2); + foreach (Model.ClsXs_OutDoorBillMain oItem in lsmain) + { + if (refSav == "Add") + { + //鍗曟嵁鍙锋槸鍚﹂噸澶� + if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鍙烽噸澶嶏紒涓嶅厑璁镐繚瀛橈紒"; + objJsonResult.data = 1; + return objJsonResult; + } + } + if (refSav == "Update") + { + if (BillOld.ShowBill(oItem.HInterID, ref s) == false) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹湁璇紒"; + objJsonResult.data = 1; + return objJsonResult; + } + //鍒ゆ柇鏄惁鍙紪杈� + if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹凡缁忚瀹℃牳锛屼笉鍏佽淇敼锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + if (BillOld.omodel.HBillStatus > 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹浜庝笉鍙紪杈戠姸鎬侊紝涓嶅厑璁镐慨鏀癸紒"; + objJsonResult.data = 1; + return objJsonResult; + } + if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = s + "锛屼笉鍏佽淇敼"; + objJsonResult.data = 1; + return objJsonResult; + } + } + + oItem.HMaker = msg4; + oItem.HUpDater = msg4; + + if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛佹病鏈夊崟鎹棩鏈燂紝鏃犳硶淇濆瓨锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + oBill.omodel = oItem; + } + + + //琛ㄤ綋鏁版嵁 + //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆� + msg3 = msg3.Substring(1, msg3.Length - 2); + msg3 = msg3.Replace("\\", ""); + msg3 = msg3.Replace("\n", ""); //\n + //msg2 = msg2.Replace("'", "鈥�"); + List<Model.ClsXs_OutDoorBillSub> ls = new List<Model.ClsXs_OutDoorBillSub>(); + ls = oListModels.getObjectByJson_Xs_OutDoorBillSub(msg3); + int i = 0; + foreach (Model.ClsXs_OutDoorBillSub oItemSub in ls) + { + i++; + oItemSub.HEntryID = i; + + //oItemSub.HCloseMan = ""; //琛屽叧闂� + //oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); + //oItemSub.HCloseType = false; //鍏抽棴绫诲瀷 + //oItemSub.HRemark = ""; //澶囨敞 + + //oItemSub.HSourceInterID = 0; // 婧愬崟涓诲唴鐮� + //oItemSub.HSourceEntryID = 0; //婧愬崟瀛愬唴鐮� + //oItemSub.HSourceBillNo = ""; //婧愬崟鍗曞彿 + //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷 + //oItemSub.HRelationQty = 0; //鍏宠仈鏁伴噺 + //oItemSub.HRelationMoney = 0; //鍏宠仈閲戦 + oBill.DetailColl.Add(oItemSub); + + } + + //杩涜 浼氳鏈熼棿 缁撹处 鐨勫垽鏂拰鎺у埗 + int sYear = 0; + int sPeriod = 0; + DateTime HDate = DateTime.Now; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) + { + objJsonResult.Message = s; + return objJsonResult; + } + + //淇濆瓨 + //淇濆瓨瀹屾瘯鍚庡鐞� + bool bResult; + if (refSav == "Add") + { + // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + } + else if (refSav == "Update") + { + bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); + } + else + { + bResult = false; + } + if (bResult) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; + //WebAPIController.Add_Log("閫佽揣鍗曚笅鎺�", UserName, "鐢熸垚閫佽揣鍗�"); + objJsonResult.data = 1; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = 1; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString(); + objJsonResult.data = 1; + return objJsonResult; + } + } + #endregion + + #region 鍑洪棬纭鍗� 缂栬緫椤甸潰鍒濆鍖� + [Route("Xs_OutDoorBill/cx")] + [HttpGet] + public object cx(long HInterID) + { + try + { + ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList where hmainid=" + HInterID, "h_v_Xs_OutDoorBillList"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "false锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鍑洪棬纭鍗� 鍒犻櫎 + /// <summary> + ///鍙傛暟锛歴tring HInterID銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Xs_OutDoorBill/delete")] + [HttpGet] + public object deleteXs_OutDoorBill(string HInterID, string user) + { + try + { + string s = ""; + + //鏌ョ湅鏉冮檺 + if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBill_Drop", 1, false, user)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒"; + objJsonResult.data = null; + return objJsonResult; + } + + if (HInterID == null || HInterID.Equals("")) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "HInterID涓嶈兘涓虹┖锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + if (BillOld.ShowBill(long.Parse(HInterID), ref s) == false) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹湁璇紒"; + objJsonResult.data = 1; + return objJsonResult; + } + //鍒ゆ柇鏄惁鍙紪杈� + if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹凡缁忚瀹℃牳锛屼笉鍏佽鍒犻櫎锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + + //鍒犻櫎鍓嶆帶鍒�========================================= + string sql1 = "exec h_p_Xs_OutDoorBill_BeforeDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; + ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeDelCtrl"); + if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:鍒犻櫎鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠$悊浜哄憳鑱旂郴"; + objJsonResult.data = null; + return objJsonResult; + } + + if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; + objJsonResult.data = null; + return objJsonResult; + } + //================================================================================== + + //杩涜 浼氳鏈熼棿 缁撹处 鐨勫垽鏂拰鎺у埗 + int sYear = 0; + int sPeriod = 0; + DateTime HDate = DateTime.Now; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) + { + objJsonResult.Message = s; + return objJsonResult; + } + + oCN.BeginTran(); + + //鍙嶅啓婧愬崟鍏宠仈鏁伴噺 + oCN.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBillDelete " + HInterID); + + oCN.RunProc("delete from Xs_OutDoorBillMain where HInterID = " + HInterID); + oCN.RunProc("delete from Xs_OutDoorBillSub where HInterID= " + HInterID); + + //鍒犻櫎鍚庢帶鍒�================================================================================== + string sql2 = "exec h_p_Xs_OutDoorBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; + ds = oCN.RunProcReturn(sql2, "h_p_Xs_OutDoorBill_AfterDelCtrl"); + if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) + { + s = "鍒犻櫎鍚庡垽鏂け璐ワ紝璇蜂笌缃戠粶绠$悊浜哄憳鑱旂郴"; + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + s; + objJsonResult.data = null; + oCN.RollBack(); + return objJsonResult; + } + if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") + { + s = ds.Tables[0].Rows[0]["HRemark"].ToString(); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鍒犻櫎澶辫触!鍘熷洜:" + s; + objJsonResult.data = null; + oCN.RollBack(); + return objJsonResult; + } + //============================================================================================== + + 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 = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鍑洪棬纭鍗� 瀹℃牳/鍙嶅鏍� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">瀹℃牳(0),鍙嶅鏍�(1)</param> + /// <param name="CurUserName">瀹℃牳浜�</param> + /// <returns></returns> + [Route("Xs_OutDoorBill/AuditXs_OutDoorBill")] + [HttpGet] + public object AuditXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Xs_OutDoorCheckBill_Check"; + 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.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + 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 (IsAudit == 0) //瀹℃牳鍒ゆ柇 + { + if (oBill.omodel.HChecker.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘鍐嶆瀹℃牳锛�"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅鏍稿垽鏂� + { + if (oBill.omodel.HChecker.Trim() == "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!"; + objJsonResult.data = null; + return objJsonResult; + } + } + + for(int i = 0; i < oBill.DetailColl.Count; i++) + { + //妫�鏌ユ簮鍗曟槸鍚﹀瓨鍦� + string sql = "select * from Kf_ICStockBillMain where HInterID = " + oBill.DetailColl[i].HSourceInterID; + ds = oCN.RunProcReturn(sql, "Kf_ICStockBillMain"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:婧愬崟[" + oBill.DetailColl[i].HSourceBillNo + "]鏁版嵁涓嶅瓨鍦紒"; + objJsonResult.data = null; + return objJsonResult; + } + else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "2") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:婧愬崟[" + oBill.DetailColl[i].HSourceBillNo + "]鏈浜庡凡瀹℃牳鐘舵��!"; + 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) //瀹℃牳鎻愪氦 + { + //杩涜 浼氳鏈熼棿 缁撹处 鐨勫垽鏂拰鎺у埗 + string s = ""; + int sYear = 0; + int sPeriod = 0; + DateTime HDate = DateTime.Now; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) + { + objJsonResult.Message = s; + return objJsonResult; + } + + //瀹℃牳鍓嶆帶鍒�========================================= + string sql1 = "exec h_p_Xs_OutDoorBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; + ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeCheckCtrl"); + if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:瀹℃牳鍓嶅垽鏂け璐ワ紝璇蜂笌缃戠粶绠$悊浜哄憳鑱旂郴"; + objJsonResult.data = null; + return objJsonResult; + } + + if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; + objJsonResult.data = null; + return objJsonResult; + } + //================================================================================== + + oCN.BeginTran(); + + //瀹℃牳鎻愪氦 + if (oBill.CheckBill(oCN,oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_OutDoorBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "瀹℃牳鎴愬姛"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + oCN.RollBack(); + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶅鏍告彁浜� + { + //杩涜 浼氳鏈熼棿 缁撹处 鐨勫垽鏂拰鎺у埗 + string s = ""; + int sYear = 0; + int sPeriod = 0; + DateTime HDate = DateTime.Now; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) + { + objJsonResult.Message = s; + return objJsonResult; + } + + //鍙嶅鏍稿墠鎺у埗========================================= + string sql1 = "exec h_p_Xs_OutDoorBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; + ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeUnCheckCtrl"); + if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:鍙嶅鏍稿墠鍒ゆ柇澶辫触锛岃涓庣綉缁滅鐞嗕汉鍛樿仈绯�"; + objJsonResult.data = null; + return objJsonResult; + + } + if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; + objJsonResult.data = null; + return objJsonResult; + } + //=========================================================== + + oCN.BeginTran(); + + //鍙嶅鏍告彁浜bandonCheck + if (oBill.AbandonCheck(oCN,oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_OutDoorBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) + { + oCN.Commit(); + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鍙嶅鏍告垚鍔�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍙嶅鏍稿け璐�!鍘熷洜:" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "瀹℃牳澶辫触鎴栬�呭弽瀹℃牳澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鍑洪棬纭鍗� 鍏抽棴/鍙嶅叧闂� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">鍏抽棴(0),鍙嶅叧闂�(1)</param> + /// <param name="CurUserName">鍏抽棴浜�</param> + /// <returns></returns> + [Route("Xs_OutDoorBill/CloseXs_OutDoorBill")] + [HttpGet] + public object CloseXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Xs_OutDoorCheckBill_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.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + 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 + + #region 鍑洪棬纭鍗� 浣滃簾/鍙嶄綔搴� + /// <summary> + /// </summary> + /// <param name="HInterID">鍗曟嵁ID</param> + /// <param name="IsAudit">浣滃簾(0),鍙嶄綔搴�(1)</param> + /// <param name="CurUserName">浣滃簾浜�</param> + /// <returns></returns> + [Route("Xs_OutDoorBill/DeleteXs_OutDoorBill")] + [HttpGet] + public object DeleteXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) + { + string ModRightNameCheck = "Xs_OutDoorCheckBill_Delete"; + 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.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //瀹炰緥鍖栧崟鎹搷浣滅被锛岀敤浜庤繘琛岀浉鍏虫搷浣� + + //閽堝闇�瑕佽繘琛岀殑鎿嶄綔锛屾楠屽綋鍓嶅崟鎹殑鐘舵�佹槸鍚︽敮鎸侀渶瑕佽繘琛岀殑鎿嶄綔 + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //鏍规嵁HInterID鑾峰彇璇ュ崟鎹殑鏁版嵁 + { + if (oBill.omodel.HChecker.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸插鏍�!涓嶈兘杩涜浣滃簾锛�"; + objJsonResult.data = null; + return objJsonResult; + } + if (IsAudit == 0) //浣滃簾鍒ゆ柇 + { + if (oBill.omodel.HDeleteMan.Trim() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸蹭綔搴�!涓嶈兘鍐嶄綔搴燂紒"; + objJsonResult.data = null; + return objJsonResult; + } + } + if (IsAudit == 1) //鍙嶄綔搴熷垽鏂� + { + if (oBill.omodel.HDeleteMan.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.Cancelltion(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.AbandonCancelltion(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 + + #region 鍑洪棬纭鍗曞垪琛� 纭鍑洪棬-鎾ら攢 + /// <summary> + ///鍙傛暟锛歴tring HInterID銆� + ///杩斿洖鍊硷細object銆� + /// </summary> + [Route("Xs_OutDoorBill/revoke")] + [HttpGet] + public object revokeXs_OutDoorBill(string HInterID,string HBillNo, string user) + { + try + { + oCN.BeginTran(); + + string sql = " update Xs_OutDoorBillMain set HOutCheckMan = '',HOutCheckDate = null where HInterID = " + HInterID; + oCN.RunProc(sql); + + //鍐欏叆鏃ュ織 + string WorkList = "鎾ら攢鍗曟嵁-鍑洪棬纭锛屽崟鎹彿锛�" + HBillNo; + string MvarReportTitle = BillNew0.MvarReportTitle; + string SystemName = "LMES-" + MvarReportTitle + "妯″潡"; + string ComputerName = SystemInformation.ComputerName; + string IPAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList[0].ToString(); + oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + + "(getdate(),'" + user + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','鎾ら攢')" + ); + + 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; + } + } + #endregion + + #region 鍑洪棬纭鍗� 鎵爜鍑洪棬纭-鑾峰彇鍗曟嵁淇℃伅 + [Route("Xs_OutDoorBill/cx_PDA")] + [HttpGet] + public object cx_PDA(string HBillNo,int HStockOrgID) + { + try + { + List<object> columnNameList = new List<object>(); + + ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_PDA where 鍗曟嵁鍙�='" + HBillNo + "' and HStockOrgID = " + HStockOrgID, "h_v_Xs_OutDoorBillList_PDA"); + + //娣诲姞鍒楀悕 + 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("Xs_OutDoorBill/OutDoorCheck_Xs_OutDoorBill")] + [HttpPost] + public object OutDoorCheck_Xs_OutDoorBill([FromBody] JObject msg) + { + var _value = msg["msg"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁 + string msg3 = sArray[1].ToString(); //瀛愯〃1鏁版嵁 + string msg4 = sArray[2].ToString(); //鐢ㄦ埛 + + DBUtility.ClsPub.CurUserName = msg4; + + string UserName = ""; + string s = ""; + ListModels oListModels = new ListModels(); + try + { + DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); + List<Model.ClsXs_OutDoorBillMain> lsmain = new List<Model.ClsXs_OutDoorBillMain>(); + msg2 = msg2.Replace("\\", ""); + msg2 = msg2.Replace("\n", ""); //\n + lsmain = oListModels.getObjectByJson_Xs_OutDoorBillMain(msg2); + + oCN.BeginTran(); + Model.ClsXs_OutDoorBillMain oItem = lsmain[0]; + if (BillOld.ShowBill(oItem.HInterID, ref s) == false) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹湁璇紒"; + objJsonResult.data = 1; + return objJsonResult; + } + //鍒ゆ柇鏄惁涓哄凡瀹℃牳鐘舵�� + if (BillOld.omodel.HBillStatus != 2) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎻愪氦澶辫触锛佹鍗曟嵁褰撳墠鐘舵�佷笉涓衡�滃凡瀹℃牳鈥濓紒"; + objJsonResult.data = 1; + return objJsonResult; + } + + if (BillOld.omodel.HOutCheckMan != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎻愪氦澶辫触锛佹鍗曟嵁宸茬粡鎻愪氦锛屾棤闇�閲嶅鎻愪氦锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + + string HShipper = oItem.HShipper; + string HCarNumber = oItem.HCarNumber; + string HPhone = oItem.HPhone; + string HOutReason = oItem.HOutReason; + string HMaterName = oItem.HMaterName; + string HRemark = oItem.HRemark; + string HOutCheckMan = msg4; + + string sql = "update Xs_OutDoorBillMain set " + + //"HShipper = '" + HShipper + "'" + + //",HCarNumber = '" + HCarNumber + "'" + + //",HPhone = '" + HPhone + "'" + + //",HOutReason='" + HOutReason + "'" + + //",HMaterName ='" + HMaterName + "'" + + //",HRemark = '" + HRemark + "'" + + "HOutCheckMan = '" + HOutCheckMan + "'" + + ",HOutCheckDate = getdate() " + + "where HInterID = " + oItem.HInterID; + oCN.RunProc(sql); + + //==============================鍐欏叆鏃ュ織 + string WorkList = "鍗曟嵁-鍑洪棬纭锛屽崟鎹彿锛�" + oItem.HBillNo; + string MvarReportTitle = BillNew0.MvarReportTitle; + string SystemName = "LMES-" + MvarReportTitle + "妯″潡"; + string ComputerName = SystemInformation.ComputerName; + string IPAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList[0].ToString(); + oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + + "(getdate(),'" + msg4 + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','鍑洪棬纭')" + ); + //======================================= + + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "鎻愪氦鎴愬姛锛�"; + objJsonResult.data = 1; + return objJsonResult; + } + catch (Exception e) + { + oCN.RollBack(); + 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/ListModels.cs b/WebAPI/ListModels.cs index dd4e323..2b33e21 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -4152,6 +4152,21 @@ } #endregion + #region 鍑洪棬纭鍗昣鏂� + public List<Model.ClsXs_OutDoorBillMain> getObjectByJson_Xs_OutDoorBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXs_OutDoorBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_OutDoorBillMain>>(jsonString); + return list; + } + public List<Model.ClsXs_OutDoorBillSub> getObjectByJson_Xs_OutDoorBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsXs_OutDoorBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_OutDoorBillSub>>(jsonString); + return list; + } + #endregion + #region 搴旀敹閫�娆惧崟 /// <summary> /// 搴旀敹閫�娆惧崟涓昏〃json diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user index ab6aa0a..726cb89 100644 --- a/WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user +++ b/WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user @@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> - <History>True|2024-10-11T08:49:55.1188159Z;True|2024-10-11T16:11:04.2021026+08:00;True|2024-10-11T15:48:50.7687290+08:00;True|2024-10-11T15:33:27.8527915+08:00;True|2024-10-11T14:49:01.6142514+08:00;False|2024-10-11T14:48:33.6149374+08:00;True|2024-10-11T13:50:33.4424142+08:00;False|2024-10-11T13:41:53.6580199+08:00;False|2024-10-11T13:41:39.5167380+08:00;False|2024-10-11T13:37:52.6531605+08:00;False|2024-10-11T13:37:11.7263329+08:00;</History> + <History>True|2024-10-16T03:57:09.2205029Z;True|2024-10-16T11:47:09.1175797+08:00;True|2024-10-16T11:12:45.2631759+08:00;False|2024-10-16T11:11:57.2236500+08:00;True|2024-10-15T16:20:02.9116206+08:00;True|2024-10-15T15:58:43.2926050+08:00;True|2024-10-15T15:42:21.7936803+08:00;True|2024-10-15T15:08:43.2300880+08:00;True|2024-10-15T14:57:53.1025144+08:00;True|2024-10-15T14:49:52.0203753+08:00;True|2024-10-15T13:43:28.4322672+08:00;True|2024-10-15T13:02:51.9833820+08:00;True|2024-10-15T10:35:13.3052884+08:00;True|2024-10-15T10:31:23.7280933+08:00;True|2024-10-15T10:16:45.0292893+08:00;True|2024-10-15T09:59:30.2256849+08:00;True|2024-10-15T09:53:37.7284098+08:00;True|2024-10-15T09:45:34.6928334+08:00;False|2024-10-15T09:45:08.0828173+08:00;True|2024-10-15T09:20:15.0444151+08:00;False|2024-10-15T09:18:15.4388995+08:00;True|2024-10-14T15:31:49.0978922+08:00;False|2024-10-14T15:31:08.3741419+08:00;True|2024-10-14T15:09:44.3508500+08:00;True|2024-10-14T14:45:34.5430843+08:00;True|2024-10-14T14:04:11.8258435+08:00;True|2024-10-14T13:54:24.2353356+08:00;True|2024-10-14T13:48:16.0893349+08:00;False|2024-10-14T13:47:57.1909782+08:00;True|2024-10-14T11:12:14.9583385+08:00;False|2024-10-14T11:11:21.0058133+08:00;True|2024-10-11T16:49:55.1188159+08:00;True|2024-10-11T16:11:04.2021026+08:00;True|2024-10-11T15:48:50.7687290+08:00;True|2024-10-11T15:33:27.8527915+08:00;True|2024-10-11T14:49:01.6142514+08:00;False|2024-10-11T14:48:33.6149374+08:00;True|2024-10-11T13:50:33.4424142+08:00;False|2024-10-11T13:41:53.6580199+08:00;False|2024-10-11T13:41:39.5167380+08:00;False|2024-10-11T13:37:52.6531605+08:00;False|2024-10-11T13:37:11.7263329+08:00;</History> <_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,19 +45,19 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> - <publishTime>10/11/2024 13:37:29</publishTime> + <publishTime>10/16/2024 11:46:33</publishTime> </File> <File Include="bin/BLL.pdb"> - <publishTime>10/11/2024 13:37:29</publishTime> + <publishTime>10/16/2024 11:46:33</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> - <publishTime>10/11/2024 13:37:28</publishTime> + <publishTime>10/16/2024 11:46:31</publishTime> </File> <File Include="bin/DAL.pdb"> - <publishTime>10/11/2024 13:37:28</publishTime> + <publishTime>10/16/2024 11:46:31</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> - <publishTime>10/11/2024 13:37:24</publishTime> + <publishTime>10/16/2024 11:46:26</publishTime> </File> <File Include="bin/Model.pdb"> - <publishTime>10/11/2024 13:37:24</publishTime> + <publishTime>10/16/2024 11:46:26</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/06/2023 15:57:02</publishTime> @@ -294,13 +294,13 @@ <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> - <publishTime>10/11/2024 16:49:47</publishTime> + <publishTime>10/16/2024 11:47:03</publishTime> </File> <File Include="bin/WebAPI.pdb"> - <publishTime>10/11/2024 16:49:47</publishTime> + <publishTime>10/16/2024 11:47:03</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> - <publishTime>10/11/2024 16:49:54</publishTime> + <publishTime>10/16/2024 11:47:08</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj index a86231e..cb42ec2 100644 --- a/WebAPI/WebAPI.csproj +++ b/WebAPI/WebAPI.csproj @@ -442,6 +442,7 @@ <Compile Include="Controllers\SBGL\SBBB\Sb_EquipMentCollectionTechParamController.cs" /> <Compile Include="Controllers\SBGL\SBBB\Sb_EquipMentCollectionTechParam_TempController.cs" /> <Compile Include="Controllers\SCGL\Sc_ProductionReportsController.cs" /> + <Compile Include="Controllers\XSGL\Xs_OutDoorBillController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectBasisController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectMethodController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_QualityController.cs" /> diff --git a/WorkM/bin/Release/BLL.dll b/WorkM/bin/Release/BLL.dll index d527af4..d28d427 100644 --- a/WorkM/bin/Release/BLL.dll +++ b/WorkM/bin/Release/BLL.dll Binary files differ diff --git a/WorkM/bin/Release/BLL.pdb b/WorkM/bin/Release/BLL.pdb index 3cd3d4f..3f09c4c 100644 --- a/WorkM/bin/Release/BLL.pdb +++ b/WorkM/bin/Release/BLL.pdb Binary files differ diff --git a/WorkM/bin/Release/DAL.dll b/WorkM/bin/Release/DAL.dll index 035e49e..c344f61 100644 --- a/WorkM/bin/Release/DAL.dll +++ b/WorkM/bin/Release/DAL.dll Binary files differ diff --git a/WorkM/bin/Release/DAL.pdb b/WorkM/bin/Release/DAL.pdb index 4605e8b..e8f8e7c 100644 --- a/WorkM/bin/Release/DAL.pdb +++ b/WorkM/bin/Release/DAL.pdb Binary files differ diff --git a/WorkM/bin/Release/Model.dll b/WorkM/bin/Release/Model.dll index ef97a6c..5a9709c 100644 --- a/WorkM/bin/Release/Model.dll +++ b/WorkM/bin/Release/Model.dll Binary files differ diff --git a/WorkM/bin/Release/Model.pdb b/WorkM/bin/Release/Model.pdb index 1270e49..13f78da 100644 --- a/WorkM/bin/Release/Model.pdb +++ b/WorkM/bin/Release/Model.pdb Binary files differ diff --git a/WorkM/bin/Release/WarM.dll b/WorkM/bin/Release/WarM.dll index 521e315..388883d 100644 --- a/WorkM/bin/Release/WarM.dll +++ b/WorkM/bin/Release/WarM.dll Binary files differ diff --git a/WorkM/bin/Release/WarM.pdb b/WorkM/bin/Release/WarM.pdb index 38afaea..98d465b 100644 --- a/WorkM/bin/Release/WarM.pdb +++ b/WorkM/bin/Release/WarM.pdb Binary files differ diff --git a/WorkM/bin/Release/WorkM.dll b/WorkM/bin/Release/WorkM.dll index c715704..8acc8fa 100644 --- a/WorkM/bin/Release/WorkM.dll +++ b/WorkM/bin/Release/WorkM.dll Binary files differ diff --git a/WorkM/bin/Release/WorkM.pdb b/WorkM/bin/Release/WorkM.pdb index d29c979..4161282 100644 --- a/WorkM/bin/Release/WorkM.pdb +++ b/WorkM/bin/Release/WorkM.pdb Binary files differ diff --git a/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll b/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll index 041e9d1..41aea73 100644 --- a/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll +++ b/sdk_dingding/TopSdk/bin/Debug/TopSdk.dll Binary files differ diff --git a/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb b/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb index 6a3651b..01196f2 100644 --- a/sdk_dingding/TopSdk/bin/Debug/TopSdk.pdb +++ b/sdk_dingding/TopSdk/bin/Debug/TopSdk.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 deleted file mode 100644 index b3a6f35..0000000 --- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cache +++ /dev/null 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 716910b..6fe3b2c 100644 --- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt +++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt @@ -21,4 +21,3 @@ D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb -D:\缃戠珯鍙戝竷\鍚庣浠g爜\MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll b/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll index 041e9d1..41aea73 100644 --- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll +++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.dll Binary files differ diff --git a/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb b/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb index 6a3651b..01196f2 100644 --- a/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb +++ b/sdk_dingding/TopSdk/obj/Debug/TopSdk.pdb Binary files differ -- Gitblit v1.9.1