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); } }