//
// GET: /TheReports/
/// <summary>
/// 客户构成报表分析
/// </summary>
/// <returns></returns>
public ActionResult Composing()
{
ComposingReportModel searchEntity = new ComposingReportModel();
searchEntity.TypeName = "按等级";
ViewData["pagerHelper"] = new PageHelper <ComposingReportModel>(new TheReportsService().GetComposingReportBySearchEntity(searchEntity), 1, 10);
ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ComposingReportModel>);
SetReportTypeList();
return(View(searchEntity));
}
public ActionResult Composing(FormCollection forms)
{
int curPage = int.Parse(forms["curPage"]);
ComposingReportModel searchEntity = new ComposingReportModel();
UpdateModel <ComposingReportModel>(searchEntity);
ViewData["pagerHelper"] = new PageHelper <ComposingReportModel>(new TheReportsService().GetComposingReportBySearchEntity(searchEntity), curPage, 10);
ViewData["reportData"] = new JavaScriptSerializer().Serialize(ViewData["pagerHelper"] as PageHelper <ComposingReportModel>);
SetReportTypeList();
return(View(searchEntity));
}
public string ExportComposing(string TypeName)
{
ComposingReportModel searchEntity = new ComposingReportModel();
searchEntity.TypeName = TypeName;
UpdateModel <ComposingReportModel>(searchEntity);
var list = new TheReportsService().GetComposingReportBySearchEntity(searchEntity);
//这里用的是ajax请求，需要先保存到本地，再返回路径 window.location.href = data;
var excel = ExcelHelper.Export <ComposingReportModel>(new ComposingReportModel(), list);
//MemoryStream ms = new MemoryStream();
var guid = Guid.NewGuid().ToString();
FileStream file = new FileStream(Server.MapPath("/Excel/" + guid + ".xls"), FileMode.Create);
excel.Write(file);
file.Close();
return("/Excel/" + guid + ".xls");
}
/// <summary>
/// 查询客户构成报表数据
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <ComposingReportModel> GetComposingReportBySearchEntity(ComposingReportModel searchEntity)
{
var db = LinqHelper.GetDataContext();
if (searchEntity.TypeName == "按等级")
{
return((from c in db.cst_customer
group c by c.cust_level_label into nc
select new ComposingReportModel
{
TypeName = nc.Key.ToString(),
CustomerCount = nc.Count()
}).ToList());
}
else if (searchEntity.TypeName == "按信用度")
{
var list = from c in db.cst_customer
group c by c.cust_credit into nc
select new ComposingReportModel
{
TypeName = db.bas_dict.Where(b => b.dict_type == "客户信用度" && b.dict_value == nc.Key.Value.ToString()).Select(b => b.dict_item).FirstOrDefault(),
CustomerCount = nc.Count()
};
return(list.ToList());
}
else
{
return((from c in db.cst_customer
group c by c.cust_satisfy into nc
select new ComposingReportModel
{
TypeName = db.bas_dict.Where(b => b.dict_type == "客户满意度" && b.dict_value == nc.Key.Value.ToString()).Select(b => b.dict_item).FirstOrDefault(),
CustomerCount = nc.Count()
}).ToList());
}
}
/// <summary>
/// 查询客户构成报表数据
/// </summary>
/// <param name="searchEntity"></param>
/// <returns></returns>
public List <ComposingReportModel> GetComposingReportBySearchEntity(ComposingReportModel searchEntity)
{
return(new TheReportsRepository().GetComposingReportBySearchEntity(searchEntity));
}
