/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="request"></param>
public void UpdateSYSUserInfo(SYSUserInfoRequest request)
{
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Proc_UpdateUserInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", request.ID);
cmd.Parameters[0].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@UserName", request.UserName);
cmd.Parameters[1].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@Password", request.Password);
cmd.Parameters[2].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@CompanyName", request.CompanyName);
cmd.Parameters[3].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@BusinessContact", request.BusinessContact);
cmd.Parameters[4].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@FinancialContact", request.FinancialContact);
cmd.Parameters[5].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@Email", request.Email);
cmd.Parameters[6].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@Tel", request.Tel);
cmd.Parameters[7].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@Address", request.Address);
cmd.Parameters[8].SqlDbType = SqlDbType.VarChar;
cmd.Parameters.AddWithValue("@State", request.State);
cmd.Parameters[9].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@UserType", request.UserType);
cmd.Parameters[10].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@RoleID", request.RoleID);
cmd.Parameters[11].SqlDbType = SqlDbType.Int;
cmd.CommandTimeout = 600;
conn.Open();
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// 拼接用户查询条件
/// </summary>
/// <param name="request">请求条件</param>
/// <returns>请求条件字符串</returns>
private string GetUserListCondition(SYSUserInfoRequest request)
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(request.UserName))
{
sb.Append(" AND sui.UserName LIKE '%" + request.UserName + "%'");
}
if (!string.IsNullOrEmpty(request.CompanyName))
{
sb.Append(" AND sui.CompanyName LIKE '%" + request.CompanyName + "%'");
}
if (request.UserType != -1)
{
sb.Append(" AND sui.UserType = " + request.UserType);
}
if (!string.IsNullOrEmpty(request.StartCreateTime))
{
sb.Append(" AND sui.CreateTime >='" + request.StartCreateTime + "'");
}
if (!string.IsNullOrEmpty(request.EndCreateTime))
{
sb.Append(" AND sui.CreateTime <='" + request.EndCreateTime + " 23:59:59'");
}
return(sb.ToString());
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public JsonResult UserLogin(CommonRequest request)
{
string msg = string.Empty;
ResponseData res = new ResponseData();
SYSUserInfoRequest condition = new SYSUserInfoRequest();
SYSUserInfoResponse info = new SYSUserInfoResponse();
List <SYSUserInfoResponse> list = new List <SYSUserInfoResponse>();
res.code = 401;
TokenInfo token = new TokenInfo();
try
{
if (request.requestData != null)
{
condition = JsonHelper.DeserializeJsonToObject <SYSUserInfoRequest>(request.requestData);
}
}
catch (Exception ex)
{
res.code = 0;
res.msg = "JSON字符串转数组对象错误" + ex.Message;
return(Json(res));
}
try
{
info = service.VerificationLogin(condition.UserName, condition.Password);
if (info != null)
{
//默认session会在20分钟内过期，设置一天过期
Session.Timeout = 1440;
Session["UserInfo"] = info;//保存用户信息对象
//保存签证信息
token.iss = "SFProject";
token.aud = "*****@*****.**";
token.sub = "Genious.com";
token.jti = DateTime.Now.ToString("yyyyMMddhhmmss");
token.OpUserID = info.ID.ToString();
token.UserId = info.ID;
token.UserName = info.UserName;
token.UserPwd = info.Password;
token.Status = info.State;
//生成令牌
msg = CommonToken.GetToken(token);
list.Add(info);
res.code = 200;
res.data = list;
res.msg = info.State == 1 ? msg : "false";
}
}
catch (Exception ex)
{
LogUtil.LogException(ex);
res.msg = ex.Message;
}
return(Json(res));
}
/// <summary>
/// 根据条件获取用户列表
/// </summary>
/// <param name="request">请求条件</param>
/// <returns>用户列表</returns>
public IEnumerable <SYSUserInfoResponse> GetUserList(SYSUserInfoRequest request)
{
string where = GetUserListCondition(request);
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, where, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, request.PageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, request.PageSize, ParameterDirection.Input)
};
return(this.ExecuteDataTable("Proc_GetUserList", dbParams).ConvertToEntityCollection <SYSUserInfoResponse>());
}
public Response <bool> CheckNameIsExist(SYSUserInfoRequest request)
{
Response <bool> response = new Response <bool>();
try
{
response.IsSuccess = accessor.CheckNameIsExist(request.UserName, request.ID);
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.Exception = ex;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public Response <bool> AddSYSUserInfo(SYSUserInfoRequest request)
{
Response <bool> response = new Response <bool>();
try
{
accessor.AddSYSUserInfo(request);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.Exception = ex;
response.ErrorCode = ErrorCode.Technical;
}
return(response);
}
public Response <IEnumerable <SYSUserInfoResponse> > GetUserList(SYSUserInfoRequest request)
{
Response <IEnumerable <SYSUserInfoResponse> > response = new Response <IEnumerable <SYSUserInfoResponse> >();
try
{
response.Result = accessor.GetUserList(request);
response.IsSuccess = true;
}
catch (Exception ex)
{
LogError(ex);
response.IsSuccess = false;
response.ErrorCode = ErrorCode.Technical;
response.Exception = ex;
}
return(response);
}
