public DataTable get_ChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietDiCongTacDTO.MaChamCong)
};
return(base.executeNonQuerya("ChiTietDiCongTac_get", sqlParams));
}
public void Delete_ChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ID", _chiTietDiCongTacDTO.ID)
};
base.Procedure("ChiTietDiCongTac_delete", sqlParams);
}
public void Delete_ChiTietDiCongTacByMaChamCong(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietDiCongTacDTO.MaChamCong)
};
base.Procedure("ChiTietDiCongTac_DeleteByMaChamCong", sqlParams);
}
public void Insert_ChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _chiTietDiCongTacDTO.MaChamCong),
new SqlParameter("@Ngay", _chiTietDiCongTacDTO.Ngay),
new SqlParameter("@GioDi", _chiTietDiCongTacDTO.GioDi),
new SqlParameter("@GioVe", _chiTietDiCongTacDTO.GioVe),
new SqlParameter("@TongGioCongTac", _chiTietDiCongTacDTO.TongGioCongTac),
new SqlParameter("@CongTinhCongTac", _chiTietDiCongTacDTO.CongTinhCongTac),
new SqlParameter("@LyDo", _chiTietDiCongTacDTO.LyDo)
};
base.Procedure("ChiTietDiCongTac_add", sqlParams);
}
public void InsertChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
this._chiTietDiCongTacDAL.Insert_ChiTietDiCongTac(_chiTietDiCongTacDTO);
}
public DataTable getChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
return(this._chiTietDiCongTacDAL.get_ChiTietDiCongTac(_chiTietDiCongTacDTO));
}
public void DeleteChiTietDiCongTacByMaChamCong(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
this._chiTietDiCongTacDAL.Delete_ChiTietDiCongTacByMaChamCong(_chiTietDiCongTacDTO);
}
public void DeleteChiTietDiCongTac(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
this._chiTietDiCongTacDAL.Delete_ChiTietDiCongTac(_chiTietDiCongTacDTO);
}
public DataTable ChiTietDiCongTacGetTinhCong(ChiTietDiCongTacDTO _chiTietDiCongTacDTO)
{
return(this._chiTietDiCongTacDAL.ChiTietDiCongTac_getTinhCong(_chiTietDiCongTacDTO));
}