public JResult GetUserInfo(BaseUserModel model) { return _baseservice.GetUserInfo(model); }
/// <summary> /// 编辑用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateUser(BaseUserModel model) { var sql = new StringBuilder("update `sys_user` set "); sql.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sql.Append(" where innerid = @innerid"); int result; try { result = Helper.Execute(sql.ToString(), model); } catch (Exception ex) { result = 0; } return result; }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddUser(BaseUserModel model) { const string sql = @"INSERT INTO `sys_user` (`innerid`,`no`, `username`, `loginname`, `password`, `mobile`, `telephone`, `email`, `status`, `createdtime`, `modifiedtime`,depid,`level`) VALUES (@innerid,@no, @username, @loginname, @password, @mobile, @telephone, @email, @status, now(), now(),@depid,@level);"; using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { //生成编号 var obj = new { p_tablename = "sys_user", p_columnname = "no", p_prefix = "S", p_length = 4, p_hasdate = 0 }; var args = new DynamicParameters(obj); args.Add("p_value", dbType: DbType.String, direction: ParameterDirection.Output); args.Add("p_errmessage", dbType: DbType.String, direction: ParameterDirection.Output); using (conn.QueryMultiple("sp_automaticnumbering", args, commandType: CommandType.StoredProcedure)) {} model.no = args.Get<string>("p_value"); if (string.IsNullOrWhiteSpace(model.no)) { var msg = args.Get<string>("p_errmessage"); LoggerFactories.CreateLogger().Write("销售编号生成失败:" + msg, TraceEventType.Error); return -1; } conn.Execute(sql, model, tran); tran.Commit(); return 1; } catch (Exception ex) { tran.Rollback(); return 0; } } }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public IEnumerable<BaseUserModel> GetUserInfo(BaseUserModel model) { StringBuilder sql = new StringBuilder(); sql.Append(@"select * from sys_user where 1=1 "); var sqlWhere = new StringBuilder(); //用户名 if (!string.IsNullOrWhiteSpace(model.loginname)) { sqlWhere.AppendFormat(" and loginname ='{0}' ", model.loginname); } //部门 if (!string.IsNullOrWhiteSpace(model.depid)) { sqlWhere.AppendFormat(" and depid ='{0}' ", model.depid); } //等级 if (model.level.HasValue) { sqlWhere.AppendFormat(" and level ={0} ", model.level); } sql.Append(sqlWhere.ToString()); var menuList = Helper.Query<BaseUserModel>(sql.ToString()); return menuList; }