public ReturnType AddPayCharge(PayCharge paycharge)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToPayCharge(paycharge);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType AddInOutAndDetails(StockInOut stockInOut, PayCharge payChage, List <StockDetail> sdList, List <StockHouseProduct> shpList, List <View_StockItemProduct> vsipList)
{
System.Data.Common.DbTransaction tran = null;
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
try
{
alading.Connection.Open();
tran = alading.Connection.BeginTransaction();
alading.AddToPayCharge(payChage);
alading.AddToStockInOut(stockInOut);
foreach (StockDetail sd in sdList)
{
alading.AddToStockDetail(sd);
}
foreach (StockHouseProduct shp in shpList)
{
StockHouseProduct tmpshp = alading.StockHouseProduct.FirstOrDefault(c => c.HouseProductCode == shp.HouseProductCode);
if (tmpshp != null)
{
tmpshp.Num = shp.Num;
}
else
{
alading.AddToStockHouseProduct(shp);
}
}
foreach (View_StockItemProduct vsip in vsipList)
{
StockItem stockItem = alading.StockItem.FirstOrDefault(s => s.OuterID == vsip.OuterID);
StockProduct stockProduct = alading.StockProduct.FirstOrDefault(s => s.SkuOuterID == vsip.SkuOuterID);
stockItem.TotalQuantity = Math.Round(vsip.TotalQuantity, 3);
stockProduct.SkuQuantity = vsip.SkuQuantity;
stockProduct.LastStockPrice = vsip.LastStockPrice;
stockProduct.AvgStockPrice = vsip.AvgStockPrice;
}
alading.SaveChanges();
tran.Commit();
return(ReturnType.Success);
}
catch (System.Exception ex)
{
if (tran != null)
{
tran.Rollback();
}
return(ReturnType.SaveFailed);
}
finally
{
if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed)
{
alading.Connection.Close();
}
}
}
}
public ReturnType AddPayCharge(List <PayCharge> paychargeList)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
foreach (PayCharge paycharge in paychargeList)
{
alading.AddToPayCharge(paycharge);
}
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateTradeRefund(List <TradeRefund> tradeRefundList, List <StockProduct> stockProductList, List <StockHouseProduct> houseProList
, List <StockInOut> stockInOutList, List <StockDetail> stockDetailList, PayCharge payCharge, List <string> refundIdList
, List <string> outerSkuIdList, List <string> outerIdList)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*更新TradeRefund*/
var refundResult = alading.TradeRefund.Where(BuildWhereInExpression <TradeRefund, string>(v => v.refund_id, refundIdList));
if (refundResult == null)
{
return(ReturnType.NotExisted);
}
foreach (TradeRefund tradeRefund in tradeRefundList)//需要更新的新数据
{
TradeRefund oldRefund = refundResult.Where(c => c.refund_id == tradeRefund.refund_id).FirstOrDefault();
//TradeRefundCopydata(oldRefund, tradeRefund);
oldRefund.IsRecieved = tradeRefund.IsRecieved;
oldRefund.LocalPrivyC = tradeRefund.LocalPrivyC;
}
/*更新StockProduct 和 StockItem*/
var stockProductResult = alading.StockProduct.Where(BuildWhereInExpression <StockProduct, string>(v => v.SkuOuterID, outerSkuIdList));
var stockItemResult = alading.StockItem.Where(BuildWhereInExpression <StockItem, string>(v => v.OuterID, outerIdList));
if (stockProductResult == null || stockItemResult == null)
{
return(ReturnType.NotExisted);
}
foreach (StockProduct stockProduct in stockProductList)
{
//获取StockProduct的原始数据
StockProduct oldStockProduct = stockProductResult.Where(c => c.SkuOuterID == stockProduct.SkuOuterID).FirstOrDefault();
//获取StockItem的原始数据
StockItem oldStockItem = stockItemResult.Where(c => c.OuterID == stockProduct.OuterID).FirstOrDefault();
if (oldStockProduct != null && oldStockItem != null)
{
//获取StockProduct的相关原始数据的商品数量
oldStockProduct.SkuQuantity = oldStockProduct.SkuQuantity + stockProduct.SkuQuantity;
//获取oldStockItem的相关原始数据的商品数量
oldStockItem.TotalQuantity = oldStockItem.TotalQuantity + stockProduct.SkuQuantity;
}
else
{
return(ReturnType.NotExisted);
}
}
/*添加或更新StockHouseProduct*/
var stockHouseProResult = alading.StockHouseProduct.Where(BuildWhereInExpression <StockHouseProduct, string>(v => v.SkuOuterID, outerSkuIdList));
foreach (StockHouseProduct stockHousePro in houseProList)
{
StockHouseProduct oldPro = stockHouseProResult.Where(c => c.SkuOuterID == stockHousePro.SkuOuterID &&
c.HouseCode == stockHousePro.HouseCode && c.LayoutCode == stockHousePro.LayoutCode).FirstOrDefault();
if (oldPro != null)
{
oldPro.Num += stockHousePro.Num;
}
else
{
stockHousePro.HouseProductCode = Guid.NewGuid().ToString();
alading.AddToStockHouseProduct(stockHousePro);
}
}
/*添加StockInOut*/
foreach (StockInOut stockInOut in stockInOutList)
{
alading.AddToStockInOut(stockInOut);
}
/*添加StockDetail*/
foreach (StockDetail stockDetail in stockDetailList)
{
alading.AddToStockDetail(stockDetail);
}
alading.AddToPayCharge(payCharge);
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateStock(List <StockProduct> stockProductList, List <StockHouseProduct> stockHouseProList, List <StockInOut> stockInOutList
, List <StockDetail> stockDetailList, PayCharge payCharge, List <string> outerSkuIdList, List <string> outerIdList)//zxl
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
#region 更新StockProduct 和 StockItem
var stockProductResult = alading.StockProduct.Where(BuildWhereInExpression <StockProduct, string>(v => v.SkuOuterID, outerSkuIdList));
var stockItemResult = alading.StockItem.Where(BuildWhereInExpression <StockItem, string>(v => v.OuterID, outerIdList));
if (stockProductResult == null || stockItemResult == null)
{
return(ReturnType.NotExisted);
}
foreach (StockProduct stockProduct in stockProductList)
{
//获取StockProduct的原始数据
StockProduct oldStockProduct = stockProductResult.Where(c => c.SkuOuterID == stockProduct.SkuOuterID).FirstOrDefault();
//获取StockItem的原始数据
StockItem oldStockItem = stockItemResult.Where(c => c.OuterID == stockProduct.OuterID).FirstOrDefault();
//获取StockProduct的相关原始数据的商品数量
oldStockProduct.SkuQuantity += stockProduct.SkuQuantity;
//获取oldStockItem的相关原始数据的商品数量
oldStockItem.TotalQuantity += stockProduct.SkuQuantity;
}
#endregion
#region 添加或更新StockHouseProduct
var stockHouseProResult = alading.StockHouseProduct.Where(BuildWhereInExpression <StockHouseProduct, string>(v => v.SkuOuterID, outerSkuIdList));
foreach (StockHouseProduct stockHousePro in stockHouseProList)
{
StockHouseProduct oldPro = stockHouseProResult.Where(c => c.SkuOuterID == stockHousePro.SkuOuterID &&
c.HouseCode == stockHousePro.HouseCode && c.LayoutCode == stockHousePro.LayoutCode).FirstOrDefault();
if (oldPro != null)
{
oldPro.Num += stockHousePro.Num;
}
else
{
stockHousePro.HouseProductCode = Guid.NewGuid().ToString();
alading.AddToStockHouseProduct(stockHousePro);
}
}
#endregion
#region 添加StockInOut
foreach (StockInOut stockInOut in stockInOutList)
{
alading.AddToStockInOut(stockInOut);
}
#endregion
#region 添加StockDetail
foreach (StockDetail stockDetail in stockDetailList)
{
alading.AddToStockDetail(stockDetail);
}
#endregion
#region 添加PayCharge
alading.AddToPayCharge(payCharge);
#endregion
alading.SaveChanges();
return(ReturnType.Success);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
