public RecordPage <SubjectInfo> AddApplyList(MarketOptionSearchParm parm, int pageIndex = 1, int pageSize = 10) { var dic = new Dictionary <string, object>(); dic.Add("KeyWord", (parm == null || parm.SubjectNoName == "活动名称或活动编号" || string.IsNullOrEmpty(parm.SubjectNoName)) ? "" : parm.SubjectNoName); dic.Add("BrandNo", (parm == null || string.IsNullOrEmpty(parm.BrandNo)) ? "" : parm.BrandNo); dic.Add("ApplyBeginTime", (parm == null || string.IsNullOrEmpty(parm.ApplyBeginTime)) ? "" : parm.ApplyBeginTime); dic.Add("ApplyEndTime", (parm == null || string.IsNullOrEmpty(parm.ApplyEndTime)) ? "" : parm.ApplyEndTime); dic.Add("SpreadStatus", (parm == null || string.IsNullOrEmpty(parm.SpreadStatus)) ? "" : parm.SpreadStatus); dic.Add("Level", (parm == null || string.IsNullOrEmpty(parm.Level)) ? "" : parm.Level); dic.Add("SubjectType", (parm == null || string.IsNullOrEmpty(parm.SubjectType)) ? "" : parm.SubjectType); dic.Add("CategoryNo", (parm == null || string.IsNullOrEmpty(parm.CategoryNo)) ? "" : parm.CategoryNo); IEnumerable <SubjectInfo> query = DapperUtil.QueryPaging <SubjectInfo>("ComBeziWfs_SWfsSubjectApply_SubjectList", pageIndex, pageSize, "CreateDateTime desc", dic, new { KeyWord = parm.SubjectNoName, BrandNo = parm.BrandNo, ApplyBeginTime = parm.ApplyBeginTime, ApplyEndTime = string.IsNullOrWhiteSpace(parm.ApplyEndTime) ? "" : Convert.ToDateTime(parm.ApplyEndTime).AddDays(1).ToString("yyyy-MM-dd"), SpreadStatus = parm.SpreadStatus, Level = parm.Level, SubjectType = parm.SubjectType, CategoryNo = parm.CategoryNo }); Dictionary <string, List <SWfsSubjectChannelSordRef> > dicSordRef = new SWfsSubjectService().GetSordBySubjectNoList(query.Select(x => x.SubjectNo).ToArray()); foreach (var subject in query) { subject.ChannelSordList = dicSordRef.Keys.Contains(subject.SubjectNo) ? dicSordRef[subject.SubjectNo] : null; } return(PageConvertor.Convert(pageIndex, pageSize, query.ToList())); }
// // GET: /Outlet/MarketOption/ public ActionResult Index(MarketOptionSearchParm parm, int pageIndex = 1) { MarketOptionService service = new MarketOptionService(); RecordPage <SubjectInfo> list = service.AddApplyList(parm, pageIndex, 10); ViewBag.List = list; ViewBag.ChannelSordList = new SubjectController().GetChannelSordList(2); return(View(parm)); }