public void load_nguoi_dai_dien_by_acc_scm(DS_V_DM_NGUOI_DAI_DIEN op_ds_dm_nguoi_dai_dien, string ip_str_acc_scm) { CStoredProc v_cstore = new CStoredProc("pr_V_DM_NGUOI_DAI_DIEN_Load_Nguoi_Dai_Dien_By_Acc_SCM"); v_cstore.addNVarcharInputParam("@ACC_SCM", ip_str_acc_scm); v_cstore.fillDataSetByCommand(this, op_ds_dm_nguoi_dai_dien); }
public void load_ds_nguoi_dai_dien_by_id_to_chuc(DS_V_DM_NGUOI_DAI_DIEN op_ds_dm_nguoi_dai_dien) { CStoredProc v_cstore = new CStoredProc("pr_V_DM_NGUOI_DAI_DIEN_Load_Ds_Nguoi_Dai_Dien_By_To_Chuc"); v_cstore.addDecimalInputParam("@ID_DON_VI", this.dcID_DON_VI); v_cstore.addNVarcharInputParam("@CHUC_VU", this.strNDD_CHUC_VU); v_cstore.fillDataSetByCommand(this, op_ds_dm_nguoi_dai_dien); }
public US_V_DM_NGUOI_DAI_DIEN(decimal i_dbID) { pm_objDS = new DS_V_DM_NGUOI_DAI_DIEN(); 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_thong_tin_email_qlht(string ip_str_acc_scm_qlht) { US_V_DM_NGUOI_DAI_DIEN v_us_dm_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_dm_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); if (ip_str_acc_scm_qlht != "") { v_ds_dm_nguoi_dai_dien.EnforceConstraints = false; v_us_dm_nguoi_dai_dien.load_nguoi_dai_dien_by_acc_scm(v_ds_dm_nguoi_dai_dien, ip_str_acc_scm_qlht); if (v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows.Count > 0) { m_txt_email_qlht.Text = v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows[0][V_DM_NGUOI_DAI_DIEN.NDD_EMAIL].ToString(); } } }
private AutoCompleteStringCollection load_thong_tin_email_qlht_search(string ip_str_acc_scm_qlht) { US_V_DM_NGUOI_DAI_DIEN v_us_dm_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_dm_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); AutoCompleteStringCollection v_auto_complete_string_email = new AutoCompleteStringCollection(); v_ds_dm_nguoi_dai_dien.EnforceConstraints = false; v_us_dm_nguoi_dai_dien.load_nguoi_dai_dien_by_acc_scm(v_ds_dm_nguoi_dai_dien, ip_str_acc_scm_qlht); if (v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows.Count > 0) { foreach (DataRow v_dr in v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows) { v_auto_complete_string_email.Add(v_dr[V_DM_NGUOI_DAI_DIEN.NDD_EMAIL].ToString()); } } return(v_auto_complete_string_email); }
private void load_data_2_grid_nguoi_dai_dien(decimal ip_dc_id_don_vi) { m_us_nguoi_dai_dien.dcID_DON_VI = ip_dc_id_don_vi; switch (m_e_form_mode) { case e_formMode.VIEW_TOAN_BO: m_us_nguoi_dai_dien.strNDD_CHUC_VU = ""; break; case e_formMode.VIEW_QLHT: m_us_nguoi_dai_dien.strNDD_CHUC_VU = "QLHT"; break; } m_ds_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); m_us_nguoi_dai_dien.load_ds_nguoi_dai_dien_by_id_to_chuc(m_ds_nguoi_dai_dien); m_fg_nguoi_dai_dien.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds_nguoi_dai_dien, m_fg_nguoi_dai_dien, m_obj_trans_nguoi_dai_dien); m_fg_nguoi_dai_dien.Redraw = true; }
private void load_data_2_cbo_nguoi_dai_dien() { m_e_trang_thai_cbo_ndd = e_trang_thai_cbo_nguoi_dai_dien.DANG_FILL_DATA; US_V_DM_NGUOI_DAI_DIEN v_us_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); v_us_nguoi_dai_dien.dcID_DON_VI = CIPConvert.ToDecimal(m_cbo_don_vi_noi_bo.SelectedValue); v_us_nguoi_dai_dien.load_ds_nguoi_dai_dien_by_id_to_chuc(v_ds_nguoi_dai_dien); m_cbo_nguoi_dai_dien.DataSource = v_ds_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN; m_cbo_nguoi_dai_dien.DisplayMember = V_DM_NGUOI_DAI_DIEN.NDD_HO_TEN; m_cbo_nguoi_dai_dien.ValueMember = V_DM_NGUOI_DAI_DIEN.ID; m_e_trang_thai_cbo_ndd = e_trang_thai_cbo_nguoi_dai_dien.DA_FILL_XONG; if (m_cbo_nguoi_dai_dien.Items.Count > 0) { load_thong_tin_nguoi_dai_dien(); } else { m_txt_dien_thoai_ndd.Text = ""; m_pic_call_ndd.Visible = false; } }
private void load_data_2_grid_nguoi_dai_dien(decimal ip_dc_id_don_vi) { m_us_nguoi_dai_dien.dcID_DON_VI = ip_dc_id_don_vi; switch (m_e_form_mode) { case e_formMode.VIEW_TOAN_BO: m_us_nguoi_dai_dien.strNDD_CHUC_VU = ""; break; case e_formMode.VIEW_QLHT: m_us_nguoi_dai_dien.strNDD_CHUC_VU = "QLHT"; break; } m_ds_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); m_us_nguoi_dai_dien.load_ds_nguoi_dai_dien_by_id_to_chuc(m_ds_nguoi_dai_dien); m_fg_nguoi_dai_dien.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds_nguoi_dai_dien, m_fg_nguoi_dai_dien, m_obj_trans_nguoi_dai_dien); m_fg_nguoi_dai_dien.Redraw = true;
private AutoCompleteStringCollection load_thong_tin_email_qlht_search(string ip_str_acc_scm_qlht) { US_V_DM_NGUOI_DAI_DIEN v_us_dm_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_dm_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); AutoCompleteStringCollection v_auto_complete_string_email = new AutoCompleteStringCollection(); v_ds_dm_nguoi_dai_dien.EnforceConstraints = false; v_us_dm_nguoi_dai_dien.load_nguoi_dai_dien_by_acc_scm(v_ds_dm_nguoi_dai_dien, ip_str_acc_scm_qlht); if (v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows.Count > 0) { foreach (DataRow v_dr in v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows) { v_auto_complete_string_email.Add(v_dr[V_DM_NGUOI_DAI_DIEN.NDD_EMAIL].ToString()); } } return v_auto_complete_string_email; }
private void load_thong_tin_email_qlht(string ip_str_acc_scm_qlht) { US_V_DM_NGUOI_DAI_DIEN v_us_dm_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_dm_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); if (ip_str_acc_scm_qlht != "") { v_ds_dm_nguoi_dai_dien.EnforceConstraints = false; v_us_dm_nguoi_dai_dien.load_nguoi_dai_dien_by_acc_scm(v_ds_dm_nguoi_dai_dien, ip_str_acc_scm_qlht); if (v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows.Count > 0) m_txt_email_qlht.Text = v_ds_dm_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN.Rows[0][V_DM_NGUOI_DAI_DIEN.NDD_EMAIL].ToString(); } }
private void load_data_2_cbo_nguoi_dai_dien() { m_e_trang_thai_cbo_ndd = e_trang_thai_cbo_nguoi_dai_dien.DANG_FILL_DATA; US_V_DM_NGUOI_DAI_DIEN v_us_nguoi_dai_dien = new US_V_DM_NGUOI_DAI_DIEN(); DS_V_DM_NGUOI_DAI_DIEN v_ds_nguoi_dai_dien = new DS_V_DM_NGUOI_DAI_DIEN(); v_us_nguoi_dai_dien.dcID_DON_VI = CIPConvert.ToDecimal(m_cbo_don_vi_noi_bo.SelectedValue); v_us_nguoi_dai_dien.load_ds_nguoi_dai_dien_by_id_to_chuc(v_ds_nguoi_dai_dien); m_cbo_nguoi_dai_dien.DataSource = v_ds_nguoi_dai_dien.V_DM_NGUOI_DAI_DIEN; m_cbo_nguoi_dai_dien.DisplayMember = V_DM_NGUOI_DAI_DIEN.NDD_HO_TEN; m_cbo_nguoi_dai_dien.ValueMember = V_DM_NGUOI_DAI_DIEN.ID; m_e_trang_thai_cbo_ndd = e_trang_thai_cbo_nguoi_dai_dien.DA_FILL_XONG; if (m_cbo_nguoi_dai_dien.Items.Count > 0) load_thong_tin_nguoi_dai_dien(); else { m_txt_dien_thoai_ndd.Text = ""; m_pic_call_ndd.Visible = false; } }
public US_V_DM_NGUOI_DAI_DIEN() { pm_objDS = new DS_V_DM_NGUOI_DAI_DIEN(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }