public static string AddUserLogin(UserLogin login, UserGroup group, PermissionInfo permission, UserRole role)
{
try
{
//查询
UserLogin info = UserLoginOperation.GetUserLoginInfoByName(login.loginName);
if (null == info)
{
//添加用户登录账号信息
UserLoginOperation.AddOrUpdateUserLoginInfo(info, EnumAddOrUpdate.Add);
//添加用户组信息
UserGroupOperation.AddOrUpdateUserGroupInfo(group, EnumAddOrUpdate.Add);
//添加用户权限信息
PermissionOperation.AddOrUpdatePermission(permission, EnumAddOrUpdate.Add);
//添加用户角色信息
UserRoleOperation.AddOrUpdateUserRoleInfo(role, EnumAddOrUpdate.Add);
return(string.Format("添加登录账号【{0}】信息成功！", login.loginName));
}
else
{
return(string.Format("系统已存在【{0}】登录账号！", info.loginName));
}
}
catch (Exception ex)
{
log.Error("AddUserLogin()发生错误,错误信息如下:{0}", ex);
return(string.Format("添加登录账号失败,错误信息如下:{0}", ex.Message));
}
}
public bool PermissionOperationSave(PermissionOperation obj)
{
bool retVal = true;
string procName = (obj.Id == 0 ? "dbo.PermissionOperation_New" : "dbo.PermissionOperation_Edit");
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_FdpPermissionOperationId", obj.FdpPermissionOperationId, dbType: DbType.Int32);
para.Add("@p_FdpPermissionObjectType", obj.FdpPermissionObjectType, dbType: DbType.String, size: 50);
para.Add("@p_Operation", obj.Operation, dbType: DbType.String, size: 25);
para.Add("@p_Description", obj.Description, dbType: DbType.String, size: -1);
if (obj.Id == 0)
{
para.Add("@p_Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
}
else
{
para.Add("@p_Id", obj.Id, dbType: DbType.Int32);
}
conn.Execute(procName, para, commandType: CommandType.StoredProcedure);
if (obj.Id == 0)
{
obj.Id = para.Get <int>("@p_Id");
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public PermissionOperation PermissionOperationGet(int id)
{
PermissionOperation retVal = null;
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_Id", id, dbType: DbType.Int32);
retVal = conn.Query <PermissionOperation>("dbo.PermissionOperation_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
