public DataTable getMultiData(int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Multi, RP_Code);
if (_r == null)
{
return(null);
}
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
return(dt);
}
public DataTable getSchData(int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Sch, RP_Code);
if (_r == null)
{
return(null);
}
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
// DataTable dt = DAL.DL_Reports.QueryExecution(ReportReplace.ReportParamReplace(_r.RP_Query));
return(dt);
}
public DataTable getPieData(int FL_FB_Code, out int RP_Code, int PR = 0)
{
CT_Reports _r = _B_rp.GetReprot_Chat(ChartType.Pie, FL_FB_Code);
if (_r == null)
{
RP_Code = -1;
return(null);
}
//DataTable dt = DL_Reports.QueryExecution(ReportReplace.ReportParamReplace(_r.RP_Query));
DataTable dt = BL_Reports.GetReportSqlWithTemplate(ReportReplace.ReportParamReplace(_r.RP_Query), PR);
RP_Code = _r.RP_Code;
return(dt);
}
/// <summary>
/// 获取下载的数据
/// </summary>
/// <param name="Pl_Code"></param>
/// <param name="PR"></param>
/// <returns></returns>
private DataTable getEx_Data(int Pl_Code, int PR)
{
CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code);
List <CRMTreeDatabase.EX_Param> eps = new List <CRMTreeDatabase.EX_Param>();
CRMTreeDatabase.EX_Param ep = new CRMTreeDatabase.EX_Param();
ep.EX_Name = "PR";
ep.EX_Value = PR.ToString();
ep.EX_DataType = "int";
eps.Add(ep);
Report.RP_Query = BL_Reports.GetReportSql(Report.RP_Code, eps).SQL;
DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query);
return(dt);
}