protected string getCenterDataList()
{
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.getCenterDataFaster(year, month, dateStr);
if (dt != null)
{
dt = PinYinHelper.SortByPinYin(dt, sort, order);
DataTable footDataTable = generateFooterTable(dt, "center");
string json = JsonHelper.DataTableToJsonForEasyUiDataGridLoadDataMethod(dt, footDataTable);
return(json);
}
else
{
return("error");
}
}
protected string generateCenterChart()
{
int year = Int32.Parse(Request.Form["year"]);
int month = Int32.Parse(Request.Form["month"]);
string dateStr = Request.Form["dateStr"];
// 读取总表数据
DataTable dt = SalesReportManage.getCenterDataFaster(year, month, dateStr);
JArray jArray1 = new JArray();
JArray jArray2 = new JArray();
// 组装成echarts图表数据
if (dt == null)
{
return(null);
}
foreach (DataRow dr in dt.Rows)
{
JObject jObject = new JObject();
float monthCompleteRate = float.Parse(dr["monthCompleteRate"].ToString());
float sumCompleteRate = float.Parse(dr["sumCompleteRate"].ToString());
jObject.Add("name", "年度达成率");
jObject.Add("value", sumCompleteRate * 100);
jArray1.Add(jObject);
jObject = new JObject();
jObject.Add("name", "月度达成率");
jObject.Add("value", monthCompleteRate * 100);
jArray2.Add(jObject);
}
JObject totalObject = new JObject
{
{ "jArray1", jArray1 },
{ "jArray2", jArray2 }
};
return(totalObject.ToString());
}