public void UpdateItemCategory(List <ItemCategoryEntity> itemCategory)
{
var adAreaBll = new MHAdAreaBLL(this.CurrentUserInfo);
var categoryAreaBll = new MHCategoryAreaBLL(this.CurrentUserInfo);
var homeBll = new MobileHomeBLL(this.CurrentUserInfo);
var homeList = homeBll.QueryByEntity(new MobileHomeEntity {
CustomerId = this.CurrentUserInfo.ClientID
}, null);
var homeId = homeList.FirstOrDefault().HomeId;
foreach (var item in itemCategory)
{
//更新
var entity = new MHCategoryAreaEntity()
{
CategoryAreaId = Guid.Parse(item.categoryAreaId),
HomeId = homeId,
ObjectId = item.objectId,
ObjectTypeId = item.typeId,
GroupID = item.groupId,
ObjectName = item.objectName,
ImageUrlObject = item.imageUrl,
DisplayIndex = item.displayIndex
};
adAreaBll.UpdateMHCategoryArea(entity);
}
}
public void InsertItemCategory(List <ItemCategoryEntity> itemCategory, int groupId)
{
var categoryAreaBll = new MHCategoryAreaBLL(this.CurrentUserInfo);
var homeBll = new MobileHomeBLL(this.CurrentUserInfo);
var homeList = homeBll.QueryByEntity(new MobileHomeEntity {
CustomerId = this.CurrentUserInfo.ClientID
}, null);
var homeId = homeList.FirstOrDefault().HomeId;
foreach (var item in itemCategory)
{
//新增
var entity = new MHCategoryAreaEntity()
{
CategoryAreaId = Guid.NewGuid(),
HomeId = homeId,
ObjectId = item.objectId,
ObjectTypeId = item.typeId,
GroupID = groupId,
ObjectName = item.objectName,
ImageUrlObject = item.imageUrl,
DisplayIndex = item.displayIndex
};
categoryAreaBll.Create(entity);
}
}
/// <summary>
/// 更新商品分类区域表
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public void UpdateMHCategoryArea(MHCategoryAreaEntity entity)
{
string sql = string.Empty;
sql += " UPDATE dbo.MHCategoryArea SET ";
sql += " ObjectId = '" + entity.ObjectId + "', ";
sql += " ObjectTypeId = '" + entity.ObjectTypeId + "', ";
sql += " GroupID = '" + entity.GroupID + "', ";
sql += " ObjectName = '" + entity.ObjectName + "', ";
sql += " ImageUrlObject = '" + entity.ImageUrlObject + "', ";
sql += " navName = '" + entity.navName + "', ";
sql += " url = '" + entity.url + "', ";
sql += " DisplayIndex = '" + entity.DisplayIndex + "' ";
sql += " WHERE CategoryAreaId = '" + entity.CategoryAreaId + "' ";
this.SQLHelper.ExecuteNonQuery(sql);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(MHCategoryAreaEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(MHCategoryAreaEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <MHCategoryAreaEntity> PagedQueryByEntity(MHCategoryAreaEntity 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 MHCategoryAreaEntity[] QueryByEntity(MHCategoryAreaEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(MHCategoryAreaEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(MHCategoryAreaEntity pEntity)
{
_currentDAO.Update(pEntity);
}
/// <summary>
/// 更新商品分类区域表
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public void UpdateMHCategoryArea(MHCategoryAreaEntity entity)
{
this._currentDAO.UpdateMHCategoryArea(entity);
}
