| | |
| | | ",HProjectNum='" + omodel.HProjectNum.ToString() + "'" + |
| | | ",HMateOutBatchNo='" + omodel.HMateOutBatchNo + "'" + |
| | | ",HBLFlag='" + (omodel.HBLFlag ? 1 : 0) + "'" + |
| | | ",HMachineLine='" + omodel.HMachineLine + "'" + |
| | | ",HXTNumber='" + omodel.HXTNumber + "'" + |
| | | ",HXTModel='" + omodel.HXTModel + "'" + |
| | | ",HRemark2='" + omodel.HRemark2 + "'" + |
| | |
| | | ",HAl1Long='" + omodel.HAl1Long + "'" + |
| | | ",HDensity='" + omodel.HDensity + "'" + |
| | | ",HTela='" + omodel.HTela + "'" + |
| | | ",HSplitSumQty='" + omodel.HSplitSumQty + "'" + |
| | | ",HSplitColorQty='" + omodel.HSplitColorQty + "'" + |
| | | ",HUnderTela='" + omodel.HUnderTela + "'" + |
| | | ",HSizing='" + omodel.HSizing + "'" + |
| | | ",HSellDate='" + omodel.HSellDate + "'" + |
| | |
| | | ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HPRDORGID,HBLFlag,HCusNumber,HPickLabel,HPickLabelNumber,HXTNumber,HXTModel,HWorkBillSortNo" + |
| | | ", HRoutingBillID,HMaterModel,HWidth,HWeight,HAuxQty,HAuxUnit,HSplitNo" + |
| | | ",HHeight,HInches,HAl1Long,HDensity,HTela,HUnderTela,HSizing,HSellDate" + |
| | | ",HRemark2,HRemark3,HEmpID,HCusID,HColorRemark) " + |
| | | ",HRemark2,HRemark3,HEmpID,HCusID,HColorRemark,HSplitSumQty,HSplitColorQty,HMachineLine) " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()," + "" + (omodel.HPrevMainSourceInterID == 0 ? omodel.HInterID : omodel.HPrevMainSourceInterID) + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HBatchNo + "'," + omodel.HMainMaterID.ToString() + "," + omodel.HKeyMaterID.ToString() + "," + omodel.HNo.ToString() + ",'" + omodel.HOrderProcNO + "'" + |
| | | "," + omodel.HWWOrderInterID.ToString() + "," + omodel.HWWOrderEntryID.ToString() + ",'" + omodel.HWWOrderBillNo + "'," + omodel.HICMOInterID.ToString() + "," + omodel.HEquipMentID.ToString() + |
| | |
| | | ",'" + 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 + ",'"+ omodel.HMaterModel + "',"+ omodel.HWidth + ","+ omodel.HWeight + ","+ omodel.HAuxQty + ","+ omodel.HAuxUnit +","+ omodel.HSplitNo +"" + |
| | | ",'" + omodel.HHeight + "','" + omodel.HInches + "','" + omodel.HAl1Long + "','" + omodel.HDensity + "','" + omodel.HTela + "','" + omodel.HUnderTela + "','" + omodel.HSizing + "','" + omodel.HSellDate + "'" + |
| | | ",'"+ omodel.HRemark2 + "','"+ omodel.HRemark3 + "',"+ omodel.HEmpID + "," + omodel.HCusID + ",'"+ omodel.HColorRemark + "')"); |
| | | ",'"+ omodel.HRemark2 + "','"+ omodel.HRemark3 + "',"+ omodel.HEmpID + "," + omodel.HCusID + ",'"+ omodel.HColorRemark + "',"+ omodel.HSplitSumQty + ","+ omodel.HSplitColorQty + ",'"+ omodel.HMachineLine + "')"); |
| | | sErr = sErr + "1;"; |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oSub in DetailColl) |
| | |
| | | public Int64 HBomID; // --BOMåID |
| | | public string HBomNumber; |
| | | public Int64 HRoutingInterID; // --å·¥èºè·¯çº¿ID |
| | | public Int64 HOWNERID; // --货主 |
| | | public string HOWNERTYPEID; // --货主类å |
| | | public DateTime HPlanBeginDate; //计åå¼å·¥æ¥æ |
| | | public DateTime HPlanEndDate; //计åå®å·¥æ¥æ |
| | | public DateTime HBeginDate; // --æè¿å¼å·¥æ¥æ |
| | |
| | | public double HReadyQty; // --é½å¥æ°é |
| | | public double? HPlanQty; //计åç产æ°é |
| | | public string HRemark; |
| | | public string HIsStockQty;//æ¯å¦ååºå |
| | | public string HRemark3;//åºé¨å¤æ³¨ |
| | | |
| | | public double HRelationQty; |
| | | public string HOrderProcNo;//订åè·è¸ªå· |
| | |
| | | public double HAuxQty;//è¾
æ°é |
| | | public int HAuxUnit;//è¾
å©åä½ |
| | | public int HSplitNo;//æåå· |
| | | public int HSplitSumQty;//æåæ»é |
| | | public int HSplitColorQty;//åç¼¸å· |
| | | public string HMachineLine;//æºå° |
| | | |
| | | public string HRemark2;//夿³¨2 |
| | | public string HRemark3;//åºé¨å¤æ³¨ |
| | |
| | | oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'"); |
| | | } |
| | | return sBillNo; |
| | | case 3: //æ ¹æ® ä¹ä¸ ï¼S + å¹´ï¼23ï¼+äºä½æµæ°´å·ï¼å®ä¾ï¼S2300001 |
| | | Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''", "Gy_MaxNum"); |
| | | sKjYear = sKjYear.Substring(2, 2); |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); |
| | | Profix = Profix.Substring(0, 1); |
| | | sBillNo = Profix.Trim() + sKjYear + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); |
| | | } |
| | | else //æå
¥æ°è®°å½ |
| | | { |
| | | sStr = new string(c, CodeLen - 1); |
| | | oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + sDay + "',1)"); |
| | | sBillNo = Profix.Trim() + sKjYear + sStr + 1; |
| | | } |
| | | if (Add == true) |
| | | { |
| | | oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''"); |
| | | } |
| | | return sBillNo; |
| | | case 4: //æ ¹æ® ä¹ä¸ å·¥åºæµè½¬å¡å·æ¹æå¹´+æ+å使µæ°´å·ï¼23050001ï¼ |
| | | Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''", "Gy_MaxNum"); |
| | | sKjYear = sKjYear.Substring(2, 2); |
| | | sPeriod = "0" + sPeriod; |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); |
| | | sBillNo = sKjYear + sPeriod + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); |
| | | } |
| | | else //æå
¥æ°è®°å½ |
| | | { |
| | | sStr = new string(c, CodeLen - 1); |
| | | oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + sDay + "',1)"); |
| | | sBillNo = sKjYear + sPeriod + sStr + 1; |
| | | } |
| | | if (Add == true) |
| | | { |
| | | oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='0' and whcode=''"); |
| | | } |
| | | return sBillNo; |
| | | default: |
| | | return sBillNo; |
| | | |
| | |
| | | if (LogTF == 1 || LogTF == 3)//éè¦å¤ææé |
| | | { |
| | | //æ ¹æ®ç¨æ·åç§°å¤ææé |
| | | DsUser = oCn.RunProcReturn("select * from gy_czygl where czymc='" + UserID.Trim() + "'", "gy_czygl"); |
| | | DsUser = oCn.RunProcReturn("select ManagerFlag,isnull(AuthorityID,'') AuthorityID,Czybm from gy_czygl where czymc='" + UserID.Trim() + "'", "gy_czygl"); |
| | | if (DsUser.Tables[0].Rows.Count == 0) |
| | | { |
| | | if (Msg == true) |
| | |
| | | } |
| | | else |
| | | { |
| | | if (DsUser.Tables[0].Rows[0]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") |
| | | if (ClsPub.isStrNull(DsUser.Tables[0].Rows[0]["AuthorityID"]).Length > ModID |
| | | && DsUser.Tables[0].Rows[0]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") |
| | | { |
| | | HavRight = true; |
| | | } |
| | |
| | | //è·åç¨æ·ç» 并循ç¯å¤ææé |
| | | //夿è§è²æ¯å¦ææé |
| | | DsJS = oCn.RunProcReturn("select isnull(AuthorityID,'') AuthorityID from System_UserGroupinfo a inner join System_UserGroup b on a.GroupID=b.GroupID " + |
| | | " Where a.USERID='" + UserID.Trim() + "'", "gy_czygl"); |
| | | " Where a.USERID='" + DsUser.Tables[0].Rows[0]["Czybm"].ToString().Trim() + "'", "gy_czygl"); |
| | | if (DsJS == null) |
| | | { |
| | | HavRight = false; |
| | |
| | | { |
| | | omodel.Kf_SellOutBillCheck_MultilineCtl = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Kf_SellOutBillCheck_SourceBarCodeCtl") |
| | | { |
| | | omodel.Kf_SellOutBillCheck_SourceBarCodeCtl = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //å
¶ä»åºåºå |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Kf_OtherOutBill_AutoCheck") |
| | |
| | | omodel.Sc_MESProceReportWorkBill_AutoCheck = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //æ¡ç 主档å é¤äººå¿
é¡»æ¯å¶å人ï¼'Y'为æ§å¶ï¼ |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "BarCode_DeleterAndMakerMustSame") |
| | | { |
| | | omodel.BarCode_DeleterAndMakerMustSame = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //-==================ç产订å |
| | | //ç产订å忥æ¶èªå¨çææµè½¬å¡ |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ICMOBill_AutoProcExchBill") |
| | | { |
| | | omodel.Sc_ICMOBill_AutoProcExchBill = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ICMOBill_DeleterAndMakerMustSame") |
| | | { |
| | | omodel.Sc_ICMOBill_DeleterAndMakerMustSame = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | |
| | | //-==================å·¥åºæµè½¬å¡ |
| | | //å·¥åºæµè½¬å¡ä¿åèªå¨åæ¥æ¡ç æ¡£æ¡ |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ProcessExchangeBill_AutoBarCode") |
| | | { |
| | | omodel.Sc_ProcessExchangeBill_AutoBarCode = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ProcessExchangeBill_DeleterAndMakerMustSame") |
| | | { |
| | | omodel.Sc_ProcessExchangeBill_DeleterAndMakerMustSame = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | |
| | | ////=========å·¥åºè¿ç«å |
| | | ////èªå¨å¹é
æµæ°´å· |
| | | //if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "MES_StationBill_ProcNo") |
| | |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Kf_SellOutBillCheck_MultilineCtl") |
| | | { |
| | | omodel.Kf_SellOutBillCheck_MultilineCtl = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Kf_SellOutBillCheck_SourceBarCodeCtl") |
| | | { |
| | | omodel.Kf_SellOutBillCheck_SourceBarCodeCtl = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //============å
¶ä»åºåºå |
| | |
| | | { |
| | | omodel.Sc_ICMOBill_AutoProcExchBill = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ICMOBill_DeleterAndMakerMustSame") |
| | | { |
| | | omodel.Sc_ICMOBill_DeleterAndMakerMustSame = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | |
| | | //-==================å·¥åºæµè½¬å¡ |
| | |
| | | { |
| | | omodel.Sc_ProcessExchangeBill_AutoBarCode = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_ProcessExchangeBill_DeleterAndMakerMustSame") |
| | | { |
| | | omodel.Sc_ProcessExchangeBill_DeleterAndMakerMustSame = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | |
| | | //-======å·¥åºè¿ç«æ¥æ¶å |
| | |
| | | //========================================================================================WMSæ¡ç ç³»ç»åæ° |
| | | |
| | | //çäº§æ±æ¥å |
| | | public string Sc_ICMOReportBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOReportBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOReportBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_ICMOReportBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Sc_ICMOReportBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Sc_ICMOReportBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Sc_ICMOReportBill_DeleterAndMakerMustSame; //çäº§æ±æ¥åæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //æ¶æéç¥å(éè´§åãå°è´§ç¡®è®¤ï¼ |
| | | public string Cg_POInStockBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Cg_POInStockBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Cg_POInStockBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Cg_POInStockBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Cg_POInStockBill_BarCodeCtl; //å°è´§ç¡®è®¤å¿
é¡»æ«ç ç®±æ¡ç |
| | | public string Cg_POInStockBill_DeleterAndMakerMustSame; //éè´§åï¼æ¶æåï¼å é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //éè´å
¥åº |
| | | public string Kf_POStockInBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_POStockInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_POStockInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_POStockInBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_POStockInBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_POStockInBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_POStockInBill_DeleterAndMakerMustSame; //éè´å
¥åºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //产åå
¥åº |
| | | public string Kf_ProductInBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_ProductInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_ProductInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_ProductInBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_ProductInBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_ProductInBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_ProductInBill_DeleterAndMakerMustSame; //产åå
¥åºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å
¶ä»å
¥åº |
| | | public string Kf_OtherInBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_OtherInBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_OtherInBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_OtherInBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_OtherInBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //å§å¤å
¥åº |
| | | public string Kf_EntrustInBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_EntrustInBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_EntrustInBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_EntrustInBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_EntrustInBill_DeleterAndMakerMustSame; //å§å¤å
¥åºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //çäº§é¢æ |
| | | public string Kf_MateOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MateOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MateOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MateOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MateOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //éå®åºåº |
| | | public string Kf_SellOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_SellOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_SellOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_SellOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_SellOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_SellOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_SellOutBillCheck_MustQtyCtl; //æ ¡éªæ°éæ§å¶ |
| | | public string Kf_SellOutBillCheck_WHSPCtl; //æ ¡éª-æ¯å¦æ ¡å¯¹ä»åºä»ä½ |
| | | public string Kf_SellOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | public string Kf_SellOutBillCheck_SourceBarCodeCtl; //æ ¡éª-æ¯å¦è¿è¡æºåå¯¹åºæ¡ç æ ¸å¯¹ï¼'Y'ä¸ºæ ¸å¯¹ï¼ |
| | | |
| | | //å
¶ä»åºåº |
| | | public string Kf_OtherOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_OtherOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_OtherOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_OtherOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_OtherOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //å§å¤åºåº |
| | | public string Kf_EntrustOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_EntrustOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_EntrustOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_EntrustOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_EntrustOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //ç产补æ |
| | | public string Kf_MateReplenishOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateReplenishOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateReplenishOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MateReplenishOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MateReplenishOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MateReplenishOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MateReplenishOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //å§å¤è¡¥æ |
| | | public string Kf_EntrustReplenishOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustReplenishOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustReplenishOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_EntrustReplenishOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_EntrustReplenishOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_EntrustReplenishOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_EntrustReplenishOutBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //ç´æ¥è°æ¨ |
| | | public string Kf_MoveStockBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MoveStockBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MoveStockBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MoveStockBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MoveStockBillCheck_MultilineCtl; //æ ¡éª-å¤è¡ç¸åç©æèªå¨æåæ¢è¡å¹é
|
| | | |
| | | //忥å¼è°åºå |
| | | public string Kf_MoveStockStepOutBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockStepOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockStepOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MoveStockStepOutBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MoveStockStepOutBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MoveStockStepOutBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MoveStockStepOutBill_DeleterAndMakerMustSame; //忥å¼è°åºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //忥å¼è°å
¥å |
| | | public string Kf_MoveStockStepInBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockStepInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MoveStockStepInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MoveStockStepInBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MoveStockStepInBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MoveStockStepInBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MoveStockStepInBill_DeleterAndMakerMustSame; //忥å¼è°å
¥åæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //éè´éæ |
| | | public string Kf_POStockInBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_POStockInBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_POStockInBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_POStockInBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_POStockInBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_POStockInBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_POStockInBackBill_DeleterAndMakerMustSame; //éè´éæåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //产åéåº |
| | | public string Kf_ProductInBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_ProductInBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_ProductInBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_ProductInBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_ProductInBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_ProductInBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_ProductInBackBill_DeleterAndMakerMustSame; //产åéåºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å
¶ä»å
¥åºçº¢å |
| | | public string Kf_OtherInBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherInBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherInBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_OtherInBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_OtherInBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_OtherInBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_OtherInBackBill_DeleterAndMakerMustSame; //å
¶ä»å
¥åºçº¢ååæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å§å¤éåº |
| | | public string Kf_EntrustInBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustInBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustInBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_EntrustInBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_EntrustInBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_EntrustInBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_EntrustInBackBill_DeleterAndMakerMustSame; //å§å¤éåºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //çäº§éæ |
| | | public string Kf_MateOutBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateOutBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_MateOutBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_MateOutBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_MateOutBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_MateOutBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_MateOutBackBill_DeleterAndMakerMustSame; //ç产éæåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //éå®éåº |
| | | public string Kf_SellOutBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_SellOutBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_SellOutBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_SellOutBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_SellOutBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_SellOutBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_SellOutBackBill_DeleterAndMakerMustSame; //éå®éåºåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å
¶ä»åºåºçº¢å |
| | | public string Kf_OtherOutBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherOutBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_OtherOutBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_OtherOutBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_OtherOutBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_OtherOutBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_OtherOutBackBill_DeleterAndMakerMustSame; //å
¶ä»åºåºçº¢ååæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å§å¤éæ |
| | | public string Kf_EntrustOutBackBill_AutoCheck; //æ¯å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustOutBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Kf_EntrustOutBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Kf_EntrustOutBackBill_ERPMode; //WMSç³»ç»åæ¥è³ERPçç±»åï¼WISEãCLOUDãæ ï¼ |
| | | public string Kf_EntrustOutBackBill_MustQtyCtl; //åºæ¶æ°éæ§å¶ï¼å°äºçäºåºæ¶ãå®å
¨çäºåºæ¶ã䏿§å¶ï¼ |
| | | public string Kf_EntrustOutBackBill_MulSourceBill; //夿ºåæ¨¡å¼ |
| | |
| | | public string Kf_EntrustOutBackBill_DeleterAndMakerMustSame; //å§å¤éæåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //çäº§ç»æ |
| | | public string Sc_PackUnionBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_PackUnionBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_PackUnionBill_SourceBillTypeCtl; //æªå
¥åºæ¡ç è¿è¡ç»ææ¶ï¼è¿è¡åæºåç±»åæ§å¶ï¼Y为æ§å¶ï¼ |
| | | public string Sc_PackUnionBill_SourceBillNoCtl; //æªå
¥åºæ¡ç è¿è¡ç»ææ¶ï¼è¿è¡åæºåæ§å¶ï¼Y为æ§å¶ï¼ |
| | | public string Sc_PackUnionBill_DeleterAndMakerMustSame; //çäº§ç»æåæåå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //WMS éç¨ |
| | | public string WMS_ERPStockCtl;//ERPè´åºåæ§å¶ï¼ç©æåºåï¼ |
| | |
| | | //====================================================å·¥åºæµè½¬WIP |
| | | |
| | | //ç产订å |
| | | public string Sc_ICMOBill_AutoProcExchBill; //ç产订å忥æ¶èªå¨çææµè½¬å¡ |
| | | public string Sc_ICMOBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_ICMOBill_AutoProcExchBill; //ç产订å忥æ¶èªå¨çææµè½¬å¡ |
| | | public string Sc_ICMOBill_DeleterAndMakerMustSame; //ç产订åå é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å·¥åºæµè½¬å¡ |
| | | public string Sc_ProcessExchangeBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ProcessExchangeBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_ProcessExchangeBill_AutoBarCode; //å·¥åºæµè½¬å¡ä¿åèªå¨åæ¥æ¡ç æ¡£æ¡ |
| | | public string Sc_ProcessExchangeBill_DeleterAndMakerMustSame; //å·¥åºæµè½¬å¡å é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //å·¥åºè¿ç«æ¥æ¶å |
| | | public string MES_StationInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string MES_StationInBill_FIFOCtl; //å·¥ç«æå·¥åºå
è¿å
åºï¼æ¬çäº§èµæº æåæ®æ²¡æåºç«åï¼ä¸è½è¿ç«å
¶ä»åæ®ï¼ |
| | | public string MES_StationInBill_FullMoveCtl; //ä¸éå®å
¨åºç«æ§å¶ï¼æ¬éè¿ç«æ¶ï¼ä¸éçæ¥åº+åæ ¼å¿
é¡»çäºä¸éè¿ç«æ°é |
| | | public string MES_StationInBill_QtyCtl; //è¿ç«æ°éä¸è½å¤§äºä¸éåºç«æ±æ»åæ ¼æ° |
| | |
| | | public string MES_StationInBill_PreQtyCtl; //æ¬éè¿ç«æ°éä¸è½å¤§äºä¸éåºç«åæ ¼æ°é |
| | | |
| | | //å·¥åºåºç«æ±æ¥å |
| | | public string MES_StationOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string MES_StationOutBill_QtyCtl; //åºç«æ°éä¸è½å¤§äºæ¬éè¿ç«æ±æ»æ° |
| | | public string MES_StationOutBill_QtyPreQtyCtl; //åºç«æ°é(åæ ¼æ°éææ»æ°é)æ±æ»ä¸è½å¤§äºä¸éåæ ¼æ±æ»æ° |
| | | public string MES_StationOutBill_QtyNextQtyCtl; //åºç«æ°é(åæ ¼æ°éææ»æ°é)æ±æ»ä¸è½å¤§äºä¸éåæ ¼æ±æ»æ° |
| | |
| | | public string MES_StationOutBill_NextQtyCtl; //æ¬éåºç«æ°éä¸å
许å°äºä¸éè¿ç«æ°é |
| | | |
| | | //ä¸è¯åè¯å®¡å |
| | | public string QC_NoPassProdCheckBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string QC_NoPassProdCheckBill_QtyCtl; //ä¸è¯åæ°ä¸è½å¤§äºåºç«åæ¥åºæ°é |
| | | public string QC_NoPassProdCheckBill_BadReasonQtyCtrl; //ä¸è¯åè¯å®¡åä¸è¯æ°éåä¸è¯åå æ»æ°å¿
é¡»ä¸è´ |
| | | public string QC_NoPassProdCheckBill_DeleteCtl; //å é¤åæ®æ¶å¶å人ä¸å é¤äººå¿
é¡»ä¸è´ |
| | | //å·¥åºå§å¤ååºå |
| | | public string MES_StationEntrustInBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string MES_StationEntrustInBill_FIFOCtl; //å·¥ç«æå·¥åºå
è¿å
åºï¼åä¸ï¼ |
| | | public string MES_StationEntrustInBill_FullMoveCtl; //ä¸éå®å
¨åºç«æ§å¶ï¼åä¸ï¼ |
| | | public string MES_StationEntrustInBill_QtyCtl; //è¿ç«æ°éä¸è½å¤§äºä¸éåºç«æ±æ»åæ ¼æ°ï¼åä¸ï¼ |
| | |
| | | public string MES_StationEntrustInBill_DeleteCtl; //å é¤åæ®æ¶å¶å人ä¸å é¤äººå¿
é¡»ä¸è´ |
| | | public string MES_StationEntrustInBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | //å·¥åºå§å¤æ¥æ¶å |
| | | public string MES_StationEntrustOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string MES_StationEntrustOutBill_QtyCtl; //åºç«æ°éä¸è½å¤§äºæ¬éè¿ç«æ±æ»æ° |
| | | public string MES_StationEntrustOutBill_DeleteCtl; //å é¤åæ®æ¶å¶å人ä¸å é¤äººå¿
é¡»ä¸è´ |
| | | public string MES_StationEntrustOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | |
| | | |
| | | |
| | | //å¼çå |
| | | public string Sc_MESBeginWorkBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MESBeginWorkBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MESBeginWorkBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MESBeginWorkBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //è¿å·¥å |
| | | public string Sc_MESReturnWorkBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MESReturnWorkBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MESReturnWorkBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MESReturnWorkBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //ç»çå |
| | | public string Sc_MESEndWorkBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MESEndWorkBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MESEndWorkBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MESEndWorkBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //åå·¥æèµ·å |
| | | public string Sc_MESStopWorkBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MESStopWorkBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MESStopWorkBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MESStopWorkBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //äº§éæ±æ¥å |
| | | public string Sc_ICMOBillWorkQtyStatus_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOBillWorkQtyStatus_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOBillWorkQtyStatus_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_ICMOBillWorkQtyStatus_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //è´¨éæ±æ¥å |
| | | public string Sc_ICMOBillQualityStatus_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOBillQualityStatus_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_ICMOBillQualityStatus_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_ICMOBillQualityStatus_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //䏿é²éå |
| | | public string Sc_MaterToSourceBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MaterToSourceBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MaterToSourceBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MaterToSourceBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | public string Sc_MaterToSourceBill_MouldLifeCtrl; //ä¿åæ¶å¨å
·å¯¿å½æ§å¶ ï¼Y æ§å¶ï¼ N 䏿§å¶ å½å¨å
·é¢è®¡å¯¿å½æè
å½å寿å½ä¸è¶³æ¶ï¼ä¸å
è®¸ä¸æï¼ |
| | | public string Sc_MaterToSourceBill_MouldLifeCtrlType; //ä¿åæ¶å¨å
·å¯¿å½æ§å¶ç±»å ï¼Y å¼ºå¶æ§å¶ï¼ N ä»
æç¤ºï¼ |
| | | //å¼å¸¸åé¦å |
| | | public string OA_ErrMsgBackBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string OA_ErrMsgBackBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string OA_ErrMsgBackBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string OA_ErrMsgBackBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | //æ¥å·¥å°å·¥åºæ±æ¥ |
| | | public string Sc_MESProceReportWorkBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MESProceReportWorkBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MESProceReportWorkBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MESProceReportWorkBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | //QMS |
| | | |
| | | //é¦ä»¶æ£éªå |
| | | public string QC_FirstPieceCheckBill_AutoCheck; //ä¿ååå为æ°å¢ç¶æ |
| | | public string QC_FirstPieceCheckBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string QC_FirstPieceCheckBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string QC_FirstPieceCheckBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | |
| | | |
| | | |
| | | //EAM |
| | | |
| | | //å¨å
·é¢ç¨åºåºå |
| | | public string Sc_MouldProdOutBill_AutoCheck; //èªå¨å®¡æ ¸ |
| | | public string Sc_MouldProdOutBill_SaveAutoAddnew; //ä¿ååèªå¨æ°å¢ |
| | | public string Sc_MouldProdOutBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Sc_MouldProdOutBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Sc_MouldProdOutBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | public string Sc_MouldProdOutBill_MouldLifeCtrl; //ä¿åæ¶å¨å
·å¯¿å½æ§å¶ ï¼Y æ§å¶ï¼ N 䏿§å¶ å½å¨å
·é¢è®¡å¯¿å½æè
å½å寿å½ä¸è¶³æ¶ï¼ä¸å
许é¢ç¨ï¼ |
| | | public string Sc_MouldProdOutBill_MouldLifeCtrlType; //ä¿åæ¶å¨å
·å¯¿å½æ§å¶ç±»å ï¼Y å¼ºå¶æ§å¶ï¼ N ä»
æç¤ºï¼ |
| | | |
| | | |
| | | //å·¥èºè·¯çº¿ |
| | | public string Gy_RoutingBill_SaveAutoLastProc; //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | public string Gy_RoutingBill_AutoCheck; //ä¿å忝å¦èªå¨å®¡æ ¸ |
| | | public string Gy_RoutingBill_SaveAutoAddnew; //ä¿ååå为æ°å¢ç¶æ |
| | | public string Gy_RoutingBill_DeleterAndMakerMustSame; //å é¤äººå¿
é¡»æ¯å¶å人 |
| | | public string Gy_RoutingBill_SaveAutoLastProc; //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | |
| | | |
| | | ////å·¥åºè¿ç«å |
| | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | oCN.BeginTran();//å¼å¯äºå¡ |
| | | |
| | | oCN.RunProc($"delete from h_v_System_UserGroup where HGroupID={HInterID}"); |
| | | //å é¤è§è²è¡¨ |
| | | oCN.RunProc($"delete from System_UserGroup where GroupID={HInterID}"); |
| | | //å é¤å
³èçç¨æ·å
³ç³» |
| | | oCN.RunProc($"delete from System_UserGroupInfo where GroupId={HInterID}"); |
| | | |
| | | oCN.Commit();//ç»æäºå¡ |
| | | |
| | |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Gy_ICBomBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | mainList[0].HBillNo = DBUtility.ClsPub.CreateBillCode("3302", ref DBUtility.ClsPub.sExeReturnInfo,true); |
| | | oCN.RunProc("Insert Into Gy_ICBomBillMain " + |
| | | "(HBillType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HMaterTypeID,HStatus" + |
| | |
| | | string sql1 = string.Format(@"select * from h_v_Gy_MaterialList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ç©æä»£ç ", "h_v_Gy_MaterialList"); |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + " order by ç©æä»£ç desc", "h_v_Gy_MaterialList"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + " order by ç©æä»£ç "; |
| | | string sql = sql1 + sWhere + " order by ç©æä»£ç desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_MaterialList"); |
| | | } |
| | | |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç©æå±æ§ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.Message = "ä¿å失败ï¼ç©æåç±»ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | |
| | | string HInterID = HInter.Replace("\"", ""); |
| | | string user = sArray[1].ToString(); |
| | | string HBarCode = sArray[2].ToString().Replace("\"",""); |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBillList_Edit", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | try |
| | | { |
| | |
| | | |
| | | string[] NewBarCode; |
| | | NewBarCode = HBarCode.Split(Convert.ToChar(",")); |
| | | |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_BarCodeBill_Del", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //å 餿¡ç åè¿è¡å¤æ |
| | | Ds = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_MulDelete_Before '" + HInterID + "','" + HBarCode + "'", "h_p_Gy_BarCodeBill_MulDelete_Before", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Delete from Gy_BarCodeBill Where HItemID in (" + HInterID + ")"); |
| | | |
| | | //è·åç³»ç»åæ° |
| | | string Ret = ""; |
| | | if (oSystemParameter.ShowBill(ref Ret)) |
| | | { |
| | | //夿æ¯å¦åªè½å é¤èªå·±çæçæ¡ç |
| | | if (oSystemParameter.omodel.BarCode_DeleterAndMakerMustSame == "Y") //ç³»ç»åæ° |
| | | { |
| | | oCN.RunProc("Delete from Gy_BarCodeBill Where HItemID in (" + HInterID + ")" + " and HMaker = '" + user + "'"); |
| | | } |
| | | else |
| | | { |
| | | oCN.RunProc("Delete from Gy_BarCodeBill Where HItemID in (" + HInterID + ")"); |
| | | } |
| | | } |
| | | |
| | | //åå
¥ç³»ç»æ¥å¿ |
| | | for (int i = 0; i <= NewBarCode.Length - 1; i++) |
| | |
| | | long HCenterID = list[0].HCenterID;//å·¥ä½ä¸å¿ID |
| | | string HOrderProcNO = list[0].HOrderProcNO;//订åè·è¸ªå· |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | double HmaterOutqty = list[0].HmaterOutqty;//ç½å¯åå¸ |
| | | //忮宿´æ§å¤æ |
| | | if (HMaterID <= 0) |
| | | { |
| | |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HSupID,HQty,HPrice,HMoney,HPieceQty,HSourceName,HCenterID" + |
| | | ",HProcNo,HOrderProcNO,HMainInterID,HPRDOrgID" + |
| | | ",HmaterOutqty" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "'" + |
| | |
| | | "," + HGroupID + "," + HDeptID + "," + HEmpID + ",'" + HBarCode + "','" + HAddr + "','" + HBarCodeMaker + "',getdate()" + |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HPieceQty + ",'" + HSourceName + "'," + HCenterID + |
| | | ",'" + HProcNo + "','" + HOrderProcNO + "','" + HMainInterID + "'," + HPRDOrgID + |
| | | ") "); |
| | | ","+ HmaterOutqty + ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | | { |
| | |
| | | ",HProcExchBillNo='" + HProcExchBillNo + "'" + |
| | | ",HMaterID=" + HMaterID + |
| | | ",HProcID=" + HProcID + |
| | | ",HmaterOutqty=" + HmaterOutqty + |
| | | ",HICMOQty=" + HICMOQty + |
| | | ",HPlanQty=" + HPlanQty + |
| | | ",HStationInTime=getdate()" + |
| | |
| | | DAL.ClsSc_StationInBill oBill = new DAL.ClsSc_StationInBill(); |
| | | if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | if (oSystemParameter.omodel.MES_StationInBill_DeleteCtl == "Y") |
| | | { |
| | | if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | |
| | | double HWorkTimes = list[0].HWorkTimes;//å·¥æ¶ |
| | | long HQCCheckID = list[0].HQCCheckID;//æ£éªåID |
| | | long HPRDOrgID = list[0].HPRDOrgID;//ç»ç»ID |
| | | double HmaterOutqty = list[0].HmaterOutqty;//ç½å¯åå¸ |
| | | //忮宿´æ§å¤æ |
| | | if (HProcExchInterID <= 0) |
| | | { |
| | |
| | | if (oSystemParameter.ShowBill(ref Ret)) |
| | | { |
| | | //夿客æ·ä¸ä¸ºé¾å±±æ±½é
|
| | | if (oSystemParameter.omodel.WMS_CampanyName != "é¾å±±æ±½é
") //ç³»ç»åæ° |
| | | if (oSystemParameter.omodel.WMS_CampanyName != "é¾å±±æ±½é
"&& oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º") //ç³»ç»åæ° |
| | | { |
| | | if (HSourceID == 0) |
| | | { |
| | |
| | | ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" + |
| | | ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + |
| | | ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" + |
| | | ",HmaterOutqty" + |
| | | ") " + |
| | | " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + |
| | |
| | | "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" + |
| | | "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + |
| | | "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID + |
| | | ") "); |
| | | ","+ HmaterOutqty + ") "); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | | { |
| | |
| | | DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill(); |
| | | if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | if (oSystemParameter.omodel.MES_StationOutBill_DeleteCtl == "Y") |
| | | { |
| | | if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ä¸è¯æç»è¯çæ¥è¡¨ æ¥è¯¢ |
| | | |
| | | #region 车é´çäº§æ±æ¥ç»è®¡è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/StationOutSumReportList")] |
| | | [HttpGet] |
| | | public object StationOutSumReportList(string sWhere) |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region è®¡ä»¶å·¥èµæ¥è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/EmployeePiecePayReport")] |
| | | [HttpGet] |
| | | public object EmployeePiecePayReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | //ååºååä¼ éçå¼ |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePiecePayReport " + sWhere + "", "h_p_Sc_EmployeePiecePayReport"); |
| | | |
| | | List<object> listCol = new List<object>(); |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | listCol.Add(JsonConvert.DeserializeObject(str)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = listCol; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region è®¡ä»¶å·¥èµæ±æ»æ¥è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/EmployeePiecePaySumReport")] |
| | | [HttpGet] |
| | | public object EmployeePiecePaySumReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | //ååºååä¼ éçå¼ |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePiecePaySumReport " + sWhere + "", "h_p_Sc_EmployeePiecePaySumReport"); |
| | | |
| | | List<object> listCol = new List<object>(); |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | listCol.Add(JsonConvert.DeserializeObject(str)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = listCol; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region å·¥èµæ±æ¥æ¥æ¥è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/EmployeePieceWorkReport")] |
| | | [HttpGet] |
| | | public object EmployeePieceWorkReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | //ååºååä¼ éçå¼ |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_EmployeePieceWorkReport " + sWhere + "", "h_p_Sc_EmployeePieceWorkReport"); |
| | | |
| | | List<object> listCol = new List<object>(); |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | listCol.Add(JsonConvert.DeserializeObject(str)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = listCol; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region ç产车é´å·¥åºæ¥è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/WorkShopProcessWIPReport")] |
| | | [HttpGet] |
| | | public object WorkShopProcessWIPReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | //ååºååä¼ éçå¼ |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_WorkShopProcessWIPReport " + sWhere + "", "h_p_Sc_WorkShopProcessWIPReport"); |
| | | |
| | | List<object> listCol = new List<object>(); |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | listCol.Add(JsonConvert.DeserializeObject(str)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = listCol; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region å·¥åºå¨å¶åæ¥è¡¨ æ¥è¯¢ |
| | | [Route("Mes_OrderProcFlowAllReport/WorkShopProcessWIPSumReport")] |
| | | [HttpGet] |
| | | public object WorkShopProcessWIPSumReport(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | //ååºååä¼ éçå¼ |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Sc_WorkShopProcessWIPSumReport " + sWhere + "", "h_p_Sc_WorkShopProcessWIPSumReport"); |
| | | |
| | | List<object> listCol = new List<object>(); |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | | { |
| | | Type dataType = col.DataType; |
| | | string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; |
| | | listCol.Add(JsonConvert.DeserializeObject(str)); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = listCol; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | #region[æ°å¢åæ®-ä¿åæé®] |
| | | /// <summary> |
| | |
| | | //} |
| | | #endregion |
| | | |
| | | #region[æ°å¢åæ®-ä¿åæé®-æ¹éå¤å¶] |
| | | /// <summary> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Sc_ProcessExchangeBill/AddBill_Copy_pl")] |
| | | [HttpPost] |
| | | public object AddBill_Copy_pl([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | int msg2 = int.Parse(sArray[0].ToString()); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | | string sReturn = ""; |
| | | try |
| | | { |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, msg4)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | DBUtility.ClsPub.HOrgID = long.Parse(msg5); |
| | | DBUtility.ClsPub.CurUserName = msg4; |
| | | oBill.ShowBill(long.Parse(msg3), ref sReturn); |
| | | |
| | | ds = oCN.RunProcReturn("select isnull(sum(HQty),0) from Sc_ProcessExchangeBillMain where HICMOBillNo='" + oBill.omodel.HICMOBillNo + "' and HInterID <>"+ oBill.omodel.HInterID, "Sc_ProcessExchangeBillMain"); |
| | | var HQty = double.Parse(ds.Tables[0].Rows[0][0].ToString()); |
| | | int num = 0; |
| | | //åæ®æ°é * å¼ æ° + å·²çæä¸å
æ¬æ¬åæ®çæ°é >çäº§è®¢åæ°é |
| | | if ((oBill.omodel.HQty * msg2) + HQty > oBill.omodel.HPlanQty) |
| | | { |
| | | if (((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) % oBill.omodel.HQty) == 0) |
| | | { |
| | | num = (int)((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) / oBill.omodel.HQty); |
| | | } else |
| | | { |
| | | num = (int)((oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty) / oBill.omodel.HQty); |
| | | num += 1; |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æå¤å¯ä»¥å¤å¶" + num + "å¼ ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (num == 0) { |
| | | double HPlanQty = oBill.omodel.HPlanQty - oBill.omodel.HQty - HQty; |
| | | for (int i = 0; i < msg2; i++) |
| | | { |
| | | oBill.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode("3772", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | oBill.omodel.HDate =DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | oBill.omodel.HChecker = ""; |
| | | oBill.omodel.HCheckDate = ""; |
| | | oBill.omodel.HMaker = msg4; |
| | | |
| | | if (HPlanQty < oBill.omodel.HQty) |
| | | { |
| | | oBill.omodel.HQty = HPlanQty; |
| | | } |
| | | |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | |
| | | bResult = oBill.AddBill(ref sReturn); |
| | | if (bResult) |
| | | { |
| | | num++; |
| | | HPlanQty -= oBill.omodel.HQty; |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å¤å¶äº" + num + "å¼ åæ®ï¼"; |
| | | 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> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessExchangeBill/DeltetProcessExchangeBillByID")] |
| | | [HttpGet] |
| | | public object DeltetProcessExchangeBillByID(string HInterID,int HPRDORGID, string user) |
| | | public object DeltetProcessExchangeBillByID(string HInterID, int HPRDORGID, string user) |
| | | { |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Drop", 1, false, user)) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | 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; |
| | | } |
| | | |
| | | |
| | | //å é¤å夿å
³èæ°é |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | ds = oCn.RunProcReturn("select ct from ( " + |
| | | " select 1 ct from Sc_StationInBillMain Where HProcExchInterID=" + lngBillKey + " " + |
| | | " union all " + |
| | | " select 1 from Sc_StationOutBillMain Where HProcExchInterID=" + lngBillKey + " ) as a ", "Sc_ProcExchReportSub"); |
| | | if (ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æµè½¬å¡å·²ç»æä¸æ¸¸è¿åºç«ååï¼ä¸å
许å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | DBUtility.ClsPub.HOrgID = HPRDORGID; |
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HBillStatus > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å½åå¤äºä¸è½å é¤ç¶æ,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (oBill.omodel.HChecker != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "忮已ç»å®¡æ ¸,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (IsDete) |
| | | string[] HBillNo = HInterID.Split(','); |
| | | |
| | | foreach (var item in HBillNo) |
| | | { |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(item); |
| | | |
| | | DBUtility.ClsPub.HOrgID = HPRDORGID; |
| | | if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | if (lngBillKey == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·:"+ oBill .omodel.HBillNo+ "åæ®ID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //å é¤å夿å
³èæ°é |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | ds = oCn.RunProcReturn("select ct from ( " + |
| | | " select 1 ct from Sc_StationInBillMain Where HProcExchInterID=" + lngBillKey + " " + |
| | | " union all " + |
| | | " select 1 from Sc_StationOutBillMain Where HProcExchInterID=" + lngBillKey + " ) as a ", "Sc_ProcExchReportSub"); |
| | | if (ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·:" + oBill.omodel.HBillNo + "æµè½¬å¡å·²ç»æä¸æ¸¸è¿åºç«ååï¼ä¸å
许å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | if (oSystemParameter.omodel.Sc_ProcessExchangeBill_DeleterAndMakerMustSame == "Y") |
| | | { |
| | | if (oBill.omodel.HMaker != user && (user != "admin" && user != "Admin")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·:" + oBill.omodel.HBillNo + "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | if (oBill.omodel.HBillStatus > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·:" + oBill.omodel.HBillNo + "åæ®å½åå¤äºä¸è½å é¤ç¶æ,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | if (oBill.omodel.HChecker != "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·:" + oBill.omodel.HBillNo + "忮已ç»å®¡æ ¸,ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æªæ¾å°"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | foreach (var item in HBillNo) |
| | | { |
| | | bool IsDete = oBill.DeleteBill(long.Parse(item), ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (!IsDete) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æªæ¾å°"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | |
| | | ",HProductNum='" + HProductNum + "',HVerNum='" + HVerNum + "' where HInterID='" + HInterID + "'"); |
| | | |
| | | //å é¤å表 |
| | | oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "' and HProcNo!='9999'"); |
| | | oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "'"); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType); |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (oSub.HProcNo != "9999" || OperationType == 2) |
| | | { |
| | | oCN.RunProc("Insert into Gy_RoutingBillSub " + |
| | | "(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" + |
| | | ",HWorkQty,HCenterID,HTimeUnit,HUnitTime" + |
| | | ",HReadyTime,HQueueTime,HMoveTime" + |
| | | ",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" + |
| | | ",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" + |
| | | ",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" + |
| | | ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + |
| | | ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + |
| | | ",HTechnologyParameter,HPicNum,HProcCheckNote" + |
| | | ",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID " + |
| | | ") values(" |
| | | + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + |
| | | "," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() + |
| | | "," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) + |
| | | "," + oSub.HFixPrice.ToString() + "," + oSub.HProcPrice.ToString() + "," + oSub.HBadPrice.ToString() + "," + oSub.HWasterPrice.ToString() + "," + Convert.ToString(oSub.HStdFlag ? 1 : 0) + "," + oSub.HBeginDayQty.ToString() + "," + oSub.HBeginFixQty.ToString() + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + Convert.ToString(oSub.HAutoTrunFlag ? 1 : 0) + |
| | | "," + oSub.HFixWorkDays.ToString() + "," + oSub.HTrunWorkDays.ToString() + "," + oSub.HReadyTimes.ToString() + "," + oSub.HICMOReadyTimes.ToString() + "," + oSub.HSubStdEmpQty.ToString() + "," + oSub.HSubCanUseSourceQty.ToString() + |
| | | "," + oSub.HProcID_S.ToString() + "," + oSub.HCenterID_S.ToString() + "," + oSub.HWorkQty_S.ToString() + ", " + oSub.HSubStdEmpQty_S.ToString() + ",'" + oSub.HMouldNo + "'," + oSub.HChangeMould.ToString() + |
| | | ",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() + |
| | | ",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() + |
| | | "', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString()+"," + oSub.HWasterWHID.ToString()+"," + oSub.HWHID.ToString() + |
| | | ") "); |
| | | } |
| | | oCN.RunProc("Insert into Gy_RoutingBillSub " + |
| | | "(HInterID,HEntryID,HProcID,HProcNO,HSupID,HSupFlag" + |
| | | ",HWorkQty,HCenterID,HTimeUnit,HUnitTime" + |
| | | ",HReadyTime,HQueueTime,HMoveTime" + |
| | | ",HCloseMan,HCloseType,HRemark,HProcType,HNextProcFlag,HFlowProc" + |
| | | ",HFixPrice,HProcPrice,HBadPrice,HWasterPrice,HStdFlag,HBeginDayQty,HBeginFixQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HAutoTrunFlag" + |
| | | ",HFixWorkDays,HTrunWorkDays,HReadyTimes,HICMOReadyTimes,HSubStdEmpQty,HSubCanUseSourceQty" + |
| | | ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + |
| | | ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + |
| | | ",HTechnologyParameter,HPicNum,HProcCheckNote" + |
| | | ",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID " + |
| | | ") values(" |
| | | + HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" + |
| | | "," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() + |
| | | "," + oSub.HReadyTime.ToString() + "," + oSub.HQueueTime.ToString() + "," + oSub.HMoveTime.ToString() + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HProcType + "'," + Convert.ToString(oSub.HNextProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HFlowProc ? 1 : 0) + |
| | | "," + oSub.HFixPrice.ToString() + "," + oSub.HProcPrice.ToString() + "," + oSub.HBadPrice.ToString() + "," + oSub.HWasterPrice.ToString() + "," + Convert.ToString(oSub.HStdFlag ? 1 : 0) + "," + oSub.HBeginDayQty.ToString() + "," + oSub.HBeginFixQty.ToString() + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + Convert.ToString(oSub.HAutoTrunFlag ? 1 : 0) + |
| | | "," + oSub.HFixWorkDays.ToString() + "," + oSub.HTrunWorkDays.ToString() + "," + oSub.HReadyTimes.ToString() + "," + oSub.HICMOReadyTimes.ToString() + "," + oSub.HSubStdEmpQty.ToString() + "," + oSub.HSubCanUseSourceQty.ToString() + |
| | | "," + oSub.HProcID_S.ToString() + "," + oSub.HCenterID_S.ToString() + "," + oSub.HWorkQty_S.ToString() + ", " + oSub.HSubStdEmpQty_S.ToString() + ",'" + oSub.HMouldNo + "'," + oSub.HChangeMould.ToString() + |
| | | ",'" + oSub.HPackStd + "','" + oSub.HPack + "','" + oSub.HPutArea + "'," + oSub.HMyWorkDays.ToString() + "," + oSub.HMyFixWorkDays.ToString() + "," + oSub.HPassRate.ToString() + |
| | | ",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() + |
| | | "', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + |
| | | ") "); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | { |
| | | try |
| | | { |
| | | string flag = "flase"; |
| | | string sErrMsg = ""; |
| | | if (oSystemParameter.ShowBill(ref sErrMsg)) |
| | | { |
| | | if (oSystemParameter.omodel.Gy_RoutingBill_SaveAutoLastProc == "Y") |
| | | { |
| | | flag = "true"; |
| | | } |
| | | } |
| | | |
| | | oSystemParameter.ShowBill(ref sErrMsg); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ""; |
| | | objJsonResult.data = flag; |
| | | objJsonResult.data = oSystemParameter.omodel; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | //if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æ¥è¯¢æé!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery"); |
| | |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | //if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; |
| | | string sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc,cast(å·¥åºå· as int)"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList"); |
| | | } |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region å·¥èºè·¯çº¿(ç»´æ¤å·¥ä»·) |
| | | /// <summary> |
| | | /// è¿åå·¥èºè·¯çº¿å表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("LEMS/MES_Gy_RoutingBillMainRates_Json")] |
| | | [HttpGet] |
| | | public object MES_Gy_RoutingBillMainRates_Json(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | //夿æ¯å¦ææ¥è¯¢æé |
| | | if (!DBUtility.ClsPub.Security_Log("Gy_RoutingBill_Query", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéæ¥è¯¢!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList_MainRate order by hmainid desc", "h_v_Gy_RoutingBillList_MainRate"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_RoutingBillList_MainRate where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc,cast(å·¥åºå· as int)"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_RoutingBillList_MainRate"); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region å¤æç©ææ¯å¦å·²ç»åå¨å·¥èºè·¯çº¿ |
| | | /// <summary> |
| | | /// è¿åå·¥èºè·¯çº¿å表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("LEMS/IsExistRoutingByMaterial")] |
| | | [HttpGet] |
| | | public object IsExistRoutingByMaterial(int HMaterID, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | | ds = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HMaterID = '" + HMaterID + "'", "Gy_RoutingBillMain"); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return GetObjectJson(ds); |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | /// <summary> |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by åæ®å· desc", "h_v_IF_ICMOBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by å¶åæ¥æ desc,åæ®å· desc", "h_v_IF_ICMOBillList"); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | "-", |
| | | num27.ToString() |
| | | })); |
| | | string text20 = sBarCodeNew.Remove(0, 16); |
| | | string text21 = text20.Remove(text20.Length - 9, 9); |
| | | ClsCN clsCN3 = new ClsCN(); |
| | | string text20 = sBarCodeNew.Remove(0, 16); //SAE1300100230309 2303704250308010 |
| | | string text21 = text20.Remove(text20.Length - 9 , 9); //SAE1300100230309 2303704 250308010 |
| | | ClsCN clsCN3 = new ClsCN(); |
| | | DataSet dataSet13 = clsCN3.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + str6 + "' and huseorgid = " + HOrgID.ToString(), "Gy_Material"); |
| | | long num28 = ClsPub.isLong(dataSet13.Tables[0].Rows[0]["HItemID"]); |
| | | string text22 = ClsPub.isStrNull(dataSet13.Tables[0].Rows[0]["HName"]); |
| | |
| | | #region æ¡ä»¶æ¥è¯¢æéå表 |
| | | [Route("PublicPageMethod/PowerList")] |
| | | [HttpGet] |
| | | public object PowerList(string czybm, string sGnbm) |
| | | public object PowerList(string czybm, string sGnbm,string HSouceBillType) |
| | | { |
| | | try |
| | | { |
| | |
| | | sName = sGnbm; |
| | | } |
| | | } |
| | | if (HSouceBillType == "yh") |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl"); |
| | | } |
| | | else if (HSouceBillType == "js") |
| | | { |
| | | ds = oCN.RunProcReturn("select * from System_UserGroup where GroupID='" + czybm + "'", "System_UserGroup"); |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl"); |
| | | string AuthorityID = ClsPub.isStrNull(ds.Tables[0].Rows[0]["AuthorityID"]); |
| | | ds = oCN.RunProcReturn("SELECT id hid,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityID,'' AuthorityHID, gnms ,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sName + "' and rightflag=1 order by gnbm", "xt_xtgnb"); |
| | | ds = oCN.RunProcReturn("SELECT id hid,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityID,case when id<=" + AuthorityID.Length + " then case when SUBSTRING('" + AuthorityID + "',id,1)=1 then 1 else 0 end else 0 end AuthorityHID, gnms ,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sName + "' and rightflag=1 order by gnbm", "xt_xtgnb"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string HSouceBillType = sArray[3].ToString(); |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_UserPower(msg3); |
| | | ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + msg4.Trim() + "'", "Gy_Czygl"); |
| | | |
| | | if (HSouceBillType == "yh") |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_Czygl where czybm='" + msg4.Trim() + "'", "Gy_Czygl"); |
| | | } |
| | | else if (HSouceBillType == "js") |
| | | { |
| | | ds = oCN.RunProcReturn("select * from System_UserGroup where GroupID='" + msg4 + "'", "System_UserGroup"); |
| | | } |
| | | |
| | | string AuthorityID = ClsPub.isStrNull(ds.Tables[0].Rows[0]["AuthorityID"]); |
| | | string Auth_str = AuthorityID; |
| | | string MKID = ""; |
| | |
| | | } |
| | | oDs = null; |
| | | } |
| | | oCN.RunProc("UPDATE Gy_Czygl SET AuthorityID='" + Auth_str + "' WHERE czybm='" + msg4.Trim() + "'"); |
| | | |
| | | if (HSouceBillType == "yh") |
| | | { |
| | | oCN.RunProc("UPDATE Gy_Czygl SET AuthorityID='" + Auth_str + "' WHERE czybm='" + msg4.Trim() + "'"); |
| | | } |
| | | else if (HSouceBillType == "js") |
| | | { |
| | | oCN.RunProc("UPDATE System_UserGroup SET AuthorityID='" + Auth_str + "' WHERE GroupID='" + msg4.Trim() + "'"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æææåï¼"; |
| | |
| | | //æ£æé
é 䏿¥ |
| | | ds = oCN.RunProcReturn($"exec h_p_JIT_ComplementGoodsBillList_DownQuery '{com.HSouceInterID}',{com.HSourceEntryID}", "h_p_JIT_ComplementGoodsBillList_DownQuery"); |
| | | } |
| | | else if (com.Type == 3772) |
| | | { |
| | | //ç产订å 䏿¥ å·¥åºæµè½¬å¡ |
| | | ds = oCN.RunProcReturn($"select * from h_v_Sc_ProcessExchangeBillQuery where HICMOInterID='{com.HSouceInterID}' and HICMOEntryID={com.HSourceEntryID}", "h_v_Sc_ProcessExchangeBillQuery"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | //夿éè¶äºçäº§æ±æ¥å æ°é æ¯å¦ å¤§äº æ«éåºç«æ°é |
| | | ds = oCN.RunProcReturn($@"select sum(FFinishQty)-(select HQty from Sc_StationOutBillMain where HBillNo='{BillNo}') |
| | | from AIS20220308151944..T_PRD_MORPT rpt3 |
| | | left join AIS20220308151944..T_PRD_MORPTENTRY rpt2 on rpt3.FID = rpt2.FID |
| | | where F_bsv_Text=(select HProcExchBillNo from Sc_StationOutBillMain where HBillNo='{BillNo}')", "SumCount"); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | if (double.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0) { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "éè¶äºæ±æ¥æ°éå°äºæ¬å°åºç«æ°é!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | JObject model = new JObject(); |
| | | model.Add("FBillType", new JObject() { ["FNumber"] = "SCRKD01_SYS" }); //åæ®ç±»å |
| | | model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //åæ®æ¥æ |
| | |
| | | FentityModel.Add("FBaseRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");// |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | string sErr = ""; |
| | | |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | |
| | | |
| | | foreach (DataRow row in ds.Tables[0].Rows) |
| | | { |
| | | var strLen = row["hnumber"].ToString().Split('.'); |
| | | var strLen = row["hitemid"].ToString().Split('.'); |
| | | if (strLen.Length == 1) |
| | | { |
| | | TreeModel tree = new TreeModel(); |
| | | tree.id = row["hnumber"].ToString(); |
| | | tree.id = row["hitemid"].ToString(); |
| | | tree.title = row["hname"].ToString(); |
| | | treeModels[0].children.Add(tree); |
| | | } |
| | |
| | | if (strLen.Length == num && dt.Rows[i]["hnumber"].ToString().Contains(tree[m].id + ".")) |
| | | { |
| | | TreeModel tbjson = new TreeModel(); |
| | | tbjson.id = dt.Rows[i]["hnumber"].ToString(); |
| | | tbjson.id = dt.Rows[i]["hitemid"].ToString(); |
| | | tbjson.title = dt.Rows[i]["hname"].ToString(); |
| | | tree[m].children.Add(tbjson); |
| | | } |
| | |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(subList[i].HMaterIDCol); |
| | | oSub.HProcID = DBUtility.ClsPub.isLong(subList[i].HProcIDCol); |
| | | oSub.HSourceID = DBUtility.ClsPub.isLong(subList[i].HSourceIDCol); |
| | | oSub.HPrice = DBUtility.ClsPub.isLong(subList[i].HPriceCol); |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(subList[i].HPriceCol); |
| | | oSub.HBeginDate = DBUtility.ClsPub.isDate(subList[i].HBeginDateCol); |
| | | oSub.HEndDate = DBUtility.ClsPub.isDate(subList[i].HEndDateCol); |
| | | oSub.HCostFlag = DBUtility.ClsPub.GridToBool(subList[i].HCostFlagCol); |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region ç»´æ¤å·¥ä»·æ¶è¿åå·¥èºè·¯çº¿ä¿¡æ¯ |
| | | [Route("Gy_RoutingBill/EditPrice")] |
| | | [HttpGet] |
| | | public object EditPrice(string HMaterNumber) |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | |
| | | ds = oCN.RunProcReturn("exec Gy_RoutingBill_EditPrice '" + HMaterNumber + "'", "Gy_RoutingBill_EditPrice"); |
| | | |
| | | //æ·»å åå |
| | | 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.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus) |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus |
| | | ,HOWNERID,HOWNERTYPEID) |
| | | values('3710'," + mainList[0].HInterID + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'," + mainList[0].HPRDORGID + |
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "',getdate()" + |
| | | ",'" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HEmpID + "," + mainList[0].HCusID + |
| | | "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2) "); |
| | | "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + |
| | | ","+ mainList[0].HOWNERID + ",'"+ mainList[0].HOWNERTYPEID + "') "); |
| | | //ä¿å主表 |
| | | foreach (var oSub in subList) |
| | | { |
| | |
| | | ,HBeginDate,HEndDate |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney |
| | | ,HCOSTRATE,HISBACKFLUSH,HBatchNo,HBomID,HCHECKPRODUCT,HSEQ) |
| | | ,HCOSTRATE,HISBACKFLUSH,HBatchNo,HBomID,HCHECKPRODUCT,HSEQ,HSTOCKINORGID) |
| | | values({oSub.HInterID},{oSub.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.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},4 |
| | | ,0,0,'','',0,0 |
| | | ,{oSub.HCOSTRATE},{oSub.HISBACKFLUSH},'{oSub.HBatchNo}',{oSub.HBomID},{oSub.HCHECKPRODUCT},{oSub.HSEQ})"); |
| | | ,{oSub.HCOSTRATE},{oSub.HISBACKFLUSH},'{oSub.HBatchNo}',{oSub.HBomID},{oSub.HCHECKPRODUCT},{oSub.HSEQ},{oSub.HSTOCKINORGID})"); |
| | | } |
| | | |
| | | foreach (var _item in _mainList) |
| | |
| | | long HBomID = mainList[0].HBomID;//bom |
| | | //double? HPlanQty = mainList[0].HPlanQty == null ? 0 : mainList[0].HPlanQty;//è®¡åæ°é |
| | | string HMaker = user;//å¶å人 |
| | | string HIsStockQty = mainList[0].HIsStockQty; |
| | | string HRemark3 = mainList[0].HRemark3; |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_ICMOBillList"); |
| | | |
| | |
| | | (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID |
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate) |
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate |
| | | ,HIsStockQty,HRemark3) |
| | | 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 + ",'','') "); |
| | | "," + HCenterID + ",0,0,0,0," + HBomID + ",'',''" + |
| | | ",'"+ HIsStockQty + "','"+ HRemark3 + "') "); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { |
| | |
| | | //ä¿®æ¹ |
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + |
| | | ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + " where HInterID=" + HInterID); |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + |
| | | ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + ",HIsStockQty='"+ HIsStockQty + "',HRemark3='" + HRemark3 + "' where HInterID=" + HInterID); |
| | | |
| | | //å é¤å表 |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'"); |
| | |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn)) |
| | | { |
| | | if (oSystemParameter.omodel.Sc_ICMOBill_DeleterAndMakerMustSame == "Y") |
| | | { |
| | | if (ds.Tables[0].Rows[0]["HMaker"].ToString() != user && (user != "admin" && user != "Admin")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åªè½å 餿¬äººçåæ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | if (int.Parse(ds.Tables[0].Rows[0]["HBillStatus"].ToString()) > 1) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡å å¤è¡æ¹é䏿¨ |
| | | [Route("Sc_ICMOBill/Sc_ICMOReportBill_dh")] |
| | | [HttpGet] |
| | | public object Sc_ICMOReportBill_dh(string HInterID, string user, int OrganizationID) |
| | | { |
| | | try |
| | | { |
| | | //è·ååæ®ID |
| | | string[] HBillNo = HInterID.Split(','); |
| | | string Error = ""; |
| | | int i = 0; |
| | | foreach (var item in HBillNo) |
| | | { |
| | | string err = ""; |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | Model.ClsSc_ProcessExchangeBillMain lsmain = new Model.ClsSc_ProcessExchangeBillMain(); |
| | | List<Model.ClsSc_ProcessExchangeBillSub> ls = new List<Model.ClsSc_ProcessExchangeBillSub>(); |
| | | string HBillNOs = ""; |
| | | string hmainid = item.Split('|')[0]; |
| | | string HEntryID = item.Split('|')[1]; |
| | | |
| | | 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"); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | err = "æ æ°æ®! \n"; |
| | | } |
| | | else |
| | | { |
| | | string HNumber = ds.Tables[0].Rows[0]["产å代ç "].ToString(); |
| | | HBillNOs = ds.Tables[0].Rows[0]["åæ®å·"].ToString(); |
| | | |
| | | if (ds.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() == "") |
| | | { |
| | | err = "æéç产订å为æªå®¡æ ¸ç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["å
³é人"].ToString() != "") |
| | | { |
| | | err = "æéç产订å为已å
³éç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; |
| | | } |
| | | |
| | | if (ds.Tables[0].Rows[0]["ä½åºäºº"].ToString() != "") |
| | | { |
| | | err = "æéç产订å为已ä½åºç¶æï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; |
| | | } |
| | | |
| | | 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) |
| | | { |
| | | err = "æéç产订åå·²å
¨é¨ä¸æ¨çæå·¥åºæµè½¬å¡ï¼å©ä½å¯ä¸æ¨æ°é为0ï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; |
| | | } |
| | | lsmain.HMaker = user; //å¶å人 |
| | | lsmain.HBillType = "3772"; |
| | | lsmain.HBillSubType = "3772"; |
| | | lsmain.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | lsmain.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | lsmain.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | lsmain.HICMOInterID = long.Parse(ds.Tables[0].Rows[0]["hmainid"].ToString()); |
| | | lsmain.HICMOBillNo = ds.Tables[0].Rows[0]["ç产订åå·"].ToString(); |
| | | lsmain.HICMOEntryID = long.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()); |
| | | lsmain.HOrderProcNO = ds.Tables[0].Rows[0]["订åè·è¸ªå·"].ToString(); |
| | | lsmain.HMaterID = long.Parse(ds.Tables[0].Rows[0]["hmaterid"].ToString()); |
| | | lsmain.HMaterID2 = long.Parse(ds.Tables[0].Rows[0]["hmaterid"].ToString()); |
| | | lsmain.HMaterNumber = ds.Tables[0].Rows[0]["ç©æä»£ç "].ToString(); |
| | | lsmain.HMaterModel = ds.Tables[0].Rows[0]["è§æ ¼åå·"].ToString(); |
| | | lsmain.HBatchNo = ds.Tables[0].Rows[0]["æ¹å·"].ToString(); |
| | | lsmain.HSplitNo =1;//齿¯1 |
| | | lsmain.HUnitID = long.Parse(ds.Tables[0].Rows[0]["hunitid"].ToString()); |
| | | lsmain.HUnitNumber = ds.Tables[0].Rows[0]["计éåä½ä»£ç "].ToString(); |
| | | lsmain.HPlanQty = double.Parse(ds.Tables[0].Rows[0]["计åç产æ°é"].ToString()); |
| | | lsmain.HQty = double.Parse(ds.Tables[0].Rows[0]["æµè½¬å¡æ°é"].ToString()); |
| | | lsmain.HPlanBeginDate = DateTime.Parse(ds.Tables[0].Rows[0]["计åå¼å·¥æ¥æ"].ToString()); |
| | | lsmain.HPlanEndDate = DateTime.Parse(ds.Tables[0].Rows[0]["计åå®å·¥æ¥æ"].ToString()); |
| | | lsmain.HWorkShopID = long.Parse(ds.Tables[0].Rows[0]["hdeptid"].ToString()); |
| | | lsmain.HProdMaterCode = ds.Tables[0].Rows[0]["产åCODE"].ToString(); |
| | | lsmain.HSeOrderBillNo = ds.Tables[0].Rows[0]["éå®è®¢åå·"].ToString(); |
| | | lsmain.HCusShortName = ds.Tables[0].Rows[0]["客æ·ç®ç§°"].ToString(); |
| | | lsmain.HCusNeedMaterial = ds.Tables[0].Rows[0]["客æ·è¦æ±æææå"].ToString(); |
| | | lsmain.HPlanSendGoodsDate = ds.Tables[0].Rows[0]["é¢è®¡åºè´§æ¥æ"].ToString()==""?DateTime.Now.ToString(): ds.Tables[0].Rows[0]["é¢è®¡åºè´§æ¥æ"].ToString(); |
| | | lsmain.HSellDate = DateTime.Now.ToString(); |
| | | lsmain.HPRDORGID = OrganizationID; |
| | | lsmain.HProdMaterName = ds.Tables[0].Rows[0]["产ååç§°"].ToString(); |
| | | lsmain.HCusName = ds.Tables[0].Rows[0]["客æ·åç§°"].ToString(); |
| | | lsmain.HWorkRemark = ds.Tables[0].Rows[0]["çäº§å¤æ³¨"].ToString(); |
| | | lsmain.HImportNote = ds.Tables[0].Rows[0]["éè¦æç¤º"].ToString(); |
| | | lsmain.HPicNumVer = ds.Tables[0].Rows[0]["å¾å·çæ¬"].ToString(); |
| | | lsmain.HPicNumAssemble = ds.Tables[0].Rows[0]["æ»è£
å¾å·"].ToString(); |
| | | lsmain.HMaterTexture = ds.Tables[0].Rows[0]["æè´¨"].ToString(); |
| | | lsmain.HProductNum = ds.Tables[0].Rows[0]["æåç¼å·"].ToString(); |
| | | lsmain.HVerNum = ds.Tables[0].Rows[0]["çæ¬"].ToString(); |
| | | //lsmain.HCusNumber = ds.Tables[0].Rows[0]["æºå客æ·ç¼ç "].ToString(); |
| | | //lsmain.HPickLabel = ds.Tables[0].Rows[0]["å
è£
æ è¯"].ToString(); |
| | | //lsmain.HPickLabelNumber = ds.Tables[0].Rows[0]["å
è£
æ è¯ç¼ç "].ToString(); |
| | | //lsmain.HXTNumber = ds.Tables[0].Rows[0]["è¯ä½ç©æä»£ç "].ToString(); |
| | | //lsmain.HXTModel = ds.Tables[0].Rows[0]["è¯ä½è§æ ¼åå·"].ToString(); |
| | | lsmain.HWidth = double.Parse(ds.Tables[0].Rows[0]["HWidth"].ToString()); |
| | | lsmain.HWeight = double.Parse(ds.Tables[0].Rows[0]["HWeight"].ToString()); |
| | | lsmain.HAuxUnit = int.Parse(ds.Tables[0].Rows[0]["HAuxUnit"].ToString()); |
| | | lsmain.HRemark2 = ds.Tables[0].Rows[0]["夿³¨"].ToString(); |
| | | lsmain.HEmpID = long.Parse(ds.Tables[0].Rows[0]["HEmpID"].ToString()); |
| | | lsmain.HCusID = long.Parse(ds.Tables[0].Rows[0]["HCusID"].ToString()); |
| | | lsmain.HColorRemark = ds.Tables[0].Rows[0]["æè²è¦æ±"].ToString(); |
| | | lsmain.HBLFlag = ds.Tables[0].Rows[0]["HBLFlag"].ToString() == "0" ? false : true; |
| | | lsmain.HAuxQty = 0; |
| | | lsmain.HAuxUnit = 0; |
| | | |
| | | |
| | | ds = oCN.RunProcReturn("select top 1000 * from h_v_Gy_RoutingBillList a left join Gy_Process p on a.hprocid = p.HItemID where ç©æä»£ç ='" + HNumber + "' and é»è®¤å·¥èº=1", "h_v_Gy_RoutingBillList"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | err = "æéç产订å对åºç©ææªè®¾ç½®å¯¹åºçå·¥èºè·¯çº¿ï¼ä¸å
è®¸ä¸æ¨çæå·¥åºæµè½¬å¡ï¼\n"; |
| | | } |
| | | else |
| | | { |
| | | lsmain.HRoutingBillID = ds.Tables[0].Rows[0]["hmainid"].ToString(); |
| | | oBill.omodel = lsmain; |
| | | |
| | | int j = 0; |
| | | foreach (DataRow row in ds.Tables[0].Rows) |
| | | { |
| | | if (row["HTProcessFlag"].ToString() == "False") |
| | | { |
| | | ClsSc_ProcessExchangeBillSub sub = new ClsSc_ProcessExchangeBillSub(); |
| | | sub.HEntryID = j + 1; |
| | | sub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | sub.HProcNo = long.Parse(row["å·¥åºå·"].ToString()); |
| | | sub.HProcID = long.Parse(row["HProcID"].ToString()); |
| | | sub.HProcNumber = row["å·¥åºä»£ç "].ToString(); |
| | | sub.HWorkRemark = row["表ä½å¤æ³¨"].ToString(); |
| | | sub.HCenterID = long.Parse(row["HCenterID"].ToString()); |
| | | sub.HSupID = long.Parse(row["HSupID"].ToString()); |
| | | sub.HSupFlag = row["å§å¤æ è®°"].ToString() == "False" ? false : true; |
| | | sub.HQty = lsmain.HQty; |
| | | sub.HTechnologyParameter = row["å·¥èºåæ°"].ToString(); |
| | | sub.HPicNum = row["å¾çº¸ç¼å·"].ToString(); |
| | | sub.HProcCheckNote = row["æ¬å·¥åºç¡®è®¤è®°å½"].ToString(); |
| | | sub.HDeptID = 0; |
| | | sub.HDeptNumber = ""; |
| | | sub.HOutPrice = 0; |
| | | sub.HRemark = ""; |
| | | sub.HRelationQty_In =0; |
| | | sub.HRelationQty_Out = 0; |
| | | sub.HRelationQty_WWOrder = 0; |
| | | sub.HRelationQty_Bad = 0; |
| | | sub.HOverRate = 0; |
| | | sub.HMaxQty = 0; |
| | | sub.HPassRate = 0; |
| | | sub.HSumPassRate = 0; |
| | | j++; |
| | | oBill.DetailColl.Add(sub); |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | bool bResult = false; |
| | | if (err != "") |
| | | { |
| | | Error += "ç产订ååæ®å·:" + HBillNOs + "\n" + err; |
| | | } |
| | | else |
| | | { |
| | | oBill.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode("3772", ref DBUtility.ClsPub.sExeReturnInfo,true); |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oBill.DetailColl.Clear(); |
| | | |
| | | if (!bResult) |
| | | { |
| | | Error += "ä¿å失败,ç产订ååæ®å·:" + HBillNOs + "\n" + err; |
| | | } |
| | | else |
| | | { |
| | | i++; |
| | | } |
| | | } |
| | | } |
| | | Error = "æå:" + i + "è¡ !!! " + Error; |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = Error; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "䏿¨å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åè·åè½¦é´ |
| | | [Route("Sc_ICMOBill/GetHDeptList")] |
| | | [HttpGet] |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åè·åå·¥ä½ä¸å¿ |
| | | [Route("Sc_ICMOBill/GetHWorkCenterList")] |
| | | [HttpGet] |
| | | public object GetHWorkCenterList() |
| | | { |
| | | try |
| | | { |
| | | DataSet oDs = new DataSet(); |
| | | //========== |
| | | oDs = oCN.RunProcReturn("select HItemID,HName from Gy_WorkCenter", "Gy_WorkCenter"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åæåï¼"; |
| | | objJsonResult.data = oDs.Tables[0]; |
| | | return objJsonResult; ; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region å¢åè£
ç®±åå车äºä»¶ |
| | | [Route("Sc_ICMOBill/QK_PackingBillByXSBill")] |
| | | [HttpGet] |
| | |
| | | public string eventType { get; set; } |
| | | public long HMainInterID { get; set; } |
| | | public long HPRDOrgID { get; set; } |
| | | public double HmaterOutqty { get; set; } |
| | | } |
| | | } |
| | |
| | | <LastUsedBuildConfiguration>Debug</LastUsedBuildConfiguration> |
| | | <LastUsedPlatform>x86</LastUsedPlatform> |
| | | <PublishProvider>FileSystem</PublishProvider> |
| | | <PublishUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</PublishUrl> |
| | | <PublishUrl>E:\ç½ç«åå¸\API</PublishUrl> |
| | | <WebPublishMethod>FileSystem</WebPublishMethod> |
| | | <SiteUrlToLaunchAfterPublish /> |
| | | </PropertyGroup> |
| | |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.pdb"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>11/09/2022 16:02:08</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:20</publishTime> |
| | | </File> |
| | | <File Include="bin/BouncyCastle.Crypto.dll"> |
| | | <publishTime>12/18/2020 05:32:28</publishTime> |
| | | <publishTime>12/17/2020 21:32:28</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>11/09/2022 16:02:06</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:19</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>11/02/2022 22:02:56</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:16</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.Api.dll"> |
| | | <publishTime>03/22/2022 13:17:26</publishTime> |
| | | <publishTime>03/22/2022 05:17:26</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.Api.pdb"> |
| | | <publishTime>03/19/2022 07:39:42</publishTime> |
| | | <publishTime>03/18/2022 23:39:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.dll"> |
| | | <publishTime>03/22/2022 13:17:20</publishTime> |
| | | <publishTime>03/22/2022 05:17:20</publishTime> |
| | | </File> |
| | | <File Include="bin/Grpc.Core.pdb"> |
| | | <publishTime>03/19/2022 07:39:48</publishTime> |
| | | <publishTime>03/18/2022 23:39:48</publishTime> |
| | | </File> |
| | | <File Include="bin/grpc_csharp_ext.x64.dll"> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | </File> |
| | | <File Include="bin/grpc_csharp_ext.x86.dll"> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | </File> |
| | | <File Include="bin/ICSharpCode.SharpZipLib.dll"> |
| | | <publishTime>05/09/2021 01:08:30</publishTime> |
| | | <publishTime>05/08/2021 17:08:30</publishTime> |
| | | </File> |
| | | <File Include="bin/ICSharpCode.SharpZipLib.pdb"> |
| | | <publishTime>05/09/2021 01:08:30</publishTime> |
| | | <publishTime>05/08/2021 17:08:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Interop.gregn6Lib.dll"> |
| | | <publishTime>08/25/2021 10:28:25</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>02/09/2023 20:21:24</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>09/20/2018 19:28:34</publishTime> |
| | | </File> |
| | | <File Include="bin/libgrpc_csharp_ext.x64.dylib"> |
| | | <publishTime>03/19/2022 07:38:44</publishTime> |
| | | <publishTime>03/18/2022 23:38:44</publishTime> |
| | | </File> |
| | | <File Include="bin/libgrpc_csharp_ext.x64.so"> |
| | | <publishTime>03/19/2022 07:38:42</publishTime> |
| | | <publishTime>03/18/2022 23:38:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> |
| | | <publishTime>03/19/2015 01:02:50</publishTime> |
| | | <publishTime>03/18/2015 17:02:50</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.CSharp.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Web.Infrastructure.dll"> |
| | | <publishTime>07/25/2012 19:48:56</publishTime> |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>11/09/2022 16:02:01</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:16</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/04/2014 04:33:56</publishTime> |
| | | <publishTime>08/03/2014 20:33:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.dll"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OOXML.dll"> |
| | | <publishTime>10/23/2021 09:07:56</publishTime> |
| | | <publishTime>10/23/2021 01:07:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OOXML.pdb"> |
| | | <publishTime>10/23/2021 17:07:56</publishTime> |
| | | <publishTime>10/23/2021 09:07:56</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXml4Net.dll"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXml4Net.pdb"> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXmlFormats.dll"> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXmlFormats.dll"> |
| | | <publishTime>10/23/2021 01:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.OpenXmlFormats.pdb"> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/NPOI.pdb"> |
| | | <publishTime>10/23/2021 17:07:54</publishTime> |
| | | <publishTime>10/23/2021 09:07:54</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>11/09/2022 16:01:56</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:15</publishTime> |
| | | </File> |
| | | <File Include="bin/RestSharp.dll"> |
| | | <publishTime>08/31/2012 06:22:50</publishTime> |
| | | <publishTime>08/30/2012 22:22:50</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>05/18/2023 22:34:15</publishTime> |
| | |
| | | <publishTime>05/09/2021 13:35:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | <publishTime>02/15/2015 17:57:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Buffers.dll"> |
| | | <publishTime>07/19/2017 18:01:28</publishTime> |
| | | <publishTime>07/19/2017 10:01:28</publishTime> |
| | | </File> |
| | | <File Include="bin/System.ComponentModel.DataAnnotations.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> |
| | | <publishTime>08/19/2014 18:03:34</publishTime> |
| | | <publishTime>08/19/2014 10:03:34</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Memory.dll"> |
| | | <publishTime>04/18/2019 00:24:34</publishTime> |
| | | <publishTime>04/17/2019 16:24:34</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.Formatting.dll"> |
| | | <publishTime>11/28/2018 21:00:36</publishTime> |
| | | <publishTime>11/28/2018 13:00:36</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Runtime.CompilerServices.Unsafe.dll"> |
| | | <publishTime>09/19/2018 03:38:10</publishTime> |
| | | <publishTime>09/18/2018 19:38:10</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Runtime.Serialization.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Cors.dll"> |
| | | <publishTime>11/28/2018 20:58:44</publishTime> |
| | | <publishTime>11/28/2018 12:58:44</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Helpers.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.Cors.dll"> |
| | | <publishTime>11/28/2018 21:01:26</publishTime> |
| | | <publishTime>11/28/2018 13:01:26</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.dll"> |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Optimization.dll"> |
| | | <publishTime>02/11/2014 23:26:04</publishTime> |
| | | <publishTime>02/11/2014 15:26:04</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Razor.dll"> |
| | | <publishTime>01/28/2015 12:02:32</publishTime> |
| | | <publishTime>01/28/2015 04:02:32</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Services.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Deployment.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Razor.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Xml.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>11/14/2022 11:23:59</publishTime> |
| | |
| | | <publishTime>05/18/2023 22:34:24</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |
| | | <publishTime>07/17/2013 17:03:52</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:02</publishTime> |
| | | <publishTime>11/29/2018 13:26:02</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | <publishTime>11/29/2018 13:26:30</publishTime> |
| | | </File> |
| | | <File Include="Config/kdapi.config"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>08/19/2022 08:17:39</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>04/06/2023 15:57:01</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>11/01/2021 09:26:33</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>02/09/2023 20:21:24</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="grpc_csharp_ext.x64.dll"> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | </File> |
| | | <File Include="grpc_csharp_ext.x86.dll"> |
| | | <publishTime>03/22/2022 13:17:22</publishTime> |
| | | <publishTime>03/22/2022 05:17:22</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="libgrpc_csharp_ext.x64.dylib"> |
| | | <publishTime>03/19/2022 07:38:44</publishTime> |
| | | <publishTime>03/18/2022 23:38:44</publishTime> |
| | | </File> |
| | | <File Include="libgrpc_csharp_ext.x64.so"> |
| | | <publishTime>03/19/2022 07:38:42</publishTime> |
| | | <publishTime>03/18/2022 23:38:42</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>11/29/2022 10:36:46</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | | <publishTime>08/19/2021 09:44:01</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | |
| | | <!--<add key="sUrl" value="http://10.10.130.181/WEBS-WMS/WebService1.asmx"/> åæ¥ç§æ--> |
| | | <!--<add key="sUrl" value="http://192.168.0.214/WEBS-WMS/WebService1.asmx"/> çä¸ç¥º--> |
| | | <!--<add key="sUrl" value="http://60.191.27.141:8090/WEBS-WMS/WebService1.asmx"/> 森楷--> |
| | | <add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/> |
| | | <!--<add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/> --> |
| | | <!--<add key="sUrl" value="http://192.168.80.90:9090/WEBS/WebService1.asmx"/> å®çæå¡å¨--> |
| | | <!--<add key="sUrl" value="http://122.227.133.186:8090/WEBS/WebService1.asmx"/> --> |
| | | <!--<add key="sUrl" value="http://192.168.80.90:9090/WEBS-WMS/WebService1.asmx"/> å®çæå¡å¨--> |
| | |
| | | </basicHttpBinding> |
| | | </bindings> |
| | | <client> |
| | | <endpoint address="http://47.96.97.237/WEBS-WMS/WebService1.asmx" binding="basicHttpBinding" |
| | | <endpoint address="http://192.168.63.3/WEBS-WMS/WebService1.asmx" binding="basicHttpBinding" |
| | | bindingConfiguration="WebService1Soap" contract="Webs1.WebService1Soap" |
| | | name="WebService1Soap" /> |
| | | </client> |
| | |
| | | |
| | | <applicationSettings> |
| | | <WebAPI.Properties.Settings> |
| | | <setting name="WebAPI_WebS2_WebService1" serializeAs="String"> |
| | | <value>http://47.96.97.237/WEBS-WMS/WebService1.asmx</value> |
| | | </setting> |
| | | <setting name="WebAPI_WebS_WebService1" serializeAs="String"> |
| | | <value>http://47.96.97.237/WEBS-WMS/WebService1.asmx</value> |
| | | <value>http://192.168.63.3/WEBS-WMS/WebService1.asmx</value> |
| | | </setting> |
| | | </WebAPI.Properties.Settings> |
| | | </applicationSettings> |
| | |
| | | <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> |
| | | <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\GITä»åº\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>false</UseIISExpress> |
| | | <Use64BitIISExpress /> |