private List <T_Sku_PriceEntity> ConvertToT_Sku_PriceEntityList(ItemDetailAmountContract contract)
{
var result = new List <T_Sku_PriceEntity>();
var inventory = new T_Sku_PriceEntity
{
sku_price_id = Guid.NewGuid().ToString("N"),
sku_id = contract.ItemDetailId,
item_price_type_id = ConfigMgr.ItemPriceTypeId_Inventory,
sku_price = contract.Inventory,
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"),
bat_id = null,
if_flag = "0",
customer_id = ConfigMgr.CustomerId
};
result.Add(inventory);
var salesVolume = new T_Sku_PriceEntity
{
sku_price_id = Guid.NewGuid().ToString("N"),
sku_id = contract.ItemDetailId,
item_price_type_id = ConfigMgr.ItemPriceTypeId_SalesVolume,
sku_price = contract.SalesVolume,
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"),
bat_id = null,
if_flag = "0",
customer_id = ConfigMgr.CustomerId
};
result.Add(salesVolume);
return(result);
}
internal void Delete(T_Sku_PriceEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
conn.Open();
conn.Delete(dbEntity);
}
}
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);
}
internal void Update(T_Sku_PriceEntity dbEntity)
{
using (var conn = new SqlConnection(ConnectionString.XgxInsert))
{
dbEntity.create_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
//dbEntity.modify_user_id = "ERP";
conn.Open();
conn.Update(dbEntity);
}
}
public void Create(T_Sku_PriceEntity dbEntity)
{
_cmd.Create(dbEntity);
}
public void Delete(T_Sku_PriceEntity dbEntity)
{
_cmd.Delete(dbEntity);
}
public void Update(T_Sku_PriceEntity dbEntity)
{
_cmd.Update(dbEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(T_Sku_PriceEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(T_Sku_PriceEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <T_Sku_PriceEntity> PagedQueryByEntity(T_Sku_PriceEntity 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_Sku_PriceEntity[] QueryByEntity(T_Sku_PriceEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(T_Sku_PriceEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(T_Sku_PriceEntity pEntity)
{
_currentDAO.Update(pEntity);
}
