You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1212 lines
34 KiB
1212 lines
34 KiB
2 years ago
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<WorkBook xmlVersion="20211223" releaseVersion="10.0.0">
|
||
|
|
<TableDataMap>
|
||
|
|
<TableData name="ds1" class="com.fr.data.impl.DBTableData">
|
||
|
|
<Parameters/>
|
||
|
|
<Attributes maxMemRowCount="-1"/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
<Query>
|
||
|
|
<![CDATA[SELECT * FROM [订单]A]]></Query>
|
||
|
|
<PageQuery>
|
||
|
|
<![CDATA[]]></PageQuery>
|
||
|
|
</TableData>
|
||
|
|
<TableData name="ds2" class="com.fr.data.impl.DBTableData">
|
||
|
|
<Parameters/>
|
||
|
|
<Attributes maxMemRowCount="-1"/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
<Query>
|
||
|
|
<![CDATA[SELECT * FROM [订单明细]A]]></Query>
|
||
|
|
<PageQuery>
|
||
|
|
<![CDATA[]]></PageQuery>
|
||
|
|
</TableData>
|
||
|
|
</TableDataMap>
|
||
|
|
<ReportWebAttr>
|
||
|
|
<ServerPrinter/>
|
||
|
|
<WebPageContent>
|
||
|
|
<ToolBars>
|
||
|
|
<ToolBarManager>
|
||
|
|
<Location>
|
||
|
|
<Embed position="1"/>
|
||
|
|
</Location>
|
||
|
|
<ToolBar>
|
||
|
|
<Widget class="com.fr.report.web.button.page.First">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("ReportServerP-First")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[first]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.page.Previous">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("ReportServerP-Previous")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[previous]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.page.PageNavi">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.page.Next">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("ReportServerP-Next")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[next]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.page.Last">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("ReportServerP-Last")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[last]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.FlashPrint">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Utils-Print[Client]A")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[flashprint]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Print">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Print")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[print]]></IconName>
|
||
|
|
<PrintButtons/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Export">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Export")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[export]]></IconName>
|
||
|
|
<Buttons pdf="true" excelP="true" excelO="true" excelS="true" word="true" image="true" html="true"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Email">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Email")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[email]]></IconName>
|
||
|
|
<EmailButton customConsignee="true" consigneeByDepartment="false" consigneeByRole="false"/>
|
||
|
|
</Widget>
|
||
|
|
</ToolBar>
|
||
|
|
</ToolBarManager>
|
||
|
|
</ToolBars>
|
||
|
|
<WebPage isPage="false" showAsImage="false" autoScale="false" tdHeavy="false"/>
|
||
|
|
</WebPageContent>
|
||
|
|
<WebWriteContent>
|
||
|
|
<ToolBars>
|
||
|
|
<ToolBarManager>
|
||
|
|
<Location>
|
||
|
|
<Embed position="1"/>
|
||
|
|
</Location>
|
||
|
|
<ToolBar>
|
||
|
|
<Widget class="com.fr.report.web.button.write.Submit">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Utils-Submit")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[submit]]></IconName>
|
||
|
|
<Verify failVerifySubmit="false" value="true"/>
|
||
|
|
<Sheet onlySubmitSelect="false"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.write.Verify">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Verify-Data_Verify")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[verify]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.FlashPrint">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Utils-Print[Client]A")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[flashprint]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Print">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Print")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[print]]></IconName>
|
||
|
|
<PrintButtons/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Export">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Export")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[export]]></IconName>
|
||
|
|
<Buttons pdf="true" excelP="true" excelO="true" excelS="true" word="true" image="true" html="true"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.Email">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Email")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[email]]></IconName>
|
||
|
|
<EmailButton customConsignee="true" consigneeByDepartment="false" consigneeByRole="false"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.write.AppendColumnRow">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Add")}${i18n("Record")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[appendcolumn]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.write.ShowCellValue">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
<LabelAttr textalign="0" autoline="false"/>
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<border style="0" color="-723724"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.report.web.button.write.DeleteColumnRow">
|
||
|
|
<WidgetAttr disabled="true" aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[${i18n("Utils-Delete_Column")}${i18n("Row")}]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[deletecolumn]]></IconName>
|
||
|
|
</Widget>
|
||
|
|
</ToolBar>
|
||
|
|
</ToolBarManager>
|
||
|
|
</ToolBars>
|
||
|
|
<EditRowColor setColor="true"/>
|
||
|
|
<SelectedColor color="-10033153"/>
|
||
|
|
<WebWrite SheetPosition="3"/>
|
||
|
|
<RptLocation isShowAtLeft="true"/>
|
||
|
|
<UnloadCheck/>
|
||
|
|
<ShowWidgets/>
|
||
|
|
<OtherAttr autoStash="false"/>
|
||
|
|
</WebWriteContent>
|
||
|
|
</ReportWebAttr>
|
||
|
|
<ElementCaseMobileAttr>
|
||
|
|
<ElementCaseMobileAttrProvider horizontal="1" vertical="1" zoom="true" refresh="false" isUseHTML="false" isMobileCanvasSize="false" appearRefresh="false" allowFullScreen="false" allowDoubleClickOrZoom="true" functionalWhenUnactivated="false"/>
|
||
|
|
</ElementCaseMobileAttr>
|
||
|
|
<Report class="com.fr.report.worksheet.WorkSheet" name="订单2">
|
||
|
|
<ReportPageAttr>
|
||
|
|
<HR/>
|
||
|
|
<FR/>
|
||
|
|
<HC/>
|
||
|
|
<FC/>
|
||
|
|
</ReportPageAttr>
|
||
|
|
<ColumnPrivilegeControl/>
|
||
|
|
<RowPrivilegeControl/>
|
||
|
|
<RowHeight defaultValue="723900">
|
||
|
|
<![CDATA[952500,723900,723900,723900,723900,723900,723900,723900,723900,723900,723900]]></RowHeight>
|
||
|
|
<ColumnWidth defaultValue="2743200">
|
||
|
|
<![CDATA[3276600,3238500,3238500,3543300,3009900,1295400,2247900,2743200,2743200,2743200,2743200]]></ColumnWidth>
|
||
|
|
<CellElementList>
|
||
|
|
<C c="0" r="0" cs="7" s="0">
|
||
|
|
<O>
|
||
|
|
<![CDATA[订单信息]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="7" r="0">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="2">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="订单ID"/>
|
||
|
|
<Condition class="com.fr.data.condition.CommonCondition">
|
||
|
|
<CNUMBER>
|
||
|
|
<![CDATA[0]]></CNUMBER>
|
||
|
|
<CNAME>
|
||
|
|
<![CDATA[订单ID]]></CNAME>
|
||
|
|
<Compare op="0">
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="ID"/>
|
||
|
|
<O>
|
||
|
|
<![CDATA[10001]]></O>
|
||
|
|
</Parameter>
|
||
|
|
</Compare>
|
||
|
|
</Condition>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<HighlightList>
|
||
|
|
<Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
|
||
|
|
<Condition class="com.fr.data.condition.ListCondition"/>
|
||
|
|
<HighlightAction class="com.fr.report.cell.cellattr.highlight.RowHeightHighlightAction"/>
|
||
|
|
</Highlight>
|
||
|
|
</HighlightList>
|
||
|
|
<CellInsertPolicy/>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="3">
|
||
|
|
<O>
|
||
|
|
<![CDATA[客户名称：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="3" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="客户ID"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.ComboBox">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="客户" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
<widgetValue/>
|
||
|
|
</Widget>
|
||
|
|
<Present class="com.fr.base.present.DictPresent">
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="客户" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
</Present>
|
||
|
|
<Expand dir="0" leftParentDefault="false" left="A3"/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="3">
|
||
|
|
<O>
|
||
|
|
<![CDATA[雇员名称：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="3" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="雇员ID"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.ComboBox">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="雇员" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
<widgetValue/>
|
||
|
|
</Widget>
|
||
|
|
<Present class="com.fr.base.present.DictPresent">
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="雇员" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
</Present>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="3">
|
||
|
|
<O>
|
||
|
|
<![CDATA[运货商：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="3" cs="2" s="2">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="运货商"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.ComboBox">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="运货商" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
<widgetValue/>
|
||
|
|
</Widget>
|
||
|
|
<Present class="com.fr.base.present.DictPresent">
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="运货商" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
</Present>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="6" r="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[运货费：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="5" s="3">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="运货费"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<EMSG>
|
||
|
|
<![CDATA[必须是数字！]]></EMSG>
|
||
|
|
<NumberAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0" leftParentDefault="false" left="A3"/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[货主名称：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="5" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="货主名称"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.TextEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<TextAttr/>
|
||
|
|
<widgetValue/>
|
||
|
|
<MobileScanCodeAttr scanCode="true" textInputMode="0"/>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[货主地址：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="5" cs="2" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="货主地址"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.TextEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<TextAttr/>
|
||
|
|
<Reg class="com.fr.form.ui.reg.NoneReg"/>
|
||
|
|
<widgetValue/>
|
||
|
|
<MobileScanCodeAttr scanCode="true" textInputMode="0"/>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="6" r="6">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="7">
|
||
|
|
<O>
|
||
|
|
<![CDATA[货主城市：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="7" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="货主城市"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand dir="0" leftParentDefault="false" left="A3"/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="7">
|
||
|
|
<O>
|
||
|
|
<![CDATA[应付金额：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="7" s="1">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="应付金额"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<NumberAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="7">
|
||
|
|
<O>
|
||
|
|
<![CDATA[是否已付：]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="7" cs="2" s="2">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds1" columnName="是否已付"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.CheckBox">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<widgetValue>
|
||
|
|
<O t="B">
|
||
|
|
<![CDATA[false]]></O>
|
||
|
|
</widgetValue>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
</CellElementList>
|
||
|
|
<ReportAttrSet>
|
||
|
|
<ReportSettings isHorizontalCenterOnPage="true" headerHeight="0" footerHeight="0">
|
||
|
|
<PaperSetting orientation="1">
|
||
|
|
<PaperSize width="21312000" height="30240000"/>
|
||
|
|
<Margin top="1274400" left="2167200" bottom="122400" right="7200"/>
|
||
|
|
</PaperSetting>
|
||
|
|
<Background name="ColorBackground" color="-1"/>
|
||
|
|
</ReportSettings>
|
||
|
|
<Header reportPageType="0">
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<LeftList/>
|
||
|
|
<CenterList/>
|
||
|
|
<RightList/>
|
||
|
|
</Header>
|
||
|
|
<Footer reportPageType="0">
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<LeftList/>
|
||
|
|
<CenterList/>
|
||
|
|
<RightList/>
|
||
|
|
</Footer>
|
||
|
|
</ReportAttrSet>
|
||
|
|
<ReportWriteAttr>
|
||
|
|
<SubmitVisitor class="com.fr.report.write.BuiltInSQLSubmiter">
|
||
|
|
<Name>
|
||
|
|
<![CDATA[内置SQL1]]></Name>
|
||
|
|
<Attributes dsName="FRDemo"/>
|
||
|
|
<DMLConfig class="com.fr.write.config.IntelliDMLConfig">
|
||
|
|
<Table schema="" name="订单"/>
|
||
|
|
<ColumnConfig name="订单ID" isKey="true" skipUnmodified="true">
|
||
|
|
<ColumnRow column="0" row="2"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="客户ID" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="1" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="雇员ID" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="3" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="运货商" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="5" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="运货费" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="1" row="5"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="货主名称" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="3" row="5"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="货主地址" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="5" row="5"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="货主城市" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="1" row="7"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="应付金额" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="3" row="7"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="是否已付" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="5" row="7"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<Condition class="com.fr.data.condition.ListCondition"/>
|
||
|
|
</DMLConfig>
|
||
|
|
</SubmitVisitor>
|
||
|
|
</ReportWriteAttr>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</Report>
|
||
|
|
<Report class="com.fr.report.worksheet.WorkSheet" name="订单明细2">
|
||
|
|
<ReportPageAttr>
|
||
|
|
<HR/>
|
||
|
|
<FR/>
|
||
|
|
<HC/>
|
||
|
|
<FC/>
|
||
|
|
</ReportPageAttr>
|
||
|
|
<ColumnPrivilegeControl/>
|
||
|
|
<RowPrivilegeControl/>
|
||
|
|
<RowHeight defaultValue="723900">
|
||
|
|
<![CDATA[723900,723900,723900,723900,723900,723900,723900,723900,723900,723900,723900]]></RowHeight>
|
||
|
|
<ColumnWidth defaultValue="2743200">
|
||
|
|
<![CDATA[2743200,2743200,2743200,2743200,2743200,1028700,1066800,2743200,2743200,2743200,2743200]]></ColumnWidth>
|
||
|
|
<CellElementList>
|
||
|
|
<C c="0" r="0">
|
||
|
|
<O t="XMLable" class="com.fr.base.Formula">
|
||
|
|
<Attributes>
|
||
|
|
<![CDATA[=$ID]]></Attributes>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<HighlightList>
|
||
|
|
<Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
|
||
|
|
<Name>
|
||
|
|
<![CDATA[条件属性1]]></Name>
|
||
|
|
<Condition class="com.fr.data.condition.ListCondition"/>
|
||
|
|
<HighlightAction class="com.fr.report.cell.cellattr.highlight.RowHeightHighlightAction"/>
|
||
|
|
</Highlight>
|
||
|
|
</HighlightList>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="1" cs="7" s="4">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[产品名称]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[单价]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[数量]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[进价]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[折扣]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[增]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="6" r="2" s="5">
|
||
|
|
<O>
|
||
|
|
<![CDATA[删]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="0" r="3" s="6">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds2" columnName="产品ID"/>
|
||
|
|
<Condition class="com.fr.data.condition.CommonCondition">
|
||
|
|
<CNUMBER>
|
||
|
|
<![CDATA[1]]></CNUMBER>
|
||
|
|
<CNAME>
|
||
|
|
<![CDATA[订单ID]]></CNAME>
|
||
|
|
<Compare op="0">
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="ID"/>
|
||
|
|
<O>
|
||
|
|
<![CDATA[10001]]></O>
|
||
|
|
</Parameter>
|
||
|
|
</Compare>
|
||
|
|
</Condition>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Result>
|
||
|
|
<![CDATA[$$$]]></Result>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.ComboBox">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="产品" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
<widgetValue/>
|
||
|
|
</Widget>
|
||
|
|
<Present class="com.fr.base.present.DictPresent">
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="1"/>
|
||
|
|
<DBDictAttr tableName="产品" schemaName="" ki="0" vi="1" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
</Present>
|
||
|
|
<Expand dir="0" leftParentDefault="false" left="A1"/>
|
||
|
|
</C>
|
||
|
|
<C c="1" r="3" s="6">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds2" columnName="单价"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<NumberAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="2" r="3" s="6">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds2" columnName="数量"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<NumberAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="3" r="3" s="6">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds2" columnName="进价"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<NumberAttr>
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="4" r="3" s="6">
|
||
|
|
<O t="DSColumn">
|
||
|
|
<Attributes dsName="ds2" columnName="折扣"/>
|
||
|
|
<Complex/>
|
||
|
|
<RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
|
||
|
|
<Parameters/>
|
||
|
|
</O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.form.ui.NumberEditor">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<NumberAttr minValue="0.0" maxValue="1.0">
|
||
|
|
<widgetValue/>
|
||
|
|
</NumberAttr>
|
||
|
|
</Widget>
|
||
|
|
<Expand dir="0"/>
|
||
|
|
</C>
|
||
|
|
<C c="5" r="3" s="7">
|
||
|
|
<O>
|
||
|
|
<![CDATA[]]></O>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.report.web.button.write.AppendRowButton">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[add]]></IconName>
|
||
|
|
<FixCell row="3" col="0"/>
|
||
|
|
</Widget>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
<C c="6" r="3" s="7">
|
||
|
|
<PrivilegeControl/>
|
||
|
|
<Widget class="com.fr.report.web.button.write.DeleteRowButton">
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[]]></Hotkeys>
|
||
|
|
<IconName>
|
||
|
|
<![CDATA[delete]]></IconName>
|
||
|
|
<FixCell row="3" col="0"/>
|
||
|
|
</Widget>
|
||
|
|
<Expand/>
|
||
|
|
</C>
|
||
|
|
</CellElementList>
|
||
|
|
<ReportAttrSet>
|
||
|
|
<ReportSettings headerHeight="0" footerHeight="0">
|
||
|
|
<PaperSetting/>
|
||
|
|
<Background name="ColorBackground" color="-1"/>
|
||
|
|
</ReportSettings>
|
||
|
|
</ReportAttrSet>
|
||
|
|
<ReportWriteAttr>
|
||
|
|
<SubmitVisitor class="com.fr.report.write.BuiltInSQLSubmiter">
|
||
|
|
<Name>
|
||
|
|
<![CDATA[内置SQL1]]></Name>
|
||
|
|
<Attributes dsName="FRDemo"/>
|
||
|
|
<DMLConfig class="com.fr.write.config.IntelliDMLConfig">
|
||
|
|
<Table schema="" name="订单明细"/>
|
||
|
|
<ColumnConfig name="订单ID" isKey="true" skipUnmodified="true">
|
||
|
|
<ColumnRow column="0" row="0"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="产品ID" isKey="true" skipUnmodified="true">
|
||
|
|
<ColumnRow column="0" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="单价" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="1" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="数量" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="2" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="进价" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="3" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<ColumnConfig name="折扣" isKey="false" skipUnmodified="true">
|
||
|
|
<ColumnRow column="4" row="3"/>
|
||
|
|
</ColumnConfig>
|
||
|
|
<Condition class="com.fr.data.condition.ListCondition"/>
|
||
|
|
</DMLConfig>
|
||
|
|
</SubmitVisitor>
|
||
|
|
</ReportWriteAttr>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</Report>
|
||
|
|
<ReportParameterAttr>
|
||
|
|
<Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="1" useParamsTemplate="false" currentIndex="4"/>
|
||
|
|
<PWTitle>
|
||
|
|
<![CDATA[参数]]></PWTitle>
|
||
|
|
<ParameterUI class="com.fr.form.main.parameter.FormParameterUI">
|
||
|
|
<Parameters/>
|
||
|
|
<Layout class="com.fr.form.ui.container.WParameterLayout">
|
||
|
|
<WidgetName name="para"/>
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Margin top="0" left="0" bottom="0" right="0"/>
|
||
|
|
<Border>
|
||
|
|
<border style="0" color="-723724" borderRadius="0" type="0" borderStyle="0"/>
|
||
|
|
<WidgetTitle>
|
||
|
|
<O>
|
||
|
|
<![CDATA[新建标题]]></O>
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Position pos="0"/>
|
||
|
|
</WidgetTitle>
|
||
|
|
<Alpha alpha="1.0"/>
|
||
|
|
</Border>
|
||
|
|
<Background name="ColorBackground" color="-526086"/>
|
||
|
|
<LCAttr vgap="0" hgap="0" compInterval="0"/>
|
||
|
|
<Widget class="com.fr.form.ui.container.WAbsoluteLayout$BoundsWidget">
|
||
|
|
<InnerWidget class="com.fr.form.ui.Label">
|
||
|
|
<WidgetName name="label1"/>
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<widgetValue>
|
||
|
|
<O>
|
||
|
|
<![CDATA[订单编号：]]></O>
|
||
|
|
</widgetValue>
|
||
|
|
<LabelAttr verticalcenter="true" textalign="2" autoline="true"/>
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<border style="0" color="-723724"/>
|
||
|
|
</InnerWidget>
|
||
|
|
<BoundsAttr x="0" y="0" width="72" height="19"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.form.ui.container.WAbsoluteLayout$BoundsWidget">
|
||
|
|
<InnerWidget class="com.fr.form.ui.ComboBox">
|
||
|
|
<WidgetName name="ID"/>
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Dictionary class="com.fr.data.impl.DatabaseDictionary">
|
||
|
|
<FormulaDictAttr ki="0" vi="0"/>
|
||
|
|
<DBDictAttr tableName="订单" schemaName="" ki="0" vi="0" kiName="" viName=""/>
|
||
|
|
<Connection class="com.fr.data.impl.NameDatabaseConnection">
|
||
|
|
<DatabaseName>
|
||
|
|
<![CDATA[FRDemo]]></DatabaseName>
|
||
|
|
</Connection>
|
||
|
|
</Dictionary>
|
||
|
|
<widgetValue>
|
||
|
|
<O>
|
||
|
|
<![CDATA[10001]]></O>
|
||
|
|
</widgetValue>
|
||
|
|
</InnerWidget>
|
||
|
|
<BoundsAttr x="72" y="0" width="129" height="19"/>
|
||
|
|
</Widget>
|
||
|
|
<Widget class="com.fr.form.ui.container.WAbsoluteLayout$BoundsWidget">
|
||
|
|
<InnerWidget class="com.fr.form.parameter.FormSubmitButton">
|
||
|
|
<WidgetName name="widget3"/>
|
||
|
|
<WidgetAttr aspectRatioLocked="false" aspectRatioBackup="0.0" description="">
|
||
|
|
<MobileBookMark useBookMark="false" bookMarkName="" frozen="false"/>
|
||
|
|
<PrivilegeControl/>
|
||
|
|
</WidgetAttr>
|
||
|
|
<Text>
|
||
|
|
<![CDATA[查询]]></Text>
|
||
|
|
<Hotkeys>
|
||
|
|
<![CDATA[enter]]></Hotkeys>
|
||
|
|
</InnerWidget>
|
||
|
|
<BoundsAttr x="72" y="38" width="129" height="19"/>
|
||
|
|
</Widget>
|
||
|
|
<ShowBookmarks showBookmarks="false"/>
|
||
|
|
<Sorted sorted="false"/>
|
||
|
|
<MobileWidgetList>
|
||
|
|
<Widget widgetName="ID"/>
|
||
|
|
<Widget widgetName="widget3"/>
|
||
|
|
</MobileWidgetList>
|
||
|
|
<FrozenWidgets/>
|
||
|
|
<MobileBookMarkStyle class="com.fr.form.ui.mobile.impl.DefaultMobileBookMarkStyle"/>
|
||
|
|
<Display display="true"/>
|
||
|
|
<DelayDisplayContent delay="true"/>
|
||
|
|
<UseParamsTemplate use="false"/>
|
||
|
|
<Position position="1"/>
|
||
|
|
<Design_Width design_width="960"/>
|
||
|
|
<NameTagModified/>
|
||
|
|
<WidgetNameTagMap/>
|
||
|
|
<ParamAttr class="com.fr.report.mobile.DefaultMobileParamStyle"/>
|
||
|
|
<ParamStyle class="com.fr.form.ui.mobile.impl.DefaultMobileParameterStyle"/>
|
||
|
|
</Layout>
|
||
|
|
<DesignAttr width="960" height="80"/>
|
||
|
|
</ParameterUI>
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="ID"/>
|
||
|
|
<O>
|
||
|
|
<![CDATA[10001]]></O>
|
||
|
|
</Parameter>
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="sheetParameters"/>
|
||
|
|
<O>
|
||
|
|
<![CDATA[[{\"sheetName\":\"订单明细\",\"newName\":\"BBBB\"},{\"sheetName\":\"订单明细2\",\"newName\":\"CCCC\"}]A]]></O>
|
||
|
|
</Parameter>
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="CopyOfsheetParameters"/>
|
||
|
|
<O>
|
||
|
|
<![CDATA[[{\"sheetName\":\"订单\",\"newName\":\"AAAA\"},{\"sheetName\":\"订单明细\",\"newName\":\"BBBB\"},{\"sheetName\":\"订单明细2\",\"newName\":\"CCCC\"}]A]]></O>
|
||
|
|
</Parameter>
|
||
|
|
<Parameter>
|
||
|
|
<Attributes name="sheetStrict"/>
|
||
|
|
<O t="B">
|
||
|
|
<![CDATA[true]]></O>
|
||
|
|
</Parameter>
|
||
|
|
</ReportParameterAttr>
|
||
|
|
<StyleList>
|
||
|
|
<Style horizontal_alignment="0" imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="1" size="84" foreground="-16739659"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Bottom style="6" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Bottom style="1" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Top color="-6697729"/>
|
||
|
|
<Bottom style="1" color="-6697729"/>
|
||
|
|
<Left color="-6697729"/>
|
||
|
|
<Right color="-6697729"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style imageLayout="1">
|
||
|
|
<Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
|
||
|
|
<![CDATA[#0.00]]></Format>
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Top color="-6697729"/>
|
||
|
|
<Bottom style="1" color="-6697729"/>
|
||
|
|
<Left color="-6697729"/>
|
||
|
|
<Right color="-6697729"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="ImageBackground" layout="2">
|
||
|
|
<FineImage fm="png">
|
||
|
|
<IM>
|
||
|
|
<![CDATA[lO<9(kN.ld@UNU%p%320@UNU)#I6cXfRW$ncQ/@&e8e>$a,l0=Df>"8@V-<f]Aib)[q.F]AuN<
|
||
|
|
*+`9)+iDEno.MO&+OXpe[c7rS1I`_7MAD1p$TIR^qDWb-K@P%(gi<2gG*=J'Uq8ae(9Wr^RK
|
||
|
|
TaP-++)+q&Dfs<>6h,_V[&8muX=*[/NdAgE=GPD"'N:mbjICgforinP#NicD`(3TTFN7HMh=
|
||
|
|
07p<mHFg]AL[_j_[4D\dT:9cFHm)HoIl9[9cUrr[57BUtK(sRH)V5%]Abi%aNkH`A^Ta:]A~
|
||
|
|
]]></IM>
|
||
|
|
</FineImage>
|
||
|
|
</Background>
|
||
|
|
<Border>
|
||
|
|
<Top style="1" color="-6894375"/>
|
||
|
|
<Bottom style="1" color="-6894375"/>
|
||
|
|
<Left style="1" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style horizontal_alignment="0" imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="1" size="72"/>
|
||
|
|
<Background name="ColorBackground" color="-853505"/>
|
||
|
|
<Border>
|
||
|
|
<Top style="1" color="-6894375"/>
|
||
|
|
<Bottom style="1" color="-6894375"/>
|
||
|
|
<Left style="1" color="-6894375"/>
|
||
|
|
<Right style="1" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style horizontal_alignment="0" imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Top style="1" color="-6894375"/>
|
||
|
|
<Bottom style="1" color="-6894375"/>
|
||
|
|
<Left style="1" color="-6894375"/>
|
||
|
|
<Right style="1" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
<Style imageLayout="1">
|
||
|
|
<FRFont name="SimSun" style="0" size="72"/>
|
||
|
|
<Background name="NullBackground"/>
|
||
|
|
<Border>
|
||
|
|
<Top style="1" color="-6894375"/>
|
||
|
|
<Bottom style="1" color="-6894375"/>
|
||
|
|
<Left style="1" color="-6894375"/>
|
||
|
|
<Right style="1" color="-6894375"/>
|
||
|
|
</Border>
|
||
|
|
</Style>
|
||
|
|
</StyleList>
|
||
|
|
<DesignerVersion DesignerVersion="KAA"/>
|
||
|
|
<PreviewType PreviewType="0"/>
|
||
|
|
<TemplateCloudInfoAttrMark class="com.fr.plugin.cloud.analytics.attr.TemplateInfoAttrMark" pluginID="com.fr.plugin.cloud.analytics.v10" plugin-version="2.6.1.20220408">
|
||
|
|
<TemplateCloudInfoAttrMark createTime="1652325876474"/>
|
||
|
|
</TemplateCloudInfoAttrMark>
|
||
|
|
<TemplateIdAttMark class="com.fr.base.iofile.attr.TemplateIdAttrMark">
|
||
|
|
<TemplateIdAttMark TemplateId="eb93159d-0aef-4694-92bf-dccbd39306c5"/>
|
||
|
|
</TemplateIdAttMark>
|
||
|
|
</WorkBook>
|