public void FillDatasetSearch(DS_DM_CHUC_VU op_ds, string i_str_search)
{
CStoredProc v_sp = new CStoredProc("pr_DM_CHUC_VU_search");
v_sp.addNVarcharInputParam("@STR_SEARCH", i_str_search);
v_sp.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_sle_chon_vi_tri()
{
m_sle_chon_vi_tri.EditValue = null;
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_chon_don_vi.EditValue));
m_sle_chon_vi_tri.Properties.DataSource = v_ds.Tables[0];
}
public void FillDatasetByID(DS_DM_CHUC_VU op_ds, decimal ip_dc_id, ref string op_str)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_CHUC_VU_filldataset_by_id");
v_cstore.addDecimalInputParam("@ID", ip_dc_id);
SqlParameter v_sql = v_cstore.addNVarcharOutputParam("@TEN", op_str);
v_cstore.fillDataSetByCommand(this, op_ds);
op_str = v_sql.Value.ToString();
}
private bool check_cv_dang_su_dung(decimal ip_id_don_vi)
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds, "where id_don_vi = " + ip_id_don_vi);
if (v_ds.Tables[0].Rows.Count == 0)
{
return false;
}
else return true;
}
public US_DM_CHUC_VU(decimal i_dbID)
{
pm_objDS = new DS_DM_CHUC_VU();
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 bool check_ma_cv_da_ton_tai()
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds, "where ma_chuc_vu = N'" + m_txt_ma_chuc_vu.Text +"'");
if (m_us.strMA_CHUC_VU != m_txt_ma_chuc_vu.Text && v_ds.Tables[0].Rows.Count !=0)
{
return true;
}
return false;
}
public US_DM_CHUC_VU(decimal i_dbID)
{
pm_objDS = new DS_DM_CHUC_VU();
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 bool check_trung_ma_cv(string ip_str_ma_cv)
{
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
decimal count_ma_cv;
m_us.FillDataset(v_ds, ip_str_ma_cv);
count_ma_cv = v_ds.DM_CHUC_VU.Count;
if (count_ma_cv > 0)
{
return(false);
}
return(true);
}
private void load_data_to_cbo_chuc_vu()
{
DS_DM_CHUC_VU v_ds_chuc_vu = new DS_DM_CHUC_VU();
US_DM_CHUC_VU v_us_chuc_vu = new US_DM_CHUC_VU();
v_us_chuc_vu.FillDataset(v_ds_chuc_vu);
m_cbo_chuc_vu_moi.DataSource = v_ds_chuc_vu.DM_CHUC_VU;
m_cbo_chuc_vu_moi.DisplayMember = DM_CHUC_VU.TEN_CV;
m_cbo_chuc_vu_moi.ValueMember = DM_CHUC_VU.ID;
m_cbo_ma_chuc_vu_moi.DataSource = v_ds_chuc_vu.DM_CHUC_VU;
m_cbo_ma_chuc_vu_moi.DisplayMember = DM_CHUC_VU.MA_CV;
m_cbo_ma_chuc_vu_moi.ValueMember = DM_CHUC_VU.ID;
}
private bool confirm_save_data()
{
US_DM_CHUC_VU v_us_dm_chuc_vu = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds_dm_chuc_vu = new DS_DM_CHUC_VU();
string v_str_chuc_vu = "";
v_us_dm_chuc_vu.FillDatasetByID(v_ds_dm_chuc_vu, CIPConvert.ToDecimal(m_cbo_chuc_vu_moi.SelectedValue), ref v_str_chuc_vu);
if (m_b_check_is_mien_nhiem)
{
if (BaseMessages.MsgBox_Confirm("Bạn có thực sự muốn miễn nhiệm chức vụ \"" + v_str_chuc_vu + "\" của " + m_us.strHO_DEM + " " + m_us.strTEN + "\" tại\n \"" + m_txt_don_vi_moi.Text + "\" không?"))
{
if (BaseMessages.MsgBox_Confirm("Bạn có muốn miễn nhiệm chức vụ hiện tại của " + m_us.strHO_DEM + " " + m_us.strTEN + " không ?"))
{
mien_nhiem_chuc_vu();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
if (BaseMessages.MsgBox_Confirm("Bạn có thực sự muốn thay đổi chức vụ của \"" + m_us.strHO_DEM + " " + m_us.strTEN + "\" thành\n \"" + v_str_chuc_vu + "\" tại \"" + m_txt_don_vi_moi.Text + "\" không?"))
{
if (BaseMessages.MsgBox_Confirm("Bạn có muốn miễn nhiệm chức vụ hiện tại của " + m_us.strHO_DEM + " " + m_us.strTEN + " không ?"))
{
mien_nhiem_chuc_vu();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private void load_data_to_cbc_choose_columns()
{
DS_DM_CHUC_VU v_ds_cv = new DS_DM_CHUC_VU();
US_DM_CHUC_VU v_us_cv = new US_DM_CHUC_VU();
v_us_cv.FillDataset(v_ds_cv);
//m_cbc_choose_columns.DisplayMember = DM_CHUC_VU.MA_CV;
//m_cbc_choose_columns.ValueMember = DM_CHUC_VU.MA_CV;
//m_cbc_choose_columns.DataSource = v_ds_cv.DM_CHUC_VU;
foreach (DataRow dr in v_ds_cv.DM_CHUC_VU)
{
m_clb_chuc_vu.Items.Add(dr[1].ToString());
}
for (int i = 0; i < m_clb_chuc_vu.Items.Count; i++)
{
m_clb_chuc_vu.SetItemChecked(i, true);
ma_cv = string.Concat(ma_cv, m_clb_chuc_vu.Items[i].ToString());
}
}
private void load_data_to_sle_chuc_vu()
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_don_vi.EditValue));
m_sle_chuc_vu.Properties.DataSource = v_ds.Tables[0];
m_sle_chuc_vu.Properties.DisplayMember = DM_CHUC_VU.TEN_CHUC_VU;
m_sle_chuc_vu.Properties.ValueMember = DM_CHUC_VU.ID;
//m_sle_chuc_vu.Properties.NullText = "---Chọn chức vụ---";
m_sle_chuc_vu.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
m_sle_chuc_vu.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit;
}
public US_DM_CHUC_VU()
{
pm_objDS = new DS_DM_CHUC_VU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private DataTable load_data_to_chuc_vu()
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds);
return v_ds.Tables[0];
}
private void load_data_2_sle_chon_vi_tri()
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds, " where id_don_vi = " + Convert.ToDecimal(m_sle_chon_don_vi.EditValue));
m_sle_chon_vi_tri.Properties.DataSource = v_ds.Tables[0];
m_sle_chon_vi_tri.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
m_sle_chon_vi_tri.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit;
}
private void load_data_to_sle_chuc_vu()
{
US_DM_CHUC_VU v_us = new US_DM_CHUC_VU();
DS_DM_CHUC_VU v_ds = new DS_DM_CHUC_VU();
v_us.FillDataset(v_ds);
m_sle_chuc_vu.Properties.DataSource = v_ds.Tables[0];
m_sle_chuc_vu.Properties.DisplayMember = DM_CHUC_VU.TEN_CHUC_VU;
m_sle_chuc_vu.Properties.ValueMember = DM_CHUC_VU.ID;
m_sle_chuc_vu.Properties.NullText = "---Chọn chức vụ---";
}
public US_DM_CHUC_VU()
{
pm_objDS = new DS_DM_CHUC_VU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
