private void BindData() { string whereString = ""; string key = this.txtKeywords.Text.FormatSqlParm(); if (!string.IsNullOrEmpty(this.ddlDictGroup.SelectedValue)) { whereString = string.Format("`GroupCode`='{0}'", this.ddlDictGroup.SelectedValue); } if (!string.IsNullOrEmpty(key)) { if (!string.IsNullOrEmpty(whereString)) { whereString += " AND "; } whereString += string.Format("(Name LIKE '%{0}%' OR Code LIKE '%{0}%')", key); } int count = _bus.RecordCount(whereString); this.NPager1.PageSize = 10; this.NPager1.RecordCount = count; this.list.DataSource = _bus.GetDictItemData(this.NPager1.CurrentPage, this.NPager1.PageSize, this.ddlDictGroup.SelectedValue, this.txtKeywords.Text); this.list.DataBind(); BindKit.BindOnClientClick(this.list, "Delete", "return confirm('确定要删除吗?');"); }
private void BindData() { string whereString = "IsDel=0"; string key = this.txtKeywords.Text.FormatSqlParm(); if (!string.IsNullOrEmpty(key)) { whereString += " AND (Name LIKE '%" + key + "%' OR Code LIKE '%" + key + "%')"; } this.list.DataSource = _bus.Query(whereString, "CreateDate DESC"); this.list.DataBind(); BindKit.BindOnClientClick(this.list, "Delete", "return confirm('确定要删除吗?');"); }