查询按钮
protected void btnSearch_Click(object sender, EventArgs e)
{
//Maticsoft.BLL.Post_Info post = new BLL.Post_Info();
//post.GetList("postName like '%" + this.txtKeyword.Text + "%' or departmenName like '%" + this.txtKeyword.Text + "%' or postDescribe like '%" + this.txtKeyword.Text + "%'");
//gridView.DataSource = ds;
//gridView.DataBind();
BindData();
}
/// <summary>
/// 模糊查询
/// </summary>
public void BindData()
{
#region
//if (!Context.User.Identity.IsAuthenticated)
//{
// return;
//}
//AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
//if (user.HasPermissionID(PermId_Modify))
//{
// gridView.Columns[6].Visible = true;
//}
//if (user.HasPermissionID(PermId_Delete))
//{
// gridView.Columns[7].Visible = true;
//}
#endregion
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
if (txtKeyword.Text.Trim() != "")
{
#warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称
strWhere.AppendFormat("postName like '%{0}%' or departmenName like '%{0}%' or postDescribe like '%{0}%'", txtKeyword.Text.Trim());
}
ds = bll.GetList(strWhere.ToString());
gridView.DataSource = ds;
gridView.DataBind();
}
BLL
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
DAL
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select postid,postName,departmenName,postDescribe ");
strSql.Append(" FROM Post_Info ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DbHelperSQL.Query(strSql.ToString());
}