public US_V_F316_DM_HOC_SINH_LOP_MON(decimal i_dbID)
{
pm_objDS = new DS_V_F316_DM_HOC_SINH_LOP_MON();
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_lbl_tong_so_hoc_sinh(decimal ip_dc_id_lop_mon)
{
DS_V_F316_DM_HOC_SINH_LOP_MON v_ds_hoc_sinh_lop_mon = new DS_V_F316_DM_HOC_SINH_LOP_MON();
US_V_F316_DM_HOC_SINH_LOP_MON v_us_hoc_sinh_lop_mon = new US_V_F316_DM_HOC_SINH_LOP_MON();
decimal op_dc_tong_so_hoc_sinh = 0;
v_us_hoc_sinh_lop_mon.FillDataset_2_lbl_tong_so(v_ds_hoc_sinh_lop_mon, ip_dc_id_lop_mon, ref op_dc_tong_so_hoc_sinh);
m_lbl_tong_so_hoc_sinh.Text = op_dc_tong_so_hoc_sinh.ToString();
}
private void load_data_2_cbo_hoc_sinh(decimal ip_dc_id_lop_mon)
{
DS_V_F316_DM_HOC_SINH_LOP_MON v_ds_hoc_sinh_lop_mon = new DS_V_F316_DM_HOC_SINH_LOP_MON();
US_V_F316_DM_HOC_SINH_LOP_MON v_us_hoc_sinh_lop_mon = new US_V_F316_DM_HOC_SINH_LOP_MON();
v_ds_hoc_sinh_lop_mon.Clear();
v_ds_hoc_sinh_lop_mon.EnforceConstraints = false;
v_us_hoc_sinh_lop_mon.FillDataset(v_ds_hoc_sinh_lop_mon
, ip_dc_id_lop_mon);
m_cbo_hs.DataSource = v_ds_hoc_sinh_lop_mon.V_F316_DM_HOC_SINH_LOP_MON;
m_cbo_hs.DisplayMember = V_F316_DM_HOC_SINH_LOP_MON.HO_TEN;
m_cbo_hs.ValueMember = V_F316_DM_HOC_SINH_LOP_MON.ID;
}
public void FillDataset_2_lbl_tong_so(DS_V_F316_DM_HOC_SINH_LOP_MON op_ds_tong_so_hoc_sinh,
decimal ip_dc_id_lop_mon,
ref decimal op_dc_tong_so_hoc_sinh)
{
CStoredProc v_obj_spr = new CStoredProc("pr_tinh_tong_so_hoc_sinh_theo_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
SqlParameter v_tong_so_hoc_sinh = v_obj_spr.addDecimalOutputParam("@op_dc_tong_so_hoc_sinh", op_dc_tong_so_hoc_sinh);
v_obj_spr.fillDataSetByCommand(this, op_ds_tong_so_hoc_sinh);
op_dc_tong_so_hoc_sinh = CIPConvert.ToDecimal(v_tong_so_hoc_sinh.Value);
}
public void FillDataset(DS_V_F316_DM_HOC_SINH_LOP_MON op_ds
, decimal ip_dc_id_lop_mon)
{
CStoredProc v_obj_spr = new CStoredProc("pr_get_hs_by_id_lop_mon");
v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public US_V_F316_DM_HOC_SINH_LOP_MON()
{
pm_objDS = new DS_V_F316_DM_HOC_SINH_LOP_MON();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
