internal void Delete(T_Item_PropertyEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
conn.Open();
conn.Delete(dbEntity);
}
}
internal void Update(T_Item_PropertyEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
dbEntity.modify_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
conn.Open();
conn.Update(dbEntity);
}
}
internal void CreateSalesCount(string skuId)
{
using (var conn = new SqlConnection(ConnectionString.XgxSelect))
{
conn.Open();
const string sql = @"select sum(isnull(sku_price,0)) from T_Sku_Price where sku_id in (select sku_id from t_sku where item_id = (select item_id from t_sku where sku_id = @SkuId)) and item_price_type_id = '77850286E3F24CD2AC84F80BC625859f'and status = 1";
var qty = conn.QueryFirstOrDefault <int>(sql, new { SkuId = skuId });
const string sql1 = @"select item_id from t_sku where sku_id = @SkuId";
var itemId = conn.QueryFirstOrDefault <string>(sql1, new { SkuId = skuId });
var dbEntity = new T_Item_PropertyEntity
{
item_property_id = Guid.NewGuid().ToString("N"),
item_id = itemId,
prop_id = "34FF4445D39F49AD8174954D18BC1347",
prop_value = qty.ToString(),
status = "1",
create_time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
modify_time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")
};
Create(dbEntity);
}
}
public void Deal(ItemContract contract)
{
var itemFacade = new T_ItemFacade();
var itemSkuPropFacade = new T_ItemSkuPropFacade();
var skuPriceFacade = new T_Sku_PriceFacade();
var skuFacade = new T_SkuFacade();
var itemDeliveryMappingFacade = new T_Item_Delivery_MappingFacade();
var itemPropertyFacade = new T_Item_PropertyFacade();
var propFacade = new T_PropFacade();
itemFacade.Delete(new T_ItemEntity {
item_id = contract.ItemId
});
itemSkuPropFacade.DeleteByItemId(contract.ItemId);
skuPriceFacade.DeleteByItemId(contract.ItemId);
skuFacade.DeleteByItemId(contract.ItemId);
itemDeliveryMappingFacade.DeleteByItemId(contract.ItemId);
switch (contract.Operation)
{
case OptEnum.Create:
case OptEnum.Update:
if (contract.ItemDetailList == null || contract.ItemDetailList.Count == 0)
{
return;
}
var itemEntity = ConvertToT_ItemEntity(contract);
var itemSkuPropEntity = ConvertToT_ItemSkuPropEntity(contract);
var skuPriceEntityList = ConvertToT_Sku_PriceEntityList(contract);
var skuEntityList = ConvertToT_SkuEntityList(contract);
var deliveryList = ConvertToT_Item_Delivery_MappingEntityList(contract);
itemFacade.Create(itemEntity);
if (itemSkuPropEntity != null)
{
itemSkuPropFacade.Create(itemSkuPropEntity);
}
foreach (var i in skuPriceEntityList)
{
skuPriceFacade.Create(i);
}
foreach (var i in skuEntityList)
{
skuFacade.Create(i);
}
foreach (var i in deliveryList)
{
itemDeliveryMappingFacade.Create(i);
}
if (contract.ItemId.StartsWith("S_"))
{
//删除库存
itemPropertyFacade.DeleteByItemId(contract.ItemId);
//添加库存
var inventory = new T_Item_PropertyEntity
{
item_property_id = Guid.NewGuid().ToString("N"),
item_id = contract.ItemId,
prop_id = propFacade.GetIdByCode("Qty"),
prop_value = "10000000",
status = "1",
create_time =
contract.CreateTime == null
? null
: contract.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss"),
modify_time =
contract.ModifyTime == null
? null
: contract.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss")
};
itemPropertyFacade.Create(inventory);
}
break;
}
}
public void Create(T_Item_PropertyEntity dbEntity)
{
_cmd.Create(dbEntity);
}
public void Delete(T_Item_PropertyEntity dbEntity)
{
_cmd.Delete(dbEntity);
}
public void Update(T_Item_PropertyEntity dbEntity)
{
_cmd.Update(dbEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(T_Item_PropertyEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(T_Item_PropertyEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <T_Item_PropertyEntity> PagedQueryByEntity(T_Item_PropertyEntity 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_Item_PropertyEntity[] QueryByEntity(T_Item_PropertyEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(T_Item_PropertyEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(T_Item_PropertyEntity pEntity)
{
_currentDAO.Update(pEntity);
}
