public static DataTable GetReportSqlWithTemplate(string sql, int PR = 0)
{
string[] sqls = sql.Split(new string[] { "|-|" }, StringSplitOptions.None);
if (sqls.Length == 1)
{
sql = sqls[0];
}
else if (sqls.Length == 2)
{
sql = sqls[1];
var db = CRMTreeDatabase.DBCRMTree.GetInstance();
var procSql = sqls[0];
var pr = new CRMTreeDatabase.EX_Param();
pr.EX_DataType = "int";
pr.EX_Name = "PR";
pr.EX_Value = PR.ToString();
List <CRMTreeDatabase.EX_Param> ps = new List <CRMTreeDatabase.EX_Param>();
ps.Add(pr);
var pSql = SetReportSql(procSql, ps);
var tags = db.Query <CRMTreeDatabase.EX_Tag>(pSql);
foreach (var tag in tags)
{
sql = sql.Replace(tag.PL_Tag, tag.PV_Val);
}
}
return(DL_Reports.QueryExecution(sql));
}
public BL_Report_Service()
{
_d_report = new DL_Reports();
}
/// <summary>
/// 根据报表的RP_Query来执行SQl，返回表格形式
/// </summary>
/// <param name="RP_Query"></param>
/// <returns></returns>
public static DataTable QueryExecution(string RP_Query)
{
return(DL_Reports.QueryExecution(RP_Query));
}
