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