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 ActionResult Index()
{
int CustomerCount = CMSService.GetSomeValue("CustomerDto", "CMSCustomer", "1=1", "Count(CustomerId)");
int JianyanCount = CMSService.GetSomeValue("JianyanDto", "CMSJianyan", "1=1", "Count(JianyanId)");
int ChufangCount = CMSService.GetSomeValue("ChufangDto", "CMSChufang", "1=1", "Count(ChufangId)");
int TizhiCount = CMSService.GetSomeValue("TizhiDto", "CMSTizhi", "1=1", "Count(TizhiId)");
int XueyaCount = CMSService.GetSomeValue("XueyaDto", "CMSXueya", "1=1", "Count(XueyaId)");
float JixiaoCount = CMSService.GetSomeValue("JixiaoDto", "CMSJixiao", "1=1", "Count(JixiaoId)");
float JixiaoPassCount = CMSService.GetSomeValue("JixiaoDto", "CMSJixiao", "JixiaoStatus='已审核'", "Count(JixiaoId)");
float JixiaoPersent = (JixiaoPassCount / JixiaoCount) * 100;
ViewBag.CustomerCount = CustomerCount;
ViewBag.JianyanCount = JianyanCount;
ViewBag.ChufangCount = ChufangCount;
ViewBag.TizhiCount = TizhiCount;
ViewBag.XueyaCount = XueyaCount;
ViewBag.JixiaoCount = JixiaoCount;
ViewBag.JixiaoPassCount = JixiaoPassCount;
ViewBag.JixiaoPersent = JixiaoPersent.ToString() + "%";
return(View());
//return RedirectToAction("Index","Customer", new { category = "全部", guidang = "0" });
}