public void Update(Model.Store.Member entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { conn.Execute("UPDATE store_member SET AvatarPath=@AvatarPath,Phone=@Phone,Password=@Password,AddTime=@AddTime,State=@State,LastTime=@LastTime,LoginName=@LoginName WHERE Member_Id =@Member_Id", entity); } }
public bool Insert(Model.Store.Member entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { int i = conn.Execute("INSERT INTO store_member(LoginName,Password,AddTime,LastTime,AvatarPath,Phone,State)" + "VALUES(@LoginName,@Password,@AddTime,@LastTime,@AvatarPath,@Phone,@State)", entity); if (i > 0) { return(true); } else { return(false); } } }
public ActionResult AlterFaceHandle() { var avatarFile = Request.Files["FaceFile"]; if (avatarFile != null && avatarFile.ContentLength > 0) { if (avatarFile.ContentLength <= MyPath.fileSize * 1024) { var avatarName = avatarFile.FileName; var avatarExt = Path.GetExtension(avatarName); if (!String.IsNullOrEmpty(avatarExt) && Config.ImgExtensions.Contains(avatarExt)) { if (!System.IO.Directory.Exists(MyPath.AvatarPath)) { System.IO.Directory.CreateDirectory(MyPath.AvatarPath); } //保存原图 string imgPath = DateTime.Now.ToString("yyyyMMddHHmmssfff") + avatarExt; var savePath = Path.Combine(MyPath.AvatarPath, imgPath); avatarFile.SaveAs(savePath); Model.Store.Member u = this.memberServer.Find(this.LoginMember.Member_Id); u.AvatarPath = MyPath.Web_AvatarPath + "/" + imgPath; this.memberServer.Update(u); ViewData["AlterFaceResult"] = "上传成功"; } else { ViewData["AlterFaceResult"] = "上传文件类型错误"; } } else { ViewData["AlterFaceResult"] = "上传文件大小超出限制," + MyPath.fileSize + "k以内"; } } else { ViewData["AlterFaceResult"] = "上传失败"; } return(View("AlterFace")); }
public ActionResult Register(string username, string pwd, string phone) { try { if (base.LoginMember != null) { return(Redirect("/User/Index")); } Model.Store.Member member = new Model.Store.Member(); member.AddTime = DateTime.Now; member.LastTime = DateTime.Now; member.LoginName = username; member.Password = Common.CryptoHelper.MD5Encrypt(pwd); member.Phone = phone; member.State = 1; member.AvatarPath = base.Config.DefaultAvatar; base.memberServer.Insert(member); return(View("RegisterSuccess")); } catch { return(View("RegisterFail")); } }