/// <summary>
/// 根据用户编号，修改用户信息，得到操作结果
/// </summary>
/// <param name="userModel"></param>
/// <returns></returns>
public string UpdateUser(sys_UsersModel userModel)
{
JsonMessage json = new JsonMessage();
DataSet ds = sys_UserDAL.GetUsersInfoByWhere(" UserName='******' and UserId !=" + userModel.UserId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
json.Success = false;
json.Msg = "用户名已经被别人占用，请更换";
}
else
{
int number = sys_UserDAL.UpdateUser(userModel);
if (number > 0)
{
json.Success = true;
json.Msg = "用户修改成功";
}
else if (number == 0)
{
json.Success = false;
json.Msg = "用户修改失败";
}
else
{
json.Success = false;
json.Msg = "用户修改出错";
}
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 添加用户信息到数据库中，得到返回结果
/// </summary>
/// <param name="userModel">用户实体对象</param>
/// <returns></returns>
public string AddUser(sys_UsersModel userModel)
{
JsonMessage json = new JsonMessage();
if (sys_UserDAL.GetUsersModelByUserName(userModel.UserName) == null)
{
int number = sys_UserDAL.InsertUser(userModel);
if (number > 0)
{
json.Success = true;
json.Msg = "用户添加成功";
}
else if (number == 0)
{
json.Success = false;
json.Msg = "用户添加失败";
}
else
{
json.Success = false;
json.Msg = "用户添加出错";
}
}
else
{
json.Success = false;
json.Msg = "该用户名已存在";
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 根据用户名查询该用户信息，返回用户实体类对象
/// </summary>
/// <param name="userName">用户名</param>
/// <returns></returns>
public sys_UsersModel GetUsersModelByUserName(string userName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserId,UserName,UserPassword,RealName,SubordinateEnterprise,UserType,UserState from sys_Users ");
strSql.Append(" where UserName=@UserName ");
SqlParameter[] paras =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 20)
};
paras[0].Value = userName;
SqlDataReader reader = DBHelper.ExecuteReader(strSql.ToString(), paras);
sys_UsersModel userModel = new sys_UsersModel();
if (reader != null)
{
while (reader.Read())
{
userModel.UserId = reader.GetInt32(0);
userModel.UserName = reader.GetString(1);
userModel.UserPassword = reader.GetString(2);
userModel.RealName = reader.GetString(3);
userModel.SubordinateEnterprise = reader.GetInt32(4);
userModel.UserType = reader.GetInt32(5);
userModel.UserState = reader.GetInt32(6);
}
}
else
{
return(null);
}
reader.Close();
return(userModel);
}
/// <summary>
/// 将用户对象添加到数据库中，得到对数据库的影响行数，大于0表示插入成功 0表示插入失败 小于0表示插入出错
/// </summary>
/// <param name="userModel">用户实体对象</param>
/// <returns></returns>
public int InsertUser(sys_UsersModel userModel)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_Users (UserName,UserPassword,RealName,");
strSql.Append("SubordinateEnterprise,UserType,UserState)");
strSql.Append(" values (@UserName,@UserPassword,@RealName,");
strSql.Append("@SubordinateEnterprise,@UserType,@UserState)");
SqlParameter[] paras =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 20),
new SqlParameter("@UserPassword", SqlDbType.VarChar, 20),
new SqlParameter("@RealName", SqlDbType.VarChar, 10),
new SqlParameter("@SubordinateEnterprise", SqlDbType.Int, 4),
new SqlParameter("@UserType", SqlDbType.Int, 4),
new SqlParameter("@UserState", SqlDbType.Int)
};
paras[0].Value = userModel.UserName;
paras[1].Value = userModel.UserPassword;
paras[2].Value = userModel.RealName;
paras[3].Value = userModel.SubordinateEnterprise;
paras[4].Value = userModel.UserType;
paras[5].Value = userModel.UserState;
int number = DBHelper.ExecuteNonQuery(strSql.ToString(), paras);
return(number);
}
catch (Exception ex)
{
return(-1);
throw ex;
}
}
/// <summary>
/// 根据用户编号，原始密码，新密码进行修改用户密码，得到操作结果
/// </summary>
/// <param name="uid">用户编号</param>
/// <param name="mpass">用户原始密码</param>
/// <param name="newpass">用户新密码</param>
/// <returns></returns>
public string UpdatePassword(string uid, string mpass, string newpass)
{
JsonMessage json = new JsonMessage();
try
{
sys_UsersModel usersModel = sys_UserDAL.GetUsersModelByUserId(int.Parse(uid));
if (usersModel != null)
{
if (string.Equals(usersModel.UserPassword, mpass))
{
int number = sys_UserDAL.UpdatePasswordByUserId(int.Parse(uid), newpass);
if (number > 0)
{
json.Success = true;
json.Msg = "密码修改成功，请重新登录！";
}
else
{
json.Success = false;
json.Msg = "密码修改失败";
}
}
else
{
json.Success = false;
json.Msg = "原始密码不正确";
}
}
else
{
json.Success = false;
json.Msg = "该用户不存在";
}
}
catch (Exception ex)
{
json.Success = false;
json.Msg = "密码修改出错";
throw ex;
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 根据用户编号，查询出该用户信息，返回用户实体类对象
/// </summary>
/// <param name="userId">用户编号</param>
/// <returns></returns>
public sys_UsersModel GetUsersModelByUserId(int userId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserId,UserName,UserPassword,RealName,SubordinateEnterprise,CompanyName,");
strSql.Append("UserType,UserState from sys_Users left join sys_Company on sys_Users.SubordinateEnterprise = sys_Company.CompanyId ");
strSql.Append(" where UserId=@UserId");
SqlParameter[] paras =
{
new SqlParameter("@UserId", SqlDbType.Int, 4)
};
paras[0].Value = userId;
SqlDataReader reader = DBHelper.ExecuteReader(strSql.ToString(), paras);
sys_UsersModel userModel = new sys_UsersModel();
if (reader != null)
{
while (reader.Read())
{
userModel.UserId = reader.GetInt32(0);
userModel.UserName = reader.GetString(1);
userModel.UserPassword = reader.GetString(2);
userModel.RealName = reader.GetString(3);
try
{
userModel.SubordinateEnterprise = reader.GetInt32(4);
}
catch
{
userModel.SubordinateEnterprise = 0;
}
userModel.UserType = reader.GetInt32(6);
userModel.UserState = reader.GetInt32(7);
}
}
else
{
return(null);
}
reader.Close();
return(userModel);
}
/// <summary>
/// 根据用户名与密码，判断该用户是否能成功登录，返回提示信息
/// </summary>
/// <param name="name">用户名</param>
/// <param name="password">用户密码</param>
/// <returns></returns>
public string Login(string name, string password)
{
JsonMessage json = new JsonMessage();
sys_UsersModel userModel = sys_UserDAL.GetUsersModelByUserName(name);
if (userModel == null)
{
json.Success = false;
json.Msg = "用户名不存在";
}
else
{
if (userModel.UserState == 1)
{
if (string.Equals(userModel.UserPassword, password))
{
json.Success = true;
json.Msg = "登录成功";
StringBuilder str = new StringBuilder();
str.Append(userModel.UserId + ",");
str.Append(userModel.UserName + ",");
str.Append(userModel.SubordinateEnterprise + ",");
str.Append(userModel.UserType);
json.Obj = str.ToString();
}
else
{
json.Success = false;
json.Msg = "密码不正确";
}
}
else
{
json.Success = false;
json.Msg = "该用户已被停用";
}
}
return(JsonHelper.ToJson(json));
}
/// <summary>
/// 根据用户对象，进行数据修改，得到对数据影响行数 大于0表示修改成功 等于0表示修改失败 小于0表示修改出错
/// </summary>
/// <param name="userModel">用户实体对象</param>
/// <returns></returns>
public int UpdateUser(sys_UsersModel userModel)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_Users set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPassword=@UserPassword,");
strSql.Append("RealName=@RealName,");
strSql.Append("SubordinateEnterprise=@SubordinateEnterprise,");
strSql.Append("UserType=@UserType,");
strSql.Append("UserState=@UserState");
strSql.Append(" where UserId=@UserId");
SqlParameter[] paras =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 20),
new SqlParameter("@UserPassword", SqlDbType.VarChar, 20),
new SqlParameter("@RealName", SqlDbType.VarChar, 10),
new SqlParameter("@SubordinateEnterprise", SqlDbType.Int, 4),
new SqlParameter("@UserType", SqlDbType.Int, 4),
new SqlParameter("@UserState", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int)
};
paras[0].Value = userModel.UserName;
paras[1].Value = userModel.UserPassword;
paras[2].Value = userModel.RealName;
paras[3].Value = userModel.SubordinateEnterprise;
paras[4].Value = userModel.UserType;
paras[5].Value = userModel.UserState;
paras[6].Value = userModel.UserId;
int numbers = DBHelper.ExecuteNonQuery(strSql.ToString(), paras);
return(numbers);
}
catch (Exception ex)
{
return(-1);
throw ex;
}
}
private string UpdateUser(HttpContext context)
{
try
{
sys_UsersModel userModel = new sys_UsersModel();
userModel.UserId = int.Parse(context.Request.Form["userid"].ToString());
userModel.UserName = context.Request.Form["username"].ToString();
userModel.UserPassword = context.Request.Form["userpassword"].ToString();
userModel.RealName = context.Request.Form["realname"].ToString();
userModel.SubordinateEnterprise = int.Parse(context.Request.Form["subor"].ToString());
userModel.UserType = int.Parse(context.Request.Form["usertype"].ToString());
userModel.UserState = int.Parse(context.Request.Form["userstate"].ToString());
string result = usersBLL.UpdateUser(userModel);
return(result);
}
catch (Exception ex)
{
return("{\"Success\":\"False\",\"Msg\":\"用户信息类型转换出错\"}");
throw;
}
}
/// <summary>
/// 根据用户编号，查询该用户信息
/// </summary>
/// <param name="uid">用户编号</param>
/// <returns></returns>
public string GetUserModelByUserId(int uid)
{
sys_UsersModel userModel = sys_UserDAL.GetUsersModelByUserId(uid);
return(JsonHelper.ToJson(userModel));
}
