/// <summary>
/// 获取订单信息
/// </summary>
/// <param name="userId"></param>
/// <param name="orderCode"></param>
/// <returns></returns>
public OrderDetails_ExtInfo GetOrderInfo(int userId, string orderCode)
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.sale_v_order
join b in db.base_t_member on a.userCode equals b.userCode
join c in db.sale_t_orderInvoice on a.invoiceNo equals c.invoiceNo
where b.membNo == userId && a.orderCode == orderCode
select new OrderDetails_ExtInfo
{
OrderNo = a.orderNo,
OrderCode = a.orderCode,
Provinces = "",
City = "",
County = "",
AddressInfo = a.address,
Phone = a.mobile,
Mobile = a.mobile,
Consignee = a.sendTo,
InvoiceCategory = c.InvType,
InvoiceTitle = c.InvTitle,
Zip = a.zip,
PayStatusId = a.payStatus ?? 0,
OrderStatusId = a.flowStatus ?? 0,
DeliveryType = a.deliverName,
PayId = a.payMethod ?? 0
};
return(queryTxt.First());
}
}
/// <summary>
/// 新增系统权限
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool AddSystemPermission(Model.DataContext.System_Permission item)
{
using (var db = new bbHomeEntities())
{
db.System_Permission.AddObject(item);
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 获取会员信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public base_t_member GetMemberInfo(int userId)
{
var bbhome = new bbHomeEntities();
var querylinq = from a in bbhome.base_t_member
where a.membNo == userId
select a;
return(querylinq.FirstOrDefault());
}
/// <summary>
/// 获取会员信息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public base_t_member GetMemberInfo(string uid)
{
var bbhome = new bbHomeEntities();
var querylinq = from a in bbhome.base_t_member
where a.email.Equals(uid)
select a;
return(querylinq.FirstOrDefault());
}
/// <summary>
/// 获取系统权限
/// </summary>
/// <returns></returns>
public List <System_Permission> GetSystemPermissionList()
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.System_Permission
select a;
return(queryTxt.ToList());
}
}
/// <summary>
/// 检查 数据是否存在
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int CheckIsExistsSystemPermission(Model.DataContext.System_Permission item)
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.System_Permission
where a.MethodName == item.MethodName
select a.Id;
return(queryTxt.FirstOrDefault());
}
}
/// <summary>
/// 获取订单信息
/// </summary>
/// <param name="orderCode"></param>
/// <returns></returns>
public sale_v_order GetOrderInfo(string orderCode)
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.sale_v_order
where a.orderCode == orderCode
select a;
var orderInfo = queryTxt.First();
return(orderInfo);
}
}
/// <summary>
/// 检查用户是否存在黑名单里
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public bool CheckUserIdInBackList(int userId)
{
var result = false;
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.tb_Blacklist
where a.intUserID == userId
select a;
result = queryTxt.Any();
}
return(result);
}
/// <summary>
/// 获取订单列表
/// </summary>
/// <param name="userId"></param>
/// <param name="begimTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public List <sale_v_order> GetOrdersList(int userId, DateTime begimTime, DateTime endTime)
{
//using (var db = new HolycaEntities())
//{
// var queryTxt = from a in db.Sale_Order
// where a.intUserID == userId && a.dtCreateDate <= endTime && a.dtCreateDate >= begimTime
// orderby a.dtCreateDate descending
// select a;
// return queryTxt.ToList();
//}
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.sale_v_order
join b in db.base_t_member on a.userCode equals b.userCode
where b.membNo == userId && a.createDate <= endTime && a.createDate >= begimTime
orderby a.createDate descending
select a;
return(queryTxt.ToList());
}
}
/// <summary>
/// 更新系统权限
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool UpdateSystemPermission(Model.DataContext.System_Permission item)
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.System_Permission
where a.Id == item.Id
select a;
var systemPermission = queryTxt.First();
systemPermission.RefreshTime = item.RefreshTime;
systemPermission.RequestType = item.RequestType;
systemPermission.RequestUri = item.RequestUri;
systemPermission.ReturnParameters = item.ReturnParameters;
systemPermission.AfferentParameters = item.AfferentParameters;
systemPermission.MethodAttrs = item.MethodAttrs;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 获取订单所有状态
/// </summary>
/// <param name="oCodes"></param>
/// <returns></returns>
public List <OrderAllStatus> GetOrderAllStatusByOrderCodes(List <string> oCodes)
{
var result = new List <OrderAllStatus>();
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.sale_t_order
join b in db.sale_t_orderStatus on a.orderNo equals b.orderNo
join c in db.sale_t_orderPayStatus on a.orderNo equals c.orderNo
where oCodes.Contains(a.orderCode)
select new OrderAllStatus
{
OrderCode = a.orderCode,
OrderNo = a.orderNo,
OrderStatus = b.flowStatus,
PayStatus = c.payStatus
};
result = queryTxt.ToList();
}
return(result);
}
/// <summary>
/// 获取商品
/// </summary>
/// <param name="userId"></param>
/// <param name="orderCode"></param>
/// <param name="clusterId"> </param>
/// <returns></returns>
public List <Sale_Order_Detail_And_GoodsInfo> GetOrderGoodsList(int userId, string orderCode, int clusterId)
{
using (var db = new bbHomeEntities())
{
var queryTxt = from a in db.sale_v_orderItem
join b in db.cg_t_products on a.productId equals b.productId
join c in db.sale_t_order on a.orderNo equals c.orderNo
where a.membNo == userId && c.orderCode == orderCode
select new Sale_Order_Detail_And_GoodsInfo
{
PicUrl = b.pictureUrl,
intProductID = a.productId ?? 0,
vchProductName = a.productName,
numSalePrice = a.price ?? 0,
intQty = a.qty ?? 0,
intScores = a.scores ?? 0,
numTotalAmount = a.amount ?? 0
};
return(queryTxt.ToList());
}
}
