From ae84ec6572367dcfb16b63ae22d3119ae2dfbcd7 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 20 十一月 2023 10:52:27 +0800
Subject: [PATCH] 收款单:反审核是判断反审核后余额是否为正,不为则反审核失败

---
 WebAPI/Controllers/WebAPIController.cs |   27 +++++++++++++++++++--------
 1 files changed, 19 insertions(+), 8 deletions(-)

diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs
index 479f3b7..1455b61 100644
--- a/WebAPI/Controllers/WebAPIController.cs
+++ b/WebAPI/Controllers/WebAPIController.cs
@@ -1188,16 +1188,21 @@
         [HttpGet]
         public object GetSupplierList_Json(string Supplier, Int64 HOrgID)
         {
-            sWhere = " Where HStopFlag=0  and HEndFlag=1 and HUSEORGID =" + HOrgID + "";
+            sWhere = " Where HStopFlag=0 and HUSEORGID =" + HOrgID + "";
+            //sWhere = " Where HStopFlag=0  and HEndFlag=1 and HUSEORGID =" + HOrgID + "";
             //sWhere = " Where HStopFlag=0  and HEndFlag=1  and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
-            if (Supplier != "")
+            if (Supplier != "" && Supplier != null)
             {
                 sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + HOrgID + "%' ) ";
+                //sWhere = sWhere + " and ( HNumber like '%" + Supplier + "%' or HName like '%" + Supplier + "%' or HUSEORGID like '%" + HOrgID + "%' ) ";
             }
             try
             {
-                WebS.WebService1 oWeb = new WebS.WebService1();
-                ds = oWeb.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
+                string sql = "select HItemID,HNumber,HName from Gy_Supplier " + sWhere;
+                ds = oCN.RunProcReturn(sql, "Gy_Supplier");
+
+                //WebS.WebService1 oWeb = new WebS.WebService1();
+                //ds = oWeb.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
                 //ds = webserver.GetSupplierList(sWhere, ref DBUtility.ClsPub.sErrInfo);
                 if (ds == null || ds.Tables[0].Rows.Count <= 0)
                 {
@@ -4541,6 +4546,12 @@
                     case "WX":
                         HView = "h_v_Sb_EquipRepairCheckBillList";
                         break;
+                    case "GZ":
+                        HView = "h_v_Sb_EquipConkBookBillList";
+                        break;
+                    case "YS":
+                        HView = "h_v_Sb_EquipRepairCheckBillList";
+                        break;
                     default:
                         objjson.code = "0";
                         objjson.count = 0;
@@ -4550,7 +4561,7 @@
                 }
 
                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
-                string sql = string.Format(@"select * from " + HView + " where 1 = 1 ");
+                string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere);
                 ds = oCN.RunProcReturn(sql, HView);
                 //娣诲姞鍒楀悕
                 foreach (DataColumn col in ds.Tables[0].Columns)
@@ -4561,9 +4572,9 @@
                 }
                 if (ds == null || ds.Tables[0].Rows.Count <= 0)
                 {
-                    objjson.code = "0";
-                    objjson.count = 0;
-                    objjson.Message = "鑾峰彇澶辫触,鏌ユ棤鏁版嵁" + DBUtility.ClsPub.sErrInfo;
+                    objjson.code = "1";
+                    objjson.count = 1;
+                    objjson.Message = "鑾峰彇澶辫触,鏌ユ棤鏁版嵁";
                     objjson.data = null;
                     objjson.list = columnNameList;
                     return objjson;

--
Gitblit v1.9.1