| | |
| | | long HInterID = list[0].HInterID;//éå
¥typeå¾å°çåæ®ID |
| | | string HBillNo = list[0].HBillNo;//éå
¥typeå¾å°çåæ®å· |
| | | int HBillStatus = 0; |
| | | string HMaker = list[0].HMaker;//å¶å人 |
| | | string HMaker = user;//å¶å人 |
| | | string HMouldNum = list[0].HMouldNum;//æ¨¡ç©´å· |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | if (HCenterID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å·¥ä½ä¸å¿æ²¡æéæ©ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //if (HCenterID == 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å·¥ä½ä¸å¿æ²¡æéæ©ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | if (HQty + HWasterQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " + |
| | | " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + |
| | | " Where a.HInterID=" + HProcExchInterID + " and b.HEntryID=" + HProcExchEntryID + " ", "Sc_ProcessExchangeBillMain"); |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0 || HLastSubProc == false) |
| | | //夿æ¯å¦æ¯æ°å¢ |
| | | if ("Add".Equals(eventType)) |
| | | { |
| | | |
| | | //夿æ¯å¦æ¯æ«éå·¥åº |
| | | if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HLastProc"]) == "æ¯") |
| | | { |
| | | //è·åç³»ç»åæ° |
| | | string Return = ""; |
| | | if (oSystemParameter.ShowBill(ref Return)) |
| | | { |
| | | //夿æ«é çäº§æ±æ¥æ±æ¥ æ¯å¦å¾é |
| | | if (oSystemParameter.omodel.MES_StationOutBill_LastAutoICMOReport == "Y") //ç³»ç»åæ° |
| | | { |
| | | //忥çäº§æ±æ¥å |
| | | objJsonResult= (json)SaveICMOReportBill(HInterID.ToString(), user, HBillNo, HPRDOrgID.ToString()); |
| | | if (objJsonResult.count == 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = objJsonResult.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //夿æ«é ç产å
¥åº æ¯å¦å¾é |
| | | else if (oSystemParameter.omodel.MES_StationOutBill_AutoStockIn == "Y") //ç³»ç»åæ° |
| | | { |
| | | //忥ç产å
¥åºå |
| | | objJsonResult=(json)SaveProcdutInBill(HBillNo); |
| | | if (objJsonResult.count == 0) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = objJsonResult.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |
| | | } |
| | | else if (ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HLastProc"]) == "æ¯") |
| | | { |
| | | |
| | | } |
| | | |
| | | |
| | | oCN.Commit(); |
| | | string sReturn = ""; |
| | | if (oSystemParameter.ShowBill(ref sReturn) == true) |
| | |
| | | } |
| | | } |
| | | |
| | | #region æ«éå·¥åº çäº§æ±æ¥ |
| | | public object SaveICMOReportBill(string InterID, string user, string BillNo, string OrganizationID) |
| | | { |
| | | try |
| | | { |
| | | //è·åçäº§æ±æ¥åæå¤§InterIDååæ®å· |
| | | Int64 HInterID = DBUtility.ClsPub.CreateBillID("3711", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo = DBUtility.ClsPub.CreateBillCode("3711", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | //è·åç»ç»ä»£ç |
| | | string OrganizationNUM = oCN.RunProcReturn("select HNumber from Xt_ORGANIZATIONS where HItemID=" + OrganizationID, "Xt_ORGANIZATIONS").Tables[0].Rows[0]["HNumber"].ToString(); |
| | | //æ ¹æ®å·¥åºæ±æ¥å主IDè·åå·¥åºæ±æ¥å
¥åºåçæ°æ® |
| | | DataSet ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc where HInterID=" + InterID, "h_v_MES_StationOutBillList_LastProc"); |
| | | if (ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "çæçäº§æ±æ¥åè¿ç¨ä¸æ²¡ææ¥è¯¢å°åºç«å"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | DataRow dr = ds.Tables[0].Rows[0]; |
| | | |
| | | //ä¿å |
| | | //oCN.BeginTran(); |
| | | DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain where HBillNo='{HBillNo}'", "Sc_ICMOReportBillMain"); |
| | | if (DsTable.Tables[0].Rows.Count > 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å·²å
¥åº,请ä¸è¦éå¤å
¥åº"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //çäº§æ±æ¥å主表 |
| | | oCN.RunProc("Insert Into Sc_ICMOReportBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate,HBillStatus,HChecker,HCheckDate" + |
| | | ",HYear,HPeriod,HRemark,HEmpID,HEmpNumber" + |
| | | ",HGroupID,HDeptID,HDeptNumber" + |
| | | ",HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType" + |
| | | ") " + |
| | | " values('3711','3711'," + HInterID.ToString() + ",'" + HBillNo + "',getdate(),'" + user + "',getdate(),2,'" + user + "',getdate()" + |
| | | ",DATENAME(YEAR,GETDATE()),0,'','" + dr["HEmpID"].ToString() + "','" + dr["æä½å代ç "].ToString() + |
| | | "','" + dr["HGroupID"].ToString() + "',0,''" + |
| | | ",'" + BillNo.ToString() + "'," + InterID.ToString() + ", 0,'3791'" + |
| | | ") "); |
| | | //çäº§æ±æ¥åå表 |
| | | oCN.RunProc("Insert into Sc_ICMOReportBillSub " + |
| | | " (HInterID,HEntryID,HMaterID,HMaterNumber" + |
| | | ",HQty,HUnitID,HUnitNumber,HTimes,HSourceID" + |
| | | ",HQtyMust,HWorkerID,HWorkerNumber,HBadCount,HWasterQty," + |
| | | "HCloseMan,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + |
| | | ",HICMOInterID,HICMOBillNo,HBarCode" + |
| | | ") values(" |
| | | + HInterID.ToString() + ",1," + dr["HMaterID"].ToString() + ",'" + dr["产å代ç "].ToString() + "'" + |
| | | "," + dr["åæ ¼æ°é"].ToString() + ",0,'',0,0" + |
| | | "," + dr["æ¥æ¶æ°é"].ToString() + "," + dr["HEmpID"].ToString() + ",'" + dr["æä½å代ç "].ToString() + "'," + dr["ä¸è¯æ°é"].ToString() + "," + dr["æ¥åºæ°é"].ToString() + |
| | | ",'',0,''" + |
| | | "," + InterID.ToString() + ",0,'" + BillNo.ToString() + "','3791',0,0" + |
| | | ",0,0,''" + |
| | | "," + dr["HICMOInterID"].ToString() + ",'" + dr["ä»»å¡å"].ToString() + "',''" + |
| | | ") "); |
| | | //忥éè¶ |
| | | //访é®éè¶ |
| | | var loginRet = InvokeHelper.Login(); |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸ã" + loginRet; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æ ¹æ®ä»»å¡åæ¥æ¾å°éè¶çç产订å |
| | | DataSet ds1 = oCN.RunProcReturn("select * from h_v_TOERP_StationOutBillList_LastProc where HICMOEntryID=" + dr["HICMOEntryID"].ToString(), "h_v_TOERP_StationOutBillList_LastProc"); |
| | | DataRow dr1 = ds1.Tables[0].Rows[0]; |
| | | |
| | | JObject model = new JObject(); |
| | | model.Add("FBillType", new JObject() { ["Fnumber"] = "SCHBD01_SYS" }); //åæ®ç±»åçäº§æ±æ¥âSCHBD02_SYSâ å
¥åºæ±æ¥SCHBD01_SYS |
| | | model.Add("FPrdOrgId", new JObject() { ["Fnumber"] = dr1["FPrdOrgNUMBER"].ToString() }); //ç产ç»ç»1 |
| | | model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //åæ®æ¥æ1 |
| | | model.Add("FHZYMESFLAG", "æ¯");// æ¯å¦ä¸ºMES忥 |
| | | model.Add("FBillNo", HBillNo); |
| | | |
| | | JArray Fentity = new JArray(); |
| | | |
| | | foreach (DataRow item in ds.Tables[0].Rows) |
| | | { |
| | | JObject FentityModel = new JObject(); |
| | | FentityModel.Add("FIsNew", false);// æºåç±»å |
| | | FentityModel.Add("FReportType", new JObject() { ["Fnumber"] = dr1["FREPORTTYPENUMBER"].ToString() });//çäº§æ±æ¥ç±»å |
| | | FentityModel.Add("FSrcBillType", "PRD_MO");// æºåç±»å |
| | | FentityModel.Add("FProductType", "1");// 产åç±»å |
| | | FentityModel.Add("FSrcBillNo", item["ä»»å¡å"].ToString());// æºåç¼å· |
| | | FentityModel.Add("FSrcInterId", dr1["FMOID"].ToString());// æºåå
ç |
| | | FentityModel.Add("FSrcEntryId", dr1["FMOENTRYID"].ToString());// æºååå½å
ç ã |
| | | FentityModel.Add("FSRCENTRYSEQ", dr1["FMOENTRYSEQ"].ToString());// æºååå½è¡å· |
| | | FentityModel.Add("FUNITID", new JObject() { ["Fnumber"] = dr1["FUNITNUMBER"].ToString() });//åä½ |
| | | FentityModel.Add("FTimeUnitId", "1");//æ¶é´åä½ |
| | | FentityModel.Add("FWorkshipId", new JObject() { ["Fnumber"] = dr1["FWorkShopNUM"].ToString() }); // çäº§è½¦é´ |
| | | FentityModel.Add("FStandHourUnitId", "3600"); // å使 åå·¥æ¶åä½ |
| | | FentityModel.Add("FMaterialId", new JObject() { ["Fnumber"] = dr1["FMaterialNUM"].ToString() }); // ç©æç¼ç |
| | | FentityModel.Add("FMoEntrySeq", dr1["FMOENTRYSEQ"].ToString());//ç产订åè¡å· |
| | | FentityModel.Add("FMoId", dr1["HICMOInterID"].ToString());//ç产订åå
ç |
| | | FentityModel.Add("FFinishQty", item["æ¥æ¶æ°é"].ToString());//宿æ°é1 |
| | | FentityModel.Add("FQuaQty", item["åæ ¼æ°é"].ToString());//åæ ¼æ°é1FFailQty |
| | | FentityModel.Add("FFailQty", item["ä¸è¯æ°é"].ToString());//ä¸åæ ¼æ°é |
| | | FentityModel.Add("FStockInOrgId ", new JObject() { ["Fnumber"] = OrganizationNUM });// å
¥åºç»ç» |
| | | FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = dr1["FStockNUM"].ToString() }); // ä»åº |
| | | FentityModel.Add("FMOID", dr1["FMOID"].ToString());// |
| | | FentityModel.Add("FMOBILLNO", dr1["FMOBILLNO"].ToString());// |
| | | FentityModel.Add("FMOENTRYID", dr1["FMOENTRYID"].ToString());// |
| | | FentityModel.Add("FMOENTRYSEQ", dr1["FMOENTRYSEQ"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", dr1["FOWNERTYPEID"].ToString()); //货主类åï¼FOwnerTypeId(å¿
填项) |
| | | FentityModel.Add("FOwnerId", new JObject() { ["Fnumber"] = dr1["FOwnerNumber"].ToString() }); //货主ï¼FOwnerId(å¿
填项) |
| | | FentityModel.Add("FBomId", new JObject() { ["Fnumber"] = dr1["FBOMNUM"].ToString() }); //BOMçæ¬ï¼FBomId(å¿
填项) |
| | | FentityModel.Add("FCostRate", dr1["FCostRate"].ToString());// ææ¬æé |
| | | FentityModel.Add("FISBACKFLUSH", dr1["FISBACKFLUSH"].ToString() == "1" ? true : false);// åå²é¢æ |
| | | FentityModel.Add("FMOMAINENTRYID", dr1["FMOENTRYID"].ToString());// |
| | | //FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //å
è£
æ è¯ |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = dr1["FBATCHNO"].ToString() }); //æ¹å· |
| | | FentityModel.Add("F_bsv_Text", dr1["å·¥åºæµè½¬å¡å·"].ToString()); //æµè½¬å¡å· |
| | | JArray Fentity2 = new JArray(); |
| | | JObject FentityModel2 = new JObject(); |
| | | FentityModel2.Add("FEntity_Link_FFlowId", "f6e6eec3-5267-4f02-8593-b633da508a72"); |
| | | FentityModel2.Add("FEntity_Link_FFlowLineId", "PRD_MO2MORPT"); |
| | | FentityModel2.Add("FEntity_Link_FRuleId", "3"); |
| | | FentityModel2.Add("FEntity_Link_FSTableId", "0"); |
| | | FentityModel2.Add("FEntity_Link_FSTableName", "T_PRD_MOENTRY"); |
| | | FentityModel2.Add("FEntity_Link_FSBillId", dr1["FMOID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSId", dr1["FMOENTRYID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBaseQuaQtyOld", item["åæ ¼æ°é"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBaseQuaQty", item["åæ ¼æ°é"].ToString()); |
| | | Fentity2.Add(FentityModel2); |
| | | FentityModel.Add("FEntity_Link", Fentity2); |
| | | FentityModel.Add("FBFLowId", new JObject() { ["FID"] = "f6e6eec3-5267-4f02-8593-b633da508a72" }); // |
| | | Fentity.Add(FentityModel); |
| | | } |
| | | model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ |
| | | JObject jsonRoot = new JObject() |
| | | { |
| | | ["Creator"] = "", |
| | | ["NeedUpDateFields"] = new JArray(), |
| | | ["NeedReturnFields"] = new JArray(), |
| | | ["IsDeleteEntry"] = "false", |
| | | ["SubSystemId"] = "", |
| | | ["IsVerifyBaseDataField"] = "false", |
| | | //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ |
| | | ["Model"] = model |
| | | }; |
| | | |
| | | string result = InvokeHelper.Save("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | //夿ä¿åæ¯å¦æå |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("å·¥åºæ±æ¥åå
¥åºé误jsonRoot:" + jsonRoot); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"å·¥åºæ±æ¥å
¥åºå忥éè¶äºå¤±è´¥ï¼åå·:{dr["åæ®å·"].ToString()}" + result; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æäº¤å®¡æ ¸ |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"çäº§æ±æ¥ååå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); |
| | | |
| | | //oCN.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ«éå·¥åº ç产å
¥åº |
| | | public object SaveProcdutInBill(string BillNo) |
| | | { |
| | | try |
| | | { |
| | | //è·åçäº§æ±æ¥åæå¤§InterIDååæ®å· |
| | | Int64 HInterID = DBUtility.ClsPub.CreateBillID("1202", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo = DBUtility.ClsPub.CreateBillCode("1202", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | |
| | | ////夿å
¥åºçåæ ¼æ°éæ¯å¦ä¸º0 |
| | | //var DTable = oCN.RunProcReturn("select * from Sc_StationOutBillMain where HBillNo='" + BillNo + "' ", "Sc_StationOutBillMain").Tables[0]; |
| | | |
| | | //if (double.Parse(DTable.Rows[0]["HQty"].ToString()) == 0) |
| | | //{ |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 2; |
| | | // objJsonResult.Message = "åæ ¼æ°é为0,ä¸éè¦å
¥åºï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //ä¿å |
| | | //oCN.BeginTran(); |
| | | |
| | | //忥éè¶ |
| | | //访é®éè¶ |
| | | var loginRet = InvokeHelper.Login(); |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸ã" + loginRet; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | DataSet ds1 = oCN.RunProcReturn("exec h_p_TOERPProcduct_LastProc_Mes '" + BillNo + "'", "h_p_TOERPProcduct_LastProc_Mes"); |
| | | DataRow dr1 = ds1.Tables[0].Rows[0]; |
| | | if (double.Parse(dr1[0].ToString()) <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¾å°å¯¹åºççäº§æ±æ¥åè®°å½;1.æªæ¥è¯¢å°å¯¹åºççäº§æ±æ¥åï¼2.请确ä¿å½åå·¥åºæ¯æ«éå·¥åº3.æ±æ¥å对åºçå
¥åºæ°é已满 请å¨éè¶äºæ¥çå
¥åºè®°å½ï¼"; |
| | | 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")); //åæ®æ¥æ |
| | | model.Add("FStockOrgId", new JObject() { ["FNumber"] = dr1["HPrdOrgNumber"].ToString() }); //åºåç»ç»ä»£ç |
| | | model.Add("FPrdOrgId", new JObject() { ["FNumber"] = dr1["HPrdOrgNumber"].ToString() }); //ç产ç»ç»ä»£ç |
| | | model.Add("FOwnerTypeId0", "BD_OwnerOrg"); |
| | | model.Add("FOwnerId0", new JObject() { ["FNumber"] = dr1["HPrdOrgNumber"].ToString() }); // |
| | | model.Add("FIsEntrust", "false");// |
| | | model.Add("FCurrId", new JObject() { ["FNumber"] = "PRE001" }); // |
| | | model.Add("FBillNo", BillNo); |
| | | |
| | | JArray Fentity = new JArray(); |
| | | |
| | | foreach (DataRow item in ds1.Tables[0].Rows) |
| | | { |
| | | JObject FentityModel = new JObject(); |
| | | FentityModel.Add("FSrcEntryId", item["HSourceEntryID"].ToString());// æºååå½å
ç ã |
| | | FentityModel.Add("FIsNew", "false");// æºåç±»å |
| | | FentityModel.Add("FMaterialId", new JObject() { ["FNumber"] = item["HMaterNumber"].ToString() }); // ç©æç¼ç |
| | | FentityModel.Add("FCheckProduct", "false");// |
| | | FentityModel.Add("FInStockType", "1");// |
| | | FentityModel.Add("FProductType", "1");// |
| | | FentityModel.Add("FUNITID", new JObject() { ["FNumber"] = item["HUnitNumber"].ToString() });//åä½ |
| | | FentityModel.Add("FMustQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FCostRate", "100");// |
| | | FentityModel.Add("FBaseUnitId", new JObject() { ["FNumber"] = item["HUnitNumber"].ToString() });//åä½ |
| | | FentityModel.Add("FBaseMustQty", item["æ°é"].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() }); // ä»åº |
| | | FentityModel.Add("FLot", new JObject() { ["FNumber"] = item["HBatchNo"].ToString() }); //æ¹å· |
| | | FentityModel.Add("FISBACKFLUSH", "true");// |
| | | FentityModel.Add("FWorkShopId1", new JObject() { ["FNumber"] = item["HWorkShopNumber"].ToString() }); // çäº§è½¦é´ |
| | | FentityModel.Add("FMOBILLNO", item["HMOBillNo"].ToString());// |
| | | FentityModel.Add("FMoId", item["HICMOInterID"].ToString());//ç产订åå
ç |
| | | FentityModel.Add("FMoEntryId", item["HMOEntryID"].ToString());// |
| | | FentityModel.Add("FMoEntrySeq", item["HMOEntrySEQ"].ToString());//ç产订åè¡å· |
| | | FentityModel.Add("FStockUnitId", new JObject() { ["FNumber"] = item["HUnitNumber"].ToString() });//åºååä½ |
| | | FentityModel.Add("FStockRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FSrcBillType", "PRD_MORPT");// |
| | | FentityModel.Add("FSrcBillNo", item["HSourceBillNo"].ToString());// |
| | | FentityModel.Add("FSrcInterId", item["HSourceInterID"].ToString());// |
| | | FentityModel.Add("FBasePrdRealQty", item["æ°é"].ToString());// |
| | | FentityModel.Add("FIsFinished", "false");// |
| | | FentityModel.Add("FStockStatusId", new JObject() { ["FNumber"] = "KCZT01_SYS" }); // |
| | | FentityModel.Add("FSrcEntrySeq", item["HSourceSeQ"].ToString());// æºååå½è¡å· |
| | | FentityModel.Add("FMOMAINENTRYID", item["HMOEntryID"].ToString());// |
| | | FentityModel.Add("FKeeperTypeId", "BD_KeeperOrg"); |
| | | FentityModel.Add("FKeeperId", new JObject() { ["FNumber"] = item["HPrdOrgNumber"].ToString() });// |
| | | FentityModel.Add("FIsOverLegalOrg", "false");// |
| | | FentityModel.Add("F_bsv_Base1", new JObject() { ["FNumber"] = item["HBZBS"].ToString() });// |
| | | FentityModel.Add("F_BSV_TEXT", item["HLZKH"].ToString());// |
| | | FentityModel.Add("F_BSV_TEXT1", item["HWYID"].ToString());// |
| | | //æ¹å· |
| | | //FFLOWID FFLOWLINEID FRULEID FSTABLENAME |
| | | //f6e6eec3 - 5267 - 4f02 - 8593 - b633da508a72 3 PRD_MO2MORPT T_PRD_MOENTRY |
| | | //ä¸å¡æµç¨å¾ï¼FEntity_Link_FFlowId |
| | | //æ¨è¿è·¯çº¿ï¼FEntity_Link_FFlowLineId |
| | | //转æ¢è§åï¼FEntity_Link_FRuleId |
| | | //æºå表å
ç ï¼FEntity_Link_FSTableId |
| | | //æºå表ï¼FEntity_Link_FSTableName |
| | | //æºåå
ç ï¼FEntity_Link_FSBillId |
| | | //æºååå½å
ç ï¼FEntity_Link_FSId |
| | | //åå§æºå¸¦éï¼FEntity_Link_FBaseQuaQtyOld |
| | | //ä¿®æ¹æºå¸¦éï¼FEntity_Link_FBaseQuaQty |
| | | JArray Fentity2 = new JArray(); |
| | | JObject FentityModel2 = new JObject(); |
| | | FentityModel2.Add("FEntity_Link_FFlowId", "f6e6eec3-5267-4f02-8593-b633da508a72"); |
| | | FentityModel2.Add("FEntity_Link_FFlowLineId", "5"); |
| | | FentityModel2.Add("FEntity_Link_FRuleId", "PRD_MORPT2INSTOCK"); |
| | | FentityModel2.Add("FEntity_Link_FSTableName", "T_PRD_MORPTENTRY"); |
| | | FentityModel2.Add("FEntity_Link_FSTableId", "0"); |
| | | FentityModel2.Add("FEntity_Link_FSBillId", item["HSourceInterID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSId", item["HSourceEntryID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBasePrdRealQtyOld", item["å
³èæ°é"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBasePrdRealQty", item["æ°é"].ToString()); |
| | | Fentity2.Add(FentityModel2); |
| | | FentityModel.Add("FEntity_Link", Fentity2); |
| | | FentityModel.Add("FBFLowId", new JObject() { ["FID"] = "f6e6eec3-5267-4f02-8593-b633da508a72" }); // |
| | | Fentity.Add(FentityModel); |
| | | |
| | | |
| | | //Fentity.Add(FentityModel); |
| | | } |
| | | model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ |
| | | JObject jsonRoot = new JObject() |
| | | { |
| | | ["Creator"] = "", |
| | | ["NeedUpDateFields"] = new JArray(), |
| | | ["NeedReturnFields"] = new JArray(), |
| | | //["IsDeleteEntry"] = "true", |
| | | //["SubSystemId"] = "", |
| | | //["IsVerifyBaseDataField"] = "false", |
| | | |
| | | |
| | | ["IsDeleteEntry"] = "true", |
| | | ["SubSystemId"] = "", |
| | | ["IsVerifyBaseDataField"] = "true", |
| | | ["IsEntryBatchFill"] = "false", |
| | | ["ValidateFlag"] = "true", |
| | | ["NumberSearch"] = "true", |
| | | ["IsAutoAdjustField"] = "false", |
| | | ["InterationFlags"] = "", |
| | | ["IgnoreInterationFlag"] = "", |
| | | |
| | | |
| | | |
| | | |
| | | //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ |
| | | ["Model"] = model |
| | | }; |
| | | |
| | | string result = InvokeHelper.Save("PRD_INSTOCK", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | //夿ä¿åæ¯å¦æå |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("ç产å
¥åºé误jsonRoot:" + jsonRoot); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"ç产å
¥åºå忥éè¶äºå¤±è´¥ï¼åå·:{HBillNo.ToString()}" + result + jsonRoot; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æäº¤å®¡æ ¸ |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | result1 = InvokeHelper.Submit("PRD_INSTOCK", JsonConvert.SerializeObject(json));//æäº¤ |
| | | //result2 = InvokeHelper.Audit("PRD_INSTOCK", JsonConvert.SerializeObject(json));//æäº¤ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"ç产å
¥åºååå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); |
| | | |
| | | //oCN.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |