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