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);
}
