测试职员同步员工同步，开工单增加字段HPeopleSum 开工人数

zrg

2025-10-22 c4419b105b4bacea26f7581ed30d12bf3530a37d

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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace WebAPI.Models
{
    public class ClsKf_MateOutBillSub:DBUtility.ClsXt_BaseBillSub
    { 
        public DateTime HEntryCloseDate;//   datetime      --Ðйرՠ(ĬÈÏΪ'')        new
        public string HRemark;//         varchar(200)        --±¸×¢ 
        public Int64 HMaterID;//     int               --ÎïÁÏID
        public Int64 HPropertyID;//  int                --¸¨ÖúÊôÐÔ
        public Int64 HSecUnitID;//   int                --¸¨Öú¼ÆÁ¿µ¥Î»
        public Single HSecUnitRate;//       money            --»»ËãÂÊ     
        public Int64 HUnitID;//    int                  --¼ÆÁ¿µ¥Î»
        public double HQtyMust;//   dec(18,8)               --Ó¦ÊÕÊýÁ¿
        public double HQty;//        dec(18,8)              --ʵÊÕÊýÁ¿
        public double HPrice;//     dec(18,8)               --µ¥¼Û
        public double HMoney;//     dec(18,8)              --½ð¶î
        public Int64 HWHID;//      int                  --ÊÕÁϲֿâ
        public Int64 HSCWHID;//    int                     --µ÷³ö²Ö¿âID 
        public Int64 HSPID;//        int            --²ÖλID         
        public Int64 HSCSPID;//        int             --µ÷³ö²ÖλID    
        public Int64 HSPGroupID;//    int            --²Öλ×éID(²Ö¿âÑ¡ÔñÍê×Ô¶¯´ø³ö)         
        public string HBatchNo;//    varchar(50)        --Åú´Î         
        public Int64 HPOOrderInterID;//  int              --²É¹º¶©µ¥Ö÷ÄÚÂë
        public Int64 HPOOrderEntryID;//    int            --²É¹º¶©µ¥×ÓÄÚÂë
        public string HPOOrderBillNo;//    varchar(50)         --²É¹º¶©µ¥ºÅ
        public Int64 HSeOrderInterID;//   int             --ÏúÊÛ¶©µ¥Ö÷ÄÚÂë
        public Int64 HSeOrderEntryID;//      int            --ÏúÊÛ¶©µ¥×ÓÄÚÂë
        public string HSeOrderBillNo;//    varchar(50)        --ÏúÊÛ¶©µ¥ºÅ
 
        public double HRate;        //money             --ÓÃÁ¿
 
        public Int64 HICMOInterID;          //        int                --Éú²ú¶©µ¥Ö÷ÄÚÂë
        public Int64 HICMOEntryID;          //        int                --Éú²ú¶©µ¥×ÓÄÚÂë
        public string HICMOBillNo;          //        varchar(50)        --Éú²ú¶©µ¥ºÅ
        public Int64 HKEEPERID;             //        int                --±£¹ÜÕß
        public string HKEEPERTYPEID;        //        varchar(100)    --±£¹ÜÀàÐÍ
        public string HMTONo;               //        varchar(50)        --¼Æ»®¸ú×ÙºÅ
        public Int64 HPlanMode;             //        int                --¼Æ»®Ä£Ê½
        public double HTaxPrice;            //        dec(18,8)        --º¬Ë°µ¥¼Û
        public double HTaxMoney;            //        dec(18,8)        --º¬Ë°½ð¶î
        public Single HTaxRate;             //        money           --Ë°ÂÊ
        public Int64 HWWOrderInterID;       //        int             --ίÍⶩµ¥Ö÷ÄÚÂë
        public Int64 HWWOrderEntryID;       //        int             --ίÍⶩµ¥×ÓÄÚÂë
        public string HWWOrderBillNo;       //        varchar(50)     --ίÍⶩµ¥ºÅ
 
        public string HExpressNumber; // ¿ìµÝµ¥ºÅ
        public Int64 HERPInterID; // ERPÖ÷±íÄÚÂë
        public Int64 HERPEntryID; // ERP×Ó±íÄÚÂë
        public Int64 HSTOCKERGROUPID; // ²Ö¿â×éID
        public Int64 HPROVIDERCONTACTID; // ¹©Ó¦ÉÌÁªÏµÈËID
        public Int64 HSUPPLYID; // ¹©Ó¦ID
        public Int64 HSETTLEID; // ½áËãID
        public Int64 HCHARGEID; // ¸ºÔðÈËID
        public Int64 HPURCHASEDEPTID; // ²É¹º²¿ÃÅID
        public string HPRILSTENTRYID; // ¼Û¸ñ±íÌõÄ¿ID
        public Int64 HPURBASENUM; // ²É¹º»ùÊý
        public Int64 HSTOCKBASEDEN; // ¿â´æ»ù×¼
        public string HBFLOWID; // ÒµÎñÁ÷³ÌID
        public Int64 HSTOCKSTATUSID; // ¿â´æ״̬ID
        public Int64 HPRICEUNITID; // ¼Û¸ñµ¥Î»ID
        public Int64 HBASEUNITID; // »ù±¾µ¥Î»ID
        public Int64 HSNUNITID; // ÐòÁкŵ¥Î»ID
        public Int64 HREMAININSTOCKUNITID; // Ê£Óà¿â´æµ¥Î»ID
        public Int64 HEXTAUXUNITID; // À©Õ¹¸¨Öúµ¥Î»ID
        public Int64 HTAXRATEID; // Ë°ÂÊID
 
        public string HERPBillNo_Sub; // ERP×Ó±íµ¥¾ÝºÅ
        public string HSUPPLIERLOT; // ¹©Ó¦ÉÌÅú´ÎºÅ
        public string HREQTRACENO; // ÐèÇó¸ú×ÙºÅ
        public string HPROJECTNO; // ÏîÄ¿±àºÅ
        public string HGIVEAWAY; // ÔùÆ·±êʶ
        public string HROWTYPE; // ÐÐÀàÐÍ
        public string HPARENTMATID; // ¸¸ÎïÁÏID
 
        public decimal HSYSPRICE; // ÏµÍ³¼Û¸ñ
        public decimal HPRICECOEFFICIENT; // ¼Û¸ñϵÊý
        public decimal HDISCOUNTRATE; // ÕÛ¿ÛÂÊ
        public decimal HBASEUNITPRICE; // »ù±¾µ¥Î»¼Û¸ñ
        public decimal HTAXCOMBINATION; // Ë°ÖÖ×éºÏ£¬
        public decimal HPRICELISTENTRY; // ¼Û¸ñ±íÌõÄ¿
        public decimal HCOSTPRICE; // ³É±¾¼Û¸ñ
        public decimal HSEQ; // ÐòºÅ
        public decimal HTAXRATE_TAX; // Ë°ÂÊÖµ
        public decimal HTAXAMOUNT; // Ë°¶î
        public decimal HCOSTPERCENT; // ³É±¾°Ù·Ö±È
        public decimal HCOSTAMOUNT; // ³É±¾½ð¶î
 
        public string HProduceDate; // Éú²úÈÕÆÚ
        public string HExpiryDate; // ¹ýÆÚÈÕÆÚ
 
        public string HVAT; // Ôöֵ˰±êʶ
        public string HSELLERWITHHOLDING; // ÏúÊÛ·½¿Û½É
        public string HBUYERWITHHOLDING; // ²É¹º·½¿Û½É
 
    }
}