public void check_so_hop_dong(DS_DM_HOP_DONG_KHUNG ip_ds_dm_hop_dong_khung, string ip_str_so_hop_dong)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_HOP_DONG_KHUNG_check_so_hop_dong");
v_cstore.addNVarcharInputParam("@So_Hop_dong", ip_str_so_hop_dong);
v_cstore.fillDataSetByCommand(this, ip_ds_dm_hop_dong_khung);
}
public decimal get_id_by_so_hop_dong(string ip_so_hop_dong)
{
US_DM_HOP_DONG_KHUNG v_us_hop_dong = new US_DM_HOP_DONG_KHUNG();
DS_DM_HOP_DONG_KHUNG v_ds_hop_dong = new DS_DM_HOP_DONG_KHUNG();
v_us_hop_dong.FillDataset(v_ds_hop_dong, " WHERE SO_HOP_DONG =N'" + ip_so_hop_dong + "'");
return(CIPConvert.ToDecimal(v_ds_hop_dong.DM_HOP_DONG_KHUNG.Rows[0][DM_HOP_DONG_KHUNG.ID]));
}
private bool check_exist_so_hop_dong(string ip_str_so_hd)
{
US_DM_HOP_DONG_KHUNG v_us_dm_hop_dong_khung = new US_DM_HOP_DONG_KHUNG();
DS_DM_HOP_DONG_KHUNG v_ds_dm_hop_dong_khung = new DS_DM_HOP_DONG_KHUNG();
v_us_dm_hop_dong_khung.FillDataset(v_ds_dm_hop_dong_khung, " WHERE SO_HOP_DONG=N'" + ip_str_so_hd + "'");
if (v_ds_dm_hop_dong_khung.DM_HOP_DONG_KHUNG.Rows.Count == 0)
{
return(false); // Nghĩa là không tồn tại số hợp đồng đó
}
return(true); // Nghĩa là tồn tại số hợp đồng đó
}
private decimal get_id_by_so_hop_dong(string ip_str_so_hd)
{
US_DM_HOP_DONG_KHUNG v_us_dm_hd_khung = new US_DM_HOP_DONG_KHUNG();
DS_DM_HOP_DONG_KHUNG v_ds_dm_hd_khung = new DS_DM_HOP_DONG_KHUNG();
v_us_dm_hd_khung.FillDataset(v_ds_dm_hd_khung, " WHERE SO_HOP_DONG =N'" + ip_str_so_hd + "'");
if (v_ds_dm_hd_khung.DM_HOP_DONG_KHUNG.Rows.Count > 0)
{
return(CIPConvert.ToDecimal(v_ds_dm_hd_khung.DM_HOP_DONG_KHUNG.Rows[0][DM_HOP_DONG_KHUNG.ID]));
}
return(0);
}
public US_DM_HOP_DONG_KHUNG(decimal i_dbID)
{
pm_objDS = new DS_DM_HOP_DONG_KHUNG();
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_2_cbo_so_hop_dong()
{
US_DM_HOP_DONG_KHUNG v_us_hop_dong_khung = new US_DM_HOP_DONG_KHUNG();
DS_DM_HOP_DONG_KHUNG v_ds_hop_dong_khung = new DS_DM_HOP_DONG_KHUNG();
v_ds_hop_dong_khung.Clear();
m_cbo_so_hd.Items.Clear();
v_us_hop_dong_khung.FillDataset(v_ds_hop_dong_khung, "WHERE ID_GIANG_VIEN=" + CIPConvert.ToDecimal(m_cbo_ten_giang_vien.SelectedValue));
m_cbo_so_hd.Items.Add(new ListItem("Không có hợp đồng", CIPConvert.ToStr(0)));
for (int v_i = 0; v_i < v_ds_hop_dong_khung.DM_HOP_DONG_KHUNG.Rows.Count; v_i++)
{
m_cbo_so_hd.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_hop_dong_khung.DM_HOP_DONG_KHUNG.Rows[v_i][DM_HOP_DONG_KHUNG.SO_HOP_DONG]), CIPConvert.ToStr(v_ds_hop_dong_khung.DM_HOP_DONG_KHUNG.Rows[v_i][DM_HOP_DONG_KHUNG.ID])));
}
}
private void load_2_cbo_hop_dong_khung()
{
US_DM_HOP_DONG_KHUNG v_us = new US_DM_HOP_DONG_KHUNG();
DS_DM_HOP_DONG_KHUNG v_ds = new DS_DM_HOP_DONG_KHUNG();
try
{
v_us.FillDataset(v_ds);
m_cbo_dm_hop_dong_khung.DataSource = v_ds.DM_HOP_DONG_KHUNG;
m_cbo_dm_hop_dong_khung.DataValueField = DM_HOP_DONG_KHUNG.ID;
m_cbo_dm_hop_dong_khung.DataTextField = DM_HOP_DONG_KHUNG.SO_HOP_DONG;
m_cbo_dm_hop_dong_khung.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
public US_DM_HOP_DONG_KHUNG()
{
pm_objDS = new DS_DM_HOP_DONG_KHUNG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
