From 66e84e2020f46904d153f201ffd56a33ec6351d4 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 24 十一月 2022 08:39:04 +0800
Subject: [PATCH] nothing

---
 VueWebApi/DLL/DAL/AppDeviceManageDAL.cs |    9 ++++-----
 1 files changed, 4 insertions(+), 5 deletions(-)

diff --git a/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs b/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
index 3a26ff4..3c15a46 100644
--- a/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
+++ b/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
@@ -383,8 +383,8 @@
             var dynamicParams = new DynamicParameters();
             try
             {
-                //鑾峰彇褰撳墠鎵爜璁惧鏄惁鐢宠缁翠慨璁板綍
-                sql = @"select *  from TEqp_RepairRequest where eqp_code=@eqpcode and status='REPA' or status='COMP'";
+                //鑾峰彇褰撳墠鎵爜璁惧鏄惁瀛樺湪宸茬敵璇锋垨宸茬淮淇姸鎬佹暟鎹�
+                sql = @"select *  from TEqp_RepairRequest where eqp_code=@eqpcode and status<>'CONFIR'";
                 dynamicParams.Add("@eqpcode", eqpcode);
                 var data0 = DapperHelper.selectdata(sql, dynamicParams);
                 if (data0.Rows.Count > 0)
@@ -607,7 +607,7 @@
                         string imgPath1 = "", imgPath2 = "", AbsolutePath = "";
                         HttpPostedFile file = files[i];
                         string imgName = DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString();
-                        string keyname = files.AllKeys[i].ToString();
+                        string keyname = files.AllKeys[i].ToString().Substring(0, files.AllKeys[i].ToString().IndexOf(";"));
                         if (keyname == "files1")
                         {
                             imgPath1 = "/DeviceImage/image1/" + imgName + file.FileName;     //閫氳繃姝ゅ璞¤幏鍙栨枃浠跺悕
@@ -618,7 +618,6 @@
                             imgPath2 = "/DeviceImage/image2/" + imgName + file.FileName;     //閫氳繃姝ゅ璞¤幏鍙栨枃浠跺悕
                             AbsolutePath = System.Web.HttpContext.Current.Server.MapPath(imgPath2);
                         }
-
                         file.SaveAs(AbsolutePath); //灏嗕笂浼犵殑涓滆タ淇濆瓨
                                                    //寰幆鍐欑淮淇褰曞搴斿浘鐗囪〃
                         sql = @"insert into  TEqp_RepairImage(source_wo,wo_type,img1url,img2url) 
@@ -1128,7 +1127,7 @@
             try
             {
                 list.Clear();
-                for (int i = 1; i <= json.Count; i++)
+                for (int i = 0; i <json.Count; i++)
                 {
                     string code = json[i].code.ToString();
                     string name = json[i].name.ToString();

--
Gitblit v1.9.3