public void ImportOnTemplate(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colCode = oExcel.ExcelTable.Columns["代码"];
DataColumn colNameCN = oExcel.ExcelTable.Columns["中文名称"];
DataColumn colNameUS = oExcel.ExcelTable.Columns["英文名称"];
DataColumn colShipPolicy = oExcel.ExcelTable.Columns["运输策略"];
DataColumn colPayPolicy = oExcel.ExcelTable.Columns["支付策略"];
DataColumn colRelation = oExcel.ExcelTable.Columns["关联商品"];
DataColumn colLevelDiscount = oExcel.ExcelTable.Columns["等级折扣"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrganCode = row[colOrgan].ToString();
var oOrgan = (from o in dbEntity.MemberOrganizations
where o.Code == sOrganCode && o.Otype == (byte)ModelEnum.OrganizationType.CORPORATION
select o).FirstOrDefault();
string sCode = row[colCode].ToString();
GeneralResource oName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNameCN].ToString(), 1033, row[colNameUS].ToString());
string sShipPolicy = row[colShipPolicy].ToString();
string sPayPolicy = row[colPayPolicy].ToString();
string sRelation = row[colRelation].ToString();
string sLevelDiscount = row[colLevelDiscount].ToString();
string sRemark = row[colRemark].ToString();
var oTemplate = (from t in dbEntity.ProductOnTemplates
where t.OrgID == oOrgan.Gid && t.Code == sCode
select t).FirstOrDefault();
if (oTemplate == null)
{
oTemplate = new ProductOnTemplate { Organization = oOrgan, Code = sCode };
dbEntity.ProductOnTemplates.Add(oTemplate);
}
if (oTemplate.Name == null)
oTemplate.Name = oName;
else
oTemplate.Name.SetResource(ModelEnum.ResourceType.STRING, oName);
oTemplate.ShipPolicy = sShipPolicy;
oTemplate.PayPolicy = sPayPolicy;
oTemplate.Relation = sRelation;
oTemplate.LevelDiscount = sLevelDiscount;
oTemplate.Remark = sRemark;
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2}", this.ToString(), sCode, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入ProductOnTemplate成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入ProductOnTemplate错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
private void Test(MemberOrganization oOrgan, MemberChannel oChannel, ProductOnTemplate oTemplate,
ProductInformation oProduct, List<Object> oItemList = null)
{
Debug.WriteLine(oOrgan.Code);
Debug.WriteLine(oChannel.Code);
Debug.WriteLine(oTemplate.Code);
Debug.WriteLine(oProduct.Code + oProduct.Name.Matter);
foreach (Dictionary<string, object> item in oItemList)
{
Debug.WriteLine(item["Status"].ToString());
ProductInfoItem oInfoItem = (ProductInfoItem)item["SkuItem"];
Debug.WriteLine(oInfoItem.Code + oInfoItem.FullName.Matter);
GeneralMeasureUnit oUnit = (GeneralMeasureUnit)item["Unit"];
Debug.WriteLine(oUnit.Code);
GeneralMeasureUnit oCurrency1 = (GeneralMeasureUnit)item["Currency1"];
if (oCurrency1 != null)
Debug.WriteLine(oCurrency1.Code);
}
}
/// <summary>
/// ProductOnTemplate测试
/// </summary>
public void ProductOnTemplateTest()
{
MemberOrganization org = new MemberOrganization
{
Code = GetRandCode()
};
oLiveEntities.MemberOrganizations.Add(org);
ProductOnTemplate onTemp = new ProductOnTemplate
{
Code = GetRandCode(),
Organization = org
};
oLiveEntities.ProductOnTemplates.Add(onTemp);
oLiveEntities.SaveChanges();
}
/// <summary>
/// 保存对应的上架PU的上架模板
/// </summary>
/// <returns></returns>
public string SaveProductOnsaleTemplate(ProductOnTemplate oBackTemplate)
{
ProductOnTemplate oNewProductOnTemplate;
String strCode = oBackTemplate.Code;
string strShippingPolicy = "";
string strPayPolicy = "";
string strRelation = "";
string strLevelDiscount = "";
oNewProductOnTemplate = dbEntity.ProductOnTemplates.Where(p => p.OrgID == organizationGuid && p.Code == strCode).FirstOrDefault();
if (oNewProductOnTemplate == null)
{
oNewProductOnTemplate = new ProductOnTemplate { Name = NewResource(ModelEnum.ResourceType.STRING, organizationGuid) };
//需要新建上架模板
oNewProductOnTemplate.OrgID = organizationGuid;
oNewProductOnTemplate.Code = oBackTemplate.Code;
oNewProductOnTemplate.Name = oBackTemplate.Name;
//取出上架商品的承运商信息以及承运商地区信息
List<ProductOnShipping> oOnsaleShipping = dbEntity.ProductOnShippings.Include("Shipper").Include("OnShipArea").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleShipping.Count; i++)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).Shipper.Code + "|" + oOnsaleShipping.ElementAt(i).ShipWeight + "|" + oOnsaleShipping.ElementAt(i).Solution + ":";
if (oOnsaleShipping.ElementAt(i).OnShipArea.Count == 0)
{
if (i != oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + ";";
}
}
else
{
for (int j = 0; j < oOnsaleShipping.ElementAt(i).OnShipArea.Count; j++)
{
if (j == oOnsaleShipping.ElementAt(i).OnShipArea.Count - 1)
{
//如果是最后一个承运商的最后一个地区代码，则不需要加上分号
if (i == oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N");
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ";";
}
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ",";
}
}
}
}
oNewProductOnTemplate.ShipPolicy = strShippingPolicy;
//取出上架商品的支付方式
List<ProductOnPayment> oOnsalePayment = dbEntity.ProductOnPayments.Include("PayType").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsalePayment.Count; i++)
{
if (i == oOnsalePayment.Count - 1)
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code;
}
else
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code + ";";
}
}
oNewProductOnTemplate.PayPolicy = strPayPolicy;
//取出关联商品的信息
//字符串格式使用上架商品的Guid
List<ProductOnRelation> oOnsaleRelation = dbEntity.ProductOnRelations.Include("OnSale").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleRelation.Count; i++)
{
if (i == oOnsaleRelation.Count - 1)
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString();
}
else
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString() + ";";
}
}
oNewProductOnTemplate.Relation = strRelation;
//取出会员的折扣信息
List<ProductOnLevelDiscount> oOnsaleLevelDiscount = dbEntity.ProductOnLevelDiscounts.Include("UserLevel").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleLevelDiscount.Count; i++)
{
if (i == oOnsaleLevelDiscount.Count - 1)
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString();
}
else
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString() + ";";
}
}
oNewProductOnTemplate.LevelDiscount = strLevelDiscount;
oNewProductOnTemplate.Remark = oBackTemplate.Remark;
dbEntity.ProductOnTemplates.Add(oNewProductOnTemplate);
dbEntity.SaveChanges();
}
else
{
//存在原有的上架模板
if (oNewProductOnTemplate.Deleted == true)
{
//不需要提示用户，直接修改原有被删除的模板
oNewProductOnTemplate.Name.SetResource(ModelEnum.ResourceType.STRING, oBackTemplate.Name);
oNewProductOnTemplate.Deleted = false;
//取出上架商品的承运商信息以及承运商地区信息
List<ProductOnShipping> oOnsaleShipping = dbEntity.ProductOnShippings.Include("Shipper").Include("OnShipArea").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleShipping.Count; i++)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).Shipper.Code + "|" + oOnsaleShipping.ElementAt(i).ShipWeight + "|" + oOnsaleShipping.ElementAt(i).Solution + ":";
if (oOnsaleShipping.ElementAt(i).OnShipArea.Count == 0)
{
if (i != oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + ";";
}
}
else
{
for (int j = 0; j < oOnsaleShipping.ElementAt(i).OnShipArea.Count; j++)
{
if (j == oOnsaleShipping.ElementAt(i).OnShipArea.Count - 1)
{
//如果是最后一个承运商的最后一个地区代码，则不需要加上分号
if (i == oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N");
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ";";
}
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ",";
}
}
}
}
oNewProductOnTemplate.ShipPolicy = strShippingPolicy;
//取出上架商品的支付方式
List<ProductOnPayment> oOnsalePayment = dbEntity.ProductOnPayments.Include("PayType").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsalePayment.Count; i++)
{
if (i == oOnsalePayment.Count - 1)
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code;
}
else
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code + ";";
}
}
oNewProductOnTemplate.PayPolicy = strPayPolicy;
//取出关联商品的信息
//字符串格式使用上架商品的Guid
List<ProductOnRelation> oOnsaleRelation = dbEntity.ProductOnRelations.Include("OnSale").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleRelation.Count; i++)
{
if (i == oOnsaleRelation.Count - 1)
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString();
}
else
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString() + ";";
}
}
oNewProductOnTemplate.Relation = strRelation;
//取出会员的折扣信息
List<ProductOnLevelDiscount> oOnsaleLevelDiscount = dbEntity.ProductOnLevelDiscounts.Include("UserLevel").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleLevelDiscount.Count; i++)
{
if (i == oOnsaleLevelDiscount.Count - 1)
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString();
}
else
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString() + ";";
}
}
oNewProductOnTemplate.LevelDiscount = strLevelDiscount;
oNewProductOnTemplate.Remark = oBackTemplate.Remark;
dbEntity.SaveChanges();
}
else
{
//需要提示用户模板已存在，页面提示用户是否继续保存，如果是的话，修改全局变量；
if (bOnTemplateSave == false)
{
return "fail";
}
else
{
oNewProductOnTemplate.Name.SetResource(ModelEnum.ResourceType.STRING, oBackTemplate.Name);
//取出上架商品的承运商信息以及承运商地区信息
List<ProductOnShipping> oOnsaleShipping = dbEntity.ProductOnShippings.Include("Shipper").Include("OnShipArea").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleShipping.Count; i++)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).Shipper.Code + "|" + oOnsaleShipping.ElementAt(i).ShipWeight + "|" + oOnsaleShipping.ElementAt(i).Solution + ":";
if (oOnsaleShipping.ElementAt(i).OnShipArea.Count == 0)
{
if (i != oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + ";";
}
}
else
{
for (int j = 0; j < oOnsaleShipping.ElementAt(i).OnShipArea.Count; j++)
{
if (j == oOnsaleShipping.ElementAt(i).OnShipArea.Count - 1)
{
//如果是最后一个承运商的最后一个地区代码，则不需要加上分号
if (i == oOnsaleShipping.Count - 1)
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N");
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ";";
}
}
else
{
strShippingPolicy = strShippingPolicy + oOnsaleShipping.ElementAt(i).OnShipArea.ElementAt(j).RegionID.ToString("N") + ",";
}
}
}
}
oNewProductOnTemplate.ShipPolicy = strShippingPolicy;
//取出上架商品的支付方式
List<ProductOnPayment> oOnsalePayment = dbEntity.ProductOnPayments.Include("PayType").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsalePayment.Count; i++)
{
if (i == oOnsalePayment.Count - 1)
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code;
}
else
{
strPayPolicy = strPayPolicy + oOnsalePayment.ElementAt(i).PayType.Code + ";";
}
}
oNewProductOnTemplate.PayPolicy = strPayPolicy;
//取出关联商品的信息
//字符串格式使用上架商品的Guid
List<ProductOnRelation> oOnsaleRelation = dbEntity.ProductOnRelations.Include("OnSale").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleRelation.Count; i++)
{
if (i == oOnsaleRelation.Count - 1)
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString();
}
else
{
strRelation = strRelation + oOnsaleRelation.ElementAt(i).OnSale.Gid.ToString("N") + "|" + oOnsaleRelation.ElementAt(i).Rtype.ToString() + ";";
}
}
oNewProductOnTemplate.Relation = strRelation;
//取出会员的折扣信息
List<ProductOnLevelDiscount> oOnsaleLevelDiscount = dbEntity.ProductOnLevelDiscounts.Include("UserLevel").Where(p => p.OnSaleID == selectedPuOnSaleGuid && p.Deleted == false).ToList();
for (int i = 0; i < oOnsaleLevelDiscount.Count; i++)
{
if (i == oOnsaleLevelDiscount.Count - 1)
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString();
}
else
{
strLevelDiscount = strLevelDiscount + oOnsaleLevelDiscount.ElementAt(i).UserLevel.Code + ":" + oOnsaleLevelDiscount.ElementAt(i).Discount.ToString() + ";";
}
}
oNewProductOnTemplate.LevelDiscount = strLevelDiscount;
oNewProductOnTemplate.Remark = oBackTemplate.Remark;
dbEntity.SaveChanges();
bOnTemplateSave = false;
}
}
}
return "success";
}
/// <summary>
/// 返回添加模板的页面
/// </summary>
/// <returns></returns>
public ActionResult ProductOnsaleTemplateAdd()
{
ProductOnTemplate oProuctOnTemplate = new ProductOnTemplate { Name = NewResource(ModelEnum.ResourceType.STRING, organizationGuid) };
ProductOnSale oProductOnSale = dbEntity.ProductOnSales.Include("Product").Where(p => p.Gid == selectedPuOnSaleGuid && p.Deleted == false).FirstOrDefault();
bOnTemplateSave = false;
ViewBag.ProductCode = oProductOnSale.Product.Code;
ViewBag.ProductOnsaleCode = oProductOnSale.Code;
return View(oProuctOnTemplate);
}
public string ProductTemplateOnSale(MemberOrganization oOrgan, MemberChannel oChannel, ProductOnTemplate oTemplate,
ProductInformation oProduct, List<Object> oItemList = null)
{
//判断是否存在SKU列表，如果不存在SKU列表，则只添加产品上架相关的信息；
//否则既添加产品上架信息，还要添加SKU上架表的信息。
ProductOnSale oProductOnsale;
Guid currentOnsaleGid;
Guid productGid = oProduct.Gid;
Guid onSaleChID = oChannel.Gid;
Guid onSaleOrgID = oOrgan.Gid;
//ProductInformation oProduct = dbEntity.ProductInformations.Include("SkuItems").Where(p => p.Gid == productGid && p.Deleted == false).FirstOrDefault();
String productOnsaleCode = oProduct.Code;
ProductOnSale productOnsale = dbEntity.ProductOnSales.Where(p => p.ProdID == productGid && p.ChlID == onSaleChID && p.Code == productOnsaleCode).FirstOrDefault();
//为新上架商品
if (productOnsale == null)
{
oProductOnsale = new ProductOnSale();
#region 模板上架ProductOnsale表信息添加
oProductOnsale.ProdID = productGid;
oProductOnsale.OrgID = onSaleChID;
oProductOnsale.ChlID = onSaleChID;
oProductOnsale.Code = productOnsaleCode;
oProductOnsale.Ostatus = 1;
oProductOnsale.aName = (Guid)oProduct.aName;
oProductOnsale.Mode = oProduct.Mode;
//=====市场价以及销售价======
//=========================
//oProductOnsale.CanSplit = oProduct.Block;
oProductOnsale.aBrief = oProduct.aBrief;
oProductOnsale.aMatter = oProduct.aMatter;
dbEntity.ProductOnSales.Add(oProductOnsale);
dbEntity.SaveChanges();
//当前上架商品的OnsaleID
currentOnsaleGid = oProductOnsale.Gid;
#endregion
#region 模板上架ProductOnItems表信息添加
Guid marketPriceGid;
Guid salePriceGid;
//保存SKU的信息，如果存在SKU
if (oItemList != null)
{
foreach (Dictionary<string, object> item in oItemList)
{
//保存进入ProductOnItem表
ProductInfoItem oInfoItem = (ProductInfoItem)item["SkuItem"];
ProductOnItem oNewProductItem = new ProductOnItem();
oNewProductItem.OnSaleID = currentOnsaleGid;
oNewProductItem.SkuID = oInfoItem.Gid;
oNewProductItem.aFullName = oInfoItem.aFullName;
oNewProductItem.aShortName = oInfoItem.aShortName;
dbEntity.ProductOnItems.Add(oNewProductItem);
dbEntity.SaveChanges();
//获取当前保存的OnSKUID
Guid currentOnSKUGid = oNewProductItem.Gid;
GeneralMeasureUnit oUnit = (GeneralMeasureUnit)item["Unit"];
Guid currentUnitGid = oUnit.Gid;
GeneralMeasureUnit oCurrency1 = (GeneralMeasureUnit)item["Currency1"];
//第一个价格不存在则认为添加失败
if (oCurrency1 != null)
{
GeneralResource oMarketCash = new GeneralResource();
oMarketCash.Rtype = (byte)ModelEnum.ResourceType.MONEY;
oMarketCash.Currency = oCurrency1.Gid;
oMarketCash.Cash = (decimal)item["MarketPrice1"];
GeneralResource oSaleCash = new GeneralResource();
oSaleCash.Rtype = (byte)ModelEnum.ResourceType.MONEY;
oSaleCash.Currency = oCurrency1.Gid;
oSaleCash.Cash = (decimal)item["SalePrice1"];
dbEntity.GeneralResources.Add(oMarketCash);
dbEntity.GeneralResources.Add(oSaleCash);
dbEntity.SaveChanges();
marketPriceGid = oMarketCash.Gid;
salePriceGid = oSaleCash.Gid;
GeneralMeasureUnit oCurrency2 = (GeneralMeasureUnit)item["Currency2"];
if (oCurrency2 != null)
{
GeneralResItem oMarketResItem1 = new GeneralResItem();
oMarketResItem1.ResID = marketPriceGid;
oMarketResItem1.Currency = oCurrency2.Gid;
oMarketResItem1.Cash = (decimal)item["MarketPrice2"];
GeneralResItem oSaleResItem1 = new GeneralResItem();
oSaleResItem1.ResID = salePriceGid;
oSaleResItem1.Currency = oCurrency2.Gid;
oSaleResItem1.Cash = (decimal)item["SalePrice2"];
dbEntity.GeneralResItems.Add(oMarketResItem1);
dbEntity.GeneralResItems.Add(oSaleResItem1);
dbEntity.SaveChanges();
}
GeneralMeasureUnit oCurrency3 = (GeneralMeasureUnit)item["Currency3"];
if (oCurrency3 != null)
{
GeneralResItem oMarketResItem2 = new GeneralResItem();
oMarketResItem2.ResID = marketPriceGid;
oMarketResItem2.Currency = oCurrency3.Gid;
oMarketResItem2.Cash = (decimal)item["MarketPrice3"];
GeneralResItem oSaleResItem2 = new GeneralResItem();
oSaleResItem2.ResID = salePriceGid;
oSaleResItem2.Currency = oCurrency3.Gid;
oSaleResItem2.Cash = (decimal)item["SalePrice3"];
dbEntity.GeneralResItems.Add(oMarketResItem2);
dbEntity.GeneralResItems.Add(oSaleResItem2);
dbEntity.SaveChanges();
}
GeneralMeasureUnit oCurrency4 = (GeneralMeasureUnit)item["Currency4"];
if (oCurrency3 != null)
{
GeneralResItem oMarketResItem3 = new GeneralResItem();
oMarketResItem3.ResID = marketPriceGid;
oMarketResItem3.Currency = oCurrency3.Gid;
oMarketResItem3.Cash = (decimal)item["MarketPrice4"];
GeneralResItem oSaleResItem3 = new GeneralResItem();
oSaleResItem3.ResID = salePriceGid;
oSaleResItem3.Currency = oCurrency3.Gid;
oSaleResItem3.Cash = (decimal)item["SalePrice4"];
dbEntity.GeneralResItems.Add(oMarketResItem3);
dbEntity.GeneralResItems.Add(oSaleResItem3);
dbEntity.SaveChanges();
}
//添加到UnitPrice表里
ProductOnUnitPrice oProductOnUnitPrice = new ProductOnUnitPrice();
oProductOnUnitPrice.OnSkuID = currentOnSKUGid;
oProductOnUnitPrice.aShowUnit = currentUnitGid;
oProductOnUnitPrice.aMarketPrice = marketPriceGid;
oProductOnUnitPrice.aSalePrice = salePriceGid;
oProductOnUnitPrice.UnitRatio = (decimal)item["Ratio"];
oProductOnUnitPrice.Percision = (byte)item["Percision"];
dbEntity.ProductOnUnitPrices.Add(oProductOnUnitPrice);
dbEntity.SaveChanges();
}
}
}
else
{
for (int i = 0; i < oProduct.SkuItems.Count; i++)
{
ProductOnItem oNewProductItem = new ProductOnItem();
oNewProductItem.OnSaleID = currentOnsaleGid;
oNewProductItem.SkuID = oProduct.SkuItems.ElementAt(i).Gid;
oNewProductItem.aFullName = oProduct.SkuItems.ElementAt(i).aFullName;
oNewProductItem.aShortName = oProduct.SkuItems.ElementAt(i).aShortName;
dbEntity.ProductOnItems.Add(oNewProductItem);
dbEntity.SaveChanges();
//加入价套信息
Guid stdUnitGid = oProduct.SkuItems.ElementAt(i).StdUnit;
ProductOnUnitPrice oNewUnitPrice = new ProductOnUnitPrice();
oNewUnitPrice.OnSkuID = oNewProductItem.Gid;
oNewUnitPrice.aShowUnit = stdUnitGid;
GeneralResource oMarketCash = new GeneralResource();
oMarketCash.Rtype = (byte)ModelEnum.ResourceType.MONEY;
oMarketCash.Currency = oProduct.SkuItems.ElementAt(i).MarketPrice.Currency;
oMarketCash.Cash = oProduct.SkuItems.ElementAt(i).MarketPrice.Cash;
GeneralResource oSaleCash = new GeneralResource();
oSaleCash.Rtype = (byte)ModelEnum.ResourceType.MONEY;
oSaleCash.Currency = oProduct.SkuItems.ElementAt(i).SuggestPrice.Currency;
oSaleCash.Cash = oProduct.SkuItems.ElementAt(i).SuggestPrice.Cash;
dbEntity.GeneralResources.Add(oMarketCash);
dbEntity.GeneralResources.Add(oSaleCash);
dbEntity.SaveChanges();
marketPriceGid = oMarketCash.Gid;
salePriceGid = oSaleCash.Gid;
oNewUnitPrice.aMarketPrice = marketPriceGid;
oNewUnitPrice.aSalePrice = salePriceGid;
Guid oldMarketGid = oProduct.SkuItems.ElementAt(i).MarketPrice.Gid;
List<GeneralResItem> listMarketPrice = dbEntity.GeneralResItems.Where(p => p.ResID == oldMarketGid && p.Deleted == false).ToList();
for (int j = 0; j < listMarketPrice.Count; j++)
{
GeneralResItem newMarketPrice = new GeneralResItem();
newMarketPrice.ResID = marketPriceGid;
newMarketPrice.Currency = listMarketPrice.ElementAt(j).Currency;
newMarketPrice.Cash = listMarketPrice.ElementAt(j).Cash;
dbEntity.GeneralResItems.Add(newMarketPrice);
dbEntity.SaveChanges();
}
Guid oldSaleGid = oProduct.SkuItems.ElementAt(i).SuggestPrice.Gid;
List<GeneralResItem> listSalePrice = dbEntity.GeneralResItems.Where(p => p.ResID == oldSaleGid && p.Deleted == false).ToList();
for (int j = 0; j < listSalePrice.Count; j++)
{
GeneralResItem newSalePrice = new GeneralResItem();
newSalePrice.ResID = salePriceGid;
newSalePrice.Currency = listSalePrice.ElementAt(j).Currency;
newSalePrice.Cash = listSalePrice.ElementAt(j).Cash;
dbEntity.GeneralResItems.Add(newSalePrice);
dbEntity.SaveChanges();
}
dbEntity.ProductOnUnitPrices.Add(oNewUnitPrice);
dbEntity.SaveChanges();
}
}
#endregion
#region 根据数据库中取出的模板对上架商品进行赋值
Guid onSaleTemplateGid = oTemplate.Gid;
ProductOnTemplate oCurrentTemplate = dbEntity.ProductOnTemplates.Where(p => p.Gid == onSaleTemplateGid && p.Deleted == false).FirstOrDefault();
if (oCurrentTemplate != null)
{
string strShipPolicy = oCurrentTemplate.ShipPolicy;
string strPayPolicy = oCurrentTemplate.PayPolicy;
string strRelation = oCurrentTemplate.Relation;
string strLevelDiscount = oCurrentTemplate.LevelDiscount;
//将承运商信息和地区信息存入数据库
Guid onSaleShippingGid = new Guid();
string[] shippingInfo = strShipPolicy.Split(';');
for (int i = 0; i < shippingInfo.Count(); i++)
{
string[] currentShipAndAreaInfo = shippingInfo[i].Split(':');
//承运商代码
string currentShipCode = currentShipAndAreaInfo[0].Split('|')[0];
//承运商权重
string currentShipWeight = currentShipAndAreaInfo[0].Split('|')[1];
//承运商计费方案
string currentShipSolution = currentShipAndAreaInfo[0].Split('|')[2];
//承运商地区信息
string[] currentShipAreaList = currentShipAndAreaInfo[1].Split(',');
//保存承运商信息
//如果承运商信息不为空，保存信息；否则不做操作。
if (currentShipAndAreaInfo[0] != "")
{
ProductOnShipping oNewProductOnShipping = new ProductOnShipping();
oNewProductOnShipping.OnSaleID = currentOnsaleGid;
byte bOrgType = (byte)ModelEnum.OrganizationType.SHIPPER;
//判断承运商信息是否在数据库中已删除
ShippingInformation oCurrentShippingInfomation = dbEntity.ShippingInformations.Where(p => p.Code == currentShipCode && p.aParent == onSaleOrgID && p.Otype == bOrgType && p.Deleted == false).FirstOrDefault();
if (oCurrentShippingInfomation != null)
{
Guid currentShippingID = oCurrentShippingInfomation.Gid;
oNewProductOnShipping.ShipID = currentShippingID;
oNewProductOnShipping.ShipWeight = Int32.Parse(currentShipWeight);
oNewProductOnShipping.Solution = byte.Parse(currentShipSolution);
dbEntity.ProductOnShippings.Add(oNewProductOnShipping);
dbEntity.SaveChanges();
onSaleShippingGid = oNewProductOnShipping.Gid;
//将对应的承运商的区域存入ProductOnShipArea表
//如果承运商地区信息不为空，保存信息；否则不做操作。
if (currentShipAreaList[0] != "")
{
for (int j = 0; j < currentShipAreaList.Count(); j++)
{
Guid currentRegionGid = Guid.Parse(currentShipAreaList[j]);
//判断数据库中地区是否存在
GeneralRegion oRegion = dbEntity.GeneralRegions.Where(p => p.Gid == currentRegionGid && p.Deleted == false).FirstOrDefault();
if (oRegion != null)
{
ProductOnShipArea oNewShipArea = new ProductOnShipArea();
oNewShipArea.RegionID = currentRegionGid;
oNewShipArea.OnShip = onSaleShippingGid;
dbEntity.ProductOnShipAreas.Add(oNewShipArea);
dbEntity.SaveChanges();
}
else
{
continue;
}
}
}
else
{
continue;
}
}
else
{
continue;
}
}
else
{
continue;
}
}
//将相关的支付方式存入数据库
string[] paymentList = strPayPolicy.Split(';');
//如果有支付方式，则将支付方式写入数据库；否则不保存。
if (paymentList[0] != "")
{
for (int i = 0; i < paymentList.Count(); i++)
{
string strPaymentCode = paymentList[i];
//判断支付方式在数据库中是否存在
FinancePayType oPaytype = dbEntity.FinancePayTypes.Where(p => p.OrgID == onSaleOrgID && p.Code == strPaymentCode && p.Deleted == false).FirstOrDefault();
if (oPaytype != null)
{
Guid currentPaymentGid = oPaytype.Gid;
ProductOnPayment oProductOnPayment = new ProductOnPayment();
oProductOnPayment.OnSaleID = currentOnsaleGid;
oProductOnPayment.PayID = currentPaymentGid;
dbEntity.ProductOnPayments.Add(oProductOnPayment);
dbEntity.SaveChanges();
}
else
{
continue;
}
}
}
//将相关的商品信息存入数据库
string[] relationList = strRelation.Split(';');
//判断是否存在关联商品信息
if (relationList[0] != "")
{
for (int i = 0; i < relationList.Count(); i++)
{
Guid relationProductGid = Guid.Parse(relationList[i].Split('|')[0]);
byte relationType = byte.Parse(relationList[i].Split('|')[1]);
ProductOnSale oRelationProductOnSale = dbEntity.ProductOnSales.Where(p => p.Gid == relationProductGid && p.Deleted == false).FirstOrDefault();
if (oRelationProductOnSale != null)
{
ProductOnRelation oProductOnRelation = new ProductOnRelation();
oProductOnRelation.OnSaleID = currentOnsaleGid;
oProductOnRelation.aOnRelation = relationProductGid;
oProductOnRelation.Rtype = relationType;
dbEntity.ProductOnRelations.Add(oProductOnRelation);
dbEntity.SaveChanges();
}
else
{
continue;
}
}
}
//将相关的会员打折信息存入数据库
string[] levelDiscountList = strLevelDiscount.Split(';');
//判断是否存在会员打折信息
if (levelDiscountList[0] != "")
{
for (int i = 0; i < levelDiscountList.Count(); i++)
{
string strMemberCode = levelDiscountList[i].Split(':')[0];
decimal decDiscount = Decimal.Parse(levelDiscountList[i].Split(':')[1]);
MemberLevel oMemberLevel = dbEntity.MemberLevels.Where(p => p.Code == strMemberCode && p.Deleted == false).FirstOrDefault();
if (oMemberLevel != null)
{
Guid memberLevelGid = oMemberLevel.Gid;
ProductOnLevelDiscount oProductOnLevelDiscount = new ProductOnLevelDiscount();
oProductOnLevelDiscount.OnSaleID = currentOnsaleGid;
oProductOnLevelDiscount.aUserLevel = memberLevelGid;
oProductOnLevelDiscount.Discount = decDiscount;
dbEntity.ProductOnLevelDiscounts.Add(oProductOnLevelDiscount);
dbEntity.SaveChanges();
}
else
{
continue;
}
}
}
}
#endregion
}
else
{
//存在上架的商品，同时还是可用状态，则提示用户不能重复上架
if (productOnsale.Deleted == false)
{
return "fail";
}
else
{
//==================ToDo===================
//#region 恢复原来的上架信息
////上架商品表信息恢复
//productOnsale.Deleted = false;
//currentOnsaleGid = productOnsale.Gid;
////上架SKU信息恢复
//List<ProductOnItem> listProductOnItem = dbEntity.ProductOnItems.Where(p => p.OnSaleID == currentOnsaleGid).ToList();
//foreach (ProductOnItem productOnItem in listProductOnItem)
//{
// productOnItem.Deleted = false;
//}
////上架承运商信息恢复
//List<ProductOnShipping> listProductOnShipping = dbEntity.ProductOnShippings.Where(p => p.OnSaleID == currentOnsaleGid).ToList();
//foreach (ProductOnShipping productOnShipping in listProductOnShipping)
//{
// productOnShipping.Deleted = false;
// Guid deleteShipGid = productOnShipping.Gid;
// //上架承运商地区信息恢复
// List<ProductOnShipArea> listProductOnShipArea = dbEntity.ProductOnShipAreas.Where(p => p.OnShip == deleteShipGid).ToList();
// foreach (ProductOnShipArea productShipArea in listProductOnShipArea)
// {
// productShipArea.Deleted = false;
// }
//}
////上架支付方式信息恢复
//List<ProductOnPayment> listProductOnPayment = dbEntity.ProductOnPayments.Where(p => p.OnSaleID == currentOnsaleGid).ToList();
//foreach (ProductOnPayment productOnPayment in listProductOnPayment)
//{
// productOnPayment.Deleted = false;
//}
////上架关联商品信息恢复
//List<ProductOnRelation> listProductOnRelation = dbEntity.ProductOnRelations.Where(p => p.OnSaleID == currentOnsaleGid).ToList();
//foreach (ProductOnRelation productOnRelation in listProductOnRelation)
//{
// productOnRelation.Deleted = false;
//}
////上架会员打折信息恢复
//List<ProductOnLevelDiscount> listProductOnLevelDiscount = dbEntity.ProductOnLevelDiscounts.Where(p => p.OnSaleID == currentOnsaleGid).ToList();
//foreach (ProductOnLevelDiscount productOnLevelDiscount in listProductOnLevelDiscount)
//{
// productOnLevelDiscount.Deleted = false;
//}
//#endregion
}
}
return "success";
}
