1

wtt

2 天以前 db658b16ef882ddcd56c4fea35aae42d0473b57d

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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace Model
{
    public class ClsSc_WorkBillAutoSortBillMain:DBUtility.ClsXt_BaseBillMain
    {
        public Int64 HICMOStatus;//           int          //ÈÎÎñµ¥×´Ì¬(0´ýÉú²ú£¬1Éú²úÖУ¬2¹ÒÆð£¬3½á°¸)
        public Int64 HDeptID;//           int            //Éú²ú³µ¼äid 
        public string HDeptNumber;//        varchar(50)    //³µ¼ä´úÂë
        public Int64 HMaterID;//          int            //ÎïÁÏid
        public string HMaterNumber;//        varchar(50)    //ÎïÁÏ´úÂë
        public Int64 HSourceID;//         int           //×ÊÔ´ID
        public string HSourceNumber;//        varchar(50)    //×ÊÔ´´úÂë
        public Int64 HSourceID2;//         int           //×ÊÔ´ID
        public Int64 HSourceID3;//         int           //×ÊÔ´ID
        public Int64 HSourceID4;//         int           //×ÊÔ´ID
        public Int64 HSourceID5;//         int           //×ÊÔ´ID
        public Int64 HSourceID6;//         int           //×ÊÔ´ID
        public Int64 HSourceID7;//         int           //×ÊÔ´ID
        public Int64 HSourceID8;//         int           //×ÊÔ´ID
        public Int64 HSourceID9;//         int           //×ÊÔ´ID
        public Int64 HSourceID10;//         int           //×ÊÔ´ID
        public Int64 HUnitID;//           int           //¼ÆÁ¿µ¥Î»ID
        public string HUnitNumber;//         varchar(50)    //µ¥Î»´úÂë
        public Int64 HWorkerID;//        varchar(50)    //²Ù×÷Ô±ID     
        public string HWorkerNumber;//         varchar(50)    //²Ù×÷Ô±´úÂë     
        public Int64 HGroupID;//        int        //°à×éID     
        public string HGroupNumber;//        varchar(50)    //°à×é         
        public string HYX;//            int        //ÓÅÏȼ¶
        /// <summary>
        /// ²úÄÜ
        /// </summary>
        public double HWorkQty;//        dec(18,8)//²úÄÜ
        public double HWorkTimes;//        dec(18,8)//¹¤Ê±
        public double HReadyQty;//        dec(18,8)//¿ª¹¤ÓàÁ¿
        public DateTime HPlanBeginDate;//       datetime      //¼Æ»®¿ª¹¤ÈÕÆÚ
        public DateTime HPlanEndDate;//         datetime      //¼Æ»®Í깤ÈÕÆÚ
        public DateTime HLastBeginDate;//        datetime      //×î³Ù¿ª¹¤        addnew
        public DateTime HLastEndDate;//        datetime      //×î³ÙÍ깤        addnew
        public double HPlanQty;//             dec(18,8)          //¼Æ»®Éú²úÊýÁ¿
        public Int64 HProcID;//            int            //¹¤Ðòid            addnew
        public double HProdTimes;//        money             //Éú²úÖÜÆÚ            addnew
        public double HRelationQty;//        money            //¹ØÁªÊý
        public bool HKTQ;//                   bit            //¿ÉÌáÇ°±ê¼Ç
        public double HOrderNeedQty;//        dec(18,8)    //¶©µ¥ÐèÇóÊý(¿â´æÊýÁ¿)
        public double HReadyTimes;//            dec(18,8)        //×¼±¸Ê±¼ä
        public Int64 HSourceInterID;//        int        //Ô´µ¥Ö÷ÄÚÂë
        public Int64 HSourceEntryID;//        int        //Ô´µ¥×ÓÄÚÂë
        public string HSourceBillNo;//        varchar(50)    //Ô´µ¥ºÅÂë
        public string HSourceBillType;//        varchar(10)    //Ô´µ¥ÀàÐÍ
        public Int64 HICMOInterID;//            int            //ÈÎÎñµ¥Ö÷ÄÚÂë
        public string HICMOBillNo;//             varchar(50)      //ÈÎÎñµ¥ºÅ
        public DateTime HOrderCommitDate;//    datetime    //¶©µ¥½»»õÆÚ
        public Int64 HProcPlanInterID;//    int           //¹¤Ðò¼Æ»®µ¥Ö÷ÄÚÂë
        public Int64 HProcPlanEntryID;//    int           //¹¤Ðò¼Æ»®µ¥×ÓÄÚÂë
        public string HProcPlanBillNo;//        varchar(50)    //¹¤Ðò¼Æ»®µ¥ºÅ
        public string HSeOrderBillNo;//      varchar(50)       //(ÏúÊÛ¶©µ¥ºÅ)
        public Int64 HSeOrderInterID;//      int           //(ÏúÊÛ¶©µ¥Ö÷ÄÚÂë)
        public Int64 HSeOrderEntryID;//       int          //(ÏúÊÛ¶©µ¥×ÓÄÚÂë)
        public Int64 HRelationInterID;//        int        --Åú´ÎºÅID
        public string Horderlev;//                varchar(50)        --¶©µ¥µÈ¼¶
        public string HBatchNo;//  ÈÎÎñµ¥Åú´Î
        public double HSplitPlanQty;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty2;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty3;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty4;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty5;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty6;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty7;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty8;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty9;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitQty10;//        dec(18,8)       //²ð·Ö¼Æ»®Êý
        public double HSplitRelationQty;//     dec(18,8)    //²ð·Ö¹ØÁªÊý
        public string HSplitNO;//                varchar(50)        --²ð·ÖºÅ
        public bool HLocked;//            bit        //Ëø¶¨¼Æ»®
        public bool HHangUp;//            bit        //¹ÒÆð
        public double HSourceQty;//        dec(18,8)       //×ÊÔ´ÊýÁ¿
        public Int64 HWorkShopID;//  Éú²ú³µ¼ä
    }
}