客户列表、供应商列表

zzr99

2021-08-27 058ccce4c336af1e7c32d0e6f164ed28ed0ac54c

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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace Model
{
    public class ClsSup_SupplyFileMain : DBUtility.ClsXt_BaseBillMain
    {
 
 
 
       public string HDateForWeb;
 
        
       public string HNumber;//   varchar(50)         //´úÂë
       public string HName;//    varchar(100)         //Ãû³Æ
       public string HHelpCode;//   varchar(50)    //Öú¼ÇÂë
       public string HShortName;//  varchar(50)   //¼ò³Æ
       public string HCheckStatus;//   varchar(50)  //ÆÀ¹À״̬(ÃâÆÀ¹À£¬Î´ÆÀ¹À£¬ÒÑÆÀ¹À)ÏÂÀ­¿ò
       public string HFoundDate;//   datatime    //´´Á¢ÈÕÆÚ
       public string HSupStatusID;//   int   //¹©Ó¦É̵ȼ¶£¨ºÚÃûµ¥,DZÔÚ£¬D,C,B,A£©
       public string HComScopeID;//  int         //¹«Ë¾¹æÄ££¨Ìش󣬴óÐÍ£¬ÖÐСÐÍ£¬Ð¡ÐÍ£©
       public string HComKindID;//   int       //¹«Ë¾ÐÔÖÊ£¨¹úÓÐÆóÒµ£¬ÃñÓª£¬¸öÌ廧£©
       public string HComTypeID;//   int      //¹«Ë¾ÀàÐÍ(ÈÕ³££¬¸Ü¸Ë£¬¹Ø¼ü£¬Æ¿¾±)
       public string HComSortID;//   int        //¹«Ë¾Àà±ð£¨ÖÆÔìÉÌ£¬´úÀíÉÌ£©
       public string HSupSortID;//   int        //¹©Ó¦Àà±ð£¨²É¹º£¬Î¯Í⣬·þÎñ£©
       public string HSupTypeID;//   int        //¹©Ó¦ÉÌ·ÖÀࣨһ¼¶£¬¶þ¼¶£¬Èý¼¶£©
       public string HLawMan;//  varchar(50)       //·¨ÈË´ú±í
       public string HLinkMan;//  varchar(50)      //ÁªÏµÈË
       public string HLinkPhone;//  varchar(100)     //ÁªÏµµç»°
       public string HFax;//   varchar(100)      //¹«Ë¾´«Õæ
       public string HBankroll;//  varchar(20)       //×¢²á×ʽð
       public string HBookNo;//     varchar(100)            //¹¤É̵ǼǺÅ
       public long HComTradeID;//   int        //ËùÊôÐÐÒµ
       public string HCountry;//    varchar(50)         //¹ú¼Ò
       public string HProvince;//    varchar(50)         //Ê¡·Ý
       public string HCity;//    varchar(50)             //³ÇÊÐ
       public long HDeptID;//      int    //¸ºÔð²¿ÃÅ
       public long HManagerID;// varchar(50)  //¸ºÔðÈË
       public string HBookDate;//  datetime    //×¢²áÈÕÆÚ        (ĬÈÏÖµ 1900-01-01)
       public string HCheckDate;// datetime        //Åú×¼ÈÕÆÚ(1900-01-01)
       public string HBeginDate;// datetime        //ÉúЧÈÕÆÚ(1900-01-01)
       public string HEndDate;// datetime        //ʧЧÈÕÆÚ(2100-01-01)
       public string HBrand;//    varchar(100)    //×¢²áÉ̱ê
       public long HEmpCount;//  int        //ÆóÒµÈËÊý
       public string HTaxNo;//    varchar(100)    //Ë°ÎñµÇ¼ÇºÅ
       public Single HTaxRate;//  money        //Ôöֵ˰ÂÊ
       public string HPostNo;//     varchar(50)    //Óʱà
       public string HComAddress;// varchar(500)        //¹«Ë¾µØÖ·
       public string HBankName;//   varchar(200)        //¿ª»§ÒøÐÐ
       public string HBankAccNo;// varchar(50)        //ÕʺÅ
       public string HSellBound;//    varchar(100) //¾­Óª·¶Î§
       public long HSupID;//    int          //¶ÔÓ¦¹©Ó¦ÉÌID
            
 
 
    }
}