public US_V_DM_CAU_HOI(decimal i_dbID)
{
pm_objDS = new DS_V_DM_CAU_HOI();
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_cau_hoi = new DS_V_DM_CAU_HOI();
m_us_cau_hoi.search_dm_cau_hoi(m_txt_key_cau_hoi.Text.Trim()
, CIPConvert.ToDecimal(m_cbo_don_vi_lien_quan.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_loai_cau_hoi_tren.SelectedValue)
, m_ds_cau_hoi);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds_cau_hoi, m_fg, m_obj_trans);
set_tree_on_grid();
m_fg.Redraw = true;
m_fg.Focus();
if (m_fg.Rows.Count > 3)
{
m_fg.Select(3, 3, true);
}
}
public void search_dm_cau_hoi(string i_str_key_search
,decimal i_dc_id_don_vi_lien_quan
,decimal i_dc_id_loai_cau_hoi
, DS_V_DM_CAU_HOI i_us_cau_hoi)
{
CStoredProc v_cstore = new CStoredProc("pr_V_GD_CAU_HOI_YEU_CAU_search_dm_cau_hoi");
v_cstore.addNVarcharInputParam("@KEY_SEARCH", i_str_key_search);
v_cstore.addDecimalInputParam("@ID_DON_VI", i_dc_id_don_vi_lien_quan);
v_cstore.addDecimalInputParam("@ID_LOAI_CAU_HOI", i_dc_id_loai_cau_hoi);
v_cstore.fillDataSetByCommand(this, i_us_cau_hoi);
}
public US_V_DM_CAU_HOI()
{
pm_objDS = new DS_V_DM_CAU_HOI();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}