111
cjs
4 天以前 99004292e20a9e1efa4e3b11b8c319bfd796912c
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
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
using HH.WCS.Mobox3.NFLZ.util;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static HH.WCS.Mobox3.NFLZ.wms.SYSHelper;
 
namespace HH.WCS.Mobox3.NFLZ.wms {
    internal class WCSHelper {
        internal static string GenerateTaskNo() {
            var id = SYSHelper.GetSerialNumber("任务号", "TN");
            var date = DateTime.Now.ToString("yyMMdd");
            return $"TN{date}{id.ToString().PadLeft(4, '0')}";
        }
        internal static bool UpdateStatus(WCSTask task, string status, string S_AGV_NO = "") {
            Console.WriteLine("开始取货");
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            task.S_B_STATE = status;
            if (S_AGV_NO != "")
            {
                task.S_EQ_NO = S_AGV_NO;
            }
            db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE,it.N_B_STATE,it.S_EQ_NO }).ExecuteCommand();
            return res;
        }
        internal static bool UpdatePrioryty(WCSTask task,int Prioryty) {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            task.N_PRIORITY = Prioryty;
            task.T_MODIFY = DateTime.Now;
            db.Updateable(task).UpdateColumns(it => new { it.N_PRIORITY, it.T_MODIFY }).ExecuteCommand();
            return res;
        }
        internal static bool UpdateInfo(WCSTask task, string sourceNo, string endBit, string status) {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            task.S_B_STATE = status;
            task.S_OP_CODE = sourceNo;
            task.S_END_LOC = endBit;
            db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.S_OP_CODE, it.S_END_LOC }).ExecuteCommand();
            return res;
        }
        internal static WCSTask GetTask(string no) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_CODE == no).First();
            return task;
        }
        internal static WCSTask GetTaskBySrcNo(string no) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE == no).First();
            return task;
        }
        internal static List<WCSTask> GetTaskByStart(string bit) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_START_LOC == bit).ToList();
            return task;
        }
        internal static List<WCSTask> GetTaskByEnd(string bit) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_END_LOC== bit).ToList();
            return task;
        }
        internal static List<WCSTask> GetTaskByType(string taskType) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.S_TYPE== taskType).ToList();
        }
        internal static bool CreateTask(string no, string from, string to, string taskType, int pri, string cntrInfo, int cntrCount = 1, int startLayer = 1, int endLayer = 1) {
            var fromLoc = LocationHelper.GetLocation(from);
            var endLoc = LocationHelper.GetLocation(to);
            WCSTask TN_Task = new WCSTask()
            {
                S_CODE = GenerateTaskNo(),
                S_START_AREA = fromLoc.S_AREA_CODE,
                S_END_AREA = endLoc.S_AREA_CODE,
                S_START_LOC = from,
                S_END_LOC = to,
                S_TYPE = taskType,
                S_OP_CODE = no,
                N_PRIORITY = pri,
                N_SCHEDULE_TYPE = 1,
                N_B_STATE = 0,
                S_CNTR_CODE = cntrInfo,
                N_START_LAYER = startLayer,
                N_END_LAYER = endLayer,
                N_CNTR_COUNT = cntrCount
 
            };
 
            return CreateTask(TN_Task);
        }
        internal static bool CheckExist(string no) {
            return GetTask(no) != null;
        }
        internal static bool UpdateStatus(string no, int state) {
            var res = false;
            var db = new SqlHelper<WCSTask>().GetInstance();
            var task = db.Queryable<WCSTask>().Where(a => a.S_CODE== no).First();
            if (task != null) {
                task.N_B_STATE = state;
                task.S_B_STATE = WCSTask.GetStateStr(state);
                //需要判断任务是否失败或者已完成,不允许再修改
                res = db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand() > 0;
            }
            return res;
        }
 
 
 
        internal static bool AddActionRecord(string no, int state, string forkliftNo, string extData) {
            var db = new SqlHelper<TaskAction>().GetInstance();
            var action = new TaskAction()
            {
                N_ACTION_CODE = state,
                S_TASK_CODE = no,
                S_EQ_CODE = forkliftNo,
                S_EQ_TYPE = "agv",
                S_DATA = extData
            };
            return db.Insertable(action).ExecuteCommand() > 0;
        }
        internal static bool CheckActionRecordExist(string no, int code) {
            var db = new SqlHelper<TaskAction>().GetInstance();
            return db.Queryable<TaskAction>().Count(a => a.S_TASK_CODE == no && a.N_ACTION_CODE == code) > 0;
        }
        internal static void Begin(WCSTask task) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (task != null) {
                if (task.N_B_STATE == 1) {
                    task.N_B_STATE = 2;
                    task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                    task.T_START_TIME = DateTime.Now;
                    db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_START_TIME }).ExecuteCommand();
                }
 
            }
        }
        internal static void End(WCSTask task) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (task != null) {
                task.N_B_STATE = 3;
                task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                task.T_END_TIME = DateTime.Now;
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE, it.T_END_TIME }).ExecuteCommand();
            }
        }
        internal static void Fail(WCSTask task) {
            var db = new SqlHelper<WCSTask>().GetInstance();
            if (task != null) {
                //判断有没有取货完成,没有就变成失败。有取货完成默认完成了(跟据项目而定,有些项目人工拉走了也没有放到终点)。
                task.N_B_STATE = 5;
                task.S_B_STATE = WCSTask.GetStateStr(task.N_B_STATE);
                db.Updateable(task).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand();
            }
        }
        internal static bool CreateTask(WCSTask TN_Task) {
            try {
                var db = new SqlHelper<WCSTask>().GetInstance();
                return db.Insertable(TN_Task).ExecuteCommand() > 0;
            }
            catch (Exception ex) {
                Console.WriteLine(ex.Message);
                throw;
            }
 
        }
 
        /// <summary>
        /// 根据任务状态获取任务
        /// </summary>
        /// <param name="state"></param>
        /// <returns></returns>
        internal static List<WCSTask> GetTaskListByState(string status) {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.S_B_STATE== status).ToList();
 
        }
        internal static List<WCSTask> GetTaskListByState(int state) {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == state).ToList();
        }
        internal static List<WCSTask> GetWaitingTaskList() {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).ToList();
        }
 
        internal static void UpdateStorStatus(string S_CNTR_CODE, int v)
        {
            var db = new SqlHelper<object>().GetInstance();
            string s_state = "";
            switch (v) 
            {
                case 1: s_state = "配盘完成"; break;
                case 2: s_state = "创建作业"; break;
                case 3: s_state = "作业执行"; break;
                case 4: s_state = "完成出库"; break;
                case 5: s_state = "分拣完成"; break;
            }
            var oldstate = v - 1;
            var cn = db.Queryable<TN_Distribution_CNTR>().Where(a => a.S_CNTR_CODE == S_CNTR_CODE && a.N_B_STATE == oldstate).First();
            if (cn != null) 
            {
                cn.N_B_STATE = v;
                cn.S_B_STATE = s_state;
                db.Updateable(cn).UpdateColumns(it => new { it.N_B_STATE, it.S_B_STATE }).ExecuteCommand();
            }
        }
 
        internal static void CreateMiddleTable()
        {
            //var order1 = new SqlHelper<OI_SYS_MAXID>().CreateTable();
        }
 
        #region 林芝WCS业务处理
        /// <summary>
        /// 林芝-查询工单信息--执行中或者暂停
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static LinZhiWorkOrder GetLinZhiWorkOrder(string lineNo)
        {
            var db = new SqlHelper<object>().GetInstance();
            var order = db.Queryable<LinZhiWorkOrder>().Where(a => a.S_PLineNo == lineNo && a.S_WorkState == "执行中").First();
            //var order = new SqlHelper<LinJiangWorkOrder>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中"), a => a.T_CREATE, true);
            return order;
        }
 
        internal List<YiKuWorkOrder> GetLinJianglysisOrderWork(string orderType)
        {
            var order = new SqlHelper<YiKuWorkOrder>().GetList(a => a.S_ORDER_TYPE == orderType && a.S_WorkState == "执行中");
            return order;
        }
 
        internal static void CreateLinJiangMiddleTableTest()
        {
            var order4 = new SqlHelper<OI_SYS_MAXID>().CreateTable();//HTTP接口调用失败重发中间表
        }
 
        /// <summary>
        /// 林芝-查询当前设备信息
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static LinZhiDeviceState GetLinJiangDeviceState(string deviceName)
        {
            var order = new SqlHelper<LinZhiDeviceState>().Get(a => a.DeviceName == deviceName, a => a.DeviceTime, true);
            return order;
        }
 
        internal static bool UpdateLinJiangDeviceState(LinZhiDeviceState deviceInfo, string status, string dateTime, string extData = "")
        {
            var res = false;
            var db = new SqlHelper<LinZhiDeviceState>().GetInstance();
            deviceInfo.DeviceState = status;
            deviceInfo.DeviceTime = dateTime;
            db.Updateable(deviceInfo).UpdateColumns(it => new { it.DeviceState, it.DeviceTime }).ExecuteCommand();
            return res;
        }
 
        /// <summary>
        /// 林芝-插入设备信息
        /// </summary>
        /// <param name="wmsTask"></param>
        /// <returns></returns>
        internal static bool LinJiangInsertDeviceState(LinZhiDeviceState deviceState)
        {
            var db = new SqlHelper<LinZhiDeviceState>().GetInstance();
            return db.Insertable(deviceState).ExecuteCommand() > 0;
        }
 
        /// <summary>
        /// 林芝-查询托盘信息-下线时间之前的数据
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static List<LinZhiTrayInfo> GetLinZhiTrayInfoList(string dateTime, string deviceName)
        {
            var db = new SqlHelper<object>().GetInstance();
            var order = new SqlHelper<LinZhiTrayInfo>().GetList(a => Convert.ToDateTime(a.dateTime.Trim()) < Convert.ToDateTime(dateTime) && a.deviceName == deviceName);
 
            var trayInfo = new SqlHelper<LinZhiTrayInfo>().GetInstance().Queryable<LinZhiTrayInfo>().ToList();
            LogHelper.Info("富乐托盘表全部数据:" + JsonConvert.SerializeObject(trayInfo));
 
            //if (order != null && order.Count > 0)
            //{
            //    //删除当前产线下线时间前10分钟的托盘数据
            //    for (int i = order.Count - 1; i >= 0; i--)
            //    {
 
            //    }
            //}
            return order;
        }
 
        /// <summary>
        /// 林芝-更改工单信息:托规、批次号、物料层数
        /// </summary>
        /// <param name="task"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        internal static bool UpdateWorkInfo(LinZhiWorkOrder task, string trayRule = "", string batchNo = "", string itemLayer = "")
        {
            var res = false;
            var db = new SqlHelper<LinZhiWorkOrder>().GetInstance();
            task.S_TrayRules = trayRule;
            task.S_BatchNo = batchNo;
            task.S_ItemLayer = itemLayer;
            db.Updateable(task).UpdateColumns(it => new { it.S_TrayRules, it.S_BatchNo, it.S_ItemLayer }).ExecuteCommand();
            return res;
        }
 
        /// <summary>
        /// 林芝-查询托盘信息-全部-为了对比当前是否为正常下线
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static List<LinZhiTrayInfo> GetLinJiangTrayInfoAllList(string deviceName)
        {
            var order = new SqlHelper<LinZhiTrayInfo>().GetList(a => a.deviceName == deviceName);
            return order;
        }
        #endregion
    }
}