From 1505f2bf41f2e4c4a92fe087bbf1537432c70cfd Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期五, 24 三月 2023 09:57:44 +0800 Subject: [PATCH] 工序派工;工序进出站 --- Model/车间管理/ClsSc_ProcExchSendWorkBillMain.cs | 15 WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs | 2 Model/车间管理/ClsSc_ProcExchSendWorkBillSub.cs | 29 + WebAPI/ListModels.cs | 18 DAL/DAL.csproj | 1 DAL/车间管理/ClsSc_ProcExchSendWorkBill.cs | 232 +++++++++++ WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | 17 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 177 ++++---- WebAPI/Controllers/CJGL/Sc_ProcExchSendWorkBillController.cs | 270 ++++++++++++ Model/Model.csproj | 2 WebAPI/Controllers/CJGL/Sc_ProcessSendWorkController.cs | 472 +++++++++++----------- WebAPI/WebAPI.csproj | 2 12 files changed, 907 insertions(+), 330 deletions(-) diff --git a/DAL/DAL.csproj b/DAL/DAL.csproj index 366af25..99a7f4d 100644 --- a/DAL/DAL.csproj +++ b/DAL/DAL.csproj @@ -623,6 +623,7 @@ <Compile Include="璐ㄦ绠$悊\ClsQC_ProcessCheckBill.cs" /> <Compile Include="璐ㄦ绠$悊\ClsQC_ProdReportCheckBill.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchRecordBackBill.cs" /> + <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchSendWorkBill.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchWorkBackBill.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_CutMaterProcExchBill.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_MaterBackBill.cs" /> diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBill.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBill.cs" new file mode 100644 index 0000000..9994a36 --- /dev/null +++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBill.cs" @@ -0,0 +1,232 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Text; +using System.Data; + +namespace DAL +{ + public class ClsSc_ProcExchSendWorkBill : DBUtility.ClsXt_BaseBill + { + public Model.ClsSc_ProcExchSendWorkBillMain omodel = new Model.ClsSc_ProcExchSendWorkBillMain(); + public List<Model.ClsSc_ProcExchSendWorkBillSub> DetailColl = new List<Model.ClsSc_ProcExchSendWorkBillSub>(); + + public ClsSc_ProcExchSendWorkBill() + { + base.MvarItemKeySub = "Sc_ProcExchSendWorkBillSub"; + base.MvarItemKeySub2 = ""; + base.MvarItemKeySub3 = ""; + base.MvarItemKeySub4 = ""; + base.MvarItemKey = "Sc_ProcExchSendWorkBillMain"; + base.MvarReportTitle = "宸ュ簭娴佽浆鍗℃淳宸ュ崟"; + base.BillType = "3798"; + base.HBillSubType = "3798"; + + } + + #region 鍥哄畾浠g爜 + + ~ClsSc_ProcExchSendWorkBill() + { + DetailColl = null; + } + + #endregion 鑷畾涔夋柟娉� + //淇敼鍗曟嵁 + public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) + { + try + { + oCn.BeginTran(); + //鏇存柊涓昏〃 + oCn.RunProc("UpDate Sc_ProcExchSendWorkBillMain set " + + " HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��=============== + ",HDate='" + omodel.HDate + "'" + + ",HYear='" + omodel.HYear.ToString() + "'" + + ",HPeriod='" + omodel.HPeriod.ToString() + "'" + + ",HRemark='" + omodel.HRemark + "'" + + ",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" + + ",HUpDateDate=getdate()" + + //======================================== + ",HExplanation='" + omodel.HExplanation + "'" + + ",HWorkShopID='" + omodel.HWorkShopID + "'" + + ",HPRDORGID='" + omodel.HPRDORGID + "'" + + " where HInterID=" + lngBillKey.ToString()); + //鍒犻櫎鍏宠仈 + DeleteRelation(ref sReturn, lngBillKey); + //鍒犻櫎瀛愯〃 + DeleteBillSub(lngBillKey); + //鎻掑叆瀛愯〃 + omodel.HInterID = lngBillKey; + DataSet Ds; + foreach (Model.ClsSc_ProcExchSendWorkBillSub oSub in DetailColl) + { + oCn.RunProc("Insert into Sc_ProcExchSendWorkBillSub " + + " (HInterID,HEntryID,HBillNo_bak," + + "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + + "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + + "HProcNo,HMaterID,HUnitID,HPlanQty,HQty" + + ",HSourceID,HWorkerID,HWorkerNumber,HGroupID,HGroupNumber,HBatchNo,HPlanBeginDate" + + ",HPlanEndDate,HWWOrderInterID,HWWOrderEntryID,HWWOrderBillNo,HICMOInterID,HICMOBillNo" + + ",HICMOEntryID" + + ") values(" + + omodel.HInterID + "," + oSub.HEntryID + ",'" + omodel.HBillNo + "'" + + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + 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.HProcNo.ToString() + "," + oSub.HMaterID + "," + oSub.HUnitID + ",'" + oSub.HPlanQty + "'," + oSub.HQty + "," + oSub.HSourceID + + "," + oSub.HWorkerID + ",'" + oSub.HWorkerNumber + "'," + oSub.HGroupID + ",'" + oSub.HGroupNumber + "','" + oSub.HBatchNo + "','" + oSub.HPlanBeginDate + "','" + oSub.HPlanEndDate + + "'," + oSub.HWWOrderInterID + "," + oSub.HWWOrderEntryID + ",'" + oSub.HWWOrderBillNo + "'," + oSub.HICMOInterID + ",'" + oSub.HICMOBillNo + "'," + oSub.HICMOEntryID + ") "); + } + + + sReturn = "淇敼鍗曟嵁鎴愬姛锛�"; + oCn.Commit(); + return true; + } + catch (Exception e) + { + sReturn = e.Message; + oCn.RollBack(); + throw (e); + } + } + //鏂板鍗曟嵁 + public override bool AddBill(ref string sReturn) + { + try + { + //寰楀埌mainid + omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); + //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙� + oCn.BeginTran(); + //涓昏〃 + oCn.RunProc("Insert Into Sc_ProcExchSendWorkBillMain " + + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HMaker,HMakeDate" + + ",HRemark,HBackRemark,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo" + + ",HPrintQty,HWorkShopID,HExplanation,HInnerBillNo,HPRDORGID" + + ") " + + " values(" + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + this.BillType + "','" + omodel.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HDate + "','" + omodel.HBillNo + "'," + omodel.HBillStatus + ",'" + omodel.HMaker + "'," + "getdate()" + + ",'" + omodel.HRemark + "','" + omodel.HBackRemark + "','" + omodel.HMainSourceBillType + "'," + omodel.HMainSourceInterID + + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "'," + omodel.HPrintQty + "," + omodel.HWorkShopID + ",'" + omodel.HExplanation + + "','" + omodel.HInnerBillNo + "'," + omodel.HPRDORGID + ") "); + //鎻掑叆瀛愯〃 + DataSet Ds; + foreach (Model.ClsSc_ProcExchSendWorkBillSub oSub in DetailColl) + { + oCn.RunProc("Insert into Sc_ProcExchSendWorkBillSub " + + " (HInterID,HEntryID,HBillNo_bak," + + "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + + "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + + "HProcNo,HMaterID,HUnitID,HPlanQty,HQty" + + ",HSourceID,HWorkerID,HWorkerNumber,HGroupID,HGroupNumber,HBatchNo,HPlanBeginDate" + + ",HPlanEndDate,HWWOrderInterID,HWWOrderEntryID,HWWOrderBillNo,HICMOInterID,HICMOBillNo" + + ",HICMOEntryID" + + ") values("+ + omodel.HInterID + "," + oSub.HEntryID + ",'" + omodel.HBillNo + "'" + + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + 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.HProcNo.ToString() + "," + oSub.HMaterID + "," + oSub.HUnitID + ",'" + oSub.HPlanQty + "'," + oSub.HQty + "," + oSub.HSourceID + + "," + oSub.HWorkerID + ",'" + oSub.HWorkerNumber + "'," + oSub.HGroupID + ",'" + oSub.HGroupNumber + "','" + oSub.HBatchNo + "','" + oSub.HPlanBeginDate + "','" + oSub.HPlanEndDate + + "'," + oSub.HWWOrderInterID + "," + oSub.HWWOrderEntryID + ",'" + oSub.HWWOrderBillNo + "'," + oSub.HICMOInterID + ",'" + oSub.HICMOBillNo + "'," + oSub.HICMOEntryID + ") "); + } + // + + + // + 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 Sc_ProcExchSendWorkBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_ProcExchSendWorkBillMain"); + if (Ds.Tables[0].Rows.Count == 0) + { + sReturn = "鍗曟嵁鏈壘鍒帮紒"; + return false; + } + //鍥哄畾璧嬪��=========================================== + omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); + omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim(); + omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]); + omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]); + omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]); + 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.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]); + omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]); + omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]); + 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.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.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim(); + omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim(); + omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim(); + omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim(); + //======================================================== + //== + omodel.HExplanation = Ds.Tables[0].Rows[0]["HExplanation"].ToString().Trim(); + omodel.HInnerBillNo = Ds.Tables[0].Rows[0]["HInnerBillNo"].ToString().Trim(); + // + omodel.HMainSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceInterID"]); + omodel.HMainSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceEntryID"]); + omodel.HMainSourceBillNo = Ds.Tables[0].Rows[0]["HMainSourceBillNo"].ToString().Trim(); + //寰幆 + DataSet DsSub; + DsSub = oCn.RunProcReturn("Select * from Sc_ProcExchSendWorkBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Sc_ProcExchSendWorkBillSub"); + DetailColl.Clear();//娓呯┖ + for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) + { + Model.ClsSc_ProcExchSendWorkBillSub oSub = new Model.ClsSc_ProcExchSendWorkBillSub(); + // 鍥哄畾璧嬪��=============================================== + oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); + oSub.HBillNo_bak = DsSub.Tables[0].Rows[i]["HBillNo_bak"].ToString().Trim(); + oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); + 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.HICMOInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HICMOInterID"]); + oSub.HICMOBillNo = DsSub.Tables[0].Rows[i]["HICMOBillNo"].ToString().Trim(); + oSub.HWWOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWWOrderInterID"]); + oSub.HWWOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWWOrderEntryID"]); + oSub.HWWOrderBillNo = DsSub.Tables[0].Rows[i]["HWWOrderBillNo"].ToString().Trim(); + + DetailColl.Add(oSub); + } + sReturn = "鏄剧ず鍗曟嵁鎴愬姛锛�"; + return true; + } + catch (Exception e) + { + sReturn = e.Message; + throw (e); + } + } + } +} diff --git a/Model/Model.csproj b/Model/Model.csproj index 62e79e7..b21ec65 100644 --- a/Model/Model.csproj +++ b/Model/Model.csproj @@ -582,6 +582,8 @@ <Compile Include="鐢熶骇绠$悊\璁惧绠$悊\ClsSb_EquipConkBookBillSub.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchRecordBackBillMain.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchRecordBackBillSub.cs" /> + <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchSendWorkBillMain.cs" /> + <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchSendWorkBillSub.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchWorkBackBillSub.cs" /> <Compile Include="杞﹂棿绠$悊\ClsSc_ProcExchWorkBackBillMain.cs" /> <Compile Include="鐢熶骇绠$悊\璁惧绠$悊\ClsSb_EquipWorkBeforeCheckBillMain.cs" /> diff --git "a/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillMain.cs" "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillMain.cs" new file mode 100644 index 0000000..790d731 --- /dev/null +++ "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillMain.cs" @@ -0,0 +1,15 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Text; + +namespace Model +{ + public class ClsSc_ProcExchSendWorkBillMain : DBUtility.ClsXt_BaseBillMain + { + public Int64 HWorkShopID; //鐢熶骇杞﹂棿 + public string HExplanation; //鎽樿 + public string HInnerBillNo; //鍐呴儴鍗曟嵁鍙� + + public Int64 HPrintQty; + } +} diff --git "a/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillSub.cs" "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillSub.cs" new file mode 100644 index 0000000..39d750b --- /dev/null +++ "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcExchSendWorkBillSub.cs" @@ -0,0 +1,29 @@ +锘縰sing System; +using System.Collections.Generic; +using System.Text; +namespace Model +{ + public class ClsSc_ProcExchSendWorkBillSub : DBUtility.ClsXt_BaseBillSub + { + public string HBillNo_bak; //鍗曟嵁鍙凤紙澶囦唤锛屼互鍏嶅唴鐮佷涪澶憋紝鎵句笉鍒板搴斾富琛級 + public Int64 HProcNo; + public Int64 HMaterID; + public Int64 HUnitID; + public decimal HPlanQty; + public decimal HQty; + public Int64 HSourceID; + public Int64 HWorkerID; + public string HWorkerNumber; + public Int64 HGroupID; + public string HGroupNumber; + public string HBatchNo; + public DateTime HPlanBeginDate; + public DateTime HPlanEndDate; + public Int64 HWWOrderInterID; + public Int64 HWWOrderEntryID; + public string HWWOrderBillNo; + public Int64 HICMOInterID; + public string HICMOBillNo; + public Int64 HICMOEntryID; + } +} diff --git a/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs b/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs index d6ae83c..a657012 100644 --- a/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs +++ b/WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs @@ -579,7 +579,7 @@ "," + mainList[0].HManagerID + "," + mainList[0].HEmpID + "," + mainList[0].HDeptID + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HOWNERTYPEID + "'," + mainList[0].HOWNERID + "," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPURCHASEORGID + "," + mainList[0].HSTOCKORGID + "," + mainList[0].HREQUIREORGID + "," + mainList[0].HSTOCKGROUPID + ",'" + mainList[0].HSENDBILLNO + "','" + mainList[0].HLADBILLNO + "'," + mainList[0].HPURDEPTID + "," + mainList[0].HPURGROUPID + "," + mainList[0].HSUPPLYID + "," + -mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + ",'" + mainList[0].HBUSINESSTYPE + "','" + mainList[0].HSUPPLYADDRESS + "'," + mainList[0].HCORRESPONDORGID + "," + mainList[0].HPROVIDERCONTACTID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + ",'" + mainList[0].HAddress + "'," + mainList[0].HWHID + "," + mainList[0].HInnerBillNo + ")"; +mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + ",'" + mainList[0].HBUSINESSTYPE + "','" + mainList[0].HSUPPLYADDRESS + "'," + mainList[0].HCORRESPONDORGID + "," + mainList[0].HPROVIDERCONTACTID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + ",'" + mainList[0].HAddress + "'," + mainList[0].HWHID + ",'" + mainList[0].HInnerBillNo + "'" + ")"; oCN.RunProc(sql); //淇濆瓨涓昏〃 foreach (var oSub in subList) diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs index d8fe2f7..eec616b 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs @@ -167,9 +167,19 @@ string sBillNo = sBillBarCode; //鎴彇鏉$爜绫诲瀷 string BillNoType = sBillNo.Substring(0, Math.Min(3, sBillNo.Length)); + //鎴彇鏉$爜绫诲瀷2 + string BillNoType2 = sBillNo.Substring(0, Math.Min(4, sBillNo.Length)); //鎴彇鍐呯爜 string BillNo = sBillNo.Substring(3, Math.Min(sBillNo.Length - 3,sBillNo.Length)); - + switch (BillNoType2) + { + case "GXLZ"://宸ュ簭娴佽浆娲惧伐 + ds = oCN.RunProcReturn("select * from h_v_Sc_ProcExchSendWorkBill where 娲惧伐鍗曟嵁鍙� = '" + sBillNo + "'", "h_v_Sc_ProcExchSendWorkBill"); + break; + case "GXLX"://娴佽浆鍗� + ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 鍗曟嵁鍙�= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList"); + break; + } switch (BillNoType) //寰楀埌淇℃伅 { @@ -234,10 +244,7 @@ break; case "WLM"://鐗╂枡鐮� ds = oCN.RunProcReturn("select * from h_v_Gy_MaterialList where HItemID = '" + BillNo + "'", "h_v_Gy_MaterialList"); - break; - case "GXL"://娴佽浆鍗� - ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList where 鍗曟嵁鍙�= '" + sBillNo + "'", "h_v_Sc_ProcessExchangeBillList"); - break; + break; } //鍐欏叆淇℃伅 diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index 0d824de..90563b8 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -1677,100 +1677,101 @@ #endregion #region 鏄庣粏 淇濆瓨/缂栬緫鍔熻兘 - //[Route("Cj_StationOutBill/AddBill_Detail")] - //[HttpPost] - //public object AddBill_Detail([FromBody] JObject sMain) - //{ - // try - // { - // var _value = sMain["sMainSub"].ToString(); - // string msg1 = _value.ToString(); - // oCN.BeginTran(); - // //淇濆瓨涓昏〃 - // objJsonResult = Add_Detail(msg1); - // if (objJsonResult.code == "0") - // { - // oCN.RollBack(); - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = objJsonResult.Message; - // objJsonResult.data = null; - // return objJsonResult; - // } - // oCN.Commit(); - // objJsonResult.code = "1"; - // objJsonResult.count = 1; - // objJsonResult.Message = "鍗曟嵁淇濆瓨鎴愬姛锛�"; - // objJsonResult.data = null; - // return objJsonResult; + [Route("Cj_StationOutBill/AddBill_Detail")] + [HttpPost] + public object AddBill_Detail([FromBody] JObject sMain) + { + try + { + var _value = sMain["sMainSub"].ToString(); + string msg1 = _value.ToString(); + oCN.BeginTran(); + //淇濆瓨涓昏〃 + objJsonResult = Add_Detail(msg1); + if (objJsonResult.code == "0") + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = objJsonResult.Message; + objJsonResult.data = null; + return objJsonResult; + } + 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 = "淇濆瓨澶辫触锛�" + e.ToString(); - // objJsonResult.data = null; - // return objJsonResult; - // } - //} + } + catch (Exception e) + { + oCN.RollBack(); + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } - //public json Add_Detail(string msg1) - //{ - // string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); - // string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁 - // string msg3 = sArray[1].ToString(); //琛ㄤ綋鏁版嵁 - // int OperationType = int.Parse(sArray[2].ToString()); // 鏁版嵁绫诲瀷 1娣诲姞 3淇敼 - // string user = sArray[3].ToString(); //鐢ㄦ埛鍚� - // try - // { - // List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2); + public json Add_Detail(string msg1) + { + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁 + string msg3 = sArray[1].ToString(); //琛ㄤ綋鏁版嵁 + var a = sArray[2].ToString(); + int OperationType = int.Parse(sArray[2].ToString()); // 鏁版嵁绫诲瀷 1娣诲姞 3淇敼 + string user = sArray[3].ToString(); //鐢ㄦ埛鍚� + try + { + msg2 = "[" + msg2.ToString() + "]"; + List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2); + List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3); - // List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3); - - // long HWorkEmpID = subList[0].HWorkEmpID; - // long HWorkSourceID = subList[0].HWorkSourceID; - // decimal HQty = subList[0].HQty; - // decimal HRate = subList[0].HRate; - // decimal HProcPrice = subList[0].HProcPrice; - // decimal HMoney = subList[0].HMoney; - // long HWorkProcID = mainList[0].HWorkProcID; + long HWorkEmpID = subList[0].HWorkEmpID; + long HWorkSourceID = subList[0].HWorkSourceID; + decimal HQty = subList[0].HQty; + decimal HRate = subList[0].HRate; + decimal HProcPrice = subList[0].HProcPrice; + decimal HMoney = subList[0].HMoney; + long HWorkProcID = mainList[0].HWorkProcID; - // foreach (ClsSc_StationOutBillSub_Emp oSub in subList) - // { - // //ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 鍗曟嵁鍙�='" + HBillNo + "'", "h_v_IF_ICMOBillList"); + foreach (ClsSc_StationOutBillSub_Emp oSub in subList) + { + //ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 鍗曟嵁鍙�='" + HBillNo + "'", "h_v_IF_ICMOBillList"); - // if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//鏂板 - // { - // //涓昏〃 - // oCN.RunProc(@"Insert Into Sc_StationOutBillSub_Emp - // (HBillNo_bak ,HCloseMan ,HEntryCloseDate ,HCloseType ,HRemark ,HSourceInterID - // ,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney - // ,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice - // ,HMoney ,HWorkProcID) - // values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + - // "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" + - // ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID + - // "," + HCenterID + ",0,0,0,0," + HBomID + ",'','') "); - // } - // } + if ((OperationType == 1 || OperationType == 2))//鏂板 && ds.Tables[0].Rows.Count == 0 + { + string sql = string.Empty; + sql = $@" + Insert into Sc_StationOutBillSub_Emp + (HInterID,HEntryID,HBillNo_bak ,HRemark ,HSourceInterID + ,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney + ,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice ,HMoney ,HWorkProcID) + values(" + 1 + "," + 2 + "," + "'" + mainList[0].HBillNo_bak + "','" + "HRemark" + "'," + 0 + "," + 0 + ",'" + " " + "','" + "HSource" + "'," + + "0" + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + ")"; - // objJsonResult.code = "1"; - // objJsonResult.count = 1; - // objJsonResult.Message = null; - // objJsonResult.data = null; - // return objJsonResult; - // } - // catch (Exception e) - // { - // objJsonResult.code = "0"; - // objJsonResult.count = 0; - // objJsonResult.Message = "Exception锛�" + e.ToString(); - // objJsonResult.data = null; - // return objJsonResult; - // } - //} + oCN.RunProc(sql); + } + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = null; + 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 } } \ No newline at end of file diff --git a/WebAPI/Controllers/CJGL/Sc_ProcExchSendWorkBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcExchSendWorkBillController.cs new file mode 100644 index 0000000..8213492 --- /dev/null +++ b/WebAPI/Controllers/CJGL/Sc_ProcExchSendWorkBillController.cs @@ -0,0 +1,270 @@ +锘縰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.Web.Http; +using WebAPI.Models; + +namespace WebAPI.Controllers.CJGL +{ + public class Sc_ProcExchSendWorkBillController : ApiController + { + public DBUtility.ClsPub.Enum_BillStatus BillStatus; + private json objJsonResult = new json(); + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + DataSet ds; + + #region 宸ュ簭娲惧伐鍗曞垪琛� + [Route("Sc_ProcExchSendWorkBill/Sc_ProcExchSendWorkBillList")] + [HttpGet] + public object Sc_ProcExchSendWorkBillList(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + + string sql1 = "select * from h_v_Sc_ProcExchSendWorkBillList where 1 = 1 "; + string sql = sql1 + sWhere + " order by hmainid desc"; + ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcExchSendWorkBillList"); + + //娣诲姞鍒楀悕 + 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.list = columnNameList; + 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 鏌ヨ宸ュ簭娴佽浆鍗℃暟鎹� + [Route("Sc_ProcExchSendWorkBill/GetProcessExchangeBillSub")] + [HttpGet] + public object GetProcessExchangeBillSub_cf(string sWhere) + { + DataSet ds; + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + string sql = string.Format(@"select * from h_v_Sc_ProcessExchangeBillQuerySub_SendWork"); + ds = oCN.RunProcReturn(sql + sWhere + " order by 娴佹按鍙� ", "h_v_Sc_ProcessExchangeBillQuerySub_SendWork"); + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion + + #region 宸ュ簭娲惧伐鍗� 淇濆瓨/缂栬緫 + /// <summary> + /// 宸ュ簭娲惧伐鍗� 淇濆瓨 + /// </summary> + /// <param name="msg"></param> + /// <returns></returns> + [Route("Sc_ProcExchSendWorkBill/SaveProcessSendWork")] + [HttpPost] + public object SaveProcessSendWork([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(); + string msg4 = sArray[2].ToString(); + + + string UserName = ""; + ListModels oListModels = new ListModels(); + try + { + DAL.ClsSc_ProcExchSendWorkBill oBill = new DAL.ClsSc_ProcExchSendWorkBill(); + List<Model.ClsSc_ProcExchSendWorkBillMain> lsmain = new List<Model.ClsSc_ProcExchSendWorkBillMain>(); + msg2 = msg2.Replace("\\", ""); + msg2 = msg2.Replace("\n", ""); //\n + lsmain = oListModels.getObjectByJson_ClsSc_ProcExchSendWorkBillMain(msg2); + foreach (Model.ClsSc_ProcExchSendWorkBillMain oItem in lsmain) + { + //oItem.HMaker = ""; + UserName = oItem.HMaker; //鍒跺崟浜� + oItem.HBillType = "3798"; + oItem.HBillSubType = "3798"; + oItem.HBillStatus = 1; + DBUtility.ClsPub.CurUserName = UserName; + oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); + + 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.ClsSc_ProcExchSendWorkBillSub> ls = new List<Model.ClsSc_ProcExchSendWorkBillSub>(); + ls = oListModels.getObjectByJson_ClsSc_ProcExchSendWorkBillSub(msg3); + int i = 0; + foreach (Model.ClsSc_ProcExchSendWorkBillSub 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; //鍏宠仈鏁伴噺 + + oBill.DetailColl.Add(oItemSub); + + } + //淇濆瓨 + //淇濆瓨瀹屾瘯鍚庡鐞� + bool bResult; + if (oBill.omodel.HInterID == 0) + { + // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + } + else + { + bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); + } + if (bResult) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; + 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("Sc_ProcExchSendWorkBill/DelProcessSendWork")] + [HttpGet] + public object DelProcessSendWork(string HInterID, string user) + { + Int64 lngBillKey = 0; + lngBillKey = DBUtility.ClsPub.isLong(HInterID); + if (lngBillKey == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁ID涓虹┖锛�"; + objJsonResult.data = null; + return objJsonResult; + } + DAL.ClsSc_ProcExchSendWorkBill oBill = new DAL.ClsSc_ProcExchSendWorkBill(); + if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) + { + ds = oCN.RunProcReturn("select * from Sc_ProcExchSendWorkBillMain where HInterID=" + lngBillKey, "Sc_ProcExchSendWorkBillMain"); + if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁褰撳墠澶勪簬涓嶈兘鍒犻櫎鐘舵��,涓嶈兘鍒犻櫎锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁宸茬粡瀹℃牳,涓嶈兘鍒犻櫎锛�"; + objJsonResult.data = null; + return objJsonResult; + } + + bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); + if (IsDete) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + else + { + + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; + objJsonResult.data = null; + return objJsonResult; + } + } + //#endregion + + } +} \ No newline at end of file diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessSendWorkController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessSendWorkController.cs index b1f415a..d30df7b 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcessSendWorkController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcessSendWorkController.cs @@ -1,253 +1,253 @@ -锘縰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.Web.Http; -using WebAPI.Models; +锘�//using 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.Web.Http; +//using WebAPI.Models; -namespace WebAPI.Controllers -{ - public class Sc_ProcessSendWorkController : ApiController - { - private json objJsonResult = new json(); - public DataSet ds = new DataSet(); - SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); +//namespace WebAPI.Controllers +//{ +// public class Sc_ProcessSendWorkController : ApiController +// { +// private json objJsonResult = new json(); +// public DataSet ds = new DataSet(); +// SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - #region 宸ュ簭娲惧伐鍗� 鍒楄〃 - /// <summary> - /// 宸ュ簭娲惧伐鍗曞垪琛� - /// </summary> - /// <returns></returns> - [Route("Sc_ProcessSendWork/Sc_ProcessSendWorkList")] - [HttpGet] - public object Sc_ProcessSendWorkList(string sWhere, string user) - { - try - { - List<object> columnNameList = new List<object>(); +// #region 宸ュ簭娲惧伐鍗� 鍒楄〃 +// /// <summary> +// /// 宸ュ簭娲惧伐鍗曞垪琛� +// /// </summary> +// /// <returns></returns> +// [Route("Sc_ProcessSendWork/Sc_ProcessSendWorkList")] +// [HttpGet] +// public object Sc_ProcessSendWorkList(string sWhere, string user) +// { +// try +// { +// List<object> columnNameList = new List<object>(); - ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessSendWorkList where 1=1 " + sWhere, "h_v_Sc_ProcessSendWorkList"); +// ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessSendWorkList where 1=1 " + sWhere, "h_v_Sc_ProcessSendWorkList"); - //娣诲姞鍒楀悕 - 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鍒楀璞$殑鍒楀悕 - } +// //娣诲姞鍒楀悕 +// 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 = "杩斿洖璁板綍鎴愬姛锛�"; - objJsonResult.data = ds.Tables[0]; - objJsonResult.list = columnNameList; - return objJsonResult; +// objJsonResult.code = "1"; +// objJsonResult.count = 1; +// objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�"; +// objJsonResult.data = ds.Tables[0]; +// objJsonResult.list = columnNameList; +// return objJsonResult; - } - catch (Exception ex) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); - objJsonResult.data = null; - return objJsonResult; - } - } - #endregion +// } +// catch (Exception ex) +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString(); +// objJsonResult.data = null; +// return objJsonResult; +// } +// } +// #endregion - #region 宸ュ簭娲惧伐鍗� 淇濆瓨/缂栬緫 - /// <summary> - /// 宸ュ簭娲惧伐鍗� 淇濆瓨 - /// </summary> - /// <param name="msg"></param> - /// <returns></returns> - [Route("Sc_ProcessSendWork/SaveProcessSendWork")] - [HttpPost] - public object SaveProcessSendWork([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(); - string msg4 = sArray[2].ToString(); +// #region 宸ュ簭娲惧伐鍗� 淇濆瓨/缂栬緫 +// /// <summary> +// /// 宸ュ簭娲惧伐鍗� 淇濆瓨 +// /// </summary> +// /// <param name="msg"></param> +// /// <returns></returns> +// [Route("Sc_ProcessSendWork/SaveProcessSendWork")] +// [HttpPost] +// public object SaveProcessSendWork([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(); +// string msg4 = sArray[2].ToString(); - string UserName = ""; - ListModels oListModels = new ListModels(); - try - { - DAL.ClsSc_ProcessSendWork oBill = new DAL.ClsSc_ProcessSendWork(); - List<Model.ClsSc_ProcessSendWorkMain> lsmain = new List<Model.ClsSc_ProcessSendWorkMain>(); - msg2 = msg2.Replace("\\", ""); - msg2 = msg2.Replace("\n", ""); //\n - lsmain = oListModels.getObjectByJson_ClsSc_ProcessSendWorkMain(msg2); - foreach (Model.ClsSc_ProcessSendWorkMain oItem in lsmain) - { - //oItem.HMaker = ""; - UserName = oItem.HMaker; //鍒跺崟浜� - oItem.HBillType = "3712"; - oItem.HBillSubType = "3712"; - oItem.HBillStatus = 1; - DBUtility.ClsPub.CurUserName = UserName; - oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); +// string UserName = ""; +// ListModels oListModels = new ListModels(); +// try +// { +// DAL.ClsSc_ProcessSendWork oBill = new DAL.ClsSc_ProcessSendWork(); +// List<Model.ClsSc_ProcessSendWorkMain> lsmain = new List<Model.ClsSc_ProcessSendWorkMain>(); +// msg2 = msg2.Replace("\\", ""); +// msg2 = msg2.Replace("\n", ""); //\n +// lsmain = oListModels.getObjectByJson_ClsSc_ProcessSendWorkMain(msg2); +// foreach (Model.ClsSc_ProcessSendWorkMain oItem in lsmain) +// { +// //oItem.HMaker = ""; +// UserName = oItem.HMaker; //鍒跺崟浜� +// oItem.HBillType = "3712"; +// oItem.HBillSubType = "3712"; +// oItem.HBillStatus = 1; +// DBUtility.ClsPub.CurUserName = UserName; +// oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); - 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.ClsSc_ProcessSendWorkSub> ls = new List<Model.ClsSc_ProcessSendWorkSub>(); - ls = oListModels.getObjectByJson_ClsSc_ProcessSendWorkSub(msg3); - int i = 0; - foreach (Model.ClsSc_ProcessSendWorkSub oItemSub in ls) - { +// 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.ClsSc_ProcessSendWorkSub> ls = new List<Model.ClsSc_ProcessSendWorkSub>(); +// ls = oListModels.getObjectByJson_ClsSc_ProcessSendWorkSub(msg3); +// int i = 0; +// foreach (Model.ClsSc_ProcessSendWorkSub 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; //鍏宠仈閲戦 - //HMaterID = "";//閰嶄欢浠g爜 - //HUnitID = "";//鍗曚綅浠g爜 - //HQty = "";//瀹為檯鐢ㄩ噺 - //HQtyMust = "";//鍗曚綅鐢ㄩ噺 - //HRemark = "";//澶囨敞 +// 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; //鍏宠仈閲戦 +// //HMaterID = "";//閰嶄欢浠g爜 +// //HUnitID = "";//鍗曚綅浠g爜 +// //HQty = "";//瀹為檯鐢ㄩ噺 +// //HQtyMust = "";//鍗曚綅鐢ㄩ噺 +// //HRemark = "";//澶囨敞 - oBill.DetailColl.Add(oItemSub); +// oBill.DetailColl.Add(oItemSub); - } - //淇濆瓨 - //淇濆瓨瀹屾瘯鍚庡鐞� - bool bResult; - if (oBill.omodel.HInterID == 0) - { - // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); - bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); - } - else - { - bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); - } - if (bResult) - { - objJsonResult.code = "0"; - objJsonResult.count = 1; - objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; - 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 +// } +// //淇濆瓨 +// //淇濆瓨瀹屾瘯鍚庡鐞� +// bool bResult; +// if (oBill.omodel.HInterID == 0) +// { +// // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); +// bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); +// } +// else +// { +// bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); +// } +// if (bResult) +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 1; +// objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; +// 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 宸ュ簭娲惧伐鍗� 鍒犻櫎 - /// <summary> - /// 宸ュ簭娲惧伐鍗曞垹闄� - /// </summary> - /// <returns></returns> - [Route("Sc_ProcessSendWork/DelProcessSendWork")] - [HttpGet] - public object DelProcessSendWork(string HInterID, string user) - { - Int64 lngBillKey = 0; - lngBillKey = DBUtility.ClsPub.isLong(HInterID); - if (lngBillKey == 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁ID涓虹┖锛�"; - objJsonResult.data = null; - return objJsonResult; - } - DAL.ClsSc_ProcessSendWork oBill = new DAL.ClsSc_ProcessSendWork(); - if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) - { - ds = oCN.RunProcReturn("select * from Sc_ProcessSendWorkMain where HInterID=" + lngBillKey, "Sc_ProcessSendWorkMain"); - if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁褰撳墠澶勪簬涓嶈兘鍒犻櫎鐘舵��,涓嶈兘鍒犻櫎锛�"; - objJsonResult.data = null; - return objJsonResult; - } +// #region 宸ュ簭娲惧伐鍗� 鍒犻櫎 +// /// <summary> +// /// 宸ュ簭娲惧伐鍗曞垹闄� +// /// </summary> +// /// <returns></returns> +// [Route("Sc_ProcessSendWork/DelProcessSendWork")] +// [HttpGet] +// public object DelProcessSendWork(string HInterID, string user) +// { +// Int64 lngBillKey = 0; +// lngBillKey = DBUtility.ClsPub.isLong(HInterID); +// if (lngBillKey == 0) +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = "鍗曟嵁ID涓虹┖锛�"; +// objJsonResult.data = null; +// return objJsonResult; +// } +// DAL.ClsSc_ProcessSendWork oBill = new DAL.ClsSc_ProcessSendWork(); +// if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) +// { +// ds = oCN.RunProcReturn("select * from Sc_ProcessSendWorkMain where HInterID=" + lngBillKey, "Sc_ProcessSendWorkMain"); +// if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = "鍗曟嵁褰撳墠澶勪簬涓嶈兘鍒犻櫎鐘舵��,涓嶈兘鍒犻櫎锛�"; +// objJsonResult.data = null; +// return objJsonResult; +// } - if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁宸茬粡瀹℃牳,涓嶈兘鍒犻櫎锛�"; - objJsonResult.data = null; - return objJsonResult; - } +// if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = "鍗曟嵁宸茬粡瀹℃牳,涓嶈兘鍒犻櫎锛�"; +// objJsonResult.data = null; +// return objJsonResult; +// } - bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); - if (IsDete) - { - objJsonResult.code = "0"; - objJsonResult.count = 1; - objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - else - { +// bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); +// if (IsDete) +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 1; +// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; +// objJsonResult.data = null; +// return objJsonResult; +// } +// else +// { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; - objJsonResult.data = null; - return objJsonResult; - } - } - else - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; - objJsonResult.data = null; - return objJsonResult; - } - } - #endregion - } -} \ No newline at end of file +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; +// objJsonResult.data = null; +// return objJsonResult; +// } +// } +// else +// { +// objJsonResult.code = "0"; +// objJsonResult.count = 0; +// objJsonResult.Message = "鍗曟嵁鏈壘鍒�"; +// objJsonResult.data = null; +// return objJsonResult; +// } +// } +// #endregion +// } +//} \ No newline at end of file diff --git a/WebAPI/ListModels.cs b/WebAPI/ListModels.cs index ae5c17a..23ef83f 100644 --- a/WebAPI/ListModels.cs +++ b/WebAPI/ListModels.cs @@ -1556,6 +1556,24 @@ return list; } + ///娴佽浆鍗″伐搴忔淳宸ュ崟 涓昏〃 + ///ClsSc_ProcExchWorkBackBillMain + public List<Model.ClsSc_ProcExchSendWorkBillMain> getObjectByJson_ClsSc_ProcExchSendWorkBillMain(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_ProcExchSendWorkBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchSendWorkBillMain>>(jsonString); + return list; + } + + ///娴佽浆鍗″伐搴忔淳宸ュ崟 瀛愯〃 + ///ClsSc_ProcExchWorkBackBillMain + public List<Model.ClsSc_ProcExchSendWorkBillSub> getObjectByJson_ClsSc_ProcExchSendWorkBillSub(string jsonString) + { + jsonString = "[" + jsonString.ToString() + "]"; + List<Model.ClsSc_ProcExchSendWorkBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcExchSendWorkBillSub>>(jsonString); + return list; + } + ///璁惧鎶曚骇妫�楠岄獙鏀跺崟 瀛愯〃 ///ClsSb_EquipWorkBeforeCheckBillSub public List<Model.ClsSb_EquipWorkBeforeCheckBillSub> getObjectByJson_ClsSb_EquipWorkBeforeCheckBillSub(string jsonString) diff --git a/WebAPI/WebAPI.csproj b/WebAPI/WebAPI.csproj index 66146ee..5b6a1f3 100644 --- a/WebAPI/WebAPI.csproj +++ b/WebAPI/WebAPI.csproj @@ -404,6 +404,7 @@ <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" /> <Compile Include="Controllers\CJGL\Sc_ProcExchRecordBackBillController.cs" /> <Compile Include="Controllers\CJGL\Sc_ProcessSendWorkController.cs" /> + <Compile Include="Controllers\CJGL\Sc_ProcExchSendWorkBillController.cs" /> <Compile Include="Controllers\CJGL\Sc_ProcExchWorkBackBillController.cs" /> <Compile Include="Controllers\CJGL\Sc_WorkBillAutoSortBillMainController.cs" /> <Compile Include="Controllers\Gy_MateMouldController.cs" /> @@ -1000,6 +1001,7 @@ <Folder Include="Views\Sc_ProcessExchangeIssueBill\" /> <Folder Include="Views\Sc_ProcessSendWork\" /> <Folder Include="Views\Sc_ProcExchRecordBackBill\" /> + <Folder Include="Views\Sc_ProcExchSendWorkBill\" /> <Folder Include="Views\Sc_WorkBillAutoSortBillMain\" /> <Folder Include="Views\Sc_WorkBillSortBill\" /> <Folder Include="Views\Sc_WorkDemandPlanBill\" /> -- Gitblit v1.9.1