/// <summary>
/// 设置sku信息
/// </summary>
/// <param name="itemInfo"></param>
/// <returns></returns>
public bool SetSkuInfo(ItemInfo itemInfo)
{
using (IDbTransaction tran = this.SQLHelper.CreateTransaction())
{
try
{
//修改sku下载标志
UpdateSkuFlag(itemInfo, tran);
if (itemInfo.SkuList != null)
{
foreach (SkuInfo skuInfo in itemInfo.SkuList)
{
if (skuInfo.item_id == null)
{
skuInfo.item_id = itemInfo.Item_Id;
}
if (skuInfo.sku_id == null || skuInfo.sku_id.Equals(""))
{
skuInfo.sku_id = NewGuid();
}
if (skuInfo.modify_time == null || skuInfo.modify_time.Equals(""))
{
skuInfo.modify_time = GetCurrentDateTime();
}
if (skuInfo.modify_user_id == null || skuInfo.modify_user_id.Equals(""))
{
skuInfo.modify_user_id = itemInfo.Create_User_Id;
}
if (skuInfo.create_time == null || skuInfo.create_time.Equals(""))
{
skuInfo.create_time = GetCurrentDateTime();
}
if (skuInfo.create_user_id == null || skuInfo.create_user_id.Equals(""))
{
skuInfo.create_user_id = itemInfo.Create_User_Id;
}
UpdateSku(skuInfo, tran); //修改
InsertSku(skuInfo, tran); //删除
//处理sku相关价格信息(jifeng.cao 20140224)
foreach (SkuPriceInfo skuPriceInfo in skuInfo.sku_price_list)
{
if (skuPriceInfo.sku_price != -1)
{
if (skuPriceInfo.sku_id == null)
{
skuPriceInfo.sku_id = skuInfo.sku_id;
}
if (skuPriceInfo.sku_price_id == null || skuPriceInfo.sku_price_id.Equals(""))
{
skuPriceInfo.sku_price_id = NewGuid();
}
if (skuPriceInfo.modify_time == null || skuPriceInfo.modify_time.Equals(""))
{
skuPriceInfo.modify_time = GetCurrentDateTime();
}
if (skuPriceInfo.modify_user_id == null || skuPriceInfo.modify_user_id.Equals(""))
{
skuPriceInfo.modify_user_id = skuInfo.create_user_id;
}
if (skuPriceInfo.create_time == null || skuPriceInfo.create_time.Equals(""))
{
skuPriceInfo.create_time = GetCurrentDateTime();
}
if (skuPriceInfo.create_user_id == null || skuPriceInfo.create_user_id.Equals(""))
{
skuPriceInfo.create_user_id = skuInfo.create_user_id;
}
new SkuPriceService(loggingSessionInfo).UpdateSkuPrice(skuPriceInfo, tran); //修改
new SkuPriceService(loggingSessionInfo).InsertSkuPrice(skuPriceInfo, tran); //删除
}
}
}
}
if (itemInfo.SkuImageList != null && itemInfo.SkuImageList.Count > 0)
{
ObjectImagesDAO objectImagesDAO = new ObjectImagesDAO(CurrentUserInfo);
foreach (var imageItem in itemInfo.SkuImageList)
{
var exsitObj = objectImagesDAO.QueryByEntity(new ObjectImagesEntity()
{
ObjectId = imageItem.ObjectId,
ImageURL = imageItem.ImageURL
}, null);
if (exsitObj == null || exsitObj.Length == 0)
{
imageItem.ImageId = NewGuid();
imageItem.CreateTime = DateTime.Now;
imageItem.CreateBy = itemInfo.Create_User_Id;
imageItem.CustomerId = CurrentUserInfo.CurrentUser.customer_id;
objectImagesDAO.Create(imageItem);
}
}
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
tran.Rollback();
throw (ex);
}
}
}
/// <summary>
/// 设置sku信息
/// </summary>
/// <param name="itemInfo"></param>
/// <returns></returns>
public bool SetSkuInfo(ItemInfo itemInfo, IDbTransaction pTran, out string strError)
{
var skupriceService = new SkuPriceService(loggingSessionInfo);
//using (IDbTransaction tran = this.SQLHelper.CreateTransaction())
//{
try
{
//修改sku下载标志
UpdateSkuFlag(itemInfo, pTran);
if (itemInfo.SkuList != null)
{
// T_Item_Price_Type
var priceTypeService = new ItemPriceTypeService(loggingSessionInfo);
var priceTypeList = priceTypeService.GetItemPriceTypeList();
//
var skustockTypeId = ""; //库存id
var skusalesCountTypeId = ""; //销量id
if (priceTypeList != null && priceTypeList.Tables.Count != 0)
{
var priceTypeTable = priceTypeList.Tables[0];
foreach (DataRow row in priceTypeTable.Rows)
{
if (row["item_price_type_code"] != null && row["item_price_type_code"].ToString() == "库存")
{
skustockTypeId = row["item_price_type_id"].ToString();
}
if (row["item_price_type_code"] != null && row["item_price_type_code"].ToString() == "销量")
{
skusalesCountTypeId = row["item_price_type_id"].ToString();
}
}
}
//还要遍历看看商品的库存和销量
var ItemStockPropId = ""; //库存id
var ItemsalesCountPropId = ""; //销量id
var propService = new PropService(loggingSessionInfo);
//
PropInfo pro1 = new PropInfo();
pro1.Prop_Code = "Qty";
pro1.Prop_Domain = "ITEM";
pro1.Prop_Type = "2";
var pro1DataSet = propService.GetWebProp(pro1, 0, 10);
if (pro1DataSet != null && pro1DataSet.Tables.Count != 0)
{
var pro1Table = pro1DataSet.Tables[0];
if (pro1Table.Rows.Count > 0)
{
ItemStockPropId = pro1Table.Rows[0]["prop_id"].ToString();
}
}
//
PropInfo pro2 = new PropInfo();
pro2.Prop_Code = "SalesCount";
pro2.Prop_Domain = "ITEM";
pro2.Prop_Type = "2";
var pro2DataSet = propService.GetWebProp(pro2, 0, 10);
if (pro2DataSet != null && pro2DataSet.Tables.Count != 0)
{
var pro2Table = pro2DataSet.Tables[0];
if (pro2Table.Rows.Count > 0)
{
ItemsalesCountPropId = pro2Table.Rows[0]["prop_id"].ToString();
}
}
//商品的属性****
ItemPropService itemPropService = new ItemPropService(loggingSessionInfo);
var ds = itemPropService.GetItemPropListByItemId(itemInfo.Item_Id, pTran);//绑到事务里
var stockItemProp = new ItemPropInfo();
var SalesCountProp = new ItemPropInfo();
if (ds != null && ds.Tables.Count != 0)
{
var dt = ds.Tables[0];
var drs = dt.Select(" PropertyCodeId='" + ItemStockPropId + "'"); //原来prop_id
if (drs != null && drs.Length != 0)
{
var row = drs[0];
stockItemProp.Item_Property_Id = row["item_property_id"].ToString();
try
{
//stockItemProp.PropertyCodeValue = row["PropertyCodeValue"].ToString();//库存属性值,
stockItemProp.PropertyCodeValue = "0"; //赋值为0的原因是，不让数据叠加
int temp = Convert.ToInt32(row["PropertyCodeValue"].ToString());
}
catch {
stockItemProp.PropertyCodeValue = "0";
}
}
//
var drs2 = dt.Select(" PropertyCodeId='" + ItemsalesCountPropId + "'");
if (drs2 != null && drs2.Length != 0)
{
var row = drs2[0];
SalesCountProp.Item_Property_Id = row["item_property_id"].ToString();
try
{
// SalesCountProp.PropertyCodeValue = row["PropertyCodeValue"].ToString();
SalesCountProp.PropertyCodeValue = "0"; //赋值为0的原因是，不让数据叠加
int temp = Convert.ToInt32(row["PropertyCodeValue"].ToString()); //出异常时，就为0
}
catch
{
SalesCountProp.PropertyCodeValue = "0"; //销量属性
}
}
}
decimal stockCountTemp = 0;
decimal salesCountTemp = 0;
foreach (SkuInfo skuInfo in itemInfo.SkuList)
{
if (skuInfo.item_id == null)
{
skuInfo.item_id = itemInfo.Item_Id;
}
if (skuInfo.sku_id == null || skuInfo.sku_id.Equals(""))
{
skuInfo.sku_id = NewGuid();
}
if (skuInfo.modify_time == null || skuInfo.modify_time.Equals(""))
{
skuInfo.modify_time = GetCurrentDateTime();
}
if (skuInfo.modify_user_id == null || skuInfo.modify_user_id.Equals(""))
{
skuInfo.modify_user_id = itemInfo.Create_User_Id;
}
if (skuInfo.create_time == null || skuInfo.create_time.Equals(""))
{
skuInfo.create_time = GetCurrentDateTime();
}
if (skuInfo.create_user_id == null || skuInfo.create_user_id.Equals(""))
{
skuInfo.create_user_id = itemInfo.Create_User_Id;
}
UpdateSku(skuInfo, pTran); //修改
InsertSku(skuInfo, pTran); //删除
//处理sku相关价格信息(jifeng.cao 20140224)
foreach (SkuPriceInfo skuPriceInfo in skuInfo.sku_price_list)
{
if (skuPriceInfo.sku_price != -1)
{
//不要取原来的数据了
//decimal oldPrice = 0;
//if (!string.IsNullOrEmpty(skuPriceInfo.sku_price_id))
//{
// var skuPriceInfoTemp = skupriceService.GetSkuPriceByID(skuPriceInfo.sku_price_id, pTran);
// if (skuPriceInfoTemp != null && skuPriceInfoTemp.Tables.Count != 0 && skuPriceInfoTemp.Tables[0].Rows.Count!=0)
// {
// oldPrice=Convert.ToDecimal( skuPriceInfoTemp.Tables[0].Rows[0]["sku_price"]);
// }
//}
if (skuPriceInfo.sku_id == null)
{
skuPriceInfo.sku_id = skuInfo.sku_id;
}
if (skuPriceInfo.sku_price_id == null || skuPriceInfo.sku_price_id.Equals(""))
{
skuPriceInfo.sku_price_id = NewGuid(); //如果是新建
}
if (skuPriceInfo.modify_time == null || skuPriceInfo.modify_time.Equals(""))
{
skuPriceInfo.modify_time = GetCurrentDateTime();
}
if (skuPriceInfo.modify_user_id == null || skuPriceInfo.modify_user_id.Equals(""))
{
skuPriceInfo.modify_user_id = skuInfo.create_user_id;
}
if (skuPriceInfo.create_time == null || skuPriceInfo.create_time.Equals(""))
{
skuPriceInfo.create_time = GetCurrentDateTime();
}
if (skuPriceInfo.create_user_id == null || skuPriceInfo.create_user_id.Equals(""))
{
skuPriceInfo.create_user_id = skuInfo.create_user_id;
}
new SkuPriceService(loggingSessionInfo).UpdateSkuPrice(skuPriceInfo, pTran); //修改
new SkuPriceService(loggingSessionInfo).InsertSkuPrice(skuPriceInfo, pTran); //删除
// skuPriceInfo.item_price_type_name==
//skuPriceInfo
//判断如果是库存的,并且当前sku的price_type_type_id=获取到的库存类型的id，并且商品里有库存
if (skustockTypeId != "" && skuPriceInfo.item_price_type_id == skustockTypeId && ItemStockPropId != "")
{
//找出该商品对应的库存的属性
stockCountTemp += skuPriceInfo.sku_price; // -oldPrice;//不用再删除之前的数据了
}
//如果是销量的
if (skusalesCountTypeId != "" && skuPriceInfo.item_price_type_id == skusalesCountTypeId && ItemsalesCountPropId != "")
{
//找出该商品对应的库存的属性
salesCountTemp += skuPriceInfo.sku_price; //- oldPrice;//不用再删除之前的数据
}
}
}
}
stockItemProp.PropertyCodeValue = (Convert.ToDecimal(stockItemProp.PropertyCodeValue) + stockCountTemp) + "";
SalesCountProp.PropertyCodeValue = (Convert.ToDecimal(SalesCountProp.PropertyCodeValue) + salesCountTemp) + "";
//更新数据
itemPropService.updateValue(stockItemProp.Item_Property_Id, stockItemProp.PropertyCodeValue, pTran);
itemPropService.updateValue(SalesCountProp.Item_Property_Id, SalesCountProp.PropertyCodeValue, pTran);
}
//图片
if (itemInfo.SkuImageList != null && itemInfo.SkuImageList.Count > 0)
{
ObjectImagesDAO objectImagesDAO = new ObjectImagesDAO(CurrentUserInfo);
foreach (var imageItem in itemInfo.SkuImageList)
{
var exsitObj = objectImagesDAO.QueryByEntity(new ObjectImagesEntity()
{
ObjectId = imageItem.ObjectId,
ImageURL = imageItem.ImageURL
}, null);
if (exsitObj == null || exsitObj.Length == 0)
{
imageItem.ImageId = NewGuid();
imageItem.CreateTime = DateTime.Now;
imageItem.CreateBy = itemInfo.Create_User_Id;
imageItem.CustomerId = CurrentUserInfo.CurrentUser.customer_id;
objectImagesDAO.Create(imageItem);
}
}
}
// tran.Commit();
strError = "";
return(true);
}
catch (Exception ex)
{
strError = "";
return(false);
//tran.Rollback();
//throw (ex);
}
// }
}