/// <summary>
/// 全线资料统计
/// </summary>
/// <returns></returns>
public DataTable QXZLTJ()
{
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTable("spweb_qxzlhzb", StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, 0, 1, 100000, "segment", "ASC", out pageCount, out records);
#region 添加总数
int pageCount1 = 0;
int records1 = 0;
string SelectedTestRoomCodes1 = "";
foreach (DataRow Dr in dt.Rows)
{
if (SelectedTestRoomCodes1.IndexOf("'" + Dr["testcode"].ToString() + "'") >= 0)
{
continue;
}
SelectedTestRoomCodes1 += string.IsNullOrEmpty(SelectedTestRoomCodes1) ? "'" + Dr["testcode"].ToString() + "'" : ",'" + Dr["testcode"].ToString() + "'";
}
DataTable dt1 = BLL.GetProcDataTable("spweb_qxzlhzb", DateTime.Parse("1999-1-1").ToString("yyyy-MM-dd"), DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes1, 0, 1, 100000, "segment", "ASC", out pageCount1, out records1);
dt.Columns.Add(new DataColumn("ncountA", typeof(string)));
dt.Columns.Add(new DataColumn("wncountA", typeof(string)));
DataTable _tempTable = new DataTable();
foreach (DataRow Dr in dt.Rows)
{
dt1.DefaultView.RowFilter = " testcode='" + Dr["testcode"].ToString() + "' AND modelid='" + Dr["modelid"].ToString() + "' ";
_tempTable = dt1.DefaultView.ToTable();
Dr["ncountA"] = _tempTable.Rows.Count > 0 ? _tempTable.Rows[0]["ncount"].ToString() : "";
Dr["wncountA"] = _tempTable.Rows.Count > 0 ? _tempTable.Rows[0]["wncount"].ToString() : "";
dt1.DefaultView.RowFilter = "";
}
#endregion
dt.Columns.Remove("id");
dt.Columns.Remove("project");
dt.Columns.Remove("testcode");
dt.Columns.Remove("modelid");
dt.Columns["segment"].ColumnName = "标段";
dt.Columns["company"].ColumnName = "单位";
dt.Columns["testroom"].ColumnName = "试验室";
dt.Columns["testname"].ColumnName = "试验名称";
dt.Columns["ncountA"].ColumnName = "总录入数";
dt.Columns["ncount"].ColumnName = "时间段内录入数";
dt.Columns["wncountA"].ColumnName = "不合格报告总数";
dt.Columns["wncount"].ColumnName = "时间段内不合格报告数";
dt.Columns["总录入数"].SetOrdinal(4);
dt.Columns["时间段内录入数"].SetOrdinal(5);
dt.Columns["不合格报告总数"].SetOrdinal(6);
dt.Columns["时间段内不合格报告数"].SetOrdinal(7);
return(dt);
}
private String qxzlhzb(String proc, int ftype, out int pageCount, out int records)
{
BLL_Document BLL = new BLL_Document();
DataTable dt = BLL.GetProcDataTable(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes, ftype, PageIndex, PageSize, OrderField, OrderType, out pageCount, out records);
#region 添加总数
int pageCount1 = 0;
int records1 = 0;
string SelectedTestRoomCodes1 = "";
foreach (DataRow Dr in dt.Rows)
{
SelectedTestRoomCodes1 += string.IsNullOrEmpty(SelectedTestRoomCodes1) ? "'" + Dr["testcode"].ToString() + "'" : ",'" + Dr["testcode"].ToString() + "'";
}
DataTable dt1 = BLL.GetProcDataTable(proc, DateTime.Parse("1999-1-1").ToString("yyyy-MM-dd"), DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes1, ftype, 1, 1000, OrderField, OrderType, out pageCount1, out records1);
//testcode modelid
dt.Columns.Add(new DataColumn("ncountA", typeof(string)));
dt.Columns.Add(new DataColumn("wncountA", typeof(string)));
DataTable _tempTable = new DataTable();
foreach (DataRow Dr in dt.Rows)
{
dt1.DefaultView.RowFilter = " testcode='" + Dr["testcode"].ToString() + "' AND modelid='" + Dr["modelid"].ToString() + "' ";
_tempTable = dt1.DefaultView.ToTable();
Dr["ncountA"] = _tempTable.Rows.Count > 0 ? _tempTable.Rows[0]["ncount"].ToString() : "";
Dr["wncountA"] = _tempTable.Rows.Count > 0 ? _tempTable.Rows[0]["wncount"].ToString() : "";
dt1.DefaultView.RowFilter = "";
}
#endregion
if (dt != null)
{
return(JsonConvert.SerializeObject(dt));
}
else
{
return("");
}
}
private String qxzlhzbcharttogrid(String proc, int ftype, String testcode, String modelid, out int pageCount, out int records)
{
BLL_Document BLL = new BLL_Document();
sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line;
//if (sysBaseLine.IsActive == 0)
//{
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
//}
DataTable dt = BLL.GetProcDataTable(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, modelid, ftype, PageIndex, PageSize, OrderField, OrderType, out pageCount, out records);
if (dt != null)
{
return(JsonConvert.SerializeObject(dt));
}
else
{
return("");
}
}
