コード例 #1
0
        public ActionResult DocumentViewerPartial(string QueryS)
        {
            string[] pars = QueryS.Split('|');
            string id = pars.Where(s => s.Split('=')[0].Equals("id")).FirstOrDefault().Split('=')[1];
            string CreateDate = pars.Where(s => s.Split('=')[0].Equals("CreateDate")).FirstOrDefault().Split('=')[1];
            string LastActivityDate = pars.Where(s => s.Split('=')[0].Equals("LastActivityDate")).FirstOrDefault().Split('=')[1];
            string StartDate = pars.Where(s => s.Split('=')[0].Equals("StartDate")).FirstOrDefault().Split('=')[1];
            string EndDate = pars.Where(s => s.Split('=')[0].Equals("EndDate")).FirstOrDefault().Split('=')[1];
            string Agent = pars.Where(s => s.Split('=')[0].Equals("Agent")).FirstOrDefault().Split('=')[1];
            string SalesRep = pars.Where(s => s.Split('=')[0].Equals("SalesRep")).FirstOrDefault().Split('=')[1];
            string Module = pars.Where(s => s.Split('=')[0].Equals("Module")).FirstOrDefault().Split('=')[1];
            string ContractStatus = pars.Where(s => s.Split('=')[0].Equals("ContractStatus")).FirstOrDefault().Split('=')[1];
            string Type = pars.Where(s => s.Split('=')[0].Equals("Type")).FirstOrDefault().Split('=')[1];
            string Percent = pars.Where(s => s.Split('=')[0].Equals("Percent")).FirstOrDefault().Split('=')[1];
            string Merchant = pars.Where(s => s.Split('=')[0].Equals("Merchant")).FirstOrDefault().Split('=')[1];
            string TaskStatus = pars.Where(s => s.Split('=')[0].Equals("TaskStatus")).FirstOrDefault().Split('=')[1];

            DevExpress.XtraReports.Parameters.Parameter prm1;
            DevExpress.XtraReports.Parameters.Parameter prm2;
            DevExpress.XtraReports.Parameters.Parameter prm3;

            switch (id)
            {
                case "0":
                    break;
                case "1":
                    ViewData["Report"] = new Pecuniaus.Reports.Collection();
                    break;
                case "2":
                    Pecuniaus.Reports.Contracts_Contract cnt = new Pecuniaus.Reports.Contracts_Contract();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = cnt.Parameters["Agent"];
                    prm2 = cnt.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    cnt.Parameters.Add(prm1);
                    cnt.Parameters.Add(prm2);
                    cnt.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = cnt;
                    break;
                case "3":
                    Pecuniaus.Reports.Contracts_DeclinedByAvanzame avz = new Pecuniaus.Reports.Contracts_DeclinedByAvanzame();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = avz.Parameters["Agent"];
                    prm2 = avz.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    avz.Parameters.Add(prm1);
                    avz.Parameters.Add(prm2);
                    avz.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = avz;
                    break;
                case "4":
                    Pecuniaus.Reports.Contracts_DeclinedByClient dc = new Pecuniaus.Reports.Contracts_DeclinedByClient();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = dc.Parameters["Agent"];
                    prm2 = dc.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    dc.Parameters.Add(prm1);
                    dc.Parameters.Add(prm2);
                    dc.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = dc;
                    break;
                case "5":
                    Pecuniaus.Reports.Contracts_Pending cp = new Pecuniaus.Reports.Contracts_Pending();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = cp.Parameters["Agent"];
                    prm2 = cp.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    cp.Parameters.Add(prm1);
                    cp.Parameters.Add(prm2);
                    cp.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = cp;
                    break;
                case "6":
                    Pecuniaus.Reports.Investigation rep = new Pecuniaus.Reports.Investigation();
                    prm1 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = rep.Parameters["Merchant"];
                    prm1.Value = Merchant;
                    rep.Parameters.Add(prm1);
                    rep.FilterString = "[Merchant] = [Parameters.Merchant]";
                    ViewData["Report"] = rep;
                    break;
                case "7":
                    Pecuniaus.Reports.Monthly_MCA mm = new Pecuniaus.Reports.Monthly_MCA();
                    prm1 = prm2 = prm3 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = mm.Parameters["ContractStatus"];
                    prm2 = mm.Parameters["Date"];
                    prm3 = mm.Parameters["Type"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    prm3.Value = Module;
                    mm.Parameters.Add(prm1);
                    mm.Parameters.Add(prm2);
                    mm.Parameters.Add(prm3);
                    mm.FilterString = "[ContractStatus] = [Parameters.ContractStatus] AND [Date] = [Parameters.Date] AND [Type]=[Parameters.Type]";
                    ViewData["Report"] = mm;
                    break;
                case "8":
                    Pecuniaus.Reports.Notes nt = new Pecuniaus.Reports.Notes();
                    prm1 = prm2 = prm3 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = nt.Parameters["Agent"];
                    prm2 = nt.Parameters["Date"];
                    prm3 = nt.Parameters["Module"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    prm3.Value = Module;
                    nt.Parameters.Add(prm1);
                    nt.Parameters.Add(prm2);
                    nt.Parameters.Add(prm3);
                    nt.FilterString = "[Agent] = [Parameters.Agent] AND [Date] = [Parameters.Date] AND [Module]=[Parameters.Module]";
                    ViewData["Report"] = nt;
                    break;
                case "9":
                    Pecuniaus.Reports.PAFReport av = new Pecuniaus.Reports.PAFReport();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = av.Parameters["StartDate"];
                    prm2 = av.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    av.Parameters.Add(prm1);
                    av.Parameters.Add(prm2);
                    av.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = av;
                    break;
                case "10":
                    Pecuniaus.Reports.Prequalification pq = new Pecuniaus.Reports.Prequalification();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pq.Parameters["Agent"];
                    prm2 = pq.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    pq.Parameters.Add(prm1);
                    pq.Parameters.Add(prm2);
                    pq.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = pq;
                    break;
                case "11":
                    Pecuniaus.Reports.Prequalification_DeclinedByAvanzame pqavz = new Pecuniaus.Reports.Prequalification_DeclinedByAvanzame();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pqavz.Parameters["Agent"];
                    prm2 = pqavz.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    pqavz.Parameters.Add(prm1);
                    pqavz.Parameters.Add(prm2);
                    pqavz.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = pqavz;
                    break;
                case "12":
                    Pecuniaus.Reports.Prequalification_DeclinedByClient pqdcb = new Pecuniaus.Reports.Prequalification_DeclinedByClient();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pqdcb.Parameters["Agent"];
                    prm2 = pqdcb.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    pqdcb.Parameters.Add(prm1);
                    pqdcb.Parameters.Add(prm2);
                    pqdcb.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = pqdcb;
                    break;
                case "13":
                    Pecuniaus.Reports.Prequalification_Offers ofr = new Pecuniaus.Reports.Prequalification_Offers();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ofr.Parameters["Agent"];
                    prm2 = ofr.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    ofr.Parameters.Add(prm1);
                    ofr.Parameters.Add(prm2);
                    ofr.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = ofr;
                    break;
                case "14":
                    Pecuniaus.Reports.Prequalifications_Pending pqpen = new Pecuniaus.Reports.Prequalifications_Pending();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pqpen.Parameters["Agent"];
                    prm2 = pqpen.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    pqpen.Parameters.Add(prm1);
                    pqpen.Parameters.Add(prm2);
                    pqpen.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = pqpen;
                    break;
                case "15":
                    Pecuniaus.Reports.Prequalifications_AcceptedOffers acp = new Pecuniaus.Reports.Prequalifications_AcceptedOffers();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = acp.Parameters["Agent"];
                    prm2 = acp.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    acp.Parameters.Add(prm1);
                    acp.Parameters.Add(prm2);
                    acp.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = acp;
                    break;
                case "16":
                    Pecuniaus.Reports.Refund_Done refd = new Pecuniaus.Reports.Refund_Done();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = refd.Parameters["DatePaidInFull"];
                    prm2 = refd.Parameters["LastActvityDate"];
                    prm1.Value = System.Convert.ToDateTime(CreateDate);
                    prm2.Value = System.Convert.ToDateTime(LastActivityDate);
                    refd.Parameters.Add(prm1);
                    refd.Parameters.Add(prm2);
                    refd.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = refd;
                    break;
                case "17":
                    ViewData["Report"] = new Pecuniaus.Reports.Refund_Pending();
                    break;
                case "18":
                    Pecuniaus.Reports.Renewals ren = new Pecuniaus.Reports.Renewals();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ren.Parameters["Agent"];
                    prm2 = ren.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    ren.Parameters.Add(prm1);
                    ren.Parameters.Add(prm2);
                    ren.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = ren;
                    break;
                case "19":
                    Pecuniaus.Reports.Renewals_Pending pen = new Pecuniaus.Reports.Renewals_Pending();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pen.Parameters["Agent"];
                    prm2 = pen.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    pen.Parameters.Add(prm1);
                    pen.Parameters.Add(prm2);
                    pen.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = pen;
                    break;
                case "20":
                    Pecuniaus.Reports.Renewals_DeclinedByAvanzeMe dca = new Pecuniaus.Reports.Renewals_DeclinedByAvanzeMe();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = dca.Parameters["Agent"];
                    prm2 = dca.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    dca.Parameters.Add(prm1);
                    dca.Parameters.Add(prm2);
                    dca.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = dca;
                    break;
                case "21":
                    Pecuniaus.Reports.Renewals_DeclinedByClient dcb = new Pecuniaus.Reports.Renewals_DeclinedByClient();
                    prm1 = prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = dcb.Parameters["Agent"];
                    prm2 = dcb.Parameters["SalesRep"];
                    prm1.Value = Agent;
                    prm2.Value = SalesRep;
                    dcb.Parameters.Add(prm1);
                    dcb.Parameters.Add(prm2);
                    dcb.FilterString = "[Agent] = [Parameters.Agent] AND [SalesRep] = [Parameters.SalesRep]";
                    ViewData["Report"] = dcb;
                    break;
                case "22":
                    Pecuniaus.Reports.ScoringReport sc = new Pecuniaus.Reports.ScoringReport();
                    prm1 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = sc.Parameters["CreationDate"];
                    prm1.Value = System.Convert.ToDateTime(CreateDate);//System.Convert.ToDateTime("2015-03-16 20:02:28");
                    sc.Parameters.Add(prm1);
                    sc.FilterString = "[CreationDate] = [Parameters.CreationDate]";
                    ViewData["Report"] = sc;
                    break;
                case "23":
                    Pecuniaus.Reports.WorkFlowReport wf = new Pecuniaus.Reports.WorkFlowReport();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = wf.Parameters["StartDate"];
                    prm2 = wf.Parameters["TaskStatus"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = TaskStatus;
                    wf.Parameters.Add(prm1);
                    wf.Parameters.Add(prm2);
                    wf.FilterString = "[StartDate] = [Parameters.StartDate] AND [TaskStatus] = [Parameters.TaskStatus]";
                    ViewData["Report"] = wf;
                    break;
                case "24":
                    Pecuniaus.Reports.WrittenOffContracts wof = new Pecuniaus.Reports.WrittenOffContracts();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = wof.Parameters["StartDate"];
                    prm2 = wof.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    wof.Parameters.Add(prm1);
                    wof.Parameters.Add(prm2);
                    wof.FilterString = "[StartFundingDate] = [Parameters.StartDate] AND [EndFundingDate] = [Parameters.EndDate]";
                    ViewData["Report"] = wof;
                    break;
                case "25":
                    Pecuniaus.Reports.WSF_Report wsf = new Pecuniaus.Reports.WSF_Report();
                    prm1 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = wsf.Parameters["Date"];
                    prm1.Value = System.Convert.ToDateTime(CreateDate);
                    wsf.Parameters.Add(prm1);
                    wsf.FilterString = "[Date] = [Parameters.Date]";
                    ViewData["Report"] = wsf;
                    break;
                case "26":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_BadDebtRecoveryAccount();
                    break;
                case "27":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_Collection();
                    break;
                case "28":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_Contract_Activity();
                    break;
                case "29":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_DAR_New_Renewalcs();
                    break;
                case "30":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_Processing_Assets();
                    break;
                case "31":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_Progress_New_Renewal();
                    break;
                case "32":
                    ViewData["Report"] = new Pecuniaus.Reports.Author_RefundsDone();
                    break;
                case "33":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_RefundsEarrings();
                    break;
                case "34":
                    ViewData["Report"] = new Pecuniaus.Reports.Auditor_Research();
                    break;
                case "35":
                    Pecuniaus.Reports.Monthly_Portfolio_del_Avance port = new Pecuniaus.Reports.Monthly_Portfolio_del_Avance();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = port.Parameters["StartDate"];
                    prm2 = port.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    port.Parameters.Add(prm1);
                    port.Parameters.Add(prm2);
                    port.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = port;
                    break;
                case "36":
                    Pecuniaus.Reports.Monthly_Ingreso ming = new Pecuniaus.Reports.Monthly_Ingreso();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ming.Parameters["StartDate"];
                    prm2 = ming.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    ming.Parameters.Add(prm1);
                    ming.Parameters.Add(prm2);
                    ming.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = ming;
                    break;
                case "37":
                    Pecuniaus.Reports.Monthly_Saldos_de_avance ing = new Pecuniaus.Reports.Monthly_Saldos_de_avance();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ing.Parameters["StartDate"];
                    prm2 = ing.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    ing.Parameters.Add(prm1);
                    ing.Parameters.Add(prm2);
                    ing.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = ing;
                    break;
                case "38":
                    Pecuniaus.Reports.Monthly_DAR_Pendiente mon = new Pecuniaus.Reports.Monthly_DAR_Pendiente();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = mon.Parameters["StartDate"];
                    prm2 = mon.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    mon.Parameters.Add(prm1);
                    mon.Parameters.Add(prm2);
                    mon.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = mon;
                    break;
                case "39":
                    Pecuniaus.Reports.Monthly_Procesamiento_Saldo_del_avance di = new Pecuniaus.Reports.Monthly_Procesamiento_Saldo_del_avance();
                    prm1=prm2 =prm3= new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = di.Parameters["StartDate"];
                    prm2 = di.Parameters["EndDate"];
                    prm3 = di.Parameters["Percent"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    prm3.Value = Percent;
                    di.Parameters.Add(prm1);
                    di.Parameters.Add(prm2);
                    di.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate] AND [Percent]=[Parameters.Percent]";
                    ViewData["Report"] = di;
                    break;
                case "40":
                    Pecuniaus.Reports.Monthly_Procesamiento_DAR_PENDIENTE pro = new Pecuniaus.Reports.Monthly_Procesamiento_DAR_PENDIENTE();
                    prm1=prm2 =prm3= new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = pro.Parameters["StartDate"];
                    prm2 = pro.Parameters["EndDate"];
                    prm3 = pro.Parameters["Percent"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    prm3.Value = Percent;
                    pro.Parameters.Add(prm1);
                    pro.Parameters.Add(prm2);
                    pro.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate] AND [Percent]=[Parameters.Percent]";
                    ViewData["Report"] = pro;
                    break;
                case "41":
                    Pecuniaus.Reports.Daily_DER_DAR_PENDIENTE ddd = new Pecuniaus.Reports.Daily_DER_DAR_PENDIENTE();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ddd.Parameters["StartDate"];
                    prm2 = ddd.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    ddd.Parameters.Add(prm1);
                    ddd.Parameters.Add(prm2);
                    ddd.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = ddd;
                    break;
                case "42":
                    Pecuniaus.Reports.Daily_RPT_DER_SALDOS_DE_AVANCE sald = new Pecuniaus.Reports.Daily_RPT_DER_SALDOS_DE_AVANCE();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = sald.Parameters["StartDate"];
                    prm2 = sald.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    sald.Parameters.Add(prm1);
                    sald.Parameters.Add(prm2);
                    sald.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = sald;
                    break;
                case "43":
                    Pecuniaus.Reports.Daily_Portafolio_del_avance por = new Pecuniaus.Reports.Daily_Portafolio_del_avance();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = por.Parameters["StartDate"];
                    prm2 = por.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    por.Parameters.Add(prm1);
                    por.Parameters.Add(prm2);
                    por.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = por;
                    break;
                case "44":
                    Pecuniaus.Reports.Daily_Ingresso dai = new Pecuniaus.Reports.Daily_Ingresso();
                    prm1=prm2 = new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = dai.Parameters["StartDate"];
                    prm2 = dai.Parameters["EndDate"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    dai.Parameters.Add(prm1);
                    dai.Parameters.Add(prm2);
                    dai.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate]";
                    ViewData["Report"] = dai;
                    break;
                case "45":
                    Pecuniaus.Reports.Daily_Procesamiento_Saldo_del_avance sal = new Pecuniaus.Reports.Daily_Procesamiento_Saldo_del_avance();
                    prm1=prm2 =prm3= new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = sal.Parameters["StartDate"];
                    prm2 = sal.Parameters["EndDate"];
                    prm3 = sal.Parameters["Percent"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    prm3.Value = Percent;
                    sal.Parameters.Add(prm1);
                    sal.Parameters.Add(prm2);
                    sal.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate] AND [Percent]=[Parameters.Percent]";
                    ViewData["Report"] = sal;
                    break;
                case "46":
                    Pecuniaus.Reports.Daily_Procesamiento_DAR_PENDIENTE ces = new Pecuniaus.Reports.Daily_Procesamiento_DAR_PENDIENTE();
                    prm1=prm2 =prm3= new DevExpress.XtraReports.Parameters.Parameter();
                    prm1 = ces.Parameters["StartDate"];
                    prm2 = ces.Parameters["EndDate"];
                    prm3 = ces.Parameters["Percent"];
                    prm1.Value = System.Convert.ToDateTime(StartDate);
                    prm2.Value = System.Convert.ToDateTime(EndDate);
                    prm3.Value = Percent;
                    ces.Parameters.Add(prm1);
                    ces.Parameters.Add(prm2);
                    ces.FilterString = "[StartDate] = [Parameters.StartDate] AND [EndDate] = [Parameters.EndDate] AND [Percent]=[Parameters.Percent]";
                    ViewData["Report"] = ces;
                    break;
            }
            return PartialView("_ViewReport");
        }
コード例 #2
0
 public ActionResult DocumentViewerPartial(string id)
 {
     switch (id)
     {
         case "0":
            // ViewData["Report"] = new Pecuniaus.Reports.Monthly_MCA();
             break;
         case "1":
             ViewData["Report"] = new Pecuniaus.Reports.Collection();
             break;
         case "2":
             ViewData["Report"] = new Pecuniaus.Reports.Contracts_Contract();
             break;
         case "3":
             ViewData["Report"] = new Pecuniaus.Reports.Contracts_DeclinedByAvanzame();
             break;
         case "4":
             ViewData["Report"] = new Pecuniaus.Reports.Contracts_DeclinedByClient();
             break;
         case "5":
             ViewData["Report"] = new Pecuniaus.Reports.Contracts_Pending();
             break;
         case "6":
             ViewData["Report"] = new Pecuniaus.Reports.Investigation();
             break;
         case "7":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_MCA();
             break;
         case "8":
             ViewData["Report"] = new Pecuniaus.Reports.Notes();
             break;
         case "9":
             ViewData["Report"] = new Pecuniaus.Reports.PAFReport();
             break;
         case "10":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalification();
             break;
         case "11":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalification_DeclinedByAvanzame();
             break;
         case "12":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalification_DeclinedByClient();
             break;
         case "13":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalification_Offers();
             break;
         case "14":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalifications_Pending();
             break;
         case "15":
             ViewData["Report"] = new Pecuniaus.Reports.Prequalifications_AcceptedOffers();
             break;
         case "16":
             ViewData["Report"] = new Pecuniaus.Reports.Refund_Done();
             break;
         case "17":
             ViewData["Report"] = new Pecuniaus.Reports.Refund_Pending();
             break;
         case "18":
             ViewData["Report"] = new Pecuniaus.Reports.Renewals();
             break;
         case "19":
             ViewData["Report"] = new Pecuniaus.Reports.Renewals_Pending();
             break;
         case "20":
             ViewData["Report"] = new Pecuniaus.Reports.Renewals_DeclinedByAvanzeMe();
             break;
         case "21":
             ViewData["Report"] = new Pecuniaus.Reports.Renewals_DeclinedByClient();
             break;
         case "22":
             ViewData["Report"] = new Pecuniaus.Reports.ScoringReport();
             break;
         case "23":
             ViewData["Report"] = new Pecuniaus.Reports.WorkFlowReport();
             break;
         case "24":
             ViewData["Report"] = new Pecuniaus.Reports.WrittenOffContracts();
             break;
         case "25":
             ViewData["Report"] = new Pecuniaus.Reports.WSF_Report();
             break;
         case "26":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_BadDebtRecoveryAccount();
             break;
         case "27":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_Collection();
             break;
         case "28":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_Contract_Activity();
             break;
         case "29":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_DAR_New_Renewalcs();
             break;
         case "30":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_Processing_Assets();
             break;
         case "31":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_Progress_New_Renewal();
             break;
         case "32":
             ViewData["Report"] = new Pecuniaus.Reports.Author_RefundsDone();
             break;
         case "33":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_RefundsEarrings();
             break;
         case "34":
             ViewData["Report"] = new Pecuniaus.Reports.Auditor_Research();
             break;
         case "35":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_Portfolio_del_Avance();
             break;
         case "36":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_Ingreso();
             break;
         case "37":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_Saldos_de_avance();
             break;
         case "38":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_DAR_Pendiente();
             break;
         case "39":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_Procesamiento_Saldo_del_avance();
             break;
         case "40":
             ViewData["Report"] = new Pecuniaus.Reports.Monthly_Procesamiento_DAR_PENDIENTE();
             break;
         case "41":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_DER_DAR_PENDIENTE();
             break;
         case "42":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_RPT_DER_SALDOS_DE_AVANCE();
             break;
         case "43":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_Portafolio_del_avance();
             break;
         case "44":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_Ingresso();
             break;
         case "45":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_Procesamiento_Saldo_del_avance();
             break;
         case "46":
             ViewData["Report"] = new Pecuniaus.Reports.Daily_Procesamiento_DAR_PENDIENTE();
             break;
     }
     return PartialView("_ViewReport");
 }