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()); }