/// <summary> /// 更新用户组信息 /// </summary> /// <param name="info">用户组信息</param> public static void UpdateUserGroup(UserGroupInfo info) { DatabaseProvider.GetInstance().UpdateUserGroup(info); }
/// <summary> /// 创建用户组信息 /// </summary> /// <param name="userGroupInfo">用户组信息</param> public static void CreateUserGroup(UserGroupInfo userGroupInfo) { DatabaseProvider.GetInstance().AddUserGroup(userGroupInfo); }
public void UpdateUserGroup(UserGroupInfo userGroupInfo) { DbParameter[] parms = { DbHelper.MakeInParam("@Radminid",(DbType)SqlDbType.Int,4,(userGroupInfo.Groupid == 1) ? 1 : userGroupInfo.Radminid), DbHelper.MakeInParam("@Grouptitle",(DbType)SqlDbType.NVarChar,50, Utils.RemoveFontTag(userGroupInfo.Grouptitle)), DbHelper.MakeInParam("@Creditshigher",(DbType)SqlDbType.Int,4,userGroupInfo.Creditshigher), DbHelper.MakeInParam("@Creditslower",(DbType)SqlDbType.Int,4, userGroupInfo.Creditslower), DbHelper.MakeInParam("@Stars",(DbType)SqlDbType.Int,4,userGroupInfo.Stars), DbHelper.MakeInParam("@Color",(DbType)SqlDbType.Char,7,userGroupInfo.Color), DbHelper.MakeInParam("@Groupavatar",(DbType)SqlDbType.NVarChar,60,userGroupInfo.Groupavatar), DbHelper.MakeInParam("@Readaccess",(DbType)SqlDbType.Int,4,userGroupInfo.Readaccess), DbHelper.MakeInParam("@Allowvisit",(DbType)SqlDbType.Int,4,userGroupInfo.Allowvisit), DbHelper.MakeInParam("@Allowpost",(DbType)SqlDbType.Int,4,userGroupInfo.Allowpost), DbHelper.MakeInParam("@Allowreply",(DbType)SqlDbType.Int,4,userGroupInfo.Allowreply), DbHelper.MakeInParam("@Allowpostpoll",(DbType)SqlDbType.Int,4,userGroupInfo.Allowpostpoll), DbHelper.MakeInParam("@Allowdirectpost",(DbType)SqlDbType.Int,4,userGroupInfo.Allowdirectpost), DbHelper.MakeInParam("@Allowgetattach",(DbType)SqlDbType.Int,4,userGroupInfo.Allowgetattach), DbHelper.MakeInParam("@Allowpostattach",(DbType)SqlDbType.Int,4,userGroupInfo.Allowpostattach), DbHelper.MakeInParam("@Allowvote",(DbType)SqlDbType.Int,4,userGroupInfo.Allowvote), DbHelper.MakeInParam("@Allowmultigroups",(DbType)SqlDbType.Int,4,userGroupInfo.Allowmultigroups), DbHelper.MakeInParam("@Allowsearch",(DbType)SqlDbType.Int,4,userGroupInfo.Allowsearch), DbHelper.MakeInParam("@Allowavatar",(DbType)SqlDbType.Int,4,userGroupInfo.Allowavatar), DbHelper.MakeInParam("@Allowcstatus",(DbType)SqlDbType.Int,4,userGroupInfo.Allowcstatus), DbHelper.MakeInParam("@Allowuseblog",(DbType)SqlDbType.Int,4,userGroupInfo.Allowuseblog), DbHelper.MakeInParam("@Allowinvisible",(DbType)SqlDbType.Int,4,userGroupInfo.Allowinvisible), DbHelper.MakeInParam("@Allowtransfer",(DbType)SqlDbType.Int,4,userGroupInfo.Allowtransfer), DbHelper.MakeInParam("@Allowsetreadperm",(DbType)SqlDbType.Int,4,userGroupInfo.Allowsetreadperm), DbHelper.MakeInParam("@Allowsetattachperm",(DbType)SqlDbType.Int,4,userGroupInfo.Allowsetattachperm), DbHelper.MakeInParam("@Allowhidecode",(DbType)SqlDbType.Int,4,userGroupInfo.Allowhidecode), DbHelper.MakeInParam("@Allowhtml",(DbType)SqlDbType.Int,4,userGroupInfo.Allowhtml), DbHelper.MakeInParam("@Allowhtmltitle",(DbType)SqlDbType.Int,4,userGroupInfo.Allowhtmltitle), DbHelper.MakeInParam("@Allowcusbbcode",(DbType)SqlDbType.Int,4,userGroupInfo.Allowcusbbcode), DbHelper.MakeInParam("@Allownickname",(DbType)SqlDbType.Int,4,userGroupInfo.Allownickname), DbHelper.MakeInParam("@Allowsigbbcode",(DbType)SqlDbType.Int,4,userGroupInfo.Allowsigbbcode), DbHelper.MakeInParam("@Allowsigimgcode",(DbType)SqlDbType.Int,4,userGroupInfo.Allowsigimgcode), DbHelper.MakeInParam("@Allowviewpro",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewpro), DbHelper.MakeInParam("@Allowviewstats",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewstats), DbHelper.MakeInParam("@Allowtrade",(DbType)SqlDbType.Int,4,userGroupInfo.Allowtrade), DbHelper.MakeInParam("@Allowdiggs",(DbType)SqlDbType.Int,4,userGroupInfo.Allowdiggs), DbHelper.MakeInParam("@Disableperiodctrl",(DbType)SqlDbType.Int,4,userGroupInfo.Disableperiodctrl), DbHelper.MakeInParam("@Allowdebate",(DbType)SqlDbType.Int,4,userGroupInfo.Allowdebate), DbHelper.MakeInParam("@Allowbonus",(DbType)SqlDbType.Int,4,userGroupInfo.Allowbonus), DbHelper.MakeInParam("@Minbonusprice",(DbType)SqlDbType.Int,4,userGroupInfo.Minbonusprice), DbHelper.MakeInParam("@Maxbonusprice",(DbType)SqlDbType.Int,4,userGroupInfo.Maxbonusprice), DbHelper.MakeInParam("@Reasonpm",(DbType)SqlDbType.Int,4,userGroupInfo.Reasonpm), DbHelper.MakeInParam("@Maxprice",(DbType)SqlDbType.SmallInt,2,userGroupInfo.Maxprice), DbHelper.MakeInParam("@Maxpmnum",(DbType)SqlDbType.SmallInt,2,userGroupInfo.Maxpmnum), DbHelper.MakeInParam("@Maxsigsize",(DbType)SqlDbType.SmallInt,2,userGroupInfo.Maxsigsize), DbHelper.MakeInParam("@Maxattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.Maxattachsize), DbHelper.MakeInParam("@Maxsizeperday",(DbType)SqlDbType.Int,4,userGroupInfo.Maxsizeperday), DbHelper.MakeInParam("@Attachextensions",(DbType)SqlDbType.Char,100,userGroupInfo.Attachextensions), DbHelper.MakeInParam("@Maxspaceattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.Maxspaceattachsize), DbHelper.MakeInParam("@Maxspacephotosize",(DbType)SqlDbType.Int,4,userGroupInfo.Maxspacephotosize), DbHelper.MakeInParam("@Groupid",(DbType)SqlDbType.Int,4,userGroupInfo.Groupid), //DbHelper.MakeInParam("@Maxfriendscount",(DbType)SqlDbType.Int,4,userGroupInfo.MaxFriendsCount), DbHelper.MakeInParam("@ModNewTopics",(DbType)SqlDbType.SmallInt,2,userGroupInfo.ModNewTopics), DbHelper.MakeInParam("@ModNewPosts",(DbType)SqlDbType.SmallInt,2,userGroupInfo.ModNewPosts), DbHelper.MakeInParam("@Ignoreseccode",(DbType)SqlDbType.Int,4,userGroupInfo.Ignoreseccode) }; DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, string.Format("{0}updateusergroup", BaseConfigs.GetTablePrefix), parms); }
/// <summary> /// 获得用户组数据 /// </summary> /// <returns>用户组数据</returns> public static List<UserGroupInfo> GetUserGroupList() { DataTable dt = GetUserGroupForDataTable(); List<UserGroupInfo> userGruopInfoList = new List<UserGroupInfo>(); foreach (DataRow dr in dt.Rows) { UserGroupInfo info = new UserGroupInfo(); info.Groupid = TypeConverter.StrToInt(dr["groupid"].ToString()); info.Radminid = TypeConverter.StrToInt(dr["radminid"].ToString()); info.Type = TypeConverter.StrToInt(dr["type"].ToString()); info.System = TypeConverter.StrToInt(dr["system"].ToString()); info.Color = dr["color"].ToString().Trim(); info.Grouptitle = dr["grouptitle"].ToString().Trim(); info.Creditshigher = TypeConverter.StrToInt(dr["creditshigher"].ToString()); info.Creditslower = TypeConverter.StrToInt(dr["creditslower"].ToString()); info.Stars = TypeConverter.StrToInt(dr["stars"].ToString()); info.Groupavatar = dr["groupavatar"].ToString(); info.Readaccess = TypeConverter.StrToInt(dr["readaccess"].ToString()); info.Allowvisit = TypeConverter.StrToInt(dr["allowvisit"].ToString()); info.Allowpost = TypeConverter.StrToInt(dr["allowpost"].ToString()); info.Allowreply = TypeConverter.StrToInt(dr["allowreply"].ToString()); info.Allowpostpoll = TypeConverter.StrToInt(dr["allowpostpoll"].ToString()); info.Allowdirectpost = TypeConverter.StrToInt(dr["allowdirectpost"].ToString()); info.Allowgetattach = TypeConverter.StrToInt(dr["allowgetattach"].ToString()); info.Allowpostattach = TypeConverter.StrToInt(dr["allowpostattach"].ToString()); info.Allowvote = TypeConverter.StrToInt(dr["allowvote"].ToString()); info.Allowmultigroups = TypeConverter.StrToInt(dr["allowmultigroups"].ToString()); info.Allowsearch = TypeConverter.StrToInt(dr["allowsearch"].ToString()); info.Allowavatar = TypeConverter.StrToInt(dr["allowavatar"].ToString()); info.Allowcstatus = TypeConverter.StrToInt(dr["allowcstatus"].ToString()); info.Allowuseblog = TypeConverter.StrToInt(dr["allowuseblog"].ToString()); info.Allowinvisible = TypeConverter.StrToInt(dr["allowinvisible"].ToString()); info.Allowtransfer = TypeConverter.StrToInt(dr["allowtransfer"].ToString()); info.Allowsetreadperm = TypeConverter.StrToInt(dr["allowsetreadperm"].ToString()); info.Allowsetattachperm = TypeConverter.StrToInt(dr["allowsetattachperm"].ToString()); info.Allowhidecode = TypeConverter.StrToInt(dr["allowhidecode"].ToString()); info.Allowhtmltitle = TypeConverter.StrToInt(dr["allowhtmltitle"].ToString()); info.Allowhtml = TypeConverter.StrToInt(dr["allowhtml"].ToString()); info.Allowcusbbcode = TypeConverter.StrToInt(dr["allowcusbbcode"].ToString()); info.Allownickname = TypeConverter.StrToInt(dr["allownickname"].ToString()); info.Allowsigbbcode = TypeConverter.StrToInt(dr["allowsigbbcode"].ToString()); info.Allowsigimgcode = TypeConverter.StrToInt(dr["allowsigimgcode"].ToString()); info.Allowviewpro = TypeConverter.StrToInt(dr["allowviewpro"].ToString()); info.Allowviewstats = TypeConverter.StrToInt(dr["allowviewstats"].ToString()); info.Disableperiodctrl = TypeConverter.StrToInt(dr["disableperiodctrl"].ToString()); info.Reasonpm = TypeConverter.StrToInt(dr["reasonpm"].ToString()); info.Maxprice = TypeConverter.StrToInt(dr["maxprice"].ToString()); info.Maxpmnum = TypeConverter.StrToInt(dr["maxpmnum"].ToString()); info.Maxsigsize = TypeConverter.StrToInt(dr["maxsigsize"].ToString()); info.Maxattachsize = TypeConverter.StrToInt(dr["maxattachsize"].ToString()); info.Maxsizeperday = TypeConverter.StrToInt(dr["maxsizeperday"].ToString()); info.Attachextensions = dr["attachextensions"].ToString().Trim(); info.Raterange = dr["raterange"].ToString().Trim(); info.Allowspace = TypeConverter.StrToInt(dr["allowspace"].ToString()); info.Maxspaceattachsize = TypeConverter.StrToInt(dr["maxspaceattachsize"].ToString()); info.Maxspacephotosize = TypeConverter.StrToInt(dr["maxspacephotosize"].ToString()); info.Allowbonus = TypeConverter.StrToInt(dr["allowbonus"].ToString()); info.Allowdebate = TypeConverter.StrToInt(dr["allowdebate"].ToString()); info.Minbonusprice = TypeConverter.StrToInt(dr["minbonusprice"].ToString()); info.Maxbonusprice = TypeConverter.StrToInt(dr["maxbonusprice"].ToString()); info.Allowtrade = TypeConverter.StrToInt(dr["allowtrade"].ToString()); info.Allowdiggs = TypeConverter.StrToInt(dr["allowdiggs"].ToString()); //info.MaxFriendsCount = TypeConverter.StrToInt(dr["maxfriendscount"].ToString()); info.ModNewTopics = TypeConverter.StrToInt(dr["modnewtopics"].ToString()); info.ModNewPosts = TypeConverter.StrToInt(dr["modnewposts"].ToString()); info.Ignoreseccode = TypeConverter.ObjectToInt(dr["ignoreseccode"]); userGruopInfoList.Add(info); } return userGruopInfoList; }
public void UpdateOnlineList(UserGroupInfo userGroupInfo) { DbParameter[] parms = { DbHelper.MakeInParam("@groupid", (DbType)SqlDbType.Int, 4, userGroupInfo.Groupid), DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 50, Utils.RemoveFontTag(userGroupInfo.Grouptitle)) }; DbHelper.ExecuteNonQueryInMasterDB(CommandType.StoredProcedure, string.Format("{0}updateonlinelist", BaseConfigs.GetTablePrefix), parms); }