public virtual void Remove(LUONG_DANHSACH b) { try { db.LUONG_DANHSACHes.DeleteOnSubmit(b); db.SubmitChanges(); } catch (Exception e) { throw new Exception(e.Message); } }
public virtual void Remove(int id) { try { LUONG_DANHSACH b = this.GetById(id); this.Remove(b); } catch (Exception e) { throw new Exception(e.Message); } }
public virtual void Create(LUONG_DANHSACH cus) { try { this.db.LUONG_DANHSACHes.InsertOnSubmit(cus); db.SubmitChanges(); } catch //(Exception e) { //throw new Exception(e.Message); } }
public virtual void Update(LUONG_DANHSACH cus) { try { LUONG_DANHSACH cusOld = this.GetById(cus.ID); cusOld = cus; db.SubmitChanges(); } catch //(Exception e) { //throw new Exception(e.Message); } }
private void Save_Data(int _year, int _month, int _phongban) { _DoanhThuSPData.RemoveByPhongBan(_year, _month, _phongban); //Xóa doanh thu có phòng ban đã chọn _BangLuongData.RemoveByYearMonth(_year, _month, _phongban); //Xóa bảng lương có phòng ban đã chọn var list = _UserRepo.GetByGroupBangLuong(_phongban); foreach (var u in list) { LUONG_DANHSACH i = new LUONG_DANHSACH(); //Lưu doanh thu trước if (Utils.CIntDef(u.GROUP_ID, 0) == 3 || Utils.CIntDef(u.GROUP_ID, 0) == 9 || Utils.CIntDef(u.GROUP_ID, 0) == 14) { Save_DoanhThuSp(Utils.CIntDef(u.GROUP_ID, 0), Utils.CIntDef(u.USER_ID, 0) , u.USER_UN, _year, _month, Utils.CIntDef(txtTyLeLuongSP.Text)); } i.BL_MANV = u.USER_UN; i.BL_TENNV = u.USER_NAME; i.BL_THANG = month; i.BL_NAM = year; i.BL_LUONG_CB = u.USER_LUONG_CB; i.BL_DT_SPDV = getDanhThuAll(_year, _month, u.USER_UN); i.BL_LUONG_SP = getLuongSPAll(_year, _month, u.USER_UN); i.BL_LUONG_DA_TV = getDatvAll(_year, _month, u.USER_UN); i.BL_PC_THUONG = null; i.BL_PC_KHAC = null; i.BL_BHXH = u.USER_BHXH; i.BL_BHYT = u.USER_BHYT; i.BL_BHTN = u.USER_BHTN; i.BL_KHAUTRU_KHAC = null; i.BL_THUNHAP_TRUOCTHUE = null; i.BL_TAMUNG = null; i.BL_LUONG_THUCNHAN = null; i.BL_PHONGBAN = u.GROUP_ID; _BangLuongData.Create(i); } }
private void Save_Data(int _year, int _month, int _phongban) { _DoanhThuSPData.RemoveByPhongBan(_year, _month, _phongban);//Xóa doanh thu có phòng ban đã chọn _BangLuongData.RemoveByYearMonth(_year, _month, _phongban);//Xóa bảng lương có phòng ban đã chọn var list = _UserRepo.GetByGroupBangLuong(_phongban); foreach(var u in list) { LUONG_DANHSACH i = new LUONG_DANHSACH(); //Lưu doanh thu trước if (Utils.CIntDef(u.GROUP_ID, 0) == 3 || Utils.CIntDef(u.GROUP_ID, 0) == 9 || Utils.CIntDef(u.GROUP_ID, 0) == 14) { Save_DoanhThuSp(Utils.CIntDef(u.GROUP_ID, 0), Utils.CIntDef(u.USER_ID, 0) , u.USER_UN, _year, _month, Utils.CIntDef(txtTyLeLuongSP.Text)); } i.BL_MANV = u.USER_UN; i.BL_TENNV = u.USER_NAME; i.BL_THANG = month; i.BL_NAM = year; i.BL_LUONG_CB = u.USER_LUONG_CB; i.BL_DT_SPDV = getDanhThuAll(_year, _month, u.USER_UN); i.BL_LUONG_SP = getLuongSPAll(_year, _month, u.USER_UN); i.BL_LUONG_DA_TV = getDatvAll(_year, _month, u.USER_UN); i.BL_PC_THUONG = null; i.BL_PC_KHAC = null; i.BL_BHXH = u.USER_BHXH; i.BL_BHYT = u.USER_BHYT; i.BL_BHTN = u.USER_BHTN; i.BL_KHAUTRU_KHAC = null; i.BL_THUNHAP_TRUOCTHUE = null; i.BL_TAMUNG = null; i.BL_LUONG_THUCNHAN = null; i.BL_PHONGBAN = u.GROUP_ID; _BangLuongData.Create(i); } }