public void UpdateAddress(VipAddressEntity pEntity)
{
if (pEntity.IsDefault == 1)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"
UPDATE vipaddress SET isdefault=0,lastupdateby={2},lastupdatetime=GETDATE()
FROM vipaddress WHERE isdelete=0 AND isdefault=1 AND vipid='{0}' AND vipaddressid<>'{1}'
", pEntity.VIPID, pEntity.VipAddressID, CurrentUserInfo.UserID);
this.SQLHelper.ExecuteNonQuery(sql.ToString());
}
this.Update(pEntity);
}
public bool EditVipAddress(VipAddressEntity pEntity)
{
if (!string.IsNullOrEmpty(pEntity.VipAddressID))
{//修改、删除
if (pEntity.IsDelete == 1)
{
this._currentDAO.Delete(pEntity);
}
else
{
this._currentDAO.UpdateAddress(pEntity);
}
}
else
{
pEntity.VipAddressID = Guid.NewGuid().ToString("N");
this._currentDAO.CreateAddress(pEntity);
}
return(true);
}
public void Update(VipAddressEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(VipAddressEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(VipAddressEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(VipAddressEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <VipAddressEntity> PagedQueryByEntity(VipAddressEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public VipAddressEntity[] QueryByEntity(VipAddressEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(VipAddressEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(VipAddressEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(VipAddressEntity pEntity)
{
Update(pEntity, true);
}
