kazelee
1 天以前 6ed44f32c96a17fd10601a24c3c36ca1229bc89b
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
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Http;
 
using HH.WCS.Mobox3.AnGang.dispatch;
using HH.WCS.Mobox3.AnGang.wms;
using HH.WCS.Mobox3.AnGang.models;
 
using Newtonsoft.Json;
 
using static HH.WCS.Mobox3.AnGang.api.ApiModel;
using HH.WCS.Mobox3.AnGang.util;
 
namespace HH.WCS.Mobox3.AnGang.api {
    /// <summary>
    /// 测试用,如果项目中要和设备对接,前期设备无法测试,用接口模拟
    /// </summary>
    [RoutePrefix("api")]
    public class DebugController : System.Web.Http.ApiController
    {
        /// <summary>
        /// AGV状态一键回报1462-国自
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Route("AGVSeriesReports")]
        public GzResults AGVSeriesReports(UpdateTaskState model) {
            GzResults gzResults = new GzResults();
            gzResults.GzResultList = new List<GzResult>();
            var orderStatus = new orderStatusReportParme() {
                orderName = model.TaskID,
                agvIDList = model.ForkliftNo,
                orderStatus = "waiting",
            };
            var temp1 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp1);
 
            orderStatus.orderStatus = "source_finish";
            var temp2 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp2);
 
            orderStatus.orderStatus = "dest_finish";
            var temp3 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp3);
 
            orderStatus.orderStatus = "finish";
            var temp4 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp4);
 
            return gzResults;
        }
 
        /// <summary>
        /// AGV状态一键回报14-国自
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Route("AGVSeriesReports-14")]
        public GzResults AGVSeriesReports14(UpdateTaskState model) {
            GzResults gzResults = new GzResults();
            gzResults.GzResultList = new List<GzResult>();
            var orderStatus = new orderStatusReportParme() {
                orderName = model.TaskID,
                agvIDList = model.ForkliftNo,
                orderStatus = "waiting",
            };
            var temp1 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp1);
 
            orderStatus.orderStatus = "source_finish";
            var temp2 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp2);
 
            return gzResults;
        }
 
        /// <summary>
        /// AGV状态一键回报62-国自
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Route("AGVSeriesReports-62")]
        public GzResults AGVSeriesReports62(UpdateTaskState model) {
            GzResults gzResults = new GzResults();
            gzResults.GzResultList = new List<GzResult>();
            var orderStatus = new orderStatusReportParme() {
                orderName = model.TaskID,
                agvIDList = model.ForkliftNo,
                orderStatus = "dest_finish",
            };
 
            var temp3 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp3);
 
            orderStatus.orderStatus = "finish";
            var temp4 = GZRobot.orderStatusReport(orderStatus);
            gzResults.GzResultList.Add(temp4);
 
            return gzResults;
        }
 
        /// <summary>
        /// 初始化数据库
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [Route("CreateDatabase")]
        public string CreateDatabase() {
            try {
                var db = new SqlHelper<object>().GetInstance();
 
                var entityTypes = new Type[] { };
 
                //db.CodeFirst.InitTables(entityTypes);
            }
            catch (Exception ex) {
                LogHelper.Info($"发生了异常");
                return "初始化数据库错误" + ex.Message;
            }
            return "成功";
        }
 
        /// <summary>
        /// DEBUG:根据任务号设置物料重量
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("SetTaskWeight")]
        public string SetTaskWeight(SetTaskWeightInfo model) {
            var db = new SqlHelper<object>().GetInstance();
            var cgDetail = db.Queryable<TN_CG_Detail, TN_Task>((d, t) => d.S_CNTR_CODE == t.S_CNTR_CODE)
                .Where((d, t) => t.S_CODE == model.TaskNo).First();
 
            if (cgDetail == null) {
                return "找不到对应的物料信息";
            }
 
            var task = db.Queryable<TN_Task>()
                .Where(t => t.S_CODE == model.TaskNo).First();
 
            if (cgDetail == null) {
                return "找不到对应的任务号";
            }
 
            cgDetail.F_QTY = model.Weight;
            task.F_WEIGHT = model.Weight;
 
            try {
                using (var tran = db.Ado.UseTran()) {
                    if (db.Updateable<TN_CG_Detail>(cgDetail).UpdateColumns(it => it.F_QTY)
                    .ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return "修改失败";
                    }
 
                    if (db.Updateable<TN_Task>(task).UpdateColumns(it => it.F_WEIGHT).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return "修改失败";
                    }
                    tran.CommitTran();
                }
                LogHelper.Info($"模拟AGV传递物料重量:修改任务号{task.S_CODE}重量为{model.Weight}", "HosttoagvTask");
                return "修改成功";
            }
 
            catch (Exception ex) {
 
                return ex.Message;
            }
        }
    }
 
    public class ReturnResults {
        public List<ReturnResult> ResultList { set; get; }
    }
 
    public class GzResults {
        public List<GzResult> GzResultList { set; get; }
    }
 
    /// <summary>
    /// 模拟 AGV 传递信号,用于更改任务状态
    /// </summary>
    public class UpdateTaskState {
        /// <summary>
        /// 任务ID
        /// </summary>
        public string TaskID { set; get; }
        /// <summary>
        /// AGV 小车号
        /// </summary>
        public string ForkliftNo { set; get; }
        /// <summary>
        /// AGV 下一个状态
        /// </summary>
        public int NextState { set; get; }
    }
 
    public class SetTaskWeightInfo {
        public string TaskNo { set; get; }
        public float Weight { set; get; }
    }
}