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.getCenterData(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 generateCenterMonthChart() { int year = Int32.Parse(Request.Form["year"]); string sector = Request.Form["sector"]; DataTable dt = SalesReportManage.getSectorMoneyMonthly(year, sector); JObject jObject = new JObject(); List <string> list = new List <string>(); list.Add(dt.Rows[0]["jan"].ToString()); list.Add(dt.Rows[0]["feb"].ToString()); list.Add(dt.Rows[0]["mar"].ToString()); list.Add(dt.Rows[0]["apr"].ToString()); list.Add(dt.Rows[0]["may"].ToString()); list.Add(dt.Rows[0]["jun"].ToString()); list.Add(dt.Rows[0]["jul"].ToString()); list.Add(dt.Rows[0]["aug"].ToString()); list.Add(dt.Rows[0]["sep"].ToString()); list.Add(dt.Rows[0]["oct"].ToString()); list.Add(dt.Rows[0]["nov"].ToString()); list.Add(dt.Rows[0]["dec"].ToString()); jObject.Add("list", JsonHelper.JsonSerializer(list)); return(jObject.ToString()); }
protected string getAllSector() { DataTable dt = SalesReportManage.getSector(); if (dt == null) { return(null); } DataRow dr = dt.NewRow(); dr["Sector"] = "全部"; dt.Rows.InsertAt(dr, 0); return(JsonHelper.DataTable2Json(dt)); }
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()); }
protected string getPersonReport() { int year = Int32.Parse(Request.Form["year"]); int month = Int32.Parse(Request.Form["month"]); string sort = Request.Form["sort"]; string order = Request.Form["order"]; string name = Request.Form["name"]; string sector = Request.Form["sector"]; UserInfo user = (UserInfo)Session["user"]; DataTable dt = SalesReportManage.getSalesmanCompleteRate(year, month, name, sector, user); string json = ""; if (dt != null) { dt = PinYinHelper.SortByPinYin(dt, sort, order); json = JsonHelper.DataTable2Json(dt); } return(json.ToString()); }
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()); }