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