private void BarMonthTasknumber(HttpContext context)
{
BLL.ChartReport bll = new BLL.ChartReport();
string strYear = context.Request["Year"];
if (string.IsNullOrEmpty(strYear))
{
strYear = DateTime.Now.Year.ToString();
}
DataSet ds = bll.BarMonthTasknumber(strYear);
List <Model.ChartReport.MonthData> list = new List <Model.ChartReport.MonthData>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.ChartReport.MonthData()
{
Month = Convert.ToInt32(dr["CR_Month"]),
DataPreMonth = Convert.ToInt32(dr["CR_TaskNumber"])
});
}
//for (int i = 0; i < 12; i++)
//{
// Model.ChartReport list.Find()
//}
//list.Sort();
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void LineMonthBugnoRelease(HttpContext context)
{
BLL.ChartReport bll = new BLL.ChartReport();
string Year = context.Request["Year"];
if (string.IsNullOrEmpty(Year))
{
Year = DateTime.Now.Year.ToString();
}
DataSet ds = bll.LineMonthBugnoRelease(Year);
List <Model.ChartReport.LabelReleaseData> list = new List <Model.ChartReport.LabelReleaseData>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.ChartReport.LabelReleaseData()
{
LabelName = dr["MonthNum"].ToString(),
Release = dr["TT_Release"].ToString(),
iData = Convert.ToInt32(dr["IssueNo"])
});
}
string[] arrRelease = { "W14", "W15", "W16", "LM" };
Model.ChartReport.LabelReleaseData modelCheck;
for (int i = 1; i <= 12; i++)
{
foreach (string Release in arrRelease)
{
modelCheck = list.Find(delegate(Model.ChartReport.LabelReleaseData model)
{
return(model.LabelName == i.ToString() && model.Release == Release);
});
if (modelCheck == null)
{
list.Add(new Model.ChartReport.LabelReleaseData()
{
LabelName = i.ToString(),//.Length == 1 ? '0' + i.ToString() : i.ToString()
Release = Release,
iData = 0
});
}
}
}
list = list.OrderBy(o => o.LabelName.PadLeft(2, '0')).ThenBy(o => o.Release).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void PieResolutionBugno(HttpContext context)
{
BLL.ChartReport bll = new BLL.ChartReport();
string Year = context.Request["Year"];
string Season = context.Request["Season"];
string strDateTime = GetDateTimeWithYearSeasonNum(Year, Season);
DataSet ds = bll.PieResolutionBugno(strDateTime);
List <Model.ChartReport.LabelDataPercent> list = new List <Model.ChartReport.LabelDataPercent>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.ChartReport.LabelDataPercent()
{
LabelName = dr["BI_Resolution"].ToString(),
iData = Convert.ToInt32(dr["BugNo"]),
Percent = Convert.ToInt32(dr["BugPercent"].ToString() == "" ? 0 : dr["BugPercent"]).ToString() + '%'
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void BarTaskstyleCaseno(HttpContext context)
{
BLL.ChartReport bll = new BLL.ChartReport();
string strYear = context.Request["Year"];
string strSeason = context.Request["Season"];
string strDateTime = GetDateTimeWithYearSeasonNum(strYear, strSeason);
DataSet ds = bll.BarTaskstyleCaseno(strDateTime);
List <Model.ChartReport.LabelData> list = new List <Model.ChartReport.LabelData>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.ChartReport.LabelData()
{
LabelName = dr["TaskType"].ToString(),
iData = Convert.ToInt32(dr["CaseNo"])
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
