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)); }