public void CanUseSmallWarehouse()
{
Game.CargoShips[0].Load(new List <IGood> {
new Tobacco()
});
Game.CargoShips[1].Load(new List <IGood> {
new Coffee()
});
Game.CargoShips[2].Load(new List <IGood> {
new Sugar()
});
var smallWarehouse = new SmallWarehouse();
smallWarehouse.AddWorker(new Colonist());
RoleOwner.Buildings.Add(smallWarehouse);
var goodCount = 7;
for (var i = 0; i < goodCount; i++)
{
RoleOwner.Goods.Add(new Indigo());
}
ReselectRole();
var storeGoods = new StoreGoods {
SmallWarehouse = GoodType.Indigo
};
CanExecuteActionOnce(storeGoods, RoleOwner);
Assert.Empty(RoleOwner.Goods);
RoleOwner.Role.CleanUp();
Assert.Equal(goodCount, RoleOwner.Goods.Count);
}
private void ExecuteStoreGoods(StoreGoods storeGoods, IPlayer player)
{
var largeWarehouse = GetLargeWarehouseOrDefault(player);
if (storeGoods.LargeWarehouse1.HasValue)
{
largeWarehouse?.StoreGoods(storeGoods.LargeWarehouse1.Value, player);
}
if (storeGoods.LargeWarehouse2.HasValue)
{
largeWarehouse?.StoreGoods(storeGoods.LargeWarehouse2.Value, player);
}
var smallWarehouse = GetSmallWarehouseOrDefault(player);
if (storeGoods.SmallWarehouse.HasValue)
{
smallWarehouse?.StoreGoods(storeGoods.SmallWarehouse.Value, player);
}
if (storeGoods.DefaultStorage.HasValue)
{
var goodToStore =
player.Goods.FirstOrDefault(g => g.Type == storeGoods.DefaultStorage.Value);
if (goodToStore != null)
{
_defaultStore[player.UserId] = goodToStore;
player.Goods.Remove(goodToStore);
}
}
SetPlayerPhase(player, EndedPhase);
}
public void CanStoreGoodsWithoutDelivering()
{
Game.CargoShips[0].Load(new List <IGood> {
new Tobacco()
});
Game.CargoShips[1].Load(new List <IGood> {
new Coffee()
});
Game.CargoShips[2].Load(new List <IGood> {
new Sugar()
});
for (var i = 0; i < 3; i++)
{
RoleOwner.Goods.Add(new Indigo());
}
ReselectRole();
var storeGoods = new StoreGoods {
DefaultStorage = GoodType.Indigo
};
CanExecuteActionOnce(storeGoods, RoleOwner);
Assert.Equal(2, RoleOwner.Goods.Count);
RoleOwner.Role.CleanUp();
Assert.Single(RoleOwner.Goods);
}
//查找订单列表-电商
public List <StoreAdminGoodsOrder> GetAdminListForStores(string where, int pagesize, int pageindex, out int totalCount, bool export = false, MySqlParameter[] param = null)
{
List <StoreAdminGoodsOrder> list = new List <StoreAdminGoodsOrder>();
string sql;
string sqlCount;
sql = $@"select orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,orders.AccepterName as NickName,orders.AccepterTelePhone as TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address,orders.buyMode,c.nickName as userName,l.name as levelname from storegoodsorder orders ";
sql += $"left join c_userinfo c on c.Id = orders.userid ";
sql += $"left join viprelation v on v.uid = orders.userid and v.state >=0 ";
sql += $"left join viplevel l on v.levelid = l.id and l.state >= 0 ";
sql += $"{(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by orders.Id desc {(pagesize == 0 ? "" : " limit " + (pageindex <= 0 ? 0 : pageindex - 1) * pagesize + "," + pagesize)}";
if (export)//导出Excel的话，不需要分页
{
sql = $@"select g.goodsname,s.count,s.price,orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,orders.AccepterName as NickName,orders.AccepterTelePhone as TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address,orders.buyMode,c.nickName as userName,l.name as levelname from storegoodsorder orders ";
sql += $"left join c_userinfo c on c.Id = orders.userid ";
sql += $"left join viprelation v on v.uid = orders.userid ";
sql += $"left join viplevel l on v.levelid = l.id ";
sql += $"left join storegoodscart s on orders.id = s.goodsorderid and s.state = 1 ";
sql += $"left join storegoods g on g.id = s.goodsid ";
sql += $"{(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by orders.Id desc ";
}
sqlCount = $@"select count(0) from storegoodsorder orders ";
sqlCount += $"left join c_userinfo c on c.Id = orders.userid ";
sqlCount += $"left join viprelation v on v.uid = orders.userid ";
sqlCount += $"left join viplevel l on v.levelid = l.id ";
sqlCount += $"{(string.IsNullOrEmpty(where) ? "" : " where " + where)}";
using (MySqlDataReader dr = SqlMySql.ExecuteDataReaderMaster(connName, CommandType.Text, sql, param))
{
while (dr.Read())
{
StoreAdminGoodsOrder model = GetModel(dr);
List <StoreGoodsCart> cartlist = StoreGoodsCartBLL.SingleModel.GetList($"GoodsOrderId={model.Id}");
List <StoreOrderCardDetail> detaillist = new List <StoreOrderCardDetail>();
foreach (StoreGoodsCart item in cartlist)
{
StoreOrderCardDetail cart = new StoreOrderCardDetail();
cart.Id = item.Id;
StoreGoods goods = StoreGoodsBLL.SingleModel.GetModel(item.GoodsId);
if (goods != null)
{
cart.GoodsName = goods.GoodsName;
cart.ImgUrl = goods.ImgUrl;
}
cart.SpecInfo = item.SpecInfo;
cart.Price = item.Price;
cart.Count = item.Count;
detaillist.Add(cart);
}
model.GoodsList = detaillist;
list.Add(model);
}
}
//totalCount = GetCountBySql(sqlCount);
totalCount = Convert.ToInt32(SqlMySql.ExecuteScalar(connName, CommandType.Text, sqlCount, param));
return(list);
}
/// <summary>
/// 根据模板类型返回填充模板内容(餐饮)
/// </summary>
/// <param name="OrderId"></param>
/// <param name="sendMsgType"></param>
/// <returns></returns>
public object getTemplateMessageData(int OrderId, SendTemplateMessageTypeEnum sendMsgType)
{
StoreGoodsOrder model = GetModel(OrderId) ?? new StoreGoodsOrder();
List <StoreGoodsCart> modelDtl = StoreGoodsCartBLL.SingleModel.GetList($" GoodsOrderId = {model.Id} ") ?? new List <StoreGoodsCart>();
string modelDtlName = "";
string goodsIds = string.Join(",", modelDtl.Select(s => s.GoodsId).Distinct());
List <StoreGoods> storeGoodsList = StoreGoodsBLL.SingleModel.GetListByIds(goodsIds);
modelDtl.ForEach(x =>
{
StoreGoods good = storeGoodsList?.FirstOrDefault(f => f.Id == x.GoodsId) ?? new StoreGoods();
x.goodsMsg = good;
});
modelDtlName = string.Join("+", modelDtl.Select(x => x.goodsMsg.GoodsName));
//店名
string storeName = "";
Store stroe = StoreBLL.SingleModel.GetModel(model.StoreId) ?? new Store();
List <ConfParam> paramslist = ConfParamBLL.SingleModel.GetListByRId(stroe.appId);
ConfParam cinfo = paramslist?.Where(w => w.Param == "nparam").FirstOrDefault();
if (cinfo != null)
{
storeName = cinfo.Value;
}
object postData = new object();
switch (sendMsgType)
{
case SendTemplateMessageTypeEnum.电商订单支付成功通知:
postData = new
{
keyword1 = new { value = model.OrderNum, color = "#000000" },
keyword2 = new { value = model.CreateDateStr, color = "#000000" },
keyword3 = new { value = modelDtlName, color = "#000000" },
keyword4 = new { value = model.PayDateStr, color = "#000000" },
keyword5 = new { value = Enum.GetName(typeof(miniAppBuyMode), model.buyMode), color = "#000000" },
keyword6 = new { value = model.BuyPriceStr, color = "#000000" },
keyword7 = new { value = Enum.GetName(typeof(OrderState), model.State), color = "#000000" },
};
break;
case SendTemplateMessageTypeEnum.电商订单配送通知:
postData = new
{
keyword1 = new { value = model.CreateDateStr, color = "#000000" },
keyword2 = new { value = storeName, color = "#000000" },
keyword3 = new { value = model.OrderNum, color = "#000000" },
keyword4 = new { value = model.Address, color = "#000000" },
keyword5 = new { value = model.DistributeDateStr, color = "#000000" },
keyword6 = new { value = modelDtlName, color = "#000000" },
keyword7 = new { value = Enum.GetName(typeof(OrderState), model.State), color = "#000000" },
};
break;
}
return(postData);
}
/// <summary>
/// 方法操作：1.创建订单,2.将购物车对应内容转为订单内容,3.减库存
/// </summary>
/// <param name="order"></param>
/// <param name="goodsCar"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public bool addGoodsOrder(StoreGoodsOrder order, List <StoreGoodsCart> goodsCar, C_UserInfo userInfo, ref string msg)
{
TransactionModel TranModel = new TransactionModel();
//创建订单
TranModel.Add(BuildAddSql(order));
//定义临时变量接收订单Id
//var dbOrderId = "@dbOrderId";
//TranModel.Add($" select {dbOrderId} := last_insert_id(); ");
//将购物车记录转为订单明细记录
TranModel.Add($" update StoreGoodsCart set GoodsOrderId = (select last_insert_id()),State = 1,UserId = {userInfo.Id} where id in ({string.Join(",", goodsCar.Select(s => s.Id).Distinct())}) and state = 0; ");
//根据订单内记录数量减库存
List <StoreGoods> goodsList = StoreGoodsBLL.SingleModel.GetList($" Id in ({string.Join(",", goodsCar.Select(x => x.GoodsId).Distinct().ToList())}) ");
Utility.Easyui.EasyuiHelper <StoreGoodsAttrDetail> goodDtlJsonHelper = new Utility.Easyui.EasyuiHelper <StoreGoodsAttrDetail>();
//msg += "a";
goodsCar.ForEach(x =>
{
StoreGoods good = goodsList.Where(y => y.Id == x.GoodsId).FirstOrDefault();
if (string.IsNullOrWhiteSpace(x.SpecIds))
{
good.Stock -= x.Count;
}
else
{
good.Stock -= x.Count;
//var goodList = good.GASDetailList.Where(z => z.id.Equals(x.SpecIds));
List <StoreGoodsAttrDetail> GASDetailList = new List <StoreGoodsAttrDetail>();
good.GASDetailList.ForEach(y =>
{
if (y.id.Equals(x.SpecIds))
{
y.count -= x.Count;
}
GASDetailList.Add(y);
});
//规格库存详情重新赋值
good.AttrDetail = goodDtlJsonHelper.SToJsonArray(GASDetailList);
}
});
// msg += "b";
goodsList.ForEach(x =>
{
TranModel.Add($" update storegoods set Stock={x.Stock},AttrDetail='{x.AttrDetail}' where Id = {x.Id} ");
});
string stringSql = "";
for (int i = 0; i < TranModel.sqlArray.Length; i++)
{
stringSql += TranModel.sqlArray[i];
}
return(ExecuteTransactionDataCorect(TranModel.sqlArray, TranModel.ParameterArray));
}
public StoreInfo GetStoreInfo(string storeId)
{
StoreInfo storeInfo = null;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MallSqls.SELECT_STORE_BY_STORE_ID, storeId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null && dt.Rows.Count == 1)
{
storeInfo = new StoreInfo
{
storeAddr = dt.Rows[0]["STORE_ADDR"].ToString(),
storeId = dt.Rows[0]["STORE_ID"].ToString(),
storeCardImg = dt.Rows[0]["STORE_CARD_IMG"].ToString(),
storeCode = dt.Rows[0]["STORE_CODE"].ToString(),
storeDesc = dt.Rows[0]["STORE_DESC"].ToString(),
storeImg = dt.Rows[0]["STORE_IMG"].ToString(),
storeName = dt.Rows[0]["STORE_NAME"].ToString(),
storeTel = dt.Rows[0]["STORE_TEL"].ToString(),
storeRate = Convert.ToInt32(dt.Rows[0]["STORE_RATE"]),
};
builder.Clear();
builder.AppendFormat(MallSqls.SELECT_STORE_IMG_BY_STORE_ID, storeId);
sql = builder.ToString();
dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
foreach (DataRow dr in dt.Rows)
{
StoreImg storeImg = new StoreImg
{
storeId = dr["STORE_ID"].ToString(),
storeImg = dr["STORE_IMG"].ToString(),
storeImgId = dr["STORE_IMG_ID"].ToString(),
};
storeInfo.storeImgs.Add(storeImg);
}
builder.Clear();
builder.AppendFormat(MallSqls.SELECT_STORE_GOODS_BY_STORE_ID, storeId);
sql = builder.ToString();
dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
foreach (DataRow dr in dt.Rows)
{
StoreGoods storeGoods = new StoreGoods
{
storeId = dr["STORE_ID"].ToString(),
storeGoodsDesc = dr["STORE_GOODS_DESC"].ToString(),
storeGoodsId = dr["STORE_GOODS_ID"].ToString(),
storeGoodsImg = dr["STORE_GOODS_IMG"].ToString(),
storeGoodsName = dr["STORE_GOODS_NAME"].ToString(),
storeGoodsImgOpen = dr["STORE_GOODS_IMG_OPEN"].ToString(),
};
storeInfo.storeGoods.Add(storeGoods);
}
}
return(storeInfo);
}
public override void OnIn(object data)
{
goods = (StoreGoods)data;
goodsName.text = goods.name;
Icon.spriteName = goods.iconSpriteName;
Icon.MakePixelPerfect();
price.text = "" + goods.silver;
}
public void init(StoreGoods goods)
{
this.storeGoods = goods;
name.text = goods.name;
Icon.spriteName = goods.iconSpriteName;
Icon.MakePixelPerfect();
price.text = "" + goods.silver;
describe.text = "description of " + goods.name;//goods.describe;
}
public StoreGoodsModel(StoreGoods storeGoods) : base(storeGoods.Goods)
{
this.StoreGoodsId = storeGoods.Id;
this.StoreGoodsQuantity = storeGoods.Quantity;
this.Price = storeGoods.Price;
this.TotalAomount = storeGoods.TotalAomount;
this.StoreGoodsNote = storeGoods.Note;
}
public void init(StoreGoods goods)
{
if(goods == null){
title.text = "Sorry";
description.text = "Your storage is full!";
}else {
title.text = "Purchase Successful";
description.text = "Room for content about coin can go right here so use it wisely!";
this.storeGoods = goods;
}
}
/// <summary>
/// 方法操作：1.创建订单,2.将购物车对应内容转为订单内容,3.减库存
/// </summary>
/// <param name="order"></param>
/// <param name="goodsCar"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public bool addGoodsOrder(StoreGoodsOrder order, List <StoreGoodsCart> goodsCar, C_UserInfo userInfo, StringBuilder sb, ref string msg)
{
TransactionModel TranModel = new TransactionModel();
//更新会员打折后的购物车
if (sb != null)
{
TranModel.Add(sb.ToString());
}
//创建订单
TranModel.Add(BuildAddSql(order));
//将购物车记录转为订单明细记录
TranModel.Add($" update StoreGoodsCart set GoodsOrderId = (select last_insert_id()),State = 1,UserId = {userInfo.Id} where id in ({string.Join(",", goodsCar.Select(s => s.Id).Distinct())}) and state = 0; ");
//根据订单内记录数量减库存
List <StoreGoods> goodsList = StoreGoodsBLL.SingleModel.GetList($" Id in ({string.Join(",", goodsCar.Select(x => x.GoodsId).Distinct().ToList())}) ");
Utility.Easyui.EasyuiHelper <StoreGoodsAttrDetail> goodDtlJsonHelper = new Utility.Easyui.EasyuiHelper <StoreGoodsAttrDetail>();
goodsCar.ForEach(x =>
{
StoreGoods good = goodsList.Where(y => y.Id == x.GoodsId).FirstOrDefault();
if (string.IsNullOrWhiteSpace(x.SpecIds))
{
good.Stock -= x.Count;
}
else
{
good.Stock -= x.Count;
List <StoreGoodsAttrDetail> GASDetailList = new List <StoreGoodsAttrDetail>();
good.GASDetailList.ForEach(y =>
{
if (y.id.Equals(x.SpecIds))
{
y.count -= x.Count;
}
GASDetailList.Add(y);
});
//规格库存详情重新赋值
good.AttrDetail = goodDtlJsonHelper.SToJsonArray(GASDetailList);
}
});
goodsList.ForEach(x =>
{
StoreGoodsBLL.SingleModel.RemoveStoreGoodsCache(x.Id);
TranModel.Add($" update storegoods set Stock={x.Stock},AttrDetail='{x.AttrDetail}' where Id = {x.Id} ");
});
return(ExecuteTransactionDataCorect(TranModel.sqlArray, TranModel.ParameterArray));
}
//查找订单列表
public List <StoreAdminGoodsOrder> GetAdminList(string where, int pagesize, int pageindex, out int totalCount, bool export = false)
{
List <StoreAdminGoodsOrder> list = new List <StoreAdminGoodsOrder>();
string sql;
string sqlCount;
sql = $@"select orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,orders.AccepterName as NickName,orders.AccepterTelePhone as TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address from storegoodsorder orders {(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by Id desc {(pagesize == 0 ? "" : " limit " + (pageindex <= 0 ? 0 : pageindex - 1) * pagesize + "," + pagesize)}";
//sql = $@"select orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,user.NickName,user.TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address from miniappgoodsorder orders inner join c_userinfo user on user.Id=orders.UserId {(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by Id desc {(pagesize == 0 ? "" : " limit " + (pageindex <= 0 ? 0 : pageindex - 1) * pagesize + "," + pagesize)}";
if (export)//导出Excel的话，不需要分页
{
sql = $@"select orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,orders.AccepterName as NickName,orders.AccepterTelePhone as TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address from storegoodsorder orders {(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by Id desc";
//sql = $@"select orders.Id,orders.OrderId,orders.BuyPrice,orders.UserId,user.NickName,user.TelePhone,orders.Message,orders.CreateDate,orders.State,orders.OrderNum,orders.Remark,orders.FreightPrice,orders.Address from miniappgoodsorder orders inner join c_userinfo user on user.Id=orders.UserId {(string.IsNullOrEmpty(where) ? "" : " where " + where)} order by Id desc";
}
sqlCount = $@"select count(*) from storegoodsorder orders {(string.IsNullOrEmpty(where) ? "" : " where " + where)}";
using (MySqlDataReader dr = SqlMySql.ExecuteDataReaderMaster(connName, CommandType.Text, sql, null))
{
while (dr.Read())
{
StoreAdminGoodsOrder model = GetModel(dr);
List <StoreGoodsCart> cartlist = StoreGoodsCartBLL.SingleModel.GetList($"GoodsOrderId={model.Id}");
List <StoreOrderCardDetail> detaillist = new List <StoreOrderCardDetail>();
string goodsIds = string.Join(",", cartlist?.Select(s => s.GoodsId).Distinct());
List <StoreGoods> storeGoodsList = StoreGoodsBLL.SingleModel.GetListByIds(goodsIds);
foreach (StoreGoodsCart item in cartlist)
{
StoreOrderCardDetail cart = new StoreOrderCardDetail();
cart.Id = item.Id;
StoreGoods goods = storeGoodsList?.FirstOrDefault(f => f.Id == item.GoodsId);
if (goods != null)
{
cart.GoodsName = goods.GoodsName;
cart.ImgUrl = goods.ImgUrl;
}
cart.SpecInfo = item.SpecInfo;
cart.Price = item.Price;
cart.Count = item.Count;
detaillist.Add(cart);
}
model.GoodsList = detaillist;
list.Add(model);
}
}
totalCount = GetCountBySql(sqlCount);
return(list);
}
public void CanUseLargeWarehouse()
{
Game.CargoShips[0].Load(new List <IGood> {
new Tobacco()
});
Game.CargoShips[1].Load(new List <IGood> {
new Coffee()
});
Game.CargoShips[2].Load(new List <IGood> {
new Sugar()
});
var largeWarehouse = new LargeWarehouse();
largeWarehouse.AddWorker(new Colonist());
RoleOwner.Buildings.Add(largeWarehouse);
var indigoCount = 5;
for (var i = 0; i < indigoCount; i++)
{
RoleOwner.Goods.Add(new Indigo());
}
var cornCount = 7;
for (var i = 0; i < cornCount; i++)
{
RoleOwner.Goods.Add(new Corn());
}
ReselectRole();
var storeGoods = new StoreGoods {
LargeWarehouse1 = GoodType.Indigo,
LargeWarehouse2 = GoodType.Corn
};
CanExecuteActionOnce(storeGoods, RoleOwner);
Assert.Empty(RoleOwner.Goods);
RoleOwner.Role.CleanUp();
Assert.Equal(indigoCount + cornCount, RoleOwner.Goods.Count);
}
/// <summary>
/// 商品订单过期-蔡华兴
/// </summary>
public void StoreGoodsOrderTimeOut(int timeoutlength = -30)
{
TransactionModel tranModel = new TransactionModel();
//订单超过30分钟取消订单
List <StoreGoodsOrder> orderList = GetList($"State=0 and CreateDate < date_add(NOW(), interval {timeoutlength} MINUTE)", 100, 1);
if (orderList != null && orderList.Count > 0)
{
log4net.LogHelper.WriteInfo(this.GetType(), "小程序商品订单过期（订单超过30分钟取消订单）");
tranModel = new TransactionModel();
//订单明细
List <StoreGoodsCart> orderdetaillist = orderList.Any() ? StoreGoodsCartBLL.SingleModel.GetList($"State =1 and GoodsOrderId in ({string.Join(",", orderList.Select(s => s.Id).Distinct())})") : new List <StoreGoodsCart>();
if (orderdetaillist != null && orderdetaillist.Count > 0)
{
//商品
List <StoreGoods> goodlist = StoreGoodsBLL.SingleModel.GetList($"Id in ({string.Join(",", orderdetaillist.Select(s => s.GoodsId).Distinct())})");
if (goodlist != null && goodlist.Count > 0)
{
foreach (StoreGoodsOrder item in orderList)
{
//商品明细
List <StoreGoodsCart> orderdetails = orderdetaillist.Any() ? orderdetaillist.Where(w => w.GoodsOrderId == item.OrderId).ToList() : new List <StoreGoodsCart>();
if (orderdetails != null && orderdetails.Count > 0)
{
for (int i = 0; i < orderdetails.Count; i++)
{
//商品
StoreGoods good = goodlist.Where(w => w.Id == orderdetails[i].GoodsId).FirstOrDefault();
if (good != null)
{
//商品加总库存
good.Stock += orderdetails[i].Count;
List <StoreGoodsAttrDetail> GASDetailList = good.GASDetailList;
//订单明细中的规格属性，加规格属性库存
for (int j = 0; j < GASDetailList.Count; j++)
{
if (GASDetailList[j].id == orderdetails[i].SpecIds)
{
GASDetailList[j].count += orderdetails[i].Count;
good.AttrDetail = SerializeHelper.SerToJson(GASDetailList);
break;
}
}
//更改商品总库存和规格属性库存
tranModel.Add($"update StoreGoods set AttrDetail='{good.AttrDetail}',Inventory={good.Inventory} where Id={good.Id}");
}
}
}
//订单状态改成已过期
item.State = -1;
tranModel.Add($"update StoreGoodsOrder set State={item.State} where Id={item.Id} and State = 0");
//加订单操作日志
StoreGoodsOrderLog model = new StoreGoodsOrderLog();
model.UserId = 0;
model.GoodsOrderId = item.Id;
model.LogInfo = " 30分钟未付款,系统自动改为已过期！ ";
model.CreateDate = DateTime.Now;
tranModel.Add(StoreGoodsOrderLogBLL.SingleModel.BuildAddSql(model));
ExecuteTransactionDataCorect(tranModel.sqlArray, tranModel.ParameterArray);
}
}
}
}
}
