private void btnOk_Click(object sender, RoutedEventArgs e) { string strup = ""; try { cls.ClsConnect(); string sqlload = "select '" + dtpNgay.SelectedDate.Value.ToString("dd/MM/yyyy") + "' NGAY,a.POS_CD,b.PO_TEN,a.MA_NHANHIEU_TS,a.TEN_NHANHIEU_TS,a.MAPHONG,a.TENPHONG,convert(varchar(4),DATEPART(yyyy,NGAY_MUA)) NAM,A.MA_TS,a.MOTA,MA_CIF,CB_QUANLY,a.GDX from LUU_TSCC a left join DMPOS b on a.POS_CD = b.PO_MA where a.POS_CD = '" + CboPos.SelectedValue + "' and LOAI_TS_CHITIET = 'TI1' and a.TRANGTHAI = 'A' order by MAPHONG,MA_NHANHIEU_TS,MA_CIF"; var dtin = cls.LoadDataText(sqlload); if (dtin.Rows.Count > 0) { rpt_TSCC_BC rpt = new rpt_TSCC_BC(); RPUtility.ShowRp(rpt, dtin, this, srv.DbSourceSerVer(), srv.DbNameSerVer(), srv.DbUserSerVer(), srv.DbPassSerVer()); } else { MessageBox.Show("Không có dữ liệu !", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButton.OK, MessageBoxImage.Error); } cls.DongKetNoi(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rpt_TSCC_BC rpt = new rpt_TSCC_BC(); rpt.Site = this.Site; return(rpt); }