/// <summary>
/// 绑定数据
/// </summary>
private void BindGame()
{
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 ");
IList <MySqlParameter> parm = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(this.txtCnname.Text.Trim()))
{
//strWhere.Append(" And gm.Gm_name like '%" + this.txtCnname.Text.Trim() + "%'");
strWhere.Append(" And gm.Gm_name like @Cnname");
parm.Add(new MySqlParameter("@Cnname", "%" + this.txtCnname.Text.Trim() + "%"));
}
if (this.rblState.SelectedValue == "0") //0启用1停用 默认0
{
strWhere.Append(" And gm.Gm_state = 0");
}
else
{
strWhere.Append(" And gm.Gm_state = 1");
}
strWhere.Append(" And gm.Gm_del = 0 ");
//DataView view = gameMessage.GetTable(strWhere.ToString()).DefaultView;
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
// view = gameMessage.GetTable(strWhere.ToString(),parm,sort);
//view.Sort = sort;
this.gvGame.DataSource = gameMessage.GetTable(strWhere.ToString(), parm);;
this.gvGame.DataBind();
}
