private void FilterReport(string action)
        {
            string foldername = Server.MapPath("~/CS_REPORT/rpt/ftmandytdsellinperareareport.rpt");
            _User  Ousr       = new _User(Session["username"].ToString());

            string[] No_Filter_Users = { "ceo", "vpbsm", "vptfi", "ssgm", "ssm", "brd", "admin" };
            string[] User_more_roles = { "6", "14", "20", "21", "23", "31", "36", "52", "62", "64", "65", "71", "72", "77", "79", "90" };
            string   orig_ids        = string.Join(",", User_more_roles);
            string   tmp_ids         = "";

            DataTable user_counterid = SqlDbHelper.getDataDT("SELECT counterid FROM userheader WHERE username='******'");

            foreach (DataRow ids in user_counterid.Rows)
            {
                tmp_ids = ids["counterid"].ToString();
            }

            string val_region = txt_region.Text.ToUpper();

            if (val_region.Trim() != "")
            {
                ReportDocument ReportDoc = new ReportDocument();
                ReportDoc.Load(foldername);
                ReportDoc.SetDatabaseLogon("sa", "p@ssw0rd");

                ParameterFields PFIELDS = ReportDoc.ParameterFields;

                ParameterDiscreteValue[] param_values = new ParameterDiscreteValue[] { };

                ParameterDiscreteValue region_default_val = new ParameterDiscreteValue();
                region_default_val.Value = "C";
                ParameterDiscreteValue channel_default_val = new ParameterDiscreteValue();
                channel_default_val.Value = "All";
                ParameterDiscreteValue area_default_val = new ParameterDiscreteValue();
                area_default_val.Value = "All";
                ParameterDiscreteValue so_default_val = new ParameterDiscreteValue();
                so_default_val.Value = "All";
                ParameterDiscreteValue brand_default_val = new ParameterDiscreteValue();
                brand_default_val.Value = "All";

                PFIELDS["Region"].CurrentValues.Clear();
                PFIELDS["Area"].CurrentValues.Clear();
                PFIELDS["Channel"].CurrentValues.Clear();
                PFIELDS["SO"].CurrentValues.Clear();
                PFIELDS["Brand"].CurrentValues.Clear();

                if (action == "button_click" && (Ousr.HasPositionsOf(No_Filter_Users) || orig_ids.IndexOf(tmp_ids) != -1))
                {
                    if (val_region == "LUZON")
                    {
                        region_default_val.Value = "CL";
                    }
                    else if (val_region == "VISMIN")
                    {
                        region_default_val.Value = "CV";
                    }
                    else
                    {
                        region_default_val.Value = "C";
                    }
                }
                else
                {
                    ReportHelper.GetRegions(Session["username"].ToString(), "Region", ref PFIELDS, ref param_values);
                    foreach (ParameterDiscreteValue pd in PFIELDS["Region"].CurrentValues)
                    {
                        if (pd.Value.ToString() == "LUZON")
                        {
                            pd.Value = "CL";
                        }
                        if (pd.Value.ToString() == "VISMIN")
                        {
                            pd.Value = "CV";
                        }
                    }
                }
                ReportHelper.GetChannels(Session["username"].ToString(), "Channel", ref PFIELDS, ref param_values);
                ReportHelper.GetAreas(Session["username"].ToString(), "Area", ref PFIELDS, ref param_values);
                ReportHelper.GetBrands(Session["username"].ToString(), "Brand", ref PFIELDS, ref param_values);

                if (Ousr.HasPositionOf("so") != -1)
                {
                    so_default_val.Value = Ousr.SlpName;
                }

                bool has_region = false, has_channel = false, has_area = false, has_so = false, has_brand = false;
                foreach (ParameterField pd in PFIELDS)
                {
                    bool has_val = pd.CurrentValues.Count > 0 ? true : false;

                    if (has_val)
                    {
                        switch (pd.Name.ToUpper())
                        {
                        case "REGION": has_region = true; break;

                        case "CHANNEL": has_channel = true; break;

                        case "AREA": has_area = true; break;

                        case "SO": has_so = true; break;

                        case "BRAND": has_brand = true; break;
                        }
                    }
                }

                if (!has_region)
                {
                    ReportDoc.ParameterFields["Region"].CurrentValues.Add(region_default_val);
                }
                if (!has_channel)
                {
                    ReportDoc.ParameterFields["Channel"].CurrentValues.Add(channel_default_val);
                }
                if (!has_area)
                {
                    ReportDoc.ParameterFields["Area"].CurrentValues.Add(area_default_val);
                }
                if (!has_so)
                {
                    ReportDoc.ParameterFields["SO"].CurrentValues.Add(so_default_val);
                }
                if (!has_brand)
                {
                    ReportDoc.ParameterFields["Brand"].CurrentValues.Add(brand_default_val);
                }

                CrystalReportViewer1.ReportSource = ReportDoc;
            }
        }
Exemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //string foldername = Server.MapPath("~/CS_REPORT/rpt/summarybusinessreviews.rpt");

            try
            {
                //CrystalReportSource1.Report.FileName = foldername;

                //CrystalReportViewer1.ReportSource = CrystalReportSource1;
                //CrystalReportViewer1.RefreshReport();
                //Label2.Text = CrystalReportViewer1.ParameterFieldInfo[0].Name + "-" + CrystalReportViewer1.ParameterFieldInfo[1].Name;

                string         foldername = Server.MapPath("~/CS_REPORT/rpt/summarybusinessreviews.rpt");
                _User          Ousr       = new _User(Session["username"].ToString());
                ReportDocument ReportDoc  = new ReportDocument();
                ReportDoc.Load(foldername);
                ReportDoc.SetDatabaseLogon("sa", "p@ssw0rd");

                ParameterFields PFIELDS = ReportDoc.ParameterFields;

                ParameterDiscreteValue[] param_values = new ParameterDiscreteValue[] { };

                ParameterDiscreteValue region_default_val = new ParameterDiscreteValue();
                region_default_val.Value = "C";
                ParameterDiscreteValue channel_default_val = new ParameterDiscreteValue();
                channel_default_val.Value = "All";
                ParameterDiscreteValue area_default_val = new ParameterDiscreteValue();
                area_default_val.Value = "All";
                ParameterDiscreteValue so_default_val = new ParameterDiscreteValue();
                so_default_val.Value = "All";
                ParameterDiscreteValue start_date_default_val = new ParameterDiscreteValue();

                PFIELDS["Region"].CurrentValues.Clear();
                PFIELDS["Area"].CurrentValues.Clear();
                PFIELDS["Channel"].CurrentValues.Clear();
                PFIELDS["SO"].CurrentValues.Clear();

                ReportHelper.GetRegions(Session["username"].ToString(), "Region", ref PFIELDS, ref param_values);
                foreach (ParameterDiscreteValue pd in PFIELDS["Region"].CurrentValues)
                {
                    if (pd.Value.ToString() == "LUZON")
                    {
                        pd.Value = "CL";
                    }
                    if (pd.Value.ToString() == "VISMIN")
                    {
                        pd.Value = "CV";
                    }
                }


                ReportHelper.GetChannels(Session["username"].ToString(), "Channel", ref PFIELDS, ref param_values);
                ReportHelper.GetAreas(Session["username"].ToString(), "Area", ref PFIELDS, ref param_values);

                if (Ousr.HasPositionOf("so") != -1)
                {
                    so_default_val.Value = Ousr.SlpName;
                }

                bool has_region = false, has_channel = false, has_area = false, has_so = false;
                foreach (ParameterField pd in PFIELDS)
                {
                    bool has_val = pd.CurrentValues.Count > 0 ? true : false;

                    if (has_val)
                    {
                        switch (pd.Name.ToUpper())
                        {
                        case "REGION": has_region = true; break;

                        case "CHANNEL": has_channel = true; break;

                        case "AREA": has_area = true; break;

                        case "SO": has_so = true; break;
                        }
                    }
                }

                if (!has_region)
                {
                    ReportDoc.ParameterFields["Region"].CurrentValues.Add(region_default_val);
                }
                if (!has_channel)
                {
                    ReportDoc.ParameterFields["Channel"].CurrentValues.Add(channel_default_val);
                }
                if (!has_area)
                {
                    ReportDoc.ParameterFields["Area"].CurrentValues.Add(area_default_val);
                }
                if (!has_so)
                {
                    ReportDoc.ParameterFields["SO"].CurrentValues.Add(so_default_val);
                }

                CrystalReportViewer1.ReportSource = ReportDoc;
            }
            catch (Exception ex)
            {
                Label2.Text = "Error-" + ex.Message;
            }
        }