//查询指定流程、角色的操作
public static DataTable getOperation(int processid, int roleid)
{
Query q = OpProRole.Query();
q.AddWhere(OpProRole.Columns.RoleId, roleid);
q.AddWhere(OpProRole.Columns.ProcessId, processid);
return(q.ExecuteDataSet().Tables[0]);
}
////重新赋值
//public static void UpdateOperation(int operationid,int roleid,int processid)
//{
// Query q = OpProRole.Query();
// q.AddWhere(OpProRole.Columns.RoleId, roleid);
// q.AddWhere(OpProRole.Columns.ProcessId, processid);
// q.AddUpdateSetting(OpProRole.Columns.OperationId, operationid);
// q.QueryType = QueryType.Update;
// q.Execute();
//}
//清空
//public static void UpdateOperation(int processid, int roleid)
//{
// Query q = OpProRole.Query();
// q.AddWhere(OpProRole.Columns.RoleId, roleid);
// q.AddWhere(OpProRole.Columns.ProcessId, processid);
// q.AddUpdateSetting(OpProRole.Columns.OperationId, null);
// q.QueryType = QueryType.Update;
// q.Execute();
//}
//删除指定操作权限
public static void DelOperation(int processid, int roleid, int operationid)
{
Query q = OpProRole.Query();
q.AddWhere(OpProRole.Columns.OperationId, operationid);
q.AddWhere(OpProRole.Columns.RoleId, roleid);
q.AddWhere(OpProRole.Columns.ProcessId, processid);
q.QueryType = QueryType.Delete;
q.Execute();
}
//删除角色及对应的操作、用户
public static void DelRole(int id)
{
Query q = RoleMaster.Query();
q.AddWhere(RoleMaster.Columns.RoleId, id);
q.QueryType = QueryType.Delete;
q.Execute();
Query s = OpProRole.Query();
s.AddWhere(OpProRole.Columns.RoleId, id);
s.QueryType = QueryType.Delete;
s.Execute();
Role.Delete(id);
}
//ProcessRole数据是否存在
public static bool IsProcessRole(int processid, int roleid)
{
Query q = OpProRole.Query();
q.AddWhere(OpProRole.Columns.RoleId, roleid);
q.AddWhere(OpProRole.Columns.ProcessId, processid);
DataTable dt = q.ExecuteDataSet().Tables[0];
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}