工序流转卡 保存工艺路线内码
生产订单完善
工艺路线添加字段 仓库
| | |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | } |
| | | //æ ¹æ®ä»£ç è¿å项ç®ä¿¡æ¯ |
| | | public override bool GetInfoByName(string sNumber) |
| | | { |
| | | DataSet DS; |
| | | try |
| | | { |
| | | DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HName='" + sNumber + "'", MvarItemKey, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count == 0) |
| | | return false; |
| | | else |
| | | { |
| | | return GetInfo(DS); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | //è¿å项ç®ä¿¡æ¯ |
| | | public override bool GetInfo(DataSet Ds) |
| | | { |
| | |
| | | ",HProdMaterCode,HSeOrderBillNo,HCusShortName,HCusNeedMaterial,HPlanSendGoodsDate" + |
| | | ",HProdMaterName,HCusName,HWorkRemark,HImportNote,HMaterNumber_A" + |
| | | ",HMaterNumber_B,HMaterNumber_C,HMaterNumber_D,HProdType,HMaterShortName" + |
| | | ",HMaterIDA,HMaterIDB,HMaterIDC,HMaterIDD,HICMOEntryID" + |
| | | ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HPRDORGID,HBLFlag,HCusNumber,HPickLabel,HPickLabelNumber,HXTNumber,HXTModel,HWorkBillSortNo" + |
| | | ") " + |
| | | ",HMaterIDA,HMaterIDB,HMaterIDC,HMaterIDD,HICMOEntryID" + ",HPicNumVer,HPicNumAssemble,HMaterTexture,HProductNum,HVerNum,HPRDORGID,HBLFlag,HCusNumber,HPickLabel,HPickLabelNumber,HXTNumber,HXTModel,HWorkBillSortNo" + |
| | | ", HRoutingBillID) " + |
| | | " 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.HMaterNumber_B + "','" + omodel.HMaterNumber_C + "','" + omodel.HMaterNumber_D + "','" + omodel.HProdType + "','" + omodel.HMaterShortName + "'" + |
| | | ",'" + omodel.HMaterIDA + "','" + omodel.HMaterIDB + "','" + omodel.HMaterIDC + "','" + omodel.HMaterIDD + "'," + omodel.HICMOEntryID + |
| | | ",'" + omodel.HPicNumVer + "','" + omodel.HPicNumAssemble + "','" + omodel.HMaterTexture + "','" + omodel.HProductNum + "','" + omodel.HVerNum + "','"+ omodel.HPRDORGID+ "','"+omodel.HBLFlag+ "','" + omodel.HCusNumber + "','" + omodel.HPickLabel + "','" + omodel.HPickLabelNumber + "','" + omodel.HXTNumber + "','" + omodel.HXTModel + "','" + omodel.HWorkBillSortNo + |
| | | "') "); |
| | | "',"+ omodel.HRoutingBillID + ") "); |
| | | sErr = sErr + "1;"; |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oSub in DetailColl) |
| | |
| | | public string HPickLabelNumber; |
| | | public string HXTNumber; |
| | | public string HXTModel; |
| | | public string HRoutingBillID;//å·¥èºè·¯çº¿ID |
| | | } |
| | | } |
| | |
| | | omodel.MES_StationOutBill_InStockType = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //===========å·¥èºè·¯çº¿ |
| | | //ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_SaveAutoLastProc") |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //=======JIT |
| | | |
| | |
| | | omodel.MES_StationEntrustOutBill_SaveAutoAddnew = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //=========å·¥èºè·¯çº¿ |
| | | //èªå¨æ°å¢ ä¿åå°æ°æ®åºæ¶èªå¨å ä¸è½¬å·¥åº |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Gy_RoutingBill_SaveAutoLastProc") |
| | | { |
| | | omodel.Gy_RoutingBill_SaveAutoLastProc = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]); |
| | | } |
| | | |
| | | //æ¥å·¥å°ï¼å·¥åºæ±æ¥èªå¨å®¡æ ¸åæ° |
| | | if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_MESProceReportWorkBill_AutoCheck") |
| | | { |
| | |
| | | DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View(); |
| | | public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View(); |
| | | DAL.ClsGy_WorkCenter_View oCenHlp = new DAL.ClsGy_WorkCenter_View(); |
| | | DAL.ClsGy_Warehouse_View oCenWare = new DAL.ClsGy_Warehouse_View(); |
| | | Gy_RoutingBill_temporary omdelMian = new Gy_RoutingBill_temporary(); |
| | | public string BillType = "3301"; |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | #region æªç¥ |
| | | /// <summary> |
| | |
| | | double HStdSourceQty = mainList[0].HStdSourceQty;//æ åèµæºæ° |
| | | double HAddSourceRate = mainList[0].HAddSourceRate;//å èµæºå¢é |
| | | double HDelSourceRate = mainList[0].HDelSourceRate;//åèµæºåé |
| | | int HPRDORGID = mainList[0].HOrgID; //ç产ç»ç» |
| | | int HPRDORGID = mainList[0].HPRDORGID; //ç产ç»ç» |
| | | int HOrgID = mainList[0].HOrgID; //ç»ç» |
| | | string HPicNumVer = mainList[0].HPicNumVer;//å¾å·çæ¬ |
| | | string HPicNumAssemble = mainList[0].HPicNumAssemble;//æ»è£
å¾å· |
| | |
| | | string HProductNum = mainList[0].HProductNum;//æåç¼å· |
| | | string HVerNum = mainList[0].HVerNum;//çæ¬ |
| | | int IsProNo = mainList[0].IsProNo;//æ¯å¦è½¬å·¥åº |
| | | |
| | | |
| | | if (OperationType == 2) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_RoutingBillList where åæ®å·='" + HBillNo + "'", "h_v_Gy_RoutingBillList"); |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //string sErrMsg = ""; |
| | | //if (oSystemParameter.ShowBill(ref sErrMsg)) |
| | | //{ |
| | | // if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | // { |
| | | // if (oSystemParameter.omodel.Gy_RoutingBill_SaveAutoLastProc == "Y" && OperationType == 1) |
| | | // { |
| | | // //è®¾ç½®è½¬å·¥åº |
| | | // oCN.RunProc("exec Gy_RoutingBill_LastProNo " + HInterID); |
| | | // } |
| | | // } |
| | | //} |
| | | |
| | | if (IsProNo == 1 && OperationType == 1) |
| | | { |
| | |
| | | ",HProcID_S,HCenterID_S,HWorkQty_S,HSubStdEmpQty_S,HMouldNo,HChangeMould" + |
| | | ",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" + |
| | | ",HTechnologyParameter,HPicNum,HProcCheckNote" + |
| | | ",HOverRate,HProcWorkNum" + |
| | | ",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.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.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString()+"," + oSub.HWasterWHID.ToString()+"," + oSub.HWHID.ToString() + |
| | | ") "); |
| | | } |
| | | } |
| | |
| | | if (!tb2.Columns.Contains("è¯ç")) |
| | | error += "æ²¡ææ¾å°ãè¯çãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("ä¸è¯åä»")) |
| | | error += "æ²¡ææ¾å°ãä¸è¯åä»ãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("æ¥åºåä»")) |
| | | error += "æ²¡ææ¾å°ãæ¥åºåä»ãçæ é¢"; |
| | | |
| | | if (!tb2.Columns.Contains("è¯åä»")) |
| | | error += "æ²¡ææ¾å°ãè¯åä»ãçæ é¢"; |
| | | |
| | | if (error.Length > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | , è¯ç, å·¥åºå·¥ä»·, ä¸åæ ¼åä»·, æ¥åºåä»·, æ¬éåºå®å¼å·¥å¤©æ°, æ¬éå¼å·¥ä½é, ä¸éçå¾
å¤©æ° |
| | | , ä¸é循ç¯å¨æ, èªå¨è½¬ç§», å¤åæ è®°, ä¾åºå代ç , ä¾åºå, å·¥èºåæ°, å¾çº¸ç¼å· |
| | | , æ¬å·¥åºç¡®è®¤è®°å½, 夿³¨, å¾å·çæ¬, æ»è£
å¾å·, æè´¨, æåç¼å·, çæ¬ |
| | | , 模å
·ç¼å·, ç¨åºå·, ç产å®é¢, å·¥èºè·¯çº¿åç§°, æ¶é´åä½,å·¥èºè·¯çº¿ä»£ç )values |
| | | , 模å
·ç¼å·, ç¨åºå·, ç产å®é¢, å·¥èºè·¯çº¿åç§°, æ¶é´åä½,å·¥èºè·¯çº¿ä»£ç ,ä¸è¯åä»,æ¥åºåä»,è¯åä»)values |
| | | ('" + tb2.Rows[i]["产å代ç "].ToString() + "','" + tb2.Rows[i]["产ååç§°"].ToString() + "','" + tb2.Rows[i]["å·¥åºåºå·"].ToString() + "','" + tb2.Rows[i]["å·¥åºä»£ç "].ToString() + "','" + tb2.Rows[i]["å·¥åº"].ToString() + "','" + tb2.Rows[i]["å·¥ä½ä¸å¿"].ToString() + "','" + tb2.Rows[i]["å å·¥æ°é"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["è¯ç"].ToString() + "','" + (tb2.Rows[i]["å·¥åºå·¥ä»·"].ToString() == "" ? "0" : tb2.Rows[i]["å·¥åºå·¥ä»·"].ToString()) + "','" + tb2.Rows[i]["ä¸åæ ¼åä»·"].ToString() + "','" + tb2.Rows[i]["æ¥åºåä»·"].ToString() + "','" + tb2.Rows[i]["æ¬éåºå®å¼å·¥å¤©æ°"].ToString() + "','" + tb2.Rows[i]["æ¬éå¼å·¥ä½é"].ToString() + "','" + tb2.Rows[i]["ä¸éçå¾
天æ°"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["ä¸é循ç¯å¨æ"].ToString() + "','" + tb2.Rows[i]["èªå¨è½¬ç§»"].ToString() + "','" + tb2.Rows[i]["å¤åæ è®°"].ToString() + "','" + tb2.Rows[i]["ä¾åºå代ç "].ToString() + "','" + tb2.Rows[i]["ä¾åºå"].ToString() + "','" + tb2.Rows[i]["å·¥èºåæ°"].ToString() + "','" + tb2.Rows[i]["å¾çº¸ç¼å·"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["æ¬å·¥åºç¡®è®¤è®°å½"].ToString() + "','" + tb2.Rows[i]["夿³¨"].ToString() + "','" + tb2.Rows[i]["å¾å·çæ¬"].ToString() + "','" + tb2.Rows[i]["æ»è£
å¾å·"].ToString() + "','" + tb2.Rows[i]["æè´¨"].ToString() + "','" + tb2.Rows[i]["æåç¼å·"].ToString() + "','" + tb2.Rows[i]["çæ¬"].ToString() + "'" + |
| | | ",'" + tb2.Rows[i]["模å
·ç¼å·"].ToString() + "','" + tb2.Rows[i]["ç¨åºå·"].ToString() + "','" + tb2.Rows[i]["ç产å®é¢"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿åç§°"].ToString() + "','" + tb2.Rows[i]["æ¶é´åä½"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿ä»£ç "].ToString() + "')"); |
| | | ",'" + tb2.Rows[i]["模å
·ç¼å·"].ToString() + "','" + tb2.Rows[i]["ç¨åºå·"].ToString() + "','" + tb2.Rows[i]["ç产å®é¢"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿åç§°"].ToString() + "','" + tb2.Rows[i]["æ¶é´åä½"].ToString() + "','" + tb2.Rows[i]["å·¥èºè·¯çº¿ä»£ç "].ToString() + "','" + tb2.Rows[i]["ä¸è¯åä»"].ToString() + "','" + tb2.Rows[i]["æ¥åºåä»"].ToString() + "','" + tb2.Rows[i]["è¯åä»"].ToString() + "')"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | Single sWorkQty = 0; |
| | | Single sHPassRate = 0; |
| | | |
| | | // |
| | | sHNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["产å代ç "].ToString()); |
| | | sHNumberCen = DBUtility.ClsPub.isStrNull(dt.Rows[i]["å·¥ä½ä¸å¿"].ToString()); |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(dt.Rows[i]["å·¥åº"].ToString()); |
| | | sWorkQty = DBUtility.ClsPub.isSingle(dt.Rows[i]["å å·¥æ°é"].ToString()); |
| | | sHPassRate = DBUtility.ClsPub.isSingle(dt.Rows[i]["è¯ç"].ToString()); |
| | | |
| | | if (sHNumber != "") |
| | | { |
| | | // |
| | |
| | | sErrMsg = sErrMsg + "[" + sHNumberCen + "]å·¥ä½ä¸å¿ä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | |
| | | } |
| | | |
| | | |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | string HBadWHName = ""; //ä¸è¯åä» |
| | | string HWasterWHName = ""; //æ¥åºåä» |
| | | string HWHName = ""; //è¯åä» |
| | | |
| | | HBadWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["ä¸è¯åä»"].ToString()); |
| | | HWasterWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["æ¥åºåä»"].ToString()); |
| | | HWHName = DBUtility.ClsPub.isStrNull(dt.Rows[i]["è¯åä»"].ToString()); |
| | | |
| | | //夿æ¯å¦ä¸ºç©º |
| | | if (HBadWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :ä¸è¯åä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWasterWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :æ¥åºåä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWHName == "") |
| | | { |
| | | sErrMsg = sErrMsg + "第" + index + "è¡ :è¯åä»ä¸è½ä¸ºç©º !\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | //夿ä»åºæ¯å¦éå¤ |
| | | if (HBadWHName == HWasterWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "ä¸è¯åä»åæ¥åºåä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HWasterWHName == HWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "æ¥åºåä»åè¯åä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | if (HBadWHName == HWHName) |
| | | { |
| | | sErrMsg = sErrMsg + "ä¸è¯åä»åè¯åä»éå¤\r\n"; |
| | | b = true; |
| | | } |
| | | |
| | | //å¾å°ä»åºå
ç |
| | | if (!oCenWare.GetInfoByName(HBadWHName)) |
| | | { |
| | | sMsg = "[" + HBadWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HBadWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | |
| | | if (!oCenWare.GetInfoByName(HWasterWHName)) |
| | | { |
| | | sMsg = "[" + HWasterWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HWasterWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | |
| | | if (!oCenWare.GetInfoByName(HWHName)) |
| | | { |
| | | sMsg = "[" + HWHName + "]ä»åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + HWHName + "]ä»åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (b == true) |
| | |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | |
| | | FentityModel.Add("FBaseRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");// |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥èºè·¯çº¿") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumbers"].ToString() }); // ä»åº |
| | | } |
| | | else if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥åº") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | } |
| | | } |
| | | } |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["HBatchNo"].ToString() }); //æ¹å· |
| | | FentityModel.Add("FISBACKFLUSH", "true");// |
| | | FentityModel.Add("FWorkShopId1", new JObject() { ["FNumber"] = item["HWorkShopNumber"].ToString() }); // çäº§è½¦é´ |
| | |
| | | FentityModel.Add("FBaseRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");// |
| | | FentityModel.Add("FOwnerId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | string sErr = ""; |
| | | if (oSystemParameter.ShowBill(ref sErr)) |
| | | { |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º") |
| | | { |
| | | if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥èºè·¯çº¿") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumbers"].ToString() }); // ä»åº |
| | | } |
| | | else if (oSystemParameter.omodel.MES_StationOutBill_InStockType == "å·¥åº") |
| | | { |
| | | FentityModel.Add("FStockId", new JObject() { ["FNumber"] = item["HStockNumber"].ToString() }); // ä»åº |
| | | } |
| | | } |
| | | } |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["HBatchNo"].ToString() }); //æ¹å· |
| | | FentityModel.Add("FISBACKFLUSH", "true");// |
| | | FentityModel.Add("FWorkShopId1", new JObject() { ["FNumber"] = item["HWorkShopNumber"].ToString() }); // çäº§è½¦é´ |
| | |
| | | |
| | | //è·åç³»ç»åæ° |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill(); |
| | | |
| | | #region ç产任å¡å ä¿å/ç¼è¾åè½ |
| | | [Route("Sc_ICMOBill/ICMOBillEdit")] |
| | |
| | | string msg2 = sArray[0].ToString(); //ä¸»è¡¨æ°æ® |
| | | int OperationType = int.Parse(sArray[1].ToString()); // æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ |
| | | string user = sArray[2].ToString(); |
| | | int HEntryID = int.Parse(sArray[3].ToString()); |
| | | |
| | | try |
| | | { |
| | |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
| | | "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + "" + |
| | | ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + " where HInterID=" + HInterID); |
| | | |
| | | //å é¤å表 |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "'"); |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'"); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType); |
| | | objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType, HEntryID); |
| | | |
| | | if (objJsonResult.code == "0") |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType) |
| | | public json AddBillSub_NoTable(string msg3, long HInterID, int OperationType,int HEntryID) |
| | | { |
| | | ClsSc_ICMOBillSub oSub = Newtonsoft.Json.JsonConvert.DeserializeObject<ClsSc_ICMOBillSub>(msg3); |
| | | if (oSub.HQty <= 0 || oSub.HQty == null) |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (oSub.HBomID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //if (oSub.HBomID == 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "BOMä¸è½ä¸ºç©º"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | oCN.RunProc($@"Insert into Sc_ICMOBillSub |
| | | (HInterID,HENTRYID,HQty |
| | |
| | | ,HMaterID,HUnitID,HRemark,HSourceID,HDeptID,HSTATUS |
| | | ,HBomID,HEntryCusID |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney) |
| | | values({HInterID},1,{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | values({HInterID},{HEntryID},{(oSub.HQty == null ? 0 : oSub.HQty)} |
| | | ,'{(oSub.HPlanBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HPlanBeginDate.ToString())}','{(oSub.HPlanEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HPlanEndDate.ToString())}' |
| | | ,'{(oSub.HBeginDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : oSub.HBeginDate.ToString())}','{(oSub.HEndDate == null ? DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") : oSub.HEndDate.ToString())}' |
| | | ,{oSub.HMaterID},{oSub.HUnitID},'{oSub.HRemark}',{oSub.HSourceID},{oSub.HDeptID},{oSub.HSTATUS} |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åå®¡æ ¸/åå®¡æ ¸åè½ |
| | | [Route("Sc_ICMOBill/CheckSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CheckSc_ICMOReportBill(string HInterID,int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Check", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéå®¡æ ¸!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 å®¡æ ¸ 2 åå®¡æ ¸ |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.CheckBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (BillOld.AbandonCheck(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet DSet = oCn.RunProcReturn("exec h_p_Sc_ICMOBill_AbandonCheckCtrl " + int.Parse(HInterID), "h_p_Sc_ICMOBill_AbandonCheckCtrl"); |
| | | //if (DBUtility.ClsPub.isInt(DSet.Tables[0].Rows[0]["Hback"]) != 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = "该任å¡å已䏿¨æµè½¬å¡ï¼ä¸å
许åå®¡æ ¸" + DBUtility.ClsPub.isStrNull(DSet.Tables[0].Rows[0]["HBackRemark"]); |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åå
³é/åå
³éåè½ |
| | | [Route("Sc_ICMOBill/CloseSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CloseSc_ICMOReportBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Close", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéå
³é!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 å
³é 2 åå
³é |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.CloseBill(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å
³é失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (!BillOld.CancelClose(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åå
³é失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç产任å¡åä½åº/åä½åºåè½ |
| | | [Route("Sc_ICMOBill/CancellSc_ICMOReportBill")] |
| | | [HttpGet] |
| | | public object CancellSc_ICMOReportBill(string HInterID, int Type, string user) |
| | | { |
| | | try |
| | | { |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Delete", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æéä½åº!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | if (string.IsNullOrWhiteSpace(HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ClsPub.CurUserName = user; |
| | | |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | |
| | | //Type 1 ä½åº 2 åä½åº |
| | | if (Type == 1) |
| | | { |
| | | if (!BillOld.Cancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (!BillOld.AbandonCancelltion(int.Parse(HInterID), ref ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ§è¡æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ§è¡å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region ç产任å¡åå é¤åè½ |
| | | [Route("Sc_ICMOBill/DeltetSc_ICMOReportBill")] |
| | | [HttpGet] |
| | |
| | | public string HProcCheckNote = ""; // varchar(2000) æ¬å·¥åºç¡®è®¤è®°å½ |
| | | public string HProcWorkNum = ""; // varchar(100) ç¨åºå· |
| | | |
| | | //ççªæ°å åæ®µ |
| | | public int HBadWHID { get; set; } //ä¸è¯åä» |
| | | public int HWasterWHID { get; set; } //æ¥åºä» |
| | | public int HWHID { get; set; } //è¯åä» |
| | | |
| | | } |
| | | } |