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