private String pxreport(String proc, int ftype, out int pageCount, out int records)
{
BLL_ParallelReport BLL = new BLL_ParallelReport();
sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line;
if (sysBaseLine.IsActive == 0)
{
}
else
{
proc = "sp_pxjz_report";
}
string Meet = "meet".RequestStr();
Meet = Meet.IsNullOrEmpty() ? "0" : Meet;
DataTable dt = BLL.GetProcDataTable(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes.Replace("'", ""), ftype, PageIndex, PageSize, Meet, OrderType, out pageCount, out records);
if (dt != null)
{
return(JsonConvert.SerializeObject(dt));
}
else
{
return("");
}
}
/// <summary>
/// 见证频率分析
/// </summary>
/// <returns></returns>
public DataTable JZPLFX()
{
// json = pxreport("", 2, out pageCount, out records);
string proc = "";
BLL_ParallelReport BLL = new BLL_ParallelReport();
sys_line sysBaseLine = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line;
if (sysBaseLine.IsActive == 0)
{
}
else
{
proc = "sp_pxjz_report";
}
string meet = "meet".RequestStr();
DataTable dt = BLL.GetProcDataTable(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), SelectedTestRoomCodes.Replace("'", ""), 2, 1, 100000, meet, "ASC", out pageCount, out records);
dt.Columns.Remove("id");
dt.Columns.Remove("modelID");
dt.Columns.Remove("testroomID");
dt.Columns.Remove("pxqulifty");
dt.Columns["modelName"].ColumnName = "试验名称";
dt.Columns["condition"].ColumnName = "标准见证频率(%)";
dt.Columns["zjCount"].ColumnName = "施工单位资料总数";
dt.Columns["pxCount"].ColumnName = "见证次数";
dt.Columns["frequency"].ColumnName = "见证频率(%)";
dt.Columns["result"].ColumnName = "是否满足要求";
dt.Columns["segment"].ColumnName = "标段";
dt.Columns["jl"].ColumnName = "监理单位";
dt.Columns["sg"].ColumnName = "施工单位";
dt.Columns["testroom"].ColumnName = "施工单位试验室";
dt.Columns["标段"].SetOrdinal(0);
dt.Columns["监理单位"].SetOrdinal(1);
dt.Columns["施工单位"].SetOrdinal(2);
dt.Columns["施工单位试验室"].SetOrdinal(3);
dt.Columns["试验名称"].SetOrdinal(4);
dt.Columns["标准见证频率(%)"].SetOrdinal(5);
dt.Columns["施工单位资料总数"].SetOrdinal(6);
dt.Columns["见证次数"].SetOrdinal(7);
dt.Columns["见证频率(%)"].SetOrdinal(8);
dt.Columns["是否满足要求"].SetOrdinal(9);
return(dt);
}
