农夫靖宇

lss

2025-05-30 38eff4fc0100131b180ffa872009b502629743f5

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
using HH.WCS.JingyuNongfu.util;
using SqlSugar;
using System;
using System.Collections.Generic;
 
namespace HH.WCS.JingyuNongfu.wms
{
    /// <summary>
    /// 工单 相关表的读写
    /// </summary>
    public class MESHelper
    {
        static MESHelper()
        {
        }
 
        /// <summary>
        /// 查询工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrder(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中"), a => a.T_CREATE, true);
            return order;
        }
        public static WorkOrder3 GetWorkOrderdsj(string lineNo)
        {
            var order = new SqlHelper<WorkOrder3>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中"), a => a.T_CREATE, true);
            return order;
        }
        /// <summary>
        /// 查询工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrderN(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中" && a.S_UsingNow.Trim() == "N"), a => a.T_CREATE, true);
            return order;
        }
        /// <summary>
        /// 查询审核的工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrderVerify(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && a.S_WorkState == "审核中", a => a.T_CREATE, true);
            return order;
        }
        public static WorkOrder GetWorkOrderByOrderNo(string orderNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_WorkNo == orderNo);
            return order;
        }
        internal static bool UpdateWorkOrderAutoCompleteFalse(WorkOrder workOrder)
        {
            var db = new SqlHelper<object>().GetInstance();
            workOrder.S_AutoComplete = "否";
            return db.Updateable(workOrder).UpdateColumns(it => new { it.S_AutoComplete }).ExecuteCommand() > 0;
        }
       
 
        /// <summary>
        /// 查找成品工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder1 GetWorkOrder1(string lineNo)
        {
            var order = new SqlHelper<WorkOrder1>().Get(a => a.S_PLineNo.Trim() == lineNo && a.S_WorkState.Trim() == "执行中", a => a.T_CREATE, true);
            return order;
        }
 
        /// <summary>
        /// 按成品工单号查找成品工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder1 GetWorkByWorkno(string lineNo)
        {
            var order = new SqlHelper<WorkOrder1>().Get(a => a.S_WorkNo.Trim() == lineNo && a.S_WorkState.Trim() == "执行中", a => a.T_CREATE, true);
            return order;
        }
    }
}