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