public DataTable getEx_Data(int Pl_Code, IList <CRMTreeDatabase.EX_Param> eps) { try { CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code); var db = CRMTreeDatabase.DBCRMTree.GetInstance(); PetaPoco.Sql _s = BL_Reports.GetReportSql(Report.RP_Code, eps); var qData = new object(); if (_s.SQL.IndexOf(";Exec", StringComparison.OrdinalIgnoreCase) >= 0) { qData = db.Query <dynamic>(_s); } else { var pSql = PetaPoco.Sql.Builder; pSql.Append("select * from(" + _s.SQL, _s.Arguments); pSql.Append(") as dt"); qData = db.Query <dynamic>(pSql); } //Report.RP_Query = _s.SQL; //DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query); //return dt; string _j_d = JsonConvert.SerializeObject(qData); DataTable _d = ToDataTable(_j_d); return(_d); } catch { return(null); } }
public string[] GetRunAu_Code(int CG_Code, int UType, int AD_Code) { CT_Campaigns _c = GetCampaign(CG_Code); CT_Param_Value _p = new CT_Param_Value() { RP_Code = _c.CG_RP_Code, PV_Type = 1, PV_CG_Code = CG_Code, PV_UType = UType, PV_AD_OM_Code = AD_Code }; BL_Reports _bl_report = new BL_Reports(); CT_Reports _Report = _bl_report.GetReplaceReport(_p); 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 = "0"; ep.EX_DataType = "int"; eps.Add(ep); _Report.RP_Query = BL_Reports.GetReportSql(_Report.RP_Code, eps).SQL; string[] _au_code = _bl_report.GetUserCode(_Report.RP_Query, "AU_Code").Distinct().ToArray(); return(_au_code); }
/// <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); }