public UsrDto RegisterSub(UsrDto dddd) { if (string.IsNullOrEmpty(dddd.LoginName) || string.IsNullOrEmpty(dddd.LoginPwd)) { return new UsrDto { Error = "用户名和密码不能为空" } } ; string selsql = @"select ID from huangguan_user where LoginName=N'{0}'" .FormatStr(dddd.LoginName); DataTable dtq = MySqlDbHelper.ExecuteQuery(connCommonsStr, selsql); if (dtq.Rows.Count > 0) { return(new UsrDto { Error = "用户名已经存在" }); } else { var md5 = EncryptHelper.GetEncryPwd(dddd.LoginPwd); Guid id = Guid.NewGuid(); string insertsql = @"insert into huangguan_user(ID,LoginName,LoginPwd,NickName,UserPhone,RoleId,UserEmail,status,CreatedAt) values('{0}',N'{1}','{2}',N'{3}','{4}','{5}','{6}','{7}','{8}')".FormatStr(id, dddd.LoginName, md5, dddd.LoginName, dddd.UserPhone, 2, dddd.UserEmail, 0, DateTime.Now); int resultrow = MySqlDbHelper.ExecuteSql(connCommonsStr, insertsql); if (resultrow > 0) { UsrDto dto = new UsrDto(); dto.ID = id; dto.LoginName = dddd.LoginName; dto.LoginPwd = md5.ToString(); dto.NickName = dddd.LoginName; dto.UserPhone = dddd.UserPhone; dto.HeadIcon = ""; dto.RoleId = "2"; dto.UserEmail = dddd.UserEmail; dto.status = 0; dto.CreatedAt = DateTime.Now; dto.Token = IprAuthorizeAttribute.GetToken(dto.LoginName, 0); return(dto); } else { return(new UsrDto { Error = "注册失败,请重新填写!" }); } } }
public UsrDto Login(string usr_name, string pwd) { if (string.IsNullOrEmpty(usr_name) || string.IsNullOrEmpty(pwd)) { return new UsrDto { Error = "用户名和密码不能为空" } } ; Guid md5 = EncryptHelper.GetEncryPwd(pwd); //var _usr = comm.usrs.FirstOrDefault(x => x.UsrName == usr_name && x.PwdMD5 == md5); //if (_usr == null) // return new UsrDto { Error = "用户名或密码不对" }; string selsql = @"select ID,LoginName,LoginPwd,NickName,UserPhone,HeadIcon,RoleId,UserEmail,status,CreatedAt from huangguan_user where LoginName=N'{0}' and LoginPwd='{1}'" .FormatStr(usr_name, md5); DataTable dtq = MySqlDbHelper.ExecuteQuery(connCommonsStr, selsql); if (dtq.Rows.Count > 0) { UsrDto dto = new UsrDto(); dto.ID = Guid.Parse(dtq.Rows[0]["ID"].ToString()); dto.LoginName = dtq.Rows[0]["LoginName"].ToString(); dto.LoginPwd = dtq.Rows[0]["LoginPwd"].ToString(); dto.NickName = dtq.Rows[0]["NickName"].ToString(); dto.UserPhone = dtq.Rows[0]["UserPhone"].ToString(); dto.HeadIcon = dtq.Rows[0]["HeadIcon"].ToString(); dto.RoleId = dtq.Rows[0]["RoleId"].ToString(); dto.UserEmail = dtq.Rows[0]["UserEmail"].ToString(); dto.status = Convert.ToInt32(dtq.Rows[0]["status"].ToString()); dto.CreatedAt = Convert.ToDateTime(dtq.Rows[0]["CreatedAt"].ToString()); dto.Token = IprAuthorizeAttribute.GetToken(dto.LoginName, 0); return(dto); } else { return(new UsrDto { Error = "用户名或密码不对" }); } }