From a77971157668faab57170e93f4e54c6ef7953da5 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 16 八月 2022 18:18:13 +0800
Subject: [PATCH] 维护

---
 WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs |   19 ++++++++++++++++---
 1 files changed, 16 insertions(+), 3 deletions(-)

diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
index 9992ce8..a12cc8c 100644
--- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
+++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs
@@ -7,6 +7,7 @@
 using System.Net;
 using System.Net.Http;
 using System.Web.Http;
+using ViewAPI;
 using WebAPI.Models;
 
 namespace WebAPI.Controllers.MJGL
@@ -28,6 +29,7 @@
         {
             try
             {
+                Log.LogInfo("鎴愬姛锛�"); //璁板綍鎻愪氦鏁版嵁
                 //缂栬緫鏉冮檺
                 if (!DBUtility.ClsPub.Security_Log_second("Sc_MouldProdInBillList", 1, false, user))
                 {
@@ -37,7 +39,7 @@
                     objJsonResult.data = null;
                     return objJsonResult;
                 }
-
+                Log.LogInfo("鏈夋潈闄�");
                 ds = Sc_GetMouldProdInHouseBill(sWhere,Organization);
 
                 //if (ds.Tables[0].Rows.Count != 0 || ds != null)
@@ -69,6 +71,7 @@
 
         public static DataSet Sc_GetMouldProdInHouseBill(string sWhere, string Organization)
         {
+            LogService.Write(sWhere+";"+ Organization);
             string sql1 = string.Format(@"select * from h_v_Sc_MouldProdInHouseBillList where 搴撳瓨缁勭粐='" + Organization + "'");
             if (sWhere == null || sWhere.Equals(""))
             {
@@ -77,6 +80,7 @@
             else
             {
                 string sql = sql1 + sWhere+ "order by hmainid desc";
+                Log.LogInfo(sql);
                 return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldProdInHouseBillList");
             }
         }
@@ -630,8 +634,17 @@
                 }
                 if (bResult)
                 {
-                    string sql = $"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ";
-                    oCn.RunProc(sql);
+                    string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus  'in','{oBill.omodel.HInterID.ToString()}' ");
+                    DataSet db=oCn.RunProcReturn(sql, "h_p_Sc_MouldChangeFileStatus");
+                    if (db.Tables[0].Rows[0]["issuccess"].ToString()=="0")
+                    {
+                        objJsonResult.code = "0";
+                        objJsonResult.count = 0;
+                        objJsonResult.Message = "鍣ㄥ叿浣嶇疆鍚屾澶辫触锛�";
+                        //WebAPIController.Add_Log("閫佽揣鍗曚笅鎺�", UserName, "鐢熸垚閫佽揣鍗�");
+                        objJsonResult.data = 1;
+                        return objJsonResult;
+                    }
                     objJsonResult.code = "0";
                     objJsonResult.count = 1;
                     objJsonResult.Message = "淇濆瓨鎴愬姛锛�";

--
Gitblit v1.9.1