public int AddMember(MemberEntity member)
{
int result = 0;
try
{
using (SqlConnection db = new SqlConnection())
{
string query = "INSERT INTO MEMBER (first_name,last_name,email,country,phone,username,[password]) VALUES (@ArgFirstName, @ArgLastName, @ArgEmail, @ArgCountry, @ArgPhone, @ArgUsername, @ArgPassword)";
db.ConnectionString = AppConfig.ConnectionStringAdo;
SqlCommand cmd = db.CreateCommand();
/*(object)member... Permet de définir si la 1ère valeur est null, si c'est le cas, il passe à la suivante (après les ?? séparé par des ;) ainsi de suite jusqu'à ce qu'il trouve une valeur non null car la base de donnée ne supporte pas les champs vides pour les string*/
cmd.Parameters.Add(new SqlParameter("@ArgFirstName", (object)member.first_name ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@ArgLastName", (object)member.last_name ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@ArgEmail", member.email));
cmd.Parameters.Add(new SqlParameter("@ArgCountry", (object)member.country ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@ArgPhone", (object)member.phone ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@ArgUsername", member.username));
cmd.Parameters.Add(new SqlParameter("@ArgPassword", member.password));
cmd.CommandText = query;
db.Open();
return(result = cmd.ExecuteNonQuery());
}
}
catch (Exception ex)
{
throw new Exception("Erreur: ", ex);
}
}
protected void lbtnUpdateInfo_Click(object sender, EventArgs e)
{
MemberEntity memberEntity = (MemberEntity)Session["usr"];
MemberBLL memberBLL = new MemberBLL();
memberEntity = memberBLL.list(memberEntity.MemberId);
if (memberEntity == null)
{
return;
}
if (memberEntity.MemberPhone.Equals(txtMemberPhone.Text) && memberEntity.MemberAddress.Equals(txtAddress.Text) && memberEntity.MemberMail.Equals(txtMemberMail.Text))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('请修改内容')</script>");
return;
}
memberEntity.MemberPhone = txtMemberPhone.Text;
memberEntity.MemberAddress = txtAddress.Text;
memberEntity.MemberMail = txtMemberMail.Text;
if (memberBLL.Update(memberEntity) == 1)
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('信息修改成功!')</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('修改失败！')</script>");
}
}
public void UpdateMember(MemberEntity member, AddMemberArgs args)
{
if (member == null || args == null)
{
Debug.Assert(false, "UpdateMember member== null || args == null");
return;
}
member.NickName = args.WeixinUser.Nickname;
member.Sex = args.WeixinUser.Sex;
member.City = args.WeixinUser.City;
member.Country = args.WeixinUser.Country;
member.Province = args.WeixinUser.Province;
member.Language = args.WeixinUser.Language;
member.Headimgurl = args.WeixinUser.Headimgurl;
member.SubscribeTime = args.WeixinUser.SubscribeTime;
member.Remark = args.WeixinUser.Remark;
member.GroupId = args.WeixinUser.GroupId;
member.TagList = args.WeixinUser.GetTagListString();
member.Attention = true;
member.SyncFlag = args.SyncFlag;
if (args.ScenicQRCodeId.HasValue)
{
member.ScenicQRCodeId = args.ScenicQRCodeId;
}
if (args.RefereeMemberId.HasValue)
{
member.RefereeMemberId = args.RefereeMemberId;
}
_dataBase.Update(member);
}
private void BookCart_Updatss()
{
BookCartBLL cartBLL = new BookCartBLL();
MemberEntity member = (MemberEntity)Session["usr"];
List <BookCartEntity> cartEntity = cartBLL.list(member.MemberId);
var icv = from ic in cartEntity where ic.IsSelect == 0 select ic;
if (Request["qxz"].ToLower().Equals("true"))
{
foreach (var item in icv)
{
BookCartEntity entity = cartBLL.lists(item.CartId);
entity.IsSelect = entity.IsSelect == 0 ? 1 : 0;
cartBLL.Update(entity);
}
}
else
{
if (icv.Count() == 0)
{
foreach (BookCartEntity item in cartEntity)
{
BookCartEntity entity = cartBLL.lists(item.CartId);
entity.IsSelect = entity.IsSelect == 0 ? 1 : 0;
cartBLL.Update(entity);
}
}
}
BookCart_list();
}
/// <summary>
/// 会员兑换
/// </summary>
/// <param name="userId"></param>
private bool VipExchange(int userId)
{
MemberEntity memberEntity = MemberBll.Instance.GetModel(userId);
if (memberEntity.Etime < DateTime.Now || memberEntity.RemainingConversions < 1)
{
return(false);
}
else
{
//添加积分变更表
IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity();
integralChangeEntity.UserId = userId.ToString();
integralChangeEntity.source = "vipshareRedemption";
integralChangeEntity.ShenJia = 0;
integralChangeEntity.Cnbi = "0";
integralChangeEntity.integral = 0;
integralChangeEntity.ardent = 0;
integralChangeEntity.Growth = 0;
integralChangeEntity.Bean = "0";
integralChangeEntity.Status = 1;
integralChangeEntity.AddTime = DateTime.Now;
IntegralChangeBll.Instance.Add(integralChangeEntity);
//更新会员表积分
MemberBll.Instance.UpdateIntegral(userId.ToString(), "RemainingConversions", "-1");
return(true);
}
}
///// <summary>
///// 找回密码
///// </summary>
///// <returns></returns>
//public ActionResult FindPwd()
//{
// return View();
//}
/// <summary>
/// 确认个人信息,忘记密码
/// </summary>
/// <returns></returns>
public string ConfirmPersonalInfo()
{
ResultObj result = new ResultObj();
string _mobile = FormString.SafeQ("mobile");
string _vCode = FormString.SafeQ("vCode");
if (System.Web.HttpContext.Current.Session[CommonKey.MobileNo] != null && System.Web.HttpContext.Current.Session[CommonKey.MobileNo].ToString() == _mobile && System.Web.HttpContext.Current.Session[CommonKey.MobileYZCode] != null && System.Web.HttpContext.Current.Session[CommonKey.MobileYZCode].ToString() == _vCode)
{
MemberEntity _entity = MemberBLL.Instance.GetMemByMobile(_mobile);
if (_entity.Id > 0)
{
if (MemberBLL.Instance.UpdateMember(_entity) > 0)
{
MemberEntity _upbehinden = MemberBLL.Instance.GetMember(_entity.Id);
System.Web.HttpContext.Current.Session.Add(CommonKey.FindPwdID, _entity.Id);
result.Status = (int)CommonStatus.Success;
result.Obj = _upbehinden.TimeStampTab;
}
else
{
result.Status = (int)CommonStatus.Fail;
}
}
else
{
result.Status = (int)CommonStatus.PhoneNotExist;
}
}
else
{
result.Status = (int)CommonStatus.VerCodeIsError;
}
return(JsonJC.ObjectToJson(result));
}
public ActionResult Register3()
{
int memid = CookieBLL.GetRegisterCookie();
if (memid > 0)
{
MemStoreEntity _en = StoreBLL.Instance.GetStoreByMemId(memid);
if (_en != null)
{
MemberEntity _mementity = MemberBLL.Instance.GetMember(memid);
if (_mementity.Status == (int)MemberStatus.Active)
{
//Response.Write("您已注册通过，请直接登录");
return(RedirectToAction("Login"));
}
else
{
ViewBag.LicensePath = _en.LicensePath;
}
}
}
else
{
return(RedirectToAction("Login"));
}
return(View());
}
public virtual async Task <IActionResult> UpdateUser([FromBody] User user, [FromRoute] int userId)
{
LogEnter("CreateUser", user);
IActionResult result;
if (TryValidateModel(user))
{
MemberEntity member = _mapper.Map <MemberEntity>(user);
if (member != null)
{
var newMember = await _repo.CreateMemberAsync(member);
result = Ok();
}
else
{
result = BadRequest();
}
}
else
{
result = BadRequest();
}
LogExit("UpdateUser", result);
return(result);
}
public virtual async Task <ActionResult <User> > PatchUser([FromRoute] int userId, [FromBody] JsonPatchDocument <User> userPatch)
{
LogEnter("PatchUser", userId, userPatch);
ActionResult <User> result;
if (userId > 0 && userPatch != null)
{
MemberEntity member = await _repo.GetMemberByIdAsync(userId);
if (member != null)
{
var userLoaded = _mapper.Map <User>(member);
userPatch.ApplyTo(userLoaded);
member = _mapper.Map <MemberEntity>(userLoaded);
await _repo.UpdateMemberAsync(member);
result = Ok();
}
else
{
result = NotFound();
}
}
else
{
result = BadRequest();
}
LogExit("PatchUser", result);
return(result);
}
public void ProcessRequest(HttpContext context)
{
string email = context.Request.Form["user[email]"];
bool i = false;
DataTable dt = MemberBll.Instance.GetList("email='" + email + "' and Activation!='0'").Tables[0];
if (dt.Rows.Count < 1)
{
context.Response.Write("1");
return;
}
MemberEntity memberEntity = MemberBll.Instance.GetModel(Convert.ToInt32(dt.Rows[0]["User_id"]));
memberEntity.code = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(Guid.NewGuid().ToString(), "MD5");
memberEntity.Activation = "2";
StringBuilder mailBody = new StringBuilder();
mailBody.AppendFormat("亲爱的 {0}", memberEntity.nickname);
mailBody.Append(@"<br />这封信是由 52cos平台 社区 发送的。<br />
您收到这封邮件，是由于在 52cos平台 社区 进行了新用户注册，或用户修改 Email，或申请重设密码 使用了这个邮箱地址。如果您并没有访问过 52cos平台 社区，或没有进行上述操作，请忽略这封邮件。您不需要退订或进行其他进一步的操作。
<br />
<br />
----------------------------------------------------------------------<br />
帐号激活说明<br />
----------------------------------------------------------------------<br />
<br />
如果您是 52cos平台 社区 的新用户，或在修改您的注册 Email，或在申请重设密码 时使用了本地址，我们需要对您的地址有效性进行验证以避免垃圾邮件或地址被滥用。
<br />
您只需点击下面的链接即可激活您的帐号：<br />");
mailBody.AppendFormat(@"<a style='color: #009A61; text-decoration: none;' href='http://{1}/Pages/App_Public/confirm.aspx?type=register&code={0}'>
http://{1}/Pages/App_Public/Reset.aspx?type=reset&token={0}
</a>", memberEntity.code, HttpContext.Current.Request.Url.Host);
mailBody.Append(@"<br />(如果上面不是链接形式，请将该地址手工粘贴到浏览器地址栏再访问)
<br />
感谢您的访问，祝您使用愉快！
<br />
此致<br />
52cos平台 社区 管理团队.<br />
http://sq.52cos.com/");
//发送注册邮件
bool b = MailHelper.sendMail("您正在申请重设密码", mailBody.ToString(), EmailConfig.Instance._EmailName, new List <string>()
{
dt.Rows[0]["Email"].ToString()
}, EmailConfig.Instance._EmailAgreement, EmailConfig.Instance._EmailUserName, EmailConfig.Instance._EmailPassword);
if (b)
{
i = MemberBll.Instance.Update(memberEntity);
}
else
{
context.Response.Write("2");
return;
}
context.Response.ContentType = "text/plain";
context.Response.Charset = "utf-8";
context.Response.Write(i);
}
public virtual async Task <IActionResult> CreateUser([FromBody] User user)
{
LogEnter("CreateUser", user);
IActionResult result;
if (TryValidateModel(user))
{
MemberEntity member = _mapper.Map <MemberEntity>(user);
if (member != null)
{
var newMember = await _repo.CreateMemberAsync(member);
result = CreatedAtAction(nameof(ShowUserById), new { id = newMember.Id });
}
else
{
result = BadRequest();
}
}
else
{
result = BadRequest();
}
LogExit("CreateUser", result);
return(result);
}
public HttpResponseMessage LoginEntry([FromBody] UserModel model)
{
MemberSearchCondition serch = new MemberSearchCondition
{
Phone = model.UserName
};
MemberEntity member = _memService.GetMembersByCondition(serch).FirstOrDefault();
if (member == null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "手机号或密码错误")));
}
var user = _userService.FindUser(member.UserId);
if (user == null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "用户名或密码错误")));
}
if (!PasswordHelper.ValidatePasswordHashed(user, model.Password))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "用户名或密码错误")));
}
_authenticationService.SignIn(user, model.Remember);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "登陆成功", new
{
user.Id,
Roles = user.UserRoles.Select(r => new { r.Role.RoleName }).ToArray(),
user.UserName
})));
}
/// <summary>
/// 构造
/// Initializes a new instance of the<see cref="FrmMemberInfo" /> class.
/// </summary>
public FrmMemberInfo()
{
InitializeComponent();
MemberEntity.AddItem(txtName, "Name", "姓名必须填写!", EfwControls.CustomControl.InvalidType.Empty, null); //姓名
MemberEntity.AddItem(tbcSex, "Sex", "性别必须填写!", EfwControls.CustomControl.InvalidType.Empty, null); //性别
MemberEntity.AddItem(dtBirthday, "Birthday", "出生日期必须填写!", EfwControls.CustomControl.InvalidType.Empty, null); //出生年月日
MemberEntity.AddItem(tbcMatrimony, "Matrimony"); //婚姻状况
MemberEntity.AddItem(tbcPatType, "PatType", "病人类型必须填写!", EfwControls.CustomControl.InvalidType.Empty, null); //病人类型
MemberEntity.AddItem(txtMedicCard, "MedicareCard"); //医保卡号
MemberEntity.AddItem(txtID, "IDNumber", "身份证号码格式不对！", EfwControls.CustomControl.InvalidType.IDcard, null); //身份证号
MemberEntity.AddItem(tbcCity, "CityCode", "所属地区必须填写！", EfwControls.CustomControl.InvalidType.Empty, null); //所属地区
MemberEntity.AddItem(textAdd, "Address"); //详细地址
MemberEntity.AddItem(txtTele, "Mobile"); //手机
//MemberEntity.AddItem(txtTele, "Mobile","手机号码必须填写！",EfwControls.CustomControl.InvalidType.Empty,null); //手机
MemberEntity.AddItem(txtAllergies, "Allergies"); //过敏史
MemberEntity.AddItem(tbcRoute, "Route", "知晓途径必须选择！", EfwControls.CustomControl.InvalidType.Empty, null); //知晓途径
MemberEntity.AddItem(tbcNationality, "Nationality"); //国籍
MemberEntity.AddItem(tbcNation, "Nation"); //民族
MemberEntity.AddItem(tbcDegree, "Degree"); //文化程度
MemberEntity.AddItem(tbcOccupation, "Occupation"); //过敏史
MemberEntity.AddItem(txtWorkUnit, "WorkUnit"); //工作单位
MemberEntity.AddItem(txtWorkTel, "WorkTele"); //公司电话
MemberEntity.AddItem(txtWorkADD, "WorkADD"); //公司地址
MemberEntity.AddItem(txtRelationName, "RelationName"); //联系人
MemberEntity.AddItem(tbcRelation, "Relation"); //联系人关系
MemberEntity.AddItem(textRelationTele, "RelationTele"); //联系人电话
}
public bool EmailExist(MemberEntity member)
{
bool exist = false;
int scalar = 0;
try
{
using (SqlConnection db = new SqlConnection())
{
string query = "SELECT count(*) FROM MEMBER WHERE EMAIL = @ArgEmail";
db.ConnectionString = AppConfig.ConnectionStringAdo;
SqlCommand cmd = db.CreateCommand();
cmd.Parameters.AddWithValue("@ArgEmail", member.email);
cmd.CommandText = query;
db.Open();
scalar = (Int32)cmd.ExecuteScalar();
}
}
catch (Exception ex)
{
throw new Exception("Erreur: ", ex);
}
return(exist = scalar > 0 ? true : false);
}
public ActionResult Create(MemberEntity member)
{
if (ModelState.IsValid)
{
bool error = false;
if (MemberManager.UsernameExist(member))
{
error = true;
ModelState.AddModelError(string.Empty, "Cette username existe déjà dans la base de donnée");
}
if (MemberManager.EmailExist(member))
{
error = true;
ModelState.AddModelError(string.Empty, "Cette email existe déjà dans la base de donnée");
}
if (error == false)
{
if (MemberManager.Add(member) > 0)
{
UserSession.CurrentUser = member;
return(RedirectToAction("Index", "Home"));
}
}
//ViewBag.Error = "Ce nom d'utilisateur existe déjà dans la base de donnée";
}
return(View());
}
public static MemberEntity getMember(int MembershipId)
{
MemberEntity newEntity = null;
try
{
SqlConnection connection = new SqlConnection();
SqlCommand command;
SqlDataReader reader;
connection.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\M_DB.mdf;Integrated Security=True;User Instance=True";
connection.Open();
String member_sql = "select * from membership where membershipid=" + MembershipId;
command = new SqlCommand(member_sql, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
newEntity = new MemberEntity(reader.GetInt32(0), "", reader.GetString(2).Trim(), reader.GetString(3).Trim(), reader.GetString(4).Trim(), "");
}
reader.Close();
return(newEntity);
}
catch (Exception)
{
return(newEntity);
}
}
public override void Patch(MemberEntity memberDataEntity)
{
var target = memberDataEntity as Contact2Entity;
target.JobTitle = JobTitle;
base.Patch(target);
}
public void ProcessRequest(HttpContext context)
{
string userId = context.Request.Form["user[userId]"];
string oldPwd = context.Request.Form["user[old-pwd]"];
string newPwd1 = context.Request.Form["user[new-pwd-1]"];
string s = "{\"status\":\"error\"}";
bool b = false;
MemberEntity memberEntity = MemberBll.Instance.GetModel(Convert.ToInt32(userId));
if (memberEntity != null)
{
if (memberEntity.Password == DEncryptUtils.Encrypt3DES(oldPwd))
{
memberEntity.Password = DEncryptUtils.Encrypt3DES(newPwd1);
b = MemberBll.Instance.Update(memberEntity);
if (b)
{
s = "{\"status\":\"success\"}";
}
}
}
context.Response.ContentType = "text/plain";
context.Response.Write(s);
}
public string Reg3Submit()
{
ResultObj _obj = new ResultObj();
string stamp = FormString.SafeQ("stamp");
int memid = FormString.IntSafeQ("memid");
string path = FormString.SafeQ("licensepath");
MemberEntity mem = MemberBLL.Instance.GetMemByMethod(memid.ToString(), LoginMethodEnum.MemId);
if (mem != null && mem.Id > 0 && mem.Status == (int)MemberStatus.Register2 && mem.TimeStampTab == stamp)
{
if (MemberBLL.Instance.RegisterCompanyLicense(memid, path) > 0)
{
_obj.Status = (int)CommonStatus.Success;
_obj.Obj = MemberBLL.Instance.GetMember(memid);
return(JsonJC.ObjectToJson(_obj));
}
_obj.Status = (int)CommonStatus.Fail;
return(JsonJC.ObjectToJson(_obj));
}
else
{
_obj.Status = (int)CommonStatus.RegisterNoModify;
return(JsonJC.ObjectToJson(_obj));
}
}
public async Task <Member> PostMembersAsync(MemberEntity member)
{
_context.Members.Add(member);
await _context.SaveChangesAsync();
return(_mapper.Map <Member>(member));
}
public string SaveLicense()
{
ResultObj _loginentity = new ResultObj();
int memid = CookieBLL.GetRegisterCookie();
string path = FormString.SafeQ("licensepath");
if (memid > 0)
{
MemberEntity _mem = new MemberEntity();
_mem = MemberBLL.Instance.GetMember(memid);
if (_mem != null && _mem.Status == (int)MemberStatus.WaitCheck)
{
MemberBLL.Instance.RegisterCompanyLicense(memid, path);
_loginentity.Status = (int)CommonStatus.Success;
}
else
{
_loginentity.Status = (int)CommonStatus.Fail;
}
}
else
{
_loginentity.Status = (int)CommonStatus.Fail;
}
return(JsonJC.ObjectToJson(_loginentity));
}
public MemberEntity Delu(MemberEntity Userentity)
{
string sql = "select * from Member where MemberAcc=@MemberAcc and MemberPwd=@MemberPwd";
db.PrepareSql(sql);
db.SetParameter("MemberAcc", Userentity.MemberAcc);
db.SetParameter("MemberPwd", Userentity.MemberPwd);
DataTable dt = db.ExecQuery();
if (dt.Rows.Count != 1)
{
return(null);
}
else
{
MemberEntity entity = new MemberEntity();
entity.MemberId = int.Parse(dt.Rows[0]["MemberId"].ToString());
entity.MemberAcc = dt.Rows[0]["MemberAcc"].ToString();
entity.MemberPwd = dt.Rows[0]["MemberPwd"].ToString();
entity.MemberCode = dt.Rows[0]["MemberCode"].ToString();
entity.MemberName = dt.Rows[0]["MemberName"].ToString();
entity.MemberPhone = dt.Rows[0]["MemberPhone"].ToString();
entity.MemberAddress = dt.Rows[0]["MemberAddress"].ToString();
entity.MemberMail = dt.Rows[0]["MemberMail"].ToString();
entity.MemberAddTime = DateTime.Parse(dt.Rows[0]["MemberAddTime"].ToString());
return(entity);
}
}
protected void lbtnUpdatePwd_Click(object sender, EventArgs e)
{
MemberBLL memberBLL = new MemberBLL();
MemberEntity meentity = (MemberEntity)Session["usr"];
meentity = memberBLL.list(meentity.MemberId);
if (txtConfirmPwd.Text.Equals(meentity.MemberPwd))
{
ClientScript.RegisterStartupScript(GetType(), "js", "<script>alert('请使用新的密码！')</script>");
return;
}
if (txtOldPwd.Text.Equals(meentity.MemberPwd))
{
meentity.MemberPwd = txtConfirmPwd.Text;
memberBLL.Update(meentity);
txtOldPwd.Text = "";
txtNewPwd.Text = "";
txtConfirmPwd.Text = "";
ClientScript.RegisterStartupScript(GetType(), "js", "<script>alert('密码修改成功！')</script>");
}
else
{
txtOldPwd.Text = "";
txtNewPwd.Text = "";
txtConfirmPwd.Text = "";
ClientScript.RegisterStartupScript(GetType(), "js", "<script>alert('请输入正确的密码！')</script>");
}
}
public ActionResult Index(MemberEntity detail)
{
MemberEntity entity = new MemberEntity();
if (detail.Type == "Admin")
{
entity = ManagerMember.ValidateCustomerMember(detail);
}
else if (detail.Type == "User")
{
}
if (!string.IsNullOrEmpty(entity.customer_id))
{
FormsAuthentication.SetAuthCookie(entity.customer_id, false);
var authTicket = new FormsAuthenticationTicket(1, entity.customer_id, DateTime.Now, DateTime.Now.AddMinutes(120), false, entity.Roles);
string encryptedTicket = FormsAuthentication.Encrypt(authTicket);
var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
HttpContext.Response.Cookies.Add(authCookie);
return(RedirectToAction("Index", "Home"));
}
ModelState.AddModelError("", "Invalid login attempt.");
return(View(detail));
}
/// <summary>
/// 普通兑换
/// </summary>
/// <param name="userId"></param>
/// <param name="official"></param>
private bool OrdinaryExchange(int userId, string official)
{
//取身家值
MemberEntity memberEntity = MemberBll.Instance.GetModel(userId);
if (decimal.Parse(memberEntity.Shenjia.ToString()) < decimal.Parse(official))
{
//s = "{\"status\":\"lacking\"}"; //身家不足
return(false);
}
else
{
//添加积分变更表
IntegralChangeEntity integralChangeEntity = new IntegralChangeEntity();
integralChangeEntity.UserId = userId.ToString();
integralChangeEntity.source = "shareRedemption";
integralChangeEntity.ShenJia = -decimal.Parse(official);
integralChangeEntity.Cnbi = "0";
integralChangeEntity.integral = 0;
integralChangeEntity.ardent = 0;
integralChangeEntity.Growth = 0;
integralChangeEntity.Bean = "0";
integralChangeEntity.Status = 1;
integralChangeEntity.AddTime = DateTime.Now;
IntegralChangeBll.Instance.Add(integralChangeEntity);
//更新会员表积分
MemberBll.Instance.UpdateIntegral(userId.ToString(), "ShenJia", integralChangeEntity.ShenJia.ToString());
return(true);
}
}
public static int Count(ApplicationDbContext context, MemberEntity entity)
{
if (!entity.iscache ||
Configs.GeneralSettings.cache_duration == 0 ||
entity.pagenumber > Configs.GeneralSettings.max_cache_pages)
{
return(CountRecords(context, entity));
}
else
{
string key = GenerateKey("cnt_members", entity);
int records = 0;
if (!SiteConfig.Cache.TryGetValue(key, out records))
{
records = CountRecords(context, entity);
var cacheEntryOptions = new MemoryCacheEntryOptions()
// Keep in cache for this time, reset time if accessed.
.SetSlidingExpiration(TimeSpan.FromSeconds(3600));
// Save data in cache.
SiteConfig.Cache.Set(key, records, cacheEntryOptions);
}
else
{
records = (int)SiteConfig.Cache.Get(key);
}
return(records);
}
}
/// <summary>
/// 会员注册
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <IResultModel> Register(RegisterModel model)
{
//用户名称是否存在
var existsUserName = _repository.ExistsUserName(model.UserName);
if (existsUserName)
{
return(ResultModel.HasExists);
}
//邮箱是否存在
var existsEmail = _repository.ExistsEmail(model.UserName);
if (existsUserName)
{
return(ResultModel.HasExists);
}
var password = _passwordHandler.Encrypt(model.UserName, model.Password);
var entity = new MemberEntity
{
UserName = model.UserName,
Email = model.Email,
NickName = model.NickName,
Password = model.Password,
Sex = model.Sex
};
var result = await _repository.AddAsync(entity);
return(ResultModel.Result(result));
}
public ActionResult SaveForm(string keyValue, MemberEntity entity)
{
try
{
if (keyValue != "")
{
entity.MemberId = keyValue;
MemberBLL.Instance.Update(entity);
}
else
{
entity.MemberId = Util.Util.NewUpperGuid();
entity.CreateTime = DateTime.Now;
entity.Status = (int)Trade.Model.Enums.UseStatus.正常;
entity.Pwd = DESEncrypt.Encrypt("123456");
MemberBLL.Instance.Add(entity);
}
return(Success("保存成功"));
}
catch (Exception ex)
{
ex.Data["Method"] = "MemberController>>Save";
new ExceptionHelper().LogException(ex);
return(Error("保存失败"));
}
}
public ActionResult GetPointCommodityOrderByOrderNumber()
{
string orderNumber = Request.QueryString["orderNumber"];
if (String.IsNullOrEmpty(orderNumber))
{
return(RespondResult(false, "参数无效。"));
}
PointCommodityOrderEntity pointCommodityOrder =
_pointCommodityManager.GetOrderByOrderNumber(DomainContext.Domain.Id, DomainContext.AppId, orderNumber);
if (pointCommodityOrder == null)
{
return(RespondResult(false, "订单不存在。"));
}
else
{
MemberEntity member = _memberManager.GetMember(pointCommodityOrder.Member);
if (member == null)
{
return(RespondResult(false, "会员数据异常。"));
}
return(RespondDataResult(new
{
Order = pointCommodityOrder,
Member = member,
ItemList = _pointCommodityManager.GetOrderItemList(pointCommodityOrder.Id)
}));
}
}
public User PostUserAsync(UserEntity user)
{
var bytePassword = Encoding.ASCII.GetBytes(user.Password);
_context.Users.Add(user);
// string passwordStr = Encoding.ASCII.GetString(user.Password);
if (user.Role == Role.Trainer)
{
var trainer = new TrainerEntity
{
Username = user.Username,
Password = user.Password
};
_context.Trainers.Add(trainer);
}
else if (user.Role == Role.Member)
{
var member = new MemberEntity
{
Username = user.Username,
Password = user.Password,
PackageId = null,
TrainerId = null
};
_context.Members.Add(member);
}
_context.SaveChanges();
return(_mapper.Map <User>(user));
}
