更新ASN实体

Rodney Chen

2025-04-02 a8fcfbb5e5ed9a07b1a30ef2d7ef9d407e9b04dd

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
using MailKit.Search;
using Newtonsoft.Json;
using Newtonsoft.Json.Serialization;
using Rhea.Common;
using System;
using System.IO;
using Tiger.Model;
using Tiger.Model.Base;
using Tiger.Model.MES.Yada;
 
namespace Tiger.Business.WMS.Extensions
{
    /// <summary>
    /// 工单发料扩展方法
    /// </summary>
    public static class OutExtension
    {
        /// <summary>
        /// 根据发料类型，获取来源单据编码
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public static string GetSourceCode(this BIZ_WMS_PREP.BIZ_TYPEs type)
        {
            switch (type)
            {
                case BIZ_WMS_PREP.BIZ_TYPEs.Others:
                    return nameof(BIZ_U9_MISC_OUT);
                case BIZ_WMS_PREP.BIZ_TYPEs.WorkOrder:
                    return nameof(BIZ_MES_WO);
                case BIZ_WMS_PREP.BIZ_TYPEs.Outsourcing:
                    return nameof(BIZ_U9_SCM_OUT);
                case BIZ_WMS_PREP.BIZ_TYPEs.Requisition:
                default:
                    return "";
            }
        }
 
        /// <summary>
        /// 根据发料类型，获取发料单据来源明细
        /// </summary>
        /// <param name="type"></param>
        /// <param name="orderNo"></param>
        /// <returns></returns>
        public static List<BIZ_WMS_PREP_SRC_DTL> GetPickList(this BIZ_WMS_PREP.BIZ_TYPEs type, string orderNo)
        {
            // 查询单据明细
            var pickList = new List<BIZ_WMS_PREP_SRC_DTL>();
            switch (type)
            {
                case BIZ_WMS_PREP.BIZ_TYPEs.Others:
                    {
                        var dtls = Biz.Db.Queryable<BIZ_U9_MISC_OUT_DTL>().Where(q => q.ORDER_NO == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.WorkOrder:
                    {
                        var dtls = Biz.DataSource["YadaU9C"].Client.Queryable<mes_MOPickList>().Where(q => q.MoDocNo == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.Outsourcing:
                    {
                        var dtls = Biz.DataSource["YadaU9C"].Client.Queryable<mes_SCMPickList>().Where(q => q.PoDocNo == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.Requisition:
                default:
                    break;
            }
            return pickList;
        }
 
        /// <summary>
        /// 根据发料类型，调用相应发料单据的ERP接口
        /// </summary>
        /// <param name="type"></param>
        /// <param name="orderNo"></param>
        /// <param name="commitInput"></param>
        /// <returns></returns>
        public static List<BIZ_WMS_PREP_SRC_DTL> CommitToERP(this BIZ_WMS_PREP.BIZ_TYPEs type, string orderNo, object commitInput)
        {
            // 查询单据明细
            var pickList = new List<BIZ_WMS_PREP_SRC_DTL>();
            switch (type)
            {
                case BIZ_WMS_PREP.BIZ_TYPEs.Others:
                    {
                        var dtls = Biz.Db.Queryable<BIZ_U9_MISC_OUT_DTL>().Where(q => q.ORDER_NO == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.WorkOrder:
                    {
                        var dtls = Biz.DataSource["YadaU9C"].Client.Queryable<mes_MOPickList>().Where(q => q.MoDocNo == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.Outsourcing:
                    {
                        var dtls = Biz.DataSource["YadaU9C"].Client.Queryable<mes_SCMPickList>().Where(q => q.PoDocNo == orderNo).ToList();
                        pickList = dtls.Select(q => q.GetPickItem()).ToList();
                    }
                    break;
                case BIZ_WMS_PREP.BIZ_TYPEs.Requisition:
                default:
                    break;
            }
            return pickList;
        }
    }
}