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);
}