| | |
| | | <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" /> |
New file |
| | |
| | | using 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 åºå®ä»£ç |
| | | |
| | | ~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); |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | 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); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | <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" /> |
New file |
| | |
| | | using 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; |
| | | } |
| | | } |
New file |
| | |
| | | using 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; |
| | | } |
| | | } |
| | |
| | | "," + 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) |
| | |
| | | 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) |
| | | //å¾å°ä¿¡æ¯ |
| | | { |
| | |
| | | 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; |
| | | } |
| | | |
| | | //åå
¥ä¿¡æ¯ |
| | |
| | | #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 |
| | | } |
| | | } |
New file |
| | |
| | | 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.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));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | |
| | | 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 |
| | | |
| | | } |
| | | } |
| | |
| | | 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; |
| | | //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));//è·åå°DataColumnå对象çåå |
| | | } |
| | | // //æ·»å åå |
| | | // 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));//è·åå°DataColumnå对象çåå |
| | | // } |
| | | |
| | | 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 = "";//é
件代ç |
| | | //HUnitID = "";//åä½ä»£ç |
| | | //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 = "";//é
件代ç |
| | | // //HUnitID = "";//åä½ä»£ç |
| | | // //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 |
| | | } |
| | | } |
| | | // 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 |
| | | // } |
| | | //} |
| | |
| | | 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) |
| | |
| | | <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" /> |
| | |
| | | <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\" /> |