/// <summary>
/// 获取某一报表配置好完整SQL,[用动态参数配置报表sql]
/// </summary>
/// <param name="rp_code">报表Code</param>
/// <param name="_params">动态参数</param>
/// <returns></returns>
public string SqlParamReplace(int rp_code, IList <_param> _params)
{
CT_Reports _c_report = _d_report.GetReprot(rp_code);
if (_c_report == null)
{
return(string.Empty);
}
string sql = ReportReplace.ReportParamReplace(_c_report.RP_Query);
string[] sqls = sql.Split(new string[] { "|-|" }, StringSplitOptions.None);
if (sqls.Length == 1)
{
sql = sqls[0];
}
if (_params != null)
{
foreach (_param _p in _params)
{
string _pp = string.Format("@{0}", _p.Kay.Trim());
sql = sql.Replace(_pp, _p.Value);
}
}
return(sql);
}
/// <summary>
/// 获取没有配置参数的报表
/// </summary>
/// <param name="RP_Code"></param>
/// <returns></returns>
public CT_Reports GetReprot(int RP_Code)
{
return(_D_re.GetReprot(RP_Code));
}