private void fill_data_2_grid()
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
DS_GD_TRANG_THAI_LAO_DONG v_ds = new DS_GD_TRANG_THAI_LAO_DONG();
// v_us.fill_data_lich_su_lao_dong(v_ds, (decimal)m_sle_chon_nhan_vien.EditValue);
m_grc_lich_su_lao_dong.DataSource = v_ds.Tables[0];
m_grc_lich_su_lao_dong.RefreshDataSource();
}
public void display_4_update(US_GD_TRANG_THAI_LAO_DONG ip_us)
{
this.Text = "F357 - SỬA trạng thái lao động";
m_e_form_mode = DataEntryFormMode.UpdateDataState;
m_sle_chon_nhan_vien.EditValue = ip_us.dcID_NHAN_VIEN;
m_sle_chon_nhan_vien.Enabled = false;
m_id_gd_trang_thai_lao_dong_4_update = ip_us.dcID;
m_sle_chon_trang_thai_lao_dong.EditValue = ip_us.dcID_TRANG_THAI_LAO_DONG;
m_dat_ngay_ap_dung.EditValue = ip_us.datNGAY_AP_DUNG;
if (ip_us.datNGAY_KET_THUC != new DateTime(1900,1,1))
{
m_dat_ngay_ket_thuc.EditValue = ip_us.datNGAY_KET_THUC;
}
m_txt_ghi_chu.Text = ip_us.strGHI_CHU;
this.CenterToScreen();
this.ShowDialog();
}
private DataTable get_trang_thai_lao_dong_ket_thuc()
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
DataSet v_ds = v_us.LayDanhSachKetThucTTLDTrongThang();
return v_ds.Tables[0];
}
private void form_2_us_gd_trang_thai_lao_dong(US_GD_TRANG_THAI_LAO_DONG ip_us)
{
ip_us.dcID_NHAN_VIEN = decimal.Parse(m_sle_chon_nhan_vien.EditValue.ToString());
ip_us.dcID_TRANG_THAI_LAO_DONG = CONST_ID_TRANG_THAI_LAO_DONG.DANG_LAM_VIEC;
ip_us.datNGAY_AP_DUNG = m_dat_ngay_bat_dau.Value.Date;
ip_us.datNGAY_LAP = DateTime.Now.Date;
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
ip_us.strDA_XOA = "N";
}
private decimal find_id_trang_thai_lao_dong_da_co(decimal ip_dc_id_nhan_vien)
{
try
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
DS_GD_TRANG_THAI_LAO_DONG v_ds = new DS_GD_TRANG_THAI_LAO_DONG();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_NHAN_VIEN = " + ip_dc_id_nhan_vien + " AND DA_XOA = 'N'";
DataRow[] v_dr = v_ds.GD_TRANG_THAI_LAO_DONG.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 save_data()
{
US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD();
US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO();
US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong = new US_GD_TRANG_THAI_LAO_DONG();
US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG();
form_2_us_gd_hop_dong(v_us_gd_hd);
US_GD_HOP_DONG v_us = new US_GD_HOP_DONG();
switch (m_e_form_mode)
{
case DataEntryFormMode.UpdateDataState:
v_us_gd_hd.BeginTransaction();
v_us_gd_hd.dcID = CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID"));
v_us_gd_hd.Update();
v_us_gd_hd.CommitTransaction();
//
form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
v_us_gd_hs_lns_lcd.BeginTransaction();
v_us_gd_hs_lns_lcd.dcID = find_id_gd_lns_lcd(CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID")));
v_us_gd_hs_lns_lcd.Update();
v_us_gd_hs_lns_lcd.CommitTransaction();
break;
case DataEntryFormMode.InsertDataState:
v_us.lap_hop_dong_moi_cho_nhan_vien(CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue)
, CIPConvert.ToDecimal(m_sle_loai_hop_dong.EditValue)
, m_txt_ma_hd.Text.Trim()
, m_dat_ngay_bat_dau.Value.Date
, m_dat_ngay_ket_thuc.Value.Date
, m_dat_ngay_ky.Value.Date
, DateTime.Now.Date
, CAppContext_201.getCurrentUserName()
, "N"
, CIPConvert.ToDecimal(m_sle_chuc_danh_lcd.EditValue)
, CIPConvert.ToDecimal(m_sle_muc_lcd.EditValue)
, CIPConvert.ToDecimal(m_sle_chuc_danh_lns.EditValue)
, CIPConvert.ToDecimal(m_sle_muc_lns.EditValue)
, ref op_str_mess);
break;
case DataEntryFormMode.ViewDataState:
break;
case DataEntryFormMode.SelectDataState:
break;
default:
break;
}
//US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD();
//US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
//US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO();
//US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong = new US_GD_TRANG_THAI_LAO_DONG();
//US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG();
//form_2_us_gd_hop_dong(v_us_gd_hd);
//try
//{
// switch (m_e_form_mode)
// {
// case DataEntryFormMode.InsertDataState:
// if (m_id_gd_hd != -1)
// {
// cho_hop_dong_da_co_ve_trang_thai_delete_Y();
// cho_gd_hs_lns_lcd_da_xoa_Y();
// cho_gd_hs_lns_da_xoa_Y();
// cho_gd_lcd_da_xoa_Y();
// }
// //lap hop dong moi
// v_us_gd_hd.BeginTransaction();
// v_us_gd_hd.Insert();
// v_us_gd_hd.CommitTransaction();
// //insert gd_hs_lns_lcd
// form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
// v_us_gd_hs_lns_lcd.BeginTransaction();
// v_us_gd_hs_lns_lcd.Insert();
// v_us_gd_hs_lns_lcd.CommitTransaction();
// //insert gd_hs_lns
// form_2_us_gd_hs_lns(v_us_gd_hs_lns);
// v_us_gd_hs_lns.BeginTransaction();
// v_us_gd_hs_lns.Insert();
// v_us_gd_hs_lns.CommitTransaction();
// //insert gd_lcd
// form_2_us_gd_lcd(v_us_gd_lcd);
// v_us_gd_lcd.BeginTransaction();
// v_us_gd_lcd.Insert();
// v_us_gd_lcd.CommitTransaction();
// //insert gd_trang_thai_ld
// decimal v_id_gd_trang_thai_lao_dong_da_co = 0;
// v_id_gd_trang_thai_lao_dong_da_co = find_id_trang_thai_lao_dong_da_co(decimal.Parse(m_sle_chon_nhan_vien.EditValue.ToString())); //sai o day
// if (v_id_gd_trang_thai_lao_dong_da_co == -1)
// {
// form_2_us_gd_trang_thai_lao_dong(v_us_gd_trang_thai_lao_dong);
// v_us_gd_trang_thai_lao_dong.BeginTransaction();
// v_us_gd_trang_thai_lao_dong.Insert();
// v_us_gd_trang_thai_lao_dong.CommitTransaction();
// }
// break;
// case DataEntryFormMode.UpdateDataState:
// v_us_gd_hd.BeginTransaction();
// v_us_gd_hd.dcID = CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID"));
// v_us_gd_hd.Update();
// v_us_gd_hd.CommitTransaction();
// //
// form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
// v_us_gd_hs_lns_lcd.BeginTransaction();
// v_us_gd_hs_lns_lcd.dcID = find_id_gd_lns_lcd(CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID")));
// v_us_gd_hs_lns_lcd.Update();
// v_us_gd_hs_lns_lcd.CommitTransaction();
// break;
// default:
// break;
// }
//}
//catch (Exception v_e)
//{
// throw v_e;
//}
}
private void select_trang_thai_by_nhan_vien(decimal ip_id_nhan_vien)
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
// var id_trang_thai_ld = v_us.get_id_trang_thai_lao_dong(ip_id_nhan_vien);
//m_le_trang_thai_hien_tai.EditValue = id_trang_thai_ld;
}
private void save_data()
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
//v_us.thay_doi_trang_thai_lao_dong((decimal)m_sle_chon_nhan_vien.EditValue, (decimal)m_le_trang_thai_hien_tai.EditValue, DateTime.Now, CAppContext_201.getCurrentUserName());
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
fill_data_2_grid();
labelControlNhacNho.Text = "";
}
void m_le_trang_thai_hien_tai_EditValueChanged(object sender, EventArgs e)
{
try
{
if (m_sle_chon_nhan_vien.EditValue == null)
{
return;
}
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
//var id_trang_thai_ld = v_us.get_id_trang_thai_lao_dong((decimal)m_sle_chon_nhan_vien.EditValue);
var id_trang_thai_ld = 0;
if (id_trang_thai_ld != (decimal)m_le_trang_thai_hien_tai.EditValue)
{
m_cmd_save.Enabled = true;
panelControlSave.Enabled = true;
labelControlNhacNho.Text = "Bạn vừa thay đổi trạng thái LĐ. Nhấn Lưu để cập nhật!";
}
else
{
m_cmd_save.Enabled = false;
panelControlSave.Enabled = false;
labelControlNhacNho.Text = "...";
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
void m_cmd_save_Click(object sender, EventArgs e)
{
try
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
if (m_cmd_save.Enabled == false)
{
return;
}
save_data();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
void m_cmd_update_Click(object sender, EventArgs e)
{
try
{
if (m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.FocusedRowHandle < 0)
{
return;
}
decimal v_id_gd_trang_thai_lao_dong = (decimal)m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.
GetRowCellValue(m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.FocusedRowHandle, "ID");
if (v_id_gd_trang_thai_lao_dong > 0)
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG(v_id_gd_trang_thai_lao_dong);
f357_bao_cao_trang_thai_lao_dong_nhan_vien_de v_frm = new f357_bao_cao_trang_thai_lao_dong_nhan_vien_de();
v_frm.display_4_update(v_us);
m_sle_chon_trang_thai_lao_dong.EditValue = null;
load_data_2_grid();
focus_new_row_created(v_id_gd_trang_thai_lao_dong);
}
else
{
CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_CHUA_CO_DU_LIEU_DE_THUC_HIEN_THAO_TAC);
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
void m_cmd_delete_Click(object sender, EventArgs e)
{
try
{
if (m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.FocusedRowHandle < 0)
{
return;
}
if (CHRM_BaseMessages.MsgBox_Confirm(CONST_ID_MSGBOX.QUESTION_XAC_NHAN_XOA_DU_LIEU) == true)
{
DataRow v_dr = m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.GetDataRow(m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.FocusedRowHandle);
decimal v_id_gd_trang_thai_lao_dong = CIPConvert.ToDecimal(v_dr["ID"]);
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG(v_id_gd_trang_thai_lao_dong);
v_us.Delete();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
load_data_2_grid();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
//private void load_data_2_sle_trang_thai_ld()
//{
// US_DM_TRANG_THAI_LD v_us = new US_DM_TRANG_THAI_LD();
// DS_DM_TRANG_THAI_LD v_ds = new DS_DM_TRANG_THAI_LD();
// v_us.FillDataset(v_ds);
// m_sle_chon_trang_thai_lao_dong.Properties.DataSource = v_ds.Tables[0];
// m_sle_chon_trang_thai_lao_dong.Properties.DisplayMember = "TEN_TRANG_THAI_LD";
// m_sle_chon_trang_thai_lao_dong.Properties.ValueMember = "ID";
//}
private void load_data_2_grid()
{
CHRMCommon.make_stt(m_grv_bao_cao_trang_thai_lao_dong_nhan_vien);
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetTTLD(v_ds);
m_grc_bao_cao_trang_thai_lao_dong_nhan_vien.DataSource = v_ds.Tables[0];
m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.BestFitColumns();
m_grv_bao_cao_trang_thai_lao_dong_nhan_vien.ExpandAllGroups();
}
private void save_data()
{
US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong = new US_GD_TRANG_THAI_LAO_DONG();
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
//cho_trang_thai_lao_dong_cu_cua_nhan_vien_da_xoa_Y((decimal)m_sle_chon_nhan_vien.EditValue);
form_2_us_obj(v_us_gd_trang_thai_lao_dong);
v_us_gd_trang_thai_lao_dong.BeginTransaction();
v_us_gd_trang_thai_lao_dong.Insert();
v_us_gd_trang_thai_lao_dong.CommitTransaction();
m_id_gd_trang_thai_lao_dong_moi_tao = v_us_gd_trang_thai_lao_dong.dcID;
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
this.Close();
break;
case DataEntryFormMode.UpdateDataState:
v_us_gd_trang_thai_lao_dong.dcID = m_id_gd_trang_thai_lao_dong_4_update;
form_2_us_obj(v_us_gd_trang_thai_lao_dong);
v_us_gd_trang_thai_lao_dong.BeginTransaction();
v_us_gd_trang_thai_lao_dong.Update();
v_us_gd_trang_thai_lao_dong.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
this.Close();
break;
default:
break;
}
}
catch (Exception v_e)
{
v_us_gd_trang_thai_lao_dong.Rollback();
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void form_2_us_obj(US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong)
{
v_us_gd_trang_thai_lao_dong.dcID_NHAN_VIEN = (decimal)m_sle_chon_nhan_vien.EditValue;
v_us_gd_trang_thai_lao_dong.dcID_TRANG_THAI_LAO_DONG = (decimal)m_sle_chon_trang_thai_lao_dong.EditValue;
v_us_gd_trang_thai_lao_dong.datNGAY_AP_DUNG = m_dat_ngay_ap_dung.DateTime.Date;
if (m_dat_ngay_ket_thuc.DateTime != DateTime.MinValue)
{
v_us_gd_trang_thai_lao_dong.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.DateTime.Date;
}
if (m_e_form_mode == DataEntryFormMode.InsertDataState)
{
v_us_gd_trang_thai_lao_dong.datNGAY_LAP = DateTime.Now.Date;
v_us_gd_trang_thai_lao_dong.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
else
{
v_us_gd_trang_thai_lao_dong.datNGAY_SUA = DateTime.Now.Date;
v_us_gd_trang_thai_lao_dong.strNGUOI_SUA = CAppContext_201.getCurrentUserName();
}
v_us_gd_trang_thai_lao_dong.strGHI_CHU = m_txt_ghi_chu.Text;
v_us_gd_trang_thai_lao_dong.strDA_XOA = "N";
}
private void cho_trang_thai_lao_dong_cu_cua_nhan_vien_da_xoa_Y(decimal ip_dc_id_nv)
{
try
{
decimal v_id_gd_trang_thai_lao_dong_hien_tai = 0;
v_id_gd_trang_thai_lao_dong_hien_tai = find_id_gd_trang_thai_lao_dong_hien_tai(ip_dc_id_nv);
if (v_id_gd_trang_thai_lao_dong_hien_tai == -1)
{
return;
}
else
{
US_GD_TRANG_THAI_LAO_DONG v_us = new US_GD_TRANG_THAI_LAO_DONG(v_id_gd_trang_thai_lao_dong_hien_tai);
v_us.datNGAY_KET_THUC = m_dat_ngay_ap_dung.DateTime.AddDays(-1);
v_us.strDA_XOA = "Y";
v_us.BeginTransaction();
v_us.Update();
v_us.CommitTransaction();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
