public void ViPham_DeleteByMaChamCong(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _viPhamDTO.MaChamCong)
};
base.Procedure("ViPham_DeleteByMaChamCong", sqlParams);
}
public void ViPham_Delete(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@IDViPham", _viPhamDTO.IDViPham)
};
base.Procedure("ViPham_Delete", sqlParams);
}
public DataTable load_ViPhamByMaChamCong(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _viPhamDTO.MaChamCong)
};
return(base.executeNonQuerya("ViPham_SelectbyMaChamCong", sqlParams));
}
public DataTable ViPham_getMaChamCongAndNgayThang(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _viPhamDTO.MaChamCong),
new SqlParameter("@NgayThang", _viPhamDTO.NgayThang)
};
return(base.executeNonQuerya("ViPham_getMaChamCongAndNgayThang", sqlParams));
}
public DataTable Select_ViPhamByMaChamCongThangNam(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _viPhamDTO.MaChamCong),
new SqlParameter("@Thang", _viPhamDTO.Thang),
new SqlParameter("@Nam", _viPhamDTO.Nam)
};
return(base.executeNonQuerya("ViPham_SelectbyMaChamCongThangNam", sqlParams));
}
public void Insert_ViPham(ViPhamDTO _viPhamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _viPhamDTO.MaChamCong),
new SqlParameter("@ViPham", _viPhamDTO.ViPham),
new SqlParameter("@TienPhat", _viPhamDTO.TienPhat),
new SqlParameter("@NgayThang", _viPhamDTO.NgayThang)
};
base.Procedure("ViPham_add", sqlParams);
}
public DataTable ViPhamGetMaChamCongAndNgayThang(ViPhamDTO _viPhamDTO)
{
return(this._viPhamDAL.ViPham_getMaChamCongAndNgayThang(_viPhamDTO));
}
public void ViPhamDeleteByMaChamCong(ViPhamDTO _viPhamDTO)
{
this._viPhamDAL.ViPham_DeleteByMaChamCong(_viPhamDTO);
}
public void ViPhamDelete(ViPhamDTO _viPhamDTO)
{
this._viPhamDAL.ViPham_Delete(_viPhamDTO);
}
public DataTable SelectViPhamByMaChamCongThangNam(ViPhamDTO _viPhamDTO)
{
return(this._viPhamDAL.Select_ViPhamByMaChamCongThangNam(_viPhamDTO));
}
public DataTable loadViPhamByMaChamCong(ViPhamDTO _viPhamDTO)
{
return(this._viPhamDAL.load_ViPhamByMaChamCong(_viPhamDTO));
}
public void InsertViPham(ViPhamDTO _viPhamDTO)
{
this._viPhamDAL.Insert_ViPham(_viPhamDTO);
}
