public DataTable Select_ChiTietTamUngLuongByMaChamCongThangNam(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietTamUngLuongDTO.MaChamCong)
};
return(base.executeNonQuerya("CHITIETTAMUNGLUONG_SelectbyMaChamCongThangNam", sqlParams));
}
public void Delete_ChiTietTamUngLuongByMaChamCong(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietTamUngLuongDTO.MaChamCong)
};
base.Procedure("NHANVIEN_deleteChiTietTamUngLuongByMaChamCong", sqlParams);
}
public void ChiTietTamUngLuong_Delete(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@IDTamUngLuong", _chiTietTamUngLuongDTO.IDTamUngLuong)
};
base.Procedure("ChiTietTamUngLuong_delete", sqlParams);
}
public DataTable ChiTietTamUngLuong_getMaChamCongAndNgayTamUng(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietTamUngLuongDTO.MaChamCong),
new SqlParameter("@NgayTamUng", _chiTietTamUngLuongDTO.NgayTamUng)
};
return(base.executeNonQuerya("ChiTietTamUngLuong_getMaChamCongAndNgayTamUng", sqlParams));
}
public void InsertChiTietTamUngLuong(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietTamUngLuongDTO.MaChamCong),
new SqlParameter("@SoTien", _chiTietTamUngLuongDTO.SoTien),
new SqlParameter("@LyDo", _chiTietTamUngLuongDTO.LyDo),
new SqlParameter("@NgayTamUng", _chiTietTamUngLuongDTO.NgayTamUng)
};
base.Procedure("CHITIETTAMUNGLUONG_add", sqlParams);
}
public void ChiTietTamUngLuong_Update(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietTamUngLuongDTO.MaChamCong),
new SqlParameter("@SoTien", _chiTietTamUngLuongDTO.SoTien),
new SqlParameter("@LyDo", _chiTietTamUngLuongDTO.LyDo),
new SqlParameter("@NgayTamUng", _chiTietTamUngLuongDTO.NgayTamUng)
};
base.Procedure("ChiTietTamUngLuong_update", sqlParams);
}
public DataTable SelectChiTietTamUngLuongByMaChamCongThangNam(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
return(this._chiTietTamUngLuongDAL.Select_ChiTietTamUngLuongByMaChamCongThangNam(_chiTietTamUngLuongDTO));
}
public DataTable loadChiTietTamUngLuongByMaChamCong(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
return(this._chiTietTamUngLuongDAL.load_ChiTietTamUngLuongByMaChamCong(_chiTietTamUngLuongDTO));
}
public void Insert_ChiTietTamUngLuong(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
this._chiTietTamUngLuongDAL.InsertChiTietTamUngLuong(_chiTietTamUngLuongDTO);
}
public void DeleteChiTietTamUngLuong(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
this._chiTietTamUngLuongDAL.Delete_ChiTietTamUngLuongByMaChamCong(_chiTietTamUngLuongDTO);
}
public void ChiTietTamUngLuongUpdate(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
this._chiTietTamUngLuongDAL.ChiTietTamUngLuong_Update(_chiTietTamUngLuongDTO);
}
public DataTable ChiTietTamUngLuongGetMaChamCongAndNgayTamUng(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
return(this._chiTietTamUngLuongDAL.ChiTietTamUngLuong_getMaChamCongAndNgayTamUng(_chiTietTamUngLuongDTO));
}
public void ChiTietTamUngLuongDelete(ChiTietTamUngLuongDTO _chiTietTamUngLuongDTO)
{
this._chiTietTamUngLuongDAL.ChiTietTamUngLuong_Delete(_chiTietTamUngLuongDTO);
}
