/// <summary>
/// 分页查询,使用Id desc排序
/// </summary>
/// <param name="pageIndex">页号</param>
/// <param name="pageSize">页大小</param>
/// <param name="recordCount">记录总数</param>
/// <returns></returns>
public virtual ICollection<PatientsProduct> SelectPaging(int pageIndex, int pageSize, out int recordCount)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
recordCount = this.Count();
int offsetCount = (pageIndex - 1) * pageSize;
ICollection<PatientsProduct> resultList = null;
using (var reader = SqlHelper.ExecuteReader(sqlConnection, System.Data.CommandType.Text, selectPaging,
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@OffsetCount", offsetCount)
))
{
if (reader.HasRows)
{
resultList = new System.Collections.ObjectModel.Collection<PatientsProduct>();
}
while (reader.Read())
{
PatientsProduct result = new PatientsProduct();
result.Id = reader.GetGuid(0);
result.PatientId = reader.GetGuid(1);
result.ProductId = reader.GetGuid(2);
resultList.Add(result);
}
reader.Close();
}
return resultList;
}
/// <summary>
/// 更新对象，使用显示事物
/// </summary>
/// <param name="transaction">事物对象</param>
/// <param name="entity">一个实体对象</param>
public virtual void Update(SqlTransaction transaction, PatientsProduct entity)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
if (entity != null)
{
SqlHelper.ExecuteNonQuery(transaction, System.Data.CommandType.Text, updateById,
new SqlParameter("@PatientId", entity.PatientId),
new SqlParameter("@ProductId", entity.ProductId),
new SqlParameter("@Id", entity.Id)
);
}
}
/// <summary>
/// 查询,使用Id desc排序
/// </summary>
/// <param name="patientId">patientId</param>
/// <returns></returns>
public virtual ICollection<PatientsProduct> SelectByPatientId(Guid patientId)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
ICollection<PatientsProduct> resultList = null;
using (var reader = SqlHelper.ExecuteReader(sqlConnection, System.Data.CommandType.Text, selectByPatientId2,
new SqlParameter("@PatientId", patientId)
))
{
if (reader.HasRows)
{
resultList = new System.Collections.ObjectModel.Collection<PatientsProduct>();
}
while (reader.Read())
{
PatientsProduct result = new PatientsProduct();
result.Id = reader.GetGuid(0);
result.PatientId = reader.GetGuid(1);
result.ProductId = reader.GetGuid(2);
resultList.Add(result);
}
reader.Close();
}
return resultList;
}
/// <summary>
/// 创建对象
/// </summary>
/// <param name="entity">一个实体对象</param>
public virtual void Insert(PatientsProduct entity)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
if (entity != null)
{
SqlHelper.ExecuteNonQuery(sqlConnection, System.Data.CommandType.Text, insert,
new SqlParameter("@Id", entity.Id),
new SqlParameter("@PatientId", entity.PatientId),
new SqlParameter("@ProductId", entity.ProductId)
);
}
}
/// <summary>
/// 根据Id查询实体
/// </summary>
/// <param name="id">实体对象的Id</param>
/// <returns>一个实体对象</returns>
public virtual PatientsProduct GetById(Guid id)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
PatientsProduct result = null;
if (id != Guid.Empty)
{
using (var reader = SqlHelper.ExecuteReader(sqlConnection, System.Data.CommandType.Text, selectById,
new SqlParameter("@Id", id)
))
{
if (reader.HasRows)
{
result = new PatientsProduct();
}
while (reader.Read())
{
result.Id = reader.GetGuid(0);
result.PatientId = reader.GetGuid(1);
result.ProductId = reader.GetGuid(2);
}
reader.Close();
}
}
return result;
}
/// <summary>
/// 删除对象，使用显示事物
/// </summary>
/// <param name="transaction">事物对象</param>
/// <param name="entity">一个实体对象</param>
public virtual void Delete(SqlTransaction transaction, PatientsProduct entity)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
if (entity != null)
{
SqlTransaction tran = transaction;
try
{
Delete(entity);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Dispose();
tran = null;
}
}
}
/// <summary>
/// 删除对象
/// </summary>
/// <param name="entity">一个实体对象</param>
public virtual void Delete(PatientsProduct entity)
{
if (Disposed)
{
throw new ObjectDisposedException(ToString());
}
if (entity != null)
{
Delete(entity.Id);
}
}
