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