public IHttpActionResult AddUser(UsrDto us)
{
return(Ok(Bl.UserBl.AddUser(us)));
// if (b)
// return Ok();
// return BadRequest();
}
public IHttpActionResult UpdateUser([FromBody] UsrDto us)
{
bool b = Bl.UserBl.UpdateUser(us);
if (b)
return Ok();
return BadRequest();
}
public IHttpActionResult Register([FromBody] UsrDto user)
{
bool b = bl.Userbl.Regiater(user);
if (b == true)
{
return(Ok());
}
return(BadRequest());
}
public static bool AddUser(UsrDto us)
{
using (kindergardenEntities db = new kindergardenEntities())
{
Users poDal = UsrDto.Todal(us);
int id = 0;
id += UserDal.AddUser(poDal);
if (id != 0)
return true;
}
return false;
}
public UsrDto Regsit(UsrDto dddd)
{
var code = VerifyCodeClass.YzmCode;
if (dddd.YZM.ToLower() != code.ToLower())
{
return(new UsrDto {
Error = "验证码填写错误！"
});
}
return(RegisterSub(dddd));
}
public static bool UpdateUser(UsrDto us)
{
using (kindergardenEntities db = new kindergardenEntities())
{
bool id = false;
Users poDal = UsrDto.Todal(us);
string v = us.childId;
if (poDal.UserName != null && poDal.Password != null)
id = UserDal.UpdateUser(poDal, v);
return id;
}
return false;
}
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 string UpdateUser(string loginName, UsrDto usrdata)
{
string sql = "select ID from huangguan_user where NickName =N'{0}'".FormatStr(usrdata.NickName);
DataTable dt = MySqlDbHelper.ExecuteQuery(connCommonsStr, sql);
if (dt.Rows.Count > 0)
{
return("用户昵称已经存在了，请换一个！");
}
string updatesql = @"update huangguan_user set NickName=N'{0}',UserPhone='{1}',UserEmail='{2}'
where LoginName=N'{3}'".FormatStr(usrdata.NickName, usrdata.UserPhone, usrdata.UserEmail, loginName);
int count = MySqlDbHelper.ExecuteSql(connCommonsStr, updatesql);
return(count > 0 ? "成功！" : "失败！");
}
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 = "用户名或密码不对"
});
}
}
public static bool Regiater(UsrDto user)
{
Users u = UsrDto.Todal(user);
return UserDal.Register(u);
}
