From a3fd494312a6f22551e65f1387e4a57409ea075d Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期三, 04 九月 2024 10:50:46 +0800
Subject: [PATCH] 一些单据添加自动审核系统参数
---
DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs | 77 +++++++++++++++++++++++++++++++++++++-
1 files changed, 75 insertions(+), 2 deletions(-)
diff --git a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
index dfa92b6..e3149f5 100644
--- a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
+++ b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
@@ -102,6 +102,71 @@
throw (e);
}
}
+
+ //新增单据
+ public bool AddBill1(ref string sReturn)
+ {
+ try
+ {
+ //若MAINDI重复则重新获取
+ oCn.BeginTran();
+ string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp"+
+ "(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
+ "HRemark,HSaveType,HICMOInterID,HICMOEntryID,HICMOBillNo,HSplitNo,HMaterID,HProcID,HSourceID,HDate,HGroupID,HDeptID,HStationID," +
+ "HPRDORGID,HAuxPropID,HBillType,HBillSubType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
+ "HRelationEntryID,HRelationBillNo,HMaker,HMakeDate)" +
+ "values(" +
+ "'" + omodel.HBarCode +
+ "'," + omodel.HInterID +
+ ",'" + omodel.HBillNo +
+ "'," + omodel.HCheckManID +
+ "," + omodel.HBadReasonID +
+ "," + omodel.HWasterReasonID +
+ ",'" + omodel.HResult +
+ "','" + omodel.HAddr +
+ "','" + omodel.HRemark +
+ "','" + omodel.HSaveType +
+ "'," + omodel.HICMOInterID +
+ "," + omodel.HICMOEntryID +
+ ",'" + omodel.HICMOBillNo +
+ "','" + omodel.HSplitNO +
+ "'," + omodel.HMaterID +
+ "," + omodel.HProcID +
+ "," + omodel.HSourceID +
+ ",'" + omodel.HDate +
+ "'," + omodel.HGroupID +
+ "," + omodel.HDeptID +
+ "," + omodel.HStationID +
+ "," + omodel.HPRDORGID +
+ "," + omodel.HAuxPropID +
+ ",'" + BillType +
+ "','" + "" +
+ "'," + omodel.HReportType +
+ "," + omodel.HSourceInterID +
+ "," + omodel.HSourceEntryID +
+ ",'" + omodel.HSourceBillNo +
+ "','" + omodel.HSourceBillType +
+ "'," + omodel.HRelationInterID +
+ "," + omodel.HRelationEntryID +
+ ",'" + omodel.HRelationBillNo +
+ "','" + omodel.HMaker +
+ "','" + omodel.HMakeDate +
+ "')";
+
+ //主表
+ oCn.RunProc(sql);
+ sReturn = "新增单据成功！";
+ oCn.Commit();
+ return true;
+ }
+ catch (Exception e)
+ {
+ sReturn = e.Message;
+ oCn.RollBack();
+ throw (e);
+ }
+ }
+
//显示单据
public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
{
@@ -134,9 +199,17 @@
omodel.HRelationInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRelationInterID"]);
omodel.HRelationEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRelationEntryID"]);
omodel.HRelationBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRelationBillNo"]);
+ omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim();
+ omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim();
+ omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim();
+ omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim();
+ omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim();
+ omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim();
+ omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim();
+ omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim();
//
-
-
+
+
sReturn = "显示单据成功！";
return true;
}
--
Gitblit v1.9.1