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); }
public int ReportRun(ReportRunParam rParam) { //-1 代表请求参数为空; if (rParam == null) { return(-1); } CT_Reports _r; if (rParam.pType == 1) { BL_Campaign c = new BL_Campaign(); CT_Campaigns _c = c.GetCampaign(rParam.CG_EV_Code); CT_Param_Value _p = new CT_Param_Value() { RP_Code = _c.CG_RP_Code, PV_Type = 1, PV_CG_Code = _c.CG_Code, PV_UType = rParam.UType, PV_AD_OM_Code = rParam.AU_AD_OM_Code }; _r = 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); //var oeps = JsonConvert.SerializeObject(eps); _r.RP_Query = GetReportSql(_r.RP_Code, eps).SQL; return(_D_re.ReportRun <CT_Campaigns>(_r, _c, rParam.UType, rParam.AU_AD_OM_Code)); } else if (rParam.pType == 2) { DL_Event e = new DL_Event(); CT_Events _e = e.getEvents(rParam.CG_EV_Code); CT_Param_Value _p = new CT_Param_Value() { RP_Code = _e.EV_RP_Code, PV_Type = 2, PV_CG_Code = _e.EV_Code, PV_UType = rParam.UType, PV_AD_OM_Code = rParam.AU_AD_OM_Code }; _r = GetReplaceReport(_p); _r.RP_Query = GetReportSql(_r.RP_Code, null).SQL; return(_D_re.ReportRun <CT_Events>(_r, _e, rParam.UType, rParam.AU_AD_OM_Code)); } return(-1); }
public DataTable getfile_Rep_value(int CG_Code, int AU_Type, int AU_AD_OM_Code) { CT_Campaigns _o = GetCampaign(CG_Code); CT_Param_Value _p = new CT_Param_Value() { RP_Code = _o.CG_RP_Code, PV_Type = 1, PV_CG_Code = _o.CG_Code, PV_UType = AU_Type, PV_AD_OM_Code = AU_AD_OM_Code }; BL_Reports R = new BL_Reports(); CT_Reports _r = R.GetReplaceReport(_p); DataTable dt_Query = BL_Reports.QueryExecution(_r.RP_Query); return(dt_Query); }
/// <summary> /// 获取报表,以及报表相关的参数值=》名称、描述、query等; /// </summary> /// <param name="Param_value"></param> /// <returns></returns> public MD_ReportList GetReportValue(CT_Param_Value Param_value) { #region 参数 SqlParameter[] _p = { new SqlParameter("@RP_Code", SqlDbType.Int, 4), new SqlParameter("@PV_Type", SqlDbType.Int, 4), new SqlParameter("@PV_CG_Code", SqlDbType.Int, 4), new SqlParameter("@PV_UType", SqlDbType.Int, 4), new SqlParameter("@AD_Code", SqlDbType.Int, 4), new SqlParameter("@DG_Code", SqlDbType.Int, 4), new SqlParameter("@OM_Code", SqlDbType.Int, 4), }; _p[0].Value = Param_value.RP_Code; _p[1].Value = Param_value.PV_Type; _p[2].Value = Param_value.PV_CG_Code; _p[3].Value = Param_value.PV_UType; if (Param_value.PV_UType == 1) { _p[4].Value = Param_value.PV_AD_OM_Code; _p[5].Value = null; _p[6].Value = null; } else if (Param_value.PV_UType == 2) { _p[4].Value = null; _p[5].Value = Param_value.PV_AD_OM_Code; _p[6].Value = null; } else if (Param_value.PV_UType == 3) { _p[4].Value = null; _p[5].Value = null; _p[6].Value = Param_value.PV_AD_OM_Code; } #endregion DataSet ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "RP_GetReportValue", _p); MD_ReportList o = new MD_ReportList(); o.CT_Reports_List = DataHelper.ConvertToList <CT_Reports>(ds); return(o); }
/// <summary> /// 根据单一的Code获取报表对应的参数列表,和参数名称 /// 供更改参数列表的窗体调用 /// </summary> /// <param name="Intern"></param> /// <param name="Param_value"></param> /// <returns></returns> public MD_Paramterslist GetParamterslist(bool Intern, CT_Param_Value Param_value) { MD_ReportList MD_List = GetReportValue(Param_value); if (!Intern) { MD_List = ReportReplace.NameReplace(MD_List); } MD_Paramterslist Param = new MD_Paramterslist(); Param.CT_Paramters_list = new List <CT_Paramters_list>(); foreach (CT_Reports RE in MD_List.CT_Reports_List) { CT_Paramters_list p_List = new CT_Paramters_list(); p_List.PL_Code = RE.PL_Code; p_List.PL_Prompt_En = RE.PL_Prompt_En; p_List.PL_Type = RE.PL_Type; p_List.PL_Default = RE.PL_Default; Param.CT_Paramters_list.Add(p_List); } return(Param); }
/// <summary> /// 获取替换成功后的Report, /// Name Desc 都做了替换 可以单独使用,也可供其他方式调用 /// </summary> /// <param name="Intern"></param> /// <param name="Param_value"></param> /// <param name="Mode"></param> /// <param name="Paramterslist"></param> /// <returns></returns> public CT_Reports GetReplaceReport(bool Intern, CT_Param_Value Param_value, EM_ParameterMode Mode, string Paramterslist) { MD_ReportList MD_List = GetReportValue(Param_value); if (MD_List == null || MD_List.CT_Reports_List == null) { return(null); } if (!Intern) { MD_List = ReportReplace.NameReplace(MD_List); } MD_List = BL_ReportReplace.ReportParamReplace(MD_List, Mode, Paramterslist, Intern); CT_Reports Report = null; if (MD_List != null || MD_List.CT_Reports_List[0] != null) { Report = MD_List.CT_Reports_List[0]; Report.RP_Query = ReportReplace.ReportParamReplace(Report.RP_Query); } return(Report); }
/// <summary> /// 获取报表的相关的值,根据传递的Code /// 如果Pv_val 不为空,就将值赋值与PL_Default /// new CT_Param_Value() { /// RP_Code = RP_Code, /// PV_Type = 1/2, /// PV_CG_Code = CG_Code/EV_Code, /// PV_UType = UG_UType, /// PV_AD_OM_Code =DE_AD_OM_Code } /// </summary> /// <param name="Param_value"></param> /// <returns></returns> private MD_ReportList GetReportValue(CT_Param_Value Param_value) { return(_D_re.GetReportValue(Param_value)); }
/// <summary> /// 获取替换成功后的Report, /// Name Desc 都做了替换 可以单独使用,也可供其他方式调用 /// </summary> /// <param name="Intern"></param> /// <param name="Param_value"></param> /// <returns></returns> public CT_Reports GetReplaceReport(bool Intern, CT_Param_Value Param_value) { return(GetReplaceReport(Intern, Param_value, EM_ParameterMode.Background, null)); }
/// <summary> /// 获取替换成功后的Report, /// Name Desc 都做了替换 可以单独使用,也可供其他方式调用 /// </summary> /// <param name="Param_value"></param> /// <returns></returns> public CT_Reports GetReplaceReport(CT_Param_Value Param_value) { return(GetReplaceReport(true, Param_value)); }