private bool check_ma_nhan_vien_is_ok(DataRow dataRow)
{
decimal v_id_nhan_vien = find_id_nhan_vien_by_ma_nv(dataRow["MA_NV"].ToString().Trim());
if (v_id_nhan_vien == -1) return false;
US_GD_LOAI_LAO_DONG v_us_gd_loai_lao_dong = new US_GD_LOAI_LAO_DONG();
DS_GD_LOAI_LAO_DONG v_ds_gd_loai_lao_dong = new DS_GD_LOAI_LAO_DONG();
v_us_gd_loai_lao_dong.FillDataset(v_ds_gd_loai_lao_dong, "where id_nhan_vien = " + v_id_nhan_vien);
if (v_ds_gd_loai_lao_dong.Tables[0].Rows.Count > 0)
return false;
else
{
return true;
}
}
//Load toan bo du lieu tu V_GD_LOAI_LAO_DONG len luoi
private void form_2_us_gd_loai_lao_dong(US_GD_LOAI_LAO_DONG ip_us)
{
if (m_sle_chon_nhan_vien.EditValue != null && m_sle_chon_nhan_vien.EditValue != "")
{
ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
}
if (m_sle_chon_loai_lao_dong.EditValue != null && m_sle_chon_loai_lao_dong.EditValue != "")
{
ip_us.dcID_LOAI_LAO_DONG = CIPConvert.ToDecimal(m_sle_chon_loai_lao_dong.EditValue);
}
if (m_dat_ngay_bat_dau.Value.Date != null || m_dat_ngay_bat_dau.Value.Date.ToString() != "")
{
ip_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau.Value.Date;
}
if (m_dat_ngay_ket_thuc.Value.Date != null || m_dat_ngay_ket_thuc.Value.Date.ToString() != "")
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.Value.Date;
}
}
private void save_data()
{
decimal ip_id_dc_nv = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
US_GD_LOAI_LAO_DONG v_us_gd_loai_lao_dong = new US_GD_LOAI_LAO_DONG(ip_id_dc_nv);
v_us_gd_loai_lao_dong.dcID_LOAI_LAO_DONG = CIPConvert.ToDecimal(m_sle_chon_loai_lao_dong.EditValue);
v_us_gd_loai_lao_dong.datNGAY_BAT_DAU = m_dat_ngay_bat_dau.Value.Date;
v_us_gd_loai_lao_dong.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.Value.Date;
v_us_gd_loai_lao_dong.BeginTransaction();
v_us_gd_loai_lao_dong.Update();
v_us_gd_loai_lao_dong.CommitTransaction();
}
private void m_cmd_update_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_v_gd_loai_lao_dong.GetDataRow(m_grv_v_gd_loai_lao_dong.FocusedRowHandle);
decimal v_id_gd_loai_lao_dong = CIPConvert.ToDecimal(v_dr[GD_LOAI_LAO_DONG.ID]);
US_GD_LOAI_LAO_DONG v_us = new US_GD_LOAI_LAO_DONG(v_id_gd_loai_lao_dong);
f371_nhan_vien_loai_lao_dong_de v_frm = new f371_nhan_vien_loai_lao_dong_de();
v_frm.DisplayForUpdate(v_us);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void m_cmd_delete_Click(object sender, EventArgs e)
{
try
{
//Lay ID cua dong du lieu muon xoa
DataRow v_dr = m_grv_v_gd_loai_lao_dong.GetDataRow(m_grv_v_gd_loai_lao_dong.FocusedRowHandle);
//Lay ID cua dong du lieu tren
decimal v_id = CIPConvert.ToDecimal(v_dr[GD_LOAI_LAO_DONG.ID]);
US_GD_LOAI_LAO_DONG v_us = new US_GD_LOAI_LAO_DONG(v_id);
if (CHRM_BaseMessages.MsgBox_Confirm(CONST_ID_MSGBOX.QUESTION_XAC_NHAN_XOA_DU_LIEU) == true)
{
v_us.Delete();
load_data_2_grid();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void gan_du_lieu_cho_us_dm_nhan_vien(DataRow dataRow)
{
US_GD_LOAI_LAO_DONG v_us = new US_GD_LOAI_LAO_DONG();
v_us.dcID_NHAN_VIEN = find_id_nhan_vien_by_ma_nv(dataRow["MA_NV"].ToString().Trim());
if (dataRow["LOAI_LAO_DONG"].ToString() == "Trực tiếp")
{
v_us.dcID_LOAI_LAO_DONG = CONST_ID_LOAI_LAO_DONG.TRUC_TIEP;
}
else if (dataRow["LOAI_LAO_DONG"].ToString() == "Gián tiếp")
{
v_us.dcID_LOAI_LAO_DONG = CONST_ID_LOAI_LAO_DONG.GIAN_TIEP;
}
if (dataRow["NGAY_BAT_DAU"].ToString() != "")
if ((dataRow["NGAY_BAT_DAU"].ToString().Substring(0, 10) != ""))
v_us.datNGAY_BAT_DAU = CIPConvert.ToDatetime(dataRow["NGAY_BAT_DAU"].ToString().Substring(0, 10));
if (dataRow["NGAY_KET_THUC"].ToString() != "")
if ((dataRow["NGAY_KET_THUC"].ToString().Substring(0, 10) != ""))
v_us.datNGAY_KET_THUC = CIPConvert.ToDatetime(dataRow["NGAY_KET_THUC"].ToString().Substring(0, 10));
v_us.strDA_XOA = "N";
v_us.Insert();
}
//Tim id_nhan_vien da co trong bang GD_LOAI_LAO_DONG
//Neu nhan vien da co loai lao dong thi khong the them duoc ma chi co the sua
private decimal find_id_gd_nv_loai_ld(decimal ip_dc_id_nv)
{
US_GD_LOAI_LAO_DONG v_us = new US_GD_LOAI_LAO_DONG();
DS_GD_LOAI_LAO_DONG v_ds = new DS_GD_LOAI_LAO_DONG();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_NHAN_VIEN = " + ip_dc_id_nv;
DataRow[] v_dr = v_ds.GD_LOAI_LAO_DONG.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return 0; // m_id_gd_loai_ld = 0 tuc la trong bang GD_LOAI_LAO_DONG chua co nhan vien nay
}
else return 1; // m_id_gd_loai_ld = 1 tuc la trong bang GD_LOAI_LAO_DONG da co nhan vien nay
}
private void save_data()
{
US_GD_LOAI_LAO_DONG v_us_gd_loai_lao_dong = new US_GD_LOAI_LAO_DONG();
form_2_us_gd_loai_lao_dong(v_us_gd_loai_lao_dong);
try
{
if (m_id_gd_loai_ld != 0)
{
MessageBox.Show("Nhân viên nãy đã tồn tại loại lao động! Nếu bạn muốn SỬA thông tin cho nhân viên vui lòng chọn nút SỬA!", "THÔNG BÁO!");
}
else
{
v_us_gd_loai_lao_dong.BeginTransaction();
v_us_gd_loai_lao_dong.Insert();
v_us_gd_loai_lao_dong.CommitTransaction();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void luu_gd_loai_lao_dong()
{
try
{
US_GD_LOAI_LAO_DONG v_us = new US_GD_LOAI_LAO_DONG();
v_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_dc_id_nhan_vien.ToString());
v_us.dcID_LOAI_LAO_DONG = CIPConvert.ToDecimal(m_sle_loai_lao_dong.EditValue);
if (m_dat_ngay_bat_dau.Checked == true)
v_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau.Value;
if (m_dat_ngay_ket_thuc.Checked == true)
v_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.Value;
switch (m_e_form_mode)
{
case DataEntryFormMode.UpdateDataState:
break;
case DataEntryFormMode.InsertDataState:
v_us.Insert();
break;
default:
break;
}
}
catch (Exception)
{
MessageBox.Show("Lỗi loại lao động!");
}
}
