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); }