yl
2022-07-16 4545b915123fb7b7535b697f6e82b12f525f8b71
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web;
using System.Web.Http;
using VueWebApi.DLL.BLL;
using VueWebApi.Models;
using VueWebApi.Tools;
 
namespace VueWebApi.Controllers
{
    [RoutePrefix(prefix: "api/DeviceManager")]
    [ControllerGroup("设备管理", "在线接口")]
    public class DeviceManagerController : ApiController
    {
        //定义全局信息返回变量
        ToMessage mes = new ToMessage();
        RedisHelper redis = new RedisHelper();
 
        #region[设备类型查询]
        /// <summary>
        /// 设备类型查询
        /// </summary>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "DeviceTypeSearch")]
        [HttpGet]
        public HttpResponseMessage DeviceTypeSearch(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.DeviceTypeSearch(startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion
 
        #region[设备类型新增]
        /// <summary>
        /// 设备类型新增
        /// </summary>
        /// <param name="json">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateDeviceType")]
        [HttpPost]
        public HttpResponseMessage AddUpdateDeviceType(List<ObjectDataCont> json)
        {
            var username = HttpContext.Current.Request.Cookies["admin"].Value.ToString();
            mes = DeviceManagerBLL.AddUpdateDeviceType(json, username);
            return TJson.toJson(mes);
        }
        #endregion
 
        #region[设备类型删除]
        /// <summary>
        /// 设备类型删除
        /// </summary>
        /// <param name="devicetypecode">设备类型编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceType")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceType(string devicetypecode)
        {
            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>
        /// 设备清单查询
        /// </summary>
        /// <param name="DeviceCode">设备编码</param>
        /// <param name="DeviceName">设备名称</param>
        /// <param name="Status">使用状态</param>
        /// <param name="WorkShop">所属车间</param>
        /// <param name="DeviceType">设备类型</param>
        /// <param name="DeviceGroup">设备组</param>
        /// <param name="page">页码</param>
        /// <param name="rows">每页显示条数</param>
        /// <param name="prop">排序字段</param>
        /// <param name="order">排序规则</param>
        /// <returns></returns>
        [Route(template: "DeviceMangerSearch")]
        [HttpGet]
        public HttpResponseMessage DeviceMangerSearch(string DeviceCode = null, string DeviceName = null, string Status = null, string WorkShop = null,string DeviceType=null,string DeviceGroup=null,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.DeviceMangerSearch(DeviceCode, DeviceName, Status, WorkShop, DeviceType, DeviceGroup, startNum, endNum, prop, order);
            return TJson.toJson(mes);
        }
        #endregion
 
        #region[设备清单新增编辑]
        /// <summary>
        /// 设备清单新增编辑
        /// </summary>
        /// <param name="obj">提交数据对象</param>
        /// <returns></returns>
        [Route(template: "AddUpdateDeviceManger")]
        [HttpPost]
        public HttpResponseMessage AddUpdateDeviceManger([FromBody] JObject obj)
        {
            string deviceid = obj["id"].ToString();    //设备清单id(主键)
            string devicecode = obj["devicecode"].ToString(); //设备编码
            string devicename = obj["devicename"].ToString(); //设备名称
            string devicetype = obj["devicetypecode"].ToString(); //设备类型编码
            string devicegroup = obj["devicegroupcode"].ToString(); //设备组编码
            string importdate = obj["importdate"].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["admin"].Value.ToString();
            string OperType = obj["OperType"].ToString();  //操作类型
            mes = DeviceManagerBLL.AddUpdateDeviceManger(deviceid, devicecode, devicename, devicetype, devicegroup, importdate, workshop, linecode, status, ratio, usercode, OperType);
            return TJson.toJson(mes);
        }
        #endregion
 
        #region[设备清单删除]
        /// <summary>
        /// 设备清单删除
        /// </summary>
        /// <param name="devicecode">设备编码</param>
        /// <returns></returns>
        [Route(template: "DeleteDeviceManger")]
        [HttpPost]
        public HttpResponseMessage DeleteDeviceManger(string devicecode)
        {
            mes = DeviceManagerBLL.DeleteDeviceManger(devicecode);
            return TJson.toJson(mes);
        }
        #endregion
 
    }
}