| | |
|---|
| | | //根据工序汇报单主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'" + |
|---|
| | |
|---|
| | | 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", dr1["单据号"].ToString()); |
|---|
| | | model.Add("FBillNo", BillNo); |
|---|
| | | |
|---|
| | | JArray Fentity = new JArray(); |
|---|
| | | |
|---|
