private String qxzlhzbchartpop(string proc, string testcode)
{
BLL_Document BLL = new BLL_Document();
sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line;
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["testname"].ToString();
trcs.IntNumber = Int32.Parse(dr["ncount"].ToString());
trcs.Para1 = dr["modelid"].ToString();
trcs.Para2 = dr["segment"].ToString() + "-" + dr["company"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private String failreportsum(string proc, int ntype)
{
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
if (ntype == 1)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString();
trcs.Para1 = dr["companycode"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
else if (ntype == 2)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString() + "\n" + dr["testroom"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private void Chart()
{
if ("Act".RequestStr() != "Chart")
{
return;
}
int ntype = 1;
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTableChartsPara5("spweb_failreport_chart_order", "StartDate".RequestStr(), DateTime.Parse("EndDate".RequestStr()).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
if (ntype == 1)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString();
trcs.Para1 = dr["companycode"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
trcs.FloatNumber1 = Int32.Parse(dr["uncounts"].ToString());
}
else if (ntype == 2)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString() + "\n" + dr["testroom"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
list.Add(trcs);
}
Response.Write(JsonConvert.SerializeObject(list));
}
else
{
Response.Write("");
}
Response.End();
}
private String loginlogpop(string proc, string testcode)
{
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["UserName"].ToString();
trcs.DescriptionDate = DateTime.Parse(dr["FirstAccessTime"].ToString());
trcs.DescriptionDate1 = DateTime.Parse(dr["LastAccessTime"].ToString());
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
private String qxzlhzbchart(string proc, int ntype)
{
if (String.IsNullOrEmpty(SelectedTestRoomCodes))
{
#region
JZ.BLL.BLL_TestRoom bll_testroom = new JZ.BLL.BLL_TestRoom();
DataTable dt = bll_testroom.GetTree();
DataTable dt_user = bll_testroom.GetUsersTestRoom(UserName);
int n = 0;
DataTable dtnew = new DataTable();
dtnew = dt.Clone();
if (dt_user != null && dt_user.Rows.Count > 0)
{
n = dt_user.Rows.Count;
#region
if (n == 1)
{
string testroom = dt_user.Rows[0]["testroomcode"].ToString().Trim();
if (testroom == "0001")
{
foreach (DataRow oldDR in dt.Rows)
{
DataRow newDR = dtnew.NewRow(); //新表创建新行
newDR.ItemArray = oldDR.ItemArray; //旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
if (testroom.Length == 8)//监理一个单位或者中心实验室主任，8位标段编码
{
foreach (DataRow oldDR in dt.Rows)
{
DataRow newDR = dtnew.NewRow();//新表创建新行
if (oldDR["NodeCode"].ToString().Length > 7)
{
if (oldDR["NodeCode"].ToString().Substring(0, 8) == testroom)
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
}
}
if (testroom.Length == 16)
{
foreach (DataRow oldDR in dt.Rows)
{
DataRow newDR = dtnew.NewRow();//新表创建新行
if (oldDR["NodeCode"].ToString().Length > 7)
{
if (oldDR["NodeCode"].ToString() == testroom.Substring(0, 8))
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
if (oldDR["NodeCode"].ToString() == testroom.Substring(0, 12))
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
if (oldDR["NodeCode"].ToString() == testroom)
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
}
}
#endregion
if (n > 1)
{
DataRow newDR = dtnew.NewRow();//新表创建新行
foreach (DataRow item in dt_user.Rows)
{
string testroom = item["testroomcode"].ToString().Trim();
if (testroom.Length == 8)//监理一个单位或者中心实验室主任，8位标段编码
{
foreach (DataRow oldDR in dt.Rows)
{
if (oldDR["NodeCode"].ToString().Length > 7)
{
if (oldDR["NodeCode"].ToString().Substring(0, 8) == testroom)
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
}
}
if (testroom.Length == 16)
{
foreach (DataRow oldDR in dt.Rows)
{
if (oldDR["NodeCode"].ToString().Length > 7)
{
if (oldDR["NodeCode"].ToString() == testroom.Substring(0, 8))
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
if (oldDR["NodeCode"].ToString() == testroom.Substring(0, 12))
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
if (oldDR["NodeCode"].ToString() == testroom)
{
newDR.ItemArray = oldDR.ItemArray;//旧表结构行赋给新表结构行
dtnew.ImportRow(oldDR);
}
}
}
}
for (int i = 0; i < dtnew.Rows.Count; i++)
{
for (int j = i + 1; j < dtnew.Rows.Count; j++)
{
if (dtnew.Rows[i]["NodeCode"].ToString().Trim() == dtnew.Rows[j]["NodeCode"].ToString().Trim())
{
dtnew.Rows.RemoveAt(j);
}
}
}
}
}
GetDTJson(dtnew);
#endregion
}
BLL_Document BLL = new BLL_Document();
DataTable dt1 = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, ntype);
if (dt1 != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt1.Rows)
{
ChartModel trcs = new ChartModel();
if (ntype == 1)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString();
trcs.Para1 = dr["companycode"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
else if (ntype == 2)
{
trcs.Description = dr["segment"].ToString() + "\n" + dr["company"].ToString() + "\n" + dr["testroom"].ToString();
trcs.IntNumber = Int32.Parse(dr["totalncount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["counts"].ToString());
trcs.DoubleNumber = Double.Parse(dr["prenct"].ToString());
}
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
