From 89742acf77b33c3acb5b306d4d99f4ae01bb2e64 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 27 三月 2024 16:32:55 +0800
Subject: [PATCH] 销售订单：增加 待关闭项 按钮，点击后数据只显示 剩余订金 在(0,500]区间审核状态且没有进行行关闭的记录。 销售订单：同一个单据只有第一条记录显示主表信息 与 layui自带的排序功能 ，问题解决。(使用layui的排序时，触发事件，不在进行同一个单据只有第一条记录显示主表信息处理)
---
DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs | 18 ++++++++++++++----
1 files changed, 14 insertions(+), 4 deletions(-)
diff --git a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
index 3ebb340..e3149f5 100644
--- a/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
+++ b/DAL/MES/ClsSc_ICMOBillQualityStatus_Tmp.cs
@@ -110,9 +110,10 @@
{
//若MAINDI重复则重新获取
oCn.BeginTran();
- string sql = "Insert into Sc_ICMOBillQualityStatus_Tmp(HBarCode,HInterID,HBillNo,HCheckManID,HBadReasonID,HWasterReasonID,HResult,HAddr," +
+ 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,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
+ "HPRDORGID,HAuxPropID,HBillType,HBillSubType,HReportType,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationInterID," +
"HRelationEntryID,HRelationBillNo,HMaker,HMakeDate)" +
"values(" +
"'" + omodel.HBarCode +
@@ -139,6 +140,7 @@
"," + omodel.HPRDORGID +
"," + omodel.HAuxPropID +
",'" + BillType +
+ "','" + "" +
"'," + omodel.HReportType +
"," + omodel.HSourceInterID +
"," + omodel.HSourceEntryID +
@@ -197,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