public DataTable Select_ChiTietPhuCapNhanVienByMaChamCongThangNam(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaChamCong", _chiTietPhuCapNhanVienDTO.MaChamCong) }; return(base.executeNonQuerya("CHITIETPHUCAPNHANVIEN_SelectbyMaChamCongThangNam", sqlParams)); }
public void Delete_ChiTietPhuCapByMaChamCong(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@IDChiTietPhuCap", _chiTietPhuCapNhanVienDTO.IDChiTietPhuCap) }; base.Procedure("NHANVIEN_deleteChiTietPhuCapByMaChamCong", sqlParams); }
public DataTable ChiTietPhuCapNhanVien_getByMaChamCongAndNgayAndKyHieuPhuCap(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaChamCong", _chiTietPhuCapNhanVienDTO.MaChamCong), new SqlParameter("@Ngay", _chiTietPhuCapNhanVienDTO.Ngay), new SqlParameter("@KyHieuPhuCap", _chiTietPhuCapNhanVienDTO.KyHieuPhuCap) }; return(base.executeNonQuerya("ChiTietPhuCapNhanVien_getByMaChamCongAndNgayAndKyHieuPhuCap", sqlParams)); }
public void InsertChiTietPhuCapNhanVien(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { List <SqlParameter> sqlParams = new List <SqlParameter> { new SqlParameter("@MaChamCong", _chiTietPhuCapNhanVienDTO.MaChamCong), new SqlParameter("@MaPhuCap", _chiTietPhuCapNhanVienDTO.MaPhuCap), new SqlParameter("@TenPhuCap", _chiTietPhuCapNhanVienDTO.TenPhuCap), new SqlParameter("@SoTien", _chiTietPhuCapNhanVienDTO.SoTien), new SqlParameter("@Ngay", _chiTietPhuCapNhanVienDTO.Ngay), new SqlParameter("@KyHieuPhuCap", _chiTietPhuCapNhanVienDTO.KyHieuPhuCap) }; base.Procedure("CHITIETPHUCAPNHANVIEN_add", sqlParams); }
public DataTable SelectChiTietPhuCapNhanVienByMaChamCongThangNam(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { return(this._chiTietPhuCapNhanVienDAL.Select_ChiTietPhuCapNhanVienByMaChamCongThangNam(_chiTietPhuCapNhanVienDTO)); }
public DataTable loadChiTietPhuCapByMaChamCong(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { return(this._chiTietPhuCapNhanVienDAL.load_ChiTietPhuCapbyMaChamCong(_chiTietPhuCapNhanVienDTO)); }
public void Insert_ChiTietPhuCapNhanVien(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { this._chiTietPhuCapNhanVienDAL.InsertChiTietPhuCapNhanVien(_chiTietPhuCapNhanVienDTO); }
public void DeleteChiTietPhuCapNhanVien(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { this._chiTietPhuCapNhanVienDAL.Delete_ChiTietPhuCapByMaChamCong(_chiTietPhuCapNhanVienDTO); }
public DataTable ChiTietPhuCapNhanVienGetByMaChamCongAndNgayAndKyHieuPhuCap(ChiTietPhuCapNhanVienDTO _chiTietPhuCapNhanVienDTO) { return(this._chiTietPhuCapNhanVienDAL.ChiTietPhuCapNhanVien_getByMaChamCongAndNgayAndKyHieuPhuCap(_chiTietPhuCapNhanVienDTO)); }