//查找订单列表-电商
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);
}
//查找订单列表
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);
}
