protected string getDataList()
{
int year = Int32.Parse(Request.Form["year"]);
int month = Int32.Parse(Request.Form["month"]);
string dateStr = Request.Form["dateStr"];
string sort = Request.Form["sort"];
string order = Request.Form["order"];
// 读取数据
DataTable dt = SalesReportManage.getDataFaster(year, month, dateStr);
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, sort, order);
DataTable footDataTable = generateFooterTable(dt, "Sector");
string json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt, footDataTable);
return(json);
}
else
{
return("error");
}
}
protected string generateSectorChart()
{
int year = Int32.Parse(Request.Form["year"]);
int month = Int32.Parse(Request.Form["month"]);
string dateStr = Request.Form["dateStr"];
DataTable dt = SalesReportManage.getDataFaster(year, month, dateStr);
// 组装成echarts图表数据
if (dt == null)
{
return(null);
}
JObject jObject = new JObject();
List <string> sectorList = new List <string>();
List <float> monthCompleteRateList = new List <float>();
List <float> sumCompleteRateList = new List <float>();
foreach (DataRow dr in dt.Rows)
{
float monthCompleteRate = float.Parse(dr["monthCompleteRate"].ToString());
float sumCompleteRate = float.Parse(dr["sumCompleteRate"].ToString());
string sector = dr["Sector"].ToString();
sectorList.Add(sector);
monthCompleteRateList.Add(monthCompleteRate * 100);
sumCompleteRateList.Add(sumCompleteRate * 100);
}
jObject.Add("sectorList", JsonHelper.JsonSerializer(sectorList));
jObject.Add("monthCompleteRateList", JsonHelper.JsonSerializer(monthCompleteRateList));
jObject.Add("sumCompleteRateList", JsonHelper.JsonSerializer(sumCompleteRateList));
return(jObject.ToString());
}