/// <summary>
/// 根据Id查询会员信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public OperateResult GetMemberCardInfo(int id)
{
var model = Find(e => e.MC_ID == id);
if (model == null)
{
return(new OperateResult(ResultStatus.Error, "当前会员未找到"));
}
var viewModel = new MemberCardEditViewModel()
{
Id = model.MC_ID,
BirthdayDay = (int)model.MC_Birthday_Day,
BirthdayMonth = (int)model.MC_Birthday_Month,
BirthdayType = (int)model.MC_BirthdayType,
CardId = model.MC_CardID,
CardLevelId = (int)model.CL_ID,
IsPast = (bool)model.MC_IsPast,
IsPointAuto = (bool)model.MC_IsPointAuto,
Mobile = model.MC_Mobile,
Money = (decimal)model.MC_Money,
TotalMoney = (decimal)model.MC_TotalMoney,
Name = model.MC_Name,
PastTime = model.MC_PastTime.Value.ToString("yyyy-MM-dd"),
Point = (int)model.MC_Point,
RefererCard = model.MC_RefererCard,
RefererName = model.MC_RefererName,
Sex = (SexTypeEnum)model.MC_Sex,
CardState = (CardStateTypeEnum)model.MC_State
};
return(new OperateResult(ResultStatus.Success, "", viewModel));
}
public OperateResult MemberLock(MemberCardEditViewModel viewModel)
{
//1.根据id获取当前要编辑的会员
var model = Find(e => e.MC_ID == viewModel.Id && e.MC_CardID == viewModel.CardId);
if (model == null)
{
return(new OperateResult(ResultStatus.Error, "当前会员未找到"));
}
//2.为会员的属性赋值
model.MC_State = (int)viewModel.CardState;
if (Update(model))
{
return(new OperateResult(ResultStatus.Success, "更新状态成功"));
}
else
{
return(new OperateResult(ResultStatus.Error, "网络繁忙，请稍候重试"));
}
}
/// <summary>
/// 根据会员卡号查找推荐人
/// </summary>
/// <param name="cardId"></param>
/// <returns></returns>
public OperateResult GetRefererInfo(string cardId)
{
if (!string.IsNullOrWhiteSpace(cardId))
{
var model = Find(e => e.MC_CardID == cardId);
if (model != null)
{
var referer = new MemberCardEditViewModel()
{
Id = model.MC_ID,
BirthdayDay = (int)model.MC_Birthday_Day,
BirthdayMonth = (int)model.MC_Birthday_Month,
BirthdayType = (int)model.MC_BirthdayType,
CardId = model.MC_CardID,
CardLevelId = (int)model.CL_ID,
IsPast = (bool)model.MC_IsPast,
IsPointAuto = (bool)model.MC_IsPointAuto,
Mobile = model.MC_Mobile,
Money = (decimal)model.MC_Money,
TotalMoney = (decimal)model.MC_TotalMoney,
Name = model.MC_Name,
PastTime = model.MC_PastTime.Value.ToString("yyyy-MM-dd"),
Point = (int)model.MC_Point,
RefererCard = model.MC_RefererCard,
RefererName = model.MC_RefererName,
Sex = (SexTypeEnum)model.MC_Sex,
CardState = (CardStateTypeEnum)model.MC_State
};
return(new OperateResult(ResultStatus.Success, "", referer));
}
else
{
return(new OperateResult(ResultStatus.Error, "您输入的推荐人不存在"));
}
}
return(new OperateResult(ResultStatus.Error, "您输入的会员卡号不能为空"));
}
public ActionResult Create(MemberCardEditViewModel viewModel)
{
var result = _MemberCardService.Create(viewModel);
return(Json(result));
#region 原本添加
//try
//{
// var db = new MemberPointModel();
// var model = new MemCards()
// {
// };
// db.MemCards.Add(model);
// OperateResult result;
// if (db.SaveChanges() > 0)
// {
// //result.ResultStatus = ResultStatus.Success;
// //result.Msg = "添加会员成功";
// result = new OperateResult(ResultStatus.Success, "成功");
// }
// else
// {
// //result.ResultStatus = ResultStatus.Error;
// //result.Msg = "添加会员失败";
// result = new OperateResult(ResultStatus.Error, "失败");
// }
// return Json(result);
//}
//catch
//{
// return View();
//}
#endregion
}
public ActionResult Lock(MemberCardEditViewModel m)
{
//问题：卡片过期时间不设置时怎么解决
return(Json(_MemberCardService.MemberLock(m)));
}
public ActionResult Edit(MemberCardEditViewModel viewModel)
{
var result = _MemberCardService.Update(viewModel);
return(Json(result));
}
/// <summary>
/// 添加会员
/// </summary>
/// <param name="viewModel"></param>
/// <returns></returns>
public OperateResult Create(MemberCardEditViewModel viewModel)
{
var model = new MemCards
{
CL_ID = viewModel.CardLevelId,
MC_BirthdayType = (byte)viewModel.BirthdayType,
MC_Birthday_Day = viewModel.BirthdayDay,
MC_Birthday_Month = viewModel.BirthdayMonth,
MC_CardID = viewModel.CardId,
MC_CreateTime = DateTime.Now,
MC_IsPast = viewModel.IsPast,
MC_IsPointAuto = viewModel.IsPointAuto,
MC_Mobile = viewModel.Mobile,
MC_Money = (float)viewModel.Money,
MC_Name = viewModel.Name,
MC_Password = viewModel.Password,
MC_PastTime = Convert.ToDateTime(viewModel.PastTime),
MC_Point = viewModel.Point,
MC_Sex = (int)viewModel.Sex,
MC_State = (int)viewModel.CardState,
MC_RefererCard = viewModel.RefererCard,
};
//var refererResult = GetRefererInfo(model.MC_RefererCard);
//if (refererResult.ResultStatus == ResultStatus.Success)
//{
// model.MC_RefererName = ((MemCards)refererResult.Data).MC_Name;
// model.MC_RefererID = ((MemCards)refererResult.Data).MC_ID;
//}
//else
//{
// return new OperateResult(ResultStatus.Error,refererResult.Msg);
//}
//判断推荐人是否存在
if (!string.IsNullOrWhiteSpace(model.MC_RefererCard))
{
var referer = Find(e => e.MC_CardID == model.MC_RefererCard);
if (referer != null)
{
model.MC_RefererName = referer.MC_Name;
model.MC_RefererID = referer.MC_ID;
}
else
{
return(new OperateResult(ResultStatus.Error, "您输入的推荐人不存在"));
}
}
model.S_ID = 2;
model.MC_TotalCount = 0;
model.MC_TotalMoney = 0;
model.MC_OverCount = 0;
if (Add(model))
{
return(new OperateResult(ResultStatus.Success, "会员创建成功"));
}
else
{
return(new OperateResult(ResultStatus.Success, "网络繁忙，请稍候重试"));
}
}
/// <summary>
/// 更新会员信息
/// </summary>
/// <param name="viewModel"></param>
/// <returns></returns>
public OperateResult Update(MemberCardEditViewModel viewModel)
{
//1.根据id获取当前要编辑的会员
var model = Find(e => e.MC_ID == viewModel.Id);
if (model == null)
{
return(new OperateResult(ResultStatus.Error, "当前会员未找到"));
}
//2.为会员的属性赋值
model.CL_ID = viewModel.CardLevelId;
model.MC_BirthdayType = (byte)viewModel.BirthdayType;
model.MC_Birthday_Day = viewModel.BirthdayDay;
model.MC_Birthday_Month = viewModel.BirthdayMonth;
model.MC_CardID = viewModel.CardId;
model.MC_CreateTime = DateTime.Now;
model.MC_IsPast = viewModel.IsPast;
model.MC_IsPointAuto = viewModel.IsPointAuto;
model.MC_Mobile = viewModel.Mobile;
model.MC_Money = (float)viewModel.Money;
model.MC_Name = viewModel.Name;
if (!string.IsNullOrWhiteSpace(viewModel.Password) && !string.IsNullOrWhiteSpace(viewModel.PasswordConfirm))
{
if (viewModel.Password != viewModel.PasswordConfirm)
{
return(new OperateResult(ResultStatus.Error, "两次输入的密码不一致"));
}
model.MC_Password = viewModel.Password;
}
model.MC_PastTime = Convert.ToDateTime(viewModel.PastTime);
model.MC_Point = viewModel.Point;
model.MC_Sex = (int)viewModel.Sex;
model.MC_State = (int)viewModel.CardState;
model.MC_RefererCard = viewModel.RefererCard;
//判断推荐人是否存在
if (!string.IsNullOrWhiteSpace(model.MC_RefererCard))
{
var referer = Find(e => e.MC_CardID == model.MC_RefererCard);
if (referer != null)
{
model.MC_RefererName = referer.MC_Name;
model.MC_RefererID = referer.MC_ID;
}
else
{
return(new OperateResult(ResultStatus.Error, "您输入的推荐人不存在"));
}
}
if (Update(model))
{
return(new OperateResult(ResultStatus.Success, "会员更新成功"));
}
else
{
return(new OperateResult(ResultStatus.Success, "网络繁忙，请稍候重试"));
}
}
