public virtual bool InsertDuplicate(List<KT_NHANVIEN> cus, string nam, string thang, string loaibangluong) { try { KTCTLUONGRepo _KTCTLUONGRepo = new KTCTLUONGRepo(); for (int i = 0; i < cus.Count; i++) { db.KT_UNG_LUONGs.InsertOnSubmit( new KT_UNG_LUONG { STT = cus[i].STT, TEN_NV = cus[i].TEN_NV_VIET, NAM = nam, THANG = thang, LOAI_BL = loaibangluong, MA_NV = cus[i].MA_NV, PHONG_BAN = cus[i].PHONG_BAN, TEN_PHONG_BAN = cus[i].TEN_PHONG_BAN, LUONG_CB = cus[i].LUONG_CB, TAM_UNG = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "TAM_UNG", cus[i].ID) }); db.SubmitChanges(); } return true; } catch { return false; } }
public virtual bool InsertDuplicate(List<KT_NHANVIEN> cus, string nam, string thang, string loaibangluong) { try { //Khai báo Class KTCTLUONGRepo _KTCTLUONGRepo = new KTCTLUONGRepo(); KTUNGLUONGRepo _KTUNGLUONGRepo = new KTUNGLUONGRepo(); KTCHAMCONGRepo _KTCHAMCONGRepo = new KTCHAMCONGRepo(); for (int i = 0; i < cus.Count; i++) { //Công thức tính double _tongLuong = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "TONG_LUONG", cus[i].ID); double _bhxhNLD = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHXH_NLD", cus[i].ID); double _bhxhCty = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHXH_CTY", cus[i].ID); double _bhytNLD = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHYT_NLD", cus[i].ID); double _bhytCty = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHYT_CTY", cus[i].ID); double _bhtnNLD = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHTN_NLD", cus[i].ID); double _bhtnCty = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "BHTN_CTY", cus[i].ID); double _kpCD = _KTCTLUONGRepo.CongThucTinhLuong("KT_NHANVIEN", "KP_CD", cus[i].ID); double _luongTN = _KTCTLUONGRepo.CongThucTinhLuongTN("KT_NHANVIEN", "LUONG_TN", cus[i].ID , Utils.CIntDef(thang, 0), Utils.CIntDef(nam, 0), _tongLuong, _bhxhNLD, _bhytNLD, _bhtnNLD); //===========================// db.KT_BANG_LUONGs.InsertOnSubmit( new KT_BANG_LUONG { STT = cus[i].STT, TEN_NV_VIET = cus[i].TEN_NV_VIET, NAM = nam, THANG = thang, LOAI_BL = loaibangluong, MA_NV = cus[i].MA_NV, HSO_LUONG = cus[i].HSO_LUONG, TK_LUONG = cus[i].TK_LUONG, TK_CP_LUONG = cus[i].TK_CP_LUONG, TK_KPCD = cus[i].TK_KPCD, TK_BHXH = cus[i].TK_BHXH, TK_BHYT = cus[i].TK_BHYT, TK_BHTN = cus[i].TK_BHTN, TK_TNCN = cus[i].TK_TNCN, NGAY_CONG = _KTCHAMCONGRepo.getNgayCongByMaNV(nam, thang, cus[i].MA_NV).Count > 0 ? _KTCHAMCONGRepo.getNgayCongByMaNV(nam, thang, cus[i].MA_NV)[0] : 0, NGAY_NGHI = _KTCHAMCONGRepo.getNgayCongByMaNV(nam, thang, cus[i].MA_NV).Count > 0 ? _KTCHAMCONGRepo.getNgayCongByMaNV(nam, thang, cus[i].MA_NV)[1] : 0, LUONG_CB = cus[i].LUONG_CB, PC_CHUCVU = cus[i].PC_CHUCVU, PC_TRACH_NHIEM = cus[i].PC_TRACH_NHIEM, PC_AN = cus[i].PC_AN, PC_THAM_NIEN = cus[i].PC_THAM_NIEN, TONG_LUONG = _tongLuong, BHXH_NLD = _bhxhNLD, BHXH_CTY = _bhxhCty, BHYT_NLD = _bhytNLD, BHYT_CTY = _bhytCty, BHTN_NLD = _bhtnNLD, BHTN_CTY = _bhtnCty, KP_CD = _kpCD, LUONG_TN = _unit.Round(_luongTN, -3), TEN_NV_ANH = cus[i].TEN_NV_ANH, TEN_NV_HOA = cus[i].TEN_NV_HOA, NGAY_SINH = cus[i].NGAY_SINH, GIOI_TINH = cus[i].GIOI_TINH, NOI_SINH = cus[i].NOI_SINH, QUOC_GIA = cus[i].QUOC_GIA, TINH_TP = cus[i].TINH_TP, QUAN_HUYEN = cus[i].QUAN_HUYEN, CMND = cus[i].CMND, NGAY_CAP = cus[i].NGAY_CAP, NOI_CAP = cus[i].NOI_CAP, QUE_QUAN = cus[i].QUE_QUAN, THUONG_TRU = cus[i].THUONG_TRU, TAM_TRU = cus[i].TAM_TRU, DIEN_THOAI1 = cus[i].DIEN_THOAI1, DIEN_THOAI2 = cus[i].DIEN_THOAI2, EMAIL = cus[i].EMAIL, DAN_TOC = cus[i].DAN_TOC, TON_GIAO = cus[i].TON_GIAO, QUOC_TICH = cus[i].QUOC_TICH, VAN_HOA = cus[i].VAN_HOA, CHUYEN_NGANH = cus[i].CHUYEN_NGANH, CHUC_VU = cus[i].CHUC_VU, CHUC_DANH = cus[i].CHUC_DANH, CHUC_VU_DN = cus[i].CHUC_VU_DN, PHONG_BAN = cus[i].PHONG_BAN, THUOC_TO = cus[i].THUOC_TO, NGAY_LUU = cus[i].NGAY_LUU, GHI_CHU = cus[i].GHI_CHU, TEN_PHONG_BAN = cus[i].TEN_PHONG_BAN, TAM_UNG = _KTUNGLUONGRepo.TongTienUngByMaNV(nam,thang,cus[i].MA_NV) }); db.SubmitChanges(); } return true; } catch { return false; } }