예제 #1
0
        public ActionResult SearchData(DataInfoPager pager)
        {
            var service = Container.GetService <IDataService>();
            Expression <Func <tbl_Data, bool> > wherelambda = d => d.C_UserId == userDto.User.keyid && d.C_DataTypeId == pager.DataTypeKey;

            if (!string.IsNullOrWhiteSpace(pager.Name))
            {
                wherelambda = wherelambda.And(d => d.C_Name.Contains(pager.Name));
            }
            if (!string.IsNullOrWhiteSpace(pager.DateFrom))
            {
                wherelambda = wherelambda.And(d => d.C_CreatedDate > Convert.ToDateTime(pager.DateFrom));
            }
            if (!string.IsNullOrWhiteSpace(pager.DateTo))
            {
                wherelambda = wherelambda.And(d => d.C_CreatedDate < Convert.ToDateTime(pager.DateTo));
            }
            var items = service.GetModelsByPage(pager.pageSize, pager.pageIndex, true, d => d.keyid, wherelambda).ToList();
            var infos = DataInfo.ConvertToDataInfos(items);
            var cnt   = service.GetTableCount(wherelambda);
            //返回表格
            var grid = new DataInfoGrid();

            grid.rows  = infos;
            grid.total = cnt;
            //if (pager.DataTypeKey == (int)DataTypeEnum.PDF)
            //{
            //    return Json(infos);
            //}
            return(Json(grid));
        }