userinfo.cs

来自「该服务平台解决了计算机网络与移动网络之间信息交换问题」· CS 代码 · 共 53 行

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_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_USER_FUNCTION = "UserFunction";
        
        public UserInfo()
        {
            CreateTable();
        }

        public void CreateTable()
        {
            DataTable dt = new DataTable(TABLE_USER_INFO);
            dt.Columns.Add(COLUMNS_USER_ID,typeof(int));
            dt.Columns.Add(COLUMNS_AREA_ID,typeof(int));
            dt.Columns.Add(COLUMNS_COUNTY_ID,typeof(int));
            dt.Columns.Add(COLUMNS_USER_DEFINE_ID,typeof(String));
            dt.Columns.Add(COLUMNS_NAME,typeof(String));
            dt.Columns.Add(COLUMNS_SEX,typeof(int));
            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));

            this.Tables.Add(dt);
        }
    }
}