private List <T_SkuEntity> ConvertToT_SkuEntityList(ItemContract contract) { var result = new List <T_SkuEntity>(); if (contract.ItemDetailList == null) { return(result); } foreach (var i in contract.ItemDetailList) { var skuValueCount = 0; if (i.SkuValueIdList != null) { skuValueCount = i.SkuValueIdList.Count; } var skuEntity = new T_SkuEntity { sku_id = i.ItemDetailId, item_id = contract.ItemId, sku_prop_id1 = skuValueCount > 0 ? i.SkuValueIdList[0] : null, sku_prop_id2 = skuValueCount > 1 ? i.SkuValueIdList[1] : null, sku_prop_id3 = skuValueCount > 2 ? i.SkuValueIdList[2] : null, sku_prop_id4 = skuValueCount > 3 ? i.SkuValueIdList[3] : null, sku_prop_id5 = skuValueCount > 4 ? i.SkuValueIdList[4] : null, barcode = i.BarCode, status = "1", create_time = i.CreateTime == null ? null : i.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = i.ModifyTime == null ? null : i.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), bat_id = "1", if_flag = "0" }; result.Add(skuEntity); } return(result); }
private T_ItemEntity ConvertToT_ItemEntity(ItemContract contract) { var result = new T_ItemEntity { item_id = contract.ItemId, item_category_id = contract.ItemCategoryId, item_code = contract.ItemCode, item_name = contract.ItemName, item_name_en = contract.ItemNameEn, item_name_short = contract.ItemNameShort, pyzjm = contract.Pyzjm, item_remark = contract.ItemRemark, status = "1", status_desc = "正常", 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"), bat_id = null, if_flag = "0", ifgifts = 0, ifoften = 0, ifservice = 0, IsGB = 1, data_from = "xgx", display_index = 0, imageUrl = null, CustomerId = ConfigMgr.CustomerId }; return(result); }
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); }
private void InsertInDb() { Location = ItemLocation.Inventory; ItemContract contract = MapItemModel(); _itemCrudService.Add(contract); }
public void CreateAndUpdateItem(ItemContract itemContract) { var item = ItemRepository.Get(itemContract.Id); if (item != null) { //Update item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.Unit; ItemRepository.Update(item); } else { //Insert OR Create item = new Item(); item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.Unit; ItemRepository.Insert(item); } }
private List <T_Sku_PriceEntity> ConvertToT_Sku_PriceEntityList(ItemContract contract) { var result = new List <T_Sku_PriceEntity>(); if (contract.ItemDetailList == null) { return(result); } foreach (var i in contract.ItemDetailList) { var skuPriceEntityOriginalPrice = new T_Sku_PriceEntity { sku_price_id = Guid.NewGuid().ToString("N"), sku_id = i.ItemDetailId, item_price_type_id = ConfigMgr.ItemPriceTypeId_OriginalPrice, sku_price = i.OriginalPrice, status = "1", create_time = i.CreateTime == null ? null : i.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = i.ModifyTime == null ? null : i.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), bat_id = null, if_flag = "0", customer_id = ConfigMgr.CustomerId }; result.Add(skuPriceEntityOriginalPrice); var skuPriceEntityRetailPrice = new T_Sku_PriceEntity { sku_price_id = Guid.NewGuid().ToString("N"), sku_id = i.ItemDetailId, item_price_type_id = ConfigMgr.ItemPriceTypeId_RetailPrice, sku_price = i.RetailPrice, status = "1", create_time = i.CreateTime == null ? null : i.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = i.ModifyTime == null ? null : i.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), bat_id = null, if_flag = "0", customer_id = ConfigMgr.CustomerId }; result.Add(skuPriceEntityRetailPrice); if (contract.ItemId.StartsWith("S_")) { var skuPriceEntityInventory = new T_Sku_PriceEntity { sku_price_id = Guid.NewGuid().ToString("N"), sku_id = i.ItemDetailId, item_price_type_id = ConfigMgr.ItemPriceTypeId_Inventory, sku_price = 10000000, status = "1", create_time = i.CreateTime == null ? null : i.CreateTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), modify_time = i.ModifyTime == null ? null : i.ModifyTime.Value.ToString("yyyy-MM-dd hh:mm:ss"), bat_id = null, if_flag = "0", customer_id = ConfigMgr.CustomerId }; result.Add(skuPriceEntityInventory); } } return(result); }
private void InsertInDb() { Location = ItemLocation.Inventory; ItemContract contract = MapItemModel(); ExistsInDb = contract.ExistsInDb = true; ItemService.InsertNewItem(contract); }
public void Test1() { ItemService itemService = new ItemService(); ItemContract item = new ItemContract() { Code = 2323, Name = "pencil" }; itemService.SaveCreateOrUpdate(item); }
private L2Item MapModelToItem(ItemContract contract) { L2Item item = new L2Item(_itemCrudService, _idFactory, _itemTable.GetItem(contract.ItemId), _idFactory.NextId()) { ObjectId = contract.ObjectId, Count = contract.Count, CustomType1 = contract.CustomType1, CustomType2 = contract.CustomType2, Enchant = contract.Enchant, SlotLocation = contract.LocationData, OwnerId = contract.CharacterId, }; return(item); }
private static L2Item MapModelToItem(ItemContract contract) { L2Item item = new L2Item(ItemTable.Instance.GetItem(contract.ItemId), IdFactory.Instance.NextId()) { ObjId = contract.ObjectId, Count = contract.Count, CustomType1 = contract.CustomType1, CustomType2 = contract.CustomType2, Enchant = contract.Enchant, SlotLocation = contract.LocationData, OwnerId = contract.OwnerId, ExistsInDb = contract.ExistsInDb }; return(item); }
public override bool Equals(object other) { if ((object)this == other) { return(true); } if (base.Equals(other)) { ArrayDataContract dataContract = other as ArrayDataContract; if (dataContract != null) { return(ItemContract.Equals(dataContract.itemContract)); } } return(false); }
private ItemContract MapItemModel() { ItemContract contract = new ItemContract { ObjectId = ObjId, ItemId = Template.ItemId, Count = Count, CustomType1 = CustomType1, CustomType2 = CustomType2, Enchant = Enchant, LocationData = SlotLocation, Location = Enum.GetName(typeof(ItemLocation), Location), OwnerId = OwnerId, ManaLeft = 0, Time = 0, TimeOfUse = null }; return(contract); }
public void SaveCreateOrUpdate(ItemContract itemContract) { var item = IItemRepository.Get(itemContract.Id); if (item != null) { item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.unit; IItemRepository.Update(item); } else { item = new Item(); item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.unit; IItemRepository.Insert(item); } }
public void InsertNewItem(ItemContract item) { const string sql = @"Insert into items (owner_id,item_id,count,loc,loc_data,enchant_level,object_id,custom_type1,custom_type2,mana_left,time) Values (@owner_id,@item_id,@count,@loc,@loc_data,@enchant_level,@object_id,@custom_type1,@custom_type2,@mana_left,@time)"; Db.ExecuteAsync(sql, new { owner_id = item.OwnerId, item_id = item.ItemId, count = item.Count, loc = item.Location, loc_data = item.LocationData, enchant_level = item.Enchant, object_id = item.ObjectId, custom_type1 = item.CustomType1, custom_type2 = item.CustomType2, mana_left = item.ManaLeft, time = item.Time }); }
public void SaveCreateOrUpdate(ItemContract itemContract) { var item = IItemRepository.Get(itemContract.Id); if (item != null) { item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.Unit; IItemRepository.Update(item); } else { //hamatun iq hastin koshtin mano be bagiam bnegu chon momken koshte farzi bedin item = new Item(); item.Code = itemContract.Code; item.Name = itemContract.Name; item.Unit = itemContract.Unit; IItemRepository.Insert(item); } }
public void CreateAndUpdate(ItemContract itemContract) { var item = iitItemRepository.Get(itemContract.Id); if (item != null) { item.Name = itemContract.Name; item.Unit = itemContract.Unit; item.Code = itemContract.Code; iitItemRepository.Update(item); } else { Item item1 = new Item(); item1.Name = itemContract.Name; item1.Unit = itemContract.Unit; item1.Code = itemContract.Code; iitItemRepository.Insert(item1); } }
public void UpdateItem(ItemContract item) { if (!item.ExistsInDb) { return; } const string sql = @"UPDATE items SET owner_id=@owner_id,count=@count,loc=@loc,loc_data=@loc_data,enchant_level=@enchant_level,custom_type1=@custom_type1, custom_type2=@custom_type2,mana_left=@mana_left,time=@time WHERE object_id = @object_id"; Db.ExecuteAsync(sql, new { owner_id = item.OwnerId, count = item.Count, loc = item.Location, loc_data = item.LocationData, enchant_level = item.Enchant, custom_type1 = item.CustomType1, custom_type2 = item.CustomType2, mana_left = item.ManaLeft, time = item.Time, object_id = item.ObjectId }); }
private List <T_Item_Delivery_MappingEntity> ConvertToT_Item_Delivery_MappingEntityList(ItemContract contract) { var result = new List <T_Item_Delivery_MappingEntity>(); if (contract.DeliveryList == null || contract.DeliveryList.Count == 0) { var itemDeliveryMappingEntityUnkown = new T_Item_Delivery_MappingEntity { Item_Delivery_Id = Guid.NewGuid().ToString("N"), CustomerId = ConfigMgr.CustomerId, Item_Id = contract.ItemId, DeliveryId = 2, 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"), }; result.Add(itemDeliveryMappingEntityUnkown); return(result); } foreach (var i in contract.DeliveryList) { if (i == EnumDelivery.Unknown) { var itemDeliveryMappingEntityUnkown = new T_Item_Delivery_MappingEntity { Item_Delivery_Id = Guid.NewGuid().ToString("N"), CustomerId = ConfigMgr.CustomerId, Item_Id = contract.ItemId, DeliveryId = (int)EnumDelivery.ShopPickUp, 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"), }; result.Add(itemDeliveryMappingEntityUnkown); break; } var itemDeliveryMappingEntity = new T_Item_Delivery_MappingEntity { Item_Delivery_Id = Guid.NewGuid().ToString("N"), CustomerId = ConfigMgr.CustomerId, Item_Id = contract.ItemId, DeliveryId = (int)i, 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"), }; result.Add(itemDeliveryMappingEntity); } return(result); }
public void Delete(ItemContract itemContract) { var item = ItemRepository.Get(itemContract.Id); ItemRepository.Delete(item); }
public void UpdateItem(ItemContract item) { _unitOfWork.ItemRepository.UpdateItem(item); }
public void InsertNewItem(ItemContract item) { _itemRepository.InsertNewItem(item); }
public void UpdateItem(ItemContract item) { _itemRepository.UpdateItem(item); }
private void UpdateInDb() { ItemContract contract = MapItemModel(); ItemService.UpdateItem(contract); }
private void UpdateInDb() { ItemContract contract = MapItemModel(); _itemCrudService.Update(contract); }
public void InsertNewItem(ItemContract item) { _unitOfWork.ItemRepository.InsertNewItem(item); }
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; } }