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(); }