From 7929f99e3096841a73197b8f61b9c3091db48823 Mon Sep 17 00:00:00 2001
From: ouyangqing <ouyangqing@DESKTOP-B85SG1D>
Date: 星期一, 25 一月 2021 14:07:04 +0800
Subject: [PATCH] nothing
---
SCM/报表/Qk_OutProcessList.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git "a/SCM/\346\212\245\350\241\250/Qk_OutProcessList.cs" "b/SCM/\346\212\245\350\241\250/Qk_OutProcessList.cs"
index ae23e49..93245e7 100644
--- "a/SCM/\346\212\245\350\241\250/Qk_OutProcessList.cs"
+++ "b/SCM/\346\212\245\350\241\250/Qk_OutProcessList.cs"
@@ -62,7 +62,7 @@
strBuilder.Append(" and b.HName like '%" + textBox2.Text + "%' ");
if (!string.IsNullOrEmpty(textBox3.Text))
strBuilder.Append(" and d.HName like '%" + textBox3.Text + "%' ");
- var execSql = "select min(a.HDate) 璧峰鏃堕棿,max(a.HDate) 鎴嚦鏃堕棿,b.HName 宸ュ簭鍚嶇О,c.HName 鐝粍鍚嶇О,d.HName 姹囨姤浜�,sum(a.HQty) 鍚堣姹囨姤鏁伴噺,sum(b.HFixPrice * a.HQty ) 鍚堣宸ヨ祫" +
+ var execSql = "select min(a.HDate) 璧峰鏃堕棿,max(a.HDate) 鎴嚦鏃堕棿,b.HName 宸ュ簭鍚嶇О,c.HName 鐝粍鍚嶇О,d.HName 姹囨姤浜�,convert(decimal(18,2), sum(a.HQty)) 鍚堣姹囨姤鏁伴噺,convert(decimal(18,2),sum(b.HFixPrice * a.HQty )) 鍚堣宸ヨ祫 " +
" from Sc_StationOutBillMain a left join Gy_Process b on a.HProcID = b.HItemID Left join Gy_Group c on a.HGroupID = c.HItemID left join Gy_Employee d on a.HEmpID = d.HItemID " +
"where 1=1 " + strBuilder.ToString() + " group by b.HName,c.HName,d.HName";
DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
--
Gitblit v1.9.1