demo5.grf 6.6 KB

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