public int UpdateUser(tblusers usr) { using (var db = new BFdbContext()) { var tusr = db.tblusers.FirstOrDefault(p => p.userid == usr.userid); if (tusr == null) { return(-1); } else { tusr.birthday = usr.birthday; tusr.cardno = usr.cardno; tusr.cardtype = usr.cardtype; tusr.Mobile = usr.Mobile; tusr.Name = usr.Name; tusr.sexy = usr.sexy; tusr.Isupt = "1"; tusr.Ismod = "1"; tusr.Modtime = DateTime.Now; // or match_id='6a61b95b-2d5d-4373-abaf-bf4e4c438800') string sql = string.Format(@"update tbl_match_users set birthday='{0}',age={1},cardno='{2}',cardtype='{3}',sexy={4},mobile='{5}',nickname='{6}' where userid='{7}' and (match_id in (select match_id from tbl_match where status in (0,1)) or match_id='c83aa363-873e-489e-ac07-373489c94320')", tusr.birthday.Value.ToString("yyyy-MM-dd"), SetYearOld(tusr.birthday.Value), tusr.cardno, tusr.cardtype, tusr.sexy, tusr.Mobile, tusr.Name, tusr.userid); db.ExecuteSqlCommand(sql); return(db.Update <tblusers>(tusr)); } } }
public JsonResult edituser(tblusers user) { if (!user.birthday.HasValue) { return(RepReurnError("请检查出生日期格式是否正确")); } MembershipBll bll = new MembershipBll(); int res = bll.UpdateUser(user); if (res >= 0) { return(RepReurnOK()); } else if (res == -2) { return(RepReurnError("这个身份证号已经被注册")); } else if (res == -3) { return(RepReurnError("你的年龄不是在16-60之间")); } else { return(RepReurnError("操作中出现错误")); } }
/// <summary> /// 删除会员 /// </summary> /// <param name="ids"></param> /// <returns></returns> public int DeleteMember(List <string> ids) { using (var db = new BFdbContext()) { int res = 0; using (var tx = db.BeginTransaction()) { try { foreach (string id in ids) { tblusers ent = db.tblusers.FirstOrDefault(p => p.userid == id); ent.Status = 2; db.TUpdate <tblusers>(ent); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { tx.Rollback(); throw ex; } } return(res); } }
public ActionResult Create(FormCollection fc) { var model = new tblusers(); model.userid = Guid.NewGuid().ToString(); model.Mobile = fc["Mobile"].ToString(); model.Passwd = MD5Encrypt(fc["Passwd"].ToString()); model.sexy = fc["optSexy"].ToString(); model.cardtype = fc["optCardType"].ToString(); model.cardno = fc["cardno"].ToString(); model.mono = "-"; if (fc["birthday"] != "") { model.birthday = DateTime.Parse(fc["birthday"].ToString()); } model.Status = Int32.Parse(fc["optStatus"].ToString()); var bll = new MemberBll(); try { bll.AddMember(model); } catch (ValidException ex) { this.ModelState.AddModelError(ex.Name, ex.Message); return(View(model)); } return(this.RefreshParent()); }
public string InsertsToTUBUSER(string posted) { tblusers obj = JsonConvert.DeserializeObject <tblusers>(posted); sessionCaptcha = obj.Captcha; PDBC db = new PDBC("WebForm1"); db.Connect(); return(db.Script($"INSERT INTO [tblusers] ([FirstName] ,[LastName],[UserName],[Email],[Password]) VALUES (N'{obj.FirstName}', N'{obj.LastName}', N'{obj.UserName}', N'{obj.Email}',N'{obj.Password}')")); }
/// <summary> /// 团队导入 /// </summary> /// <param name="data"></param> /// <returns></returns> public int ImpTeams(DataTable data) { using (var db = new BFdbContext()) { tblusers usr = new tblusers(); //usr.Mobile = mobile; usr.mono = VerifyCode.Get6SzCode(); usr.Status = 6; return(db.Insert <tblusers>(usr)); } }
/// <summary> /// 团队注册1步 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public int Step1(string mobile) { using (var db = new BFdbContext()) { tblusers usr = new tblusers(); usr.Mobile = mobile; usr.mono = VerifyCode.Get6SzCode(); usr.Status = 6; return(db.Insert <tblusers>(usr)); } }
/// <summary> /// 新增会员 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int AddMember(tblusers ent) { using (var db = new BFdbContext()) { if (db.tblusers.Any(u => u.Mobile == ent.Mobile)) { throw new ValidException("Mobile", "已存在此名称的电话!"); } ent.Last_Time = DateTime.Now; return(db.Insert <tblusers>(ent)); } }
/// <summary> /// 用户注册时,生成验证码 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public int GetSMS(string mobile, string ip) { using (var db = new BFdbContext()) { if (db.tblusers.Any(p => p.Mobile == mobile && p.Status == 0)) { return(-1); } DateTime dt = DateTime.Now.AddDays(-2); int cntt = db.tbluserstime.Count(p => p.RomateIp == ip && p.crtdate >= dt); if (cntt >= 10) { return(-3); } int cnt = db.tbluserstime.Count(p => p.Mobile == mobile && p.crtdate >= dt); if (cnt >= 10) { return(-2); } tblusers usr = new tblusers(); usr.Mobile = mobile; usr.Passwd = "-"; usr.mono = VerifyCode.Get6SzCode(); //测试注册验证码改成固定数值 //usr.mono = "123456"; usr.Status = 4; usr.Playerid = 0; usr.userid = Guid.NewGuid().ToString(); usr.Isupt = "0"; usr.Type = "8"; usr.Ismod = ""; int res = db.Insert <tblusers>(usr); tbluserstime tm = new tbluserstime(); tm.crtdate = DateTime.Now; tm.Mobile = mobile; tm.tid = Guid.NewGuid().ToString(); tm.RomateIp = ip; db.Insert <tbluserstime>(tm); if (res > 0) { SMSHepler.SendRegSms(mobile, usr.mono); } return(res); } }
/// <summary> /// 更新会员 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int EditMember(tblusers ent) { using (var db = new BFdbContext()) { tblusers usr = db.tblusers.FirstOrDefault(p => p.userid == ent.userid); usr.Passwd = ent.Passwd; usr.sexy = ent.sexy; usr.cardtype = ent.cardtype; usr.cardno = ent.cardno; usr.birthday = ent.birthday; usr.Status = ent.Status; return(db.Update <tblusers>(usr)); } }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { HttpCookie cookie = filterContext.HttpContext.Request.Cookies["coc_cookie_info"]; if (cookie != null) { //已经登录 userinfo = new tblusers(); userinfo.userid = cookie.Values.Get("uuid"); userinfo.Name = cookie.Values.Get("uunm"); ViewBag.uuid = userinfo.userid; ViewBag.uunm = HttpUtility.HtmlEncode(userinfo.Name); } base.OnActionExecuting(filterContext); }
/// <summary> /// 忘记密码时,生成验证码 /// </summary> /// <param name="mobile"></param> /// <returns></returns> public int GetGSMS(string mobile) { using (var db = new BFdbContext()) { tblusers usr = db.tblusers.FirstOrDefault(p => p.Mobile == mobile && p.Status == 0); if (usr == null) { return(-1); } usr.mono = VerifyCode.Get6SzCode(); int res = db.Update <tblusers>(usr); if (res > 0) { SMSHepler.SendGetSms(mobile, usr.mono); } return(res); } }
public ActionResult my(FormCollection fc) { if (UserInfo == null) { return(RedirectToAction("login", "member")); } var model = new tblusers(); DateTime sr; if (DateTime.TryParse(fc["txtsr"], out sr)) { model.birthday = sr; } model.cardno = fc["txtcard"]; model.cardtype = fc["cbxcardtype"]; model.Mobile = fc["txtmobile"]; model.Name = fc["txtname"]; model.sexy = fc["cbxsexy"]; model.Isupt = "1"; model.userid = UserInfo.userid; MembershipBll bll = new MembershipBll(); int res = bll.UpdateUser(model); if (res < 0) { model.Status = -999; } else { model.Status = -888; } return(View(model)); }
public JsonResult checkuser(string acc, string pwd) { string md5Pwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "MD5"); MembershipBll bll = new MembershipBll(); tblusers user = bll.GetUser(acc, md5Pwd); string ip; GetWebClientIp(out ip); if (user == null) { bll.OptLog(1, "", ip, string.Format("用户[{0}]登录失败", acc)); return(RepReurnError("用户名或者密码输入错误")); } else { bll.UpdateUserLastTime(user.userid); bll.OptLog(1, user.userid, ip, string.Format("用户[{0}]成功登录", acc)); //保存用户信息 HttpCookie cookie = new HttpCookie("coc_cookie_info"); cookie.HttpOnly = false; //cookie.Expires = DateTime.Now.AddDays(7); System.Collections.Specialized.NameValueCollection nv = new System.Collections.Specialized.NameValueCollection(); nv.Add("uuid", user.userid); nv.Add("uunm", user.Name); cookie.Values.Add(nv); HttpContext.Response.SetCookie(cookie); return(RepReurn(0, user.Type, null)); } }
public JsonResult ImpTeams(string matchid) { try { DataTable data = NpoiHelper.XlSToDataTable(@"C:\Work\Vki\MyDoc\MyFile\dx_dev\定向赛团体报名统计表.xlsx", "test", 0); if (data == null || data.Rows.Count < 1) { return(RepReurnError("上传的文件中没有数据")); } StringBuilder sbtError = new StringBuilder(); List <tblusers> lstUsers = new List <tblusers>(); List <tblteams> lstTeams = new List <tblteams>(); List <tblmatchusers> lstMatchusers = new List <tblmatchusers>(); int sn = 0; string lineid = ""; string teamno = ""; string teamname = ""; string company = ""; foreach (DataRow row in data.Rows) { //记录序号,以标记团队 if (!string.IsNullOrEmpty(row["序号"].ToString().Trim())) { sn = int.Parse(row["序号"].ToString().Trim()); } if (!string.IsNullOrEmpty(row["线路号"].ToString().Trim())) { lineid = row["线路号"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["队列号"].ToString().Trim())) { teamno = row["队列号"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["队名(6个字符以内)"].ToString().Trim())) { teamname = row["队名(6个字符以内)"].ToString().Trim(); } if (!string.IsNullOrEmpty(row["公司名称"].ToString().Trim())) { company = row["公司名称"].ToString().Trim(); } if (string.IsNullOrEmpty(row["队员编号"].ToString().Trim())) { continue; } if (string.IsNullOrEmpty(row["性别"].ToString().Trim())) { sbtError.Append("[性别]不能为空;"); } if (string.IsNullOrEmpty(row["身份证/护照"].ToString().Trim())) { sbtError.Append("[身份证/护照]不能为空;"); } if (!System.Text.RegularExpressions.Regex.IsMatch(row["手机号"].ToString().Trim(), @"^[1]+[0-9]+\d{9}")) { sbtError.AppendFormat("[手机号:{0}]格式错误;", row["手机号"]); } tblusers usr = new tblusers(); usr.cardtype = "1"; usr.Mobile = row["手机号"].ToString().Trim(); usr.sexy = row["性别"].ToString().Trim() == "男" ? "1" : "0"; usr.Status = 1; usr.userid = Guid.NewGuid().ToString(); lstUsers.Add(usr); tblteams tm = new tblteams(); tm.teamid = Guid.NewGuid().ToString(); tm.Company = ""; tm.Createtime = DateTime.Now; tm.Eventid = 1; tm.Lineid = lineid; tm.match_id = matchid; tm.Status = 1; tm.Teamname = teamname; tm.Teamno = teamno; //tm.Userid lstTeams.Add(tm); } } catch (Exception ex) { ILog log = LogManager.GetLogger(this.GetType()); log.Error(ex); return(RepReurnError("导入过程中出现错误")); } return(RepReurnOK()); }
/// <summary> /// 保存登录信息 /// </summary> /// <param name="usr"></param> public static void Add(tblusers usr) { HttpContext.Current.Session.Add("pk_sid_user", usr); }