demo.grf 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  1. {
  2. "Version":"6.6.2.1",
  3. "Font":{
  4. "Name":"宋体",
  5. "Size":105000,
  6. "Weight":400,
  7. "Charset":134
  8. },
  9. "Printer":{
  10. },
  11. "DetailGrid":{
  12. "Recordset":{
  13. "Field":[
  14. {
  15. "Name":"生产号(订单号)",
  16. "DBFieldName":"place_num"
  17. },
  18. {
  19. "Name":"款式",
  20. "DBFieldName":"style"
  21. },
  22. {
  23. "Name":"工序名称",
  24. "DBFieldName":"t_name"
  25. },
  26. {
  27. "Name":"单价",
  28. "Type":"Float",
  29. "Format":"#,##0.0000",
  30. "DBFieldName":"price"
  31. },
  32. {
  33. "Name":"数量",
  34. "Type":"Integer",
  35. "Format":"0",
  36. "DBFieldName":"number"
  37. },
  38. {
  39. "Name":"金额",
  40. "Type":"Float",
  41. "Format":"#,##0.0000",
  42. "DBFieldName":"money"
  43. },
  44. {
  45. "Name":"姓名",
  46. "DBFieldName":"user_name"
  47. },
  48. {
  49. "Name":"员工号",
  50. "DBFieldName":"job_number"
  51. }
  52. ]
  53. },
  54. "Column":[
  55. {
  56. "Name":"place_num",
  57. "Width":3.175
  58. },
  59. {
  60. "Name":"style"
  61. },
  62. {
  63. "Name":"t_name",
  64. "Width":3.38667
  65. },
  66. {
  67. "Name":"price",
  68. "Width":1.61396
  69. },
  70. {
  71. "Name":"number",
  72. "Width":1.79917
  73. },
  74. {
  75. "Name":"money"
  76. }
  77. ],
  78. "ColumnContent":{
  79. "Font":{
  80. "Name":"宋体",
  81. "Size":90000,
  82. "Weight":400,
  83. "Charset":134
  84. },
  85. "ColumnContentCell":[
  86. {
  87. "Column":"place_num",
  88. "DataField":"生产号(订单号)"
  89. },
  90. {
  91. "Column":"style",
  92. "DataField":"款式"
  93. },
  94. {
  95. "Column":"t_name",
  96. "DataField":"工序名称"
  97. },
  98. {
  99. "Column":"price",
  100. "DataField":"单价"
  101. },
  102. {
  103. "Column":"number",
  104. "DataField":"数量"
  105. },
  106. {
  107. "Column":"money",
  108. "DataField":"金额"
  109. }
  110. ]
  111. },
  112. "ColumnTitle":{
  113. "BackColor":"E2EFF1",
  114. "Font":{
  115. "Name":"宋体",
  116. "Size":90000,
  117. "Weight":400,
  118. "Charset":134
  119. },
  120. "RepeatStyle":"OnPage",
  121. "ColumnTitleCell":[
  122. {
  123. "GroupTitle":false,
  124. "Column":"place_num",
  125. "TextAlign":"MiddleCenter",
  126. "Text":"生产号"
  127. },
  128. {
  129. "GroupTitle":false,
  130. "Column":"style",
  131. "TextAlign":"MiddleCenter",
  132. "Text":"款式"
  133. },
  134. {
  135. "GroupTitle":false,
  136. "Column":"t_name",
  137. "TextAlign":"MiddleCenter",
  138. "Text":"工序名称"
  139. },
  140. {
  141. "GroupTitle":false,
  142. "Column":"price",
  143. "TextAlign":"MiddleCenter",
  144. "Text":"单价"
  145. },
  146. {
  147. "GroupTitle":false,
  148. "Column":"number",
  149. "TextAlign":"MiddleCenter",
  150. "Text":"数量"
  151. },
  152. {
  153. "GroupTitle":false,
  154. "Column":"money",
  155. "TextAlign":"MiddleCenter",
  156. "Text":"金额"
  157. }
  158. ]
  159. },
  160. "Group":[
  161. {
  162. "Name":"Group1",
  163. "ByFields":"员工号",
  164. "GroupHeader":{
  165. "Height":0.79,
  166. "Font":{
  167. "Name":"宋体",
  168. "Size":105000,
  169. "Bold":true,
  170. "Charset":134
  171. },
  172. "Control":[
  173. {
  174. "Type":"FieldBox",
  175. "Name":"FieldBox1",
  176. "Center":"Vertical",
  177. "Left":3.20146,
  178. "Top":0.079375,
  179. "Width":2.19604,
  180. "Height":0.608542,
  181. "DataField":"姓名"
  182. },
  183. {
  184. "Type":"FieldBox",
  185. "Name":"FieldBox2",
  186. "Center":"Vertical",
  187. "Left":9.78958,
  188. "Top":0.079375,
  189. "Width":2.61938,
  190. "Height":0.608542,
  191. "DataField":"员工号"
  192. },
  193. {
  194. "Type":"StaticBox",
  195. "Name":"StaticBox1",
  196. "Center":"Vertical",
  197. "Left":2.01083,
  198. "Top":0.079375,
  199. "Width":1.19063,
  200. "Height":0.608542,
  201. "Text":"姓名:"
  202. },
  203. {
  204. "Type":"StaticBox",
  205. "Name":"StaticBox2",
  206. "Center":"Vertical",
  207. "Left":8.20208,
  208. "Top":0.079375,
  209. "Width":1.5875,
  210. "Height":0.608542,
  211. "Text":"员工号:"
  212. }
  213. ]
  214. },
  215. "GroupFooter":{
  216. "BackColor":"E1FFFF",
  217. "Height":0.79,
  218. "Font":{
  219. "Name":"宋体",
  220. "Size":90000,
  221. "Bold":true,
  222. "Charset":134
  223. },
  224. "Control":[
  225. {
  226. "Type":"SummaryBox",
  227. "Name":"SummaryBox1",
  228. "BackColor":"FFFFFF",
  229. "Center":"Vertical",
  230. "Left":11.1919,
  231. "Top":0.079375,
  232. "Width":1.79917,
  233. "Height":0.582083,
  234. "DataField":"数量"
  235. },
  236. {
  237. "Type":"SummaryBox",
  238. "Name":"SummaryBox2",
  239. "BackColor":"FFFFFF",
  240. "Center":"Vertical",
  241. "Left":12.991,
  242. "Top":0.079375,
  243. "Width":3.41313,
  244. "Height":0.582083,
  245. "DataField":"金额"
  246. },
  247. {
  248. "Type":"StaticBox",
  249. "Name":"StaticBox3",
  250. "BackColor":"FFFFFF",
  251. "Center":"Vertical",
  252. "Left":9.2075,
  253. "Top":0.079375,
  254. "Width":1.98438,
  255. "Height":0.582083,
  256. "Text":"个人累计:"
  257. }
  258. ]
  259. }
  260. }
  261. ]
  262. },
  263. "PageHeader":{
  264. "Height":0.608542,
  265. "Font":{
  266. "Name":"宋体",
  267. "Size":90000,
  268. "Weight":400,
  269. "Charset":134
  270. },
  271. "Control":[
  272. {
  273. "Type":"StaticBox",
  274. "Name":"StaticBox4",
  275. "Left":12.991,
  276. "Width":2.61938,
  277. "Height":0.608542,
  278. "Font":{
  279. "Name":"宋体",
  280. "Size":105000,
  281. "Bold":true,
  282. "Charset":134
  283. },
  284. "TextAlign":"MiddleRight",
  285. "Text":"秋天传媒"
  286. }
  287. ]
  288. },
  289. "PageFooter":{
  290. "Height":0.79,
  291. "Font":{
  292. "Name":"宋体",
  293. "Size":90000,
  294. "Weight":400,
  295. "Charset":134
  296. },
  297. "Control":[
  298. {
  299. "Type":"MemoBox",
  300. "Name":"MemoBox1",
  301. "Left":12.5942,
  302. "Width":3.41313,
  303. "Height":0.396875,
  304. "Text":"第[#SystemVar(PageNumber)页/共SystemVar(PageCount)#]页"
  305. }
  306. ]
  307. },
  308. "ReportHeader":[
  309. {
  310. "Name":"报表头",
  311. "Height":1.19063,
  312. "Font":{
  313. "Name":"宋体",
  314. "Size":105000,
  315. "Bold":true,
  316. "Charset":134
  317. },
  318. "Control":[
  319. {
  320. "Type":"StaticBox",
  321. "Name":"TitleBox",
  322. "Center":"Vertical",
  323. "Left":6.32354,
  324. "Top":0.238125,
  325. "Width":3.38667,
  326. "Height":0.687917,
  327. "Font":{
  328. "Name":"宋体",
  329. "Size":142500,
  330. "Bold":true,
  331. "Charset":134
  332. },
  333. "Text":"员工生产计件"
  334. },
  335. {
  336. "Type":"SummaryBox",
  337. "Name":"SummaryBox5",
  338. "Left":11.4035,
  339. "Top":0.608542,
  340. "Width":1.79917,
  341. "Height":0.582083,
  342. "DataField":"数量",
  343. "Format":"0"
  344. },
  345. {
  346. "Type":"SummaryBox",
  347. "Name":"SummaryBox6",
  348. "Left":13.2027,
  349. "Top":0.608542,
  350. "Width":2.80458,
  351. "Height":0.582083,
  352. "DataField":"金额",
  353. "Format":"0.00#"
  354. },
  355. {
  356. "Type":"StaticBox",
  357. "Name":"StaticBox6",
  358. "Left":10.0013,
  359. "Top":0.608542,
  360. "Width":1.40229,
  361. "Height":0.582083,
  362. "TextAlign":"MiddleRight",
  363. "Text":"总计:"
  364. }
  365. ]
  366. }
  367. ]
  368. }