public ActionResult Index(int?p) { Pager pager = new Pager(); pager.table = "CMSJixiao"; pager.strwhere = "1=1"; pager.PageSize = 20; pager.PageNo = p ?? 1; pager.FieldKey = "JixiaoId"; pager.FiledOrder = "JixiaoId Desc"; pager = CMSService.SelectAll("Jixiao", pager); List <JixiaoDto> list = new List <JixiaoDto>(); foreach (DataRow dr in pager.EntityDataTable.Rows) { JixiaoDto dto = JixiaoMapping.getDTO(dr); list.Add(dto); } pager.Entity = list.AsQueryable(); ViewBag.PageNo = p ?? 1; ViewBag.PageCount = pager.PageCount; ViewBag.RecordCount = pager.Amount; ViewBag.Message = pager.Amount; ViewBag.ZongCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "1=1", "Count(JixiaoId)"); ViewBag.ShenheCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='已审核'", "Count(JixiaoId)"); ViewBag.WeishenheCount = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='未通过'", "Count(JixiaoId)"); ViewBag.ZongFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "1=1", "SUM(JixiaoFenshu)"); ViewBag.ShenheFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='已审核'", "SUM(JixiaoFenshu)"); ViewBag.WeishenheFenshu = CMSService.GetSomeValue("Jixiao", "CMSJixiao", "JixiaoStatus='未通过'", "SUM(JixiaoFenshu)"); ViewData["Month"] = CommonTools.GetMontList(); return(View(pager.Entity)); }
public static IMapping CreatMapping(string DtoName) { IMapping Mapping = null; if (DtoName == "User") { Mapping = new UserMapping(); } if (DtoName == "Role") { Mapping = new RoleMapping(); } if (DtoName == "Category") { Mapping = new CategoryMapping(); } if (DtoName == "Article") { Mapping = new ArticleMapping(); } if (DtoName == "Image") { Mapping = new ImageMapping(); } if (DtoName == "Customer") { Mapping = new CustomerMapping(); } if (DtoName == "Tizhi") { Mapping = new TizhiMapping(); } if (DtoName == "Xueya") { Mapping = new XueyaMapping(); } if (DtoName == "Jianyan") { Mapping = new JianyanMapping(); } if (DtoName == "Chufang") { Mapping = new ChufangMapping(); } if (DtoName == "Jixiao") { Mapping = new JixiaoMapping(); } if (DtoName == "Fankui") { Mapping = new FankuiMapping(); } if (DtoName == "Yuyue") { Mapping = new YuyueMapping(); } return(Mapping); }