From 4b0a1f01a9d67ca51765a39ac24cfbafaed4c4c9 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 12 三月 2021 13:34:55 +0800
Subject: [PATCH] 用于上查打开界面的通用插件（表单插件）
---
src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 9 +++++++--
1 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index e3c684b..cfc5ebd 100644
--- a/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -173,9 +173,14 @@
sqlList.Add(sql);
sql = $"truncate table Sc_WorkBillSubXnqt";
sqlList.Add(sql);
- sql = $"insert into Sc_WorkBillMainXnqt select * from Sc_WorkBillSortBillMain";
+ string columnName = DBServiceHelper.ExecuteScalar<string>(Context, "/*dialect*/ select stuff((select ',' + name from syscolumns Where id = object_Id('Sc_WorkBillMainXnqt') for xml path('')),1,1,'') as name ", "");
+ sql = $"insert into Sc_WorkBillMainXnqt({columnName}) select {columnName} from Sc_WorkBillSortBillMain";
+ LogHelper.Info("娴嬭瘯1锛�"+sql);
sqlList.Add(sql);
- sql = $"insert into Sc_WorkBillSubXnqt select * from Sc_WorkBillSortBillSub";
+ columnName = DBServiceHelper.ExecuteScalar<string>(Context, "/*dialect*/ select stuff((select ',' + name from syscolumns Where id = object_Id('Sc_WorkBillSubXnqt') for xml path('')),1,1,'') as name ", "");
+ sql = $"insert into Sc_WorkBillSubXnqt({columnName}) select {columnName} from Sc_WorkBillSortBillSub";
+ LogHelper.Info("娴嬭瘯1锛�" + sql);
+
sqlList.Add(sql);
sql = $"update Sc_WorkBillSubXnqt set FComplete=''";
sqlList.Add(sql);
--
Gitblit v1.9.1