private void fill_data_2_le_trang_thai_lao_dong()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where ID_LOAI_TU_DIEN = " + CONST_ID_LOAI_TU_DIEN.TRANG_THAI_LAO_DONG);
m_le_trang_thai_hien_tai.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_to_sle_nhom_ld()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 18);
m_sle_nhom_ld.Properties.DataSource = v_ds.Tables[0];
}
private decimal find_id_cach_tinh_thue(string ip_str_cach_tinh_thue)
{
try
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds);
string v_str_filter = "TEN = '" + ip_str_cach_tinh_thue + "'";
DataRow[] v_dr = v_ds.CM_DM_TU_DIEN.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return -1;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString());
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_to_combobox_khoan_tien()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 19);
m_cmb_khoan_tien.DataSource = v_ds.Tables[0];
m_cmb_khoan_tien.DisplayMember = "TEN";
m_cmb_khoan_tien.ValueMember = "ID";
}
private void load_data_to_sle_loai_chuc_vu()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds,"WHERE ID_LOAI_TU_DIEN = 21");
m_sle_loai_chuc_vu.Properties.ValueMember = CM_DM_TU_DIEN.ID;
m_sle_loai_chuc_vu.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_loai_chuc_vu.Properties.DataSource = v_ds.Tables[0];
}
private DataTable load_data_from_tu_dien(decimal id_loai_tu_dien)
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "WHERE ID_LOAI_TU_DIEN = " + id_loai_tu_dien);
return v_ds.Tables[0];
}
private decimal find_id_tu_dien_by_ma_tu_dien(string ma_tu_dien)
{
try
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds);
decimal id = (from DataRow dr in v_ds.Tables[0].Rows
where (string)dr["MA_TU_DIEN"] == ma_tu_dien
select (decimal)dr["ID"]).FirstOrDefault();
return id;
}
catch(Exception v_e)
{
throw v_e;
}
}
private void load_data_to_le_ly_do_chinh_sua()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, CONST_ID_LOAI_TU_DIEN.LY_DO_CHINH_SUA_HS_LNS);
m_le_ly_do_chinh_sua.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_cau_hinh_in()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(m_ds_cau_hinh_in, CONST_ID_LOAI_TU_DIEN.CAU_HINH_IN_HD);
}
private void load_data_to_sle_muc_lns()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 2);
m_sle_muc_lns.Properties.DataSource = v_ds.Tables[0];
m_sle_muc_lns.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_muc_lns.Properties.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_to_sle_loai_lao_dong()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 6);
m_sle_loai_lao_dong.Properties.DataSource = v_ds.Tables[0];
m_sle_loai_lao_dong.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_loai_lao_dong.Properties.ValueMember = CM_DM_TU_DIEN.ID;
//m_sle_loai_lao_dong.Properties.NullText = "---Chọn loại lao động---";
}
private void get_loai_phu_cap()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 5);
m_search_lookup_edit_loai_phu_cap.Properties.DataSource = v_ds.Tables[0];
m_search_lookup_edit_loai_phu_cap.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
//DataSet v_ds = new DataSet();
//DataTable v_dt = new DataTable();
//US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
//v_ds.Tables.Add(v_dt);
//v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM CM_DM_TU_DIEN WHERE ID_LOAI_TU_DIEN = 5");
//m_search_lookup_edit_loai_phu_cap.Properties.DataSource = v_ds.Tables[0];
//m_search_lookup_edit_loai_phu_cap.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void load_data_to_sle_loai_quy()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 16);
m_sle_loai_quy_thu_nhap.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_to_sle_cach_tinh_thue()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 13);
m_sle_cach_tinh_thue.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_to_mo_ta_cv()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, CONST_ID_LOAI_TU_DIEN.MO_TA_CONG_VIEC);
m_sle_mo_ta_cv.Properties.DataSource = v_ds.Tables[0];
m_sle_mo_ta_cv.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_mo_ta_cv.Properties.ValueMember = CM_DM_TU_DIEN.ID;
}
private string find_id_cm_dm_tu_dien_by_trinh_do_van_hoa(string ip_str_trinh_do_van_hoa)
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds);
ip_str_trinh_do_van_hoa = ip_str_trinh_do_van_hoa.Trim().ToUpper();
string v_str_filter = "MA_TU_DIEN = '" + ip_str_trinh_do_van_hoa + "'";
DataRow[] v_dr = v_ds.CM_DM_TU_DIEN.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return null;
}
else
{
return v_dr.First()["ID"].ToString();
}
}
private DataSet load_data_2_cm_dm_tu_dien(int m_id_vt)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, m_id_vt);
return v_ds;
}
private void load_data_to_sle_muc_lcd()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 4);
m_sle_muc_lcd.Properties.DataSource = v_ds.Tables[0];
m_sle_muc_lcd.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_muc_lcd.Properties.ValueMember = CM_DM_TU_DIEN.ID;
//m_sle_chuc_danh_lns.EditValue = null;
//m_sle_muc_lcd.Properties.NullText = "--Chọn mức--";
}
private void load_data_2_sle_chon_loai_trang_thai_lao_dong()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "WHERE ID_LOAI_TU_DIEN = 17");
m_sle_chon_loai_trang_thai_lao_dong.Properties.DataSource = v_ds.Tables[0];
m_sle_chon_loai_trang_thai_lao_dong.Properties.ValueMember = CM_DM_TU_DIEN.ID;
m_sle_chon_loai_trang_thai_lao_dong.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_chon_loai_trang_thai_lao_dong.Properties.PopulateViewColumns();
m_sle_chon_loai_trang_thai_lao_dong.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
m_sle_chon_loai_trang_thai_lao_dong.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit;
}
private DS_CM_DM_TU_DIEN load_data_2_cm_dm_tu_dien(int m_id_lns_lcd_trong_loai_td)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, m_id_lns_lcd_trong_loai_td);
return v_ds;
}
private void fill_datasource_loai_lao_dong()
{
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, 6);
//US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
//DataSet v_ds = new DataSet();
//DataTable v_dt = new DataTable();
//v_ds.Tables.Add(v_dt);
//v_us.FillDatasetWithQuery(v_ds, "select ID,TEN FROM CM_DM_TU_DIEN WHERE ID_LOAI_TU_DIEN=6");
m_sle_loai_lao_dong.Properties.DataSource = v_ds.Tables[0];
m_sle_loai_lao_dong.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
