private void btnOk_Click(object sender, RoutedEventArgs e) { dtNew = dt.Clone(); foreach (DataRow dr in dt.Rows) { if ((bool)dr[0] == true) { dtNew.ImportRow(dr); } } if (dtNew == null || dtNew.Rows.Count == 0) { MessageBox.Show("Chưa chọn khách hàng nào ", "Mess"); } else { if (Opt1.IsChecked == true) { rpt_SkePnkt rpt = new rpt_SkePnkt(); RPUtility.ShowRp(rpt, dtNew, this, srv.DbSourceSerVer(), srv.DbNameSerVer(), srv.DbUserSerVer(), srv.DbPassSerVer()); } else { FileName = Thumuc + "\\" + bll.Left(CboPos.SelectedValue.ToString().Trim(), 6) + "_" + bll.Left(CboXa.SelectedValue.ToString().Trim(), 7) + "_PNKT_" + dtpNgay.SelectedDate.Value.ToString("ddMMyyyy") + ".csv"; FileStream fs = new FileStream(FileName, FileMode.Create); StreamWriter sw = new StreamWriter(fs, Encoding.Unicode); //bll.WriteDataTableToExcel(dt, "Details", FileName, "tutm : 0985165777"); bll.ToCSV(dt, sw, true); MessageBox.Show("Copy Excel to : " + FileName, "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information); } } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rpt_SkePnkt rpt = new rpt_SkePnkt(); rpt.Site = this.Site; return(rpt); }