关键字搜索的问题

2011-07-21 03:33:17 111 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

hebaobao19880921 墨衍会员 · AI 创作全网分发关注 + 加入社区

全栈开发指南：从前端到后端的全面掌握全栈开发人员（Full Stack Developer）是指能够处理前端和后端开发工作的开发人员。他们需要掌握各种技术和工具，能够独立完成从需求分析、设计、开发到部署的整个流程。这篇博客将详细介绍全栈开发涉及的各个方面，为您提供从入门到进阶的指导。阅读详情

做了一个关键字搜索的功能,被搜索的字段有资源信息和资源名称还有日期段
这个资源信息和资源名称都是来之一个输入框不知道该怎么办判断这个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);

        }