33

jingh

2021-08-07 a39b9f490e54b0cf585c165cd37f669be74668d2

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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace Model
{
    public class ClsCrm_CustomerFileMain : DBUtility.ClsXt_BaseBillMain
    {     
 
        
        public Int64 HCusID;//  int           ¶ÔÓ¦¿Í»§ID
        public string HCusNumber;//    varchar(100)    --
        public string HNumber;//   varchar(50)   ¿Í»§´úÂë
        public string HName;//   varchar(100)     ¿Í»§Ãû³Æ
        public string HHelpCode;//   varchar(50)    //Öú¼ÇÂë
        public string HShortName;// varchar(50)  ¿Í»§¼ò³Æ
        public string HComSortID;//   varchar(10)    //¹«Ë¾Àà±ð£¨ÖÆÔìÉÌ£¬´úÀíÉÌ£©
        public string HFoundDate;//   datatime    //´´Á¢ÈÕÆÚ
        public Int64 HCusTypeID;//   int        //¿Í»§·ÖÀà(F7)
        public string HCusFrom;//   varchar(50)  ¿Í»§À´Ô´(ÏÂÀ­¿ò)
        public string HComNote;//   varchar(200) ¹«Ë¾¼ò½é
        public string HEvaluate;//   varchar(5)  ¼ÛÖµÆÀ¹À(µÍ£¬ÖУ¬¸ß)
        public string HCreditLevel;//    varchar(5)  ÐÅÓõȼ¶(µÍ£¬ÖУ¬¸ß)
        public Int64 HComTradeID;//   int            //ËùÊôÐÐÒµ(F7)    
        public string HComKindID;//  varchar(10)     ¹«Ë¾ÐÔÖÊID£¨¹úÓÐÆóÒµ£¬ÃñÓª£¬¸öÌ廧£©
        public string HComScopeID;//  varchar(10)         //¹«Ë¾¹æÄ£ £¨Ìش󣬴óÐÍ£¬ÖÐСÐÍ£¬Ð¡ÐÍ£©
        public Int64 HEmpCount;//  int                //ÆóÒµÈËÊý
        public string HStatus;//   varchar(50)          ½×¶Î(ÏÂÀ­¿ò)
        public Int64 HAreaID;//       int                ¹ú±ðµØÇøID 
        public string HPostNo;//     varchar(50)            //Óʱà
        public string HCountry;//    varchar(50)         //¹ú¼Ò
        public string HProvince;//    varchar(50)         //Ê¡·Ý
        public string HCity;//    varchar(50)             //³ÇÊÐ
        public string HComAddress;// varchar(500)        //¹«Ë¾µØÖ·
        public string HLawMan;//   varchar(50)           //·¨ÈË´ú±í
        public string HLinkMan;//   varchar(50)          //ÁªÏµÈË
        public string HLinkPhone;//  varchar(100)         //ÁªÏµµç»°
        public string HMobPhone;//    varchar(20)    //ÊÖ»ú                addnew
 
        public string HLinkMan2;//   varchar(50)          //ÁªÏµÈË2            addnew
        public string HLinkPhone2;//  varchar(100)         //ÁªÏµµç»°2            addnew
        public string HMobPhone2;//    varchar(20)    //ÊÖ»ú2                addnew
        public string HLinkMan3;//  varchar(50)          //ÁªÏµÈË3            addnew
        public string HLinkPhone3;// varchar(100)         //ÁªÏµµç»°3            addnew
        public string HMobPhone3;//    varchar(20)    //ÊÖ»ú3                addnew
 
        public string HFax;//   varchar(100)          //¹«Ë¾´«Õæ
        public string HBankroll;//  varchar(20)           //×¢²á×ʽð
        public Int64 HDeptID;//      int            //¸ºÔð²¿ÃÅ
        public Int64 HManagerID;// int          //¸ºÔðÈË
        public string HSellProduct;//    varchar(50)   Ö÷Óª²úÆ·
        public string HTurnover;//    varchar(50)   ÄêÓªÒµ¶î
        public string HComTradeNo;//   varchar(50)   ÐÐÒµÅÅÃû
        public string HComERPStatus;//    varchar(500)  ÆóÒµÐÅÏ¢»¯×´¿ö
        public string HComTarget;//    varchar(500)   ÆóÒµÕ½ÂÔÄ¿±ê
        public string HEmpHolder;//        varchar(50)    //ËùÓÐÈË     
        public Single HLinkQty;//    money        --½»Á÷´ÎÊý         (×÷Òµ»ØÌî)
        public string HLinkDate;//    varchar(10)    --Éϴν»Á÷ʱ¼ä         
        public Single HUnCloseChanceQty;//    money    --δ¹Ø±ÕÐèÇó         
        public Single HUnSendProdQty;//        money    --δ·¢»õ         
        public Single HUnReceiveMoney;//        money    --δÊÕ¿î         
 
        public string HCusStatus;//    varchar(20)    --¿Í»§×´Ì¬£¨Ç±ÔÚ£¬¸ú×ÙÖУ¬Õýʽ¿Í»§£©         
        public string HLastBusDate;//    varchar(10)    --×îºóÒµÎñÈÕÆÚ                     
        public string HLastLinkDate;//    varchar(10)    --×îºóÁªÏµÈÕÆÚ                     
        public Int64 HLinkDays;//    int        --ÁªÏµÖÜÆÚ(×îºóÁªÏµÈÕÆÚ³¬¹ýÁªÏµÖÜÆÚ£¬ÔòÒÆÈ빫º£) 
 
        public string HOldEmpHolder;//    varchar(50)        --Ô­ËùÓÐÈË
        public string HOutPubDate;//    datetime        --ÒÆÈ빫º£ÈÕÆÚ
        public string HDateForWeb;
 
 
    }
}