From d9bbbbc58972514a003ba372f9ff10ca88def338 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 15 十月 2022 14:21:50 +0800
Subject: [PATCH] 设备维修记录

---
 VueWebApi/Controllers/DeviceManagerController.cs |  792 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 772 insertions(+), 20 deletions(-)

diff --git a/VueWebApi/Controllers/DeviceManagerController.cs b/VueWebApi/Controllers/DeviceManagerController.cs
index bd92ed0..4fcf61c 100644
--- a/VueWebApi/Controllers/DeviceManagerController.cs
+++ b/VueWebApi/Controllers/DeviceManagerController.cs
@@ -7,12 +7,14 @@
 using System.Web;
 using System.Web.Http;
 using VueWebApi.DLL.BLL;
+using VueWebApi.Models;
 using VueWebApi.Tools;
 
 namespace VueWebApi.Controllers
 {
-    [RoutePrefix(prefix: "api/BasicSetting")]
+    [RoutePrefix(prefix: "api/DeviceManager")]
     [ControllerGroup("璁惧绠$悊", "鍦ㄧ嚎鎺ュ彛")]
+    [ChannelActionFilter]
     public class DeviceManagerController : ApiController
     {
         //瀹氫箟鍏ㄥ眬淇℃伅杩斿洖鍙橀噺
@@ -43,18 +45,14 @@
         /// <summary>
         /// 璁惧绫诲瀷鏂板
         /// </summary>
-        /// <param name="obj">鎻愪氦鏁版嵁瀵硅薄</param>
+        /// <param name="json">鎻愪氦鏁版嵁瀵硅薄</param>
         /// <returns></returns>
         [Route(template: "AddUpdateDeviceType")]
         [HttpPost]
-        public HttpResponseMessage AddUpdateDeviceType([FromBody] JObject obj)
+        public HttpResponseMessage AddUpdateDeviceType(List<ObjectDataCont> json)
         {
-            //string deviceid = obj["id"].ToString();    //璁惧绫诲瀷id(涓婚敭)
-            string devicetypecode = obj["devicetypecode"].ToString(); //璁惧绫诲瀷缂栫爜
-            string devicetypename = obj["devicetypename"].ToString(); //璁惧绫诲瀷鍚嶇О
-            string devicetypedescipt = obj["devicetypedescipt"].ToString(); //璁惧绫诲瀷鎻忚堪
-            var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
-            mes = DeviceManagerBLL.AddUpdateDeviceType(devicetypecode, devicetypename, devicetypedescipt, usercode);
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
+            mes = DeviceManagerBLL.AddUpdateDeviceType(json, username);
             return TJson.toJson(mes);
         }
         #endregion
@@ -63,18 +61,144 @@
         /// <summary>
         /// 璁惧绫诲瀷鍒犻櫎
         /// </summary>
-        /// <param name="devicetypeid">璁惧绫诲瀷ID</param>
+        /// <param name="devicetypecode">璁惧绫诲瀷缂栫爜</param>
         /// <returns></returns>
         [Route(template: "DeleteDeviceType")]
         [HttpPost]
-        public HttpResponseMessage DeleteDeviceType(string devicetypeid)
+        public HttpResponseMessage DeleteDeviceType(string devicetypecode)
         {
-            mes = DeviceManagerBLL.DeleteDeviceType(devicetypeid);
+            mes = DeviceManagerBLL.DeleteDeviceType(devicetypecode);
             return TJson.toJson(mes);
         }
         #endregion
 
 
+        #region[璁惧绫诲瀷涓嬫媺妗嗘帴鍙
+        /// <summary>
+        /// 璁惧绫诲瀷涓嬫媺妗嗘帴鍙�
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "DeviceTypeSelect")]
+        [HttpGet]
+        public HttpResponseMessage DeviceTypeSelect()
+        {
+            try
+            {
+                mes = DeviceManagerBLL.DeviceTypeSelect();
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.Message = e.Message;
+            }
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧缁勬煡璇
+        /// <summary>
+        /// 璁惧缁勬煡璇�
+        /// </summary>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceGroupSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceGroupSearch(int page = 0, int rows = 0, string prop = null, string order = null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceGroupSearch(startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧缁勬柊澧瀅
+        /// <summary>
+        /// 璁惧缁勬柊澧�
+        /// </summary>
+        /// <param name="json">鎻愪氦鏁版嵁瀵硅薄</param>
+        /// <returns></returns>
+        [Route(template: "AddUpdateDeviceGroup")]
+        [HttpPost]
+        public HttpResponseMessage AddUpdateDeviceGroup(List<ObjectDataCont> json)
+        {
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
+            mes = DeviceManagerBLL.AddUpdateDeviceGroup(json, username);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧缁勫垹闄
+        /// <summary>
+        /// 璁惧缁勫垹闄�
+        /// </summary>
+        /// <param name="devicegroupcode">璁惧缁勭紪鐮�</param>
+        /// <returns></returns>
+        [Route(template: "DeleteDeviceGroup")]
+        [HttpPost]
+        public HttpResponseMessage DeleteDeviceGroup(string devicegroupcode)
+        {
+            mes = DeviceManagerBLL.DeleteDeviceGroup(devicegroupcode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+        #region[璁惧绫诲瀷鏌ユ壘璁惧缁刔
+        /// <summary>
+        /// 璁惧绫诲瀷鏌ユ壘璁惧缁�
+        /// </summary>
+        /// <param name="eqptypecode">璁惧绫诲瀷缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeviceTypeSelectGroup")]
+        [HttpGet]
+        public HttpResponseMessage DeviceTypeSelectGroup(string eqptypecode)
+        {
+            try
+            {
+                mes = DeviceManagerBLL.DeviceTypeSelectGroup(eqptypecode);
+            }
+            catch (Exception e)
+            {
+                mes.code = "300";
+                mes.Message = e.Message;
+            }
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[鎵�灞炶溅闂翠笅鎷夋帴鍙
+        /// <summary>
+        /// 鎵�灞炶溅闂翠笅鎷夋帴鍙�
+        /// </summary>
+        /// <returns></returns>
+
+        [Route(template: "WorkShopSelect")]
+        [HttpGet]
+        public HttpResponseMessage WorkShopSelect()
+        {
+            mes = DeviceManagerBLL.WorkShopSelect();
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[鎵�灞炶溅闂存煡鎵炬墍灞炰骇绾挎帴鍙
+        /// <summary>
+        /// 鎵�灞炶溅闂存煡鎵炬墍灞炰骇绾挎帴鍙�
+        /// </summary>
+        /// <param name="workshopcode">杞﹂棿缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "WorkShopSelectLine")]
+        [HttpGet]
+        public HttpResponseMessage WorkShopSelectLine(string workshopcode)
+        {
+            mes = DeviceManagerBLL.WorkShopSelectLine(workshopcode);
+            return TJson.toJson(mes);
+        }
+        #endregion
 
         #region[璁惧娓呭崟鏌ヨ]
         /// <summary>
@@ -115,15 +239,16 @@
             string deviceid = obj["id"].ToString();    //璁惧娓呭崟id(涓婚敭)
             string devicecode = obj["devicecode"].ToString(); //璁惧缂栫爜
             string devicename = obj["devicename"].ToString(); //璁惧鍚嶇О
-            string devicetype = obj["devicetype"].ToString(); //璁惧绫诲瀷
-            string devicegroup = obj["devicegroup"].ToString(); //璁惧缁�
+            string devicetype = obj["devicetypecode"].ToString(); //璁惧绫诲瀷缂栫爜
+            string devicegroup = obj["devicegroupcode"].ToString(); //璁惧缁勭紪鐮�
             string importdate = obj["importdate"].ToString(); //鎶曞叆鏃ユ湡
-            string workshop = obj["workshop"].ToString(); //鎵�灞炶溅闂�
+            string workshop = obj["workshopcode"].ToString(); //鎵�灞炶溅闂寸紪鐮�
+            string linecode = obj["linecode"].ToString(); //鎵�灞炰骇绾跨紪鐮�
             string status = obj["status"].ToString(); //浣跨敤鐘舵��
             string ratio = obj["ratio"].ToString(); //绋煎姩鐜�
-            var usercode = HttpContext.Current.Request.Cookies["navTabId"].Value.ToString();
+            var usercode = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
             string OperType = obj["OperType"].ToString();  //鎿嶄綔绫诲瀷
-            mes = DeviceManagerBLL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, status, ratio, usercode, OperType);
+            mes = DeviceManagerBLL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, linecode, status, ratio, usercode, OperType);
             return TJson.toJson(mes);
         }
         #endregion
@@ -132,13 +257,640 @@
         /// <summary>
         /// 璁惧娓呭崟鍒犻櫎
         /// </summary>
-        /// <param name="deviceid">璁惧ID</param>
+        /// <param name="devicecode">璁惧缂栫爜</param>
         /// <returns></returns>
         [Route(template: "DeleteDeviceManger")]
         [HttpPost]
-        public HttpResponseMessage DeleteDeviceManger(string deviceid)
+        public HttpResponseMessage DeleteDeviceManger(string devicecode)
         {
-            mes = DeviceManagerBLL.DeleteDeviceManger(deviceid);
+            mes = DeviceManagerBLL.DeleteDeviceManger(devicecode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+
+        #region[璁惧鐐规椤瑰垪琛ㄦ煡璇
+        /// <summary>
+        /// 璁惧鐐规椤瑰垪琛ㄦ煡璇�
+        /// </summary>
+        /// <param name="checkitemcode">鐐规閮ㄤ綅缂栫爜</param>
+        /// <param name="checkitemname">鐐规閮ㄤ綅鍚嶇О</param>
+        /// <param name="checkdescr">鐐规瑕佹眰</param>
+        /// <param name="isqrcode">閫変腑鎵爜</param>
+        /// <param name="cycle">鐐规鍛ㄦ湡</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckItemSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckItemSearch(int page, int rows, string prop,string order,string checkitemcode = null, string checkitemname = null, string checkdescr = null, string isqrcode = null,string cycle=null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceCheckItemSearch(checkitemcode, checkitemname, checkdescr, isqrcode, cycle, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规椤规柊澧炵紪杈慮
+        /// <summary>
+        /// 璁惧鐐规椤规柊澧炵紪杈�
+        /// </summary>
+        /// <param name="obj">鎻愪氦鏁版嵁瀵硅薄</param>
+        /// <returns></returns>
+        [Route(template: "AddUpdateDeviceCheckItem")]
+        [HttpPost]
+        public HttpResponseMessage AddUpdateDeviceCheckItem([FromBody] JObject obj)
+        {
+            string checkitemid = obj["id"].ToString();    //璁惧鐐规椤筰d(涓婚敭)
+            string checkitemcode = obj["checkitemcode"].ToString(); //璁惧鐐规閮ㄤ綅缂栫爜
+            string checkitemname = obj["checkitemname"].ToString(); //璁惧鐐规閮ㄤ綅鍚嶇О
+            string checkitemdescr = obj["checkitemdescr"].ToString(); //璁惧鐐规閮ㄤ綅瑕佹眰
+            string cycle = obj["cycle"].ToString(); //璁惧鐐规閮ㄤ綅鍛ㄦ湡
+            string isqrcode = obj["isqrcode"].ToString(); //鏄惁鎵爜
+            var usercode = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); 
+            string OperType = obj["OperType"].ToString();  //鎿嶄綔绫诲瀷
+            mes = DeviceManagerBLL.AddUpdateDeviceCheckItem(checkitemid, checkitemcode, checkitemname, checkitemdescr, cycle, isqrcode, usercode, OperType);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规椤瑰垹闄
+        /// <summary>
+        /// 璁惧鐐规椤瑰垹闄�
+        /// </summary>
+        /// <param name="checkitemcode">璁惧鐐规椤圭洰(閮ㄤ綅)缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeleteDeviceCheckItem")]
+        [HttpPost]
+        public HttpResponseMessage DeleteDeviceCheckItem(string checkitemcode)
+        {
+            mes = DeviceManagerBLL.DeleteDeviceCheckItem(checkitemcode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+
+        #region[璁惧淇濆吇椤瑰垪琛ㄦ煡璇
+        /// <summary>
+        /// 璁惧淇濆吇椤瑰垪琛ㄦ煡璇�
+        /// </summary>
+        /// <param name="maiitemcode">淇濆吇閮ㄤ綅缂栫爜</param>
+        /// <param name="maiitemname">淇濆吇閮ㄤ綅鍚嶇О</param>
+        /// <param name="maidescr">淇濆吇瑕佹眰</param>
+        /// <param name="isqrcode">閫変腑鎵爜</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceMaiItemSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceMaiItemSearch(int page, int rows, string prop, string order,string maiitemcode = null, string maiitemname = null, string maidescr = null, string isqrcode = null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceMaiItemSearch(maiitemcode, maiitemname, maidescr, isqrcode, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇椤规柊澧炵紪杈慮
+        /// <summary>
+        /// 璁惧淇濆吇椤规柊澧炵紪杈�
+        /// </summary>
+        /// <param name="obj">鎻愪氦鏁版嵁瀵硅薄</param>
+        /// <returns></returns>
+        [Route(template: "AddUpdateDeviceMaiItem")]
+        [HttpPost]
+        public HttpResponseMessage AddUpdateDeviceMaiItem([FromBody] JObject obj)
+        {
+            string maiitemid = obj["id"].ToString();    //璁惧淇濆吇椤筰d(涓婚敭)
+            string maiitemcode = obj["maiitemcode"].ToString(); //璁惧淇濆吇閮ㄤ綅缂栫爜
+            string maiitemname = obj["maiitemname"].ToString(); //璁惧淇濆吇閮ㄤ綅鍚嶇О
+            string maiitemdescr = obj["maiitemdescr"].ToString(); //璁惧淇濆吇閮ㄤ綅瑕佹眰
+            string isqrcode = obj["isqrcode"].ToString(); //鏄惁鎵爜
+            var usercode = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
+            string OperType = obj["OperType"].ToString();  //鎿嶄綔绫诲瀷
+            mes = DeviceManagerBLL.AddUpdateDeviceMaiItem(maiitemid, maiitemcode, maiitemname, maiitemdescr, isqrcode, usercode, OperType);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇椤瑰垹闄
+        /// <summary>
+        /// 璁惧淇濆吇椤瑰垹闄�
+        /// </summary>
+        /// <param name="maiitemcode">璁惧淇濆吇椤圭洰(閮ㄤ綅)缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeleteDeviceMaiItem")]
+        [HttpPost]
+        public HttpResponseMessage DeleteDeviceMaiItem(string maiitemcode)
+        {
+            mes = DeviceManagerBLL.DeleteDeviceMaiItem(maiitemcode);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+        #region[璁惧鐐规鏍囧噯鍒楄〃鏌ヨ]
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鍒楄〃鏌ヨ
+        /// </summary>
+        /// <param name="checkstandcode">鐐规鏍囧噯缂栫爜</param>
+        /// <param name="checkstandname">鐐规鏍囧噯鍚嶇О</param>
+        /// <param name="checkcontr">鐐规绠℃帶</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckStandArdSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckStandArdSearch(int page, int rows, string prop, string order,string checkstandcode = null, string checkstandname = null, string checkcontr = null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceCheckStandArdSearch(checkstandcode, checkstandname, checkcontr, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规鏍囧噯鏂板銆佺紪杈戣幏鍙栨楠岄」鐩笅鎷夊垪琛╙
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鏂板銆佺紪杈戣幏鍙栨楠岄」鐩笅鎷夊垪琛�
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckItemSelect")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckItemSelect()
+        {
+            mes = DeviceManagerBLL.DeviceCheckItemSelect();
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规鏍囧噯缂栬緫/鏌ョ湅鑾峰彇鏁版嵁]
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯缂栬緫/鏌ョ湅鑾峰彇鏁版嵁
+        /// </summary>
+        /// <param name="checkstand_code">璁惧鐐规鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "ViewDeviceCheckStanedSearch")]
+        [HttpPost]
+        public HttpResponseMessage ViewDeviceCheckStanedSearch(string checkstand_code)
+        {
+            mes = DeviceManagerBLL.ViewDeviceCheckStanedSearch(checkstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规鏍囧噯鏂板缂栬緫]
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鏂板缂栬緫
+        /// </summary>
+        /// <param name="opertype">鎿嶄綔绫诲瀷</param>
+        /// <param name="json">鎻愪氦鏁版嵁</param>
+        /// <returns></returns>
+        [Route(template: "AddUpdateDeviceCheckStandArd")]
+        [HttpPost]
+        public HttpResponseMessage AddUpdateDeviceCheckStandArd(string opertype, RoutEdit json)
+        {
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //鎿嶄綔浜哄憳
+            mes = DeviceManagerBLL.AddUpdateDeviceCheckStandArd(opertype, json, username);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规鏍囧噯鍒犻櫎]
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鍒犻櫎
+        /// </summary>
+        /// <param name="checkstand_code">璁惧鐐规鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeleteDeviceCheckStaned")]
+        [HttpPost]
+        public HttpResponseMessage DeleteDeviceCheckStaned(string checkstand_code)
+        {
+            mes = DeviceManagerBLL.DeleteDeviceCheckStaned(checkstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规鏍囧噯鍏宠仈宸ヤ綔绔欐煡璇
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鍏宠仈宸ヤ綔绔欐煡璇�
+        /// </summary>
+        /// <param name="checkstand_code">璁惧鐐规鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckStanedAssociationEqp")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckStanedAssociationEqp(string checkstand_code)
+        {
+            mes = DeviceManagerBLL.DeviceCheckStanedAssociationEqp(checkstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region [璁惧鐐规鏍囧噯鍏宠仈宸ヤ綔绔欐彁浜
+        /// <summary>
+        /// 璁惧鐐规鏍囧噯鍏宠仈宸ヤ綔绔欐彁浜�
+        /// </summary>
+        /// <param name="checkstand_code">璁惧鐐规鏍囧噯缂栫爜</param>
+        /// <param name="json">鎻愪氦鏁版嵁</param>
+        /// <returns></returns>
+        [Route(template: "SaveDeviceCheckStanedAssociationEqp")]
+        [HttpPost]
+        public HttpResponseMessage SaveDeviceCheckStanedAssociationEqp(string checkstand_code, List<ObjectData> json)
+        {
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //鎿嶄綔浜哄憳
+            mes = DeviceManagerBLL.SaveDeviceCheckStanedAssociationEqp(checkstand_code, username, json);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+
+        #region[璁惧淇濆吇鏍囧噯鍒楄〃鏌ヨ]
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鍒楄〃鏌ヨ
+        /// </summary>
+        /// <param name="repairstandcode">淇濆吇鏍囧噯缂栫爜</param>
+        /// <param name="repairstandname">淇濆吇鏍囧噯鍚嶇О</param>
+        /// <param name="repairstanddescr">淇濆吇鏍囧噯鎻忚堪</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairStandArdSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairStandArdSearch(int page, int rows, string prop, string order,string repairstandcode = null, string repairstandname = null, string repairstanddescr = null)
+        {
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceRepairStandArdSearch(repairstandcode, repairstandname, repairstanddescr, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇鏍囧噯鏂板銆佺紪杈戣幏鍙栦繚鍏婚」鐩笅鎷夊垪琛╙
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鏂板銆佺紪杈戣幏鍙栦繚鍏婚」鐩笅鎷夊垪琛�
+        /// </summary>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairItemSelect")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairItemSelect()
+        {
+            mes = DeviceManagerBLL.DeviceRepairItemSelect();
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇鏍囧噯缂栬緫/鏌ョ湅鑾峰彇鏁版嵁]
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯缂栬緫/鏌ョ湅鑾峰彇鏁版嵁
+        /// </summary>
+        /// <param name="repairstand_code">璁惧淇濆吇鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "ViewDeviceRepairStanedSearch")]
+        [HttpPost]
+        public HttpResponseMessage ViewDeviceRepairStanedSearch(string repairstand_code)
+        {
+            mes = DeviceManagerBLL.ViewDeviceRepairStanedSearch(repairstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇鏍囧噯鏂板缂栬緫]
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鏂板缂栬緫
+        /// </summary>
+        /// <param name="opertype">鎿嶄綔绫诲瀷</param>
+        /// <param name="json">鎻愪氦鏁版嵁</param>
+        /// <returns></returns>
+        [Route(template: "AddUpdateDeviceRepairStandArd")]
+        [HttpPost]
+        public HttpResponseMessage AddUpdateDeviceRepairStandArd(string opertype, EqpRepair json)
+        {
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //鎿嶄綔浜哄憳
+            mes = DeviceManagerBLL.AddUpdateDeviceRepairStandArd(opertype, json, username);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇鏍囧噯鍒犻櫎]
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鍒犻櫎
+        /// </summary>
+        /// <param name="repairstand_code">璁惧淇濆吇鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeleteDeviceRepairStaned")]
+        [HttpPost]
+        public HttpResponseMessage DeleteDeviceRepairStaned(string repairstand_code)
+        {
+            mes = DeviceManagerBLL.DeleteDeviceRepairStaned(repairstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇鏍囧噯鍏宠仈宸ヤ綔绔欐煡璇
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鍏宠仈宸ヤ綔绔欐煡璇�
+        /// </summary>
+        /// <param name="repairstand_code">璁惧淇濆吇鏍囧噯缂栫爜</param>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairStanedAssociationEqp")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairStanedAssociationEqp(string repairstand_code)
+        {
+            mes = DeviceManagerBLL.DeviceRepairStanedAssociationEqp(repairstand_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region [璁惧淇濆吇鏍囧噯鍏宠仈宸ヤ綔绔欐彁浜
+        /// <summary>
+        /// 璁惧淇濆吇鏍囧噯鍏宠仈宸ヤ綔绔欐彁浜�
+        /// </summary>
+        /// <param name="repairstand_code">璁惧淇濆吇鏍囧噯缂栫爜</param>
+        /// <param name="json">鎻愪氦鏁版嵁</param>
+        /// <returns></returns>
+        [Route(template: "SaveDeviceRepairStanedAssociationEqp")]
+        [HttpPost]
+        public HttpResponseMessage SaveDeviceRepairStanedAssociationEqp(string repairstand_code, List<ObjectData> json)
+        {
+            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //鎿嶄綔浜哄憳
+            mes = DeviceManagerBLL.SaveDeviceRepairStanedAssociationEqp(repairstand_code, username, json);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+        #region[璁惧鐐规璁板綍鏌ヨ]
+        /// <summary>
+        /// 璁惧鐐规璁板綍鏌ヨ
+        /// </summary>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栧彿</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="stanedname">鏍囧噯鍚嶇О</param>
+        /// <param name="checkuser">鐐规浜哄憳</param>
+        /// <param name="checkdate">鐐规鏃堕棿</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckTakeSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckTakeSearch(int page, int rows, string prop, string order, string wkshopcode = null, string eqpcode = null, string eqpname = null,string stanedname=null,string checkuser=null,string checkdate=null)
+        {
+            string checkopendate = "";  //鐐规寮�濮嬫椂闂�
+            string checkclosedate = "";    //鐐规缁撴潫鏃堕棿
+            if (checkdate != "" && checkdate != null)
+            {
+                checkopendate = checkdate.Split('~')[0].ToString();
+                checkclosedate = checkdate.Split('~')[1].ToString();
+            }
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceCheckTakeSearch(wkshopcode, eqpcode, eqpname, stanedname, checkuser, checkopendate, checkclosedate, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规璁板綍鏄庣粏鏌ヨ]
+        /// <summary>
+        /// 璁惧鐐规璁板綍鏄庣粏鏌ヨ
+        /// </summary>
+        /// <param name="djwo">璁惧鐐规鍗曞彿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckSubTakeSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckSubTakeSearch(string djwo)
+        {
+            mes = DeviceManagerBLL.DeviceCheckSubTakeSearch(djwo);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧鐐规璁板綍瀵煎嚭]
+        /// <summary>
+        /// 璁惧鐐规璁板綍瀵煎嚭
+        /// </summary>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栧彿</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="stanedname">鏍囧噯鍚嶇О</param>
+        /// <param name="checkuser">鐐规浜哄憳</param>
+        /// <param name="checkdate">鐐规鏃堕棿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceCheckTakeOutExcel")]
+        [HttpGet]
+        public HttpResponseMessage DeviceCheckTakeOutExcel(string wkshopcode = null, string eqpcode = null, string eqpname = null, string stanedname = null, string checkuser = null, string checkdate = null)
+        {
+            string checkopendate = "";  //鐐规寮�濮嬫椂闂�
+            string checkclosedate = "";    //鐐规缁撴潫鏃堕棿
+            if (checkdate != "" && checkdate != null)
+            {
+                checkopendate = checkdate.Split('~')[0].ToString();
+                checkclosedate = checkdate.Split('~')[1].ToString();
+            }
+            mes = DeviceManagerBLL.DeviceCheckTakeOutExcel(wkshopcode, eqpcode, eqpname, stanedname, checkuser, checkopendate, checkclosedate);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+        #region[璁惧淇濆吇璁板綍鏌ヨ]
+        /// <summary>
+        /// 璁惧淇濆吇璁板綍鏌ヨ
+        /// </summary>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栧彿</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="stanedname">鏍囧噯鍚嶇О</param>
+        /// <param name="repairuser">淇濆吇浜哄憳</param>
+        /// <param name="repairdate">淇濆吇鏃堕棿</param>
+        /// <param name="repairresult">淇濆吇缁撴灉</param>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairTakeSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairTakeSearch(int page, int rows, string prop, string order, string wkshopcode = null, string eqpcode = null, string eqpname = null, string stanedname = null, string repairuser = null, string repairdate = null,string repairresult=null)
+        {
+            string repairopendate = "";  //鐐规寮�濮嬫椂闂�
+            string repairclosedate = "";    //鐐规缁撴潫鏃堕棿
+            if (repairdate != "" && repairdate != null)
+            {
+                repairopendate = repairdate.Split('~')[0].ToString();
+                repairclosedate = repairdate.Split('~')[1].ToString();
+            }
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceRepairTakeSearch(wkshopcode, eqpcode, eqpname, stanedname, repairuser, repairopendate, repairclosedate, repairresult, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇璁板綍鏄庣粏鏌ヨ]
+        /// <summary>
+        /// 璁惧淇濆吇璁板綍鏄庣粏鏌ヨ
+        /// </summary>
+        /// <param name="bywo">璁惧淇濆吇鍗曞彿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairSubTakeSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairSubTakeSearch(string bywo)
+        {
+            mes = DeviceManagerBLL.DeviceRepairSubTakeSearch(bywo);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧淇濆吇璁板綍瀵煎嚭]
+        /// <summary>
+        /// 璁惧淇濆吇璁板綍瀵煎嚭
+        /// </summary>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栧彿</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="stanedname">鏍囧噯鍚嶇О</param>
+        /// <param name="repairuser">淇濆吇浜哄憳</param>
+        /// <param name="repairdate">淇濆吇鏃堕棿</param>
+        /// <param name="repairresult">淇濆吇缁撴灉</param>
+        /// <returns></returns>
+        [Route(template: "DeviceRepairTakeOutExcel")]
+        [HttpGet]
+        public HttpResponseMessage DeviceRepairTakeOutExcel(string wkshopcode = null, string eqpcode = null, string eqpname = null, string stanedname = null, string repairuser = null, string repairdate = null, string repairresult = null)
+        {
+            string repairopendate = "";  //鐐规寮�濮嬫椂闂�
+            string repairclosedate = "";    //鐐规缁撴潫鏃堕棿
+            if (repairdate != "" && repairdate != null)
+            {
+                repairopendate = repairdate.Split('~')[0].ToString();
+                repairclosedate = repairdate.Split('~')[1].ToString();
+            }
+            mes = DeviceManagerBLL.DeviceRepairTakeOutExcel(wkshopcode, eqpcode, eqpname, stanedname, repairuser, repairopendate, repairclosedate, repairresult);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+
+        #region[璁惧缁翠慨璁板綍鏌ヨ]
+        /// <summary>
+        /// 璁惧缁翠慨璁板綍鏌ヨ
+        /// </summary>
+        /// <param name="page">椤电爜</param>
+        /// <param name="rows">姣忛〉鏄剧ず鏉℃暟</param>
+        /// <param name="prop">鎺掑簭瀛楁</param>
+        /// <param name="order">鎺掑簭瑙勫垯</param>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栫爜</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="reportuser">鎶ヤ慨浜哄憳</param>
+        /// <param name="repairuser">缁翠慨浜哄憳</param>
+        /// <param name="vrifcatuser">楠岃瘉浜哄憳</param>
+        /// <param name="reportdate">鎶ヤ慨鏃堕棿</param>
+        /// <param name="repairdate">缁翠慨鏃堕棿</param>
+        /// <param name="vrifcatdate">楠岃瘉鏃堕棿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceUpdateSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceUpdateSearch(int page, int rows, string prop, string order, string wkshopcode = null, string eqpcode = null, string eqpname = null, string reportuser = null, string repairuser = null, string vrifcatuser = null, string reportdate = null, string repairdate = null, string vrifcatdate = null)
+        {
+            string reportopendate = "";  //鎶ヤ慨寮�濮嬫椂闂�
+            string reportclosedate = "";  //鎶ヤ慨缁撴潫鏃堕棿
+            string repairopendate = "";  //缁翠慨寮�濮嬫椂闂�
+            string repairclosedate = "";  //缁翠慨缁撴潫鏃堕棿
+            string vrifcatopendate = "";  //缁翠慨楠岃瘉寮�濮嬫椂闂�
+            string vrifcatclosedate = "";  //缁翠慨楠岃瘉缁撴潫鏃堕棿
+            if (reportdate != "" && reportdate != null)
+            {
+                reportopendate = reportdate.Split('~')[0].ToString();
+                reportclosedate = reportdate.Split('~')[1].ToString();
+            }
+            if (repairdate != "" && repairdate != null)
+            {
+                repairopendate = repairdate.Split('~')[0].ToString();
+                repairclosedate = repairdate.Split('~')[1].ToString();
+            }
+            if (vrifcatdate != "" && vrifcatdate != null)
+            {
+                vrifcatopendate = vrifcatdate.Split('~')[0].ToString();
+                vrifcatclosedate = vrifcatdate.Split('~')[1].ToString();
+            }
+            int startNum = rows * (page - 1) + 1;  //璧峰璁板綍rowNum
+            int endNum = rows * page;   //缁撴潫璁板綍 rowNum
+            mes = DeviceManagerBLL.DeviceUpdateSearch(wkshopcode, eqpcode, eqpname, reportuser, repairuser, vrifcatuser, reportopendate, reportclosedate, repairopendate, repairclosedate, vrifcatopendate, vrifcatclosedate, startNum, endNum, prop, order);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧缁翠慨璁板綍鏄庣粏鏌ヨ]
+        /// <summary>
+        /// 璁惧缁翠慨璁板綍鏄庣粏鏌ヨ
+        /// </summary>
+        /// <param name="repair_code">璁惧缁翠慨鍗曞彿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceUpdateSubSearch")]
+        [HttpGet]
+        public HttpResponseMessage DeviceUpdateSubSearch(string repair_code)
+        {
+            mes = DeviceManagerBLL.DeviceUpdateSubSearch(repair_code);
+            return TJson.toJson(mes);
+        }
+        #endregion
+
+        #region[璁惧缁翠慨璁板綍瀵煎嚭]
+        /// <summary>
+        /// 璁惧缁翠慨璁板綍瀵煎嚭
+        /// </summary>
+        /// <param name="wkshopcode">杞﹂棿缂栫爜</param>
+        /// <param name="eqpcode">璁惧缂栫爜</param>
+        /// <param name="eqpname">璁惧鍚嶇О</param>
+        /// <param name="reportuser">鎶ヤ慨浜哄憳</param>
+        /// <param name="repairuser">缁翠慨浜哄憳</param>
+        /// <param name="vrifcatuser">楠岃瘉浜哄憳</param>
+        /// <param name="reportdate">鎶ヤ慨鏃堕棿</param>
+        /// <param name="repairdate">缁翠慨鏃堕棿</param>
+        /// <param name="vrifcatdate">楠岃瘉鏃堕棿</param>
+        /// <returns></returns>
+        [Route(template: "DeviceUpdateOutExcel")]
+        [HttpGet]
+        public HttpResponseMessage DeviceUpdateOutExcel(string wkshopcode = null, string eqpcode = null, string eqpname = null, string reportuser = null, string repairuser = null, string vrifcatuser = null, string reportdate = null, string repairdate = null, string vrifcatdate = null)
+        {
+            string reportopendate = "";  //鎶ヤ慨寮�濮嬫椂闂�
+            string reportclosedate = "";  //鎶ヤ慨缁撴潫鏃堕棿
+            string repairopendate = "";  //缁翠慨寮�濮嬫椂闂�
+            string repairclosedate = "";  //缁翠慨缁撴潫鏃堕棿
+            string vrifcatopendate = "";  //缁翠慨楠岃瘉寮�濮嬫椂闂�
+            string vrifcatclosedate = "";  //缁翠慨楠岃瘉缁撴潫鏃堕棿
+            if (reportdate != "" && reportdate != null)
+            {
+                reportopendate = reportdate.Split('~')[0].ToString();
+                reportclosedate = reportdate.Split('~')[1].ToString();
+            }
+            if (repairdate != "" && repairdate != null)
+            {
+                repairopendate = repairdate.Split('~')[0].ToString();
+                repairclosedate = repairdate.Split('~')[1].ToString();
+            }
+            if (vrifcatdate != "" && vrifcatdate != null)
+            {
+                vrifcatopendate = vrifcatdate.Split('~')[0].ToString();
+                vrifcatclosedate = vrifcatdate.Split('~')[1].ToString();
+            }
+            mes = DeviceManagerBLL.DeviceUpdateOutExcel(wkshopcode, eqpcode, eqpname, reportuser, repairuser, vrifcatuser, reportopendate, reportclosedate, repairopendate, repairclosedate, vrifcatopendate, vrifcatclosedate);
             return TJson.toJson(mes);
         }
         #endregion

--
Gitblit v1.9.3