public CC1InplaceEdittingAutoAddRowAndUpdateDBController(C1FlexGrid i_fg,
US_Object i_us_obj,
DataSet i_ds_source,
ITransferDataRow i_obj_transfer,
e_CC1InplaceEditting_NewRowPosition i_e_new_row_position)
: this(i_fg, i_us_obj, i_ds_source, i_obj_transfer)
{
m_e_new_row_position = i_e_new_row_position;
}
private void change_state_all(decimal ip_id_trang_thai_cu, decimal ip_id_trang_thai_moi, C1.Win.C1FlexGrid.C1FlexGrid i_fg_left, C1.Win.C1FlexGrid.C1FlexGrid i_fg_right, string ip_str_message)
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(i_fg_left)) return;
for (int i = 1; i < i_fg_left.Rows.Count; i++)
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(i_fg_left)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(i_fg_left, i_fg_left.Row)) return;
m_obj_trans = get_trans_object(i_fg_left);
m_us = new US_V_DM_BILL();
grid_2us_object(m_us, i,i_fg_left);
//chuyen tu trang thai 1-Da nhan noi bo -> 2-Da chuyen cho CPN
change_state_of_bill(m_us.dcID, ip_id_trang_thai_moi);
}
load_data_2_grid(ip_id_trang_thai_cu, i_fg_left);
load_data_2_grid(ip_id_trang_thai_moi, i_fg_right);
BaseMessages.MsgBox_Infor(ip_str_message);
}
public CC1InplaceEdittingAutoAddRowAndUpdateDBController(C1FlexGrid i_fg, US_Object i_us_obj, DataSet i_ds_source, ITransferDataRow i_obj_transfer)
{
m_fg = i_fg;
m_us_cur = i_us_obj;
m_ds_source = i_ds_source;
m_obj_transfer = i_obj_transfer;
m_obj_edit_controller = new CC1InplaceEdittingController(m_fg);
m_e_new_row_position = e_CC1InplaceEditting_NewRowPosition.next_row;
m_fg.StartEdit += this.catch_fg_StartEdit;
m_obj_edit_controller.BeforeUpdate += m_obj_edit_controller_BeforeUpdate;
m_obj_edit_controller.OnUpdate += m_obj_edit_controller_OnUpdate;
m_obj_edit_controller.OnCancelUpdate += m_obj_edit_controller_OnCancelUpdate;
m_obj_edit_controller.BeforeInsert += m_obj_edit_controller_BeforeInsert;
m_obj_edit_controller.OnInsert += m_obj_edit_controller_OnInsert;
m_obj_edit_controller.OnCancelInsert += m_obj_edit_controller_OnCancelInsert;
m_obj_edit_controller.BeforeDelete += m_obj_edit_controller_BeforeDelete;
m_obj_edit_controller.OnDelete += m_obj_edit_controller_OnDelete;
m_obj_edit_controller.OnCancelDelete += m_obj_edit_controller_OnCancelDelete;
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
get_thoi_gian();
//load_data_2_grid();
tim_kiem();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
if(m_id_loai_dm==174) load_data_2_grid();
if (m_id_loai_dm == 173) load_data_2_grid_2();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
m_dat_tu_ngay.Text = CIPConvert.ToStr(DateTime.Now.Date.AddDays(-DateTime.Now.Date.Day + 1),"dd/MM/yyyy");
DateTime temp = DateTime.Now.Date;
temp = temp.AddMonths(1);
temp = temp.AddDays(-(temp.Day));
m_dat_den_ngay.Text = CIPConvert.ToStr(temp,"dd/MM/yyyy");
load_data_2_grid();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
if(m_trang_thai_hien_thi == 0) {
load_data_2_cbo_lop_mon_tu_399();
CCommon.load_data_2_cbo_trang_thai_hoc_sinh(m_cbo_trang_thai_hv);
load_data_2_grid();
}
else {
//bo cung dc
}
}
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();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
m_lb_thong_bao_ket_qua.Visible = false;
if(m_e_form_load == e_form_load.SEARCH_ON_LOAD_YES)
load_data_2_grid();
}
}
private void set_define_events()
{
m_cmd_exit.Click += new EventHandler(m_cmd_exit_Click);
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
load_data_2_cbo_trang_thai_cau_hoi();
}
m_grv_co_so_dinh_muc.DoubleClick+=new EventHandler(m_grv_co_so_dinh_muc_DoubleClick);
this.KeyDown+=new KeyEventHandler(f518_V_DM_CO_SO_DINH_MUC_KeyDown);
}
private void set_initial_form_load()
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
m_dt_tu_ngay.Value = DateTime.Now.Date.AddDays(-DateTime.Now.Date.Day + 1);
DateTime dtResult = DateTime.Now.Date;
dtResult = dtResult.AddMonths(1);
dtResult = dtResult.AddDays(-(dtResult.Day));
m_dt_den_ngay.Value = dtResult;
load_data_2_grid();
}
public CC1InplaceEdittingAutoAddRowController(C1FlexGrid i_fg, ITransferDataRow i_obj_trans,
e_CC1InplaceEditting_NewRowPosition i_e_new_row_position)
: this(i_fg, i_obj_trans)
{
m_e_new_row_position = i_e_new_row_position;
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
load_data_2_grid();
}
private void set_initial_form_load()
{
load_data_2_cbo_truong();
m_obj_trans = get_trans_object(m_fg);
//load_data_2_grid();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
load_data_2_cbo_trang_thai_cau_hoi();
}
private void set_inital_form_load()
{
m_obj_trans = get_trans_object_nhan_vien(m_fg_nhan_su);
}
private void set_initial_form_load()
{
m_dtp_thang.Text = DateTime.Now.Date.ToString("MM/yyyy");
m_obj_trans = get_trans_object(m_grv_de_xuat);
load_data_2_grid();
}
public void Display_for_chi_tiet(
decimal ip_v_id_phong_ban
, DateTime ip_v_dt_tu_ngay
, DateTime ip_v_dt_den_ngay
,decimal ip_v_id_loai_dm)
{
m_obj_trans = get_trans_object(m_fg);
format_controls();
US_DM_PHONG_BAN v_us_dm_pb = new US_DM_PHONG_BAN();
DS_DM_PHONG_BAN v_ds_dm_pb = new DS_DM_PHONG_BAN();
v_us_dm_pb.FillDataset(v_ds_dm_pb, "where ID =" + ip_v_id_phong_ban);
m_lbl_ten_phong_ban.Text = v_ds_dm_pb.Tables[0].Rows[0][2].ToString();
m_lbl_tu_ngay.Text = ip_v_dt_tu_ngay.Date.ToShortDateString();
m_lbl_den_ngay.Text = ip_v_dt_den_ngay.Date.ToShortDateString();
//DS_V_BC_TINH_HINH_CPN_THEO_PHONG_BAN v_ds = new DS_V_BC_TINH_HINH_CPN_THEO_PHONG_BAN();
//US_V_BC_TINH_HINH_CPN_THEO_PHONG_BAN v_us = new US_V_BC_TINH_HINH_CPN_THEO_PHONG_BAN();
//m_us.FillDataset_chi_tiet_dm(m_ds, ip_v_id_phong_ban, ip_v_dt_tu_ngay, ip_v_dt_den_ngay);
m_dt_den_ngay = ip_v_dt_den_ngay;
m_dt_tu_ngay = ip_v_dt_tu_ngay;
m_id_phong_ban = ip_v_id_phong_ban;
m_id_loai_dm = ip_v_id_loai_dm;
this.ShowDialog();
}
public void export_excel_TH_THSD(
TINH_HINH_SU_DUNG ip_str_loai_bao_cao
, ref IP.Core.QltsFormControls.CObjExcelAssetParameters op_obj_excel_parameters)
{
m_obj_trans = get_trans_object(m_fg);
US_DM_DON_VI v_us_dm_don_vi_bo_tinh;
CExcelWebReport v_obj_exe_report;
if (op_obj_excel_parameters.dcID_BO_TINH != CONST_QLDB.ID_TAT_CA)
{
v_us_dm_don_vi_bo_tinh = new US_DM_DON_VI(op_obj_excel_parameters.dcID_BO_TINH);
}
else
{
v_us_dm_don_vi_bo_tinh = new US_DM_DON_VI();
}
switch (ip_str_loai_bao_cao)
{
case TINH_HINH_SU_DUNG.TONG_HOP_CHUNG:
v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-THC.xls", 17, 1); ;
load_data_to_grid_thsd_tong_hop_chung(op_obj_excel_parameters);
break;
case TINH_HINH_SU_DUNG.DON_VI_SU_DUNG:
v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-CT.xls", 17, 1); ;
load_data_to_grid_thsd_theo_don_vi(op_obj_excel_parameters);
break;
default:
v_obj_exe_report = new CExcelWebReport("BC-400 BCTH-THSDTSK-THC.xls", 17, 1); ;
load_data_to_grid_thsd_tong_hop_chung(op_obj_excel_parameters);
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_BO_TINH>", v_us_dm_don_vi_bo_tinh.strTEN_DON_VI);
v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", v_us_dm_don_vi_bo_tinh.strMA_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);
op_obj_excel_parameters.strFILE_NAME_RESULT = v_obj_exe_report.GetStrOutputFileNameWithPath();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
CCommon.load_data_2_cbo_lop_mon(-1, m_cbo_lop_mon);
CCommon.load_data_2_cbo_nhan_vien(CAppContext_201.getCurrentUserID(), m_cbo_nhan_vien_thu);
CCommon.load_data_2_cbo_nhan_vien(CAppContext_201.getCurrentUserID(), m_cbo_nhan_vien_nhap);
m_cbo_lop_mon.SelectedIndexChanged += m_cbo_lop_mon_SelectedIndexChanged;
//load_data_2_grid();
}
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();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
m_obj_trans_nguoi_dai_dien = get_trans_object_cau_tra_loi(m_fg_nguoi_dai_dien);
load_data_2_grid();
grid2us_object(m_us, 1);
load_data_2_grid_nguoi_dai_dien(m_us.dcID);
switch (m_e_form_mode)
{
case e_formMode.VIEW_TOAN_BO:
break;
case e_formMode.VIEW_QLHT:
m_grb_dm_cau_hoi.Text = "Danh sách trường";
m_grb_ds_nguoi_dai_dien.Text = "Danh sách QLHT của trường";
m_lbl_header.Text = "F503 - Tra cứu danh sách QLHT";
this.Text = "F503 - Tra cứu danh sách QLHT";
break;
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
QltsFormControls.load_data_to_cbo_bo_tinh(
QltsFormControls.eTAT_CA.YES
, m_cbo_bo_tinh);
QltsFormControls.load_data_to_cbo_don_vi_chu_quan(
CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, QltsFormControls.eTAT_CA.YES
, m_cbo_don_vi_chu_quan);
QltsFormControls.load_data_to_cbo_don_vi_su_dung(
CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, QltsFormControls.eTAT_CA.YES
, m_cbo_don_vi_su_dung);
load_data_2_cbo_trang_thai_oto();
if (m_cbo_don_vi_su_dung.SelectedValue == null) return;
if (m_cbo_trang_thai_tai_san.SelectedValue == null) return;
load_data_2_grid(
CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue)
, CONST_QLDB.ID_TAT_CA
, CIPConvert.ToDecimal(m_cbo_trang_thai_tai_san.SelectedValue)
, m_txt_search.Text);
}
private void set_initial_form_load()
{
m_txt_tu_ngay.Text = CIPConvert.ToStr(DateTime.Now, "dd/MM/yyyy");
m_txt_den_ngay.Text = CIPConvert.ToStr(DateTime.Now.AddMonths(2), "dd/MM/yyyy");
m_obj_trans = get_trans_object(m_fg);
load_data_2_grid();
}
private void set_initial_form_load()
{
try
{
m_obj_trans = get_trans_object(m_fg);
load_data_to_cbo_bo_tinh();
// load_data_2_grid();
}
catch (System.Exception ex)
{
CSystemLog_301.ExceptionHandle(ex);
}
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
load_data_2_cbo_lop_mon_cu();
load_data_2_cbo_lop_mon_moi();
//load_data_2_grid();
}
public decimal display(decimal ip_dc_id_lop_mon)
{
m_obj_trans = get_trans_object(m_fg);
m_trang_thai_hien_thi = 1;
load_data_2_cbo_lop_mon(ip_dc_id_lop_mon, m_trang_thai_hien_thi);
m_cbo_trang_thai_hv.SelectedValue = CONST_ID_TRANG_THAI_HOC_SINH.DANG_HOC;
load_data_2_grid();
this.ShowDialog();
return m_trang_thai_hien_thi;
}
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();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
load_data_2_grid();
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg);
if(m_e_form_mode == e_form_mode.DISPLAY_FROM_CALL_SINH_VIEN)
load_data_2_grid();
if (m_e_form_mode == e_form_mode.DISPLAY_FROM_MAIN_FORM)
m_cmd_select.Visible = false;
}
private void set_initial_form_load()
{
m_obj_trans = get_trans_object(m_fg_don_dat_hang);
m_obj_trans_de = get_trans_object_de(m_fg_don_dat_hang_de);
load_data_2_grid();
m_dt_chon_thang.Checked = true;
m_dt_chon_thang.Value = DateTime.Now.Date;
}
private void set_initial_form_load()
{
load_data_to_cbo_phap_nhan();
m_obj_trans = get_trans_object(m_fg);
DateTime v_dau_thang = DateTime.Now.AddDays(-DateTime.Now.Day + 1);
//v_dau_thang=v_dat
m_txt_tu_ngay.Text = CIPConvert.ToStr(v_dau_thang.AddMonths(-v_dau_thang.Month + 1), "dd/MM/yyyy");
m_txt_den_ngay.Text = CIPConvert.ToStr(v_dau_thang.AddMonths(1).AddDays(-1), "dd/MM/yyyy");
load_data_2_grid();
}
