/// <summary>
/// 新增帐号权限数据
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool InsertAccountPermission(AccountPermission data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(ACCOUNTID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.AccountId),
MakeParam(GROUPID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GroupId),
MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId),
MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName)
};
if (Execute("InsertAccountPermission", Params, out strErrText) >= 0)
return true;
else
return false;
}
/// <summary>
/// 修改帐号权限
/// </summary>
/// <param name="nAccountId"></param>
/// <param name="listGroup"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool UpdateAccountPermissions(long nAccountId, List<SysGroup> listGroup, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
//删除原帐号权限
if (!dao.DeleteAccountPermissions(nAccountId, nOpStaffId, strOpStaffName, out strErrText))
return false;
//新增岗位权限
if (listGroup != null)
{
foreach (SysGroup g in listGroup)
{
AccountPermission p = new AccountPermission();
p.AccountId = nAccountId;
p.GroupId = g.Id;
if (!dao.InsertAccountPermission(p, nOpStaffId, strOpStaffName, out strErrText))
{
return false;
}
}
}
}
transScope.Complete();
}
return true;
}
catch (Exception e)
{
strErrText = e.Message;
return false;
}
}
