From 36208913c4834ba2d148ff0b14bae64340cecd28 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 04 三月 2024 11:31:33 +0800
Subject: [PATCH] 客户余额查询报表:双击弹窗,显示(销售订单号、物料代码、物料名称、规格型号、数量、发货数量、单价、含税单价、金额、价税合计、占用金额)

---
 DAL/ClsPM_ProjectMoneyBillMain.cs |   12 ++++++------
 1 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/DAL/ClsPM_ProjectMoneyBillMain.cs b/DAL/ClsPM_ProjectMoneyBillMain.cs
index a91a6c8..af86b4d 100644
--- a/DAL/ClsPM_ProjectMoneyBillMain.cs
+++ b/DAL/ClsPM_ProjectMoneyBillMain.cs
@@ -42,16 +42,16 @@
                 string mainSql = "update PM_ProjectMoneyBillMain set " +
                     " HBillNo = '" + omodel.HBillNo +
                      "', HRemark  = '" + omodel.HRemark + 
-                    "', HProNumber  = '" + omodel.HProNumber +
                      "', HProjectID  = '" + omodel.HProjectID +
-                    "', HProNumber   = " + omodel.HProNumber+
-                    ", HProName  = " + omodel.HProName +
-                    ", HCusID  = '" + omodel.HCusID +
+                    "', HProNumber   = '" + omodel.HProNumber+
+                    "', HProName  = '" + omodel.HProName +
+                    "', HCusID  = '" + omodel.HCusID +
                      "', HPMTeamID  = '" + omodel.HPMTeamID +
                     "', HPMEmpID = '" + omodel.HPMEmpID +
                     "', HWorkEmpID  = '" + omodel.HWorkEmpID +
                      "', HManagerID  = '" + omodel.HManagerID +
                     "', HOrgID  ='" + omodel.HOrgID +
+                    "', HUpDater = '" + omodel.HUpDater +
                     "', HUpDateDate = getdate()" +
                     //===============================================================
 
@@ -142,8 +142,8 @@
                     "','" + omodel.HMakeDate +
                     "','" + omodel.HProjectID +
                     "','" + omodel.HProNumber +
-                    "'," + omodel.HProName+
-                    ",'" + omodel.HCusID+
+                    "','" + omodel.HProName+
+                    "','" + omodel.HCusID+
                     "','" + omodel.HPMTeamID+
                     "','" + omodel.HPMEmpID+
                     "','" + omodel.HWorkEmpID+

--
Gitblit v1.9.1