public void FillDataset_By_Ma_cap(DS_V_DM_CAP_BAC op_ds, string ip_str_ma_cap)
{
CStoredProc v_sp = new CStoredProc("pr_V_DM_CAP_BAC_By_Ma_cap");
v_sp.addNVarcharInputParam("@ip_str_ma_cap", ip_str_ma_cap);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetSearch(DS_V_DM_CAP_BAC op_ds, string i_str_search)
{
CStoredProc v_sp = new CStoredProc("pr_V_DM_CAP_BAC_search");
v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search);
v_sp.fillDataSetByCommand(this, op_ds);
}
public US_V_DM_CAP_BAC(decimal i_dbID)
{
pm_objDS = new DS_V_DM_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 bool check_trung_ma_cap(string ip_str_ma_cap)
{
DS_V_DM_CAP_BAC v_ds = new DS_V_DM_CAP_BAC();
decimal count_ma_cap;
m_v_us.FillDataset_By_Ma_cap(v_ds, ip_str_ma_cap);
count_ma_cap = v_ds.V_DM_CAP_BAC.Count;
if (count_ma_cap > 0)
{
return(true);
}
return(false);
}
private void load_data_to_cbo()
{
/**
* Load data to combobox Loại quyết định
*/
WinFormControls.load_data_to_cbo_tu_dien(WinFormControls.eLOAI_TU_DIEN.LOAI_QUYET_DINH,
WinFormControls.eTAT_CA.NO,
m_cbo_loai_quyet_dinh);
var v_ds = new DS_V_DM_CAP_BAC();
var v_us = new US_V_DM_CAP_BAC();
v_us.FillDataset(v_ds);
/**
* Load data to combobox Mã cấp bậc
*/
m_cbo_ma_cap_bac.DataSource = v_ds.V_DM_CAP_BAC;
m_cbo_ma_cap_bac.DisplayMember = V_DM_CAP_BAC.MA_CAP_BAC;
m_cbo_ma_cap_bac.ValueMember = V_DM_CAP_BAC.ID;
}
private void load_data_2_grid()
{
m_v_ds = new DS_V_DM_CAP_BAC();
if (m_txt_tim_kiem.Text.Trim() == m_str_tim_kiem || m_txt_tim_kiem.Text.Trim() == "")
{
m_v_us.FillDataset(m_v_ds);
}
else
{
m_v_us.FillDatasetSearch(m_v_ds, m_txt_tim_kiem.Text.Trim());
}
//m_us.FillDataset(m_ds);
var v_str_search = m_txt_tim_kiem.Text.Trim();
if (v_str_search.Equals(m_str_tim_kiem))
{
v_str_search = "";
}
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_v_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
set_search_format_before();
}
public US_V_DM_CAP_BAC()
{
pm_objDS = new DS_V_DM_CAP_BAC();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
