三层架构用户登录后获取所有的信息

model类



public class usersModel

    {

        private string users_id;         //用户编号ID

        private string users_name;        //用户姓名

        private string role_id;          //角色编号

        private string users_pwd;        //密码

        private int users_sex;           //性别

        private string users_tel;        //联系电话

        private string users_address;    //住址

        private string users_QQ;         //QQ号码

        private string users_emial;      //Eamil

        private string users_promble;    //忘记密码设置的问题

        private string users_answer;     //忘记密码回答问题

        private DateTime users_time;     //注册时间



        public string usersID {

            get { return users_id; }

            set { users_id = value; }

        }

        public string usersName {

            get { return users_name; }

            set { users_name = value; }

        }

        public string roleID {

            get { return role_id; }

            set { role_id = value; }

        }

        public string usersPwd {

            get { return users_pwd; }

            set { users_pwd = value; }

        }

        public int usersSex{

            get { return users_sex; }

            set { users_sex = value; }

        }

        public string usersTel {

            get { return users_tel; }

            set { users_tel = value; }

        }

        public string usersAddress {

            get { return users_address; }

            set { users_address = value; }

        }

        public string usersQQ {

            get { return users_QQ; }

            set { users_QQ = value; }

        }

        public string usersEmial {

            get { return users_emial; }

            set { users_emial = value; }

        }

        public string usersPromble {

            get { return users_promble; }

            set { users_promble = value; }

        }

        public string usersAnswer {

            get { return users_answer; }

            set { users_answer = value; }

        }

        public DateTime usersTime {

            get { return users_time; }

            set { users_time = value; }

        }



DAl类



        public DataTable getUsersInfDal(string sql) {

            SqlConnection con = new SqlConnection(sqlHelp);

            try

            {

                SqlDataAdapter sda = new SqlDataAdapter(sql,con);

                DataTable dt = new DataTable();

                sda.Fill(dt);

           

                return dt;

            }

            catch (Exception Error) {

                throw Error;

            }

            finally{

                con.Close();

                con.Dispose();

            }

        }



BLL类   public DataTable getUsersInfBll(usersModel userID) {

          //  string str = "getUsersInfProce";

            string sql = "select * from users_tb where users_ID='"+userID.usersID+"'";

            usersDal usersD = new usersDal();

            return usersD.getUsersInfDal(sql);

        }





用户登录后，把session过传，在这个页面上需要查询用户所有的信息，都显示在lable控件上代码如下



 string users_id = Session["usersID"].ToString();

         usersModel usersM = new usersModel();

         usersB.getUsersInfBll(usersM);