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