userinfo.cs

该服务平台解决了计算机网络与移动网络之间信息交换问题

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace Common.Model
{
    public class UserInfo : DataSet
    {
        public const String TABLE_USER_INFO = "UserInfo";
        public const String COLUMNS_USER_ID = "UserID";
        public const String COLUMNS_AREA_ID = "AreaID";
        public const String COLUMNS_COUNTY_ID = "CountyID";
        public const String COLUMNS_USER_DEFINE_ID = "UserDefineID";
        public const String COLUMNS_NAME = "Name";
        public const String COLUMNS_TRADE_ID = "TradeID";
        public const String COLUMNS_SEX = "Sex";
        public const String COLUMNS_DUTY = "Duty";
        public const String COLUMNS_SCHOOL = "School";
        public const String COLUMNS_SCHOOL_AGE = "SchoolAge";
        public const String COLUMNS_SPECIALITY = "Speciality";
        public const String COLUMNS_BIRTHDAY = "Birthday";
        public const String COLUMNS_HOMEADDRESS = "HomeAddress";
        public const String COLUMNS_MOBILE = "Mobile";
        public const String COLUMNS_HUKOU = "Hukou";
        public const String COLUMNS_RACE = "Race";
        public const String COLUMNS_JIGUAN = "Jiguan";
        public const String COLUMNS_JOINTIME = "Jointime";
        public const String COLUMNS_IDCARD = "IDcard";
        public const String COLUMNS_NOWADDRESS = "NowAddress";
        public const String COLUMNS_BEIZHU = "Beizhu";
        public const String COLUMNS_USER_FUNCTION = "UserFunction";




        public const String TABLE_CUSTOMER_INFO = "CustomerInfo";
        public const String COLUMNS_CUSTOMER_ID = "CustomerID";
        public const String COLUMNS_TYPE_ID = "TypeID";
        public const String COLUMNS_GROUP_ID = "GroupID";
        public const String COLUMNS_CUSTOMER_DEFINE_ID = "CustomerDefineID";
        public const String COLUMNS_CUSTOMERNAME = "Name";
        public const String COLUMNS_CUSTOMERTRADE_ID = "TradeID";
        public const String COLUMNS_CUSTOMERSEX = "Sex";
        public const String COLUMNS_CUSTOMERDUTY = "Duty";
        public const String COLUMNS_UNIT = "Unit";
        public const String COLUMNS_JOINDATE = "JoinDate";
        public const String COLUMNS_UNITADDRESS = "UnitAddress";
        public const String COLUMNS_CUSTOMERIDCARD = "IDcard";
        public const String COLUMNS_CUSTOMERBIRTHDAY = "Birthday";
        public const String COLUMNS_CUSTOMERHOMEADDRESS = "HomeAddress";
        public const String COLUMNS_CUSTOMERMOBILE = "Mobile";
        public const String COLUMNS_CUSTOMER_BEIZHU = "Beizhu";

        public const String COLUMNS_CUSTOMER_FUNCTION = "CustomerFunction";



        public UserInfo()
        {
            CreateTable();
        }





        public void CreateTable()
        {
            DataTable dt = new DataTable(TABLE_USER_INFO);
            dt.Columns.Add(COLUMNS_USER_ID, typeof(String));
            dt.Columns.Add(COLUMNS_AREA_ID, typeof(Int32));
            dt.Columns.Add(COLUMNS_COUNTY_ID, typeof(Int32));
            dt.Columns.Add(COLUMNS_USER_DEFINE_ID, typeof(String));
            dt.Columns.Add(COLUMNS_NAME, typeof(String));
            dt.Columns.Add(COLUMNS_TRADE_ID, typeof(Int32));
            dt.Columns.Add(COLUMNS_SEX, typeof(Int32));

            dt.Columns.Add(COLUMNS_DUTY, typeof(String));
            dt.Columns.Add(COLUMNS_SCHOOL, typeof(String));
            dt.Columns.Add(COLUMNS_SCHOOL_AGE, typeof(String));
            dt.Columns.Add(COLUMNS_SPECIALITY, typeof(String));
            dt.Columns.Add(COLUMNS_BIRTHDAY, typeof(String));
            dt.Columns.Add(COLUMNS_HOMEADDRESS, typeof(String));
            dt.Columns.Add(COLUMNS_MOBILE, typeof(String));
            dt.Columns.Add(COLUMNS_USER_FUNCTION, typeof(int));
            dt.Columns.Add(COLUMNS_HUKOU, typeof(String));
            dt.Columns.Add(COLUMNS_RACE, typeof(String));
            dt.Columns.Add(COLUMNS_JIGUAN, typeof(String));
            dt.Columns.Add(COLUMNS_JOINTIME, typeof(String));
            dt.Columns.Add(COLUMNS_IDCARD, typeof(String));
            dt.Columns.Add(COLUMNS_NOWADDRESS, typeof(String));
            dt.Columns.Add(COLUMNS_BEIZHU, typeof(String));
            this.Tables.Add(dt);




            DataTable dc = new DataTable(TABLE_CUSTOMER_INFO);
            dc.Columns.Add(COLUMNS_CUSTOMER_ID, typeof(String));
            dc.Columns.Add(COLUMNS_TYPE_ID, typeof(Int32));
            dc.Columns.Add(COLUMNS_GROUP_ID, typeof(Int32));
            dc.Columns.Add(COLUMNS_CUSTOMER_DEFINE_ID, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERNAME, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERTRADE_ID, typeof(Int32));
            dc.Columns.Add(COLUMNS_CUSTOMERSEX, typeof(Int32));

            dc.Columns.Add(COLUMNS_CUSTOMERDUTY, typeof(String));
            dc.Columns.Add(COLUMNS_UNIT, typeof(String));
            dc.Columns.Add(COLUMNS_JOINDATE, typeof(String));
            dc.Columns.Add(COLUMNS_UNITADDRESS, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERIDCARD, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERBIRTHDAY, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERHOMEADDRESS, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMERMOBILE, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMER_BEIZHU, typeof(String));
            dc.Columns.Add(COLUMNS_CUSTOMER_FUNCTION, typeof(int));

            this.Tables.Add(dc);


        }



    }
}