From f1c258211a7bcc79cb7b86e6007a27afebb24e21 Mon Sep 17 00:00:00 2001
From: 沈泽 <211959439@qq.com>
Date: 星期一, 18 十月 2021 16:23:31 +0800
Subject: [PATCH] 新增工资结算单（集体），工资结算各列表表体的金额能自动按照工时*数量*工价得出总价且能按照所选物料和工序自动填入工价,加入工序流转卡维护拆分功能权限
---
WebAPI/Controllers/BaseSet/Gy_SourceController.cs | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
index 4433f25..a4ee1b4 100644
--- a/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_SourceController.cs
@@ -34,11 +34,11 @@
{
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 绂佺敤鏍囪='' ", "h_v_IF_SourceList");
+ ds = oCN.RunProcReturn("select * from h_v_IF_SourceList where 1=1 ", "h_v_IF_SourceList");
}
else
{
- string sql1 = "select * from h_v_IF_SourceList where 绂佺敤鏍囪='' ";
+ string sql1 = "select * from h_v_IF_SourceList where 1=1 ";
string sql = sql1 + sWhere;
ds = oCN.RunProcReturn(sql, "h_v_IF_SourceList");
}
@@ -131,7 +131,7 @@
}
//鏌ヨ鏁版嵁涓槸鍚﹀瓨鍦ㄩ噸澶嶄唬鐮�
- ds = oCN.RunProcReturn("select * from Gy_Source where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Unit");
+ ds = oCN.RunProcReturn("select * from Gy_Source where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Source");
if (oItem.HNumber.Trim() == "")
{
objJsonResult.code = "0";
@@ -306,7 +306,7 @@
return objJsonResult;
}
oCN.BeginTran();//寮�濮嬩簨鍔�
- ds = oCN.RunProcReturn("select * from Gy_Source where HItemID=" + HItemID, "Gy_Unit");
+ ds = oCN.RunProcReturn("select * from Gy_Source where HItemID=" + HItemID, "Gy_Source");
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
--
Gitblit v1.9.1