commonclass.cs

一个通讯录源码,用C#写的.挺不错的,大家可以参考看一下.

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using System.Data.OleDb;
using System.Reflection;

namespace AddressList.Utils
{
    #region LoginInfo 登录信息
    public class LoginInfo
    {
        private int FUserID;
        private string FPassword;
        private string FDomain;
        private string FIP;
        private string FUserSID;
        private string FLoginID;
        private string FHost;
        private string FVersion;
        private string FMAC;
        private DateTime FLoginTime;
        private string FLoginServer;

        public int UserID
        {
            get
            {
                return FUserID;
            }
            set
            {
                FUserID = value;
            }
        }

        public string LoginID
        {
            get
            { 
                return FLoginID;
            }

            set 
            {
                FLoginID = value;
            }
        }

        public string Password
        {
            get
            {
                return FPassword;
            }
            
            set
            {
                FPassword = value;
            }
        }

        public string UserSID
        {
            get
            {
                return FUserSID;
            }

            set
            {
                FUserSID = value;
            }
        }

        public string Domain
        {
            get
            {
                return FDomain;
            }

            set
            {
                FDomain = value;
            }
        }

        public string IP
        {
            get
            {
                return FIP;
            }

            set 
            { 
                FIP = value;
            }
        }

        public string Host
        {
            get
            {
                return FHost;
            }

           set 
           {
               FHost = value;
           }
        }

        public string MAC
        {
            get
            {
                return FMAC;
            }
            set 
            {
                FMAC = value;
            }
        }

        public string LoginServer
        {
            get
            {
                return FLoginServer;
            }
            set
            {
                FLoginServer = value;
            }
        }

        public string Version
        {
            get
            {
                return FVersion;
            }
            set
            {
                FVersion = value;
            }
        }

        public DateTime LoginTime
        {
            get
            {
                return FLoginTime;
            }

            set 
            {
                FLoginTime = value;
            }
        }
    }
    #endregion

    #region UserInfo 用户信息
    public class UserInfo
    {
        private int FUserID;        
        private string FMAC;
        private string FSID;
        private string FUserName;
        private string FLoginID;      
        private string FRoleID;
        private string FPassword;
        private string FOrgID;
        private string FEmail;
        private string FDescription;

        public int UserID
        {
            get
            {
                return FUserID;
            }

            set
            {
                FUserID = value;
            }
        }

        public string LoginID
        {
            get
            {
                return FLoginID;
            }
            set
            {
                FLoginID = value;
            }
        }

        public string UserName
        {
            get
            {
                return FUserName;
            }
            set
            {
                FUserName = value;
            }
        }
        public string Password
        {
            get
            {
                return FPassword;
            }
            set
            {
                FPassword = value;
            }
        }

        public string RoleID
        {
            get
            {
                return FRoleID;
            }
            set
            {
                FRoleID = value;
            }
        }

        public string OrgID
        {
            get
            {
                return FOrgID;
            }
            set
            {
                FOrgID = value;
            }
        }

        public string SID
        {
            get
            {
                return FSID;
            }
            set
            {
                FSID = value;
            }
        }

        public string MAC
        {
            get
            {
                return FMAC;
            }
            set
            {
                FMAC = value;
            }
        }

        public string Email
        {
            get
            {
                return FEmail;
            }
            set
            {
                FEmail = value;
            }
        }

        public string Description
        {
            get
            {
                return FDescription;
            }
            set
            {
                FDescription = value;
            }
        }
    }
    #endregion

    #region DBAccess 数据操作
    public class DBAccess
    {
        private const string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=addList.mdb";

        private DbConnection dbConn;
        private OleDbFactory dbFactory;

        public DBAccess()
        {            
            dbFactory = OleDbFactory.Instance;
            dbConn = dbFactory.CreateConnection();
        }

        /// <summary>
        /// 检查数据库连接是否打开
        /// </summary>
        public void CheckConnection()
        {

            if (dbConn.State == System.Data.ConnectionState.Closed)
            {
                try
                {
                    dbConn.ConnectionString = connectionString;
                    dbConn.Open();