private void chon_nhan_su()
{
string[] v_strs = m_txt_tim_kiem_nhan_vien.Text.Split('-');
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
m_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, v_strs[v_strs.Length - 1].Trim());
if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
{
return;
}
m_lbl_ma_nhan_vien.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["MA_NV"].ToString();
m_lbl_ho_va_ten.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["HO_DEM"] + " " +
v_ds_dm_nhan_su.Tables[0].Rows[0]["TEN"];
// DucVT
m_lbl_email_co_quan.Text = v_ds_dm_nhan_su.Tables[0].Rows[0][DM_NHAN_SU.EMAIL_CQ].ToString();
// Lấy chức vụ bằng Id nhân sự
DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qtlv = new DS_V_GD_QUA_TRINH_LAM_VIEC();
US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qtlv = new US_V_GD_QUA_TRINH_LAM_VIEC();
v_us_gd_qtlv.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qtlv, v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), CAppContext_201.getCurrentIDPhapnhan());
if (v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0)
{
m_lbl_ma_chuc_vu.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_CV].ToString();
m_lbl_ma_don_vi.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_DON_VI].ToString();
}
// ~DucVT
}
private void load_info_staff_to_form()
{
string[] v_strs = m_txt_tim_kiem_nhan_vien.Text.Split('-');
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
m_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, v_strs[v_strs.Length - 1].Trim());
if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
{
return;
}
m_us_dm_nhan_su.DataRow2Me(v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0]);
load_info_staff(m_us_dm_nhan_su);
// DucVT
// Lấy chức vụ bằng Id nhân sự
DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qtlv = new DS_V_GD_QUA_TRINH_LAM_VIEC();
US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qtlv = new US_V_GD_QUA_TRINH_LAM_VIEC();
v_us_gd_qtlv.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qtlv, v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), CAppContext_201.getCurrentIDPhapnhan());
if (v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0)
{
m_lbl_ma_chuc_vu.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_CV].ToString();
m_lbl_ma_don_vi.Text = v_ds_gd_qtlv.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_DON_VI].ToString();
}
// ~DucVT
}
// Event private methods
private void load_file_excel()
{
if (m_ofd_exel_file.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
// Reset lại ds mới nếu chọn lại file excel khác
m_ds = new DS_DM_NHAN_SU();
m_lbl_loading_mes.Visible = true;
CExcelReport v_excel_rpt = new CExcelReport(m_ofd_exel_file.FileName);
m_ds.EnforceConstraints = false;
v_excel_rpt.Export2DatasetDS_by_DucVT(m_ds, m_ds.DM_NHAN_SU.TableName, 2);
m_fg.Redraw = false;
//Gán DataSource
//m_fg.DataSource = m_ds.DM_NHAN_SU;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
m_lbl_loading_mes.Visible = false;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
}
private void view_info_Nhan_Su(decimal ip_id_nhan_su)
{
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
m_us_dm_nhan_su.FillDatasetByID(v_ds_dm_nhan_su, ip_id_nhan_su);
m_lbl_ma_nhan_vien.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString();
m_lbl_ho_va_ten.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.HO_DEM].ToString() + " " + v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.TEN].ToString();
// DucVT
m_lbl_email_co_quan.Text = v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.EMAIL_CQ].ToString();
// Lấy chức vụ bằng Id nhân sự
DS_V_GD_QUA_TRINH_LAM_VIEC v_ds_gd_qua_trinh_lam_viec = new DS_V_GD_QUA_TRINH_LAM_VIEC();
US_V_GD_QUA_TRINH_LAM_VIEC v_us_gd_qua_trinh_lam_viec = new US_V_GD_QUA_TRINH_LAM_VIEC();
v_us_gd_qua_trinh_lam_viec.FillDataSet_Now_By_Ma_NV_Id_PN(v_ds_gd_qua_trinh_lam_viec, v_ds_dm_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString(), CAppContext_201.getCurrentIDPhapnhan());
if (v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows.Count > 0)
{
m_lbl_ma_chuc_vu.Text = v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_CV].ToString();
m_lbl_ma_don_vi.Text = v_ds_gd_qua_trinh_lam_viec.V_GD_QUA_TRINH_LAM_VIEC.Rows[0][V_GD_QUA_TRINH_LAM_VIEC.MA_DON_VI].ToString();
}
// ~DucVT
}
public void FillDatasetByID(DS_DM_NHAN_SU op_ds_dm_nhan_su, decimal ip_dc_id)
{
CStoredProc cstored = new CStoredProc("pr_DM_NHAN_SU_Search_by_ID");
cstored.addDecimalInputParam("@ID_NS", ip_dc_id);
cstored.fillDataSetByCommand(this, op_ds_dm_nhan_su);
}
public void FillDataset_search_by_ma_nv(DS_DM_NHAN_SU op_ds_dm_nhan_su, string ip_str_search)
{
CStoredProc cstored = new CStoredProc("pr_DM_NHAN_SU_Search_by_ma_ns");
cstored.addNVarcharInputParam("@ip_str_search", ip_str_search);
cstored.fillDataSetByCommand(this, op_ds_dm_nhan_su);
}
private void form_2_us_object()
{
m_us.strMA_HOP_DONG = m_txt_ma_hop_dong.Text.Trim();
m_us.dcID_LOAI_HOP_DONG = (decimal)m_cbo_loai_hop_dong.SelectedValue;
m_us.dcID_PHAP_NHAN = CAppContext_201.getCurrentIDPhapnhan();
m_us.datNGAY_CO_HIEU_LUC = m_dat_ngay_co_hieu_luc.Value;
m_us.strTRANG_THAI_HOP_DONG = m_cbo_trang_thai.SelectedIndex.Equals(0) ? "Y" : "N";
m_us.strNGUOI_KY = m_txt_nguoi_ky.Text.Trim();
m_us.strCHUC_VU_NGUOI_KY = m_txt_chuc_vu_nguoi_ky.Text.Trim();
m_us.datNGAY_KY_HOP_DONG = m_dat_ngay_ky_hop_dong.Value;
if (m_us_dm_nhan_su.dcID == -1)
{
DS_DM_NHAN_SU m_ds_dm_nhan_su = new DS_DM_NHAN_SU();
m_us_dm_nhan_su.FillDataset_search_by_ma_nv(m_ds_dm_nhan_su, m_lbl_ma_nhan_vien.Text);
m_us.dcID_NHAN_SU = (decimal)m_ds_dm_nhan_su.Tables[0].Rows[0].ItemArray[0];
}
else
{
m_us.dcID_NHAN_SU = m_us_dm_nhan_su.dcID;
}
if (m_dat_ngay_het_han.Checked == false)
{
m_us.SetNGAY_HET_HANNull();
}
else
{
m_us.datNGAY_HET_HAN = m_dat_ngay_het_han.Value;
}
m_us.strLINK = m_lbl_file_name.Text;
}
private void save_data()
{
var v_count_left = m_lbox_nhan_vien_left.Items.Count;
var v_count_right = m_lbox_nhan_vien_right.Items.Count;
var v_id_don_vi_left = m_cbo_don_vi_left.SelectedValue;
var v_id_don_vi_right = m_cbo_don_vi_right.SelectedValue;
var v_us_dm_du_lieu_nhan_vien = new US_V_DM_DU_LIEU_NHAN_VIEN();
var v_ds_dm_du_lieu_nhan_vien = new DS_V_DM_DU_LIEU_NHAN_VIEN();
var v_us_dm_nhan_su = new US_DM_NHAN_SU();
var v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
var v_danh_sach_nhan_vien_left_new = new collection(1);
var v_danh_sach_nhan_vien_left_old = new collection(1);
var v_danh_sach_nhan_vien_left_insert = new collection(1);
var v_danh_sach_nhan_vien_left_delete = new collection(1);
var v_danh_sach_nhan_vien_right_new = new collection(1);
var v_danh_sach_nhan_vien_right_old = new collection(1);
var v_danh_sach_nhan_vien_right_insert = new collection(1);
var v_danh_sach_nhan_vien_right_delete = new collection(1);
v_us_dm_nhan_su.FillDataset(v_ds_dm_nhan_su);
v_us_dm_du_lieu_nhan_vien.FillDatasetByIdDonVi(v_ds_dm_du_lieu_nhan_vien, CIPConvert.ToDecimal(v_id_don_vi_left));
////-- Lưu nhân sự đơn vị LEFT
//+ Danh sách nhân viên mới trong ListBox
if (v_count_left > 0)
{
v_danh_sach_nhan_vien_left_new = new collection(v_count_left);
foreach (var v_item in m_lbox_nhan_vien_left.Items)
{
var v_ma_nhan_vien = get_ma_nhan_vien(v_item.ToString());
var v_nhan_vien = (DS_DM_NHAN_SU.DM_NHAN_SURow)(v_ds_dm_nhan_su.DM_NHAN_SU.Select("MA_NV = " + v_ma_nhan_vien)[0]);
v_danh_sach_nhan_vien_left_new.insert(v_nhan_vien.ID.ToString());
}
//+ Danh sách nhân viên cũ trước khi thay đổi ListBox
var v_count_nhan_vien = v_ds_dm_du_lieu_nhan_vien.V_DM_DU_LIEU_NHAN_VIEN.Count;
if (v_count_nhan_vien > 0)
{
var v_nhan_vien =
(v_ds_dm_du_lieu_nhan_vien.V_DM_DU_LIEU_NHAN_VIEN.Rows);
v_danh_sach_nhan_vien_left_old = new collection(v_count_nhan_vien);
foreach (DS_V_DM_DU_LIEU_NHAN_VIEN.V_DM_DU_LIEU_NHAN_VIENRow v_item in v_nhan_vien)
{
v_danh_sach_nhan_vien_left_old.insert(v_item.ID.ToString());
}
}
//+ Danh sách nhân viên thêm mới
v_danh_sach_nhan_vien_left_insert =
new collection(v_danh_sach_nhan_vien_left_new.countInANotInB(v_danh_sach_nhan_vien_left_old));
v_danh_sach_nhan_vien_left_insert =
v_danh_sach_nhan_vien_left_new.InANotInB(v_danh_sach_nhan_vien_left_old);
for (int i = 0; i < v_danh_sach_nhan_vien_left_insert.getIndex(); i++)
{
decimal v_id = CIPConvert.ToDecimal(v_danh_sach_nhan_vien_left_insert.s[i]);
v_us_dm_du_lieu_nhan_vien.FillDatasetByIdDonVi(v_ds_dm_du_lieu_nhan_vien, v_id);
}
}
//+ Danh sách nhân viên sẽ bị xoá
v_danh_sach_nhan_vien_left_delete = v_danh_sach_nhan_vien_left_old.InANotInB(v_danh_sach_nhan_vien_left_new);
}
private void load_data_2_grid()
{
m_ds = new DS_DM_NHAN_SU();
m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
public void FillDatasetSearch(DS_DM_NHAN_SU op_ds, string ip_ma_nv)
{
CStoredProc v_sp = new CStoredProc("pr_RPT_NHAN_VIEN_CHUA_CHUC_VU_TRANG_THAI");
v_sp.addNVarcharInputParam("@ip_ma_nv", ip_ma_nv);
v_sp.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
m_ds = new DS_DM_NHAN_SU();
m_us.FillDatasetSearch(m_ds, HelperDucVT.CUtils.get_ma_nv(m_txt_search.Text));
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
m_lbl_so_luong_nv_chua_chuc_vu_trang_thai.Text = m_ds.Tables[0].Rows.Count.ToString();
}
private void load_data_2_custom_source_ma_nhan_vien()
{
US_DM_NHAN_SU v_us = new US_DM_NHAN_SU();
DS_DM_NHAN_SU v_ds = new DS_DM_NHAN_SU();
v_us.FillDataset(v_ds);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
DataRow dr = v_ds.Tables[0].Rows[i];
m_txt_ma_ns.AutoCompleteCustomSource.Add(dr["MA_NV"].ToString());
}
}
public US_DM_NHAN_SU(decimal i_dbID)
{
pm_objDS = new DS_DM_NHAN_SU();
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 chon_nhan_su()
{
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();
v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, m_txt_ma_nv.Text.Trim());
if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
{
return;
}
m_txt_ho_ten.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["HO_DEM"] + " " +
v_ds_dm_nhan_su.Tables[0].Rows[0]["TEN"];
}
private void load_custom_source_2_m_txt_tim_kiem()
{
DS_DM_NHAN_SU v_ds = new DS_DM_NHAN_SU();
US_DM_NHAN_SU v_us = new US_DM_NHAN_SU();
v_us.FillDataset(v_ds);
int count = v_ds.Tables["DM_NHAN_SU"].Rows.Count;
AutoCompleteStringCollection v_acsc_search = new AutoCompleteStringCollection();
foreach (DataRow dr in v_ds.DM_NHAN_SU)
{
v_acsc_search.Add(dr[DM_NHAN_SU.MA_NV].ToString());
}
m_txt_ma_nv.AutoCompleteCustomSource = v_acsc_search;
}
private void auto_suggest_text()
{
US_DM_NHAN_SU us_dm_nhan_su = new US_DM_NHAN_SU();
DS_DM_NHAN_SU ds_dm_nhan_su = new DS_DM_NHAN_SU();
us_dm_nhan_su.FillDataset(ds_dm_nhan_su);
var v_acsc_search = new AutoCompleteStringCollection();
foreach (var v_rows in ds_dm_nhan_su.DM_NHAN_SU)
{
v_acsc_search.Add(v_rows[DM_NHAN_SU.HO_DEM] + " - " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
v_acsc_search.Add(v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
v_acsc_search.Add(v_rows[DM_NHAN_SU.MA_NV] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
}
m_txt_tim_kiem_nhan_vien.AutoCompleteCustomSource = v_acsc_search;
}
private void chon_nhan_su()
{
string[] v_strs = m_txt_ma_ns.Text.Split('-');
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();
v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, v_strs[v_strs.Length - 1].Trim());
if (v_ds_dm_nhan_su.Tables[0].Rows.Count == 0)
{
return;
}
m_lbl_ma_nhan_vien.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["MA_NV"].ToString();
m_lbl_ho_va_ten.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["HO_DEM"] + " " +
v_ds_dm_nhan_su.Tables[0].Rows[0]["TEN"];
m_lbl_ngay_sinh.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["NGAY_SINH"].ToString().Split(' ')[0];
m_lbl_dia_chi.Text = v_ds_dm_nhan_su.Tables[0].Rows[0]["CHO_O"].ToString();
}
private void load_custom_source_2_m_txt_tim_kiem()
{
DS_DM_NHAN_SU m_ds_ns = new DS_DM_NHAN_SU();
US_DM_NHAN_SU m_us_ns = new US_DM_NHAN_SU();
m_us_ns.FillDataset(m_ds_ns);
// int count = m_ds_qua_trinh_lam_viec.Tables["V_GD_QUA_TRINH_LAM_VIEC"].Rows.Count;
AutoCompleteStringCollection v_acsc_search = new AutoCompleteStringCollection();
foreach (DataRow dr in m_ds_ns.DM_NHAN_SU)
{
v_acsc_search.Add(dr[DM_NHAN_SU.MA_NV].ToString());
v_acsc_search.Add(dr[DM_NHAN_SU.HO_DEM].ToString() + " " + dr[DM_NHAN_SU.TEN].ToString());
v_acsc_search.Add(dr[DM_NHAN_SU.TEN].ToString());
}
m_txt_tim_kiem.AutoCompleteCustomSource = v_acsc_search;
}
private void auto_suggest_text()
{
m_txt_ma_ns.AutoCompleteMode = AutoCompleteMode.Suggest;
m_txt_ma_ns.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
v_us_dm_nhan_su.FillDataset_search(v_ds_dm_nhan_su, m_txt_ma_ns.Text);
var v_rows = v_ds_dm_nhan_su.Tables[0].Rows;
for (int i = 0; i < v_rows.Count - 1; i++)
{
coll.Add(v_rows[i]["HO_DEM"] + " - " + v_rows[i]["TEN"] + " - " + v_rows[i]["MA_NV"]);
coll.Add(v_rows[i]["TEN"] + " - " + v_rows[i]["HO_DEM"] + " " + v_rows[i]["TEN"] + " - " + v_rows[i]["MA_NV"]);
}
m_txt_ma_ns.AutoCompleteCustomSource = coll;
}
private void form_2_us_nhan_vien()
{
m_us.dcID_DU_AN = m_us_du_an.dcID;
m_us.strMA_DU_AN = m_us_du_an.strMA_DU_AN;
m_us.strTEN_DU_AN = m_us_du_an.strTEN_DU_AN;
US_DM_NHAN_SU v_us_nhan_su = new US_DM_NHAN_SU();
DS_DM_NHAN_SU v_ds_nhan_su = new DS_DM_NHAN_SU();
v_us_nhan_su.FillDataset_search_by_ma_nv(v_ds_nhan_su, m_lbl_ma_nhan_vien.Text);
if (v_ds_nhan_su.DM_NHAN_SU.Rows.Count > 0)
{
m_us.dcID_NHAN_SU = (decimal)v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.ID];
m_us.strMA_NV = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString();
m_us.strHO_DEM = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.HO_DEM].ToString();
m_us.strTEN = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.TEN].ToString();
}
m_us.dcID_VI_TRI = (decimal)m_cbo_vi_tri.SelectedValue;
m_us.strVI_TRI = m_cbo_vi_tri.Text;
US_V_GD_TRANG_THAI_LAO_DONG v_us_trang_thai_ld = new US_V_GD_TRANG_THAI_LAO_DONG();
DS_V_GD_TRANG_THAI_LAO_DONG v_ds_trang_thai_ld = new DS_V_GD_TRANG_THAI_LAO_DONG();
v_us_trang_thai_ld.FillDatasetByManhanvien_trang_thai_hien_tai(v_ds_trang_thai_ld, m_lbl_ma_nhan_vien.Text, CAppContext_201.getCurrentIDPhapnhan());
if (v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows.Count > 0)
{
m_us.strTRANG_THAI_LAO_DONG = v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows[0][V_GD_TRANG_THAI_LAO_DONG.TRANG_THAI_LAO_DONG].ToString();
}
m_us.datTHOI_DIEM_TG = m_dat_tham_gia.Value;
m_us.datTHOI_DIEM_KT = m_dat_ngay_kt.Value;
m_us.dcTHOI_GIAN_TG = CIPConvert.ToDecimal(m_txt_thoi_gian_tham_gia.Text);
m_us.dcID_DANH_HIEU = (decimal)m_cbo_danh_hieu.SelectedValue;
m_us.strDANH_HIEU = m_cbo_danh_hieu.Text;
m_us.strMA_QUYET_DINH = m_txt_ma_quyet_dinh.Text;
m_us.strLOAI_QD = m_lbl_loai_quyet_dinh.Text;
m_us.strMO_TA = m_txt_mo_ta.Text;
}
private void us_object_to_form()
{
m_txt_ma_nv.Text = m_us.strMA_NV;
DS_DM_NHAN_SU m_ds_nhan_su = new DS_DM_NHAN_SU();
US_DM_NHAN_SU m_us_nhan_su = new US_DM_NHAN_SU();
m_us_nhan_su.FillDataset(m_ds_nhan_su, "WHERE MA_NV = N'" + m_txt_ma_nv.Text.ToString() + "'");
id_nhan_su = decimal.Parse(m_ds_nhan_su.DM_NHAN_SU.Rows[0][0].ToString());
m_txt_ho_ten.Text = m_us.strHO_DEM + " " + m_us.strTEN;
m_txt_ma_nv.BackColor = SystemColors.Info;
m_txt_ma_nv.ReadOnly = true;
m_txt_ho_ten.BackColor = SystemColors.Info;
m_txt_ho_ten.ReadOnly = true;
BKI_HRM.DS.DS_CM_DM_TU_DIEN v_ds_loai_quyet_dinh = new BKI_HRM.DS.DS_CM_DM_TU_DIEN();
BKI_HRM.US.US_CM_DM_TU_DIEN v_us_loai_quyet_dinh = new BKI_HRM.US.US_CM_DM_TU_DIEN();
v_us_loai_quyet_dinh.FillDataset_load_loai_quyet_dinh(v_ds_loai_quyet_dinh, "Tất cả", "N");
m_cbo_loai_quyet_dinh.DataSource = v_ds_loai_quyet_dinh.CM_DM_TU_DIEN;
m_cbo_loai_quyet_dinh.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_quyet_dinh.ValueMember = CM_DM_TU_DIEN.ID;
}
private void form_to_us_object_v_trang_thai_ld()
{
//m_us_trang_thai_ld.dcID = m_us_v_trang_thai_ld.dcID;
//m_us_trang_thai_ld.dcID_NHAN_SU = m_us_v_trang_thai_ld.dcID_NHAN_SU;
if (m_us_v_trang_thai_ld.dcID == 0)
{
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU();
v_us_dm_nhan_su.FillDataset_search_by_ma_nv(v_ds_dm_nhan_su, m_txt_ma_nv.Text);
m_us_v_trang_thai_ld.dcID_NHAN_SU = (decimal)v_ds_dm_nhan_su.Tables[0].Rows[0].ItemArray[0];
}
m_us_v_trang_thai_ld.dcID_PHAP_NHAN = CAppContext_201.getCurrentIDPhapnhan();
m_us_v_trang_thai_ld.dcID_TRANG_LAO_DONG = CIPConvert.ToDecimal(m_cbo_trang_thai_moi.SelectedValue);
if (m_txt_ma_quyet_dinh.Text.Trim() != "")
{
m_us_v_trang_thai_ld.dcID_QUYET_DINH = m_us_quyet_dinh.dcID;
}
else
{
m_us_v_trang_thai_ld.SetID_QUYET_DINHNull();
}
m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC = m_dat_ngay_co_hieu_luc.Value;
if (m_dat_ngay_het_hieu_luc.Checked)
{
m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC = m_dat_ngay_het_hieu_luc.Value;
}
else
{
m_us_v_trang_thai_ld.SetNGAY_HET_HIEU_LUCNull();
}
if (m_ckb_trang_thai_hien_tai_yn.Checked == true)
{
m_us_v_trang_thai_ld.strTRANG_THAI_HIEN_TAI = "Y";
}
else
{
m_us_v_trang_thai_ld.strTRANG_THAI_HIEN_TAI = "N";
}
}
/// <summary>
/// Tạo custom source cho autocomplete với dữ liệu từ DM_NHAN_SU
/// </summary>
/// <param name="ip_type">Loại Custom Source muốn tạo</param>
/// <returns>Custom source autocomplete của bảng DM_NHAN_SU</returns>
public static AutoCompleteStringCollection create_csac_nhan_su(Int16 ip_type = 0)
{
// Initialize
AutoCompleteStringCollection v_acsc = new AutoCompleteStringCollection();
try
{
// Fill dataset
DS_DM_NHAN_SU v_ds_dm_nhan_su = new DS_DM_NHAN_SU();
new US_DM_NHAN_SU().FillDataset(v_ds_dm_nhan_su);
// Create custom source
// Tạo thêm type mới ở đây
switch (ip_type)
{
case 0:
foreach (var v_rows in v_ds_dm_nhan_su.DM_NHAN_SU)
{
v_acsc.Add(v_rows[DM_NHAN_SU.HO_DEM] + " - " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
v_acsc.Add(v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
v_acsc.Add(v_rows[DM_NHAN_SU.MA_NV] + " - " + v_rows[DM_NHAN_SU.HO_DEM] + " " + v_rows[DM_NHAN_SU.TEN] + " - " + v_rows[DM_NHAN_SU.MA_NV]);
}
break;
default:
break;
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
return(null);
}
return(v_acsc);
}
private void kiem_tra_du_lieu()
{
if ((string)m_fg[1, 0] != "")
{
DS_DM_NHAN_SU v_ds_nhan_su_db = new DS_DM_NHAN_SU();
m_us.FillDataset(v_ds_nhan_su_db);
CellStyle red_cell = m_fg.Styles.Add("v_blank");
red_cell.BackColor = Color.Red;
CellStyle green_cell = m_fg.Styles.Add("v_duplicate");
green_cell.BackColor = Color.Green;
CellStyle default_cell = m_fg.Styles.Add("v_default");
default_cell.BackColor = Color.WhiteSmoke;
int i_ma_nv = (int)e_col_Number.MA_NV;
int i_ho_dem = (int)e_col_Number.HO_DEM;
int i_ten = (int)e_col_Number.TEN;
int i_id = (int)e_col_Number.ID;
int i_id_headcount = (int)e_col_Number.ID_HEADCOUNT;
bool is_error = false;
// Clear Style và Format lại
m_fg.Clear(ClearFlags.Style);
m_fg.Cols[0].Width = 14;
m_fg.Rows[0].Height = 35;
m_fg.Cols[i_id].Visible = false;
m_fg.Cols[i_id_headcount].Visible = false;
m_fg.Cols[(int)e_col_Number.NGAY_SINH].Format = "dd/MM/yyyy";
m_fg.Cols[(int)e_col_Number.NGAY_SINH].DataType = typeof(DateTime);
m_fg.Cols[(int)e_col_Number.NGAY_CAP_CMND].Format = "dd/MM/yyyy";
m_fg.Cols[(int)e_col_Number.NGAY_CAP_CMND].DataType = typeof(DateTime);
// Tổ đỏ nền và cho phép sửa dữ liệu dòng đó.
// Chú ý là chỉ cần đổi lại màu của các ô màu bị đổi trước đó (cụ thể là đổi các ô màu đỏ, xanh được tạo trước đó về màu trắng)
foreach (Row v_row in m_fg.Rows)
{
if (v_row.Index > 0)
{
// Kiểm tra dữ liệu trống trong các cột mã nv, họ đệm, tên
if ((string)v_row[i_ma_nv] == null)
{
m_fg.SetCellStyle(v_row.Index, i_ma_nv, red_cell);
is_error = true;
}
if ((string)v_row[i_ho_dem] == null)
{
m_fg.SetCellStyle(v_row.Index, i_ho_dem, red_cell);
is_error = true;
}
if ((string)v_row[i_ten] == null)
{
m_fg.SetCellStyle(v_row.Index, i_ten, red_cell);
is_error = true;
}
// Nếu ô hiện tại bị bôi xanh thì không cần kiểm tra trùng nữa, việc này tránh dư thừa kiểm tra.
// Kiểm tra dữ liệu trùng ở cột mã nv trên grid (file excel)
for (int index = v_row.Index + 1; index < m_fg.Rows.Count; index++)
{
Row v_cur_row = m_fg.Rows[index];
if (((string)v_row[i_ma_nv]) == ((string)v_cur_row[i_ma_nv]))
{
m_fg.SetCellStyle(v_row.Index, i_ma_nv, green_cell);
m_fg.SetCellStyle(v_cur_row.Index, i_ma_nv, green_cell);
is_error = true;
}
}
// Kiểm tra dữ liệu tồn tại trong cơ sở dữ liệu
// Nếu ô hiện tại bị bôi xanh thì không cần kiểm tra trùng nữa, việc này tránh dư thừa kiểm tra.
foreach (DataRow v_row_db in v_ds_nhan_su_db.DM_NHAN_SU.Rows)
{
if (((string)v_row[i_ma_nv]) == ((string)v_row_db[DM_NHAN_SU.MA_NV]))
{
m_fg.SetCellStyle(v_row.Index, i_ma_nv, green_cell);
is_error = true;
}
}
}
}
if (is_error)
{
m_fg.AllowEditing = true;
m_fg.Redraw = true;
throw new Exception("Có dữ liệu lỗi. Vui lòng kiểm tra lại");
}
else
{
m_fg.Redraw = true;
HelperDucVT.CUtils.show_success_message("Dữ liệu không có lỗi");
}
}
else
{
m_fg.Redraw = true;
throw new Exception("Bạn cần chọn file excel trước");
}
}
public US_DM_NHAN_SU()
{
pm_objDS = new DS_DM_NHAN_SU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
