usersqldataprovider.cs

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

        }

        public override void InsertUserInfo(Components.Components.User user)
        {
            string sql = string.Empty;
            string sqlinsert = string.Empty;
            sql = "insert into DoNetBbs_UserInfo (";
            sqlinsert += ") values (";
            sql += "UserName,";
            sqlinsert += "'" + user.UserName + "',";
            sql += "UserNickName,";
            sqlinsert += "'" + user.UserNickName + "',";
            sql += "UserPassWord,";
            sqlinsert += "'" + user.UserPassWord + "',";
            sql += "UserPassWordAnswer,";
            sqlinsert += "'" + user.UserPassWordAnswer + "',";
            sql += "UserEmail,";
            sqlinsert += "'" + user.UserEmail + "',";
            sql += "UserRecommendUserID,";
            sqlinsert += "'" + user.UserRecommendUserID + "',";
            sql += "UserSex,";
            sqlinsert += "'" + user.UserSex + "',";
            sql += "UserBirthday,";
            sqlinsert += "'" + user.UserBirthday + "',";
            sql += "UserTrueName,";
            sqlinsert += "'" + user.UserTrueName + "',";
            sql += "UserComeFrom,";
            sqlinsert += "'" + user.UserComeFrom + "',";
            sql += "UserContactAddress,";
            sqlinsert += "'" + user.UserContactAddress + "',";
            sql += "UserCode,";
            sqlinsert += "'" + user.UserCode + "',";
            sql += "UserContactTel,";
            sqlinsert += "'" + user.UserContactTel + "',";
            sql += "UserMobile,";
            sqlinsert += "'" + user.UserMobile + "',";
            sql += "UserOICQ,";
            sqlinsert += "'" + user.UserOICQ + "',";
            sql += "UserIdCard,";
            sqlinsert += "'" + user.UserIdCard + "',";
            sql += "UserMaritalStatus,";
            sqlinsert += "'" + user.UserMaritalStatus + "',";
            sql += "UserWorkUnit,";
            sqlinsert += "'" + user.UserWorkUnit + "',";
            sql += "UserSchool,";
            sqlinsert += "'" + user.UserSchool + "',";
            sql += "UserSign,";
            sqlinsert += "'" + user.UserSign + "',";
            sql += "UserAbout,";
            sqlinsert += "'" + user.UserAbout + "',";
            sql += "UserFace,";
            sqlinsert += "'" + user.UserFace + "',";
            sql += "UserLastIP,";
            sqlinsert += "'" + user.UserLastIP + "',";
            sql += "UserPrivacy,";
            sqlinsert += "'" + user.UserPrivacy + "',";
            sql += "UserFalse,";
            sqlinsert += "'" + user.UserFalse + "',";
            sql += "UserRegTime,";
            sqlinsert += "'" + user.UserRegTime + "',";
            sql += "UserLastLoginTime,";
            sqlinsert += "'" + user.UserLastLoginTime + "',";
            sql += "UserLoginNumber,";
            sqlinsert += "'" + user.UserLoginNumber + "',";
            sql += "UserOnlineTime,";
            sqlinsert += "'" + user.UserOnlineTime + "',";
            sql += "UserLastActTime,";
            sqlinsert += "'" + user.UserLastActTime + "',";
            sql += "UserPoint,";
            sqlinsert += "'" + user.UserPoint + "',";
            sql += "UserPrestige,";
            sqlinsert += "'" + user.UserPrestige + "',";
            sql += "UserRmb,";
            sqlinsert += "'" + user.UserRmb + "',";
            sql += "UserTicket,";
            sqlinsert += "'" + user.UserTicket + "',";
            sql += "UserMoney,";
            sqlinsert += "'" + user.UserMoney + "',";
            sql += "UserExp,";
            sqlinsert += "'" + user.UserExp + "',";
            sql += "UserCP,";
            sqlinsert += "'" + user.UserCP + "',";
            sql += "UserOnLineStatic,";
            sqlinsert += "'" + user.UserOnLineStatic + "',";
            sql += "UserGroupID,";
            sqlinsert += "'" + user.UserGroup + "',";
            sql += "UserLevelID,";
            sqlinsert += "'" + user.UserLevelID + "',";
            sql += "UserRole,";
            sqlinsert += "'" + user.UserRole + "',";
            sql += "UserPostNumber,";
            sqlinsert += "'" + user.UserPostNumber + "',";
            sql += "UserTopicNumber,";
            sqlinsert += "'" + user.UserTopicNumber + "',";
            sql += "UserReTopicNumber,";
            sqlinsert += "'" + user.UserReTopicNumber + "',";
            sql += "UserDelTopicNumber,";
            sqlinsert += "'" + user.UserDelTopicNumber + "',";
            sql += "UserWebAddress,";
            sqlinsert += "'" + user.UserWebAddress + "',";
            sql += "UserWebLog,";
            sqlinsert += "'" + user.UserWebLog + "',";
            sql += "UserWebGallery,";
            sqlinsert += "'" + user.UserWebGallery + "',";
            sql += "UserInterests,";
            sqlinsert += "'" + user.UserInterests + "',";
            sql += "UserTrueMoney,";
            sqlinsert += "'" + user.UserTrueMoney + "',";
            sql += "UserReceiveType";
            sqlinsert += "'" + user.UserReceiveType + "'";
            sql += sqlinsert + ")";

            //HttpContext.Current.Response.Write(sql);
            //return;
            DataConnectionHepler.Instance().ExceCuteSql(sql);
        }



        public override DataRow SetUserLevel(int levelID, bool Cach)
        {
            MySql = "select * from DoNetBbs_UserLevel where UserLevelID=" + levelID.ToString() + "";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserLevel-" + levelID.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserLevel");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserLevel");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        public override DataRow SetLastUserLevel(int userPoint, bool Cach)
        {
            MySql = "select * FROM DoNetBbs_UserLevel  where UserLevelPoint<=" + userPoint + " ORDER BY UserLevelPoint DESC";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserLastLevel-" + userPoint.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserLevel");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "DoNetBbs_UserLevel");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }

        public override ArrayList SetUserLevel(bool Cach)
        {
            Components.Components.UserLevel Rs = new Components.Components.UserLevel();
            DataTable dt;
            MySql = "select * from DoNetBbs_UserLevel";
            if (Cach)
            {
                string key = "WebSite-UserLeve-List";
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserLevel");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserLevel");
            }

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    Components.Components.UserLevel _Arraylist = new Components.Components.UserLevel();
                    _Arraylist.SetDataProviders(row);
                    Rs.Arraylist.Add(_Arraylist);
                }
            }
            return Rs.Arraylist;
        }

        public override void DeleteUserLevel(int userLevelID)
        {
            DataConnectionHepler.Instance().ExceCuteSql("delete from DoNetBbs_UserLevel where UserLevelID = " + userLevelID + "");
        }

        public override void InsertUserLevel(Components.Components.UserLevel userLevel)
        {
            string sql = string.Empty;
            string sqlinsert = string.Empty;
            sql = "insert into DoNetBbs_UserLevel (";
            sqlinsert += ") values (";
            sql += "UserLevelImages,";
            sqlinsert += "'" + userLevel.UserLevelImages + "',";
            sql += "UserLevelPoint,";
            sqlinsert += "'" + userLevel.UserLevelPoint + "',";
            sql += "UserLevelTitle";
            sqlinsert += "'" + userLevel.UserLevelTitle + "'";
            sql += sqlinsert + ")";

            //DoNetBbs.DoNetBbsClassHepler.Instance().GetHttpContext().Response.Write(sql);
            //HttpContext.Current.Response.Write("alert('"+sql+"')");
            //return;
            DataConnectionHepler.Instance().ExceCuteSql(sql);
        }

        public override void UpdateUserLevel(Components.Components.UserLevel userLevel)
        {
            MySql = "update DoNetBbs_UserLevel set UserLevelImages='" + userLevel.UserLevelImages + "'";
            MySql += ",UserLevelPoint='" + userLevel.UserLevelPoint + "'";
            MySql += ",UserLevelTitle='" + userLevel.UserLevelTitle + "'";