public void BindData()
{
#region
DataGrid1.AllowCustomPaging = false;
DataGrid1.BindData(Topics.GetTopicsByCondition(condition));
#endregion
}
//public void SendEmail()
//{
// #region 向所有通过审核的用户发送邮件
// //foreach (DataRow dr in DbHelper.ExecuteDataset("SELECT [username],[password],[email] FROM [" + BaseConfigs.GetTablePrefix + "users] WHERE [groupid]=8").Tables[0].Rows)
// foreach (DataRow dr in Users.GetUserListByGroupid(8).Rows)
// {
// Emails.DiscuzSmtpMail(dr["username"].ToString().Trim(), dr["email"].ToString().Trim(), dr["password"].ToString().Trim());
// }
// #endregion
//}
//public void SendEmail(string uidlist)
//{
// #region 向指定的通过审核的用户发送邮件
// foreach (DataRow dr in Users.GetUsersByUidlLst(uidlist).Rows)
// {
// Emails.DiscuzSmtpMail(dr["username"].ToString().Trim(), dr["email"].ToString().Trim(), "");
// }
// #endregion
//}
protected void searchuser_Click(object sender, System.EventArgs e)
{
if (this.CheckCookie())
{
DataGrid1.BindData(Users.AuditNewUserClear(searchusername.Text, regbefore.Text, regip.Text));
}
}
public void BindData()
{
#region
DataGrid1.AllowCustomPaging = false;
DataGrid1.BindData(Topics.GetAuditTopicList(ViewState["condition"].ToString()));
#endregion
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "标签列表";
DataGrid1.DataKeyField = "tagid";
DataGrid1.BindData(Tags.GetForumTags("", Convert.ToInt32(radstatus.SelectedValue)));
}
protected void searchtag_Click(object sender, System.EventArgs e)
{
BindData();
string tag_name = this.tagname.Text.Trim();
int from = Utils.StrToInt(txtfrom.Text.Trim(), 101);
int end = Utils.StrToInt(txtend.Text.Trim(), 102);
//三个文本框都为空，返回
if ((from == 101 && end == 102 && tag_name == "") || (from == 101 && end != 102) || (from != 101 && end == 102))
{
return;
}
//当名称不为空，范围为空，按名字搜索
int selected = Convert.ToInt32(this.radstatus.SelectedValue);
if (tag_name != "" && ((from == 101) && (end == 102)))
{
if (this.CheckCookie())
{
DataGrid1.BindData(Tags.GetForumTags(tag_name, selected));
}
}
else
{
DataGrid1.BindData(Topics.GetTopicNumber(tag_name, from, end, selected));
}
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "特殊组列表";
DataGrid1.Attributes.Add("borderStyle", "2");
DataGrid1.BindData(UserGroups.GetSpecialUserGroup());
}
/// <summary>
/// 绑定主题
/// </summary>
public void BindData(string searthKeyWord)
{
#region 绑定主题
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "主题分类";
DataGrid1.BindData(TopicTypes.GetTopicTypes(searthKeyWord));
#endregion
}
public void BindData()
{
#region
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "附件列表";
DataGrid1.BindData(Attachments.GetAttachList(ViewState["condition"].ToString(), Posts.GetPostTableName()));
#endregion
}
public void BindData()
{
#region 绑定审核主题
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "审核主题列表";
DataGrid1.DataKeyField = "tid";
DataGrid1.BindData(AdminTopics.GetUnauditNewTopic());
#endregion
}
public void BindData()
{
#region 绑定审核帖子
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "审核帖子列表";
DataGrid1.DataKeyField = "pid";
DataGrid1.BindData(AdminTopics.GetUnauditPost(int.Parse(postlist.SelectedValue)));
#endregion
}
public void BindData()
{
#region 绑定公共列表
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "公共消息列表";
DataGrid1.DataKeyField = "pmid";
DataGrid1.BindData(PrivateMessages.GetAnnouncePrivateMessageCollection(-1, 0));
#endregion
}
//TODO:传Sql语句，需要改进
private void Search_Click(object sender, EventArgs e)
{
#region 条件搜索公告
if (CheckCookie())
{
StringBuilder builder = new StringBuilder();
if (!poster.Text.Equals(""))
{
builder.Append("[poster] LIKE '%");
builder.Append(poster.Text);
builder.Append("%'");
}
if (!title.Text.Equals(""))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.Append("[title] LIKE '%");
builder.Append(title.Text);
builder.Append("%'");
}
if (!postdatetimeStart.SelectedDate.ToString().Equals(""))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.Append("[starttime] >= '");
builder.Append(postdatetimeStart.SelectedDate.ToString());
builder.Append("'");
}
if (!postdatetimeEnd.SelectedDate.AddDays(1).ToString().Equals(""))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.Append("[starttime] <= '");
builder.Append(postdatetimeEnd.SelectedDate.ToString());
builder.Append("'");
}
if (builder.Length > 0)
{
builder.Insert(0, " WHERE ");
}
DataGrid1.BindData(Announcements.GetAnnouncementsByCondition(builder.ToString()));
}
#endregion
}
public void BindData()
{
#region 数据绑定
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "论坛勋章列表";
DataGrid1.BindData(Medals.GetMedal());
#endregion
}
public void BindData()
{
#region 数据绑定
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "发帖列表";
DataGrid1.BindData(Posts.GetPostListByCondition(ViewState["posttablename"].ToString(), ViewState["condition"].ToString()));
#endregion
}
public void BindData()
{
#region 绑定过滤词列表
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "过滤词列表";
DataGrid1.BindData(BanWords.GetBanWordList());
antipamreplacement.Text = config.Antispamreplacement;
#endregion
}
public void BindData()
{
#region 数据绑定
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "论坛勋章列表";
DataGrid1.BindData(DatabaseProvider.GetInstance().GetMedalSql());
#endregion
}
public void BindData()
{
#region 绑定用户组列表
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "用户组列表";
DataGrid1.Attributes.Add("borderStyle", "2");
DataGrid1.DataKeyField = "groupid";
DataGrid1.BindData(UserGroups.GetCreditUserGroup());
DataGrid1.Sort = "creditshigher";
#endregion
}
public void BindData()
{
#region 绑定审核用户列表
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "审核用户列表";
DataGrid1.DataKeyField = "uid";
DataTable auditUsersTable = Users.GetUserListByGroupid(8);
DataGrid1.BindData(auditUsersTable);
AllDelete.Enabled = auditUsersTable.Rows.Count > 0;
AllPass.Enabled = auditUsersTable.Rows.Count > 0;
#endregion
}
public void BindData()
{
#region 绑定友情链接列表
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "友情链接列表";
//DataGrid1.BindData(ForumLinks.GetForumLinks());
DataTable dt = ForumLinks.GetForumLinks();
DataTable dtCopy = dt.Clone();
dtCopy.Rows.Clear();
string[] conditions = { "note", "logo", "" };
foreach (string condition in conditions)
{
foreach (DataRow dr in dt.Rows)
{
DataRow newDr = dtCopy.NewRow();
newDr.ItemArray = dr.ItemArray;
switch (condition)
{
case "note":
{
if (dr["note"].ToString().Trim() != "")
{
dtCopy.Rows.Add(newDr);
}
break;
}
case "logo":
{
if (dr["logo"].ToString().Trim() != "" && dr["note"].ToString().Trim() == "")
{
dtCopy.Rows.Add(newDr);
}
break;
}
default:
{
if (dr["logo"].ToString().Trim() == "" && dr["note"].ToString().Trim() == "")
{
dtCopy.Rows.Add(newDr);
}
break;
}
}
}
}
DataGrid1.BindData(dtCopy);
#endregion
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "系统组列表";
List <UserGroupInfo> list = new List <UserGroupInfo>();
foreach (UserGroupInfo userGroupInfo in UserGroups.GetUserGroupList())
{
if (userGroupInfo.System == 1)
{
list.Add(userGroupInfo);
}
}
DataGrid1.BindData(list);
}
protected void Page_Load(object sender, EventArgs e)
{
string locations = "var locations = " + Utils.DataTableToJSON(DbProvider.GetInstance().GetLocationsTable());
this.RegisterStartupScript("locations", "<script type='text/javascript'>" + locations + "</script>");
if (!IsPostBack)
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "区域管理";
DataGrid1.DataKeyField = "lid";
DataGrid1.BindData(DbProvider.GetInstance().GetLocationsTableSql());
country_select.Items.Add(new ListItem(" ", ""));
foreach (DataRow dr in DbProvider.GetInstance().GetCountriesTable().Rows)
{
country_select.Items.Add(new ListItem(dr["country"].ToString()));
}
state_select.Items.Add(new ListItem(" ", ""));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string mod = DNTRequest.GetString("mod");
DataGrid1.DataKeyField = "goodsid";
if (mod == "audit")
{
DataGrid1.TableHeaderName = "商品审核管理";
resume.Visible = false;
DataGrid1.BindData(DbProvider.GetInstance().GetAllAuditGoods());
}
else
{
DataGrid1.TableHeaderName = "商品回收站管理";
pass.Visible = false;
DataGrid1.BindData(DbProvider.GetInstance().GetAllRecyclebinGoods());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataGrid1.TableHeaderName = "订单管理";
DataGrid1.DataKeyField = "id";
DataGrid1.BindData(DbProvider.GetInstance().GetAllGoodstradelogs(drpstatus.SelectedValue));
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "论坛图标文件列表";
DataGrid1.BindData(DatabaseProvider.GetInstance().GetIcons());
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.BindData(Forum.Announcements.GetAnnouncementList());
}
public void BindData()
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.TableHeaderName = "上传附件类型列表";
DataGrid1.BindData(Attachments.GetAttachmentType());
}
public void BindData(int type)
{
DataGrid1.AllowCustomPaging = false;
DataGrid1.BindData(Advertisements.GetAdvertisements(type));
}
