public static string opresult = ""; //存储操作结果或返回给用户的信息
#endregion Fields
#region Methods
/// <summary>
/// 添加用户组信息
/// </summary>
/// <param name="userGroupInfo"></param>
/// <returns></returns>
public static bool AddUserGroupInfo(UserGroupInfo userGroupInfo)
{
try
{
int Creditshigher = userGroupInfo.ug_scorehight;
int Creditslower = userGroupInfo.ug_scorelow;
DataTable dt = SAS.Data.DataProvider.UserGroups.GetUserGroupByCreditsHigherAndLower(Creditshigher, Creditslower);
if (dt.Rows.Count > 0)
return false;
if (userGroupInfo.ug_pg_id == 0 && !SystemCheckCredits("add", ref Creditshigher, ref Creditslower, 0))
return false;
userGroupInfo.ug_scorehight = Creditshigher;
userGroupInfo.ug_scorelow = Creditslower;
Data.DataProvider.UserGroups.CreateUserGroup(userGroupInfo);
Data.DataProvider.OnlineUsers.AddOnlineList(userGroupInfo.ug_name);
Caches.ReSetAdminGroupList();
Caches.ReSetUserGroupList();
return true;
}
catch
{
return false;
}
}
public void GetSetting(ref UserGroupInfo usergroupinfo)
{
usergroupinfo.ug_allowsearch = Convert.ToInt32(allowsearch.SelectedValue);
//usergroupinfo.Allowavatar = Convert.ToInt32(allowavatar.SelectedValue);
usergroupinfo.Reasonpm = Convert.ToInt32(reasonpm.SelectedValue);
usergroupinfo.ug_allowvisit = usergroupright.Items[0].Selected ? 1 : 0; //是否允许访问论坛
usergroupinfo.Allowpost = usergroupright.Items[1].Selected ? 1 : 0; //是否允许发帖
usergroupinfo.Allowreply = usergroupright.Items[2].Selected ? 1 : 0; //是否允许回复
usergroupinfo.Allowpostpoll = usergroupright.Items[3].Selected ? 1 : 0; //是否允许发起投票
usergroupinfo.Allowvote = usergroupright.Items[4].Selected ? 1 : 0; //是否允许参与投票
usergroupinfo.Allowpostattach = usergroupright.Items[5].Selected ? 1 : 0; //是否发布附件
usergroupinfo.ug_allowdown = usergroupright.Items[6].Selected ? 1 : 0; //是否允许下载附件
usergroupinfo.Allowsetreadperm = usergroupright.Items[7].Selected ? 1 : 0; //是否允许设置主题阅读积分权限
usergroupinfo.Allowsetattachperm = usergroupright.Items[8].Selected ? 1 : 0; //是否允许设置附件阅读积分限制
usergroupinfo.Ug_allowhidecode = usergroupright.Items[9].Selected ? 1 : 0; //是否允许使用hide代码
usergroupinfo.Ug_allowcusbbcode = usergroupright.Items[10].Selected ? 1 : 0; //是否允许使用Discuz!NT代码
//usergroupinfo.Allowsigbbcode = usergroupright.Items[11].Selected ? 1 : 0; //签名是否支持Discuz!NT代码
//usergroupinfo.Allowsigimgcode = usergroupright.Items[12].Selected ? 1 : 0; //签名是否支持图片代码
usergroupinfo.Allowviewpro = usergroupright.Items[11].Selected ? 1 : 0; //是否允许查看用户资料
usergroupinfo.Disableperiodctrl = usergroupright.Items[12].Selected ? 1 : 0; //是否不受时间段限制
//usergroupinfo.Allowdebate = usergroupright.Items[15].Selected ? 1 : 0; //是否允许辩论
//usergroupinfo.Allowbonus = usergroupright.Items[16].Selected ? 1 : 0; //是否允许悬赏
//如果勾选允许悬赏
//if (usergroupright.Items[16].Selected)
//{
// usergroupinfo.Minbonusprice = DNTRequest.GetInt("minbonusprice", 0);
// usergroupinfo.Maxbonusprice = DNTRequest.GetInt("maxbonusprice", 0);
//}
//else
//{
// usergroupinfo.Minbonusprice = 0;
// usergroupinfo.Maxbonusprice = 0;
//}
usergroupinfo.Allowviewstats = usergroupright.Items[13].Selected ? 1 : 0; //是否允许查看统计数据
//usergroupinfo.Allowdiggs = usergroupright.Items[18].Selected ? 1 : 0; //是否允许辩论支持
usergroupinfo.Ug_allowhtml = usergroupright.Items[14].Selected ? 1 : 0; //是否允许html
usergroupinfo.ug_allowshop = usergroupright.Items[15].Selected ? 1 : 0; //是否允许交易
//if (MallPluginProvider.GetInstance() != null)
//{
// usergroupinfo.Allowtrade = usergroupright.Items[usergroupright.Items.Count - 1].Selected ? 1 : 0; //是否允许交易
//}
}
public void Bind(UserGroupInfo usergroupinfo)
{
if (usergroupinfo.ug_allowsearch.ToString() == "0") allowsearch.Items[0].Selected = true;
if (usergroupinfo.ug_allowsearch.ToString() == "1") allowsearch.Items[1].Selected = true;
if (usergroupinfo.ug_allowsearch.ToString() == "2") allowsearch.Items[2].Selected = true;
//if (usergroupinfo.Allowavatar >= 0) allowavatar.Items[usergroupinfo.Allowavatar].Selected = true;
reasonpm.Items[usergroupinfo.Reasonpm].Selected = true;
if (usergroupinfo.ug_allowvisit == 1) usergroupright.Items[0].Selected = true; //是否允许访问论坛
if (usergroupinfo.Allowpost == 1) usergroupright.Items[1].Selected = true; //是否允许发帖
if (usergroupinfo.Allowreply == 1) usergroupright.Items[2].Selected = true; //是否允许回复
if (usergroupinfo.Allowpostpoll == 1) usergroupright.Items[3].Selected = true; //是否允许发起投票
if (usergroupinfo.Allowvote == 1) usergroupright.Items[4].Selected = true; //是否允许参与投票
if (usergroupinfo.Allowpostattach == 1) usergroupright.Items[5].Selected = true; //是否发布附件
if (usergroupinfo.ug_allowdown == 1) usergroupright.Items[6].Selected = true; //是否允许下载附件
if (usergroupinfo.Allowsetreadperm == 1) usergroupright.Items[7].Selected = true; //是否允许设置主题阅读积分权限
if (usergroupinfo.Allowsetattachperm == 1) usergroupright.Items[8].Selected = true; //是否允许设置附件阅读积分限制
if (usergroupinfo.Ug_allowhidecode == 1) usergroupright.Items[9].Selected = true; //是否允许使用hide代码
if (usergroupinfo.Ug_allowcusbbcode == 1) usergroupright.Items[10].Selected = true; //是否允许使用Discuz!NT代码
//if (usergroupinfo.Allowsigbbcode == 1) usergroupright.Items[11].Selected = true; //签名是否支持Discuz!NT代码
//if (usergroupinfo.Allowsigimgcode == 1) usergroupright.Items[12].Selected = true; //签名是否支持图片代码
if (usergroupinfo.Allowviewpro == 1) usergroupright.Items[11].Selected = true; //是否允许查看用户资料
if (usergroupinfo.Disableperiodctrl == 1) usergroupright.Items[12].Selected = true; //是否不受时间段限制
//if (usergroupinfo.Allowdebate == 1) usergroupright.Items[15].Selected = true; //是否允许辩论
//if (usergroupinfo.Allowbonus == 1) usergroupright.Items[16].Selected = true; //是否允许悬赏
if (usergroupinfo.Allowviewstats == 1) usergroupright.Items[13].Selected = true; //是否允许查看统计数据
//if (usergroupinfo.Allowdiggs == 1) usergroupright.Items[18].Selected = true; //是否允许辩论支持
if (usergroupinfo.Ug_allowhtml == 1) usergroupright.Items[14].Selected = true; //是否允许html
if (usergroupinfo.ug_allowshop == 1) usergroupright.Items[15].Selected = true; //是否允许交易
//if (MallPluginProvider.GetInstance() != null && usergroupinfo.Allowtrade == 1) usergroupright.Items[usergroupright.Items.Count - 1].Selected = true; //是否允许交易
//string strScript = "<script type='text/javascript'>\r\nfunction insertBonusPrice()\r\n{\r\n\t";
//strScript += "\r\n\tvar tdelement = document.getElementById('" + usergroupright.ClientID + "_16').parentNode;";
//strScript += "\r\n\ttdelement.innerHTML += ' 最低悬赏价格:<input type=\"text\" name=\"minbonusprice\" id=\"minbonusprice\" class=\"FormBase\" onblur=\"this.className=\\'FormBase\\';\" onfocus=\"this.className=\\'FormFocus\\';\" size=\"4\" maxlength=\"5\" value=\"" + usergroupinfo.Minbonusprice + "\"" + (usergroupinfo.Allowbonus == 0 ? " disabled=\"disabled \"" : "") + " />'";
//strScript += "\r\n\ttdelement.innerHTML += ' 最高悬赏价格:<input type=\"text\" name=\"maxbonusprice\" id=\"maxbonusprice\" class=\"FormBase\" onblur=\"this.className=\\'FormBase\\';\" onfocus=\"this.className=\\'FormFocus\\';\" size=\"4\" maxlength=\"5\" value=\"" + usergroupinfo.Maxbonusprice + "\"" + (usergroupinfo.Allowbonus == 0 ? " disabled=\"disabled \"" : "") + " />'";
//strScript += "\r\n}\r\ninsertBonusPrice();\r\n</script>\r\n";
//outscript.Text = strScript;
//usergroupright.Items[16].Attributes.Add("onclick", "bonusPriceSet(this.checked)");
}
/// <summary>
/// 得到用户可以上传的文件类型
/// </summary>
/// <param name="usergroupinfo">当前用户所属用户组信息</param>
/// <param name="forum">所在版块</param>
/// <returns></returns>
public static string GetAllowAttachmentType(UserGroupInfo usergroupinfo, ForumInfo forum)
{
//得到用户可以上传的文件类型
StringBuilder sbAttachmentTypeSelect = new StringBuilder();
if (!usergroupinfo.ug_attachextensions.Trim().Equals(""))
{
sbAttachmentTypeSelect.Append("[id] in (");
sbAttachmentTypeSelect.Append(usergroupinfo.ug_attachextensions);
sbAttachmentTypeSelect.Append(")");
}
if (!forum.Attachextensions.Equals(""))
{
if (sbAttachmentTypeSelect.Length > 0)
sbAttachmentTypeSelect.Append(" AND ");
sbAttachmentTypeSelect.Append("[id] in (");
sbAttachmentTypeSelect.Append(forum.Attachextensions);
sbAttachmentTypeSelect.Append(")");
}
return sbAttachmentTypeSelect.ToString();
}
public void LoadUserGroupInf(int groupid)
{
#region 加载相关组信息
userGroupInfo = AdminUserGroups.AdminGetUserGroupInfo(groupid);
groupTitle.Text = Utils.RemoveFontTag(userGroupInfo.ug_name);
creditshigher.Text = userGroupInfo.ug_scorehight.ToString();
creditslower.Text = userGroupInfo.ug_scorelow.ToString();
stars.Text = userGroupInfo.Stars.ToString();
color.Text = userGroupInfo.ug_color;
groupavatar.Text = userGroupInfo.ug_logo;
readaccess.Text = userGroupInfo.ug_readaccess.ToString();
//maxprice.Text = userGroupInfo.Maxprice.ToString();
maxpmnum.Text = userGroupInfo.Maxpmnum.ToString();
maxsigsize.Text = userGroupInfo.ug_maxsigsize.ToString();
maxattachsize.Text = userGroupInfo.Ug_maxattachsize.ToString();
maxsizeperday.Text = userGroupInfo.Ug_maxsizeperday.ToString();
maxspaceattachsize.Text = userGroupInfo.ug_maxspaceattachsize.ToString();
maxspacephotosize.Text = userGroupInfo.ug_maxspacephotosize.ToString();
attachextensions.SetSelectByID(userGroupInfo.ug_attachextensions.Trim());
if (groupid > 0 && groupid <= 3) radminid.Enabled = false;
radminid.SelectedValue = userGroupInfo.ug_pg_id.ToString();
usergrouppowersetting.Bind(userGroupInfo);
if (radminid.SelectedValue == "1")
{
allowstickthread.Enabled = false;
allowstickthread.SelectedValue = "3";
}
#endregion
}
private void AddUserGroupInf_Click(object sender, EventArgs e)
{
#region 插入相关组信息数据
if (this.CheckCookie())
{
Hashtable ht = new Hashtable();
ht.Add("附件最大尺寸", maxattachsize.Text);
ht.Add("每天最大附件总尺寸", maxsizeperday.Text);
ht.Add("个人空间附件总尺寸", maxspaceattachsize.Text);
ht.Add("相册空间总尺寸", maxspacephotosize.Text);
foreach (DictionaryEntry de in ht)
{
if (!Utils.IsInt(de.Value.ToString()))
{
base.RegisterStartupScript("", "<script>alert('输入错误," + de.Key.ToString() + "只能是0或者正整数');window.location.href='global_editusergroup.aspx';</script>");
return;
}
}
UserGroupInfo userGroupInfo = new UserGroupInfo();
userGroupInfo.ug_isSystem = 0;
//userGroupInfo.Type = 0;
userGroupInfo.ug_readaccess = Convert.ToInt32(readaccess.Text == "" ? "0" : readaccess.Text);
userGroupInfo.ug_pg_id = 0;
userGroupInfo.ug_name = groupTitle.Text;
userGroupInfo.ug_scorehight = Convert.ToInt32(creditshigher.Text);
userGroupInfo.ug_scorelow = Convert.ToInt32(creditslower.Text);
usergrouppowersetting.GetSetting(ref userGroupInfo);
if (userGroupInfo.ug_scorehight >= userGroupInfo.ug_scorelow)
{
base.RegisterStartupScript("", "<script>alert('操作失败, 积分下限必须小于积分上限');</script>");
return;
}
//if (userGroupInfo.Allowbonus == 1 && (userGroupInfo.Minbonusprice >= userGroupInfo.Maxbonusprice))
//{
// base.RegisterStartupScript("", "<script>alert('操作失败, 最低悬赏价格必须小于最高悬赏价格');</script>");
// return;
//}
userGroupInfo.Stars = Convert.ToInt32(stars.Text);
userGroupInfo.ug_color = color.Text;
userGroupInfo.ug_logo = groupavatar.Text;
//userGroupInfo.Maxprice = Convert.ToInt32(maxprice.Text);
userGroupInfo.Maxpmnum = Convert.ToInt32(maxpmnum.Text);
userGroupInfo.ug_maxsigsize = Convert.ToInt32(maxsigsize.Text);
userGroupInfo.Ug_maxattachsize = Convert.ToInt32(maxattachsize.Text);
userGroupInfo.Ug_maxsizeperday = Convert.ToInt32(maxsizeperday.Text);
userGroupInfo.ug_maxspaceattachsize = Convert.ToInt32(maxspaceattachsize.Text);
userGroupInfo.ug_maxspacephotosize = Convert.ToInt32(maxspacephotosize.Text);
userGroupInfo.ug_attachextensions = attachextensions.GetSelectString(",");
//userGroupInfo.Raterange = "";
if (AdminUserGroups.AddUserGroupInfo(userGroupInfo))
{
SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/UserGroupList");
UserGroups.GetUserGroupList();
AdminVistLogs.InsertLog(this.userid, this.username, this.usergroupid, this.grouptitle, this.ip, "后台添加用户组", "组名:" + groupTitle.Text);
base.RegisterStartupScript("PAGE", "window.location.href='global_usergroupgrid.aspx';");
}
else
{
if (AdminUserGroups.opresult != "")
{
base.RegisterStartupScript("", "<script>alert('操作失败,原因:" + AdminUserGroups.opresult + "');window.location.href='global_usergroupgrid.aspx';</script>");
}
else
{
base.RegisterStartupScript("", "<script>alert('操作失败');window.location.href='global_usergroupgrid.aspx';</script>");
}
}
}
#endregion
}
private void UpdateUserGroupInf_Click(object sender, EventArgs e)
{
#region 更新系统管理组信息
if (this.CheckCookie())
{
userGroupInfo = AdminUserGroups.AdminGetUserGroupInfo(SASRequest.GetInt("groupid", -1));
userGroupInfo.ug_isSystem = 0;
userGroupInfo.ug_readaccess = Convert.ToInt32(readaccess.Text);
userGroupInfo.Allowviewstats = 0;
userGroupInfo.Allownickname = 0;
userGroupInfo.Ug_allowhtml = 0;
userGroupInfo.ug_allowshop = 0;
userGroupInfo.ug_allowinvisible = 0;
userGroupInfo.Reasonpm = 0;
if (radminid.SelectedValue == "0") //当未选取任何管理模板时
{
SAS.Logic.AdminGroups.DeleteAdminGroupInfo((short)userGroupInfo.ug_id);
userGroupInfo.ug_pg_id = 0;
}
Users.UpdateUserAdminIdByGroupId(userGroupInfo.ug_pg_id, userGroupInfo.ug_id);
userGroupInfo.ug_name = groupTitle.Text;
userGroupInfo.ug_scorehight = Convert.ToInt32(creditshigher.Text);
userGroupInfo.ug_scorelow = Convert.ToInt32(creditslower.Text);
userGroupInfo.Stars = Convert.ToInt32(stars.Text);
userGroupInfo.ug_color = color.Text;
userGroupInfo.ug_logo = groupavatar.Text;
//userGroupInfo.Maxprice = Convert.ToInt32(maxprice.Text);
userGroupInfo.Maxpmnum = Convert.ToInt32(maxpmnum.Text);
userGroupInfo.ug_maxsigsize = Convert.ToInt32(maxsigsize.Text);
userGroupInfo.Ug_maxattachsize = Convert.ToInt32(maxattachsize.Text);
userGroupInfo.Ug_maxsizeperday = Convert.ToInt32(maxsizeperday.Text);
userGroupInfo.ug_maxspaceattachsize = Convert.ToInt32(maxspaceattachsize.Text);
userGroupInfo.ug_maxspacephotosize = Convert.ToInt32(maxspacephotosize.Text);
userGroupInfo.ug_attachextensions = attachextensions.GetSelectString(",");
usergrouppowersetting.GetSetting(ref userGroupInfo);
if (AdminUserGroups.UpdateUserGroupInfo(userGroupInfo))
{
SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/UserGroupList");
SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/AdminGroupList");
AdminVistLogs.InsertLog(this.userid, this.username, this.usergroupid, this.grouptitle, this.ip, "后台更新系统组", "组ID:" + SASRequest.GetInt("groupid", -1));
base.RegisterStartupScript("PAGE", "window.location.href='global_sysadminusergroupgrid.aspx';");
}
else
{
base.RegisterStartupScript("", "<script>alert('操作失败');window.location.href='global_sysadminusergroupgrid.aspx';</script>");
}
}
#endregion
}
/// <summary>
/// BasePage类构造函数
/// </summary>
public BasePage()
{
config = GeneralConfigs.GetConfig();
//if (SpacePluginProvider.GetInstance() == null)
// config.Enablespace = 0;
if (AlbumPluginProvider.GetInstance() == null)
config.Enablealbum = 0;
//if (MallPluginProvider.GetInstance() == null)
// config.Enablemall = 0;
LoadUrlConfig();
userid = Utils.StrToInt(LogicUtils.GetCookie("userid"), -1);
//清空当前页面查询统计
#if DEBUG
SAS.Data.DbHelper.QueryCount = 0;
SAS.Data.DbHelper.QueryDetail = "";
#endif
// 如果启用游客页面缓存，则对游客输出缓存页
if (userid == -1 && config.Guestcachepagetimeout > 0 && GetUserCachePage(pagename))
return;
AddMetaInfo(config.Seokeywords, config.Seodescription, config.Seohead);
if (config.Nocacheheaders == 1)
{
System.Web.HttpContext.Current.Response.BufferOutput = false;
System.Web.HttpContext.Current.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
System.Web.HttpContext.Current.Response.Cache.SetExpires(DateTime.Now.AddDays(-1));
System.Web.HttpContext.Current.Response.Expires = 0;
System.Web.HttpContext.Current.Response.CacheControl = "no-cache";
System.Web.HttpContext.Current.Response.Cache.SetNoStore();
}
//当为forumlist.aspx或forumindex.aspx,可能出现在线并发问题,这时系统会延时2秒
if ((pagename != "zshy.aspx") && (pagename != "index.aspx"))
oluserinfo = OnlineUsers.UpdateInfo(config.Passwordkey, config.Onlinetimeout);
else
{
try
{
oluserinfo = OnlineUsers.UpdateInfo(config.Passwordkey, config.Onlinetimeout);
}
catch
{
System.Threading.Thread.Sleep(2000);
oluserinfo = OnlineUsers.UpdateInfo(config.Passwordkey, config.Onlinetimeout);
}
}
userid = oluserinfo.Ol_ps_id;
usergroupid = oluserinfo.Ol_ug_id;
username = oluserinfo.Ol_name;
password = oluserinfo.Ol_password;
userkey = password.Length > 16 ? password.Substring(4, 8).Trim() : "";
//lastposttime = oluserinfo.Lastposttime;
lastpostpmtime = oluserinfo.Ol_lastpostpmtime;
lastsearchtime = oluserinfo.Ol_lastsearchtime;
olid = oluserinfo.Ol_id;
//确保头像可以取到
//if (userid > 0)
// useravatar = Avatars.GetAvatarUrl(userid.ToString(), AvatarSize.Small);
if (Utils.InArray(SASRequest.GetString("selectedtemplateid"), Templates.GetValidTemplateIDList()))
templateid = SASRequest.GetInt("selectedtemplateid", 0);
else if (Utils.InArray(Utils.GetCookie(Utils.GetTemplateCookieName()), Templates.GetValidTemplateIDList()))
templateid = Utils.StrToInt(Utils.GetCookie(Utils.GetTemplateCookieName()), config.Templateid);
if (templateid == 0)
templateid = config.Templateid;
pmsound = Utils.StrToInt(LogicUtils.GetCookie("pmsound"), 0);
usergroupinfo = UserGroups.GetUserGroupInfo(usergroupid);
// 取得用户权限id,1管理员,2超版,3版主,0普通组,-1特殊组
useradminid = usergroupinfo.ug_pg_id;
mainnavigation = Navs.GetNavigationString(userid, useradminid);
subnavigation = Navs.GetSubNavigation();
mainnavigationhassub = Navs.GetMainNavigationHasSub();
// 如果论坛关闭且当前用户请求页面不是登录页面且用户非管理员, 则跳转至论坛关闭信息页
if (config.Closed == 1 && pagename != "login.aspx" && pagename != "logout.aspx" && pagename != "register.aspx" && useradminid != 1)
{
ShowMessage(1);
return;
}
onlineusercount = (userid != -1) ? OnlineUsers.GetOnlineAllUserCount() : OnlineUsers.GetCacheOnlineAllUserCount();
//校验用户是否可以访问站点
if (!ValidateUserPermission())
return;
//更新用户在线时长
if (userid != -1)
OnlineUsers.UpdateOnlineTime(config.Oltimespan, userid);
templatepath = Templates.GetTemplateItem(templateid).Directory;
nowdate = Utils.GetDate();
nowtime = Utils.GetTime();
nowdatetime = Utils.GetDateTime();
ispost = SASRequest.IsPost();
isget = SASRequest.IsGet();
link = "";
script = "";
templatelistboxoptions = Caches.GetTemplateListBoxOptionsCache();
string originalTemplate = string.Format("<li><a href=\"###\" onclick=\"window.location.href='{0}showtemplate.aspx?templateid={1}'\">",
"", BaseConfigs.GetSitePath, templateid);
string newTemplate = string.Format("<li class=\"current\"><a href=\"###\" onclick=\"window.location.href='{0}showtemplate.aspx?templateid={1}'\">",
BaseConfigs.GetSitePath, templateid);
templatelistboxoptions = templatelistboxoptions.Replace(originalTemplate, newTemplate);
isseccode = Utils.InArray(pagename, config.Seccodestatus);
//headerad = Advertisements.GetOneHeaderAd("", 0);
//footerad = Advertisements.GetOneFooterAd("", 0);
//校验验证码
if (isseccode && ispost && !ValidateVerifyCode())
return;
//newtopicminute = config.Viewnewtopicminute;
m_starttick = DateTime.Now;
Companies.GetCompanyCountSum(out allcount, out passcount, out todaycount, out waitcount);
ShowPage();
m_processtime = DateTime.Now.Subtract(m_starttick).TotalMilliseconds / 1000;
querycount = SAS.Data.DbHelper.QueryCount;
SAS.Data.DbHelper.QueryCount = 0;
#if DEBUG
querydetail = SAS.Data.DbHelper.QueryDetail;
SAS.Data.DbHelper.QueryDetail = "";
#endif
}
/// <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.ug_id = TypeConverter.StrToInt(dr["ug_id"].ToString());
info.ug_name = dr["ug_name"].ToString();
info.ug_scorehight = TypeConverter.StrToInt(dr["ug_scorehight"].ToString());
info.ug_scorelow = TypeConverter.StrToInt(dr["ug_scorelow"].ToString());
info.ug_logo = dr["ug_logo"].ToString().Trim();
info.ug_readaccess = TypeConverter.StrToInt(dr["ug_readaccess"].ToString().Trim());
info.Ug_allowcusbbcode = TypeConverter.StrToInt(dr["ug_allowcusbbcode"].ToString().Trim());
info.ug_allowvisit = TypeConverter.StrToInt(dr["ug_allowvisit"].ToString());
info.ug_allowcommunity = TypeConverter.StrToInt(dr["ug_allowcommunity"].ToString());
info.ug_allowdown = TypeConverter.StrToInt(dr["ug_allowdown"].ToString());
info.ug_allowup = TypeConverter.StrToInt(dr["ug_allowup"].ToString());
info.ug_allowsearch = TypeConverter.StrToInt(dr["ug_allowsearch"].ToString());
info.ug_allowavatar = TypeConverter.StrToInt(dr["ug_allowavatar"].ToString());
info.ug_allowshop = TypeConverter.StrToInt(dr["ug_allowshop"].ToString());
info.ug_allowinvisible = TypeConverter.StrToInt(dr["ug_allowinvisible"].ToString());
info.Ug_allowhidecode = TypeConverter.StrToInt(dr["ug_allowhidecode"].ToString());
info.Ug_allowhtml = TypeConverter.StrToInt(dr["ug_allowhtml"].ToString());
info.Ug_maxattachsize = TypeConverter.StrToInt(dr["ug_maxattachsize"].ToString());
info.Ug_maxsizeperday = TypeConverter.StrToInt(dr["ug_maxsizeperday"].ToString());
info.ug_attachextensions = dr["ug_attachextensions"].ToString();
info.ug_maxspaceattachsize = TypeConverter.StrToInt(dr["ug_maxspaceattachsize"].ToString());
info.ug_maxspacephotosize = TypeConverter.StrToInt(dr["ug_maxspacephotosize"].ToString());
info.ug_maxsigsize = TypeConverter.StrToInt(dr["ug_maxsigsize"].ToString());
info.ug_pg_id = TypeConverter.StrToInt(dr["ug_pg_id"].ToString());
info.ug_color = dr["ug_color"].ToString();
info.ug_isSystem = TypeConverter.StrToInt(dr["ug_isSystem"].ToString());
info.Allowsetreadperm = TypeConverter.StrToInt(dr["allowsetreadperm"].ToString());
info.Allowpostattach = TypeConverter.StrToInt(dr["allowpostattach"].ToString());
info.Allowsetattachperm = TypeConverter.StrToInt(dr["allowsetattachperm"].ToString());
info.Stars = TypeConverter.StrToInt(dr["stars"].ToString());
info.Allowpost = TypeConverter.StrToInt(dr["allowpost"].ToString());
info.Allowreply = TypeConverter.StrToInt(dr["allowreply"].ToString());
info.Allowpostpoll = TypeConverter.StrToInt(dr["allowpostpoll"].ToString());
info.Allowvote = TypeConverter.StrToInt(dr["allowvote"].ToString());
info.Allownickname = TypeConverter.StrToInt(dr["allownickname"].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.Maxpmnum = TypeConverter.StrToInt(dr["maxpmnum"].ToString());
userGruopInfoList.Add(info);
}
return userGruopInfoList;
}
public void LoadUserGroupInf(int groupid)
{
#region 加载相关组信息
userGroupInfo = AdminUserGroups.AdminGetUserGroupInfo(groupid);
groupTitle.Text = Utils.RemoveFontTag(userGroupInfo.ug_name);
creditshigher.Text = userGroupInfo.ug_scorehight.ToString();
creditslower.Text = userGroupInfo.ug_scorelow.ToString();
stars.Text = userGroupInfo.Stars.ToString();
color.Text = userGroupInfo.ug_color;
groupavatar.Text = userGroupInfo.ug_logo;
readaccess.Text = userGroupInfo.ug_readaccess.ToString();
//maxprice.Text = userGroupInfo.Maxprice.ToString();
maxpmnum.Text = userGroupInfo.Maxpmnum.ToString();
maxsigsize.Text = userGroupInfo.ug_maxsigsize.ToString();
maxattachsize.Text = userGroupInfo.Ug_maxattachsize.ToString();
maxsizeperday.Text = userGroupInfo.Ug_maxsizeperday.ToString();
maxspaceattachsize.Text = userGroupInfo.ug_maxspaceattachsize.ToString();
maxspacephotosize.Text = userGroupInfo.ug_maxspacephotosize.ToString();
if (groupid > 0 && groupid <= 3) radminid.Enabled = false;
radminid.SelectedValue = userGroupInfo.ug_pg_id.ToString();
attachextensions.SetSelectByID(userGroupInfo.ug_attachextensions.Trim());
//设置用户权限组初始化信息
adminGroupInfo = AdminUserGroups.AdminGetAdminGroupInfo(userGroupInfo.ug_id);
usergrouppowersetting.Bind(userGroupInfo);
if (adminGroupInfo != null)
{
//设置管理权限组初始化信息
admingroupright.SelectedIndex = -1;
admingroupright.Items[0].Selected = adminGroupInfo.Alloweditpost == 1;
//admingroupright.Items[1].Selected = adminGroupInfo.Alloweditpoll == 1;
admingroupright.Items[1].Selected = adminGroupInfo.Allowdelpost == 1;
admingroupright.Items[2].Selected = adminGroupInfo.Allowmassprune == 1;
admingroupright.Items[3].Selected = adminGroupInfo.Allowviewip == 1;
admingroupright.Items[4].Selected = adminGroupInfo.Allowedituser == 1;
admingroupright.Items[5].Selected = adminGroupInfo.Allowviewlog == 1;
//admingroupright.Items[7].Selected = adminGroupInfo.Disablepostctrl == 1;
admingroupright.Items[6].Selected = adminGroupInfo.Allowviewrealname == 1;
admingroupright.Items[7].Selected = adminGroupInfo.Allowbanuser == 1;
admingroupright.Items[8].Selected = adminGroupInfo.Allowbanip == 1;
admingroupright.Items[9].Selected = adminGroupInfo.Allowmodpost == 1;
admingroupright.Items[10].Selected = adminGroupInfo.Allowpostannounce == 1;
//GeneralConfigInfo configInfo = GeneralConfigs.GetConfig();
//admingroupright.Items[11].Selected = ("," + configInfo.Reportusergroup + ",").IndexOf("," + groupid + ",") != -1; //是否允许接收举报信息
//admingroupright.Items[admingroupright.Items.Count - 1].Selected = ("," + configInfo.Photomangegroups + ",").IndexOf("," + groupid + ",") != -1;//是否允许管理图片评论
if (adminGroupInfo.Allowstickthread.ToString() != "") allowstickthread.SelectedValue = adminGroupInfo.Allowstickthread.ToString();
}
if (radminid.SelectedValue == "1")
{
allowstickthread.Enabled = false;
allowstickthread.SelectedValue = "3";
}
#endregion
}
/// <summary>
/// 更新在线表
/// </summary>
/// <param name="userGroupInfo"></param>
public void UpdateOnlineList(UserGroupInfo userGroupInfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@groupid", (DbType)SqlDbType.Int, 4, userGroupInfo.ug_id),
DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 50, Utils.RemoveFontTag(userGroupInfo.ug_name))
};
string commandText = string.Format("UPDATE [{0}userGroupIcon] SET [ui_ug_name]=@title WHERE [ui_id]=@groupid", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
public void AddUserGroup(UserGroupInfo userGroupInfo)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@Radminid",(DbType)SqlDbType.Int,4,userGroupInfo.ug_pg_id),
DbHelper.MakeInParam("@Grouptitle",(DbType)SqlDbType.VarChar,200, Utils.RemoveFontTag(userGroupInfo.ug_name)),
DbHelper.MakeInParam("@Creditshigher",(DbType)SqlDbType.Int,4,userGroupInfo.ug_scorehight),
DbHelper.MakeInParam("@Creditslower",(DbType)SqlDbType.Int,4, userGroupInfo.ug_scorelow),
DbHelper.MakeInParam("@Stars",(DbType)SqlDbType.Int,4,userGroupInfo.Stars),
DbHelper.MakeInParam("@Color",(DbType)SqlDbType.Char,7,userGroupInfo.ug_color),
DbHelper.MakeInParam("@Groupavatar",(DbType)SqlDbType.NVarChar,60,userGroupInfo.ug_logo),
DbHelper.MakeInParam("@Readaccess",(DbType)SqlDbType.Int,4,userGroupInfo.ug_readaccess),
DbHelper.MakeInParam("@Allowcommunity",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowcommunity),
DbHelper.MakeInParam("@Allowvisit",(DbType)SqlDbType.Int,4,userGroupInfo.ug_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("@Allowgetattach",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowdown),
DbHelper.MakeInParam("@Allowpostattach",(DbType)SqlDbType.Int,4,userGroupInfo.Allowpostattach),
DbHelper.MakeInParam("@Allowvote",(DbType)SqlDbType.Int,4,userGroupInfo.Allowvote),
DbHelper.MakeInParam("@Allowsearch",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowsearch),
DbHelper.MakeInParam("@Allowavatar",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowavatar),
DbHelper.MakeInParam("@Allowshop",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowshop),
DbHelper.MakeInParam("@Allowinvisible",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowinvisible),
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.Ug_allowhidecode),
DbHelper.MakeInParam("@Allowhtml",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_allowhtml),
DbHelper.MakeInParam("@Allowcusbbcode",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_allowcusbbcode),
DbHelper.MakeInParam("@Allownickname",(DbType)SqlDbType.Int,4,userGroupInfo.Allownickname),
DbHelper.MakeInParam("@Allowviewpro",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewpro),
DbHelper.MakeInParam("@Allowviewstats",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewstats),
DbHelper.MakeInParam("@Disableperiodctrl",(DbType)SqlDbType.Int,4,userGroupInfo.Disableperiodctrl),
DbHelper.MakeInParam("@Reasonpm",(DbType)SqlDbType.Int,4,userGroupInfo.Reasonpm),
DbHelper.MakeInParam("@Maxpmnum",(DbType)SqlDbType.SmallInt,2,userGroupInfo.Maxpmnum),
DbHelper.MakeInParam("@Maxsigsize",(DbType)SqlDbType.SmallInt,2,userGroupInfo.ug_maxsigsize),
DbHelper.MakeInParam("@Maxattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_maxattachsize),
DbHelper.MakeInParam("@Maxsizeperday",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_maxsizeperday),
DbHelper.MakeInParam("@Attachextensions",(DbType)SqlDbType.Char,100,userGroupInfo.ug_attachextensions),
DbHelper.MakeInParam("@Maxspaceattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.ug_maxspaceattachsize),
DbHelper.MakeInParam("@Maxspacephotosize",(DbType)SqlDbType.Int,4,userGroupInfo.ug_maxspacephotosize)
};
string commandText = string.Format("INSERT INTO [{0}userGroup] ([ug_pg_id],[ug_name],[ug_scorehight],[ug_scorelow],[stars] ,[ug_color],[ug_logo], " +
"[ug_readaccess],[ug_allowcommunity],[ug_allowvisit],[allowpost],[allowreply],[allowpostpoll], [ug_allowdown]," +
"[allowpostattach],[allowvote],[ug_allowsearch],[ug_allowavatar],[ug_allowshop],[ug_allowinvisible]," +
"[allowsetreadperm],[[allowsetattachperm],[Ug_allowhidecode],[Ug_allowhtml],[Ug_allowcusbbcode]," +
"[allownickname],[allowviewpro],[allowviewstats],[disableperiodctrl],[reasonpm],[maxpmnum],[ug_maxsigsize]," +
"[Ug_maxattachsize],[Ug_maxsizeperday],[ug_attachextensions],[ug_maxspaceattachsize],[ug_maxspacephotosize]) VALUES(" +
"@Radminid,@Grouptitle,@Creditshigher,@Creditslower,@Stars,@Color,@Groupavatar,@Readaccess,@Allowcommunity,@Allowvisit,@Allowpost," +
"@Allowreply,@Allowpostpoll,@Allowgetattach,@Allowpostattach,@Allowvote,@Allowsearch,@Allowavatar,@Allowshop," +
"@Allowinvisible,@Allowsetreadperm,@Allowsetattachperm,@Allowhidecode,@Allowhtml,@Allowcusbbcode,@Allownickname," +
"@Allowviewpro,@Allowviewstats,@Disableperiodctrl,@Reasonpm,@Maxpmnum,@Maxsigsize,@Maxattachsize," +
"@Maxsizeperday,@Attachextensions,@Maxspaceattachsize,@Maxspacephotosize)",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <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);
}
/// <summary>
/// 更新用户组信息
/// </summary>
/// <param name="userGroupInfo">用户组信息</param>
/// <returns></returns>
public static bool UpdateUserGroupInfo(UserGroupInfo userGroupInfo)
{
int Creditshigher = userGroupInfo.ug_scorehight;
int Creditslower = userGroupInfo.ug_scorelow;
if ((userGroupInfo.ug_id >= 9) && (userGroupInfo.ug_pg_id == 0))
{
//当已存在的用户组积分上下限不是当前组的时候,则不允许编辑
DataTable dt = SAS.Data.DataProvider.UserGroups.GetUserGroupByCreditsHigherAndLower(Creditshigher, Creditslower);
if (dt.Rows.Count > 0 && userGroupInfo.ug_id.ToString() != dt.Rows[0][0].ToString())
return false;
if (!SystemCheckCredits("update", ref Creditshigher, ref Creditslower, userGroupInfo.ug_id))
return false;
}
UserGroups.UpdateUserGroup(userGroupInfo);
SAS.Data.DataProvider.UserGroups.UpdateOnlineList(userGroupInfo);
Caches.ReSetAdminGroupList();
Caches.ReSetUserGroupList();
return true;
}
private void UpdateUserGroupInf_Click(object sender, EventArgs e)
{
#region 更新管理组信息
if (this.CheckCookie())
{
Hashtable ht = new Hashtable();
ht.Add("附件最大尺寸", maxattachsize.Text);
ht.Add("每天最大附件总尺寸", maxsizeperday.Text);
ht.Add("个人空间附件总尺寸", maxspaceattachsize.Text);
ht.Add("相册空间总尺寸", maxspacephotosize.Text);
foreach (DictionaryEntry de in ht)
{
if (!Utils.IsInt(de.Value.ToString()))
{
base.RegisterStartupScript("", "<script>alert('输入错误," + de.Key.ToString() + "只能是0或者正整数');window.location.href='global_editadminusergroup.aspx';</script>");
return;
}
}
userGroupInfo = AdminUserGroups.AdminGetUserGroupInfo(SASRequest.GetInt("groupid", -1));
userGroupInfo.ug_isSystem = 0;
//userGroupInfo.Type = 0;
userGroupInfo.ug_readaccess = Convert.ToInt32(readaccess.Text);
int selectradminid = Convert.ToInt32(radminid.SelectedValue);
//对于当前用户组中,有管理权限的,则设置管理权限
if (selectradminid > 0 && selectradminid <= 3)
{
adminGroupInfo = new AdminGroupInfo();
adminGroupInfo.Admingid = (short)userGroupInfo.ug_id;
adminGroupInfo.AdminGroupName = "";
//插入相应的管理组
adminGroupInfo.Alloweditpost = BoolToByte(admingroupright.Items[0].Selected);
//adminGroupInfo.Alloweditpoll = BoolToByte(admingroupright.Items[1].Selected);
adminGroupInfo.Allowstickthread = (byte)Convert.ToInt16(allowstickthread.SelectedValue);
adminGroupInfo.Allowmodpost = 0;
adminGroupInfo.Allowdelpost = BoolToByte(admingroupright.Items[1].Selected);
adminGroupInfo.Allowmassprune = BoolToByte(admingroupright.Items[2].Selected);
//adminGroupInfo.Allowrefund = 0;
adminGroupInfo.Allowcensorword = 0; ;
adminGroupInfo.Allowviewip = BoolToByte(admingroupright.Items[3].Selected);
adminGroupInfo.Allowbanip = 0;
adminGroupInfo.Allowedituser = BoolToByte(admingroupright.Items[4].Selected);
adminGroupInfo.Allowmoduser = 0;
adminGroupInfo.Allowbanuser = 0;
adminGroupInfo.Allowpostannounce = 0;
adminGroupInfo.Allowviewlog = BoolToByte(admingroupright.Items[5].Selected);
//adminGroupInfo.Disablepostctrl = BoolToByte(admingroupright.Items[7].Selected);
adminGroupInfo.Allowviewrealname = BoolToByte(admingroupright.Items[6].Selected);
adminGroupInfo.Allowbanuser = BoolToByte(admingroupright.Items[7].Selected);
adminGroupInfo.Allowbanip = BoolToByte(admingroupright.Items[8].Selected);
adminGroupInfo.Allowmodpost = BoolToByte(admingroupright.Items[9].Selected);
adminGroupInfo.Allowpostannounce = BoolToByte(admingroupright.Items[10].Selected);
SAS.Logic.AdminGroups.SetAdminGroupInfo(adminGroupInfo, userGroupInfo.ug_id);
userGroupInfo.ug_pg_id = selectradminid;
}
else
userGroupInfo.ug_pg_id = 0;
AdminGroups.ChangeUserAdminidByGroupid(userGroupInfo.ug_pg_id, userGroupInfo.ug_id);
userGroupInfo.ug_name = groupTitle.Text;
userGroupInfo.ug_scorehight = Convert.ToInt32(creditshigher.Text);
userGroupInfo.ug_scorelow = Convert.ToInt32(creditslower.Text);
userGroupInfo.Stars = Convert.ToInt32(stars.Text);
userGroupInfo.ug_color = color.Text;
userGroupInfo.ug_logo = groupavatar.Text;
//userGroupInfo.Maxprice = Convert.ToInt32(maxprice.Text);
userGroupInfo.Maxpmnum = Convert.ToInt32(maxpmnum.Text);
userGroupInfo.ug_maxsigsize = Convert.ToInt32(maxsigsize.Text);
userGroupInfo.Ug_maxattachsize = Convert.ToInt32(maxattachsize.Text);
userGroupInfo.Ug_maxsizeperday = Convert.ToInt32(maxsizeperday.Text);
userGroupInfo.ug_maxspaceattachsize = Convert.ToInt32(maxspaceattachsize.Text);
userGroupInfo.ug_maxspacephotosize = Convert.ToInt32(maxspacephotosize.Text);
userGroupInfo.ug_attachextensions = attachextensions.GetSelectString(",");
usergrouppowersetting.GetSetting(ref userGroupInfo);
if (AdminUserGroups.UpdateUserGroupInfo(userGroupInfo))
{
#region 是否允许接收举报信息和管理图片评论
GeneralConfigInfo configInfo = GeneralConfigs.GetConfig();
////是否允许接收举报信息
//int groupid = userGroupInfo.ug_id;
//if (admingroupright.Items[13].Selected)
//{
// if (("," + configInfo.Reportusergroup + ",").IndexOf("," + groupid + ",") == -1)
// {
// if (configInfo.Reportusergroup == "")
// {
// configInfo.Reportusergroup = groupid.ToString();
// }
// else
// {
// configInfo.Reportusergroup += "," + groupid.ToString();
// }
// }
//}
//else
//{
// string tempstr = "";
// foreach (string report in configInfo.Reportusergroup.Split(','))
// {
// if (report != groupid.ToString())
// {
// if (tempstr == "")
// {
// tempstr = report;
// }
// else
// {
// tempstr += "," + report;
// }
// }
// }
// configInfo.Reportusergroup = tempstr;
//}
////是否允许管理图片评论
//if (AlbumPluginProvider.GetInstance() != null)
//{
// if (admingroupright.Items[admingroupright.Items.Count - 1].Selected)
// {
// if (("," + configInfo.Photomangegroups + ",").IndexOf("," + groupid + ",") == -1)
// {
// if (configInfo.Photomangegroups == "")
// {
// configInfo.Photomangegroups = groupid.ToString();
// }
// else
// {
// configInfo.Photomangegroups += "," + groupid.ToString();
// }
// }
// }
// else
// {
// string tempstr = "";
// foreach (string photomangegroup in configInfo.Photomangegroups.Split(','))
// {
// if (photomangegroup != groupid.ToString())
// {
// if (tempstr == "")
// {
// tempstr = photomangegroup;
// }
// else
// {
// tempstr += "," + photomangegroup;
// }
// }
// }
// configInfo.Photomangegroups = tempstr;
// }
//}
GeneralConfigs.Serialiaze(configInfo, Server.MapPath("../../config/general.config"));
#endregion
SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/UserGroupList");
AdminVistLogs.InsertLog(this.userid, this.username, this.usergroupid, this.grouptitle, this.ip, "后台更新管理组", "组名:" + groupTitle.Text);
base.RegisterStartupScript("PAGE", "window.location.href='global_adminusergroupgrid.aspx';");
}
else
{
base.RegisterStartupScript("", "<script>alert('操作失败');window.location.href='global_adminusergroupgrid.aspx';</script>");
}
}
#endregion
}
/// <summary>
/// 更新用户组信息
/// </summary>
/// <param name="userGroupInfo">用户组信息</param>
public void UpdateUserGroup(UserGroupInfo userGroupInfo)
{
DbParameter[] parms =
{
DbHelper.MakeInParam("@Radminid",(DbType)SqlDbType.Int,4,(userGroupInfo.ug_id == 1) ? 1 : userGroupInfo.ug_pg_id),
DbHelper.MakeInParam("@Grouptitle",(DbType)SqlDbType.NVarChar,50, Utils.RemoveFontTag(userGroupInfo.ug_name)),
DbHelper.MakeInParam("@Creditshigher",(DbType)SqlDbType.Int,4,userGroupInfo.ug_scorehight),
DbHelper.MakeInParam("@Creditslower",(DbType)SqlDbType.Int,4, userGroupInfo.ug_scorelow),
DbHelper.MakeInParam("@Stars",(DbType)SqlDbType.Int,4,userGroupInfo.Stars),
DbHelper.MakeInParam("@Color",(DbType)SqlDbType.Char,7,userGroupInfo.ug_color),
DbHelper.MakeInParam("@Groupavatar",(DbType)SqlDbType.NVarChar,60,userGroupInfo.ug_logo),
DbHelper.MakeInParam("@Readaccess",(DbType)SqlDbType.Int,4,userGroupInfo.ug_readaccess),
DbHelper.MakeInParam("@Allowcommunity",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowcommunity),
DbHelper.MakeInParam("@Allowvisit",(DbType)SqlDbType.Int,4,userGroupInfo.ug_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("@Allowgetattach",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowdown),
DbHelper.MakeInParam("@Allowpostattach",(DbType)SqlDbType.Int,4,userGroupInfo.Allowpostattach),
DbHelper.MakeInParam("@Allowvote",(DbType)SqlDbType.Int,4,userGroupInfo.Allowvote),
DbHelper.MakeInParam("@Allowsearch",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowsearch),
DbHelper.MakeInParam("@Allowavatar",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowavatar),
DbHelper.MakeInParam("@Allowuseblog",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowshop),
DbHelper.MakeInParam("@Allowinvisible",(DbType)SqlDbType.Int,4,userGroupInfo.ug_allowinvisible),
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.Ug_allowhidecode),
DbHelper.MakeInParam("@Allowhtml",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_allowhtml),
DbHelper.MakeInParam("@Allowcusbbcode",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_allowcusbbcode),
DbHelper.MakeInParam("@Allownickname",(DbType)SqlDbType.Int,4,userGroupInfo.Allownickname),
DbHelper.MakeInParam("@Allowviewpro",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewpro),
DbHelper.MakeInParam("@Allowviewstats",(DbType)SqlDbType.Int,4,userGroupInfo.Allowviewstats),
DbHelper.MakeInParam("@Disableperiodctrl",(DbType)SqlDbType.Int,4,userGroupInfo.Disableperiodctrl),
DbHelper.MakeInParam("@Reasonpm",(DbType)SqlDbType.Int,4,userGroupInfo.Reasonpm),
DbHelper.MakeInParam("@Maxpmnum",(DbType)SqlDbType.SmallInt,2,userGroupInfo.Maxpmnum),
DbHelper.MakeInParam("@Maxsigsize",(DbType)SqlDbType.SmallInt,2,userGroupInfo.ug_maxsigsize),
DbHelper.MakeInParam("@Maxattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_maxattachsize),
DbHelper.MakeInParam("@Maxsizeperday",(DbType)SqlDbType.Int,4,userGroupInfo.Ug_maxsizeperday),
DbHelper.MakeInParam("@Attachextensions",(DbType)SqlDbType.Char,100,userGroupInfo.ug_attachextensions),
DbHelper.MakeInParam("@Maxspaceattachsize",(DbType)SqlDbType.Int,4,userGroupInfo.ug_maxspaceattachsize),
DbHelper.MakeInParam("@Maxspacephotosize",(DbType)SqlDbType.Int,4,userGroupInfo.ug_maxspacephotosize),
DbHelper.MakeInParam("@Groupid",(DbType)SqlDbType.Int,4,userGroupInfo.ug_id)
};
string commandText = string.Format("UPDATE [{0}userGroup] SET [ug_pg_id]=@Radminid,[ug_name]=@Grouptitle,[ug_scorehight]=@Creditshigher," +
"[ug_scorelow]=@Creditslower,[stars]=@Stars,[ug_color]=@Color,[ug_logo]=@Groupavatar,[ug_readaccess]=@Readaccess,[ug_allowcommunity]=@Allowcommunity," +
"[ug_allowvisit]=@Allowvisit,[allowpost]=@Allowpost,[allowreply]=@Allowreply,[allowpostpoll]=@Allowpostpoll, [ug_allowdown]=@Allowgetattach," +
"[allowpostattach]=@Allowpostattach,[allowvote]=@Allowvote,[ug_allowsearch]=@Allowsearch,[ug_allowavatar]=@Allowavatar," +
"[ug_allowshop]=@Allowuseblog,[ug_allowinvisible]=@Allowinvisible,[allowsetreadperm]=@Allowsetreadperm,[allowsetattachperm]=@Allowsetattachperm," +
"[ug_allowhidecode]=@Allowhidecode,[ug_allowhtml]=@Allowhtml,[ug_allowcusbbcode]=@Allowcusbbcode,[allownickname]=@Allownickname,[allowviewpro]=@Allowviewpro," +
"[allowviewstats]=@Allowviewstats,[disableperiodctrl]=@Disableperiodctrl,[reasonpm]=@Reasonpm,[maxpmnum]=@Maxpmnum," +
"[ug_maxsigsize]=@Maxsigsize,[ug_maxattachsize]=@Maxattachsize,[ug_maxsizeperday]=@Maxsizeperday,[ug_attachextensions]=@Attachextensions," +
"[ug_maxspaceattachsize]=@Maxspaceattachsize,[ug_maxspacephotosize]=@Maxspacephotosize WHERE [ug_id]=@Groupid",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 上传附件权限控制
/// </summary>
/// <param name="forum">版块信息</param>
/// <param name="usergroupinfo">当前用户的用户组信息</param>
/// <param name="userId">当前用户Id</param>
/// <returns></returns>
public static bool PostAttachAuthority(ForumInfo forum, UserGroupInfo userGroupInfo, int userId, ref string msg)
{
if (!Forums.AllowPostAttachByUserID(forum.Permuserlist, userId))
{
if (!Forums.AllowPostAttach(forum.Postattachperm, userGroupInfo.ug_id))
{
msg = "您没有在该版块上传附件的权限";
return false;
}
else if (userGroupInfo.Allowpostattach != 1)
{
msg = string.Format("您当前的身份 \"{0}\" 没有上传附件的权限", userGroupInfo.ug_name);
return false;
}
}
return true;
}
/// <summary>
/// 更新用户组信息
/// </summary>
/// <param name="info">用户组信息</param>
public static void UpdateUserGroup(UserGroupInfo info)
{
Data.DataProvider.UserGroups.UpdateUserGroup(info);
}
