/// <summary>
/// 设置购物车商品数量
/// </summary>
/// <param name="user_id"></param>
/// <param name="guid"></param>
/// <param name="shoppingCartId"></param>
/// <param name="num"></param>
/// <returns></returns>
public bool SetShoppingCartGoodsNum(int user_id, string guid, int shoppingCartId, int num)
{
var result = false;
if (num > 0)
{
using (var holycaDb = new HolycaEntities())
{
var shoppingCartEntity = holycaDb.Sale_ShoppingCart.First(s => s.intShopCartID == shoppingCartId);
if (shoppingCartEntity != null)
{
try
{
shoppingCartEntity.intBuyCount = num;
holycaDb.SaveChanges();
result = true;
}
catch (Exception)
{
holycaDb.Refresh(RefreshMode.ClientWins, shoppingCartEntity);
holycaDb.SaveChanges();
result = false;
}
}
}
}
return(result);
}
/// <summary>
/// 添加会员收货地址
/// </summary>
/// <param name="addressEntity"></param>
/// <returns></returns>
public int AddMemberAddress(User_Consignee_Address addressEntity)
{
using (var holycaDb = new HolycaEntities())
{
holycaDb.AddToUser_Consignee_Address(addressEntity);
holycaDb.SaveChanges();
return(addressEntity.intAddressID);
}
}
/// <summary>
/// 删除购物车中的商品信息
/// </summary>
/// <param name="shoppingCartId">购物车ID</param>
/// <returns></returns>
public bool DeleteShoppingCartByProductIdUserID(int shoppingCartId)
{
var holycaDb = new HolycaEntities();
Sale_ShoppingCart queryTxt = holycaDb.Sale_ShoppingCart.Where(c => c.intShopCartID == shoppingCartId).FirstOrDefault();
holycaDb.DeleteObject(queryTxt);
holycaDb.SaveChanges();
return(true);
}
/// <summary>
/// 清除购物车数据
/// </summary>
/// <param name="userId"></param>
public void ClearShoppingCart(int userId)
{
using (var db = new HolycaEntities())
{
var queryTxt = from a in db.Sale_ShoppingCart
where a.intUserID == userId
select a;
var shoppingCartList = queryTxt.ToList();
foreach (var saleShoppingCart in shoppingCartList)
{
db.Sale_ShoppingCart.DeleteObject(saleShoppingCart);
}
db.SaveChanges();
}
}
/// <summary>
/// 增加购物车商品信息
/// </summary>
/// <param name="shoppingCartEntity">购物车信息实体</param>
/// <returns></returns>
public bool AddShoppingCartProductInfo(ShoppingCartEntity shoppingCartEntity)
{
var holycaDb = new HolycaEntities();
Sale_ShoppingCart sale_ShoppingCart = new Sale_ShoppingCart();
MCvHelper.ObjectCopyTo(shoppingCartEntity, sale_ShoppingCart);
try
{
holycaDb.Sale_ShoppingCart.AddObject(sale_ShoppingCart);
holycaDb.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 更新会员收货地址
/// </summary>
/// <param name="id"></param>
/// <param name="addressEntity"></param>
/// <returns></returns>
public bool UpdateMemberAddress(int id, User_Consignee_Address addressEntity)
{
var result = false;
using (var holycaDb = new HolycaEntities())
{
try
{
var addressInfo = holycaDb.User_Consignee_Address.FirstOrDefault(c => c.intAddressID == id);
if (addressInfo != null && addressInfo.intAddressID > 0)
{
addressInfo.intAddrType = addressEntity.intAddrType;
addressInfo.intCityID = addressEntity.intCityID;
addressInfo.intCountyID = addressEntity.intCountyID;
addressInfo.intStateID = addressEntity.intStateID;
addressInfo.vchCAName = addressEntity.vchCAName;
addressInfo.vchCityName = addressEntity.vchCityName;
addressInfo.vchConsignee = addressEntity.vchConsignee;
addressInfo.vchCountyName = addressEntity.vchCountyName;
addressInfo.vchDetailAddr = addressEntity.vchDetailAddr;
addressInfo.vchMobile = addressEntity.vchMobile;
addressInfo.vchPhone = addressEntity.vchPhone;
addressInfo.vchPostCode = addressEntity.vchPostCode;
addressInfo.vchStateName = addressEntity.vchStateName;
addressInfo.intIsDefaultAddr = addressInfo.intIsDefaultAddr;
addressInfo.dtLastModTime = addressEntity.dtLastModTime;
//holycaDb.ApplyCurrentValues("User_Consignee_Address", addressInfo);
holycaDb.SaveChanges();
result = true;
}
}
catch (Exception)
{
result = false;
}
}
return(result);
}
/// <summary>
/// 重置用户全部地址默认状态为 0 （非默认地址）
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public bool ReSetAddressDefaultStatus(int userId)
{
var result = false;
using (var holycaDb = new HolycaEntities())
{
try
{
var defAddressList = holycaDb.User_Consignee_Address.Where(c => c.intUserID == userId && c.intIsDefaultAddr == 1).ToList();
if (defAddressList.Any())
{
defAddressList.ForEach(item => item.intIsDefaultAddr = 0);
holycaDb.SaveChanges();
}
}
catch (Exception)
{
result = false;
}
}
return(result);
}
/// <summary>
/// 设置用户默认收货地址
/// </summary>
/// <param name="userId"></param>
/// <param name="addressId"></param>
/// <returns></returns>
public bool SetDefaultAddress(int userId, int addressId)
{
var result = false;
using (var holycaDb = new HolycaEntities())
{
try
{
ReSetAddressDefaultStatus(userId);
var address = holycaDb.User_Consignee_Address.First(c => c.intAddressID == addressId);
if (address != null && address.intAddressID > 0)
{
address.intIsDefaultAddr = 1;
holycaDb.SaveChanges();
result = true;
}
}
catch (Exception)
{
result = false;
}
}
return(result);
}
/// <summary>
/// 创建订单
/// </summary>
/// <param name="order"></param>
/// <param name="invoice"></param>
/// <param name="deliver"></param>
/// <param name="orderProm"></param>
/// <param name="userId"></param>
/// <param name="guid"></param>
/// <param name="channelId"></param>
/// <param name="clusterId"></param>
/// <param name="promID"></param>
/// <param name="message"></param>
/// <returns></returns>
public int SaveWebOrder(Sale_Order order, Sale_Order_Invoice invoice, Sale_Order_Deliver deliver, Sale_Order_Prom_Rela orderProm,
int userId, string guid, int channelId, int clusterId, int promID, out string message)
{
var orderNo = -1;
message = "";
var order_rela = new List <Sale_Order_Prom_Rela>();
using (var ctx = new HolycaEntities())
{
using (var cart = new HolycaEntities())
{
ctx.Connection.Open();
var tran = ctx.Connection.BeginTransaction();
try
{
//保存订单主表
ctx.Sale_Order.AddObject(order);
//先提交得到订单编号
ctx.SaveChanges();
//返回订单编号
orderNo = order.intOrderNO;
#region 保存发票表
if (invoice != null)
{
invoice.vchOrderCode = order.vchOrderCode;
invoice.dtCreateDate = DateTime.Now;
invoice.dtBillingTime = DateTime.Now;
ctx.Sale_Order_Invoice.AddObject(invoice);
}
#endregion
Sale_Order_Detail item = null;
//获取购物车信息
var all = from cartItem in cart.Sale_ShoppingCart where cartItem.intUserID == userId && cartItem.intChannelID == channelId && cartItem.intIsDelete == 0 select cartItem;
var v = from allitem in all where (allitem.intProductType == null || allitem.intProductType == 0) select allitem;
if (v.Any())
{
decimal totalMoney = 0;
foreach (var cartItem in v)
{
#region 购物车转订单明细
item = new Sale_Order_Detail();
item.numTotalAmount = ((decimal?)cartItem.numSalePrice ?? 0) * cartItem.intBuyCount;
if (invoice != null)
{
item.intIsInvoice = 1;
}
else
{
item.intIsInvoice = 0;
}
item.numCleanCost = 0;
item.numCost = 0;
item.intBaseStar = (int?)cartItem.intOrgScore ?? 0;
item.intUserID = userId;
item.dtOpDate = DateTime.Now;
item.vchOrderCode = order.vchOrderCode;
item.numStandarPrice = cartItem.numOrgPrice;
item.numSalePrice = cartItem.numSalePrice;
item.intHerdPriceID = clusterId;
item.intProductID = cartItem.intProductID;
item.vchProductName = cartItem.nchProductName;
item.vchProductPrinted = cartItem.vchProductPrinted;
if (promID > 0)
{
if (cartItem.intPromID > 0)
{
item.intPromID = cartItem.intPromID ?? 0;
}
else
{
item.intPromID = promID;
}
}
else
{
item.intPromID = cartItem.intPromID ?? 0;
}
item.intQty = cartItem.intBuyCount;
item.intRtnQty = 0;
item.intScores = (cartItem.intScore == 0 ? 0 : cartItem.intOrgScore) * cartItem.intBuyCount;
item.intChannel = channelId;
item.intStockID = order.intStockID;
//修复ckid为空的情况
item.intLogisticsID = 21;
ctx.Sale_Order_Detail.AddObject(item);
totalMoney += item.numTotalAmount;
#endregion
}
#region 促销处理
/*
* PromOrderRelation orderrelation = null;
* //保存满减促销的关系
* foreach (Sale_ShoppingCart cartItem in p)
* {
* orderrelation = new PromOrderRelation();
* orderrelation.vchOrderCode = order.vchOrderCode;
* orderrelation.intPromID = (int)cartItem.intPromID;
* orderrelation.numCouponAmount = cartItem.numSalePrice;
* ctx.PromOrderRelation.InsertOnSubmit(orderrelation);
* }
*
* //修改已经保存的满减和购物车关系中的订单号
* //var productrelation= from r in ctx.PromOrderProductRelation
* // from q in v
* // where r.intShopCartID == q.intShopCartID
* // select r;
* string intshopcartids = ",";
* foreach (Sale_ShoppingCart productid in v)
* {
* intshopcartids = intshopcartids + productid.intShopCartID.ToString() + ",";
* }
*
* var productrelation = ctx.PromOrderProductRelation.Where(c => intshopcartids.IndexOf("," + c.intShopCartID.ToString() + ",") >= 0).ToList();
* //保存满减促销的关系
* foreach (PromOrderProductRelation pre in productrelation)
* {
* pre.vchOrderCode = order.vchOrderCode;
* ctx.SubmitChanges();
* }
*/
#endregion
#region 货款+运费
if (order.numGoodsAmount != totalMoney - order.numCouponAmount || order.numReceAmount != totalMoney + order.numCarriage - order.numCouponAmount)
{
order.numGoodsAmount = totalMoney;
order.numReceAmount = totalMoney + order.numCarriage;
}
#endregion
#region 保存支付状态
var orderPayStatus = new Sale_Order_PayState();
orderPayStatus.intUserID = 555; //顾客
orderPayStatus.dtOpdate = DateTime.Now;
orderPayStatus.vchOrderCode = order.vchOrderCode;
orderPayStatus.intPayState = 0; //未付款
ctx.AddToSale_Order_PayState(orderPayStatus);
#endregion
#region 保存订单状态
var orderStatus = new Sale_Order_State();
orderStatus.intUserID = 555; //顾客
orderStatus.intOrderState = 1; //新建
orderStatus.dtOpdate = DateTime.Now;
orderStatus.vchOrderCode = order.vchOrderCode;
ctx.Sale_Order_State.AddObject(orderStatus);
#endregion
#region 保存销售订单配送信息
ctx.Sale_Order_Deliver.AddObject(deliver);
ctx.SaveChanges();
#endregion
#region 保存订单和促销关系
foreach (var rela_item in v)
{
var shopcart_rela = cart.Sale_ShopCart_Prom_Rela.FirstOrDefault(c => c.intShopCartID == rela_item.intShopCartID);
if (shopcart_rela != null)
{
orderProm = new Sale_Order_Prom_Rela();
orderProm.vchOrderCode = order.vchOrderCode;
orderProm.intChannelID = channelId;
orderProm.intUserID = userId;
orderProm.intProductID = rela_item.intProductID;
orderProm.intPromID = shopcart_rela.intPromID ?? 0;
orderProm.intDetailID = item.intDetailID;
orderProm.dtCreateDate = DateTime.Now;
ctx.Sale_Order_Prom_Rela.AddObject(orderProm);
}
}
#endregion
//提交所有更改
tran.Commit();
}
}
catch (Exception e)
{
orderNo = -1;
message = e.Message;
tran.Rollback();
}
}
}
return(orderNo);
}
