派生自 MES-WEB-API
WebAPI/Controllers/Sc_ProcessMangementController.cs
@@ -98,6 +98,51 @@ return objJsonResult; } #region 末道工序汇报入库 /// <summary> /// 末道工序汇报入库列表 /// </summary> /// <param name="sWhere"></param> /// <param name="user"></param> /// <returns></returns> [Route("Sc_ProcessMangement/Sc_ProcessReportList_Last")] [HttpGet] public object Sc_ProcessReportList_Last(string sWhere, string user) { try { //判断是否有查询权限 if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无查询权限!"; objJsonResult.data = null; return objJsonResult; } string sql1 = "select * from h_v_Sc_ProcessReportList_Last where 1 = 1 and HLastProc='是'"; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessReportList_Last"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 工序汇报入库 /// <summary> /// 获取工序汇报入库单列表 @@ -121,16 +166,11 @@ return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc order by hmainid desc", "h_v_MES_StationOutBillList_LastProc"); } else { string sql1 = "select * from h_v_MES_StationOutBillList_LastProc where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_MES_StationOutBillList_LastProc"); } string sql1 = "select * from h_v_Sc_ProcessReportList_Last where 1 = 1 and HFstProc='是' "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessReportList_Last"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; @@ -167,16 +207,26 @@ //根据工序汇报单主ID获取工序汇报入库单的数据 DataSet ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc where HInterID=" + InterID, "h_v_MES_StationOutBillList_LastProc"); DataRow dr = ds.Tables[0].Rows[0]; //保存 oCN.BeginTran(); //生产汇报单主表 oCN.RunProc("Insert Into Sc_ICMOReportBillMain " + 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()" + " values('3711','3711'," + HInterID.ToString() + ",'" + BillNo + "',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'" + @@ -220,7 +270,7 @@ 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); model.Add("FBillNo", BillNo); JArray Fentity = new JArray(); @@ -260,19 +310,6 @@ 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()); //流转卡号 //批号 //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"); @@ -334,6 +371,8 @@ objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo+"'"); oCN.Commit(); objJsonResult.code = "0"; @@ -421,6 +460,14 @@ //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" }); //单据类型 @@ -431,7 +478,7 @@ model.Add("FOwnerId0", new JObject() { ["FNumber"] = dr1["HPrdOrgNumber"].ToString() }); // model.Add("FIsEntrust", "false");// model.Add("FCurrId", new JObject() { ["FNumber"] = "PRE001" }); // model.Add("FBillNo", HBillNo); model.Add("FBillNo", BillNo); JArray Fentity = new JArray(); @@ -571,6 +618,8 @@ objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); oCN.Commit(); objJsonResult.code = "0"; @@ -809,7 +858,10 @@ return objJsonResult; } oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); oCN.Commit(); oCN.RunProc("update sc_stationoutbillmain set HBFFlag =1 where HProcExchBillNo = '" + BillNo + "'"); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "保存成功！"; @@ -873,7 +925,7 @@ ") values(" + HInterID.ToString() + ",1,'',''" + ",''," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo.ToString() + "','" + HSourceBillType.ToString() + "'" + ",0,0,0,0,''"+ ",0,0,0,0,''" + ",'" + HCheckResult.ToString() + "','" + HCheckResult.ToString() + "','" + HKeeperID.ToString() + "',getdate()" + ") "); //同步金蝶 @@ -905,6 +957,7 @@ FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = HUnitNumber.ToString() });//计量单位内码 FentityModel.Add("FInspectQty", HCheckQty.ToString());// 检验数量 FentityModel.Add("FQualifiedQty", HRightQty.ToString());// 合格数量 FentityModel.Add("FUnqualifiedQty", HBadQty.ToString());// 不合格数量 FentityModel.Add("FInspectResult", HCheckResult.ToString());// 检验结果 FentityModel.Add("FQCStatus", "1");// 质检状态 FentityModel.Add("FIsRelated", false);// 不良品关联标志 @@ -912,13 +965,14 @@ FentityModel.Add("FBaseUnitId", new JObject() { ["Fnumber"] = HUnitNumber.ToString() });//基本单位 FentityModel.Add("FBaseInspectQty", HCheckQty.ToString());//基本单位检验数量 FentityModel.Add("FSupplierId", new JObject() { ["Fnumber"] = HSupNumber.ToString() }); // 供应商 FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = HWHNumber.ToString() }); // 仓库 //FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = HWHNumber.ToString() }); // 仓库 FentityModel.Add("FInspectTimes","1"); // 检验次数 FentityModel.Add("FTimeUnit","24");//时间单位 FentityModel.Add("FSAMPLEDAMAGEBEARER","2");//样本破坏承担方 FentityModel.Add("FISFIRSTINSPECT", false);//首检 FentityModel.Add("FBaseQualifiedQty", HRightQty.ToString());//基本单位合格数 FentityModel.Add("FCurrency", new JObject() { ["Fnumber"] = "PRE001" });//币别 FentityModel.Add("FBaseAcceptQty", HRightQty.ToString());//基本单位接收数 FentityModel.Add("FCurrency", new JObject() { ["Fnumber"] = "PRE001" });//币别 FentityModel.Add("FIsSplitRow ", false);// 是否拆分行 JArray Fentity2 = new JArray(); @@ -932,7 +986,7 @@ FentityModel2.Add("FIsDefectProcess", false); //不良处理 FentityModel2.Add("FCanSale", false); //可销售 FentityModel2.Add("FIsMRBReview", false); //MRP评审 FentityModel2.Add("FIsReturn", false); //判退 FentityModel2.Add("FIsReturn", true); //判退 FentityModel2.Add("FIsRelatedDefect", false); //不良品关联标志 Fentity2.Add(FentityModel2); FentityModel.Add("FPolicyDetail", Fentity2); @@ -941,6 +995,7 @@ 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 @@ -953,6 +1008,23 @@ 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_FBaseAcceptQty", HRightQty.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() @@ -1100,6 +1172,7 @@ FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = HUnitNumber.ToString() });//计量单位内码 FentityModel.Add("FInspectQty", HCheckQty.ToString());// 检验数量 FentityModel.Add("FQualifiedQty", HRightQty.ToString());// 合格数量 FentityModel.Add("FUnqualifiedQty", HBadQty.ToString());// 不合格数量 FentityModel.Add("FInspectResult", HCheckResult.ToString());// 检验结果 FentityModel.Add("FQCStatus", "1");// 质检状态 FentityModel.Add("FIsRelated", false);// 不良品关联标志 @@ -1107,7 +1180,7 @@ FentityModel.Add("FBaseUnitId", new JObject() { ["Fnumber"] = HUnitNumber.ToString() });//基本单位 FentityModel.Add("FBaseInspectQty", HCheckQty.ToString());//基本单位检验数量 //FentityModel.Add("FSupplierId", new JObject() { ["Fnumber"] = HSupNumber.ToString() }); // 供应商 FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = HWHNumber.ToString() }); // 仓库 //FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = HWHNumber.ToString() }); // 仓库 FentityModel.Add("FInspectTimes", "1"); // 检验次数 FentityModel.Add("FTimeUnit", "24");//时间单位 FentityModel.Add("FSAMPLEDAMAGEBEARER", "2");//样本破坏承担方 @@ -1127,13 +1200,44 @@ FentityModel2.Add("FIsDefectProcess", false); //不良处理 FentityModel2.Add("FCanSale", false); //可销售 FentityModel2.Add("FIsMRBReview", false); //MRP评审 FentityModel2.Add("FIsReturn", false); //判退 FentityModel2.Add("FIsReturn", true); //判退 FentityModel2.Add("FIsRelatedDefect", false); //不良品关联标志 Fentity2.Add(FentityModel2); FentityModel.Add("FPolicyDetail", Fentity2); JArray Fentity3 = new JArray(); JObject FentityModel3 = new JObject(); FentityModel3.Add("FDetailID", "0");// FentityModel3.Add("FSrcBillType", "SFC_OperationReport"); //源单类型 FentityModel3.Add("FSrcBillNo", HSLBillNo.ToString()); //工序汇报单单号 FentityModel3.Add("FSrcInterId", HSLInterID.ToString()); //工序汇报单主ID FentityModel3.Add("FSrcEntryId", HSLEntryID.ToString()); //工序汇报单子ID FentityModel3.Add("FSrcEntrySeq", HSLSeQ.ToString()); //工序汇报单行号 FentityModel3.Add("FOrderType", new JObject() { ["FID"] = "PRD_MO" }); // 生产订单类型 FentityModel3.Add("FOrderBillNo", HSourceBillNo.ToString()); //生产订单单号 FentityModel3.Add("FOrderId", HSourceInterID.ToString()); //生产订单主ID FentityModel3.Add("FOrderEntryId", HSourceEntryID.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_OperRpt2Inspect"); //单据转换规则 FentityModel4.Add("FEntity_Link_FSTableName", "T_SFC_OPTRPTENTRY"); //工序汇报单子表 FentityModel4.Add("FEntity_Link_FSBillId", HSLInterID.ToString()); //工序汇报单主ID FentityModel4.Add("FEntity_Link_FSId", HSLEntryID.ToString()); //工序汇报单子ID FentityModel4.Add("FEntity_Link_FBaseAcceptQty", HRightQty.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); //JArray Fentity3 = new JArray(); //JObject FentityModel3 = new JObject(); //FentityModel3.Add("FSrcBillType", "SFC_OperationReport"); //源单类型
