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