private T_ItemSkuPropEntity ConvertToT_ItemSkuPropEntity(ItemContract contract)
{
if (contract.SkuNameIdList == null)
{
return(null);
}
var skuCount = contract.SkuNameIdList.Count;
if (skuCount == 0)
{
return(null);
}
var itemSkuPropEntity = new T_ItemSkuPropEntity
{
ItemSkuPropID = Guid.NewGuid().ToString("N"),
Item_id = contract.ItemId,
ItemSku_prop_1_id = skuCount > 0 ? contract.SkuNameIdList[0] : null,
ItemSku_prop_2_id = skuCount > 1 ? contract.SkuNameIdList[1] : null,
ItemSku_prop_3_id = skuCount > 2 ? contract.SkuNameIdList[2] : null,
ItemSku_prop_4_id = skuCount > 3 ? contract.SkuNameIdList[3] : null,
ItemSku_prop_5_id = skuCount > 4 ? contract.SkuNameIdList[4] : null,
status = "1",
IsDelete = 0,
create_time = contract.CreateTime,
modify_time = contract.ModifyTime
};
return(itemSkuPropEntity);
}
internal void Delete(T_ItemSkuPropEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
conn.Open();
conn.Delete(dbEntity);
}
}
internal void Update(T_ItemSkuPropEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
dbEntity.modify_time = System.DateTime.Now;
conn.Open();
conn.Update(dbEntity);
}
}
public void Create(T_ItemSkuPropEntity dbEntity)
{
_cmd.Create(dbEntity);
}
public void Delete(T_ItemSkuPropEntity dbEntity)
{
_cmd.Delete(dbEntity);
}
public void Update(T_ItemSkuPropEntity dbEntity)
{
_cmd.Update(dbEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(T_ItemSkuPropEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(T_ItemSkuPropEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <T_ItemSkuPropEntity> PagedQueryByEntity(T_ItemSkuPropEntity 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 T_ItemSkuPropEntity[] QueryByEntity(T_ItemSkuPropEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(T_ItemSkuPropEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(T_ItemSkuPropEntity pEntity)
{
_currentDAO.Update(pEntity);
}
