userinfo.cs~rfeb9bbc.tmp

数据配置信息 登录数据库为sa 密码123 登录界面的用户信息:shichang 密码:sc

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DAL;
//51_a_s_p_x.c_o_m

namespace UserInfoLib
{
    public class ConfigFile
    {
        public static readonly string stringConnection = System.Configuration.ConfigurationSettings.AppSettings["SrtConnection"];
    }

    public class UserInfo
    {
        //注册信息
      

          
        public string SeleUserName()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);
            SqlParameter[] parms = new SqlParameter[1];
            parms[0] = new SqlParameter("@UserName", this.username);

            return (string)db.ExecuteProcScalar("SeleNameUser", parms);
        }
        private int userqq;
        public int UserQQ
        {
            get
            {
                return userqq;
            }
            set
            {
                userqq = value;
            }
        }
        private string usermsn;
        public string UserMsn
        {
            get
            {
                return usermsn;
            }
            set
            {
                usermsn = value;
            }
        }
        private string useraddress;
        public string UserAddress
        {
            get
            {
                return useraddress;
            }
            set
            {
                useraddress = value;
            }
        }
        private string useremail;
        public string UserEmail
        {
            get
            {
                return useremail;
            }
            set
            {
                useremail = value;
            }
        }
        private string usertel;
        public string YserTel
        {
            get
            {
                return usertel;
            }
            set
            {
                usertel = value;
            }
        }
        private string useryeah;
        public string UserYeah
        {
            get
            {
                return useryeah;
            }
            set
            {
                useryeah = value;
            }
        }
        private int userage;
        public int UserAge
        {
            get
            {
                return userage;
            }
            set
            {
                userage = value;
            }
        }
        private string userlable;
        public string UserLable
        {
            get
            {
                return userlable;
            }
            set
            {
                userlable = value;
            }
        }
        private string userimage;
        public string UserImage
        {
            get
            {
                return userimage;
            }
            set
            {
                userimage = value;
            }
        }

        //
        public static DataSet Sele()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);
            return db.GetDataSetFromExcuteProc("TextSelect", "ClassText", null);
        }

        public string UserRoot()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@UserName", this.username);
            paras[1] = new SqlParameter("@UserPassword", this.userpassword);
            paras[2] = new SqlParameter("@UserRoot", SqlDbType.Char, 1);
            paras[2].Direction = ParameterDirection.Output;

            return db.UserRoot("UserProc", paras);
        }

        public void Update()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[4];
            paras[0] = new SqlParameter("@UserName", this.username);
            paras[1] = new SqlParameter("@UserPassword", this.userpassword);
            paras[2] = new SqlParameter("@UserLable", this.userlable);
            paras[3] = new SqlParameter("@UserImage", this.userimage);

            db.ExcuteProc("UpdateUser", paras);
        }
        public DataSet SeleUpdate()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[1];
            paras[0] = new SqlParameter("@UserName", this.username);

            return db.GetDataSetFromExcuteProc("seleUpdateUser", "table", paras);
        }
        public int InsertText()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[4];
            paras[0] = new SqlParameter("@UserName", this.username);
            paras[1] = new SqlParameter("@UserTtitle", this.usertitle);
            paras[2] = new SqlParameter("@UserText", this.usertext);
            paras[3] = new SqlParameter("@UserData", this.time);

            return db.ExcuteProc("InsertText", paras);
        }
        public DataSet SeleBack()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[1];
            paras[0] = new SqlParameter("@TextID", this.textID);

            return db.GetDataSetFromExcuteProc("SeleBack", "back", paras);
        }
        //插入回复
        public int InsertBack()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@TextID", this.textID);
            paras[1] = new SqlParameter("@UserName", this.username);
            paras[2] = new SqlParameter("@BackBody", this.backbody);

            return db.ExcuteProc("BackTable", paras);
        }

        public void UpdateText()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@TextID", this.textID);
            paras[1] = new SqlParameter("@UserText", this.usertext);
            paras[2] = new SqlParameter("@UserData", this.time);

            db.ExcuteProc("UpdateClassText", paras);
        }
        public static int CountText()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);
            return ((int)db.ExecuteProcScalar("SeleUserSum", null));

        }
        public static int CountTextSum()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);
            return ((int)db.ExecuteProcScalar("CountText", null));
        }
        public static string SeleGG()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            return (string)db.ExecuteProcScalar("seleGG", null);
        }
        public static DataSet SeleUser()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            return db.GetDataSetFromExcuteProc("NameUser", "User", null);
        }
        public void UpdateSum()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] parms = new SqlParameter[1];
            parms[0] = new SqlParameter("@CountUser", this.textID);

            db.ExcuteProc("UpdateSumUser", parms);
        }
        public void UpdateGG()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] parms = new SqlParameter[1];
            parms[0] = new SqlParameter("@userText", this.usertext);

            db.ExcuteProc("UpdateGG", parms);
        }
        public void DeleText()
        {
            IDataAccess db = Factory.GetDBAccess(AccessDBType.SQL, ConfigFile.stringConnection);

            SqlParameter[] paras = new SqlParameter[1];
            paras[0] = new SqlParameter("@TextID", this.textID);

            db.ExcuteProc("deleText", paras);
        }
        private string backbody;
        public string BackBody
        {
            get
            {
                return backbody;
            }
            set
            {
                backbody = value;
            }
        }

        private int textID;
        public int TextID
        {
            get
            {
                return textID;
            }
            set
            {
                textID = value;
            }
        }

        private DateTime time;
        public DateTime Time
        {
            get
            {
                return time;
            }
            set
            {
                time = value;
            }

        }


        private string usertitle;
        public string UserTitle
        {
            get
            {
                return usertitle;
            }
            set
            {
                usertitle = value;
            }

        }

        private string usertext;
        public string UserText
        {
            get
            {
                return usertext;
            }
            set
            {
                usertext = value;
            }

        }

        private string username;
        public string UserName
        {
            get
            {
                return username;
            }
            set
            {
                username = value;
            }

        }
        private string userpassword;
        public string UserPassword
        {
            get
            {
                return userpassword;
            }
            set
            {
                userpassword = value;
            }

        }
    }
}