/// <summary>
/// 添加系统用户
/// </summary>
/// <param name="user">
/// 系统用户对象
/// </param>
/// <returns>
/// 系统用户编号
/// </returns>
public int AddUser(System_User user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
return this.systemUserDA.Insert(user);
}
/// <summary>
/// 添加系统用户
/// </summary>
/// <param name="user">
/// 系统用户对象
/// </param>
/// <returns>
/// 主键编号
/// </returns>
public int Insert(System_User user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
int id;
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
user.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"RoleID",
SqlDbType.Int,
user.RoleID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"LoginName",
SqlDbType.VarChar,
user.LoginName,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"LoginPassword",
SqlDbType.VarChar,
user.LoginPassword,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
user.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
user.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
user.CreateTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_User_Insert", parameters, null);
id = (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
catch (Exception exception)
{
throw new Exception("Exception - SystemUserDA - Insert", exception);
}
return id;
}
/// <summary>
/// 修改系统用户
/// </summary>
/// <param name="user">
/// 系统用户对象
/// </param>
public void Update(System_User user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
user.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
user.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"RoleID",
SqlDbType.Int,
user.RoleID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.NVarChar,
user.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"LoginName",
SqlDbType.NVarChar,
user.LoginName,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
user.Status,
ParameterDirection.Input)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_User_Update", parameters, null);
}
catch (Exception exception)
{
throw new Exception("Exception - SystemUserDA - Update", exception);
}
}
/// <summary>
/// 修改系统用户
/// </summary>
/// <param name="user">
/// 系统用户对象
/// </param>
public void ModifyUser(System_User user)
{
this.systemUserDA.Update(user);
}
/// <summary>
/// The setup session.
/// </summary>
/// <param name="user">
/// The user.
/// </param>
private void SetupSession(System_User user)
{
var topMenus = new List<MenuModel>();
var leftMenus = new List<MenuModel>();
var userRights = new SystemRightsService().QueryUserRight(user.ID);
var systemMenuService = new SystemMenuService();
var userTopMenus = systemMenuService.GetUserTopMenus(userRights);
foreach (var systemMenu in userTopMenus)
{
topMenus.Add(DataTransfer.Transfer<MenuModel>(systemMenu, typeof(System_Menu)));
}
var userLeftMenus = systemMenuService.GetUserLeftMenus(userRights);
foreach (var systemMenu in userLeftMenus)
{
leftMenus.Add(DataTransfer.Transfer<MenuModel>(systemMenu, typeof(System_Menu)));
}
var systemUserSession = new SystemUserSession
{
SessionID = this.Session.SessionID,
SystemUserID = user.ID,
// EmployeeID = user.ID, //暂时将EmployeeID设置为SystemUserId，未来将修改数据表，将EmployeeId改为SystemUserID
Name = user.Name,
LoginName = user.LoginName,
RoleID = user.RoleID,
TopMenus = topMenus,
LeftMenus = leftMenus,
Permissions = userRights,
LastVisitTime = DateTime.Now
};
MongoDBHelper.RefreshSystemUserSession(systemUserSession);
}
