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