From dfcab5f73b1f07e63ca9483d457bcfddccc95bf3 Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 10 十月 2024 14:27:44 +0800
Subject: [PATCH] 班组列表返回数据调用方法修改,增加根据用户过滤显示班组;PDA模块所调用的班组返回数据方法新增
---
DAL/车间管理/ClsSc_WorkBeginDotCheckBillMain.cs | 34 +++++++++++++++++++---------------
1 files changed, 19 insertions(+), 15 deletions(-)
diff --git "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs" "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
index 06f8557..f0926b9 100644
--- "a/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
+++ "b/DAL/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_WorkBeginDotCheckBillMain.cs"
@@ -71,20 +71,22 @@
foreach (Model.ClsSc_WorkBeginDotCheckBillSub oSub in DetailColl)
{
string subSql = "insert into Sc_WorkBeginDotCheckBillSub " +
- "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
- ",HCheckNoteItemID,HCheckPostID,HCheckResult) " +
- " values(" +
- "" + omodel.HInterID.ToString() +
- "," + oSub.HEntryID.ToString() +
- "," + oSub.HSourceInterID +
- "," + oSub.HSourceEntryID +
- ",'" + oSub.HSourceBillNo +
- "','" + oSub.HSourceBillType +
- "','" + oSub.HRemark +
- "','" + oSub.HCheckNoteItemID +
- "','" + oSub.HCheckPostID +
- "','" + oSub.HCheckResult +
- "')";
+ "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
+ ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " +
+ " values(" +
+ "" + omodel.HInterID.ToString() +
+ "," + oSub.HEntryID.ToString() +
+ "," + oSub.HSourceInterID +
+ "," + oSub.HSourceEntryID +
+ ",'" + oSub.HSourceBillNo +
+ "','" + oSub.HSourceBillType +
+ "','" + oSub.HRemark +
+ "','" + oSub.HCheckNoteItemID +
+ "','" + oSub.HCheckPostID +
+ "','" + oSub.HCheckResult +
+ "','" + oSub.HDotCheckType +
+ "','" + oSub.HRelationID +
+ "')";
oCn.RunProc(subSql);
}
@@ -161,7 +163,7 @@
{
string subSql = "insert into Sc_WorkBeginDotCheckBillSub " +
"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRemark" +
- ",HCheckNoteItemID,HCheckPostID,HCheckResult) " +
+ ",HCheckNoteItemID,HCheckPostID,HCheckResult,HDotCheckType,HRelationID) " +
" values(" +
"" + omodel.HInterID.ToString() +
"," + oSub.HEntryID.ToString() +
@@ -173,6 +175,8 @@
"','" + oSub.HCheckNoteItemID +
"','" + oSub.HCheckPostID +
"','" + oSub.HCheckResult +
+ "','" + oSub.HDotCheckType +
+ "','" + oSub.HRelationID +
"')";
oCn.RunProc(subSql);
}
--
Gitblit v1.9.1