public void FillDatasetByKeyWord(DS_V_GD_CHI_TIET_CAP_BAC op_ds_v_v_dm_don_vi, string ip_str_key_word)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_CHI_TIET_CAP_BAC_search");
v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_key_word);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_v_dm_don_vi);
}
public void FillDatasetByManhanvien(DS_V_GD_CHI_TIET_CAP_BAC op_ds_v_gd_chi_tiet_cap_bac, string ip_str_search)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_CHI_TIET_CAP_BAC_by_Ma_nhan_vien");
v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_gd_chi_tiet_cap_bac);
}
public void FillDatasetSearchCapCacThoiDiem(DS_V_GD_CHI_TIET_CAP_BAC op_ds_v_gd_chi_tiet_cap_bac, string ip_str_key_word, DateTime ip_dat_thoi_diem)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_CHI_TIET_CAP_BAC_select_by_MA_CAP_BAC_THOI_DIEM");
v_stored_proc.addNVarcharInputParam("@MA_CAP_BAC", ip_str_key_word);
v_stored_proc.addDatetimeInputParam("@THOI_DIEM", ip_dat_thoi_diem);
v_stored_proc.fillDataSetByCommand(this, op_ds_v_gd_chi_tiet_cap_bac);
}
public void display_for_insert(US_V_GD_CHI_TIET_CAP_BAC ip_us_gs_chi_tiet_cap_bac, DS_V_GD_CHI_TIET_CAP_BAC ip_ds_gs_chi_tiet_cap_bac)
{
m_e_formmode = DataEntryFormMode.InsertDataState;
m_v_us_chi_tiet_cap_bac = ip_us_gs_chi_tiet_cap_bac;
m_ds_gd_chi_tiet_cap_bac = ip_ds_gs_chi_tiet_cap_bac;
us_object_2_form();
ShowDialog();
}
private void them_cap_bac()
{
US_V_GD_CHI_TIET_CAP_BAC v_us = new US_V_GD_CHI_TIET_CAP_BAC();
DS_V_GD_CHI_TIET_CAP_BAC v_ds = new DS_V_GD_CHI_TIET_CAP_BAC();
v_us.FillDatasetByManhanvien(v_ds, m_us_nhan_su.strMA_NV);
v_us.DataRow2Me((DataRow)v_ds.V_GD_CHI_TIET_CAP_BAC.Rows[0]);
f106_v_gd_chi_tiet_cap_bac_DE v_frm = new f106_v_gd_chi_tiet_cap_bac_DE();
v_frm.display_for_insert(v_us, v_ds);
}
public US_V_GD_CHI_TIET_CAP_BAC(decimal i_dbID)
{
pm_objDS = new DS_V_GD_CHI_TIET_CAP_BAC();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_data_2_grid()
{
m_ds = new DS_V_GD_CHI_TIET_CAP_BAC();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count
, 0
, (int)e_col_Number.MA_CAP
, (int)e_col_Number.MA_NV
, "{0}"
);
m_fg.Redraw = true;
}
private void load_data_2_grid_search()
{
m_ds = new DS_V_GD_CHI_TIET_CAP_BAC();
m_us.FillDatasetSearchCapCacThoiDiem(m_ds, m_txt_tim_kiem.Text.Trim(), m_dtp_thoidiem.Value);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count
, 0
, (int)e_col_Number.MA_CAP
, (int)e_col_Number.MA_BAC
, "{0}"
);
m_fg.Redraw = true;
m_lbl_soluongns.Text = m_ds.V_GD_CHI_TIET_CAP_BAC.Count.ToString();
}
private void load_data_2_grid()
{
m_ds = new DS_V_GD_CHI_TIET_CAP_BAC();
var v_str_search = m_txt_search.Text.Trim();
if (v_str_search.Equals(m_str_goi_y_tim_kiem))
{
v_str_search = "";
}
m_us.FillDatasetByKeyWord(m_ds, v_str_search);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
m_fg.Subtotal(AggregateEnum.Count
, 0
, (int)e_col_Number.MA_NV // Cột lấy tiêu đề tree
, (int)e_col_Number.TEN // Subtotal theo cột này
, "{0}"
);
load_custom_source_2_m_txt_search();
set_search_format_before();
/*Đếm số dòng dữ liệu trên Grid*/
m_lbl_so_luong_ban_ghi.Text = m_ds.V_GD_CHI_TIET_CAP_BAC.Count.ToString();
}
public US_V_GD_CHI_TIET_CAP_BAC()
{
pm_objDS = new DS_V_GD_CHI_TIET_CAP_BAC();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
