usersqldataprovider.cs

Dos 以功能个性化和人性化为基础

//===============================================
//　　　　　　　　　　\\\|///                      
//　　　　　　　　　　\\　- -　//                   
//　　　　　　　　　　  ( @ @ )                    
//┏━━━━━━━━━oOOo-(_)-oOOo━━━┓          
//┃                                     ┃
//┃             东 网 原 创！           ┃
//┃      lenlong 作品，请保留此信息！   ┃
//┃      ** [e-mail] **   ┃
//┃                                     ┃
//┃　　　　　　　　　　　　　Dooo　     ┃
//┗━━━━━━━━━ oooD━-(　 )━━━┛
//　　　　　　　　　　 (  )　  ) /
//　　　　　　　　　　　\ (　 (_/
//　　　　　　　　　　　 \_)
//===============================================
using System;
using System.Data;
using System.Text;
using System.Collections;

namespace DataProviders
{
    public class UserSqlDataProvider : UserDataProvider
    {
        private string MySql;
        /// <summary>
        /// 根据用户ID取该用户信息
        /// </summary>
        /// <param name="userID">用户ID</param>
        /// <param name="Cach">是否缓冲</param>
        /// <returns>返回该用户的信息，如果不存在，则返回Null</returns>
        public override DataRow SetUserInfo(int userID, bool Cach)
        {
            MySql = "select * from DoNetBbs_UserInfo where UserID=" + userID.ToString() + "";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserInfo-" + userID.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        public override DataRow SetUserInfo(string userName, bool Cach)
        {
            MySql = "select * from DoNetBbs_UserInfo where UserName='" + userName.ToString() + "'";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserInfo-" + userName.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        public override DataRow SetUserEmailInfo(string userEmail, bool Cach)
        {
            MySql = "select * from DoNetBbs_UserInfo where UserEmail='" + userEmail.ToString() + "'";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserEmailInfo-" + userEmail.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserInfo");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        public override int SetUserListCount(string sql, bool Cach)
        {
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserList-count" + sql.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(sql, 0, 1, "DoNetBbs_UserInfo");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(sql, 0, 1, "DoNetBbs_UserInfo");
            }

            if (dt.Rows.Count > 0)
            {
                return int.Parse(dt.Rows[0][0].ToString());
            }
            else
            {
                return 0;
            }
        }
        public override ArrayList SetUserList(string sql, int index, int count, bool Cach)
        {
            Components.Components.User Rs = new Components.Components.User();
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserInfo-List" + sql.ToString() + "-" + index.ToString() + "-" + count.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(sql, index, count, "DoNetBbs_UserInfo");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(sql, index, count, "DoNetBbs_UserInfo");
            }

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    Components.Components.User _Arraylist = new Components.Components.User();
                    _Arraylist.SetDataProviders(row);
                    Rs.Arraylist.Add(_Arraylist);
                }
            }
            return Rs.Arraylist;
        }
        public override void UpdateUserInfo(Components.Components.User user)
        {
            MySql = "update DoNetBbs_UserInfo set ";
            MySql += " UserName='" + user.UserName + "',";
            MySql += "UserNickName='" + user.UserNickName + "',";
            MySql += "UserPassWord='" + user.UserPassWord + "',";
            MySql += "UserPassWordAnswer='" + user.UserPassWordAnswer + "',";
            MySql += "UserEmail='" + user.UserEmail + "',";
            MySql += "UserRecommendUserID='" + user.UserRecommendUserID + "',";
            MySql += "UserSex='" + user.UserSex + "',";
            MySql += "UserBirthday='" + user.UserBirthday + "',";
            MySql += "UserTrueName='" + user.UserTrueName + "',";
            MySql += "UserComeFrom='" + user.UserComeFrom + "',";
            MySql += "UserContactAddress='" + user.UserContactAddress + "',";
            MySql += "UserCode='" + user.UserCode + "',";
            MySql += "UserContactTel='" + user.UserContactTel + "',";
            MySql += "UserMobile='" + user.UserMobile + "',";
            MySql += "UserOICQ='" + user.UserOICQ + "',";
            MySql += "UserIdCard='" + user.UserIdCard + "',";
            MySql += "UserMaritalStatus='" + user.UserMaritalStatus + "',";
            MySql += "UserWorkUnit='" + user.UserWorkUnit + "',";
            MySql += "UserSchool='" + user.UserSchool + "',";
            MySql += "UserSign='" + user.UserSign + "',";
            MySql += "UserAbout='" + user.UserAbout + "',";
            MySql += "UserFace='" + user.UserFace + "',";
            MySql += "UserLastIP='" + user.UserLastIP + "',";
            MySql += "UserPrivacy='" + user.UserPrivacy + "',";
            MySql += "UserFalse='" + user.UserFalse + "',";
            MySql += "UserRegTime='" + user.UserRegTime + "',";
            MySql += "UserLastLoginTime='" + user.UserLastLoginTime + "',";
            MySql += "UserLoginNumber='" + user.UserLoginNumber + "',";
            MySql += "UserOnlineTime='" + user.UserOnlineTime + "',";
            MySql += "UserLastActTime='" + user.UserLastActTime + "',";
            MySql += "UserPoint='" + user.UserPoint + "',";
            MySql += "UserPrestige='" + user.UserPrestige + "',";
            MySql += "UserRmb='" + user.UserRmb + "',";
            MySql += "UserTicket='" + user.UserTicket + "',";
            MySql += "UserMoney='" + user.UserMoney + "',";
            MySql += "UserExp='" + user.UserExp + "',";
            MySql += "UserCP='" + user.UserCP + "',";
            MySql += "UserOnLineStatic='" + user.UserOnLineStatic + "',";
            MySql += "UserGroupID='" + user.UserGroup + "',";
            MySql += "UserLevelID='" + user.UserLevelID + "',";
            MySql += "UserRole='" + user.UserRole + "',";
            MySql += "UserPostNumber='" + user.UserPostNumber + "',";
            MySql += "UserTopicNumber='" + user.UserTopicNumber + "',";
            MySql += "UserReTopicNumber='" + user.UserReTopicNumber + "',";
            MySql += "UserDelTopicNumber='" + user.UserDelTopicNumber + "',";
            MySql += "UserWebAddress='" + user.UserWebAddress + "',";
            MySql += "UserWebLog='" + user.UserWebLog + "',";
            MySql += "UserWebGallery='" + user.UserWebGallery + "',";
            MySql += "UserInterests='" + user.UserInterests + "',";
            MySql += "UserTrueMoney='" + user.UserTrueMoney + "',";
            MySql += "UserReceiveType='" + user.UserReceiveType + "'";
            MySql += " Where UserID=" + user.UserID + "";
            DataConnectionHepler.Instance().ExceCuteSql(MySql);