public void FillDatasetSearch(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds, string i_str_search)
{
CStoredProc v_sp = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_search");
v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void FillDatasetByID_TRANG_THAI_PARENT(DS_V_DM_TRANG_THAI_UNG_VIEN op_ds)
{
CStoredProc cstored = new CStoredProc("pr_V_DM_TRANG_THAI_UNG_VIEN_Select_by_ID_Parent");
//cstored.addDecimalInputParam("@ID_NS", i_str_search);
cstored.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
m_ds = new DS_V_DM_TRANG_THAI_UNG_VIEN();
if (m_txt_tim_kiem.Text.Trim() == m_str_tim_kiem || m_txt_tim_kiem.Text.Trim() == "")
{
m_us.FillDatasetSearch(m_ds, "");
}
else
{
m_us.FillDatasetSearch(m_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_ds, m_fg, m_obj_trans);
m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế
, 0
, (int)e_col_Number.MA_TRANG_THAI_CAP_TREN // chỗ này là tên trường mà mình nhóm
, (int)e_col_Number.MA_TRANG_THAI // chỗ này là tên trường mà mình Count
, "{0}"
);
m_fg.Redraw = true;
set_search_format_before();
}
public US_V_DM_TRANG_THAI_UNG_VIEN(decimal i_dbID)
{
pm_objDS = new DS_V_DM_TRANG_THAI_UNG_VIEN();
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_cbo_ma_trang_thai_cap_tren()
{
var v_ds = new DS_V_DM_TRANG_THAI_UNG_VIEN();
var v_us = new US_V_DM_TRANG_THAI_UNG_VIEN();
v_us.FillDatasetByID_TRANG_THAI_PARENT(v_ds);
//v_us.FillDatasetSearch(v_ds, "");
m_cbo_ma_trang_thai_cap_tren.DisplayMember = V_DM_TRANG_THAI_UNG_VIEN.MA_TRANG_THAI_CAP_TREN;
m_cbo_ma_trang_thai_cap_tren.ValueMember = V_DM_TRANG_THAI_UNG_VIEN.ID_TRANG_THAI_CAP_TREN;
m_cbo_ma_trang_thai_cap_tren.DataSource = v_ds.V_DM_TRANG_THAI_UNG_VIEN;
var v_row = v_ds.V_DM_TRANG_THAI_UNG_VIEN.NewRow();
v_row[V_DM_TRANG_THAI_UNG_VIEN.ID] = -1;
v_row[V_DM_TRANG_THAI_UNG_VIEN.MA_TRANG_THAI] = "NULL";
v_row[V_DM_TRANG_THAI_UNG_VIEN.ID_TRANG_THAI_CAP_TREN] = -1;
v_row[V_DM_TRANG_THAI_UNG_VIEN.DINH_NGHIA] = "";
v_row[V_DM_TRANG_THAI_UNG_VIEN.DAU_HIEU] = "";
v_row[V_DM_TRANG_THAI_UNG_VIEN.VIEC_CAN_LAM] = "";
v_ds.V_DM_TRANG_THAI_UNG_VIEN.Rows.InsertAt(v_row, 0);
}
public US_V_DM_TRANG_THAI_UNG_VIEN()
{
pm_objDS = new DS_V_DM_TRANG_THAI_UNG_VIEN();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
