private void LanguageBind() { string table = " language "; string columns = "id,name,languageCode,languageRemark"; string sort = " id desc"; string condition = GetCondition(); // string ExSql = "select "+columns +" from "+table +" where "+condition +" order by "+sort ; Pager1.PageSorting(1, 10, table, columns, condition, sort, "GridView1"); //this.Pager1.Visible = false; }
private void PageInit() { try { string keyCode = BLL.CommonClass.ValidData.InputText(this.txtQueryCode.Text.Trim()); string keyWords = BLL.CommonClass.ValidData.InputText(this.txtKeywords.Text.Trim()); string viewCode = BLL.CommonClass.ValidData.InputText(this.ddlLanguage.SelectedItem.Value.Trim()); string table = " t_translation "; string columns = " keyCode as " + GetTran("006647", "词典编码") + " ,'" + GetTran("006640", "编辑") + "' as " + GetTran("006640", "编辑") + " "; string condition = " 1=1 "; string language1 = this.ddlLanguageView1.SelectedItem.Value.Trim(); string language2 = this.ddlLanguageView2.SelectedItem.Value.Trim(); if (language1 != "" && language1 != "-1") { columns += "," + ddlLanguageView1.SelectedItem.Value.Trim() + " as " + ddlLanguageView1.SelectedItem.Text; } if (language2 != "" && language2 != "-1" && language2 != language1) { columns += "," + ddlLanguageView2.SelectedItem.Value.Trim() + " as " + ddlLanguageView2.SelectedItem.Text; } columns += ",description as " + GetTran("001680", "描述") + " "; if (keyWords != "") { condition += " and " + viewCode + " like '%" + keyWords + "%' "; } if (keyCode != "") { condition += " and keyCode='" + keyCode + "'"; } string key = "keyCode "; Pager1.PageSorting(Pager1.pageIndex, 10, table, columns, condition, key + " desc", "GridView1"); } catch (Exception ex) { Response.Write(ex.Message); } }