Customer.cpt 26 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <WorkBook xmlVersion="20100901">
  3. <TableDataMap>
  4. <TableData name="ds1" class="com.fr.data.impl.DBTableData">
  5. <Parameters/>
  6. <Attributes maxMemRowCount="-1"/>
  7. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  8. <DatabaseName>
  9. <![CDATA[FRDemo]]></DatabaseName>
  10. </Connection>
  11. <Query>
  12. <![CDATA[SELECT * FROM 填报雇员表]]></Query>
  13. </TableData>
  14. </TableDataMap>
  15. <ReportWebAttr>
  16. <WebWriteContent>
  17. <ToolBars>
  18. <ToolBarManager>
  19. <Location>
  20. <Embed position="1"/>
  21. </Location>
  22. <ToolBar>
  23. <Widget class="com.fr.report.web.ui.impl.write.Submit">
  24. <WidgetAttr disabled="true"/>
  25. <Text>
  26. <![CDATA[提交]]></Text>
  27. <IconName>
  28. <![CDATA[submit]]></IconName>
  29. </Widget>
  30. <Widget class="com.fr.report.web.ui.impl.write.Verify">
  31. <WidgetAttr disabled="true"/>
  32. <Text>
  33. <![CDATA[数据校验]]></Text>
  34. <IconName>
  35. <![CDATA[verify]]></IconName>
  36. </Widget>
  37. <Widget class="com.fr.report.web.ui.impl.FlashPrint">
  38. <WidgetAttr disabled="true"/>
  39. <Text>
  40. <![CDATA[打印[客户端]A]]></Text>
  41. <IconName>
  42. <![CDATA[flashprint]]></IconName>
  43. </Widget>
  44. <Widget class="com.fr.report.web.ui.impl.Print">
  45. <WidgetAttr/>
  46. <Text>
  47. <![CDATA[打印]]></Text>
  48. <IconName>
  49. <![CDATA[print]]></IconName>
  50. <PrintButtons/>
  51. </Widget>
  52. <Widget class="com.fr.report.web.ui.impl.Export">
  53. <WidgetAttr/>
  54. <Text>
  55. <![CDATA[输出]]></Text>
  56. <IconName>
  57. <![CDATA[export]]></IconName>
  58. <Buttons pdf="true" excelP="true" excelO="true" excelS="true" word="true"/>
  59. </Widget>
  60. <Widget class="com.fr.report.web.ui.impl.Email">
  61. <WidgetAttr disabled="true"/>
  62. <Text>
  63. <![CDATA[邮件]]></Text>
  64. <IconName>
  65. <![CDATA[email]]></IconName>
  66. </Widget>
  67. <Widget class="com.fr.report.web.ui.impl.write.ShowCellValue">
  68. <WidgetAttr/>
  69. </Widget>
  70. </ToolBar>
  71. </ToolBarManager>
  72. </ToolBars>
  73. <SelectedColor/>
  74. </WebWriteContent>
  75. <Background name="NullBackground"/>
  76. <CacheValidateTime>
  77. <![CDATA[0]]></CacheValidateTime>
  78. </ReportWebAttr>
  79. <ReportExportAttr>
  80. <ExcelExportAttr/>
  81. <HTMLExportAttr isTDHeavy="true"/>
  82. </ReportExportAttr>
  83. <Report class="com.fr.report.WorkSheet" name="sheet1">
  84. <ReportSettings headerHeight="0.0" footerHeight="0.0">
  85. <PaperSize width="8.267992125984252" height="10.94496062992126"/>
  86. <Margin top="0.07874015748031496" left="0.0" bottom="0.07874015748031496" right="0.0"/>
  87. </ReportSettings>
  88. <ReportPageAttr>
  89. <HR/>
  90. <FR/>
  91. <HC/>
  92. <FC/>
  93. </ReportPageAttr>
  94. <Header reportPageType="0">
  95. <Background name="NullBackground"/>
  96. <LeftList/>
  97. <CenterList/>
  98. <RightList/>
  99. </Header>
  100. <Footer reportPageType="0">
  101. <Background name="NullBackground"/>
  102. <LeftList/>
  103. <CenterList/>
  104. <RightList/>
  105. </Footer>
  106. <RowHeight defaultValue="19">
  107. <![CDATA[62,24,25,24,24,24,40,37,27,22,22,22,22,22,22,22,22,22,19]]></RowHeight>
  108. <ColumnWidth defaultValue="72">
  109. <![CDATA[11,42,91,96,37,95,86,140,111,66,66,84,72]]></ColumnWidth>
  110. <CellElementList>
  111. <C c="1" r="0" cs="11" s="0">
  112. <O>
  113. <![CDATA[客户资料管理卡]]></O>
  114. <Expand/>
  115. </C>
  116. <C c="1" r="1" cs="2" s="1">
  117. <O>
  118. <![CDATA[* 客户名称]]></O>
  119. <Expand/>
  120. </C>
  121. <C c="3" r="1" cs="3" s="2">
  122. <Expand/>
  123. <Widget class="com.fr.report.web.ui.TextEditor">
  124. <WidgetName name="客户名称"/>
  125. <WidgetAttr/>
  126. <allowBlank>
  127. <![CDATA[false]]></allowBlank>
  128. <TextAttr allowBlank="false"/>
  129. </Widget>
  130. </C>
  131. <C c="6" r="1" s="2">
  132. <O>
  133. <![CDATA[地址]]></O>
  134. <Expand/>
  135. </C>
  136. <C c="7" r="1" s="2">
  137. <Expand/>
  138. <Widget class="com.fr.report.web.ui.TextEditor">
  139. <WidgetName name="地址"/>
  140. <WidgetAttr/>
  141. <TextAttr/>
  142. </Widget>
  143. </C>
  144. <C c="8" r="1" s="2">
  145. <O>
  146. <![CDATA[* 客户编号]]></O>
  147. <Expand/>
  148. </C>
  149. <C c="9" r="1" s="2">
  150. <O>
  151. <![CDATA[]]></O>
  152. <CellGUIAttr printContent="false"/>
  153. <Expand/>
  154. <CellInsertPolicy/>
  155. <Widget class="com.fr.report.web.ui.TextEditor">
  156. <WidgetName name="客户编号"/>
  157. <WidgetAttr/>
  158. <allowBlank>
  159. <![CDATA[false]]></allowBlank>
  160. <TextAttr allowBlank="false"/>
  161. </Widget>
  162. <CellPageAttr/>
  163. </C>
  164. <C c="10" r="1" s="2">
  165. <O>
  166. <![CDATA[邮编]]></O>
  167. <Expand/>
  168. </C>
  169. <C c="11" r="1" s="3">
  170. <Expand/>
  171. <Widget class="com.fr.report.web.ui.TextEditor">
  172. <WidgetName name="邮编"/>
  173. <WidgetAttr/>
  174. <TextAttr/>
  175. <Reg class="com.fr.report.web.ui.reg.PostCardReg"/>
  176. </Widget>
  177. </C>
  178. <C c="1" r="2" cs="2" s="4">
  179. <O>
  180. <![CDATA[负责人]]></O>
  181. <Expand/>
  182. </C>
  183. <C c="3" r="2" s="5">
  184. <O>
  185. <![CDATA[]]></O>
  186. <Expand/>
  187. <Widget class="com.fr.report.web.ui.TextEditor">
  188. <WidgetName name="负责人"/>
  189. <WidgetAttr/>
  190. <TextAttr/>
  191. </Widget>
  192. </C>
  193. <C c="4" r="2" s="5">
  194. <O>
  195. <![CDATA[性别]]></O>
  196. <Expand/>
  197. </C>
  198. <C c="5" r="2" s="5">
  199. <Expand/>
  200. <Widget class="com.fr.report.web.ui.RadioGroup">
  201. <WidgetName name="性别"/>
  202. <WidgetAttr/>
  203. <Dictionary class="com.fr.data.impl.CustomDictionary">
  204. <CustomDictAttr>
  205. <Dict key="男" value="男"/>
  206. <Dict key="女" value="女"/>
  207. </CustomDictAttr>
  208. </Dictionary>
  209. </Widget>
  210. </C>
  211. <C c="6" r="2" s="5">
  212. <O>
  213. <![CDATA[年龄]]></O>
  214. <Expand/>
  215. </C>
  216. <C c="7" r="2" s="5">
  217. <Expand/>
  218. <Widget class="com.fr.report.web.ui.NumberEditor">
  219. <WidgetName name="年龄"/>
  220. <WidgetAttr/>
  221. <NumberAttr allowDecimals="false" allowNegative="false" minValue="0.0" maxValue="120.0"/>
  222. </Widget>
  223. </C>
  224. <C c="8" r="2" s="5">
  225. <O>
  226. <![CDATA[职务]]></O>
  227. <Expand/>
  228. </C>
  229. <C c="9" r="2" s="5">
  230. <Expand/>
  231. <Widget class="com.fr.report.web.ui.TextEditor">
  232. <WidgetName name="职务"/>
  233. <WidgetAttr/>
  234. <TextAttr/>
  235. </Widget>
  236. </C>
  237. <C c="10" r="2" s="5">
  238. <O>
  239. <![CDATA[电话]]></O>
  240. <Expand/>
  241. </C>
  242. <C c="11" r="2" s="6">
  243. <Expand/>
  244. <Widget class="com.fr.report.web.ui.TextEditor">
  245. <WidgetName name="电话"/>
  246. <WidgetAttr/>
  247. <TextAttr/>
  248. <Reg class="com.fr.report.web.ui.reg.PhoneReg"/>
  249. </Widget>
  250. </C>
  251. <C c="1" r="3" rs="3" s="4">
  252. <O>
  253. <![CDATA[金\\n融\\n情\\n况]]></O>
  254. <CellGUIAttr showAsImage="true"/>
  255. <Expand/>
  256. <CellInsertPolicy/>
  257. <CellPageAttr/>
  258. </C>
  259. <C c="2" r="3" s="5">
  260. <O>
  261. <![CDATA[往来银行]]></O>
  262. <Expand/>
  263. </C>
  264. <C c="3" r="3" s="5">
  265. <Expand/>
  266. <Widget class="com.fr.report.web.ui.ComboCheckBox">
  267. <WidgetName name="往来银行"/>
  268. <WidgetAttr/>
  269. <Dictionary class="com.fr.data.impl.DynamicSQLDict">
  270. <FormulaDictAttr ki="1" vi="1"/>
  271. <Formula>
  272. <![CDATA[SELECT * FROM 往来银行]]></Formula>
  273. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  274. <DatabaseName>
  275. <![CDATA[FRDemo]]></DatabaseName>
  276. </Connection>
  277. </Dictionary>
  278. <RAAttr isArray="false" delimiter="&apos;,&apos;"/>
  279. </Widget>
  280. </C>
  281. <C c="4" r="3" cs="2" s="5">
  282. <O>
  283. <![CDATA[现金情况]]></O>
  284. <Expand/>
  285. </C>
  286. <C c="6" r="3" cs="2" s="5">
  287. <Expand/>
  288. <Widget class="com.fr.report.web.ui.NumberEditor">
  289. <WidgetName name="现金情况"/>
  290. <WidgetAttr/>
  291. <NumberAttr/>
  292. </Widget>
  293. </C>
  294. <C c="8" r="3" s="5">
  295. <O>
  296. <![CDATA[承办人]]></O>
  297. <Expand/>
  298. </C>
  299. <C c="9" r="3" cs="3" s="6">
  300. <Expand/>
  301. <Widget class="com.fr.report.web.ui.TextEditor">
  302. <WidgetName name="承办人"/>
  303. <WidgetAttr/>
  304. <TextAttr/>
  305. </Widget>
  306. </C>
  307. <C c="2" r="4" s="5">
  308. <O>
  309. <![CDATA[账号]]></O>
  310. <Expand/>
  311. </C>
  312. <C c="3" r="4" s="5">
  313. <O>
  314. <![CDATA[]]></O>
  315. <Expand/>
  316. <Widget class="com.fr.report.web.ui.TextEditor">
  317. <WidgetName name="账号"/>
  318. <WidgetAttr/>
  319. <TextAttr/>
  320. </Widget>
  321. </C>
  322. <C c="4" r="4" cs="2" s="5">
  323. <O>
  324. <![CDATA[资金周转]]></O>
  325. <Expand/>
  326. </C>
  327. <C c="6" r="4" cs="2" s="5">
  328. <Expand/>
  329. <Widget class="com.fr.report.web.ui.ComboBox">
  330. <WidgetName name="资金周转"/>
  331. <WidgetAttr/>
  332. <Dictionary class="com.fr.data.impl.CustomDictionary">
  333. <CustomDictAttr>
  334. <Dict key="盈利" value="盈利"/>
  335. <Dict key="亏损" value="亏损"/>
  336. <Dict key="充裕" value="充裕"/>
  337. <Dict key="缺乏" value="缺乏"/>
  338. </CustomDictAttr>
  339. </Dictionary>
  340. </Widget>
  341. </C>
  342. <C c="8" r="4" s="5">
  343. <O>
  344. <![CDATA[付款态度]]></O>
  345. <Expand/>
  346. </C>
  347. <C c="9" r="4" cs="3" s="6">
  348. <Expand/>
  349. <Widget class="com.fr.report.web.ui.ComboBox">
  350. <WidgetName name="付款态度"/>
  351. <WidgetAttr/>
  352. <Editable>
  353. <![CDATA[false]]></Editable>
  354. <Dictionary class="com.fr.data.impl.CustomDictionary">
  355. <CustomDictAttr>
  356. <Dict key="优" value="优"/>
  357. <Dict key="良" value="良"/>
  358. <Dict key="好" value="好"/>
  359. <Dict key="差" value="差"/>
  360. </CustomDictAttr>
  361. </Dictionary>
  362. </Widget>
  363. </C>
  364. <C c="2" r="5" s="5">
  365. <O>
  366. <![CDATA[税号]]></O>
  367. <Expand/>
  368. </C>
  369. <C c="3" r="5" cs="5" s="5">
  370. <O>
  371. <![CDATA[]]></O>
  372. <Expand/>
  373. <Widget class="com.fr.report.web.ui.TextEditor">
  374. <WidgetName name="税号"/>
  375. <WidgetAttr/>
  376. <TextAttr/>
  377. </Widget>
  378. </C>
  379. <C c="8" r="5" s="5">
  380. <O>
  381. <![CDATA[付款日期]]></O>
  382. <Expand/>
  383. </C>
  384. <C c="9" r="5" cs="3" s="7">
  385. <Expand/>
  386. <Widget class="com.fr.report.web.ui.DateEditor">
  387. <WidgetName name="付款日期"/>
  388. <WidgetAttr/>
  389. <DateAttr start="" end=""/>
  390. </Widget>
  391. </C>
  392. <C c="1" r="6" cs="2" s="4">
  393. <O>
  394. <![CDATA[开始交易日期]]></O>
  395. <Expand/>
  396. </C>
  397. <C c="3" r="6" cs="4" s="8">
  398. <Expand/>
  399. <Widget class="com.fr.report.web.ui.DateEditor">
  400. <WidgetName name="开始交易日期"/>
  401. <WidgetAttr/>
  402. <DateAttr start="" end=""/>
  403. </Widget>
  404. </C>
  405. <C c="7" r="6" s="5">
  406. <O>
  407. <![CDATA[主营产品]]></O>
  408. <Expand/>
  409. </C>
  410. <C c="8" r="6" cs="4" s="6">
  411. <O>
  412. <![CDATA[]]></O>
  413. <Expand/>
  414. <Widget class="com.fr.report.web.ui.CheckBoxGroup">
  415. <WidgetName name="主营产品"/>
  416. <WidgetAttr/>
  417. <Dictionary class="com.fr.data.impl.DatabaseDictionary">
  418. <FormulaDictAttr ki="1" vi="1"/>
  419. <DBDictAttr tableName="产品项目" schemaName="" ki="1" vi="1"/>
  420. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  421. <DatabaseName>
  422. <![CDATA[FRDemo]]></DatabaseName>
  423. </Connection>
  424. </Dictionary>
  425. <RAAttr isArray="false" delimiter="&apos;,&apos;"/>
  426. </Widget>
  427. </C>
  428. <C c="12" r="6">
  429. <O>
  430. <![CDATA[]]></O>
  431. <Expand/>
  432. </C>
  433. <C c="1" r="7" rs="7" s="4">
  434. <O>
  435. <![CDATA[营\\n业\\n概\\n况]]></O>
  436. <CellGUIAttr showAsImage="true"/>
  437. <Expand/>
  438. <CellInsertPolicy/>
  439. <CellPageAttr/>
  440. </C>
  441. <C c="2" r="7" s="5">
  442. <O>
  443. <![CDATA[营业项目]]></O>
  444. <Expand/>
  445. </C>
  446. <C c="3" r="7" s="5">
  447. <Expand/>
  448. <Widget class="com.fr.report.web.ui.TreeComboBoxEditor">
  449. <WidgetName name="营业项目"/>
  450. <WidgetAttr/>
  451. <Editable>
  452. <![CDATA[false]]></Editable>
  453. <TreeAttr/>
  454. <TreeNodeAttr>
  455. <Dictionary class="com.fr.data.impl.DatabaseDictionary">
  456. <FormulaDictAttr ki="1" vi="1">
  457. <Condition class="com.fr.data.condition.ListCondition"/>
  458. </FormulaDictAttr>
  459. <DBDictAttr tableName="产品项目" schemaName="" ki="1" vi="1"/>
  460. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  461. <DatabaseName>
  462. <![CDATA[FRDemo]]></DatabaseName>
  463. </Connection>
  464. <Condition class="com.fr.data.condition.ListCondition"/>
  465. </Dictionary>
  466. </TreeNodeAttr>
  467. <TreeNodeAttr>
  468. <Dictionary class="com.fr.data.impl.DynamicSQLDict">
  469. <FormulaDictAttr ki="0" vi="0">
  470. <Condition class="com.fr.data.condition.ListCondition"/>
  471. </FormulaDictAttr>
  472. <Formula>
  473. <![CDATA[SELECT 营业项目 FROM 产品项目 where 主营产品='${@1}' ]]></Formula>
  474. <Connection class="com.fr.data.impl.NameDatabaseConnection">
  475. <DatabaseName>
  476. <![CDATA[FRDemo]]></DatabaseName>
  477. </Connection>
  478. </Dictionary>
  479. </TreeNodeAttr>
  480. </Widget>
  481. </C>
  482. <C c="4" r="7" cs="2" s="5">
  483. <O>
  484. <![CDATA[仓库情况]]></O>
  485. <Expand/>
  486. </C>
  487. <C c="6" r="7" s="5">
  488. <Expand/>
  489. <Widget class="com.fr.report.web.ui.TextEditor">
  490. <WidgetName name="仓库情况"/>
  491. <WidgetAttr/>
  492. <TextAttr/>
  493. </Widget>
  494. </C>
  495. <C c="7" r="7" s="5">
  496. <O>
  497. <![CDATA[员工人数及素质]]></O>
  498. <Expand/>
  499. </C>
  500. <C c="8" r="7" s="5">
  501. <Expand/>
  502. <Widget class="com.fr.report.web.ui.NumberEditor">
  503. <WidgetName name="员工人数及素质"/>
  504. <WidgetAttr/>
  505. <NumberAttr allowDecimals="false" allowNegative="false"/>
  506. </Widget>
  507. </C>
  508. <C c="9" r="7" s="5">
  509. <O>
  510. <![CDATA[运输方式]]></O>
  511. <Expand/>
  512. </C>
  513. <C c="10" r="7" cs="2" s="6">
  514. <Expand/>
  515. <Widget class="com.fr.report.web.ui.CheckBoxGroup">
  516. <WidgetName name="运输方式"/>
  517. <WidgetAttr/>
  518. <Dictionary class="com.fr.data.impl.CustomDictionary">
  519. <CustomDictAttr>
  520. <Dict key="铁路" value="铁路"/>
  521. <Dict key="水运" value="水运"/>
  522. <Dict key="汽运" value="汽运"/>
  523. <Dict key="自提" value="自提"/>
  524. </CustomDictAttr>
  525. </Dictionary>
  526. </Widget>
  527. </C>
  528. <C c="2" r="8" s="5">
  529. <O>
  530. <![CDATA[经营体制]]></O>
  531. <Expand/>
  532. </C>
  533. <C c="3" r="8" s="5">
  534. <Expand/>
  535. <Widget class="com.fr.report.web.ui.ComboBox">
  536. <WidgetName name="经营体制"/>
  537. <WidgetAttr/>
  538. <Dictionary class="com.fr.data.impl.CustomDictionary">
  539. <CustomDictAttr>
  540. <Dict key="合同雇佣制" value="合同雇佣制"/>
  541. <Dict key="职务工资制" value="职务工资制"/>
  542. </CustomDictAttr>
  543. </Dictionary>
  544. </Widget>
  545. </C>
  546. <C c="4" r="8" cs="2" s="5">
  547. <O>
  548. <![CDATA[服务车数目]]></O>
  549. <Expand/>
  550. </C>
  551. <C c="6" r="8" s="5">
  552. <O>
  553. <![CDATA[]]></O>
  554. <Expand/>
  555. <Widget class="com.fr.report.web.ui.NumberEditor">
  556. <WidgetName name="服务车数目"/>
  557. <WidgetAttr/>
  558. <NumberAttr allowDecimals="false" allowNegative="false"/>
  559. </Widget>
  560. </C>
  561. <C c="7" r="8" s="5">
  562. <O>
  563. <![CDATA[零售商数及覆盖情况]]></O>
  564. <Expand/>
  565. </C>
  566. <C c="8" r="8" cs="4" s="6">
  567. <O>
  568. <![CDATA[]]></O>
  569. <Expand/>
  570. <Widget class="com.fr.report.web.ui.TextEditor">
  571. <WidgetName name="零售商数及覆盖情况"/>
  572. <WidgetAttr/>
  573. <TextAttr/>
  574. </Widget>
  575. </C>
  576. <C c="2" r="9" s="5">
  577. <O>
  578. <![CDATA[批发商数]]></O>
  579. <Expand/>
  580. </C>
  581. <C c="3" r="9" s="5">
  582. <Expand/>
  583. <Widget class="com.fr.report.web.ui.NumberEditor">
  584. <WidgetAttr/>
  585. <NumberAttr allowDecimals="false" allowNegative="false"/>
  586. </Widget>
  587. </C>
  588. <C c="4" r="9" cs="2" s="5">
  589. <O>
  590. <![CDATA[营业范围]]></O>
  591. <Expand/>
  592. </C>
  593. <C c="6" r="9" s="9">
  594. <Expand/>
  595. <Widget class="com.fr.report.web.ui.TextEditor">
  596. <WidgetName name="营业范围"/>
  597. <WidgetAttr/>
  598. <TextAttr/>
  599. </Widget>
  600. </C>
  601. <C c="7" r="9" s="5">
  602. <O>
  603. <![CDATA[门市面积]]></O>
  604. <Expand/>
  605. </C>
  606. <C c="8" r="9" cs="4" s="6">
  607. <Expand/>
  608. <Widget class="com.fr.report.web.ui.NumberEditor">
  609. <WidgetName name="门市面积"/>
  610. <WidgetAttr/>
  611. <NumberAttr allowNegative="false"/>
  612. </Widget>
  613. </C>
  614. <C c="2" r="10" s="5">
  615. <O>
  616. <![CDATA[经营方针]]></O>
  617. <Expand/>
  618. </C>
  619. <C c="3" r="10" cs="9" s="10">
  620. <O>
  621. <![CDATA[]]></O>
  622. <Expand/>
  623. <Widget class="com.fr.report.web.ui.CheckBoxGroup">
  624. <WidgetName name="经营方针"/>
  625. <WidgetAttr/>
  626. <Dictionary class="com.fr.data.impl.CustomDictionary">
  627. <CustomDictAttr>
  628. <Dict key="销售上量" value="销售上量"/>
  629. <Dict key="利润为准" value="利润为准"/>
  630. <Dict key="量利兼顾" value="量利兼顾"/>
  631. <Dict key="积极" value="积极"/>
  632. <Dict key="保守" value="保守"/>
  633. <Dict key="平常" value="平常"/>
  634. <Dict key="投机" value="投机"/>
  635. <Dict key="凌乱" value="凌乱"/>
  636. </CustomDictAttr>
  637. </Dictionary>
  638. </Widget>
  639. </C>
  640. <C c="2" r="11" rs="3" s="5">
  641. <O>
  642. <![CDATA[年度销售潜力]]></O>
  643. <Expand/>
  644. </C>
  645. <C c="3" r="11" s="5">
  646. <O>
  647. <![CDATA[进货]]></O>
  648. <Expand/>
  649. </C>
  650. <C c="4" r="11" cs="3" s="5">
  651. <Expand/>
  652. <Widget class="com.fr.report.web.ui.NumberEditor">
  653. <WidgetName name="进货"/>
  654. <WidgetAttr/>
  655. <NumberAttr/>
  656. </Widget>
  657. </C>
  658. <C c="7" r="11" rs="3" s="5">
  659. <O>
  660. <![CDATA[第一品牌]]></O>
  661. <Expand/>
  662. </C>
  663. <C c="8" r="11" s="5">
  664. <O>
  665. <![CDATA[进货]]></O>
  666. <Expand/>
  667. </C>
  668. <C c="9" r="11" cs="3" s="6">
  669. <Expand/>
  670. <Widget class="com.fr.report.web.ui.NumberEditor">
  671. <WidgetName name="第一品牌进货"/>
  672. <WidgetAttr/>
  673. <NumberAttr/>
  674. </Widget>
  675. </C>
  676. <C c="3" r="12" s="5">
  677. <O>
  678. <![CDATA[销售]]></O>
  679. <Expand/>
  680. </C>
  681. <C c="4" r="12" cs="3" s="5">
  682. <Expand/>
  683. <Widget class="com.fr.report.web.ui.NumberEditor">
  684. <WidgetName name="销售"/>
  685. <WidgetAttr/>
  686. <NumberAttr/>
  687. </Widget>
  688. </C>
  689. <C c="8" r="12" s="5">
  690. <O>
  691. <![CDATA[销售]]></O>
  692. <Expand/>
  693. </C>
  694. <C c="9" r="12" cs="3" s="6">
  695. <Expand/>
  696. <Widget class="com.fr.report.web.ui.NumberEditor">
  697. <WidgetName name="第一品牌销售"/>
  698. <WidgetAttr/>
  699. <NumberAttr/>
  700. </Widget>
  701. </C>
  702. <C c="3" r="13" s="5">
  703. <O>
  704. <![CDATA[存货]]></O>
  705. <Expand/>
  706. </C>
  707. <C c="4" r="13" cs="3" s="5">
  708. <O t="Formula" class="Formula">
  709. <Attributes>
  710. <![CDATA[=E12 - E13]]></Attributes>
  711. </O>
  712. <Expand/>
  713. <Widget class="com.fr.report.web.ui.TextEditor">
  714. <WidgetAttr/>
  715. <TextAttr/>
  716. </Widget>
  717. </C>
  718. <C c="8" r="13" s="5">
  719. <O>
  720. <![CDATA[存货]]></O>
  721. <Expand/>
  722. </C>
  723. <C c="9" r="13" cs="3" s="6">
  724. <O t="Formula" class="Formula">
  725. <Attributes>
  726. <![CDATA[=J12 - J13]]></Attributes>
  727. </O>
  728. <Expand/>
  729. <Widget class="com.fr.report.web.ui.TextEditor">
  730. <WidgetName name="第一品牌存货"/>
  731. <WidgetAttr/>
  732. <TextAttr/>
  733. </Widget>
  734. </C>
  735. <C c="1" r="14" cs="2" s="4">
  736. <O>
  737. <![CDATA[最高信用额度]]></O>
  738. <Expand/>
  739. </C>
  740. <C c="3" r="14" cs="4" s="9">
  741. <O>
  742. <![CDATA[]]></O>
  743. <Expand/>
  744. <Widget class="com.fr.report.web.ui.NumberEditor">
  745. <WidgetName name="最高信用额度"/>
  746. <WidgetAttr/>
  747. <NumberAttr/>
  748. </Widget>
  749. </C>
  750. <C c="7" r="14" s="5">
  751. <O>
  752. <![CDATA[客户等级]]></O>
  753. <Expand/>
  754. </C>
  755. <C c="8" r="14" cs="4" s="6">
  756. <Expand/>
  757. <Widget class="com.fr.report.web.ui.ComboBox">
  758. <WidgetName name="客户等级"/>
  759. <WidgetAttr/>
  760. <Dictionary class="com.fr.data.impl.CustomDictionary">
  761. <CustomDictAttr>
  762. <Dict key="一级" value="一级"/>
  763. <Dict key="二级" value="二级"/>
  764. <Dict key="三级" value="三级"/>
  765. <Dict key="四级" value="四级"/>
  766. </CustomDictAttr>
  767. </Dictionary>
  768. </Widget>
  769. </C>
  770. <C c="1" r="15" cs="2" s="4">
  771. <O>
  772. <![CDATA[总体月均库存数]]></O>
  773. <Expand/>
  774. </C>
  775. <C c="3" r="15" cs="4" s="5">
  776. <O t="Formula" class="Formula">
  777. <Attributes>
  778. <![CDATA[=E14 / 12]]></Attributes>
  779. </O>
  780. <Expand/>
  781. <Widget class="com.fr.report.web.ui.TextEditor">
  782. <WidgetAttr/>
  783. <TextAttr/>
  784. </Widget>
  785. </C>
  786. <C c="7" r="15" s="5">
  787. <O>
  788. <![CDATA[月均库存数]]></O>
  789. <Expand/>
  790. </C>
  791. <C c="8" r="15" cs="4" s="6">
  792. <O t="Formula" class="Formula">
  793. <Attributes>
  794. <![CDATA[=J14 / 12]]></Attributes>
  795. </O>
  796. <Expand/>
  797. <Widget class="com.fr.report.web.ui.NumberEditor">
  798. <WidgetName name="月均库存数"/>
  799. <WidgetAttr/>
  800. <NumberAttr/>
  801. </Widget>
  802. </C>
  803. <C c="1" r="16" cs="2" s="4">
  804. <O>
  805. <![CDATA[价格/折扣]]></O>
  806. <Expand/>
  807. </C>
  808. <C c="3" r="16" cs="4" s="5">
  809. <Expand/>
  810. <Widget class="com.fr.report.web.ui.NumberEditor">
  811. <WidgetName name="折扣"/>
  812. <WidgetAttr/>
  813. <NumberAttr/>
  814. </Widget>
  815. </C>
  816. <C c="7" r="16" cs="2" s="5">
  817. <O>
  818. <![CDATA[支持和服务的承诺]]></O>
  819. <Expand/>
  820. </C>
  821. <C c="9" r="16" cs="3" s="6">
  822. <Expand/>
  823. <Widget class="com.fr.report.web.ui.TextEditor">
  824. <WidgetName name="承诺"/>
  825. <WidgetAttr/>
  826. <TextAttr/>
  827. </Widget>
  828. </C>
  829. <C c="1" r="17" cs="2" s="11">
  830. <O>
  831. <![CDATA[竞品经营情况]]></O>
  832. <Expand/>
  833. </C>
  834. <C c="3" r="17" cs="9" s="12">
  835. <Expand/>
  836. <Widget class="com.fr.report.web.ui.TextArea">
  837. <WidgetName name="竞品经营情况"/>
  838. <WidgetAttr/>
  839. <TextAttr/>
  840. </Widget>
  841. </C>
  842. </CellElementList>
  843. <ReportWriteAttr>
  844. <Submiter class="com.fr.report.write.BuiltInSQLSubmiter" name="内置SQL1">
  845. <Attributes dsName="FRDemo"/>
  846. <DMLConfig class="com.fr.report.write.config.IntelliDMLConfig">
  847. <Table schema="" name="填报雇员表"/>
  848. <ColumnConfig name="客户编号" isKey="true" skipUnmodified="false">
  849. <ColumnRow column="9" row="1"/>
  850. </ColumnConfig>
  851. <ColumnConfig name="客户名称" isKey="true" skipUnmodified="false">
  852. <ColumnRow column="3" row="1"/>
  853. </ColumnConfig>
  854. <ColumnConfig name="地址" isKey="false" skipUnmodified="false">
  855. <ColumnRow column="7" row="1"/>
  856. </ColumnConfig>
  857. <ColumnConfig name="邮编" isKey="false" skipUnmodified="false">
  858. <ColumnRow column="11" row="1"/>
  859. </ColumnConfig>
  860. <ColumnConfig name="负责人" isKey="false" skipUnmodified="false">
  861. <ColumnRow column="3" row="2"/>
  862. </ColumnConfig>
  863. <ColumnConfig name="性别" isKey="false" skipUnmodified="false">
  864. <ColumnRow column="5" row="2"/>
  865. </ColumnConfig>
  866. <ColumnConfig name="年龄" isKey="false" skipUnmodified="false">
  867. <ColumnRow column="7" row="2"/>
  868. </ColumnConfig>
  869. <ColumnConfig name="职务" isKey="false" skipUnmodified="false">
  870. <ColumnRow column="9" row="2"/>
  871. </ColumnConfig>
  872. <ColumnConfig name="电话" isKey="false" skipUnmodified="false">
  873. <ColumnRow column="11" row="2"/>
  874. </ColumnConfig>
  875. <ColumnConfig name="来往银行" isKey="false" skipUnmodified="false">
  876. <ColumnRow column="3" row="3"/>
  877. </ColumnConfig>
  878. <ColumnConfig name="账号" isKey="false" skipUnmodified="false">
  879. <ColumnRow column="3" row="4"/>
  880. </ColumnConfig>
  881. <ColumnConfig name="税号" isKey="false" skipUnmodified="false">
  882. <ColumnRow column="3" row="5"/>
  883. </ColumnConfig>
  884. <ColumnConfig name="现今情况" isKey="false" skipUnmodified="false">
  885. <ColumnRow column="6" row="3"/>
  886. </ColumnConfig>
  887. <ColumnConfig name="资金周转" isKey="false" skipUnmodified="false">
  888. <ColumnRow column="6" row="4"/>
  889. </ColumnConfig>
  890. <ColumnConfig name="承办人员" isKey="false" skipUnmodified="false">
  891. <ColumnRow column="9" row="3"/>
  892. </ColumnConfig>
  893. <ColumnConfig name="付款态度" isKey="false" skipUnmodified="false">
  894. <ColumnRow column="9" row="4"/>
  895. </ColumnConfig>
  896. <ColumnConfig name="付款日期" isKey="false" skipUnmodified="false">
  897. <ColumnRow column="9" row="5"/>
  898. </ColumnConfig>
  899. <ColumnConfig name="开始交易日期" isKey="false" skipUnmodified="false">
  900. <ColumnRow column="3" row="6"/>
  901. </ColumnConfig>
  902. <ColumnConfig name="主营产品" isKey="false" skipUnmodified="false">
  903. <ColumnRow column="8" row="6"/>
  904. </ColumnConfig>
  905. <ColumnConfig name="营业项目" isKey="false" skipUnmodified="false">
  906. <ColumnRow column="3" row="7"/>
  907. </ColumnConfig>
  908. <ColumnConfig name="经营体制" isKey="false" skipUnmodified="false">
  909. <ColumnRow column="3" row="8"/>
  910. </ColumnConfig>
  911. <ColumnConfig name="批发商数" isKey="false" skipUnmodified="false">
  912. <ColumnRow column="3" row="9"/>
  913. </ColumnConfig>
  914. <ColumnConfig name="经营方针" isKey="false" skipUnmodified="false">
  915. <ColumnRow column="3" row="10"/>
  916. </ColumnConfig>
  917. <ColumnConfig name="进货" isKey="false" skipUnmodified="false">
  918. <ColumnRow column="4" row="11"/>
  919. </ColumnConfig>
  920. <ColumnConfig name="销售" isKey="false" skipUnmodified="false">
  921. <ColumnRow column="4" row="12"/>
  922. </ColumnConfig>
  923. <ColumnConfig name="存货" isKey="false" skipUnmodified="false">
  924. <ColumnRow column="4" row="13"/>
  925. </ColumnConfig>
  926. <ColumnConfig name="第一品牌进货" isKey="false" skipUnmodified="false">
  927. <ColumnRow column="9" row="11"/>
  928. </ColumnConfig>
  929. <ColumnConfig name="第一品牌销售" isKey="false" skipUnmodified="false">
  930. <ColumnRow column="9" row="12"/>
  931. </ColumnConfig>
  932. <ColumnConfig name="第一品牌存货" isKey="false" skipUnmodified="false">
  933. <ColumnRow column="9" row="13"/>
  934. </ColumnConfig>
  935. <ColumnConfig name="最高信用额度" isKey="false" skipUnmodified="false">
  936. <ColumnRow column="1" row="14"/>
  937. </ColumnConfig>
  938. <ColumnConfig name="总体月均库存" isKey="false" skipUnmodified="false">
  939. <ColumnRow column="3" row="15"/>
  940. </ColumnConfig>
  941. <ColumnConfig name="价格/折扣" isKey="false" skipUnmodified="false">
  942. <ColumnRow column="3" row="16"/>
  943. </ColumnConfig>
  944. <ColumnConfig name="竞品经营情况" isKey="false" skipUnmodified="false">
  945. <ColumnRow column="3" row="17"/>
  946. </ColumnConfig>
  947. <ColumnConfig name="客户等级" isKey="false" skipUnmodified="false">
  948. <ColumnRow column="8" row="14"/>
  949. </ColumnConfig>
  950. <ColumnConfig name="月均库存数" isKey="false" skipUnmodified="false">
  951. <ColumnRow column="8" row="15"/>
  952. </ColumnConfig>
  953. <ColumnConfig name="支持和服务的承诺" isKey="false" skipUnmodified="false">
  954. <ColumnRow column="9" row="16"/>
  955. </ColumnConfig>
  956. <ColumnConfig name="服务车数量" isKey="false" skipUnmodified="false">
  957. <ColumnRow column="6" row="8"/>
  958. </ColumnConfig>
  959. <ColumnConfig name="仓储情况" isKey="false" skipUnmodified="false">
  960. <ColumnRow column="6" row="7"/>
  961. </ColumnConfig>
  962. <ColumnConfig name="员工人数及素质" isKey="false" skipUnmodified="false">
  963. <ColumnRow column="8" row="7"/>
  964. </ColumnConfig>
  965. <ColumnConfig name="零售商数及覆盖情况" isKey="false" skipUnmodified="false">
  966. <ColumnRow column="8" row="8"/>
  967. </ColumnConfig>
  968. <ColumnConfig name="门市面积" isKey="false" skipUnmodified="false">
  969. <ColumnRow column="8" row="9"/>
  970. </ColumnConfig>
  971. <ColumnConfig name="营业范围" isKey="false" skipUnmodified="false">
  972. <ColumnRow column="6" row="9"/>
  973. </ColumnConfig>
  974. <ColumnConfig name="运输方式" isKey="false" skipUnmodified="false">
  975. <ColumnRow column="10" row="7"/>
  976. </ColumnConfig>
  977. </DMLConfig>
  978. </Submiter>
  979. </ReportWriteAttr>
  980. </Report>
  981. <ReportParameterAttr>
  982. <Attributes showWindow="false" delayPlaying="true" windowPosition="1" align="1"/>
  983. <PWTitle>
  984. <![CDATA[参数]]></PWTitle>
  985. </ReportParameterAttr>
  986. <StyleList>
  987. <Style horizontal_alignment="0">
  988. <FRFont name="黑体" style="0" size="20" foreground="-8355712"/>
  989. <Background name="NullBackground"/>
  990. <Border/>
  991. </Style>
  992. <Style horizontal_alignment="0">
  993. <FRFont name="SimSun" style="0" size="12"/>
  994. <Background name="NullBackground"/>
  995. <Border>
  996. <Top style="6" color="-14117142"/>
  997. <Bottom style="1" color="-14117142"/>
  998. <Left style="6" color="-14117142"/>
  999. <Right style="1" color="-14117142"/>
  1000. </Border>
  1001. </Style>
  1002. <Style horizontal_alignment="0">
  1003. <FRFont name="SimSun" style="0" size="12"/>
  1004. <Background name="NullBackground"/>
  1005. <Border>
  1006. <Top style="6" color="-14117142"/>
  1007. <Bottom style="1" color="-14117142"/>
  1008. <Left style="1" color="-14117142"/>
  1009. <Right style="1" color="-14117142"/>
  1010. </Border>
  1011. </Style>
  1012. <Style horizontal_alignment="0">
  1013. <FRFont name="SimSun" style="0" size="12"/>
  1014. <Background name="NullBackground"/>
  1015. <Border>
  1016. <Top style="6" color="-14117142"/>
  1017. <Bottom style="1" color="-14117142"/>
  1018. <Left style="1" color="-14117142"/>
  1019. <Right style="6" color="-14117142"/>
  1020. </Border>
  1021. </Style>
  1022. <Style horizontal_alignment="0">
  1023. <FRFont name="SimSun" style="0" size="12"/>
  1024. <Background name="NullBackground"/>
  1025. <Border>
  1026. <Top style="1" color="-14117142"/>
  1027. <Bottom style="1" color="-14117142"/>
  1028. <Left style="6" color="-14117142"/>
  1029. <Right style="1" color="-14117142"/>
  1030. </Border>
  1031. </Style>
  1032. <Style horizontal_alignment="0">
  1033. <FRFont name="SimSun" style="0" size="12"/>
  1034. <Background name="NullBackground"/>
  1035. <Border>
  1036. <Top style="1" color="-14117142"/>
  1037. <Bottom style="1" color="-14117142"/>
  1038. <Left style="1" color="-14117142"/>
  1039. <Right style="1" color="-14117142"/>
  1040. </Border>
  1041. </Style>
  1042. <Style horizontal_alignment="0">
  1043. <FRFont name="SimSun" style="0" size="12"/>
  1044. <Background name="NullBackground"/>
  1045. <Border>
  1046. <Top style="1" color="-14117142"/>
  1047. <Bottom style="1" color="-14117142"/>
  1048. <Left style="1" color="-14117142"/>
  1049. <Right style="6" color="-14117142"/>
  1050. </Border>
  1051. </Style>
  1052. <Style horizontal_alignment="0">
  1053. <Format class="java.text.SimpleDateFormat">
  1054. <![CDATA[yyyy-MM-dd]]></Format>
  1055. <FRFont name="SimSun" style="0" size="12"/>
  1056. <Background name="NullBackground"/>
  1057. <Border>
  1058. <Top style="1" color="-14117142"/>
  1059. <Bottom style="1" color="-14117142"/>
  1060. <Left style="1" color="-14117142"/>
  1061. <Right style="6" color="-14117142"/>
  1062. </Border>
  1063. </Style>
  1064. <Style horizontal_alignment="0">
  1065. <Format class="java.text.SimpleDateFormat">
  1066. <![CDATA[yyyy-MM-dd]]></Format>
  1067. <FRFont name="SimSun" style="0" size="12"/>
  1068. <Background name="NullBackground"/>
  1069. <Border>
  1070. <Top style="1" color="-14117142"/>
  1071. <Bottom style="1" color="-14117142"/>
  1072. <Left style="1" color="-14117142"/>
  1073. <Right style="1" color="-14117142"/>
  1074. </Border>
  1075. </Style>
  1076. <Style>
  1077. <FRFont name="SimSun" style="0" size="12"/>
  1078. <Background name="NullBackground"/>
  1079. <Border>
  1080. <Top style="1" color="-14117142"/>
  1081. <Bottom style="1" color="-14117142"/>
  1082. <Left style="1" color="-14117142"/>
  1083. <Right style="1" color="-14117142"/>
  1084. </Border>
  1085. </Style>
  1086. <Style>
  1087. <FRFont name="SimSun" style="0" size="12"/>
  1088. <Background name="NullBackground"/>
  1089. <Border>
  1090. <Top style="1" color="-14117142"/>
  1091. <Bottom style="1" color="-14117142"/>
  1092. <Left style="1" color="-14117142"/>
  1093. <Right style="6" color="-14117142"/>
  1094. </Border>
  1095. </Style>
  1096. <Style horizontal_alignment="0">
  1097. <FRFont name="SimSun" style="0" size="12"/>
  1098. <Background name="NullBackground"/>
  1099. <Border>
  1100. <Top style="1" color="-14117142"/>
  1101. <Bottom style="6" color="-14117142"/>
  1102. <Left style="6" color="-14117142"/>
  1103. <Right style="1" color="-14117142"/>
  1104. </Border>
  1105. </Style>
  1106. <Style horizontal_alignment="0">
  1107. <FRFont name="SimSun" style="0" size="12"/>
  1108. <Background name="NullBackground"/>
  1109. <Border>
  1110. <Top style="1" color="-14117142"/>
  1111. <Bottom style="6" color="-14117142"/>
  1112. <Left style="1" color="-14117142"/>
  1113. <Right style="6" color="-14117142"/>
  1114. </Border>
  1115. </Style>
  1116. </StyleList>
  1117. </WorkBook>