/// <summary>
/// 新增权限组
/// </summary>
/// <param name="strName"></param>
/// <param name="strRemark"></param>
/// <param name="listFunction"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public long InsertPermissionGroup(string strName, string strRemark, List<SysFunction> listFunction, long nOpStaffId, string strOpStaffName, out string strErrText)
{
long nGroupId = 0;
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
//新增权限组
nGroupId = dao.InsertPermissionGroup(strName, strRemark, nOpStaffId, strOpStaffName, out strErrText);
if (nGroupId <= 0)
return 0;
//新增组权限
foreach (SysFunction f in listFunction)
{
SysGroupPermission p = new SysGroupPermission();
p.GroupId = nGroupId;
p.FuncId = f.Id;
p.FuncName = f.Name;
p.AllowOpen = f.AllowOpen;
p.AllowNew = f.AllowNew;
p.AllowModify = f.AllowModify;
p.AllowDelete = f.AllowDelete;
p.AllowCancel = f.AllowCancel;
p.AllowDetail = f.AllowDetail;
p.AllowSearch = f.AllowSearch;
p.AllowSubmit = f.AllowSubmit;
p.AllowApprove = f.AllowApprove;
p.AllowDispatch = f.AllowDispatch;
p.AllowExport = f.AllowExport;
p.AllowImport = f.AllowImport;
p.AllowPrint = f.AllowPrint;
if (!dao.InsertGroupPermission(p, nOpStaffId, strOpStaffName, out strErrText))
{
return 0;
}
}
}
transScope.Complete();
}
return nGroupId;
}
catch (Exception e)
{
strErrText = e.Message;
return 0;
}
}
/// <summary>
/// 新增组权限数据
/// </summary>
/// <param name="data"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool InsertGroupPermission(SysGroupPermission data, long nOpStaffId, string strOpStaffName, out string strErrText)
{
//创建存储过程参数
SqlParameter[] Params =
{
MakeParam(GROUPID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GroupId),
MakeParam(FUNCID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.FuncId),
MakeParam(ALLOWOPEN_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowOpen),
MakeParam(ALLOWNEW_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowNew),
MakeParam(ALLOWMODIFY_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowModify),
MakeParam(ALLOWDELETE_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDelete),
MakeParam(ALLOWCANCEL_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowCancel),
MakeParam(ALLOWDETAIL_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDetail),
MakeParam(ALLOWSEARCH_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowSearch),
MakeParam(ALLOWSUBMIT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowSubmit),
MakeParam(ALLOWAPPROVE_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowApprove),
MakeParam(ALLOWDISPATCH_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDispatch),
MakeParam(ALLOWEXPORT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowExport),
MakeParam(ALLOWIMPORT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowImport),
MakeParam(ALLOWPRINT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowPrint),
MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId),
MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName)
};
if (Execute("InsertGroupPermission", Params, out strErrText) >= 0)
return true;
else
return false;
}
