/// <summary>
/// 订单详情
/// </summary>
/// <param name="uid"></param>
/// <param name="orderNum"></param>
/// <returns></returns>
public OrderDetail OrderDetail(string uid, string orderNum)
{
OrderDetail order = new model.OrderDetail();
string orderSql = " select * from [Order] where Uid={0} and OrderId={1}";
DAO.Order o = db.Database.SqlQuery <DAO.Order>(string.Format(orderSql, uid, orderNum)).FirstOrDefault();
string opSql = " SELECT * FROM [OrderProList] where [OrderId] ={0}";
List <DAO.OrderProList> opList = db.Database.SqlQuery <DAO.OrderProList>(string.Format(opSql, orderNum)).ToList();
string imgSql = "select * from imgstock where partID in (select ProductID from orderProList where orderID={0})";
List <DAO.ImgStock> imgList = db.Database.SqlQuery <DAO.ImgStock>(string.Format(imgSql, orderNum)).ToList();
string expSql = "select * from ExpRecord where orderNum ='{0}'";
DAO.ExpRecord ex = db.Database.SqlQuery <DAO.ExpRecord>(string.Format(expSql, orderNum)).FirstOrDefault();
int? exp = 0;
if (ex != null)
{
exp = ex.Exp;
}
order.order = o;
order.opList = opList;
order.pimgList = imgList;
order.exp = exp == null ? 0 : exp;
return(order);
}
/// <summary>
/// 注册获取等级
/// </summary>
/// <param name="upUser"></param>
/// <returns></returns>
public DAO.MemberLevel GetLevel(int uid, int upUser)
{
ExpRecordBLL expBll = new ExpRecordBLL();
DAO.ExpRecord expModel = new DAO.ExpRecord();
MemberLevelBLL mleve = new MemberLevelBLL();
DAO.MemberLevel lmodel;
if (upUser == -1)//独立注册的新会员可自动升级为二星会员 且自主购货累计双倍积分。
{
lmodel = mleve.GetLevelBySelf();
//添加积分记录
expModel.Source = "独立注册";
}
else if (upUser == 0)
{
lmodel = mleve.GetLevelBySelf();
//添加积分记录
expModel.Source = "微信注册";
}
else
{ //推荐注册 一星会员
lmodel = mleve.GetLevelByUser();
//添加积分记录
expModel.Source = "邀请码注册";
}
expModel.Uid = uid;
expModel.Exp = lmodel.MinIntegral;
expModel.Datetime = DateTime.Now;
expModel.Status = 1;
expBll.AddRecord(expModel);
return(lmodel);
}
public bool GiveExp(DAO.MemberBase mb, decimal orderPrice, string orderNumber)
{
DAO.ExpRecord extModel = new DAO.ExpRecord();
extModel.Uid = mb.ID;
extModel.Source = "订单";
extModel.OrderNum = orderNumber;
extModel.OrderPrice = orderPrice;
extModel.Datetime = DateTime.Now;
extModel.Status = 0;
//判断用户注册类型 计算积分
if (mb.UpUser == -1)
{
//独立注册
decimal JF = Math.Floor(orderPrice * decimal.Parse(ConfigurationApp.XFJFXS));
extModel.Exp = Convert.ToInt32(decimal.Parse(ConfigurationApp.SM) * JF);
if (extModel.Exp > 0)
{
db.ExpRecord.Add(extModel);
}
}
else
{
//被推荐注册的
decimal JF = Math.Floor(orderPrice * decimal.Parse(ConfigurationApp.XFJFXS));
extModel.Exp = Convert.ToInt32(decimal.Parse(ConfigurationApp.CM) * JF);
if (extModel.Exp > 0)
{
db.ExpRecord.Add(extModel);
}
//给上级积分
extModel.Uid = mb.UpUser;
extModel.Source = "推广订单";
extModel.LowerUid = mb.ID;
extModel.Exp = Convert.ToInt32(Math.Floor(orderPrice / 100));//每100得到1分
if (extModel.Exp > 0)
{
db.ExpRecord.Add(extModel);
}
}
int r = db.SaveChanges();
if (r > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 给上级用户积分
/// </summary>
public void GiveUpUserInt(int cuid, int upUser)
{
if (upUser != -1)
{
ExpRecordBLL expBll = new ExpRecordBLL();
DAO.ExpRecord expModel = new DAO.ExpRecord();
expModel.Uid = upUser;
expModel.Source = "发展注册";
expModel.LowerUid = cuid;
expModel.Exp = int.Parse(ConfigurationApp.TJJF);
expModel.Datetime = DateTime.Now;
expModel.Status = 1;
expBll.AddRecord(expModel);
}
}
//添加记录
public void AddRecord(DAO.ExpRecord m)
{
db.ExpRecord.Add(m);
db.SaveChanges();
}