public static IEnumerable <SuggestionsInfoModel> SearchSuggestInfoList(SuggestionsSearchModel model, out int totalCount)
{
var data = _suggestDAL.SearchSuggestInfoList(model);
totalCount = data.Count();
return(data);
}
public ActionResult SuggestSearchResult(SuggestionsSearchModel searchModel)
{
var totalCount = 0;
var result = SuggestBusiness.SearchSuggestInfoList(searchModel, out totalCount);
var page = new Page(totalCount, searchModel.CurrentPage);
var model = new SuggestionsSearchResultModel
{
SearchResultModel = result.Skip((page.CurrentPage - 1) * page.PageSize).Take(page.PageSize),
Page = page
};
return(View(model));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable <SuggestionsInfoModel> SearchSuggestInfoList(SuggestionsSearchModel model)
{
List <SuggestionsInfoModel> list = new List <SuggestionsInfoModel>();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@" select
Id,
BFType ,
BFPhase ,
BFDesc ,
BFRespUserNo ,
BFRespName ,
BFStatus ,
BFPicture ,
BFFeedBackComment ,
BFCreateUserNo ,
BFCreateUserName ,
BFCreateTime ,
BFOperateUserNo ,
BFOperateUserName ,
BFOperateTime ,
BFIsValid
FROM {0} with(NOLOCK) ", tableName);
sql.Append(" WHERE 1=1 ");
sql.Append(" AND BFIsValid=1 ");
if (model.DateForm != null && model.DateForm > Convert.ToDateTime("0001-01-01 00:00:00"))
{
sql.AppendFormat("AND BFCreateTime >='{0}'", model.DateForm);
}
var aa = DateTime.Parse("0001-01-01 00:00:00");
if (model.DateTo != null && model.DateTo > Convert.ToDateTime("0001-01-01 00:00:00"))
{
sql.AppendFormat("And BFCreateTime<='{0}'", model.DateTo);
}
var ds = ExecuteDataSet(CommandType.Text, sql.ToString());
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
list = DataConvertHelper.DataTableToList <SuggestionsInfoModel>(dt);
}
return(list.AsEnumerable());
}
