193 lines
20 KiB
XML
193 lines
20 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="ReportingDataSource" targetNamespace="http://tempuri.org/ReportingDataSource.xsd" xmlns:mstns="http://tempuri.org/ReportingDataSource.xsd" xmlns="http://tempuri.org/ReportingDataSource.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
<xs:annotation>
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="DefaultConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DefaultConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.DefaultConnection.ConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SummaryReportTableAdapter" GeneratorDataComponentClassName="SummaryReportTableAdapter" Name="SummaryReport" UserDataComponentName="SummaryReportTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DefaultConnection (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>select t.Name, s.Name as Scenario_Name,
|
|
s.ProjectedRevenue,
|
|
s.ExpectedGrossMargin,
|
|
s.CalculatedGrossMargin,
|
|
s.CalculatedGrossMargin_LM, s.StartDate,
|
|
s.EndDate, s.TDDirectCosts,
|
|
s.TDDirectCosts_LM, s.BUDirectCosts,
|
|
s.BUDirectCosts_LM, s.CostSavings,
|
|
s.CostSavingsStartDate, t.id as TeamId,
|
|
s.CostSavingsEndDate, s.CostSavingsType,
|
|
p.IsRevenueGenerating, p.Name as Project_Name, p.Priority,
|
|
p.Probability, p.Deadline, st.Name as Status_Name, p.StatusId AS ProjectStatusId,
|
|
s.Id as ScenarioId, p.Id as ProjectId
|
|
from Project p,
|
|
Scenario s,
|
|
Team t,
|
|
Team2Project tp,
|
|
Status st
|
|
where t.Id = tp.TeamId
|
|
and p.Id = tp.ProjectId
|
|
and s.ParentId = p.Id
|
|
and st.Id = p.StatusId
|
|
</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Name" DataSetColumn="Name" />
|
|
<Mapping SourceColumn="Scenario_Name" DataSetColumn="Scenario_Name" />
|
|
<Mapping SourceColumn="ProjectedRevenue" DataSetColumn="ProjectedRevenue" />
|
|
<Mapping SourceColumn="ExpectedGrossMargin" DataSetColumn="ExpectedGrossMargin" />
|
|
<Mapping SourceColumn="CalculatedGrossMargin" DataSetColumn="CalculatedGrossMargin" />
|
|
<Mapping SourceColumn="CalculatedGrossMargin_LM" DataSetColumn="CalculatedGrossMargin_LM" />
|
|
<Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
|
|
<Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
|
|
<Mapping SourceColumn="TDDirectCosts" DataSetColumn="TDDirectCosts" />
|
|
<Mapping SourceColumn="TDDirectCosts_LM" DataSetColumn="TDDirectCosts_LM" />
|
|
<Mapping SourceColumn="BUDirectCosts" DataSetColumn="BUDirectCosts" />
|
|
<Mapping SourceColumn="BUDirectCosts_LM" DataSetColumn="BUDirectCosts_LM" />
|
|
<Mapping SourceColumn="CostSavings" DataSetColumn="CostSavings" />
|
|
<Mapping SourceColumn="CostSavingsStartDate" DataSetColumn="CostSavingsStartDate" />
|
|
<Mapping SourceColumn="TeamId" DataSetColumn="TeamId" />
|
|
<Mapping SourceColumn="CostSavingsEndDate" DataSetColumn="CostSavingsEndDate" />
|
|
<Mapping SourceColumn="CostSavingsType" DataSetColumn="CostSavingsType" />
|
|
<Mapping SourceColumn="IsRevenueGenerating" DataSetColumn="IsRevenueGenerating" />
|
|
<Mapping SourceColumn="Project_Name" DataSetColumn="Project_Name" />
|
|
<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
|
|
<Mapping SourceColumn="Probability" DataSetColumn="Probability" />
|
|
<Mapping SourceColumn="Deadline" DataSetColumn="Deadline" />
|
|
<Mapping SourceColumn="Status_Name" DataSetColumn="Status_Name" />
|
|
<Mapping SourceColumn="ScenarioId" DataSetColumn="ScenarioId" />
|
|
<Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
|
|
<Mapping SourceColumn="ProjectStatusId" DataSetColumn="ProjectStatusId" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="DefaultConnection (Web.config)" DbObjectName="EnVisage.dbo.Status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
|
<CommandText>SELECT Id, Name, Color, IsSystem, Probability100
|
|
FROM Status</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="Id" DataSetColumn="Id" />
|
|
<Mapping SourceColumn="Name" DataSetColumn="Name" />
|
|
<Mapping SourceColumn="Color" DataSetColumn="Color" />
|
|
<Mapping SourceColumn="IsSystem" DataSetColumn="IsSystem" />
|
|
<Mapping SourceColumn="Probability100" DataSetColumn="Probability100" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="ReportingDataSource" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="ReportingDataSource" msprop:Generator_UserDSName="ReportingDataSource">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="SummaryReport" msprop:Generator_TableClassName="SummaryReportDataTable" msprop:Generator_TableVarName="tableSummaryReport" msprop:Generator_TablePropName="SummaryReport" msprop:Generator_RowDeletingName="SummaryReportRowDeleting" msprop:Generator_RowChangingName="SummaryReportRowChanging" msprop:Generator_RowEvHandlerName="SummaryReportRowChangeEventHandler" msprop:Generator_RowDeletedName="SummaryReportRowDeleted" msprop:Generator_UserTableName="SummaryReport" msprop:Generator_RowChangedName="SummaryReportRowChanged" msprop:Generator_RowEvArgName="SummaryReportRowChangeEvent" msprop:Generator_RowClassName="SummaryReportRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="400" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Scenario_Name" msprop:Generator_ColumnVarNameInTable="columnScenario_Name" msprop:Generator_ColumnPropNameInRow="Scenario_Name" msprop:Generator_ColumnPropNameInTable="Scenario_NameColumn" msprop:Generator_UserColumnName="Scenario_Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="800" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ProjectedRevenue" msprop:Generator_ColumnVarNameInTable="columnProjectedRevenue" msprop:Generator_ColumnPropNameInRow="ProjectedRevenue" msprop:Generator_ColumnPropNameInTable="ProjectedRevenueColumn" msprop:Generator_UserColumnName="ProjectedRevenue" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="ExpectedGrossMargin" msprop:Generator_ColumnVarNameInTable="columnExpectedGrossMargin" msprop:Generator_ColumnPropNameInRow="ExpectedGrossMargin" msprop:Generator_ColumnPropNameInTable="ExpectedGrossMarginColumn" msprop:Generator_UserColumnName="ExpectedGrossMargin" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CalculatedGrossMargin" msprop:Generator_ColumnVarNameInTable="columnCalculatedGrossMargin" msprop:Generator_ColumnPropNameInRow="CalculatedGrossMargin" msprop:Generator_ColumnPropNameInTable="CalculatedGrossMarginColumn" msprop:Generator_UserColumnName="CalculatedGrossMargin" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CalculatedGrossMargin_LM" msprop:Generator_ColumnVarNameInTable="columnCalculatedGrossMargin_LM" msprop:Generator_ColumnPropNameInRow="CalculatedGrossMargin_LM" msprop:Generator_ColumnPropNameInTable="CalculatedGrossMargin_LMColumn" msprop:Generator_UserColumnName="CalculatedGrossMargin_LM" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" msprop:Generator_UserColumnName="EndDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="TDDirectCosts" msprop:Generator_ColumnVarNameInTable="columnTDDirectCosts" msprop:Generator_ColumnPropNameInRow="TDDirectCosts" msprop:Generator_ColumnPropNameInTable="TDDirectCostsColumn" msprop:Generator_UserColumnName="TDDirectCosts" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="TDDirectCosts_LM" msprop:Generator_ColumnVarNameInTable="columnTDDirectCosts_LM" msprop:Generator_ColumnPropNameInRow="TDDirectCosts_LM" msprop:Generator_ColumnPropNameInTable="TDDirectCosts_LMColumn" msprop:Generator_UserColumnName="TDDirectCosts_LM" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="BUDirectCosts" msprop:Generator_ColumnVarNameInTable="columnBUDirectCosts" msprop:Generator_ColumnPropNameInRow="BUDirectCosts" msprop:Generator_ColumnPropNameInTable="BUDirectCostsColumn" msprop:Generator_UserColumnName="BUDirectCosts" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="BUDirectCosts_LM" msprop:Generator_ColumnVarNameInTable="columnBUDirectCosts_LM" msprop:Generator_ColumnPropNameInRow="BUDirectCosts_LM" msprop:Generator_ColumnPropNameInTable="BUDirectCosts_LMColumn" msprop:Generator_UserColumnName="BUDirectCosts_LM" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CostSavings" msprop:Generator_ColumnVarNameInTable="columnCostSavings" msprop:Generator_ColumnPropNameInRow="CostSavings" msprop:Generator_ColumnPropNameInTable="CostSavingsColumn" msprop:Generator_UserColumnName="CostSavings" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CostSavingsStartDate" msprop:Generator_ColumnVarNameInTable="columnCostSavingsStartDate" msprop:Generator_ColumnPropNameInRow="CostSavingsStartDate" msprop:Generator_ColumnPropNameInTable="CostSavingsStartDateColumn" msprop:Generator_UserColumnName="CostSavingsStartDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="TeamId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnTeamId" msprop:Generator_ColumnPropNameInRow="TeamId" msprop:Generator_ColumnPropNameInTable="TeamIdColumn" msprop:Generator_UserColumnName="TeamId" type="xs:string" />
|
|
<xs:element name="CostSavingsEndDate" msprop:Generator_ColumnVarNameInTable="columnCostSavingsEndDate" msprop:Generator_ColumnPropNameInRow="CostSavingsEndDate" msprop:Generator_ColumnPropNameInTable="CostSavingsEndDateColumn" msprop:Generator_UserColumnName="CostSavingsEndDate" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="CostSavingsType" msprop:Generator_ColumnVarNameInTable="columnCostSavingsType" msprop:Generator_ColumnPropNameInRow="CostSavingsType" msprop:Generator_ColumnPropNameInTable="CostSavingsTypeColumn" msprop:Generator_UserColumnName="CostSavingsType" type="xs:short" minOccurs="0" />
|
|
<xs:element name="IsRevenueGenerating" msprop:Generator_ColumnVarNameInTable="columnIsRevenueGenerating" msprop:Generator_ColumnPropNameInRow="IsRevenueGenerating" msprop:Generator_ColumnPropNameInTable="IsRevenueGeneratingColumn" msprop:Generator_UserColumnName="IsRevenueGenerating" type="xs:boolean" />
|
|
<xs:element name="Project_Name" msprop:Generator_ColumnVarNameInTable="columnProject_Name" msprop:Generator_ColumnPropNameInRow="Project_Name" msprop:Generator_ColumnPropNameInTable="Project_NameColumn" msprop:Generator_UserColumnName="Project_Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="800" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" msprop:Generator_UserColumnName="Priority" type="xs:int" />
|
|
<xs:element name="Probability" msprop:Generator_ColumnVarNameInTable="columnProbability" msprop:Generator_ColumnPropNameInRow="Probability" msprop:Generator_ColumnPropNameInTable="ProbabilityColumn" msprop:Generator_UserColumnName="Probability" type="xs:decimal" />
|
|
<xs:element name="Deadline" msprop:Generator_ColumnVarNameInTable="columnDeadline" msprop:Generator_ColumnPropNameInRow="Deadline" msprop:Generator_ColumnPropNameInTable="DeadlineColumn" msprop:Generator_UserColumnName="Deadline" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Status_Name" msprop:Generator_ColumnVarNameInTable="columnStatus_Name" msprop:Generator_ColumnPropNameInRow="Status_Name" msprop:Generator_ColumnPropNameInTable="Status_NameColumn" msprop:Generator_UserColumnName="Status_Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1600" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ScenarioId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnScenarioId" msprop:Generator_ColumnPropNameInRow="ScenarioId" msprop:Generator_ColumnPropNameInTable="ScenarioIdColumn" msprop:Generator_UserColumnName="ScenarioId" type="xs:string" />
|
|
<xs:element name="ProjectId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" msprop:Generator_UserColumnName="ProjectId" type="xs:string" />
|
|
<xs:element name="ProjectStatusId" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnProjectStatusId" msprop:Generator_ColumnPropNameInRow="ProjectStatusId" msprop:Generator_ColumnPropNameInTable="ProjectStatusIdColumn" msprop:Generator_UserColumnName="ProjectStatusId" type="xs:string" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="Status" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_TablePropName="Status" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_UserTableName="Status" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowClassName="StatusRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="Id" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:string" />
|
|
<xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1600" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="128" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="IsSystem" msprop:Generator_ColumnVarNameInTable="columnIsSystem" msprop:Generator_ColumnPropNameInRow="IsSystem" msprop:Generator_ColumnPropNameInTable="IsSystemColumn" msprop:Generator_UserColumnName="IsSystem" type="xs:boolean" />
|
|
<xs:element name="Probability100" msprop:Generator_ColumnVarNameInTable="columnProbability100" msprop:Generator_ColumnPropNameInRow="Probability100" msprop:Generator_ColumnPropNameInTable="Probability100Column" msprop:Generator_UserColumnName="Probability100" type="xs:boolean" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="SummaryReportKey1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:SummaryReport" />
|
|
<xs:field xpath="mstns:TeamId" />
|
|
<xs:field xpath="mstns:ScenarioId" />
|
|
</xs:unique>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:Status" />
|
|
<xs:field xpath="mstns:Id" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |