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
| using System;
| using System.Collections.Generic;
| using System.Data;
| using System.Linq;
| using System.Threading.Tasks;
| using VueWebCoreApi.DLL.DAL;
| using VueWebCoreApi.Models;
| using VueWebCoreApi.Models.ErpOrder;
| using VueWebCoreApi.Models.InventoryModel;
| using VueWebCoreApi.Models.ReportVerify;
| using VueWebCoreApi.Models.UpdateReport;
| using VueWebCoreApi.Models.WorkData;
| using VueWebCoreApi.Tools;
|
| namespace VueWebCoreApi.DLL.BLL
| {
| public class WorkOrderBLL
| {
|
| #region[ERP订单查询]
| public static ToMessage ErpOrderSearch(string erporderstus,string wkshopcode, string erpordercode, string saleordercode, string partcode, string partname, string partspec, int startNum,string datatype, string paydatestartdate, string paydateenddate, string creatuser, int endNum, string prop, string order)
| {
| return WorkOrderDAL.ErpOrderSearch(erporderstus, wkshopcode, erpordercode, saleordercode, partcode, partname, partspec, startNum, datatype, paydatestartdate, paydateenddate, creatuser, endNum, prop, order);
| }
| #endregion
|
| #region[ERP订单下达]
| public static ToMessage MarkSaveErpOrder(string erporderid,string sbid, string erpordercode, string saleordercode, string partcode,string deptcode, string wkshopcode, string warehousecode, string erpqty, string markqty, string ordernum, string relse_qty,string idTopInventory,string TopInventoryCode,string TopInventoryName , string saleOrderDeliveryDate,string paystartdate,string payenddate, string clerkuser, User us)
| {
| return WorkOrderDAL.MarkSaveErpOrder(erporderid, sbid, erpordercode, saleordercode, partcode, deptcode, wkshopcode, warehousecode, erpqty, markqty, ordernum, relse_qty, idTopInventory, TopInventoryCode, TopInventoryName, saleOrderDeliveryDate, paystartdate, payenddate, clerkuser, us);
| }
| #endregion
|
| #region[订单批量下达]
| public static ToMessage MarkBatchSaveErpOrder(List<ErpOrderBatch> obj, User us)
| {
| return WorkOrderDAL.MarkBatchSaveErpOrder(obj,us);
| }
| #endregion
|
| #region[ERP订单关闭]
| public static ToMessage ClosedErpOrder(string erporderid, string erpordercode, User us)
| {
| return WorkOrderDAL.ClosedErpOrder(erporderid, erpordercode, us);
| }
| #endregion
|
| #region[ERP订单反关闭]
| public static ToMessage ReverseClosedErpOrder(string erporderid, string erpordercode, User us)
| {
| return WorkOrderDAL.ReverseClosedErpOrder(erporderid, erpordercode, us);
| }
| #endregion
|
| #region[ERP订单删除]
| public static ToMessage DeleteErpOrder(string erporderid, string erpordercode, User us)
| {
| return WorkOrderDAL.DeleteErpOrder(erporderid, erpordercode, us);
| }
| #endregion
|
|
|
| #region[MES工单查询]
| public static ToMessage MesOrderSearch(string mesorderstus,string wkshopcode, string mesordercode,string sourceorder, string saleordercode, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string datatype,string paydatestartdate,string paydateenddate, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderSearch(mesorderstus, wkshopcode, mesordercode, sourceorder, saleordercode, ordertype, partcode, partname, partspec, startNum, creatuser, datatype, paydatestartdate, paydateenddate, endNum, prop, order);
| }
| #endregion
|
| #region[MES报废补单工单查询]
| public static ToMessage MesBadOrderSearch(string wkshopcode, string mesordercode, string sourceorder, string saleordercode, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesBadOrderSearch(wkshopcode,mesordercode, sourceorder, saleordercode, partcode, partname, partspec, startNum, creatuser, createdate, endNum, prop, order);
| }
| #endregion
|
| #region[MES工单新增、获取工单号]
| public static ToMessage AddMesOrderCodeSearch()
| {
| return WorkOrderDAL.AddMesOrderCodeSearch();
| }
| #endregion
|
| #region[MES工单编辑获取工序数据]
| public static ToMessage UpdateMesOrderStepSearch(string sourceid, string sourcewo, string wocode, string data_sources)
| {
| return WorkOrderDAL.UpdateMesOrderStepSearch(sourceid,sourcewo,wocode,data_sources);
| }
| #endregion
|
| #region[MES工单新增、编辑提交]
| public static ToMessage AddUpdateMesOrder(string OperType, WorkList json, User us)
| {
| return WorkOrderDAL.AddUpdateMesOrder(OperType,json,us);
| }
| #endregion
|
| #region[MES工单批量绑定获取工序数据]
| public static ToMessage UpdateMesOrderStepListSearch(List<WorkStepList> worksteplist)
| {
| return WorkOrderDAL.UpdateMesOrderStepListSearch(worksteplist);
| }
| #endregion
|
| #region[MES工单新增、编辑批量绑定提交]
| public static ToMessage AddUpdateMesOrderList(string OperType, List<WorkList> json, User us)
| {
| return WorkOrderDAL.AddUpdateMesOrderList(OperType, json, us);
| }
| #endregion
|
| #region[MES工单打印更新打印次数]
| public static ToMessage UpdateMesOrderPrintCount(string wo_code)
| {
| return WorkOrderDAL.UpdateMesOrderPrintCount(wo_code);
| }
| #endregion
|
|
| #region[MES工单删除]
| public static ToMessage DeleteMesOrder(string souceid, string wocode, string m_po, string orderqty, User us)
| {
| return WorkOrderDAL.DeleteMesOrder(souceid, wocode, m_po, orderqty,us);
| }
| #endregion
|
| #region[MES工单查找历史引用最新工序信息]
| public static ToMessage MesOrderNewStepContent(string wkshopcode,string routecode, string partcode, User us)
| {
| return WorkOrderDAL.MesOrderNewStepContent(wkshopcode, routecode, partcode, us);
| }
| #endregion
|
| #region[MES工单查看工单SOP]
| public static ToMessage MesOrderSopSearch(string wocode, string materielcode)
| {
| return WorkOrderDAL.MesOrderSopSearch(wocode, materielcode);
| }
| #endregion
|
| #region[MES工单查看工艺SOP]
| public static ToMessage MesOrderProcessSopSearch(string materielcode, string routecode, string stepcode, User us)
| {
| return WorkOrderDAL.MesOrderProcessSopSearch(materielcode, routecode, stepcode,us);
| }
| #endregion
|
|
| #region[MES工单派发提交]
| public static ToMessage MesOrderDistribution(string[] wocodelist, User us)
| {
| return WorkOrderDAL.MesOrderDistribution(wocodelist, us);
| }
| #endregion
|
| #region[工单关闭列表查询]
| public static ToMessage MesOrderClosedSearch(string mesorderstus,string wkshopcode, string mesordercode, string sourceorder, string saleordercode, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderClosedSearch(mesorderstus, wkshopcode, mesordercode, sourceorder, saleordercode, ordertype, partcode, partname, partspec, startNum, creatuser, createdate, endNum, prop, order);
| }
| #endregion
|
| #region[MES工单批量关闭提交]
| public static ToMessage MesOrderBitchClosedSeave(User us, string[] wocodelist)
| {
| return WorkOrderDAL.MesOrderBitchClosedSeave(us,wocodelist);
| }
| #endregion
|
| #region[MES工单批量反关闭提交]
| public static ToMessage MesOrderBitchReverseClosedSeave(User us, string[] wocodelist)
| {
| return WorkOrderDAL.MesOrderBitchReverseClosedSeave(us, wocodelist);
| }
| #endregion
|
| #region[生产开报工扫码获取工单对应工序任务(自制)]
| public static ToMessage MesOrderStepSearch(string wkshopcode, string wocode, string partcode, string partname, string partspec, int startNum, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderStepSearch(wkshopcode,wocode, partcode, partname, partspec, startNum, endNum, prop, order);
| }
| #endregion
|
| #region[生产开报工扫码获取工单对应工序任务(外协)]
| public static ToMessage MesOrderWxStepSearch(string wkshopcode, string wocode, string partcode, string partname, string partspec, int startNum, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderWxStepSearch(wkshopcode,wocode, partcode, partname, partspec, startNum, endNum, prop, order);
| }
| #endregion
|
| #region[生产开报工扫码获取工单对应工序任务(不良)]
| public static ToMessage MesOrderNgStepSearch(string wkshopcode, string wocode, string partcode, string partname, string partspec, int startNum, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderNgStepSearch(wkshopcode,wocode, partcode, partname, partspec, startNum, endNum, prop, order);
| }
| #endregion
|
| #region[生产开报工扫码获取工单对应工序任务(不良明细)]
| public static ToMessage MesOrderNgSubStepSearch(string wocode, string stepcode)
| {
| return WorkOrderDAL.MesOrderNgSubStepSearch(wocode, stepcode);
| }
| #endregion
|
| #region [生产开报工：报工/外协(发料/收料)时条件判断及数据返回接口]
| public static ToMessage MesOrderStepStart(string OperType, string SelectType, string wocode, string stepcode,User us)
| {
| return WorkOrderDAL.MesOrderStepStart(OperType, SelectType, wocode, stepcode, us);
| }
| #endregion
|
| #region[生产开报工,报工提交]
| public static ToMessage SavaMesOrderStepReport(string mesordercode, string partcode, string stepseq, string stepcode,string stepprice, string eqpcode, string inbarcode, string reckway, string usergroupcode, string reportuser,string payrate, string taskqty, string startqty, string reportqty, List<ReportDefectList> defectobjs, string remarks, User us)
| {
| return WorkOrderDAL.SavaMesOrderStepReport(mesordercode, partcode, stepseq, stepcode, stepprice, eqpcode, inbarcode, reckway, usergroupcode, reportuser, payrate, taskqty, startqty, reportqty, defectobjs, remarks, us);
| }
| #endregion
|
| #region[生产开报工,发料提交]
| public static ToMessage SavaMesOrderStepOut(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode, string outuser, string taskqty, string fqty, User us)
| {
| return WorkOrderDAL.SavaMesOrderStepOut(mesordercode, partcode, stepseq, stepcode, wxcode, outuser, taskqty, fqty, us);
| }
| #endregion
|
| #region[生产开报工,收料提交]
| public static ToMessage SavaMesOrderStepIn(string mesordercode, string partcode, string stepseq, string stepcode, string wxcode, string inbarcode, string inuser, string taskqty, string sqty, List<ReportDefectList> defectobjs, string remarks, User us)
| {
| return WorkOrderDAL.SavaMesOrderStepIn(mesordercode, partcode, stepseq, stepcode, wxcode, inbarcode, inuser, taskqty, sqty, defectobjs, remarks, us);
| }
| #endregion
|
| #region[不良处理,提交]
| public static ToMessage EditOrderNgStepSeave(ReportDefectHandle json, User us)
| {
| return WorkOrderDAL.EditOrderNgStepSeave(json, us);
| }
| #endregion
|
|
| #region[生产执行,报工调整数据查询接口]
| public static ToMessage MesOrderStepVerifySearch(string wkshopcode,string wo_code, string partnumber, string partname, string partspec, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderStepVerifySearch(wkshopcode,wo_code, partnumber, partname, partspec, reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order);
| }
| #endregion
|
| #region[生产执行,报工调整获取选定报工记录的不良数据]
| public static ToMessage MesOrderStepModelSearch(string wo_code, string step_code, string step_type, string isbott, string isend, string id, string sbid)
| {
| return WorkOrderDAL.MesOrderStepModelSearch(wo_code, step_code, step_type, isbott, isend, id, sbid);
| }
| #endregion
|
| #region[生产执行,报工调整数据提交]
| public static ToMessage MesOrderStepUpdateSeave(User us, List<UpdateProductReport> json)
| {
| return WorkOrderDAL.MesOrderStepUpdateSeave(us,json);
| }
| #endregion
|
|
| #region[生产执行,报工审核列表数据查询接口]
| public static ToMessage MesOrderStepReportVerifySearch(string reviewstatus, string wkshopcode, string wo_code, string partnumber, string partname, string partspec, string stepname, string reportuser, string reportdateopendate, string reportdateclosedate, int startNum, int endNum, string prop, string order)
| {
| return WorkOrderDAL.MesOrderStepReportVerifySearch(reviewstatus,wkshopcode, wo_code, partnumber, partname, partspec, stepname, reportuser, reportdateopendate, reportdateclosedate, startNum, endNum, prop, order);
| }
| #endregion
|
| #region[生产执行,报工审核数据提交]
| public static ToMessage MesOrderStepReportVerifySeave(User us, DataModel json)
| {
| return WorkOrderDAL.MesOrderStepReportVerifySeave(us,json);
| }
| #endregion
|
| #region[生产执行,报工弃审数据提交]
| public static ToMessage MesOrderStepReportNotVerifySeave(User us, string id, string steptype)
| {
| return WorkOrderDAL.MesOrderStepReportNotVerifySeave(us, id, steptype);
| }
| #endregion
|
|
|
| #region[生产入库条码补打]
| public static ToMessage ProductInHouseLabCode(string ordercode)
| {
| return WorkOrderDAL.ProductInHouseLabCode(ordercode);
| }
| #endregion
|
| #region[生产入库信息查询]
| public static ToMessage ProductInHouseOrderSearch(string deptno, string saleordercode, string wkshopcode, string erpordercode, string mesordercode, string partcode, string partname, string partspec)
| {
| return WorkOrderDAL.ProductInHouseOrderSearch(deptno, saleordercode, wkshopcode, erpordercode, mesordercode, partcode, partname, partspec);
| }
| #endregion
|
| #region[生产入库获取单据号]
| public static ToMessage ProductInHouseOrderCodeSearch(string rightcode)
| {
| return WorkOrderDAL.ProductInHouseOrderCodeSearch(rightcode);
| }
| #endregion
|
| #region[MES生产入库提交-存储过程版]
| public static ToMessage InHouseOrderSpSeave(InReptModel data, User us)
| {
| return WorkOrderDAL.InHouseOrderSpSeave(data, us);
| }
| #endregion
|
| #region[畅捷通T+生产入库提交-存储过程版(适用同一台服务器，同一个数据库)]
| public static ToMessage TProductInHouseOrderSpSeave(InReptModel data, User us)
| {
| return WorkOrderDAL.TProductInHouseOrderSpSeave(data, us);
| }
| #endregion
| }
| }
|
|
