Пример #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            BB_syxffx_xydwmxfx rpt = new BB_syxffx_xydwmxfx();

            rpt.Site = this.Site;
            return(rpt);
        }
Пример #2
0
        private void displayBB(string sql_0, string sql_other)
        {
            sel_str = "";
            sel_str = " id>=0  and   yydh='" + common_file.common_app.yydh + "' and xfdr!='" + Szwgl.common_zw.dr_ds + "'   " + sql_0 + sql_other + "  order by  xsy , xfsj  Desc ";
            //ds = B_common.GetList(" select krxm,xfxm,fjrb,fjbh,xfsj,sjxfje,xydw,xsy,xfzy,xfbz  from VS_syxfmx_cz  ", sel_str);
            ds = B_common.GetList(" select *  from VS_syxfmx_cz  ", sel_str);
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                p_gl.Visible = false;
                common_bb.displayprogress(progressBar1);
                string _qymc = ""; string _qymc_english = ""; string _address_chinese = ""; string _address_english = ""; string _qydh = ""; string _qycz = ""; string _qyyb = ""; string _website = "";
                common_file.common_app.GetPrintInfo(ref _qymc, ref _qymc_english, ref _address_chinese, ref _address_english, ref _qydh, ref _qycz, ref _qyyb, ref _website);
                if (loadType == "xsymxfx")
                {
                    BB_syxffx_xsy_xsmxfx myreport = new BB_syxffx_xsy_xsmxfx();
                    myreport.SetDataSource(ds.Tables[0]);
                    myreport.SetParameterValue("fx_type", "销售员销售明细分析");

                    myreport.SetParameterValue("qymc", common_file.common_app.qymc);
                    myreport.SetParameterValue("cssj", Time_begin.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("jssj", Time_end.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("address", _address_chinese);
                    myreport.SetParameterValue("Tel", _qydh);
                    myreport.SetParameterValue("Fax", _qycz);
                    crystalReportViewer1.ReportSource = myreport;
                }
                if (loadType == "xydwmxfx")
                {
                    BB_syxffx_xydwmxfx myreport = new BB_syxffx_xydwmxfx();
                    myreport.SetDataSource(ds.Tables[0]);
                    myreport.SetParameterValue("fx_type", "协议单位消费明细分析");

                    myreport.SetParameterValue("qymc", common_file.common_app.qymc);
                    myreport.SetParameterValue("cssj", Time_begin.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("jssj", Time_end.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("address", _address_chinese);
                    myreport.SetParameterValue("Tel", _qydh);
                    myreport.SetParameterValue("Fax", _qycz);
                    crystalReportViewer1.ReportSource = myreport;
                }
                if (loadType == "krlymxfx")
                {
                    BB_syxffx_krlymxfx myreport = new BB_syxffx_krlymxfx();
                    myreport.SetDataSource(ds.Tables[0]);
                    myreport.SetParameterValue("fx_type", "客人来源消费明细分析");

                    myreport.SetParameterValue("qymc", common_file.common_app.qymc);
                    myreport.SetParameterValue("cssj", Time_begin.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("jssj", Time_end.Trim().Replace('/', '-'));
                    myreport.SetParameterValue("address", _address_chinese);
                    myreport.SetParameterValue("Tel", _qydh);
                    myreport.SetParameterValue("Fax", _qycz);
                    crystalReportViewer1.ReportSource = myreport;
                }
            }
            else
            {
                crystalReportViewer1.ReportSource = null;
                common_file.common_app.Message_box_show(common_file.common_app.message_title, "当前时间段内没有分析数据,您可以更改查询条件来获取其它的分析数据!");
                //return;
            }
        }