public bool BatchSetForumInf(ForumInfo foruminfo, BatchSetParams bsp, string fidlist)
{
StringBuilder forums = new StringBuilder();
StringBuilder forumfields = new StringBuilder();
forums.Append("UPDATE [" + BaseConfigs.GetTablePrefix + "forums] SET ");
if (bsp.SetSetting)
{
forums.Append("[Allowsmilies]='" + foruminfo.Allowsmilies + "' ,");
forums.Append("[Allowrss]='" + foruminfo.Allowrss + "' ,");
forums.Append("[Allowhtml]='" + foruminfo.Allowhtml + "' ,");
forums.Append("[Allowbbcode]='" + foruminfo.Allowbbcode + "' ,");
forums.Append("[Allowimgcode]='" + foruminfo.Allowimgcode + "' ,");
forums.Append("[Allowblog]='" + foruminfo.Allowblog + "' ,");
forums.Append("[Allowtrade]='" + foruminfo.Allowtrade + "' ,");
forums.Append("[Alloweditrules]='" + foruminfo.Alloweditrules + "' ,");
forums.Append("[allowthumbnail]='" + foruminfo.Allowthumbnail + "' ,");
forums.Append("[Recyclebin]='" + foruminfo.Recyclebin + "' ,");
forums.Append("[Modnewposts]='" + foruminfo.Modnewposts + "' ,");
forums.Append("[Jammer]='" + foruminfo.Jammer + "' ,");
forums.Append("[Disablewatermark]='" + foruminfo.Disablewatermark + "' ,");
forums.Append("[Inheritedmod]='" + foruminfo.Inheritedmod + "' ,");
}
if (forums.ToString().EndsWith(","))
{
forums.Remove(forums.Length - 1, 1);
}
forums.Append("WHERE [fid] IN(" + fidlist + ")");
forumfields.Append("UPDATE [" + BaseConfigs.GetTablePrefix + "forumfields] SET ");
if (bsp.SetPassWord)
{
forumfields.Append("[password]='" + foruminfo.Password + "' ,");
}
if (bsp.SetAttachExtensions)
{
forumfields.Append("[attachextensions]='" + foruminfo.Attachextensions + "' ,");
}
if (bsp.SetPostCredits)
{
forumfields.Append("[postcredits]='" + foruminfo.Postcredits + "' ,");
}
if (bsp.SetReplyCredits)
{
forumfields.Append("[replycredits]='" + foruminfo.Replycredits + "' ,");
}
if (bsp.SetViewperm)
{
forumfields.Append("[Viewperm]='" + foruminfo.Viewperm + "' ,");
}
if (bsp.SetPostperm)
{
forumfields.Append("[Postperm]='" + foruminfo.Postperm + "' ,");
}
if (bsp.SetReplyperm)
{
forumfields.Append("[Replyperm]='" + foruminfo.Replyperm + "' ,");
}
if (bsp.SetGetattachperm)
{
forumfields.Append("[Getattachperm]='" + foruminfo.Getattachperm + "' ,");
}
if (bsp.SetPostattachperm)
{
forumfields.Append("[Postattachperm]='" + foruminfo.Postattachperm + "' ,");
}
if (forumfields.ToString().EndsWith(","))
{
forumfields.Remove(forumfields.Length - 1, 1);
}
forumfields.Append("WHERE [fid] IN(" + fidlist + ")");
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
if (forums.ToString().IndexOf("SET WHERE") < 0)
{
DbHelper.ExecuteNonQuery(trans, CommandType.Text, forums.ToString());
}
if (forumfields.ToString().IndexOf("SET WHERE") < 0)
{
DbHelper.ExecuteNonQuery(trans, CommandType.Text, forumfields.ToString());
}
trans.Commit();
}
catch
{
trans.Rollback();
return false;
}
}
return true;
}
private void SubmitBatchSet_Click(object sender, EventArgs e)
{
#region 写入批量论坛设置信息
string targetlist = DNTRequest.GetString("Forumtree1");
if ((targetlist == "") || (targetlist == ",") || (targetlist == "0"))
{
base.RegisterStartupScript( "", "<script>alert('您未选中任何版块, 系统无法提交! ');</script>");
return;
}
__foruminfo = AdminForums.GetForumInfomation(DNTRequest.GetInt("fid", -1));
__foruminfo.Allowsmilies = BoolToInt(setting.Items[0].Selected);
__foruminfo.Allowrss = BoolToInt(setting.Items[1].Selected);
__foruminfo.Allowhtml = 0;
__foruminfo.Allowbbcode = BoolToInt(setting.Items[2].Selected);
__foruminfo.Allowimgcode = BoolToInt(setting.Items[3].Selected);
__foruminfo.Allowblog = 0;
__foruminfo.Istrade = 0;
__foruminfo.Alloweditrules = 0;
__foruminfo.Recyclebin = BoolToInt(setting.Items[4].Selected);
__foruminfo.Modnewposts = BoolToInt(setting.Items[5].Selected);
__foruminfo.Jammer = BoolToInt(setting.Items[6].Selected);
__foruminfo.Disablewatermark = BoolToInt(setting.Items[7].Selected);
__foruminfo.Inheritedmod = BoolToInt(setting.Items[8].Selected);
__foruminfo.Allowthumbnail = BoolToInt(setting.Items[9].Selected);
__foruminfo.Password = password.Text;
__foruminfo.Attachextensions = attachextensions.GetSelectString(",");
__foruminfo.Viewperm = viewperm.GetSelectString(",");
__foruminfo.Postperm = postperm.GetSelectString(",");
__foruminfo.Replyperm = replyperm.GetSelectString(",");
__foruminfo.Getattachperm = getattachperm.GetSelectString(",");
__foruminfo.Postattachperm = postattachperm.GetSelectString(",");
BatchSetParams bsp = new BatchSetParams();
bsp.SetPassWord = setpassword.Checked;
bsp.SetAttachExtensions = setattachextensions.Checked;
bsp.SetPostCredits = setpostcredits.Checked;
bsp.SetReplyCredits = setreplycredits.Checked;
bsp.SetSetting = setsetting.Checked;
bsp.SetViewperm = setviewperm.Checked;
bsp.SetPostperm = setpostperm.Checked;
bsp.SetReplyperm = setreplyperm.Checked;
bsp.SetGetattachperm = setgetattachperm.Checked;
bsp.SetPostattachperm = setpostattachperm.Checked;
if (AdminForums.BatchSetForumInf(__foruminfo, bsp, targetlist))
{
base.RegisterStartupScript( "PAGE", "window.location.href='forum_ForumsTree.aspx';");
}
else
{
base.RegisterStartupScript( "", "<script>alert('提交不成功!');window.location.href='forum_ForumsTree.aspx';</script>");
}
#endregion
}
/// <summary>
/// 批理设置论坛信息
/// </summary>
/// <param name="__foruminfo">复制的论坛信息</param>
/// <param name="bsp">是否要批量设置的信息字段</param>
/// <param name="fidlist">目标论坛(fid)串</param>
/// <returns></returns>
public static bool BatchSetForumInf(ForumInfo forumInfo, BatchSetParams bsp, string fidlist)
{
return Discuz.Data.Forums.BatchSetForumInf(forumInfo, bsp, fidlist);
}
/// <summary>
/// 批理设置论坛信息
/// </summary>
/// <param name="__foruminfo">复制的论坛信息</param>
/// <param name="bsp">是否要批量设置的信息字段</param>
/// <param name="fidlist">目标论坛(fid)串</param>
/// <returns></returns>
public static bool BatchSetForumInf(ForumInfo __foruminfo, BatchSetParams bsp, string fidlist)
{
return DatabaseProvider.GetInstance().BatchSetForumInf(__foruminfo, bsp, fidlist);
}
private void SubmitBatchSet_Click(object sender, EventArgs e)
{
#region 写入批量论坛设置信息
string targetlist = DNTRequest.GetString("Forumtree1");
if ((targetlist == "") || (targetlist == ",") || (targetlist == "0"))
{
base.RegisterStartupScript( "", "<script>alert('您未选中任何版块, 系统无法提交! ');</script>");
return;
}
forumInfo = Forums.GetForumInfo(DNTRequest.GetInt("fid", -1));
forumInfo.Allowhtml = 0;
forumInfo.Allowblog = 0;
forumInfo.Istrade = 0;
forumInfo.Alloweditrules = 0;
forumInfo.Allowsmilies = BoolToInt(setting.Items[0].Selected);
forumInfo.Allowrss = BoolToInt(setting.Items[1].Selected);
forumInfo.Allowbbcode = BoolToInt(setting.Items[2].Selected);
forumInfo.Allowimgcode = BoolToInt(setting.Items[3].Selected);
forumInfo.Recyclebin = BoolToInt(setting.Items[4].Selected);
forumInfo.Modnewposts = BoolToInt(setting.Items[5].Selected);
forumInfo.Jammer = BoolToInt(setting.Items[6].Selected);
forumInfo.Disablewatermark = BoolToInt(setting.Items[7].Selected);
forumInfo.Inheritedmod = BoolToInt(setting.Items[8].Selected);
forumInfo.Allowthumbnail = BoolToInt(setting.Items[9].Selected);
forumInfo.Allowtag = BoolToInt(setting.Items[10].Selected);
int temppostspecial = 0;
temppostspecial = setting.Items[11].Selected ? temppostspecial | 1 : temppostspecial & ~1;
temppostspecial = setting.Items[12].Selected ? temppostspecial | 16 : temppostspecial & ~16;
temppostspecial = setting.Items[13].Selected ? temppostspecial | 4 : temppostspecial & ~4;
forumInfo.Allowpostspecial = temppostspecial;
forumInfo.Alloweditrules = BoolToInt(setting.Items[14].Selected);
forumInfo.Password = password.Text;
forumInfo.Attachextensions = attachextensions.GetSelectString(",");
forumInfo.Viewperm = viewperm.GetSelectString(",");
forumInfo.Postperm = postperm.GetSelectString(",");
forumInfo.Replyperm = replyperm.GetSelectString(",");
forumInfo.Getattachperm = getattachperm.GetSelectString(",");
forumInfo.Postattachperm = postattachperm.GetSelectString(",");
BatchSetParams bsp = new BatchSetParams();
bsp.SetPassWord = setpassword.Checked;
bsp.SetAttachExtensions = setattachextensions.Checked;
bsp.SetPostCredits = setpostcredits.Checked;
bsp.SetReplyCredits = setreplycredits.Checked;
bsp.SetSetting = setsetting.Checked;
bsp.SetViewperm = setviewperm.Checked;
bsp.SetPostperm = setpostperm.Checked;
bsp.SetReplyperm = setreplyperm.Checked;
bsp.SetGetattachperm = setgetattachperm.Checked;
bsp.SetPostattachperm = setpostattachperm.Checked;
if (AdminForums.BatchSetForumInf(forumInfo, bsp, targetlist))
{
ForumOperator.RefreshForumCache();
AdminVistLogs.InsertLog(this.userid, this.username, this.usergroupid, this.grouptitle, this.ip, "复制版块设置", "编辑论坛版块列表为:" + targetlist.Trim());
base.RegisterStartupScript( "PAGE", "window.location.href='forum_ForumsTree.aspx';");
}
else
{
base.RegisterStartupScript( "", "<script>alert('提交不成功!');window.location.href='forum_ForumsTree.aspx';</script>");
}
#endregion
}
public bool BatchSetForumInf(ForumInfo forumInfo, BatchSetParams bsp, string fidList)
{
StringBuilder forums = new StringBuilder();
StringBuilder forumfields = new StringBuilder();
forums.AppendFormat("UPDATE [{0}forums] SET ", BaseConfigs.GetTablePrefix);
if (bsp.SetSetting)
{
forums.AppendFormat("[Allowsmilies]='{0}' ,", forumInfo.Allowsmilies);
forums.AppendFormat("[Allowrss]='{0}' ,", forumInfo.Allowrss);
forums.AppendFormat("[Allowhtml]='{0}' ,", forumInfo.Allowhtml);
forums.AppendFormat("[Allowbbcode]='{0}' ,", forumInfo.Allowbbcode);
forums.AppendFormat("[Allowimgcode]='{0}' ,", forumInfo.Allowimgcode);
forums.AppendFormat("[Allowblog]='{0}' ,", forumInfo.Allowblog);
forums.AppendFormat("[istrade]='{0}' ,", forumInfo.Istrade);
forums.AppendFormat("[allowpostspecial]='{0}' ,", forumInfo.Allowpostspecial);
forums.AppendFormat("[allowspecialonly]='{0}' ,", forumInfo.Allowspecialonly);
forums.AppendFormat("[Alloweditrules]='{0}' ,", forumInfo.Alloweditrules);
forums.AppendFormat("[allowthumbnail]='{0}' ,", forumInfo.Allowthumbnail);
forums.AppendFormat("[Recyclebin]='{0}' ,", forumInfo.Recyclebin);
forums.AppendFormat("[Modnewposts]='{0}' ,", forumInfo.Modnewposts);
forums.AppendFormat("[Modnewtopics]='{0}' ,", forumInfo.Modnewtopics);
forums.AppendFormat("[Jammer]='{0}' ,", forumInfo.Jammer);
forums.AppendFormat("[Disablewatermark]='{0}' ,", forumInfo.Disablewatermark);
forums.AppendFormat("[Inheritedmod]='{0}' ,", forumInfo.Inheritedmod);
forums.AppendFormat("[allowtag]='{0}' ,", forumInfo.Allowtag);
}
if (forums.ToString().EndsWith(","))
forums.Remove(forums.Length - 1, 1);
forums.AppendFormat("WHERE [fid] IN ({0})", fidList);
forumfields.AppendFormat("UPDATE [{0}forumfields] SET ", BaseConfigs.GetTablePrefix);
if (bsp.SetPassWord)
forumfields.AppendFormat("[password]='{0}' ,", forumInfo.Password);
if (bsp.SetAttachExtensions)
forumfields.AppendFormat("[attachextensions]='{0}' ,", forumInfo.Attachextensions);
if (bsp.SetPostCredits)
forumfields.AppendFormat("[postcredits]='{0}' ,", forumInfo.Postcredits);
if (bsp.SetReplyCredits)
forumfields.AppendFormat("[replycredits]='{0}' ,", forumInfo.Replycredits);
if (bsp.SetViewperm)
forumfields.AppendFormat("[Viewperm]='{0}' ,", forumInfo.Viewperm);
if (bsp.SetPostperm)
forumfields.AppendFormat("[Postperm]='{0}' ,", forumInfo.Postperm);
if (bsp.SetReplyperm)
forumfields.AppendFormat("[Replyperm]='{0}' ,", forumInfo.Replyperm);
if (bsp.SetGetattachperm)
forumfields.AppendFormat("[Getattachperm]='{0}' ,", forumInfo.Getattachperm);
if (bsp.SetPostattachperm)
forumfields.AppendFormat("[Postattachperm]='{0}' ,", forumInfo.Postattachperm);
if (forumfields.ToString().EndsWith(","))
forumfields.Remove(forumfields.Length - 1, 1);
forumfields.AppendFormat("WHERE [fid] IN ({0})", fidList);
SqlConnection conn = new SqlConnection(DbHelper.ConnectionString);
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
if (forums.ToString().IndexOf("SET WHERE") < 0)
DbHelper.ExecuteNonQuery(trans, CommandType.Text, forums.ToString());
if (forumfields.ToString().IndexOf("SET WHERE") < 0)
DbHelper.ExecuteNonQuery(trans, CommandType.Text, forumfields.ToString());
trans.Commit();
}
catch
{
trans.Rollback();
return false;
}
}
return true;
}