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