|
<dataController name="EmployeeTerritories" conflictDetection="overwriteChanges" label="Employee Territories" xmlns="urn:schemas-codeontime-com:data-aquarium">
<commands>
<command id="command1" type="Text">
<text><![CDATA[
select
"EmployeeTerritories"."EmployeeID" "EmployeeID"
,"Employee"."LastName" "EmployeeLastName"
,"EmployeeTerritories"."TerritoryID" "TerritoryID"
,"Territory"."TerritoryDescription" "TerritoryTerritoryDescription"
,"TerritoryRegion"."RegionDescription" "TerritoryRegionRegionDescription"
from "dbo"."EmployeeTerritories" "EmployeeTerritories"
left join "dbo"."Employees" "Employee" on "EmployeeTerritories"."EmployeeID" = "Employee"."EmployeeID"
left join "dbo"."Territories" "Territory" on "EmployeeTerritories"."TerritoryID" = "Territory"."TerritoryID"
left join "dbo"."Region" "TerritoryRegion" on "Territory"."RegionID" = "TerritoryRegion"."RegionID"
]]></text>
</command>
</commands>
<fields>
<field name="EmployeeID" type="Int32" allowNulls="false" isPrimaryKey="true" label="Employee#">
<items style="Lookup" dataController="Employees" newDataView="createForm1" />
</field>
<field name="EmployeeLastName" type="String" readOnly="true" label="Employee Last Name" />
<field name="TerritoryID" type="String" allowNulls="false" isPrimaryKey="true" label="Territory#">
<items style="Lookup" dataController="Territories" newDataView="createForm1" />
</field>
<field name="TerritoryTerritoryDescription" type="String" readOnly="true" label="Territory Description" />
<field name="TerritoryRegionRegionDescription" type="String" readOnly="true" label="Territory Region Description" />
</fields>
<views>
<view id="grid1" type="Grid" commandId="command1" label="Employee Territories">
<headerText>This is a list of employee territories. </headerText>
<dataFields>
<dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
<dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
<dataField fieldName="TerritoryRegionRegionDescription" columns="50" />
</dataFields>
</view>
<view id="editForm1" type="Form" commandId="command1" label="Review Employee Territories">
<headerText>Please review employee territories information below. Click Edit to change this record, click Delete to delete the record, or click Cancel/Close to return back.</headerText>
<categories>
<category headerText="Employee Territories">
<description>These are the fields of the employee territories record that can be edited.</description>
<dataFields>
<dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
<dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
</dataFields>
</category>
<category headerText="Reference Information">
<description>Additional details about employee territories are provided in the reference information section.</description>
<dataFields>
<dataField fieldName="TerritoryRegionRegionDescription" columns="50" />
</dataFields>
</category>
</categories>
</view>
<view id="createForm1" type="Form" commandId="command1" label="New Employee Territories">
<headerText>Please fill this form and click OK button to create a new employee territories record. Click Cancel to return to the previous screen.</headerText>
<categories>
<category headerText="New Employee Territories">
<description>Complete the form. Make sure to enter all required fields.</description>
<dataFields>
<dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
<dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
</dataFields>
</category>
</categories>
</view>
</views>
<actions>
<actionGroup scope="Grid">
<action commandName="Select" commandArgument="editForm1" />
<action commandName="Edit" />
<action commandName="Delete" confirmation="Delete?" />
<action whenLastCommandName="Edit" commandName="Update" headerText="Save" />
<action whenLastCommandName="Edit" commandName="Cancel" />
</actionGroup>
<actionGroup scope="Form">
<action commandName="Edit" />
<action commandName="Delete" confirmation="Delete?" />
<action commandName="Cancel" headerText="Close" />
<action whenLastCommandName="Edit" commandName="Update" headerText="OK" />
<action whenLastCommandName="Edit" commandName="Delete" confirmation="Delete?" />
<action whenLastCommandName="Edit" commandName="Cancel" />
<action whenLastCommandName="New" commandName="Insert" headerText="OK" />
<action whenLastCommandName="New" commandName="Cancel" />
</actionGroup>
<actionGroup scope="ActionBar" headerText="New">
<action commandName="New" commandArgument="createForm1" headerText="New Employee Territories" description="Create a new Employee Territories record." />
</actionGroup>
<actionGroup scope="ActionBar" headerText="Actions">
<action commandName="Custom" commandArgument="ExportCsv" headerText="Export to Spreadsheet" description="Analyze items with spreadsheet<br/> application." cssClass="ExportCsv" />
<action commandName="Custom" commandArgument="ExportRss" headerText="View RSS Feed" description="Syndicate items with an RSS reader." cssClass="ExportRss" />
<action />
<action commandName="Custom" commandArgument="MyCommand" headerText="My Command" description="Execute my custom command" />
</actionGroup>
<actionGroup scope="ActionBar" headerText="Record">
<action whenLastCommandName="Edit" commandName="Update" headerText="Save" description="Save changes to the database." />
<action whenLastCommandName="Edit" commandName="Cancel" description="Cancel all record changes." />
</actionGroup>
</actions>
</dataController>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.