public void display(eFormMode ip_e_form_mode)
{
m_e_form_mode = ip_e_form_mode;
switch (m_e_form_mode)
{
case eFormMode.DI_NOI_BO:
m_lbl_title.Text = "THÊM MỚI VĂN BẢN ĐI";
m_rdb_noi_bo.Checked = true;
break;
case eFormMode.DI_BEN_NGOAI:
m_lbl_title.Text = "THÊM MỚI VĂN BẢN ĐI";
m_rdb_ben_ngoai.Checked = true;
break;
}
load_data_trang_thai();
this.ShowDialog();
}
public void display_for_update(decimal ip_dc_id_cong_van, eFormMode ip_e_form_mode)
{
m_dc_id_cong_van = ip_dc_id_cong_van;
m_e_form_mode = ip_e_form_mode;
switch (m_e_form_mode)
{
case eFormMode.DI_NOI_BO:
m_lbl_title.Text = "CẬP NHẬT VĂN BẢN ĐI ";
m_rdb_noi_bo.Checked = true;
break;
case eFormMode.DI_BEN_NGOAI:
m_lbl_title.Text = "CẬP NHẬT VĂN BẢN ĐI";
m_rdb_ben_ngoai.Checked = true;
break;
}
load_data_trang_thai();
us_object_to_form(m_dc_id_cong_van);
this.ShowDialog();
}
public void expor_excel_delete(
eFormMode ip_form_mode
, string ip_str_bo_tinh
, string ip_str_don_vi_chu_quan
, decimal ip_dc_don_vi_su_dung
, ref string op_str_excel_file_name)
{
//1. Đưa dữ liệu lên trên grid
m_obj_trans = get_trans_object(m_fg);
m_e_form_mode = ip_form_mode;
US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI();
if (ip_dc_don_vi_su_dung != CONST_QLDB.ID_TAT_CA)
{
v_us_don_vi = new US_DM_DON_VI(ip_dc_don_vi_su_dung);
}
else
{
v_us_don_vi.strTEN_DON_VI = CONST_QLDB.TAT_CA;
v_us_don_vi.strLOAI_HINH_DON_VI = CONST_QLDB.TAT_CA;
}
//2. Xuất dữ liệu ra file excel
CExcelWebReport v_obj_exe_report = new CExcelWebReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1); ;
switch (m_e_form_mode)
{
case eFormMode.KE_KHAI_O_TO:
//load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DANG_SU_DUNG);
v_obj_exe_report = new CExcelWebReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1);
break;
case eFormMode.O_TO_DE_NGHI_XU_LY:
//load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DE_NGHI_XU_LY);
v_obj_exe_report = new CExcelWebReport("BC-005 Danh muc xe oto de nghi xu ly.xls", 13, 1);
break;
case eFormMode.O_TO_GIAO_DON_VI_SU_NGHIEP:
// Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì
//load_data_2_grid(ip_dc_don_vi_su_dung, ID_TRANG_THAI_OTO.DANG_SU_DUNG);
v_obj_exe_report = new CExcelWebReport("BC-023 Bao cao danh muc xe o to giao cho don vi su nghiep cong lap tu chu tai chinh.xls", 13, 1);
break;
default:
break;
}
v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", ip_str_bo_tinh);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", ip_str_don_vi_chu_quan);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", v_us_don_vi.strTEN_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_don_vi.strMA_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", v_us_don_vi.strLOAI_HINH_DON_VI);
v_obj_exe_report.FindAndReplace(false);
v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
//3. Trả về địa chỉ file
op_str_excel_file_name = v_obj_exe_report.GetStrOutputFileNameWithPath();
}
public void export_excel(
eFormMode ip_form_mode
, ref IP.Core.QltsFormControls.CObjExcelAssetParameters op_obj_excel_parameters
)
{
//1. Đưa dữ liệu lên trên grid
m_obj_trans = get_trans_object(m_fg);
m_e_form_mode = ip_form_mode;
US_DM_DON_VI v_us_don_vi = new US_DM_DON_VI();
if (op_obj_excel_parameters.dcID_DON_VI_SU_DUNG != CONST_QLDB.ID_TAT_CA)
{
v_us_don_vi = new US_DM_DON_VI(op_obj_excel_parameters.dcID_DON_VI_SU_DUNG);
}
else
{
v_us_don_vi.strTEN_DON_VI = CONST_QLDB.TAT_CA;
v_us_don_vi.strLOAI_HINH_DON_VI = CONST_QLDB.TAT_CA;
}
//2. Xuất dữ liệu ra file excel
CExcelWebReport v_obj_exe_report = new CExcelWebReport();
switch (m_e_form_mode)
{
case eFormMode.KE_KHAI_O_TO:
load_data_2_grid(
op_obj_excel_parameters.dcID_BO_TINH
, op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN
, op_obj_excel_parameters.dcID_DON_VI_SU_DUNG
, op_obj_excel_parameters.dcID_LOAI_TAI_SAN
, ID_TRANG_THAI_OTO.DANG_SU_DUNG
, op_obj_excel_parameters.strKEY_SEARCH);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_KE_KHAI, 13, 1);
break;
case eFormMode.O_TO_DE_NGHI_XU_LY:
load_data_2_grid(
op_obj_excel_parameters.dcID_BO_TINH
, op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN
, op_obj_excel_parameters.dcID_DON_VI_SU_DUNG
, op_obj_excel_parameters.dcID_LOAI_TAI_SAN
, ID_TRANG_THAI_OTO.DE_NGHI_XU_LY
, op_obj_excel_parameters.strKEY_SEARCH);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_DE_NGHI_XU_LY, 13, 1);
break;
case eFormMode.THONG_KE_O_TO:
// Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì
load_data_2_grid(
op_obj_excel_parameters.dcID_BO_TINH
, op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN
, op_obj_excel_parameters.dcID_DON_VI_SU_DUNG
, op_obj_excel_parameters.dcID_LOAI_TAI_SAN
, op_obj_excel_parameters.dcID_TRANG_THAI_TAI_SAN
, op_obj_excel_parameters.strKEY_SEARCH);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_THONG_KE, 13, 1);
break;
case eFormMode.O_TO_GIAO_DON_VI_SU_NGHIEP:
// Chỗ này đang chưa chuẩn vì chưa hiểu sự nghiệp là gì
load_data_2_grid(
op_obj_excel_parameters.dcID_BO_TINH
, op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN
, op_obj_excel_parameters.dcID_DON_VI_SU_DUNG
, op_obj_excel_parameters.dcID_LOAI_TAI_SAN
, ID_TRANG_THAI_OTO.DANG_SU_DUNG
, op_obj_excel_parameters.strKEY_SEARCH);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_OTO_GIAO_CHO_DON_VI_CONG_LAP_TU_CHU_TAI_CHINH, 13, 1);
break;
default:
break;
}
v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG);
v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_don_vi.strMA_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", v_us_don_vi.strLOAI_HINH_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day);
v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month);
v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year);
v_obj_exe_report.FindAndReplace(false);
v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
//3. Trả về địa chỉ file
op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath();
}
public void set_form_mode(eFormMode ip_e_form_mode)
{
m_e_form_mode = ip_e_form_mode;
}
public void export_excel_from_grid(eFormMode ip_form_mode
, C1FlexGrid i_fg)
{
}
public void export_excel(
eFormMode ip_form_mode
, decimal ip_dc_id_dat
, ref CObjExcelAssetParameters op_obj_excel_parameters)
{
//1. Đưa dữ liệu lên trên grid
m_obj_trans = get_trans_object(m_fg_nha);
m_e_form_mode = ip_form_mode;
US_V_DM_DAT v_us_v_dm_dat;
if (ip_dc_id_dat != CONST_QLDB.ID_TAT_CA)
{
v_us_v_dm_dat = new US_V_DM_DAT(ip_dc_id_dat);
}
else
{
v_us_v_dm_dat = new US_V_DM_DAT();
}
US_DM_DON_VI v_us_dm_don_vi;
if (op_obj_excel_parameters.dcID_DON_VI_SU_DUNG != CONST_QLDB.ID_TAT_CA)
{
v_us_dm_don_vi = new US_DM_DON_VI(op_obj_excel_parameters.dcID_DON_VI_SU_DUNG);
}
else
{
v_us_dm_don_vi = new US_DM_DON_VI();
}
//2. Xuất dữ liệu ra file excel
//CExcelWebReport v_obj_exe_report = new CExcelWebReport("BC-18 Bao cao danh muc tru so lam viec co so hoat dong su nghiep.xls", 21, 1);
CExcelWebReport v_obj_exe_report = new CExcelWebReport();
switch (m_e_form_mode)
{
case eFormMode.KE_KHAI:
load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_KE_KHAI, 21, 1);
break;
case eFormMode.DE_NGHI_XU_LY:
load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_DE_NGHI_XU_LY, 21, 1);
break;
case eFormMode.THONG_KE:
load_data_2_grid(op_obj_excel_parameters, ip_dc_id_dat);
v_obj_exe_report = new CExcelWebReport(TEN_BAO_CAO.BCDM_TSLM_THONG_KE, 21, 1);
break;
default:
break;
}
// Thông tin phần đầu
v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG);
v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_dm_don_vi.strMA_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", op_obj_excel_parameters.strLOAI_HINH_DON_VI);
// Thông tin đất
v_obj_exe_report.AddFindAndReplaceItem("<DIA_CHI>", v_us_v_dm_dat.strDIA_CHI);
v_obj_exe_report.AddFindAndReplaceItem("<DT_KHUON_VIEN>", v_us_v_dm_dat.dcDT_KHUON_VIEN.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<TRU_SO_LAM_VIEC>", v_us_v_dm_dat.dcDT_TRU_SO_LAM_VIEC.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<CO_SO_HDSN>", v_us_v_dm_dat.dcDT_CO_SO_HOAT_DONG_SU_NGHIEP.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<LAM_NHA_O>", v_us_v_dm_dat.dcDT_LAM_NHA_O.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<CHO_THUE>", v_us_v_dm_dat.dcDT_CHO_THUE.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<BO_TRONG>", v_us_v_dm_dat.dcDT_BO_TRONG.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<BI_LAN_CHIEM>", v_us_v_dm_dat.dcDT_BI_LAN_CHIEM.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<KHAC>", v_us_v_dm_dat.dcDT_SU_DUNG_MUC_DICH_KHAC.ToString("#,##0.00"));
v_obj_exe_report.AddFindAndReplaceItem("<GT_THEO_SO_KE_TOAN>", v_us_v_dm_dat.dcGT_THEO_SO_KE_TOAN.ToString("#,##0.00"));
// Thông tin phần cuối
//v_obj_exe_report.AddFindAndReplaceItem("<HO_SO_GIAY_TO_LIEN_QUAN>", v_us_dm_dat.strDIA_CHI);
v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day);
v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month);
v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year);
// Thông tin bảng
v_obj_exe_report.FindAndReplace(false);
v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_nha, 1, m_fg_nha.Cols.Count - 1, true);
//3. Trả về địa chỉ file
op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath();
}
public void export_excel_tai_san_co_nguyen_gia_tren_500_trieu(
eFormMode ip_form_mode
, ref IP.Core.QltsFormControls.CObjExcelAssetParameters op_obj_excel_parameters)
{
m_obj_trans = get_trans_object(m_fg);
m_e_form_mode = ip_form_mode;
US_DM_DON_VI v_us_dm_don_vi;
if (op_obj_excel_parameters.dcID_DON_VI_SU_DUNG != CONST_QLDB.ID_TAT_CA)
{
v_us_dm_don_vi = new US_DM_DON_VI(op_obj_excel_parameters.dcID_DON_VI_SU_DUNG);
}
else
{
v_us_dm_don_vi = new US_DM_DON_VI();
}
CExcelWebReport v_obj_exe_report = new CExcelWebReport("BC-26 BCDM-TSK.xls", 12, 1); ;
switch (m_e_form_mode)
{
case eFormMode.KE_KHAI_TAI_SAN_KHAC:
v_obj_exe_report = new CExcelWebReport("BC-26 BCDM-TSK.xls", 12, 1);
load_data_2_grid_tai_san_co_nguyen_gia_tren_500_trieu(op_obj_excel_parameters);
break;
case eFormMode.TAI_SAN_KHAC_DE_NGHI_XU_LY:
v_obj_exe_report = new CExcelWebReport("BC-24 BCDM-TSK-DNXL.xls", 12, 1);
load_data_2_grid_tai_san_co_nguyen_gia_tren_500_trieu(op_obj_excel_parameters);
break;
case eFormMode.TAI_SAN_KHAC_GIAO_DON_VI_SU_NGHIEP:
v_obj_exe_report = new CExcelWebReport("BC-28 BCDM-TSK-DVTCTC.xls", 14, 1);
load_data_2_grid_tai_san_co_nguyen_gia_tren_500_trieu(op_obj_excel_parameters);
break;
default:
break;
}
v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", op_obj_excel_parameters.strTEN_BO_TINH);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG);
v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_dm_don_vi.strMA_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", op_obj_excel_parameters.strLOAI_HINH_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<TEN_DON_VI_CHU_QUAN>", op_obj_excel_parameters.strTEN_DON_VI_CHU_QUAN);
v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG>", op_obj_excel_parameters.strTEN_DON_VI_SU_DUNG);
v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day);
v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month);
v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year);
v_obj_exe_report.FindAndReplace(false);
v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true);
op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath();
}
public void display(int i_mode)
{
m_e_form_mode = (eFormMode) i_mode;
this.ShowDialog();
}
