private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f404_qua_trinh_cong_tac.xlsx", 3, 1);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f403_bao_cao_nhan_su_cap_bac.xlsx", 3, 1);
v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dtp_thoidiem.Value.Date);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f407_bao_cao_danh_sach_bo_nhiem.xlsx", 3, 2);
v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dtp_thoidiem.Value.Month);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f405_bien_dong_nhan_su_chuc_vu_trang_thai.xlsx", 3, 1);
v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dat_thoidiem.Value.Date);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f408_bao_cao_don_vi_trang_thai.xlsx", 3, 2);
v_obj_excel_rpt.AddFindAndReplaceItem("<thoi_diem>", m_dat_thoidiem.Value.Date);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg_donvi, 1, m_fg_donvi.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f501_bao_cao_nhan_su_du_an_tu_ngay_den_ngay.xlsx", 6, 1);
v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", m_dat_tu_ngay.Value.Date);
v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", m_dat_den_ngay.Value.Date);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void export_2_excel()
{
CExcelReport v_obj_excel_rpt = new CExcelReport("f409_bao_cao_nghi_viec.xlsx", 3, 2);
v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", m_dtp_tu_ngay.Value);
v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", m_dtp_den_ngay.Value);
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
/*private void set_search_format_before() {
* if (m_txt_search.Text == "") {
* m_txt_search.Text = m_str_goi_y_tim_kiem;
* m_txt_search.ForeColor = Color.Gray;
* }
* }*/
/*private void set_search_format_after() {
* if (m_txt_search.Text == m_str_goi_y_tim_kiem) {
* m_txt_search.Text = "";
* }
* m_txt_search.ForeColor = Color.Black;
* }*/
private void xuat_excel()
{
var v_start_row = 8;
var v_start_col = 1;
var v_obj_excel_rpt = new CExcelReport("f104_bao_cao_nhan_su_theo_phong_ban.xlsx", v_start_row, v_start_col);
v_obj_excel_rpt.AddFindAndReplaceItem("<ngay_thang>", string.Format("{0}/{1}/{2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year));
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}
private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
if (!backgroundWorker1.CancellationPending)
{
alert.Message = "In progress, please wait... " + e.ProgressPercentage.ToString() + "%";
alert.ProgressValue = e.ProgressPercentage;
}
var v_start_row = 2;
var v_start_col = 1;
var v_obj_excel_rpt = new CExcelReport("Employee.xls", v_start_row, v_start_col);
//v_obj_excel_rpt.AddFindAndReplaceItem("<ngay_thang>", string.Format("{0}/{1}/{2}", DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year));
v_obj_excel_rpt.FindAndReplace(false);
v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
}