| | |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc("UpDate Sc_ProcExchRecordBackBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== |
| | | //",HDate='" + omodel.HDate + "'" + |
| | | ",HDate='" + omodel.HDate + "'" + |
| | | //",HYear='" + omodel.HYear.ToString() + "'" + |
| | | //",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | |
| | | foreach (Model.ClsSc_ProcExchRecordBackBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_ProcExchRecordBackBillSub (HInterID, HEntryID, HCloseMan, HEntryCloseDate, HCloseType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | ", HQty, HICMOInterID, HICMOBillNo, HICMOEntryID)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', null, {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {omodel.HProcExchInterID.ToString()},{omodel.HProcExchEntryID.ToString()}, '{omodel.HProcExchBillNo.ToString()}', '3772'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag == true ? 1 : 0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | $", {oSub.HQty.ToString()},{omodel.HICMOInterID},'{omodel.HICMOBillNo}',{omodel.HICMOEntryID}) "); |
| | | } |
| | | |
| | | sReturn = "ä¿®æ¹åæ®æåï¼"; |
| | |
| | | foreach (Model.ClsSc_ProcExchRecordBackBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_ProcExchRecordBackBillSub (HInterID, HEntryID, HCloseMan, HEntryCloseDate, HCloseType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType== true ? 1:0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | ", HQty, HICMOInterID, HICMOBillNo, HICMOEntryID)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', null, {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {omodel.HProcExchInterID.ToString()},{omodel.HProcExchEntryID.ToString()}, '{omodel.HProcExchBillNo.ToString()}', '3772'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag== true?1:0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag == true ? 1 : 0)}" + |
| | | $", {oSub.HQty.ToString()},{omodel.HICMOInterID},'{omodel.HICMOBillNo}',{omodel.HICMOEntryID}) "); |
| | | } |
| | | |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc("UpDate Sc_ProcExchWorkBackBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== |
| | | //",HDate='" + omodel.HDate + "'" + |
| | | ",HDate='" + omodel.HDate + "'" + |
| | | //",HYear='" + omodel.HYear.ToString() + "'" + |
| | | //",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | ", HQty, HICMOInterID, HICMOBillNo, HICMOEntryID)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', null, {(oSub.HCloseType == true ? 1 : 0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {omodel.HProcExchInterID.ToString()},{omodel.HProcExchEntryID.ToString()}, '{omodel.HProcExchBillNo.ToString()}', '3772'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag == true ? 1 : 0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | $", {oSub.HQty.ToString()},{omodel.HICMOInterID},'{omodel.HICMOBillNo}',{omodel.HICMOEntryID}) "); |
| | | } |
| | | |
| | | sReturn = "ä¿®æ¹åæ®æåï¼"; |
| | |
| | | ", HRemark, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType" + |
| | | ", HRelationQty, HRelationMoney, HBillNo_bak, HProcNo, HProcID" + |
| | | ", HWorkRemark, HCenterID, HDeptID, HSupID, HSupFlag" + |
| | | ", HQty)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', GETDATE(), {(oSub.HCloseType== true ? 1:0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {oSub.HSourceInterID.ToString()},{oSub.HSourceEntryID.ToString()}, '{oSub.HSourceBillNo.ToString()}', '{oSub.HSourceBillType.ToString()}'" + |
| | | ", HQty, HICMOInterID, HICMOBillNo, HICMOEntryID)values(" + |
| | | $"{omodel.HInterID}, {oSub.HEntryID.ToString()}, '{oSub.HCloseMan.ToString()}', null, {(oSub.HCloseType== true ? 1:0)}" + |
| | | $",'{oSub.HRemark.ToString()}', {omodel.HProcExchInterID.ToString()},{omodel.HProcExchEntryID.ToString()}, '{omodel.HProcExchBillNo.ToString()}', '3772'" + |
| | | $",{oSub.HRelationQty.ToString()},{oSub.HRelationMoney.ToString()}, '{oSub.HBillNo_bak.ToString()}', '{oSub.HProcNo.ToString()}',{oSub.HProcID.ToString()}" + |
| | | $", '{oSub.HWorkRemark.ToString()}', {oSub.HCenterID.ToString()},{oSub.HDeptID.ToString()},{oSub.HSupID.ToString()},{(oSub.HSupFlag== true?1:0)}" + |
| | | $", {oSub.HQty.ToString()}) "); |
| | | $", {oSub.HQty.ToString()},{omodel.HICMOInterID},'{omodel.HICMOBillNo}',{omodel.HICMOEntryID}) "); |
| | | } |
| | | |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | |
| | | ",HEquipMentID=" + omodel.HEquipMentID.ToString() + |
| | | ",HProjectNum='" + omodel.HProjectNum.ToString() + "'" + |
| | | ",HMateOutBatchNo='" + omodel.HMateOutBatchNo + "'" + |
| | | ",HBLFlag='" + (omodel.HBLFlag ? 1 : 0) + "'" + |
| | | ",HXTNumber='" + omodel.HXTNumber + "'" + |
| | | ",HXTModel='" + omodel.HXTModel + "'" + |
| | | ",HCusNumber='" + omodel.HCusNumber + "'" + |
| | | |
| | | ",HProdMaterCode='" + omodel.HProdMaterCode + "'" + |
| | | ",HSeOrderBillNo='" + omodel.HSeOrderBillNo + "'" + |
| | |
| | | ",'" + omodel.HProdMaterName + "','" + omodel.HCusName + "','" + omodel.HWorkRemark + "','" + omodel.HImportNote + "','" + omodel.HMaterNumber_A + "'" + |
| | | ",'" + omodel.HMaterNumber_B + "','" + omodel.HMaterNumber_C + "','" + omodel.HMaterNumber_D + "','" + omodel.HProdType + "','" + omodel.HMaterShortName + "'" + |
| | | ",'" + omodel.HMaterIDA + "','" + omodel.HMaterIDB + "','" + omodel.HMaterIDC + "','" + omodel.HMaterIDD + "'," + omodel.HICMOEntryID + |
| | | ",'" + omodel.HPicNumVer + "','" + omodel.HPicNumAssemble + "','" + omodel.HMaterTexture + "','" + omodel.HProductNum + "','" + omodel.HVerNum + "','"+ omodel.HPRDORGID+ "','"+omodel.HBLFlag+ "','" + omodel.HCusNumber + "','" + omodel.HPickLabel + "','" + omodel.HPickLabelNumber + "','" + omodel.HXTNumber + "','" + omodel.HXTModel + "','" + omodel.HWorkBillSortNo + |
| | | ",'" + omodel.HPicNumVer + "','" + omodel.HPicNumAssemble + "','" + omodel.HMaterTexture + "','" + omodel.HProductNum + "','" + omodel.HVerNum + "','"+ omodel.HPRDORGID+ "','" + (omodel.HBLFlag ? 1 : 0) + "','" + omodel.HCusNumber + "','" + omodel.HPickLabel + "','" + omodel.HPickLabelNumber + "','" + omodel.HXTNumber + "','" + omodel.HXTModel + "','" + omodel.HWorkBillSortNo + |
| | | "',"+ omodel.HRoutingBillID + ") "); |
| | | sErr = sErr + "1;"; |
| | | //æå
¥å表 |
| | |
| | | omodel.HMaterTexture = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterTexture"]); |
| | | omodel.HProductNum = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProductNum"]); |
| | | omodel.HVerNum = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HVerNum"]); |
| | | omodel.HRoutingBillID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRoutingBillID"]); |
| | | omodel.HPRDORGID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPRDORGID"]); |
| | | // |
| | | //å¾ªç¯ |
| | | DataSet DsSub; |
| | |
| | | public bool AbandonCancelltion(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null Where HInterID=" + lngBillKey.ToString()); |
| | | { |
| | | DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); |
| | | if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='',HDeleteDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | public bool CancelClose(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null Where HInterID=" + lngBillKey.ToString()); |
| | | { |
| | | DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); |
| | | if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='',HCloseDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | return false; |
| | | } |
| | | try |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null Where HInterID=" + lngBillKey.ToString()); |
| | | { |
| | | DataSet ds = oCn.RunProcReturn("select * from " + MvarItemKey + " where HInterID=" + lngBillKey.ToString(), MvarItemKey); |
| | | if (ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else if (ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | else |
| | | { |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + lngBillKey.ToString()); |
| | | } |
| | | |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | { |
| | | string HChecker = ClsPub.CurUserName ; |
| | | string HCheckDate =ClsPub.GetServerDate(-1); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString()); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | { |
| | | string HCloseMan = ClsPub.CurUserName; |
| | | string HCloseDate = ClsPub.GetServerDate(-1); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate='" + HCloseDate + "' Where HInterID=" + lngBillKey.ToString()); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate='" + HCloseDate + "',HBillStatus=3 Where HInterID=" + lngBillKey.ToString()); |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | { |
| | | string HDeleteMan = ClsPub.CurUserName; |
| | | string HDeleteDate = ClsPub.GetServerDate(-1); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='" + HDeleteMan + "',HDeleteDate='" + HDeleteDate + "' Where HInterID=" + lngBillKey.ToString()); |
| | | oCn.RunProc(" Update " + MvarItemKey + " set HDeleteMan='" + HDeleteMan + "',HDeleteDate='" + HDeleteDate + "',HBillStatus=4 Where HInterID=" + lngBillKey.ToString()); |
| | | sReturn = ""; |
| | | return true; |
| | | } |
| | |
| | | public DateTime? HEndDate; |
| | | public Int64 HBomID; |
| | | public Int64 HCusID; |
| | | public Int64 HSTOCKINORGID; |
| | | |
| | | public string HINSTOCKTYPE; //å
¥åºç±»å, |
| | | public Int64 HCHECKPRODUCT; //äº§åæ£éª, |
| | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | string HRemark = list[0].HRemark; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | long HParentID = list[0].HParentID; |
| | | string HBarCode = list[0].HBarCode; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HUpDater = list[0].HUpDater; |
| | | string HUpDater = msg3; |
| | | long HEmpID = list[0].HEmpID; |
| | | bool HStopflag = list[0].HStopflag; |
| | | long HSecManagerID = list[0].HSecManagerID; |
| | | //string HCreator = list[0].HCreator; |
| | | long HCreateOrgID = list[0].HCreateOrgID; |
| | | //DateTime HCreateDate = list[0].HCreateDate; |
| | | long HUseOrgID = long.Parse(msg4); |
| | | string HUpdater = list[0].HUpDater; |
| | | long HUseOrgID = list[0].HUseOrgID; |
| | | //DateTime HUpdateDate = list[0].HUpDateDate; |
| | | string HChecker = list[0].HChecker; |
| | | //DateTime HCheckDate = list[0].HCheckDate; |
| | | string HDeleteMan = list[0].HDeleteMan; |
| | | //DateTime HDeleteDate = list[0].HDeleteDate; |
| | | long HLevel = 1; |
| | | //æ«çº§æ å¿ |
| | | bool HEndFlag = true; |
| | | long HEntityID = 1; |
| | | |
| | | //å¾å°ç代ç |
| | | string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); |
| | | if (HShortNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //ç级 |
| | | int HLevel = DBUtility.ClsPub.GetLevel(HNumber); |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | long HParentID = 0; |
| | | string sParent = DBUtility.ClsPub.GetParentCode(HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_Department where HNumber='" + sParent + "' and HStopFlag=0 ", "Gy_Department"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //夿æé |
| | | //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) |
| | | //{ |
| | |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Gy_Department " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HBarCodeForBase,HEntityID,HUSEORGID) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HBarCodeForBase,HEntityID,HUSEORGID,HCREATEORGID,HMaker,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID + ",'" + HBarCode + "'" + |
| | | "," + HEntityID.ToString() + "," + HUseOrgID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + HEntityID.ToString() + "," + HUseOrgID + ","+ HCreateOrgID + ",'"+ msg3 + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HLevel='" + HLevel + "'" + |
| | | ",HShortNumber='" + HShortNumber + "'" + |
| | | ",HBarCodeForBase='" + HBarCode + "'" + |
| | | ",HParentID=" + HParentID + |
| | | ",HEmpID=" + HEmpID.ToString() + |
| | | ",HUSEORGID=" + HUseOrgID.ToString() + |
| | | ",HCREATEORGID=" + HCreateOrgID.ToString() + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | //",HUpdater='" + HUpdater + "'" + |
| | | //",HUpdateDate= getdate()" + |
| | | ",HUpDater='" + HUpDater + "'" + |
| | | ",HUpDateDate= getdate()" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | string HOverFixPrice = list[0].HOverFixPrice; |
| | | string HSNo = list[0].HSNo; |
| | | string HBarCode = list[0].HBarCode; |
| | | string HProcMulID = list[0].HProcMulID; |
| | | string HProcMulID = list[0].HProcMulID==null?"0": list[0].HProcMulID; |
| | | string HProcCheckNote = list[0].HProcCheckNote; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | |
| | | ",HStopflag= '" + HStopflag + "'" + |
| | | ",HRemark='" + HRemark + "'" + |
| | | ",HDeptID= " + HDeptID + |
| | | ",HBarCodeForBase='" + HBarCodeForBase + "'" + |
| | | ",HBarCodeForBase='" + HBarCode + "'" + |
| | | ",HProcessID_K3= " + HProcessID_K3 + |
| | | ",HBillSubType='" + HBillSubType + "'" + |
| | | ",HAutoTrunFlag= '" + HAutoTrunFlag + "'" + |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | /// <summary>Gy_Process/cx |
| | | /// <summary> |
| | | /// å·¥åºå表å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | long HParentID = list[0].HParentID; |
| | | long HLevel = list[0].HLevel; |
| | | bool HEndFlag = list[0].HEndFlag; |
| | | bool HStopflag = list[0].HStopFlag; |
| | | string HRemark = list[0].HRemark; |
| | | string HBarCode = list[0].HBarCode; |
| | | long HEmpID = list[0].HEmpID; |
| | | string HAddress = list[0].HAddress; |
| | | string HPhone = list[0].HPhone; |
| | | long HUSEORGID = list[0].HUSEORGID; |
| | | string HUpDater = list[0].HUpDater; |
| | | |
| | | ////夿æé |
| | | if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3)) |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | bool HStopflag = list[0].HStopFlag; |
| | | string HRemark = list[0].HRemark; |
| | | string HBarCode = list[0].HBarCode; |
| | | long HEmpID = list[0].HEmpID; |
| | | string HAddress = list[0].HAddress; |
| | | string HPhone = list[0].HPhone; |
| | | long HUSEORGID = list[0].HUSEORGID; |
| | | //long HCREATEORGID = list[0].HCREATEORGID; |
| | | string HUpDater = list[0].HUpDater; |
| | | long HSPFlag = list[0].HSPFlag; |
| | | //å¾å°ç代ç |
| | | string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); |
| | | if (HShortNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //ç级 |
| | | int HLevel = DBUtility.ClsPub.GetLevel(HNumber); |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | long HParentID = 0; |
| | | string sParent = DBUtility.ClsPub.GetParentCode(HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_Warehouse where HNumber='" + sParent + "' and HStopFlag=0 ", "Gy_Warehouse"); |
| | | if (ds.Tables[0].Rows.Count>0) |
| | | { |
| | | HParentID =long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //æ«çº§æ å¿ |
| | | int HEndFlag = 1; |
| | | |
| | | //if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | //{ |
| | |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Gy_Warehouse " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID,HSPFlag,HCREATEORGID,HMaker,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','"+ HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + HLevel.ToString() + "," + HEndFlag + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','"+ HUSEORGID + "',"+ HSPFlag + ","+ HUSEORGID + ",'"+msg3+"',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å¯ç¨ä»ä½ |
| | | if (HSPFlag == 1) |
| | | { |
| | | //åå¡« HSPGroupID |
| | | oCN.RunProc("Update Gy_Warehouse set HSPGroupID=HItemID where HNumber='" + HNumber + "' and HName='" + HName + "' ", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | |
| | | oCN.Commit(); |
| | | } |
| | | else { |
| | |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HLevel=" + HLevel.ToString() + |
| | | ",HParentID=" + HParentID.ToString() + |
| | | ",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HEmpID=" + HEmpID.ToString() + |
| | | ",HAddress='" + HAddress + "'" + |
| | | ",HPhone='" + HPhone + "'" + |
| | | ",HUSEORGID='" + HUSEORGID + "'" + |
| | | ",HCREATEORGID='" + HUSEORGID + "'" + |
| | | ",HSPFlag='" + HSPFlag + "'" + |
| | | //",HSPGroupID='" + HSPGroupID + "'" + |
| | | ",HUpdater='" + HUpDater + "'" + |
| | | ",HUpdateDate= getdate()" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | //å¯ç¨ä»ä½ |
| | | if (HSPFlag == 1) |
| | | { |
| | | //åå¡« HSPGroupID |
| | | oCN.RunProc("Update Gy_Warehouse set HSPGroupID=HItemID where HItemID=" + HItemID , ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else { |
| | | //åå¡« HSPGroupID |
| | | oCN.RunProc("Update Gy_Warehouse set HSPGroupID=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | oCN.Commit(); |
| | | } |
| | | objJsonResult.code = "0"; |
| | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | string HDeptNumber = list[0].HDeptNumber; |
| | | long HParentID = list[0].HParentID; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | bool HEndFlag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | var HQty = list[0].HQty; |
| | | var HBarCodeForBase = list[0].HBarCodeForBase; |
| | | var HDayMoney = list[0].HDayMoney; |
| | | var HDeptID = list[0].HDeptID; |
| | | var HProcID = list[0].HProcID; |
| | | var HLevel = list[0].HLevel; |
| | | var HWorkTimes = list[0].HWorkTimes; |
| | | int HUSEORGID = list[0].HUSEORGID; |
| | | string HMaker = msg2; |
| | | |
| | | //夿æé |
| | | if (!ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, msg2)) |
| | | //æ«çº§æ å¿ |
| | | bool HEndFlag = true; |
| | | //å¾å°ç代ç |
| | | string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); |
| | | if (HShortNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; |
| | | objJsonResult.data = null; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //ç级 |
| | | int HLevel = DBUtility.ClsPub.GetLevel(HNumber); |
| | | |
| | | //æ£æ¥ç¶çº§æ¯å¦åå¨ |
| | | long HParentID = 0; |
| | | string sParent = DBUtility.ClsPub.GetParentCode(HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HNumber='" + sParent + "' and HStopFlag=0 ", "Gy_WorkCenter"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | //if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | //{ |
| | |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HDeptNumber,HWorkTimes,HQty" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" + |
| | | ",HProcID,HDayMoney,HUSEORGID) " + |
| | | ",HProcID,HDayMoney,HUSEORGID,HMaker,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | ",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ","+ HUSEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ","+ HUSEORGID + "" + |
| | | ",'"+ HMaker + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | ",HParentID=" + HParentID + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HRemark= '" + HRemark + "'" + |
| | | ",HUpDater= '" + HMaker + "'" + |
| | | ",HUpDateDate= getdate()" + |
| | | ",HDeptID=" + HDeptID + |
| | | ",HLevel=" + HLevel + |
| | | ",HQty=" + HQty + |
| | | ",HWorkTimes=" + HWorkTimes + |
| | | ",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DBUtility.ClsPub.CurUserName = msg4; |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | List<Model.ClsSc_ProcessExchangeBillMain> lsmain = new List<Model.ClsSc_ProcessExchangeBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | |
| | | UserName = oItem.HMaker; //å¶å人 |
| | | oItem.HBillType = "3772"; |
| | | oItem.HBillSubType = "3772"; |
| | | oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql = string.Format(@"select æµæ°´å· HProcNo,HProcID,å·¥åºä»£ç HProcNumber,å·¥åºåç§° HProcName,å 工说æ HWorkRemark,HCenterID,å·¥ä½ä¸å¿ä»£ç HCenterNumber, |
| | | å·¥ä½ä¸å¿ HCenterName,HSupID,ä¾åºå代ç HSupNumber,ä¾åºå HSupName,isEntrust,è®¡åæ°é HQty,å å·¥åä»· HOutPrice, 表ä½å¤æ³¨ HRemark, |
| | | å·¥ä½ä¸å¿ HCenterName,HSupID,ä¾åºå代ç HSupNumber,ä¾åºå HSupName,isEntrust HSupFlag,è®¡åæ°é HQty,å å·¥åä»· HOutPrice, 表ä½å¤æ³¨ HRemark, |
| | | è¿ç«å
³èæ°é HRelationQty_In,åºç«å
³èæ°é HRelationQty_Out,å§å¤å·¥åæ°é HRelationQty_WWOrder,ä¸åæ ¼æ°é HRelationQty_Bad,è¶
颿¯ä¾ HOverRate, |
| | | è¯ç HPassRate,累计è¯ç HSumPassRate,å¾çº¸ç¼å· HPicNum,æ¬å·¥åºç¡®è®¤è®°å½ HProcCheckNote,å·¥èºåæ° HTechnologyParameter,HDeptID, |
| | | å 工车é´ä»£ç HDeptNumber,å å·¥è½¦é´ HDeptName |
| | |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | string linterid = sArray[4].ToString(); |
| | | |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Sc_ProcessExchangeBillMain(msg2); |
| | | string sReturn = ""; |
| | | DBUtility.ClsPub.HOrgID = lsmain[0].HPRDORGID; |
| | | oBill.ShowBill(long.Parse(linterid), ref sReturn); |
| | | foreach (Model.ClsSc_ProcessExchangeBillMain oItem in lsmain) |
| | | { |
| | | oItem.HMaker = msg5; //å¶å人 |
| | | oItem.HBillType = "3772"; |
| | | oBill.HBillSubType = "Split"; |
| | | oItem.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]); |
| | | oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | oItem.HMaterID2 = oItem.HMaterID; |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | oBill.omodel = oItem; |
| | | |
| | | oBill.omodel.HMaker = msg5; //å¶å人 |
| | | oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]); |
| | | oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | oBill.omodel.HDate = oItem.HDate;// æ¥æ |
| | | oBill.omodel.HPlanBeginDate = oItem.HPlanBeginDate;// 计åå¼å·¥æ¥æ |
| | | oBill.omodel.HPlanEndDate = oItem.HPlanEndDate;// 计åå®å·¥æ¥æ |
| | | oBill.omodel.HQty = oItem.HQty;// æ°é |
| | | oBill.omodel.HBillNo = oItem.HBillNo;// åæ®å· |
| | | } |
| | | |
| | | //è¡¨ä½æ°æ® |
| | |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | | if (oItemSub.HSplitQty > oItemSub.HLeftQty) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "第"+i+ "è¡ï¼æåæ°éä¸è½å¤§äºå¯æåæ°éï¼"; |
| | | objJsonResult.Message = "第" + (i + 1) + "è¡ï¼æåæ°éä¸è½å¤§äºå¯æåæ°éï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oItemSub.HEntryID = i; |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | oBill.DetailColl[i].HQty = oItemSub.HQty; |
| | | oBill.DetailColl[i].HBackProc = oItemSub.HBackProc; |
| | | oBill.DetailColl[i].HPrevSourceInterID = oItemSub.HPrevSourceInterID; |
| | | oBill.DetailColl[i].HPrevSourceEntryID = oItemSub.HPrevSourceEntryID; |
| | | i++; |
| | | } |
| | | |
| | | //ä¿å |
| | |
| | | string HBillNo = mainList[0].HBillNo;//éå
¥typeå¾å°çåæ®å· |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | int HYear = DateTime.Now.Year; |
| | | double HPeriod = 1; |
| | | double HPeriod = DateTime.Now.Month; |
| | | string HRemark = mainList[0].HRemark;//夿³¨ |
| | | string HMaker = mainList[0].HMaker;//å¶å人 |
| | | long HMaterID = mainList[0].HMaterID;//产åID |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region å·¥èºè·¯çº¿å表 æ¥è¯¢ç³»ç»åæ° |
| | | /// <summary> |
| | | /// è¿åå·¥èºè·¯çº¿å表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("LEMS/MES_XT_List")] |
| | | [HttpGet] |
| | | public object MES_XT_List(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | string flag = "flase"; |
| | | string sErrMsg = ""; |
| | | if (oSystemParameter.ShowBill(ref sErrMsg)) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_SaveAutoLastProc == "Y") |
| | | { |
| | | flag = "true"; |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = flag; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region å·¥èºè·¯çº¿ æä»¶ä¸ä¼ |
| | | [Route("Gy_RoutingBill/Gy_RoutingBillimport")] |
| | | [HttpPost] |
| | |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #region 夿䏿¨ççäº§è®¢åæ¯å¦å®¡æ ¸ |
| | | [Route("LEMS/ICMOBillCheck")] |
| | | [HttpGet] |
| | | public object ICMOBillCheck(string hmainid,string HEntryID,int OrganizationID) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 and hmainid=" + hmainid + " and HEntryID=" + HEntryID + " order by åæ®å· desc", "h_v_IF_ICMOBillList"); |
| | | string HNumber = ds.Tables[0].Rows[0]["产å代ç "].ToString(); |
| | | |
| | | if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æéç产订å为æªå®¡æ ¸ç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["å
³é人"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æéç产订å为已å
³éç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["ä½åºäºº"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æéç产订å为已ä½åºç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_S_Sc_ICMOBillList where hmainid=" + hmainid + " and HEntryID=" + HEntryID + " and HSTOCKINORGID='" + OrganizationID + "'", "h_v_S_Sc_ICMOBillList"); |
| | | |
| | | if (double.Parse(ds.Tables[0].Rows[0]["æµè½¬å¡æ°é"].ToString()) == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æéç产订åå·²å
¨é¨ä¸æ¨çæå·¥åºæµè½¬å¡ï¼å©ä½å¯ä¸æ¨æ°é为0ï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select top 1000 * from h_v_Gy_RoutingBillList where ç©æä»£ç ='" + HNumber + "'", "h_v_Gy_RoutingBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æéç产订å对åºç©ææªè®¾ç½®å¯¹åºçå·¥èºè·¯çº¿ï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// è¿åå·¥åºå§å¤æ¥æ¶åå表 |
| | | ///åæ°ï¼string sqlã |
| | |
| | | //DataRow dr = ds.Tables[0].Rows[0]; |
| | | |
| | | //å¤ææ¬æ¬¡æ¥åºæ»æ°éæ¯å¦ä¸º0 |
| | | var DTable = oCN.RunProcReturn("select sum(HWasterQty) HWasterQty from Sc_StationOutBillMain where HProcExchBillNo='"+ BillNo + "' and HBFFlag=0 ", "Sc_StationOutBillMain").Tables[0]; |
| | | var DTable = oCN.RunProcReturn("select isnull(sum(HWasterQty),0) HWasterQty from Sc_StationOutBillMain where HProcExchBillNo='"+ BillNo + "' and HBFFlag=0 ", "Sc_StationOutBillMain").Tables[0]; |
| | | |
| | | if (double.Parse(DTable.Rows[0]["HWasterQty"].ToString()) == 0) |
| | | { |
| | |
| | | { |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Sc_ICMOBillMain |
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |
| | | (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID |
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HISENTRUST,HISREWORK) |
| | | values('3710'," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + |
| | | values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + |
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" + |
| | | ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID + |
| | | "," + HCenterID + "," + HPlanQty + ",0,0,0,0,'',''" + "," + HISENTRUST + "," + HISREWORK + ") "); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | | { |
| | | if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·²å®¡æ ¸,ä¸å
许修æ¹!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ä¿®æ¹ |
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
| | | "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + |
| | |
| | | ,HBeginDate,HEndDate |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney |
| | | ,HINSTOCKTYPE,HCHECKPRODUCT,HQAIP,HISBACKFLUSH,HREQSRC,HSTOCKINQUASELAUXQTY,HSeOrderEntrySEQ,HPROJECTNO,HPRODUCTTYPE,HCOSTRATE,HBASEUNITID) |
| | | ,HINSTOCKTYPE,HCHECKPRODUCT,HQAIP,HISBACKFLUSH,HREQSRC,HSTOCKINQUASELAUXQTY,HSeOrderEntrySEQ,HPROJECTNO,HPRODUCTTYPE,HCOSTRATE,HBASEUNITID |
| | | ,HSTOCKINORGID) |
| | | values({HInterID},{i},{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} |
| | | ,0,0,'','',0,0,{HINSTOCKTYPE},{HCHECKPRODUCT},{HQAIP},{HISBACKFLUSH},{HREQSRC},{HSTOCKINQUASELAUXQTY},{HSeOrderEntrySEQ},{HPROJECTNO},{HPRODUCTTYPE},{HCOSTRATE},{HBASEUNITID})"); |
| | | ,0,0,'','',0,0,{HINSTOCKTYPE},{HCHECKPRODUCT},{HQAIP},{HISBACKFLUSH},{HREQSRC},{HSTOCKINQUASELAUXQTY},{HSeOrderEntrySEQ},{HPROJECTNO},{HPRODUCTTYPE},{HCOSTRATE},{HBASEUNITID},{oSub.HSTOCKINORGID})"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | { |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Sc_ICMOBillMain |
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |
| | | (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID |
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate) |
| | | values('3710'," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + |
| | | 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 + ",'','') "); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | | { |
| | | if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·²å®¡æ ¸,ä¸å
许修æ¹!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //ä¿®æ¹ |
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + |
| | |
| | | ,HPlanBeginDate,HPlanEndDate |
| | | ,HBeginDate,HEndDate |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HBomID,HEntryCusID |
| | | ,HBomID,HEntryCusID,HSTOCKINORGID |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterID},{HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,'{(oSub.HBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HBeginDate.ToString())}','{(oSub.HEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HEndDate.ToString())}' |
| | | ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} |
| | | ,{oSub.HBomID} ,{oSub.HCusID} |
| | | ,{oSub.HBomID} ,{oSub.HCusID} ,{oSub.HSTOCKINORGID} |
| | | ,0,0,'','',0,0)"); |
| | | |
| | | |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "忮䏿¯æªå®¡æ ¸ç¶æ,ä¸å
许å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | oCN.RunProc("delete from Sc_ICMOBillMain where HInterID=" + HInterID); |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID=" + HInterID); |
| | | oCN.Commit();//æäº¤äºå¡ |