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