自定义控件的使用例子一

新客网 XKER.COM 2003-07-12 来源： 收藏本文

using System;
using com.joybase.DB;
using com.oztime.WorkShop.CodeBase;
namespace com.oztime.WorkShop.CodeBase.DB
{
    /// <summary>
    /// Summary description for DBUser.
    /// </summary>
    public class DBUser:User
    {
        private int m_UserID;
        private string m_UserName;
        private string m_Password;
        private Sex m_UserSex;
        private string m_UserEmail;
        private string m_UserTitle;
        public DBUser(string p_UserName)
        {
            this.m_UserEmail=p_UserName;
            this.LoadFromDB(0);

        }
        public DBUser(int p_UserID)
        {
            this.m_UserID=p_UserID;
            this.LoadFromDB(1);
        }
        public DBUser(string p_username,string p_password)
        {
            this.m_UserName=p_username;
            this.m_Password=p_password;
            this.LoadFromDB(2);
        }
        public DBUser(string p_UserName,string p_Password,Sex p_UserSex,string p_UserEmail,string p_UserTitle)
        {
            this.m_Password=p_Password;
            this.m_UserEmail=p_UserEmail;
            this.m_UserName=p_UserName;
            this.m_UserSex=p_UserSex;
            this.m_UserTitle=p_UserTitle;
            this.m_UserID=this.InserIntoDB();
        }
        private int InserIntoDB()
        {
            int result=-1;
            try
            {
                Command command=new Command(DBGlobal.DSN);
                command.CommandText=DBGlobal.AddNewUser;
                command.Parameter["Username"]=this.m_UserName;
                command.Parameter["Password"]=this.m_Password;
                command.Parameter["UserSex"]=(int)this.m_UserSex;
                command.Parameter["UserEmail"]=this.m_UserEmail;
                command.Parameter["UserTitle"]=this.m_UserTitle;
                command.ReturnType=ResultType.NoResult;
                command.Execute();
                command.CommandText=DBGlobal.SelectCurrentUserID;
                command.ReturnType=ResultType.DataReader;
                System.Data.IDataReader dr=(System.Data.IDataReader)command.Execute();
                dr.Read();
                result=dr.GetInt32(0);
                dr.Close();
            }
            catch
            {
                throw new Exception("Cannot Add new User");
            }
            return result;

        }
        private void LoadFromDB(int p_Type)
        {
            
            try
            {
                Command command=new Command(DBGlobal.DSN);
                switch(p_Type)
                {
                    case 0:
                        command.CommandText=DBGlobal.SelectUserByName;
                        command.Parameter["UserName"]=this.m_UserName;
                        break;
                    case 1:
                        command.CommandText=DBGlobal.SelectUserByID;
                        command.Parameter["UserID"]=this.m_UserID;
                        break;
                    case 2:
                        command.CommandText=DBGlobal.SelectUserByNameAndPassword;
                        command.Parameter["username"]=this.m_UserName;
                        command.Parameter["password"]=this.m_Password;
                        break;
                    default:
                        throw new Exception("Error Invode LoadFromDB() method!");
                }

                
                System.Data.IDataReader dr=(System.Data.IDataReader)command.Execute();
                if(dr.Read())
                {
                    this.m_Password=dr["password"].ToString();
                    this.m_UserEmail=dr["useremail"].ToString();
                    this.m_UserID=System.Convert.ToInt32(dr["userid"].ToString());
                    this.m_UserName=dr["username"].ToString();
                    this.m_UserSex=(Sex)System.Convert.ToInt32(dr["usersex"].ToString());
                    this.m_UserTitle=dr["usertitle"].ToString();


                }
                else
                {
                    throw new Exception("Error to Read userInfo!");
                }
                dr.Close();
            }
            catch
            {
                throw new Exception("Error when load user's Info");
            }
        }
        public int UserID
        {
            get
            {
                return this.m_UserID;
            }
            set
            {
                this.m_UserID=value;
            }
        }
        public string UserName
        {
            get
            {
                return this.m_UserName;
            }
            set
            {
                this.m_UserName=value;
            }
        }
        public string Password
        {
            get
            {
                return this.m_Password;
            }
            set
            {
                this.m_Password=value;
            }
        }
        public Sex UserSex
        {
            get
            {
                return this.m_UserSex;
            }
            set
            {
                this.m_UserSex=value;
            }
        }
        public string UserEmail
        {
            get
            {
                return this.m_UserEmail;
            }
            set
            {
                this.m_UserEmail=value;
            }
        }
        public string UserTitle
        {
            get
            {
                return this.m_UserTitle;
            }
            set
            {
                this.m_UserTitle=value;
            }
        }
        public System.Collections.ArrayList getMyCourse()
        {
            System.Collections.ArrayList result=null;
            return result;
        }


    }
}
 

• ·身份证函数 查看身份证地区信息
• ·VS2008 第一次安装心得及使用
• ·ASP.NET 2.0跨网页提交的三法
• ·编程实例 WebGroupBox(Aspx控件)
• ·asp.net mvc脚手架代码生成工具
• ·用独立的DLL来存储图片(资源文件)
• ·ASP.NET中多国语言的实现方法
• ·实例 .net生成静态页方法总结
• ·ASP.NET控件学习笔记之ViewState
• ·用递归在TreeView价节点
• ·经验总结 关于.NET 中的Event机制
• ·.NET应用程序开发标准化(z)
• ·在DataTable中查询应该注意的问题
• ·LINQ 中调用存储过程自动绑定列名
• ·如何用.NET技术在线生成网站LOGO
• ·对于访问IIS元数据库失败的解决