private static SOARolePropertyDefinitionCollection PrepareServerPropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "CostCenter", SortOrder = 0
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "PayMethod", SortOrder = 1
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Age", SortOrder = 2, DataType = ColumnDataType.Integer
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "OperatorType", SortOrder = 3, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Operator", SortOrder = 4, DataType = ColumnDataType.String
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PrepareSamplePropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "CostCenter", SortOrder = 0, Description = "成本中心"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "ActivitySN", SortOrder = 1, Description = "活动序号"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "ActivityProperties", SortOrder = 2, Description = "活动属性"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "OperatorType", SortOrder = 3, DataType = ColumnDataType.String, Description = "操作人类型"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Operator", SortOrder = 4, DataType = ColumnDataType.String, Description = "操作人"
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PrepareActivityMatrixPropertiesDefinition(string definitionID)
{
SOARole role = new SOARole();
role.ID = definitionID;
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "AdministrativeUnit", SortOrder = 0
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "ActivitySN", SortOrder = 0, DataType = ColumnDataType.Integer
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "OperatorType", SortOrder = 1, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "Operator", SortOrder = 2, DataType = ColumnDataType.String
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition(IRole role)
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "CostCenter", SortOrder = 0
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "Condition", SortOrder = 3
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "ActivitySN", SortOrder = 4
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "ActivityProperties", SortOrder = 5
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "IsMergeable", SortOrder = 6, DataType = ColumnDataType.Boolean
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "CostCenter", SortOrder = 0 });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Approver1", SortOrder = 1 });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Approver2", SortOrder = 2 });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Approver3", SortOrder = 3 });
return propertiesDefinition;
}
private static SOARolePropertyDefinitionCollection PrepareSamplePropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "CostCenter", SortOrder = 0, Description = "成本中心" });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "ActivitySN", SortOrder = 1, Description = "活动序号" });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "ActivityProperties", SortOrder = 2, Description = "活动属性" });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "OperatorType", SortOrder = 3, DataType = ColumnDataType.String, Description = "操作人类型" });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Operator", SortOrder = 4, DataType = ColumnDataType.String, Description = "操作人" });
return propertiesDefinition;
}
public SOARolePropertyDefinitionCollection LoadByRoleID(string roleID)
{
roleID.CheckStringIsNullOrEmpty("roleID");
string sql = string.Format("SELECT * FROM WF.ROLE_PROPERTIES_DEFINITIONS WHERE {0} ORDER BY SORT_ORDER",
roleID.ToRoleIDCriteria());
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Suppress))
{
DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];
SOARolePropertyDefinitionCollection result = new SOARolePropertyDefinitionCollection();
foreach (DataRow row in table.Rows)
{
SOARolePropertyDefinition property = new SOARolePropertyDefinition();
ORMapping.DataRowToObject(row, property);
result.Add(property);
}
return result;
}
}
/// <summary>
/// 创建一个都是预定义列的属性集合
/// </summary>
/// <returns></returns>
public static SOARolePropertyDefinitionCollection PrepareReservedPropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivitySNColumn, SortOrder = 1
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ConditionColumn, SortOrder = 3, DefaultValue = "RowOperators.Count > 0"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivityCodeColumn, SortOrder = 4
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivityNameColumn, SortOrder = 6, DefaultValue = "审批"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.AutoExtractColumn, SortOrder = 6, DataType = ColumnDataType.Boolean, DefaultValue = "False"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.OperatorTypeColumn, SortOrder = 8, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.OperatorColumn, SortOrder = 9, DataType = ColumnDataType.String
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "CostCenter", SortOrder = 0
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Approver1", SortOrder = 1
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Approver2", SortOrder = 2
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Approver3", SortOrder = 3
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition(IRole role)
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = "CostCenter", SortOrder = 1
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.ConditionColumn, SortOrder = 2
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.ActivitySNColumn, SortOrder = 3
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.ActivityPropertiesColumn, SortOrder = 4
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.IsMergeableColumn, SortOrder = 5, DataType = ColumnDataType.Boolean
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.TransitionsColumn, SortOrder = 5, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.OperatorTypeColumn, SortOrder = 7, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition(role)
{
Name = SOARolePropertyDefinition.OperatorColumn, SortOrder = 8, DataType = ColumnDataType.String
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PrepareServerPropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "CostCenter", SortOrder = 0 });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "PayMethod", SortOrder = 1 });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Age", SortOrder = 2, DataType = ColumnDataType.Integer });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "OperatorType", SortOrder = 3, DataType = ColumnDataType.String });
propertiesDefinition.Add(new SOARolePropertyDefinition() { Name = "Operator", SortOrder = 4, DataType = ColumnDataType.String });
return propertiesDefinition;
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition(IRole role)
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "CostCenter", SortOrder = 1 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.ConditionColumn, SortOrder = 2 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.ActivitySNColumn, SortOrder = 3 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.ActivityPropertiesColumn, SortOrder = 4 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.IsMergeableColumn, SortOrder = 5, DataType = ColumnDataType.Boolean });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.TransitionsColumn, SortOrder = 5, DataType = ColumnDataType.String });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.OperatorTypeColumn, SortOrder = 7, DataType = ColumnDataType.String });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = SOARolePropertyDefinition.OperatorColumn, SortOrder = 8, DataType = ColumnDataType.String });
return propertiesDefinition;
}
public static SOARolePropertyDefinitionCollection PreparePropertiesDefinition()
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "CostCenter", SortOrder = 0
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivitySNColumn, SortOrder = 1
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "PayMethod", SortOrder = 2
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ConditionColumn, SortOrder = 3, DefaultValue = "RowOperators.Count > 0"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivityCodeColumn, SortOrder = 4
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.ActivityNameColumn, SortOrder = 6, DefaultValue = "审批"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.AutoExtractColumn, SortOrder = 6, DataType = ColumnDataType.Boolean, DefaultValue = "False"
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = "Age", SortOrder = 7, DataType = ColumnDataType.Integer
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.OperatorTypeColumn, SortOrder = 8, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.OperatorColumn, SortOrder = 9, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.EnterNotifyReceiverTypeColumn, SortOrder = 10, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.EnterNotifyReceiverColumn, SortOrder = 11, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.LeaveNotifyReceiverTypeColumn, SortOrder = 12, DataType = ColumnDataType.String
});
propertiesDefinition.Add(new SOARolePropertyDefinition()
{
Name = SOARolePropertyDefinition.LeaveNotifyReceiverColumn, SortOrder = 13, DataType = ColumnDataType.String
});
return(propertiesDefinition);
}
private static SOARolePropertyDefinitionCollection PreparePropertiesDefinition(IRole role)
{
SOARolePropertyDefinitionCollection propertiesDefinition = new SOARolePropertyDefinitionCollection();
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "CostCenter", SortOrder = 0 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "Condition", SortOrder = 3 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "ActivitySN", SortOrder = 4 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "ActivityProperties", SortOrder = 5 });
propertiesDefinition.Add(new SOARolePropertyDefinition(role) { Name = "IsMergeable", SortOrder = 6, DataType = ColumnDataType.Boolean });
return propertiesDefinition;
}
