partial void DeleteKT_BANG_LUONG(KT_BANG_LUONG instance);
partial void UpdateKT_BANG_LUONG(KT_BANG_LUONG instance);
partial void InsertKT_BANG_LUONG(KT_BANG_LUONG instance);
private void Get_Data(KT_BANG_LUONG obj, int position)
{
try
{
obj.TEN_NV_VIET = Utils.CStrDef(gridView1.GetRowCellValue(position, "TEN_NV_VIET"), "");
obj.NAM = Utils.CStrDef(gridView1.GetRowCellValue(position, "NAM"), "");
obj.THANG = Utils.CStrDef(gridView1.GetRowCellValue(position, "THANG"), "");
obj.LOAI_BL = Utils.CStrDef(gridView1.GetRowCellValue(position, "LOAI_BL"), "");
obj.MA_NV = Utils.CStrDef(gridView1.GetRowCellValue(position, "MA_NV"), "");
obj.HSO_LUONG = Utils.CDblDef(gridView1.GetRowCellValue(position, "HSO_LUONG"), 0);
obj.TK_LUONG = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_LUONG"), "");
obj.TK_CP_LUONG = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_CP_LUONG"), "");
obj.TK_KPCD = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_KPCD"), "");
obj.TK_BHXH = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_BHXH"), "");
obj.TK_BHYT = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_BHYT"), "");
obj.TK_BHTN = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_BHTN"), "");
obj.TK_TNCN = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_TNCN"), "");
obj.TK_TAMUNG = Utils.CStrDef(gridView1.GetRowCellValue(position, "TK_TAMUNG"), "");
obj.NGAY_CONG = Utils.CDblDef(gridView1.GetRowCellValue(position, "NGAY_CONG"), 0);
obj.NGAY_NGHI = Utils.CDblDef(gridView1.GetRowCellValue(position, "NGAY_NGHI"), 0);
obj.LUONG_CB = Utils.CDblDef(gridView1.GetRowCellValue(position, "LUONG_CB"), 0);
obj.TAM_UNG = Utils.CDblDef(gridView1.GetRowCellValue(position, "TAM_UNG"), 0);
obj.PC_CHUCVU = Utils.CDblDef(gridView1.GetRowCellValue(position, "PC_CHUCVU"), 0);
obj.PC_TRACH_NHIEM = Utils.CDblDef(gridView1.GetRowCellValue(position, "PC_TRACH_NHIEM"), 0);
obj.PC_AN = Utils.CDblDef(gridView1.GetRowCellValue(position, "PC_AN"), 0);
obj.PC_THAM_NIEN = Utils.CDblDef(gridView1.GetRowCellValue(position, "PC_THAM_NIEN"), 0);
obj.TONG_LUONG = Utils.CDblDef(gridView1.GetRowCellValue(position, "TONG_LUONG"), 0);
obj.BHXH_NLD = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHXH_NLD"), 0);
obj.BHXH_CTY = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHXH_CTY"), 0);
obj.BHYT_NLD = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHYT_NLD"), 0);
obj.BHYT_CTY = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHYT_CTY"), 0);
obj.BHTN_NLD = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHTN_NLD"), 0);
obj.BHTN_CTY = Utils.CDblDef(gridView1.GetRowCellValue(position, "BHTN_CTY"), 0);
obj.KP_CD = Utils.CDblDef(gridView1.GetRowCellValue(position, "KP_CD"), 0);
obj.LUONG_TN = Utils.CDblDef(gridView1.GetRowCellValue(position, "LUONG_TN"), 0);
obj.NGAY_SINH = gridView1.GetRowCellValue(position, "NGAY_SINH") != null
? Utils.CDateDef(gridView1.GetRowCellValue(position, "NGAY_SINH"), DateTime.Now) : obj.NGAY_SINH = null;
obj.GIOI_TINH = Utils.CStrDef(gridView1.GetRowCellValue(position, "GIOI_TINH"), "");
obj.NOI_SINH = Utils.CStrDef(gridView1.GetRowCellValue(position, "NOI_SINH"), "");
obj.QUOC_GIA = Utils.CStrDef(gridView1.GetRowCellValue(position, "QUOC_GIA"), "");
obj.TINH_TP = Utils.CStrDef(gridView1.GetRowCellValue(position, "TINH_TP"), "");
obj.QUAN_HUYEN = Utils.CStrDef(gridView1.GetRowCellValue(position, "QUAN_HUYEN"), "");
obj.CMND = Utils.CStrDef(gridView1.GetRowCellValue(position, "CMND"), "");
obj.NGAY_CAP = gridView1.GetRowCellValue(position, "NGAY_CAP") != null
? Utils.CDateDef(gridView1.GetRowCellValue(position, "NGAY_CAP"), DateTime.Now) : obj.NGAY_CAP = null;
obj.NOI_CAP = Utils.CStrDef(gridView1.GetRowCellValue(position, "NOI_CAP"), "");
obj.QUE_QUAN = Utils.CStrDef(gridView1.GetRowCellValue(position, "QUE_QUAN"), "");
obj.THUONG_TRU = Utils.CStrDef(gridView1.GetRowCellValue(position, "THUONG_TRU"), "");
obj.TAM_TRU = Utils.CStrDef(gridView1.GetRowCellValue(position, "TAM_TRU"), "");
obj.DIEN_THOAI1 = Utils.CStrDef(gridView1.GetRowCellValue(position, "DIEN_THOAI1"), "");
obj.DIEN_THOAI2 = Utils.CStrDef(gridView1.GetRowCellValue(position, "DIEN_THOAI2"), "");
obj.EMAIL = Utils.CStrDef(gridView1.GetRowCellValue(position, "EMAIL"), "");
obj.DAN_TOC = Utils.CStrDef(gridView1.GetRowCellValue(position, "DAN_TOC"), "");
obj.TON_GIAO = Utils.CStrDef(gridView1.GetRowCellValue(position, "TON_GIAO"), "");
obj.QUOC_TICH = Utils.CStrDef(gridView1.GetRowCellValue(position, "QUOC_TICH"), "");
obj.VAN_HOA = Utils.CStrDef(gridView1.GetRowCellValue(position, "VAN_HOA"), "");
obj.CHUYEN_NGANH = Utils.CStrDef(gridView1.GetRowCellValue(position, "CHUYEN_NGANH"), "");
obj.CHUC_VU = Utils.CStrDef(gridView1.GetRowCellValue(position, "CHUC_VU"), "");
obj.CHUC_DANH = Utils.CStrDef(gridView1.GetRowCellValue(position, "CHUC_DANH"), "");
obj.CHUC_VU_DN = Utils.CStrDef(gridView1.GetRowCellValue(position, "CHUC_VU_DN"), "");
obj.PHONG_BAN = Utils.CStrDef(gridView1.GetRowCellValue(position, "PHONG_BAN"), "");
obj.TEN_PHONG_BAN = Utils.CStrDef(gridView1.GetRowCellValue(position, "TEN_PHONG_BAN"), "");
obj.THUOC_TO = Utils.CStrDef(gridView1.GetRowCellValue(position, "THUOC_TO"), "");
obj.NGAY_LUU = gridView1.GetRowCellValue(position, "NGAY_LUU") != null
? Utils.CDateDef(gridView1.GetRowCellValue(position, "NGAY_LUU"), DateTime.Now) : obj.NGAY_LUU = null;
obj.GHI_CHU = Utils.CStrDef(gridView1.GetRowCellValue(position, "GHI_CHU"), "");
obj.TRANG_THAI = Utils.CIntDef(gridView1.GetRowCellValue(position, "TRANG_THAI"), 0);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridView1_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
{
try
{
GridView view = sender as GridView;
_KTBANGLUONGRepo = new KTBANGLUONGRepo();
//Kiểm tra đây là dòng dữ liệu mới hay cũ, nếu là mới thì mình insert
if (view.IsNewItemRow(e.RowHandle))
{
//e.RowHandle trả về giá trị int là thứ tự của dòng hiện tại
KT_BANG_LUONG obj = new KT_BANG_LUONG();
Get_Data(obj, e.RowHandle);
_KTBANGLUONGRepo.Create(obj);
}
//Cũ thì update
else
{
int id = Utils.CIntDef(gridView1.GetRowCellValue(e.RowHandle, "ID").ToString(), 0);
KT_BANG_LUONG obj = _KTBANGLUONGRepo.GetById(id);
if (obj != null)
{
Get_Data(obj, e.RowHandle);
_KTBANGLUONGRepo.Update(obj);
}
}
Load_Data();
}
catch (Exception ex)
{
e.Valid = false;
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Save_Duplicate()
{
try
{
if (MessageBox.Show("Bạn có muốn copy dòng này thành dòng mới?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
_KTBANGLUONGRepo = new KTBANGLUONGRepo();
KT_BANG_LUONG obj = new KT_BANG_LUONG();
Get_Data(obj, gridView1.FocusedRowHandle);
_KTBANGLUONGRepo.Create(obj);
MessageBox.Show("Đã copy dòng này vào cuối bảng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
