动软模糊查询

查询按钮

?

1 2 3 4 5 6 7 8

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

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

/// <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

?

1 2 3 4 5 6 7

/// <summary>         /// 获得数据列表         /// </summary>         public DataSet GetList(string strWhere)         {             return dal.GetList(strWhere);         }

DAL

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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