代码上传

王 垚

2022-09-15 22b11da0f245314fa031905f68ee9b3b36216250

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
using Demo.Model.Infrastructure;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace Demo.Model.Model
{
    /// <summary>
    /// Excel导入生成收料通知单 导入信息 
    /// </summary>
    public class pur_ReceiveExcelEntry
    {
        public long FORGID { get; set; }
        public long FID { get; set; }
        public long FEntryID { get; set; }
        public long FSUPPLIERID { get; set; }
        public long FMaterialId { get; set; }
        public long FSTOCKID { get; set; }
        public long FBzbsId { get; set; }
        public decimal FQTY { get; set; }
        public long FSEQ { get; set; }
        public string FPOORDERNO { get; set; }
    }
 
    /// <summary>
    /// 采购订单数据
    /// </summary>
    public class pur_PurchaseExcelEntry
    {
        public long FPurchaseOrgId { get; set; }
        public long FSupplierId { get; set; }
        public long FMaterialId { get; set; }
        public long FBzbsId { get; set; }
        public decimal FRemainReceiveQty { get; set; }
        public decimal FQTY { get; set; }
        public long FID { get; set; }
        public long FENTRYID { get; set; }
        public long FSEQ { get; set; }
        public string FBILLNO { get; set; }
        public DateTime FCREATEDATE { get; set; }
        public DateTime FDeliveryDate { get; set; }
        public decimal FNeedQty { get; set; } //剩余收料数量 不参与计算 用于记录
        public long FSTOCKID { get; set; }
    }
    /// <summary>
    /// Excel导入生成收料通知单 采购订单信息 用于存储
    /// </summary>
    public class pur_PoOrderExcelEntry
    {
        //[FID], [FEntryID], [FSUPPLIERID], [FMATERIALID], [FPOORDERNO], [FRECEIVABLEQTY], [FACTQTY], [FPOCREATEDATE], [FDELIVERYDATE], [FPOORDERID], [FPOORDERENTRYID], [FPOORDERSEQ], [FEXCELIMPORTSEQ], [FSEQ]
        public long FID { get; set; }
        public long FSUPPLIERID { get; set; }
        public long FMATERIALID { get; set; }
        public long FPOBzbsId { get; set; }
        public string FPOORDERNO { get; set; }
        public decimal FRECEIVABLEQTY { get; set; }
        public decimal FACTQTY { get; set; }
        public DateTime FPOCREATEDATE { get; set; }
        public DateTime FDELIVERYDATE { get; set; }
        public long FPOORDERID { get; set; }
        public long FPOORDERENTRYID { get; set; }
        public long FPOORDERSEQ { get; set; }
        public long FEXCELIMPORTSEQ { get; set; }
        public long FPoStockId { get; set; } //仓库
    }
}