private void btn_BaoCao_Click(object sender, EventArgs e) { List <int> SelectedChucDanh = new List <int>(); List <int> SelectedChucVu = new List <int>(); foreach (object item in clb_ChucDanh.CheckedItems) { DataRowView drv = (DataRowView)item; SelectedChucDanh.Add(Convert.ToInt32(drv["id"])); } if (SelectedChucDanh.Count <= 0) { SelectedChucDanh = null; } foreach (object item in clb_ChucVu.CheckedItems) { DataRowView drv = (DataRowView)item; SelectedChucVu.Add(Convert.ToInt32(drv["id"])); } if (SelectedChucVu.Count <= 0) { SelectedChucVu = null; } DateTime?dt_tu_ngay = new DateTime(); DateTime?dt_den_ngay = new DateTime(); if (dtp_TuNgay.Checked) { dt_tu_ngay = dtp_TuNgay.Value; } else { dt_tu_ngay = null; } if (dtp_DenNgay.Checked) { dt_den_ngay = dtp_DenNgay.Value; } else { dt_den_ngay = null; } DataTable dt_NV = oBaoCao.NV_Theo_CD_CV(SelectedChucDanh, SelectedChucVu, dt_tu_ngay, dt_den_ngay); DataSet.NVTheoCD_CV ds = new DataSet.NVTheoCD_CV(); Reports.NVTheoCD_CV rpt = new Reports.NVTheoCD_CV(); rpt.SetDataSource(dt_NV); crystalReportViewer1.ReportSource = rpt; ((TextObject)(rpt.Subreports["Header.rpt"].ReportDefinition.ReportObjects["rptName"])).Text = "BÁO CÁO NHÂN VIÊN THEO CHỨC DANH, CHỨC VỤ"; }
private void btn_BaoCao_Click(object sender, EventArgs e) { List<int> SelectedChucDanh = new List<int>(); List<int> SelectedChucVu = new List<int>(); foreach (object item in clb_ChucDanh.CheckedItems) { DataRowView drv = (DataRowView)item; SelectedChucDanh.Add(Convert.ToInt32(drv["id"])); } if (SelectedChucDanh.Count <= 0) SelectedChucDanh = null; foreach (object item in clb_ChucVu.CheckedItems) { DataRowView drv = (DataRowView)item; SelectedChucVu.Add(Convert.ToInt32(drv["id"])); } if (SelectedChucVu.Count <= 0) SelectedChucVu = null; DateTime? dt_tu_ngay = new DateTime(); DateTime? dt_den_ngay = new DateTime(); if (dtp_TuNgay.Checked) dt_tu_ngay = dtp_TuNgay.Value; else dt_tu_ngay = null; if (dtp_DenNgay.Checked) dt_den_ngay = dtp_DenNgay.Value; else dt_den_ngay = null; DataTable dt_NV = oBaoCao.NV_Theo_CD_CV(SelectedChucDanh, SelectedChucVu, dt_tu_ngay,dt_den_ngay); DataSet.NVTheoCD_CV ds = new DataSet.NVTheoCD_CV(); Reports.NVTheoCD_CV rpt = new Reports.NVTheoCD_CV(); rpt.SetDataSource(dt_NV); crystalReportViewer1.ReportSource = rpt; ((TextObject)(rpt.Subreports["Header.rpt"].ReportDefinition.ReportObjects["rptName"])).Text = "BÁO CÁO NHÂN VIÊN THEO CHỨC DANH, CHỨC VỤ"; }