| | |
| | | //DataSet ds1 = oCN.RunProcReturn("select * from h_v_TOERPProcduct_LastProc where HLastProc = '是' and hbillno='" + BillNo.ToString() + "'", "h_v_TOERPProcduct_LastProc"); |
| | | DataSet ds1 = oCN.RunProcReturn("exec h_p_TOERPProcduct_LastProc '" + BillNo + "'", "h_p_TOERPProcduct_LastProc"); |
| | | DataRow dr1 = ds1.Tables[0].Rows[0]; |
| | | if (ds1.Tables[0].Rows.Count <= 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" }); //单据类型 |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update sc_stationoutbillmain set HBFFlag =1 where HProcExchBillNo = '" + BillNo + "'"); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | |
| | | JArray Fentity3 = new JArray(); |
| | | JObject FentityModel3 = new JObject(); |
| | | FentityModel3.Add("FDetailID", "0");// |
| | | FentityModel3.Add("FSrcBillType", "PUR_ReceiveBill"); //源单类型 |
| | | FentityModel3.Add("FSrcBillNo", HSLBillNo.ToString()); //收料通知单单号 |
| | | FentityModel3.Add("FSrcInterId", HSLInterID.ToString()); //收料通知单主ID |
| | |
| | | FentityModel3.Add("FOrderEntrySeq", HSeQ.ToString()); //订单行号 |
| | | Fentity3.Add(FentityModel3); |
| | | FentityModel.Add("FReferDetail", Fentity3); |
| | | |
| | | |
| | | JArray Fentity4 = new JArray(); |
| | | JObject FentityModel4 = new JObject(); |
| | | FentityModel4.Add("FEntity_Link_FRuleId", "QM_PURReceive2Inspect"); //单据转换规则 |
| | | FentityModel4.Add("FEntity_Link_FSTableName", "T_PUR_RECEIVEENTRY"); //收料通知单子表 |
| | | FentityModel4.Add("FEntity_Link_FSBillId", HSLInterID.ToString()); //收料通知单主内码 |
| | | FentityModel4.Add("FEntity_Link_FSId", HSLEntryID.ToString()); //收料通知单子内码 |
| | | FentityModel4.Add("FEntity_Link_FBaseAcceptQtyOld", HRightQty.ToString()); // |
| | | FentityModel4.Add("FEntity_Link_FBaseInspectQtyOld", HRightQty.ToString()); // |
| | | FentityModel4.Add("FEntity_Link_FInspectQtyOld", HRightQty.ToString()); // |
| | | Fentity4.Add(FentityModel4); |
| | | FentityModel.Add("FEntity_Link", Fentity4); |
| | | |
| | | |
| | | |
| | | Fentity.Add(FentityModel); |
| | | model.Add("FEntity", Fentity); //明细信息 |
| | | JObject jsonRoot = new JObject() |