//街道统计导出
public void Export(string SSJD, string expwher)
{
//获取导出列表
DataTable dt = BuildingsStreetStatisticsBLL.GetBySSJD(Request["ssjd"]);
ExportExcel.Export(dt.ExportExcelPreByName("街道统计"), "街道统计");
}
//简单统计（空置率，落地率）导出
public void SimpleExport()
{
decimal businessVacancyRate, commerceVacancyRate, vacancyRate, floorRate;
var list = BuildingsStreetStatisticsBLL.GetBySSJD(string.Empty);//街道数据
CalculateVacancyRateAndFloorRate(list, out businessVacancyRate, out commerceVacancyRate, out vacancyRate, out floorRate);
Dictionary <string, string> dicionary = new Dictionary <string, string>
{
{ "Name", "街道名称" },
{ "VacancyRate", "总空置率" },
{ "BusinessVacancyRate", "商业空置率" },
{ "CommerceVacancyRate", "商务控制率" },
{ "FloorRate", "落地率" }
};
ExportExcel.Export(list.ExportExcelPre(dicionary), "简单统计", new List <List <string> >()
{
new List <string>()
{
"总空置率：",
decimal.Round(businessVacancyRate, 2).ToString(),
"商业空置率：",
decimal.Round(commerceVacancyRate, 2).ToString(),
"商务空置率：",
decimal.Round(vacancyRate, 2).ToString(),
"落地率：",
decimal.Round(floorRate, 2).ToString(),
}
});
}
//街道统计
public ActionResult Index()
{
StatisticsIndexViewModel viewModel = new StatisticsIndexViewModel();
string ssjd = Request["ssjd"];
RoadFlow.Platform.DictionaryBLL DictionaryBLL = new RoadFlow.Platform.DictionaryBLL();
viewModel.ParaSSJD = new SelectList(DictionaryBLL.GetListByCode("SSJD").ToList <RoadFlow.Data.Model.DictionaryModel>(), "ID", "Title", ssjd);;
viewModel.List = BuildingsStreetStatisticsBLL.GetBySSJD(ssjd);
return(View(viewModel));
}
/// <summary>
/// 根据字段名获取值
/// </summary>
private void GetValuesByField(string field)
{
var list = BuildingsStreetStatisticsBLL.GetBySSJD(string.Empty);//街道数据
var displayName = new List <string>();
var values = new List <object>();
foreach (DataRow dr in list.Rows)
{
displayName.Add(dr["Name"].ToString());
values.Add(dr[field]);
}
ViewBag.DisplayName = JsonConvert.SerializeObject(displayName);
ViewBag.Values = JsonConvert.SerializeObject(values);
}
private StatisticsSimpleViewModel SimpleInit()
{
decimal businessVacancyRate, commerceVacancyRate, vacancyRate, floorRate;
var list = BuildingsStreetStatisticsBLL.GetBySSJD(string.Empty);//街道数据
CalculateVacancyRateAndFloorRate(list, out businessVacancyRate, out commerceVacancyRate, out vacancyRate, out floorRate);
StatisticsSimpleViewModel viewModel = new StatisticsSimpleViewModel()
{
List = list,
BusinessVacancyRate = businessVacancyRate,
CommerceVacancyRate = commerceVacancyRate,
VacancyRate = vacancyRate,
FloorRate = floorRate
};
return(viewModel);
}
