做了一个关键字搜索的功能,被搜索的字段有资源信息和资源名称 还有日期段
这个资源信息和资源名称都是来之一个输入框 不知道该怎么办判断这个Like的文字是从哪个字段中查询的
我的DAL层是这样写的
/// <summary>
/// 根据日期,资源名称,资源描述查询资源信息
/// </summary>
/// <returns></returns>
public DataSet FN_SerchByDateAndType(string createdate, string endate, NRModel.File model)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append(" select * from t_File where FileNam like @FileNam");
//strSql.Append(" and CreateOn between convert(nvarchar(10),@createdate,120) and convert(nvarchar(10),@endate,120) order by CreateOn desc");
//SqlParameter[] parameters = {
// new SqlParameter("@FileNam",SqlDbType.NVarChar,256),
// new SqlParameter("@createdate",SqlDbType.NVarChar,256),
// new SqlParameter("@endate",SqlDbType.NVarChar,256)
// };
//parameters[0].Value = '%' + model.FileNam + '%';
//parameters[1].Value = createdate;
//parameters[2].Value = endate;
StringBuilder strSql = new StringBuilder();
strSql += "select * from t_file where 1=1";
if (model.FileNam != null)
{
strSql.Append += " and FileNam like @FileNam";
}
if (createdate != null && endate != null)
{
strSql += " and CreateOn between convert(nvarchar(10),@createdate,120) and convert(nvarchar(10),@endate,120) ";
}
if (model.Decription != null)
{
strSql += " and Decription like @Decription order by CreateOn desc";
}
SqlParameter[] parameters =
{
new SqlParameter("@FileNam",SqlDbType.NVarChar,256),
new SqlParameter("@createdate",SqlDbType.NVarChar,256),
new SqlParameter("@endate",SqlDbType.NVarChar,256),
new SqlParameter("@Decription",SqlDbType.NVarChar,256)
};
parameters[0].Value = '%' + model.FileNam + '%';
parameters[1].Value = createdate;
parameters[2].Value = endate;
parameters[3].Value = '%' + model.Decription + '%';
//string strSql = string.Format("select * from t_File where CreateOn between convert(nvarchar(10),'{0}',120) and convert(nvarchar(10),'{1}',120) and fileNam like '%{2}%'", createdate, endate, model.FileNam);
return DbHelperSQL.Query(strSql.ToString(), parameters);
}
