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("");
}
}
private String parallellinechart(string proc, string testcode, int nUnit)
{
BLL_ParallelReport BLL = new BLL_ParallelReport();
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, nUnit);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["result"].ToString();
trcs.IntNumber = Int32.Parse(dr["counts"].ToString());
trcs.Para1 = dr["testroomID"].ToString();
trcs.Para2 = dr["modelid"].ToString();
trcs.Para3 = dr["stype"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
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);
}
private String parallelchartgrid(String proc, int ftype, String testcode, String modelid, out int pageCount, out int records)
{
BLL_ParallelReport BLL = new BLL_ParallelReport();
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("");
}
}
private String pxreportpop(string proc, int ftype, string startdate, string enddate, string testcode, string modelid)
{
BLL_ParallelReport BLL = new BLL_ParallelReport();
DataTable dt = BLL.GetProcDataTableChartsPara6(proc, ftype, startdate, enddate, testcode, modelid);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["chartDate"].ToString();
trcs.IntNumber = Int32.Parse(dr["zjCount"].ToString());
trcs.IntNumberMarks = Int32.Parse(dr["pxjzCount"].ToString());
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}