| | |
| | | return objJsonResult; |
| | | } |
| | | //根据任务单查找到金蝶的生产订单 |
| | | DataSet ds1 = oCN.RunProcReturn("select * from h_v_TOERP_StationOutBillList_LastProc where HICMOInterID=" + dr["HICMOInterID"].ToString(), "h_v_TOERP_StationOutBillList_LastProc"); |
| | | 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("FWorkshipId", new JObject() { ["Fnumber"] = dr1["FWorkShopNUM"].ToString() }); // 生产车间 |
| | | FentityModel.Add("FStandHourUnitId", "3600"); // 单位标准工时单位 |
| | | FentityModel.Add("FMaterialId", new JObject() { ["Fnumber"] = dr1["FMaterialNUM"].ToString() }); // 物料编码 |
| | | FentityModel.Add("FMoEntrySeq", dr1["HICMOEntryID"].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 |
| | |
| | | //["IsAutoSubmitAndAudit"] = true,//自动调用提交和审核功能 |
| | | ["Model"] = model |
| | | }; |
| | | LogService.Write("jsonRoot:" + jsonRoot); |
| | | |
| | | 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; |
| | |
| | | Ids = fID, |
| | | }; |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//提交 |
| | | //result2 = InvokeHelper.Audit("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(); |