usersqldataprovider.cs

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

            MySql += " where UserLevelID='" + userLevel.UserLevelID + "'";
            DataProviders.DataConnectionHepler.Instance().ExceCuteSql(MySql);
        }

        public override DataRow SetUserRole(int roleID, bool Cach)
        {
            MySql = "select * from DoNetBbs_UserRole where UserRoleID=" + roleID.ToString() + "";
            DataTable dt;
            if (Cach)
            {
                string key = "WebSite-UserRole-" + roleID.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "UserRole");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 1, "UserRole");
            }
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0];
            }
            else
            {
                return null;
            }
        }
        public override ArrayList SetUserRole(string roleID, bool Cach)
        {
            Components.Components.UserRole Rs = new Components.Components.UserRole();
            DataTable dt;
            MySql = "select * from DoNetBbs_UserRole where UserRoleID in (" + roleID + ")";
            if (Cach)
            {
                string key = "WebSite-UserRole-List" + roleID.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserRole");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserRole");
            }

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

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

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




        public override void DeleteUserRole(int roleID)
        {
            DataConnectionHepler.Instance().ExceCuteSql("delete from DoNetBbs_UserRole where UserRoleID = " + roleID + "");
        }

        public override void InsertUserRole(Components.Components.UserRole userRole)
        {
            string sql = string.Empty;
            string sqlinsert = string.Empty;
            sql = "insert into DoNetBbs_UserRole (";
            sqlinsert += ") values (";
            sql += "UserRoleFalse,";
            sqlinsert += "'" + userRole.UserRoleFalse + "',";
            sql += "UserRolePostCP,";
            sqlinsert += "'" + userRole.UserRolePostCP + "',";
            sql += "UserRolePostExp,";
            sqlinsert += "'" + userRole.UserRolePostExp + "',";
            sql += "UserRolePostMoney,";
            sqlinsert += "'" + userRole.UserRolePostMoney + "',";
            sql += "UserRolePostPoint,";
            sqlinsert += "'" + userRole.UserRolePostPoint + "',";
            sql += "UserRoleRePostCP,";
            sqlinsert += "'" + userRole.UserRoleRePostCP + "',";
            sql += "UserRoleRePostExp,";
            sqlinsert += "'" + userRole.UserRoleRePostExp + "',";
            sql += "UserRoleRePostMoney,";
            sqlinsert += "'" + userRole.UserRoleRePostMoney + "',";
            sql += "UserRoleRePostPoint,";
            sqlinsert += "'" + userRole.UserRoleRePostPoint + "',";
            sql += "UserRoles,";
            sqlinsert += "'" + userRole.UserRoles + "',";
            sql += "UserRoleTitle";
            sqlinsert += "'" + userRole.UserRoleTitle + "'";
            sql += sqlinsert + ")";

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

        public override void UpadateUserRole(Components.Components.UserRole userRole)
        {
            MySql = "update DoNetBbs_UserRole set UserRoleFalse='" + userRole.UserRoleFalse + "'";
            MySql += ",UserRolePostCP='" + userRole.UserRolePostCP + "'";
            MySql += ",UserRolePostExp='" + userRole.UserRolePostExp + "'";
            MySql += ",UserRolePostMoney='" + userRole.UserRolePostMoney + "'";
            MySql += ",UserRolePostPoint='" + userRole.UserRolePostPoint + "'";
            MySql += ",UserRoleRePostCP='" + userRole.UserRoleRePostCP + "'";
            MySql += ",UserRoleRePostExp='" + userRole.UserRoleRePostExp + "'";
            MySql += ",UserRoleRePostMoney='" + userRole.UserRoleRePostMoney + "'";
            MySql += ",UserRoleRePostPoint='" + userRole.UserRoleRePostPoint + "'";
            MySql += ",UserRoles='" + userRole.UserRoles + "'";
            MySql += ",UserRoleTitle='" + userRole.UserRoleTitle + "'";
            MySql += " where UserRoleID=" + userRole.UserRoleID + "";
            DataProviders.DataConnectionHepler.Instance().ExceCuteSql(MySql);
        }






        public override ArrayList SetUserGroup(string groupID, bool Cach)
        {
            Components.Components.UserGroup Rs = new Components.Components.UserGroup();
            DataTable dt;
            MySql = "select * from DoNetBbs_UserGroup where UserGroupID in (" + groupID + ")";
            if (Cach)
            {
                string key = "WebSite-UserGroup-List" + groupID.ToString();
                DataTable _cachetable = Components.CsCache.Get(key) as DataTable;
                if (_cachetable == null)
                {
                    dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserGroup");
                    Components.CsCache.Insert(key, dt, null);
                }
                else
                {
                    dt = _cachetable;
                }
            }
            else
            {
                dt = DataConnectionHepler.Instance().DataAdapter(MySql, 0, 0, "DoNetBbs_UserGroup");
            }

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


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

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

    }
}