Пример #1
0
    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('确定要删除吗?');");
    }
Пример #2
0
    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('确定要删除吗?');");
    }