public ActionResult List(BREnum bREnum, string key)
{
// var list = Core.RollViewManager.GetList(bREnum,key);
var list = Core.RollViewManager.GetRollList(bREnum, key);
ViewBag.List = list;
return(View());
}
/// <summary>
/// 作用：获取某一类名单列表
/// 作者：汪建龙
/// 编写时间：2017年3月8日09:33:37
/// </summary>
/// <param name="brenum"></param>
/// <param name="key"></param>
/// <returns></returns>
public List <RollView> GetList(BREnum brenum, string key)
{
var query = Db.RollViews.Where(e => e.BREnum == brenum).AsQueryable();
if (!string.IsNullOrEmpty(key))
{
query = query.Where(e => e.Name.ToLower().Contains(key.ToLower()));
}
return(query.ToList());
}
public ActionResult DownLoad(BREnum brenum, string key)
{
var list = Core.RollViewManager.GetRollList(brenum, key);
IWorkbook workbook = RollExcelManager.SaveRoll(list);
MemoryStream ms = new MemoryStream();
workbook.Write(ms);
ms.Flush();
byte[] fileContents = ms.ToArray();
return(File(fileContents, "application/ms-excel", string.Format("诚信系统{0}名单列表.xls", brenum == BREnum.Black?"黑":"异常")));
}
public List <RollList> GetRollList(BREnum brenum, string key, bool isStandard = false)
{
return(GetList(brenum == BREnum.Black ? GradeDegree.D : GradeDegree.C, key, isStandard));
}
public long Count(BREnum brnum)
{
return(GetRollList(brnum, null).LongCount());
}
public ActionResult Index(BREnum BREnum = BREnum.Black, string key = null)
{
ViewBag.BREnum = BREnum;
ViewBag.Key = key;
return(View());
}
public long Count(BREnum brenum)
{
return(Db.Rolls.Where(e => e.BREnum == brenum).LongCount());
}
