private void Getfxsj(string Time_begin, string Time_end) { if (dt2 < dt1) { common_file.common_app.Message_box_show(common_file.common_app.message_title, "结束时间早于起始时间,请正确选择结束时间"); return; } common_file.common_app.get_czsj(); if (tb_value.Text.Trim().Replace("'", "-") != "") { ls_condition += " and xsy like '%" + tb_value.Text.Trim().Replace("'", "-") + "%'"; } ds = common_bb.GetData(dt1.ToString(), dt2.ToString(), common_bb.xsy_krly_xydw_xsy, tb_value.Text.Trim().Replace("'", "-"), "true", common_bb.xsy_krly_xydw_xydw, ls_condition); if (ds != null && ds.Tables[0].Rows.Count > 0) { p_gl.Visible = false; common_bb.displayprogress(progressBar1); BB_syxffx_xsy_xydw myreport = new BB_syxffx_xsy_xydw(); myreport.SetDataSource(ds.Tables[0]); myreport.SetParameterValue("fx_type", "销售员"); myreport.SetParameterValue("fxdr", "销售员协议单位分析"); myreport.SetParameterValue("cssj", DateTime.Parse(Time_begin.Trim().Replace('/', '-')).Date.ToShortDateString()); myreport.SetParameterValue("jssj", DateTime.Parse(Time_end.Trim().Replace('/', '-')).Date.ToShortDateString()); crystalReportViewer1.ReportSource = myreport; } else { crystalReportViewer1.ReportSource = null; common_file.common_app.Message_box_show(common_file.common_app.message_title, "没有分析数据,请更改查询条件!"); return; } }
private void Getfxsj(string Time_begin, string Time_end) { Cursor.Current = Cursors.WaitCursor; if (dt2 < dt1) { common_file.common_app.Message_box_show(common_file.common_app.message_title, "结束时间早于起始时间,请正确选择结束时间"); return; } Cursor.Current = Cursors.WaitCursor; ds = common_bb.GetDatahy(dt1.ToShortDateString(), dt2.ToString(), common_bb.xsy_krly_xydw_xsy, tb_value.Text, "false", "", ""); if (ds != null && ds.Tables[0].Rows.Count > 0) { p_gl.Visible = false; common_bb.displayprogress(progressBar1); BB_syxffx_xsy_xydw myreport = new BB_syxffx_xsy_xydw(); myreport.SetDataSource(ds.Tables[0]); myreport.SetParameterValue("fx_type", "会员卡消费"); myreport.SetParameterValue("fxdr", "会员卡消费"); myreport.SetParameterValue("cssj", DateTime.Parse(Time_begin.Trim().Replace('/', '-')).Date.ToShortDateString()); myreport.SetParameterValue("jssj", DateTime.Parse(Time_end.Trim().Replace('/', '-')).Date.ToShortDateString()); crystalReportViewer1.ReportSource = myreport; Cursor.Current = Cursors.Default; } else { crystalReportViewer1.ReportSource = null; common_file.common_app.Message_box_show(common_file.common_app.message_title, "没有分析数据,请更改查询条件!"); } }
private void Getfxsj(string Time_begin, string Time_end) { //dt1 = DateTime.Parse(Time_begin.Trim().Replace('/', '-')); //dt2 = DateTime.Parse(Time_end.Trim().Replace('/', '-') + " 23:59:59"); if (dt2 < dt1) { common_file.common_app.Message_box_show(common_file.common_app.message_title, "结束时间早于起始时间,请正确选择结束时间"); return; } ds = common_bb.GetData(dt1.ToShortDateString(), dt2.ToString(), common_bb.xsy_krly_xydw_gj_sf, tb_value.Text, "false", "", " and krgj='" + common_file.common_app.krgj_zg + "' "); if (ds != null && ds.Tables[0].Rows.Count > 0) { p_gl.Visible = false; common_bb.displayprogress(progressBar1); BB_syxffx_xsy_xydw myreport = new BB_syxffx_xsy_xydw(); myreport.SetDataSource(ds.Tables[0]); myreport.SetParameterValue("fx_type", "省份"); myreport.SetParameterValue("fxdr", "省份城市分析"); myreport.SetParameterValue("cssj", DateTime.Parse(Time_begin.Trim().Replace('/', '-')).Date.ToShortDateString()); myreport.SetParameterValue("jssj", DateTime.Parse(Time_end.Trim().Replace('/', '-')).Date.ToShortDateString()); crystalReportViewer1.ReportSource = myreport; } else { crystalReportViewer1.ReportSource = null; common_file.common_app.Message_box_show(common_file.common_app.message_title, "没有分析数据,请更改查询条件!"); return; } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BB_syxffx_xsy_xydw rpt = new BB_syxffx_xsy_xydw(); rpt.Site = this.Site; return(rpt); }