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