/// <summary>
/// 获取礼品
/// </summary>
/// <param name="id"></param>
public GiftInfo GetById(long id)
{
GiftInfo result = null;
result = Context.GiftInfo.FirstOrDefault(d => d.Id == id);
if (result != null)
{
if (result.NeedGrade != 0)
{
MemberGrade grade = Context.MemberGrade.FirstOrDefault(d => d.Id == result.NeedGrade);
if (grade != null)
{
result.GradeIntegral = grade.Integral;
result.NeedGradeName = grade.GradeName;
}
else
{
result.GradeIntegral = -1;
result.NeedGradeName = "等级已删除";
}
}
else
{
result.GradeIntegral = 0;
result.NeedGradeName = "不限等级";
}
}
return(result);
}
public GiftInfo GetById(long id)
{
GiftInfo integral = null;
integral = context.GiftInfo.FirstOrDefault((GiftInfo d) => d.Id == id);
if (integral != null)
{
if (integral.NeedGrade == 0)
{
integral.GradeIntegral = 0;
integral.NeedGradeName = "不限等级";
}
else
{
MemberGrade memberGrade = context.MemberGrade.FirstOrDefault((MemberGrade d) => d.Id == integral.NeedGrade);
if (memberGrade == null)
{
integral.GradeIntegral = -1;
integral.NeedGradeName = "等级己删除";
}
else
{
integral.GradeIntegral = memberGrade.Integral;
integral.NeedGradeName = memberGrade.GradeName;
}
}
}
return(integral);
}
public JsonResult Add(MemberGrade model)
{
if (!(1 <= model.Discount && model.Discount <= 10))
{
return(Json(new Result()
{
success = false, msg = "可享受折扣率允许范围1-10折！"
}));
}
string erroMsg;
if (!CheckMemberGrade(model, out erroMsg))
{
return(Json(new Result()
{
success = false, msg = erroMsg
}));
}
_iMemberGradeService.AddMemberGrade(model);
return(Json(new Result()
{
success = true, msg = "添加成功！"
}));
}
public JsonActionResult <bool> Update(MemberGrade entity)
{
return(SafeExecute(() =>
{
return MemberGradeService.Update(entity);
}));
}
public JsonActionResult <MemberGrade> Add(MemberGrade entity)
{
return(SafeExecute(() =>
{
return MemberGradeService.Add(entity);
}));
}
//public Member()
//{
// id = "";
// name = "";
// cardNo = "";
// JiFen = new MemberGrade();
// discountCard = "";
//}
public Member(int argID, string argName, string argCardNo, int argJiFen, string argDiscountCard)
{
id = argID;
name = argName;
cardNo = argCardNo;
JiFen = new MemberGrade(argJiFen);
discountCard = argDiscountCard;
}
public void UpdateMemberGrade(MemberGrade model)
{
if (context.MemberGrade.Any((MemberGrade a) => a.Integral == model.Integral && a.Id != model.Id))
{
throw new HimallException("等级之间的积分不能相同");
}
context.Set<MemberGrade>().Attach(model);
context.Entry<MemberGrade>(model).State = EntityState.Modified;
context.SaveChanges();
}
public void DeleteMemberGrade(long id)
{
if (context.GiftInfo.Any((GiftInfo d) => d.NeedGrade == id))
{
throw new HimallException("有礼品兑换与等级关联，不可删除！");
}
MemberGrade gradeInfo = context.MemberGrade.FirstOrDefault((MemberGrade a)=>a.Id == id);
//context.MemberGrade.OrderBy((MemberGrade a) => a.Id == id);
context.MemberGrade.Remove(gradeInfo);
context.SaveChanges();
}
/// <summary>
/// 修改等级调用方法
/// </summary>
/// <param name="i"></param>
public void ForMemberGrade(int i)
{
MemberGrade member = ShowMemberGrade().Find(x => float.Parse(x.Totalprice.ToString()) / 1000 == i);
Customer admin = context.Customer.ToList().Find(a => a.UserId == member.UserId);
switch (i)
{
case 1:
admin.Userlevel = "一般挽留客户";
break;
case 2:
admin.Userlevel = "一般保持客户";
break;
case 3:
admin.Userlevel = "一般发展客户";
break;
case 4:
admin.Userlevel = "一般价值客户";
break;
case 5:
admin.Userlevel = "重要挽留客户";
break;
case 6:
admin.Userlevel = "重要保持客户";
break;
case 7:
admin.Userlevel = "重要保持客户";
break;
case 8:
admin.Userlevel = "重要保持客户";
break;
case 9:
admin.Userlevel = "重要发展客户";
break;
case 10:
admin.Userlevel = "重要发展客户";
break;
default:
admin.Userlevel = "重要价值客户";
break;
}
context.Entry(member).State = EntityState.Modified;
}
public void AddMemberGrade(MemberGrade model)
{
if (model.Integral < 0)
{
throw new HimallException("积分不能为负数");
}
if (context.MemberGrade.Any((MemberGrade a) => a.Integral == model.Integral))
{
throw new HimallException("等级之间的积分不能相同");
}
context.MemberGrade.Add(model);
context.SaveChanges();
}
private string GetMemberGrade(int historyIntegrals)
{
MemberGrade memberGrade = (
from a in context.MemberGrade
orderby a.Integral descending
select a).FirstOrDefault((MemberGrade a) => a.Integral <= historyIntegrals);
if (memberGrade == null)
{
return("Vip0");
}
return(memberGrade.GradeName);
}
public void UpdateMemberGrade(MemberGrade model)
{
if (Context.MemberGrade.Any(a => a.Integral == model.Integral && a.Id != model.Id))
{
throw new HimallException("等级之间的积分不能相同");
}
if (Context.MemberGrade.Any(a => a.Id != model.Id && a.GradeName.ToLower() == model.GradeName.ToLower()))
{
throw new HimallException("已存在相同名称的等级");
}
Context.Set <MemberGrade>().Attach(model);
Context.Entry <MemberGrade>(model).State = EntityState.Modified;
Context.SaveChanges();
}
private string GetMemberGrade(IEnumerable <MemberGrade> memberGrade, int historyIntegrals)
{
MemberGrade memberGrade1 = (
from a in memberGrade
where a.Integral <= historyIntegrals
orderby a.Integral descending
select a).FirstOrDefault();
if (memberGrade1 == null)
{
return("Vip0");
}
return(memberGrade1.GradeName);
}
public void AddMemberGrade(MemberGrade model)
{
if (model.Integral < 0)
{
throw new HimallException("积分不能为负数");
}
if (Context.MemberGrade.Any(a => a.Integral == model.Integral))
{
throw new HimallException("等级之间的积分不能相同");
}
if (Context.MemberGrade.Any(a => a.GradeName.ToLower() == model.GradeName.ToLower()))
{
throw new HimallException("已存在相同名称的等级");
}
Context.MemberGrade.Add(model);
Context.SaveChanges();
}
private bool CheckMemberGrade(MemberGrade model, out string erroMsg)
{
bool flag = true;
erroMsg = "";
if (string.IsNullOrWhiteSpace(model.GradeName))
{
erroMsg = "会员等级名称不能为空";
flag = false;
}
if (model.Integral < 0)
{
erroMsg = "积分不能小于0";
flag = false;
}
return(flag);
}
//检查是否可以查阅指定的职等
public static bool CheckQueryGrade(string gradeCode)
{
if (AccessController.CurrentMember == null)
{
return(false);
}
string myUserType = CurrentMember.用户类型;
MemberGrade mg = 我可以查阅的职等.Find(a => a.工资职等 == gradeCode || a.工资职等 == "所有职等");
if (myUserType == "算薪人员")
{
return(mg != null);
}
else
{
return(true);
}
}
public JsonResult Edit(MemberGrade model)
{
//if (!(1 <= model.Discount && model.Discount <= 10))
//{
// return Json(new Result() { success = false, msg = "可享受折扣率允许范围1-10折！" });
//}
string erroMsg;
if (!CheckMemberGrade(model, out erroMsg))
{
return(Json(new Result()
{
success = false, msg = erroMsg
}));
}
_iMemberGradeService.UpdateMemberGrade(model);
return(Json(new Result()
{
success = true, msg = "修改成功！"
}));
}
public JsonResult Edit(MemberGrade model)
{
string str;
if (!CheckMemberGrade(model, out str))
{
Result result = new Result()
{
success = false,
msg = str
};
return(Json(result));
}
ServiceHelper.Create <IMemberGradeService>().UpdateMemberGrade(model);
Result result1 = new Result()
{
success = true,
msg = "修改成功！"
};
return(Json(result1));
}
/// <summary>
/// 未用修改等级调用方法
/// </summary>
/// <param name="i"></param>
public void ForMemberGrade(int i)
{
List <Customer> customers = context.Customer.ToList();
List <OrderInfo> orders = context.OrderInfo.ToList();
List <MemberGrade> members = (from c in customers
join o in orders on c.UserId equals o.UserId
select new MemberGrade
{
UserId = c.UserId,
Id = c.UserId,
UserName = c.UserName,
Totalprice = o.Totalprice,
Userlevel = c.Userlevel,
Useraddress = c.Useraddress
}).ToList();
MemberGrade member = members.Find(x => float.Parse(x.Totalprice.ToString()) / 1000 == i);
Customer admin = context.Customer.ToList().Find(a => a.UserId == member.UserId);
switch (i)
{
case 1:
admin.Userlevel = "一般挽留客户";
break;
case 2:
admin.Userlevel = "一般保持客户";
break;
case 3:
admin.Userlevel = "一般发展客户";
break;
case 4:
admin.Userlevel = "一般价值客户";
break;
case 5:
admin.Userlevel = "重要挽留客户";
break;
case 6:
admin.Userlevel = "重要保持客户";
break;
case 7:
admin.Userlevel = "重要保持客户";
break;
case 8:
admin.Userlevel = "重要保持客户";
break;
case 9:
admin.Userlevel = "重要发展客户";
break;
case 10:
admin.Userlevel = "重要发展客户";
break;
default:
admin.Userlevel = "重要价值客户";
break;
}
context.Entry(member).State = EntityState.Modified;
}
