vatModule.controller('devGridHeaderController', ['$log', '$scope', '$translate',
    function ($log, $scope, $translate) {
        $scope.trialBalanceOptions = [
            { id: 1, name: '科目代码' },
            { id: 2, name: '科目名称' },
            { id: 3, name: '期初借方' },
            { id: 4, name: '期初贷方' },
            { id: 5, name: '发生借方' },
            { id: 6, name: '发生贷方' },
            { id: 7, name: '期末借方' },
            { id: 8, name: '期末贷方' }
        ];
        //var allData = "101,现金,\"1,086.11\",,\"5,731,688.37\",\"5,738,891.10\",\"-6,116.62\",\r\n102,银行存款,\"3,349,505.10\",,\"52,426,746.24\",\"48,621,012.13\",\"7,155,239.21\",\r\n  10201,城南办-1004,\"245,570.87\",,\"29,215,963.81\",\"29,462,293.30\",-758.62,\r\n  10202,城南办-6626,\"442,587.28\",,\"9,040,329.42\",\"8,467,800.76\",\"1,015,115.94\",\r\n  10203,城西办-9801,0.00,,0.00,0.00,0.00,\r\n  10204,商行汇丰处,\"1,010,376.35\",,\"6,869,634.96\",\"6,850,536.80\",\"1,029,474.51\",\r\n  10205,中行,0.00,,0.00,0.00,0.00,\r\n  10206,建行公积金,\"1,612,770.31\",,\"635,572.45\",\"434,256.97\",\"1,814,085.79\",\r\n  10207,交行-9153,84.09,,\"2,394,726.85\",\"2,394,711.98\",98.96,\r\n  10208,商行-2605,54.41,,\"513,486.70\",\"511,374.82\",\"2,166.29\",\r\n  10209,交行61993,\"38,061.79\",,\"2,755,831.85\",\"500,017.50\",\"2,293,876.14\",\r\n  10210,浦发银行营业部,0.00,,\"1,001,200.20\",20.00,\"1,001,180.20\",\r\n109,其他货币资金,0.00,,0.00,0.00,0.00,\r\n111,短期投资,0.00,,0.00,0.00,0.00,\r\n  11101,债券投资,0.00,,0.00,0.00,0.00,\r\n112,应收票据,0.00,,0.00,0.00,0.00,\r\n  11201,银行承兑汇票,0.00,,0.00,0.00,0.00,\r\n    1120101,中船工业贸易公司,0.00,,0.00,0.00,0.00,\r\n113,应收帐款,\"5,378,448.13\",,\"27,803,015.89\",\"29,274,089.59\",\"3,907,374.43\",\r\n114,坏帐准备,\"-244,592.35\",,0.00,\"-1,690.47\",\"-242,901.88\",\r\n115,预付帐款,0.00,,0.00,0.00,0.00,\r\n119,其他应收款,\"762,052.88\",,\"1,838,645.80\",\"1,452,103.84\",\"1,148,594.84\",\r\n  11901,单位,\"764,211.77\",,\"949,468.94\",\"651,327.60\",\"1,062,353.11\",\r\n  11902,个人,\"-2,158.89\",,\"889,176.86\",\"800,776.24\",\"86,241.73\",\r\n121,材料采购,0.00,,0.00,0.00,0.00,\r\n123,原材料,\"2,429,520.26\",,\"8,981,127.14\",\"8,356,586.92\",\"3,054,060.48\",\r\n  12301,原材料一,\"267,760.77\",,\"292,200.64\",\"197,766.10\",\"362,195.31\",\r\n  12302,原材料二,\"94,213.51\",,\"737,111.55\",\"714,538.29\",\"116,786.77\",\r\n  12303,原材料三,\"56,212.95\",,\"136,788.67\",\"169,589.16\",\"23,412.46\",\r\n  12304,原材料四,\"472,936.21\",,\"1,667,805.94\",\"1,359,437.83\",\"781,304.32\",\r\n  12311,补助材料一,\"48,476.08\",,\"84,281.87\",\"86,105.18\",\"46,652.77\",\r\n  12312,补助材料二,\"4,675.10\",,\"70,024.70\",\"68,692.23\",\"6,007.57\",\r\n  12313,补助材料三,\"3,051.39\",,\"188,200.26\",\"182,625.83\",\"8,625.82\",\r\n  12314,补助材料四,\"5,675.27\",,\"47,291.77\",\"39,474.06\",\"13,492.98\",\r\n  12315,补助材料五,\"18,248.78\",,\"79,296.67\",\"70,443.75\",\"27,101.70\",\r\n  12316,补助材料六,\"52,135.91\",,\"492,228.21\",\"468,640.58\",\"75,723.54\",\r\n  12317,补助材料七,\"19,873.42\",,\"19,998.19\",\"19,230.39\",\"20,641.22\",\r\n  12318,补助材料八,\"86,252.27\",,\"104,187.70\",\"90,301.32\",\"100,138.65\",\r\n  12319,补助材料九,\"4,927.95\",,\"82,765.95\",\"67,702.64\",\"19,991.26\",\r\n  12320,补助材料十,\"5,434.67\",,\"179,377.71\",\"176,117.20\",\"8,695.18\",\r\n  12321,补助材料十一,\"370,908.97\",,\"2,027,177.99\",\"1,965,096.07\",\"432,990.89\",\r\n  12322,补助材料十二,0.00,,\"28,846.82\",\"27,973.90\",872.92,\r\n  12323,补助材料十三,\"114,918.21\",,\"383,258.38\",\"374,926.20\",\"123,250.39\",\r\n  12324,补助材料十四,\"150,105.88\",,\"1,427,092.97\",\"1,443,198.18\",\"134,000.67\",\r\n  12325,补助材料十五,\"29,929.34\",,\"244,931.97\",\"211,207.99\",\"63,653.32\",\r\n  12326,补助材料十六,\"572,354.80\",,\"351,490.09\",\"308,964.21\",\"614,880.68\",\r\n  12331,工具一,\"10,152.38\",,\"12,783.54\",\"11,171.53\",\"11,764.39\",\r\n  12332,工具二,\"7,997.93\",,\"16,832.64\",\"14,004.35\",\"10,826.22\",\r\n  12333,工具三,\"4,528.44\",,\"22,690.74\",\"20,488.52\",\"6,730.66\",\r\n  12334,工具四,\"14,278.07\",,\"29,975.95\",\"23,706.81\",\"20,547.21\",\r\n  12335,工具五,\"2,223.84\",,\"10,008.17\",\"9,206.57\",\"3,025.44\",\r\n  12336,工具六,\"7,071.70\",,\"29,192.41\",\"25,918.02\",\"10,346.09\",\r\n  12337,工具七,\"4,872.13\",,\"45,228.01\",\"40,076.85\",\"10,023.29\",\r\n  12341,燃料,304.29,,\"171,864.23\",\"171,436.22\",732.30,\r\n  12371,材料差价,0.00,,\"-1,806.60\",\"-1,453.06\",-353.54,\r\n128,包装物,0.00,,0.00,0.00,0.00,\r\n129,低值易耗品,0.00,,0.00,0.00,0.00,\r\n131,材料成本差异,0.00,,0.00,0.00,0.00,\r\n133,委托加工材料,0.00,,0.00,0.00,0.00,\r\n135,自制半成品,\"2,151,165.34\",,\"6,125,830.96\",\"7,774,384.36\",\"502,611.94\",\r\n  13501,生产科库,\"2,151,165.34\",,\"6,125,830.96\",\"7,774,384.36\",\"502,611.94\",\r\n137,产成品,\"400,669.58\",,\"21,642,319.55\",\"21,814,514.36\",\"228,474.77\",\r\n138,分期收款发出商品,0.00,,0.00,0.00,0.00,\r\n139,待摊费用,\"32,938.54\",,\"3,773.16\",\"36,127.09\",584.61,\r\n  13901,办公用品,0.00,,\"1,637.60\",\"1,052.99\",584.61,\r\n  13902,工具室,\"32,938.54\",,\"2,135.56\",\"35,074.10\",0.00,\r\n  13909,抵税户,0.00,,0.00,0.00,0.00,\r\n151,长期投资,0.00,,0.00,0.00,0.00,\r\n  15101,债券投资,0.00,,0.00,0.00,0.00,\r\n161,固定资产,\"31,342,716.05\",,\"674,511.69\",\"50,000.00\",\"31,967,227.74\",\r\n  16101,生产经营用,\"9,302,447.01\",,\"575,000.00\",\"50,000.00\",\"9,827,447.01\",\r\n  16102,非生产经营用,\"2,890,269.04\",,\"99,511.69\",0.00,\"2,989,780.73\",\r\n  16103,土地,\"19,150,000.00\",,0.00,0.00,\"19,150,000.00\",\r\n165,累计折旧,,\"8,265,828.22\",\"50,277.76\",\"498,345.04\",,\"8,713,895.50\"\r\n166,固定资产清理,0.00,,0.00,0.00,0.00,\r\n169,在建工程,0.00,,0.00,0.00,0.00,\r\n  16901,工程物资,0.00,,0.00,0.00,0.00,\r\n171,无形资产,0.00,,0.00,0.00,0.00,\r\n181,递延资产,0.00,,0.00,0.00,0.00,\r\n191,待处理财产损溢,0.00,,0.00,0.00,0.00,\r\n  19101,待处理流动资产损溢,0.00,,0.00,0.00,0.00,\r\n  19102,待处理固定资产损溢,0.00,,0.00,0.00,0.00,\r\n201,短期借款,,0.00,0.00,0.00,,0.00\r\n  20101,临时借款,,0.00,0.00,0.00,,0.00\r\n202,应付票据,,0.00,0.00,0.00,,0.00\r\n  20201,北京维梦贸易公司,,0.00,0.00,0.00,,0.00\r\n203,应付帐款,,\"4,506,240.23\",\"12,042,889.97\",\"13,755,640.49\",,\"6,218,990.75\"\r\n204,预收帐款,,0.00,0.00,0.00,,0.00\r\n209,其他应付款,,\"4,901,247.51\",\"818,414.53\",\"1,325,477.81\",,\"5,408,310.79\"\r\n211,应付工资,,\"1,331,225.01\",\"9,368,466.63\",\"9,228,801.12\",,\"1,191,559.50\"\r\n  21101,工资结余,,\"1,331,225.01\",\"4,753,961.07\",\"4,614,295.56\",,\"1,191,559.50\"\r\n  21102,应付工资明细,,0.00,\"4,614,505.56\",\"4,614,505.56\",,0.00\r\n    2110201,标准工资,,0.00,\"3,401,142.35\",\"3,401,142.35\",,0.00\r\n    2110202,价格补贴,,0.00,\"623,327.00\",\"623,327.00\",,0.00\r\n    2110203,加班工资,,0.00,\"32,593.41\",\"32,593.41\",,0.00\r\n    2110204,奖金,,0.00,\"489,458.00\",\"489,458.00\",,0.00\r\n    2110205,夜班费,,0.00,\"19,408.00\",\"19,408.00\",,0.00\r\n    2110206,房贴,,0.00,\"48,576.80\",\"48,576.80\",,0.00\r\n214,应付福利费,,\"-99,247.47\",\"1,204,430.12\",\"759,287.46\",,\"-544,390.13\"\r\n  21401,提取福利费,,\"-99,247.47\",0.00,\"646,001.38\",,\"546,753.91\"\r\n  21402,福利费开支,,0.00,\"1,204,430.12\",\"113,286.08\",,\"-1,091,144.04\"\r\n    2140201,开支医疗费,,0.00,\"532,627.24\",\"106,100.90\",,\"-426,526.34\"\r\n      214020101,购药,,0.00,\"305,977.63\",\"64,899.18\",,\"-241,078.45\"\r\n      214020102,职工医疗费,,0.00,\"194,908.47\",\"41,201.72\",,\"-153,706.75\"\r\n      214020103,子女医疗费,,0.00,\"19,368.29\",0.00,,\"-19,368.29\"\r\n      214020104,家属医疗费,,0.00,\"12,372.85\",0.00,,\"-12,372.85\"\r\n    2140202,福利补助开支,,0.00,\"671,802.88\",\"7,185.18\",,\"-664,617.70\"\r\n      214020201,补助,,0.00,\"111,979.68\",0.00,,\"-111,979.68\"\r\n      214020202,食堂,,0.00,100.00,0.00,,-100.00\r\n      214020203,托儿所,,0.00,\"10,080.50\",0.00,,\"-10,080.50\"\r\n      214020204,独生子女费,,0.00,0.00,0.00,,0.00\r\n      214020205,团员活动费,,0.00,0.00,0.00,,0.00\r\n      214020206,其他,,0.00,\"549,642.70\",\"7,185.18\",,\"-542,457.52\"\r\n221,应交税金,,\"615,262.71\",\"9,975,086.68\",\"9,660,691.98\",,\"300,868.01\"\r\n  22101,应交增值税,,\"418,892.89\",\"9,638,078.41\",\"9,317,029.40\",,\"97,843.88\"\r\n    2210101,年初未交,,0.00,0.00,0.00,,0.00\r\n    2210102,进项税额,,0.00,\"2,276,419.33\",\"2,276,419.33\",,0.00\r\n    2210103,销项税额,,0.00,\"4,658,514.70\",\"4,658,514.70\",,0.00\r\n    2210104,已交税金,,\"418,892.89\",\"2,703,144.38\",\"2,382,095.37\",,\"97,843.88\"\r\n    2210105,进项税额转出,,0.00,0.00,0.00,,0.00\r\n  22102,营业税,,\"4,728.50\",\"18,827.65\",\"12,256.65\",,\"-1,842.50\"\r\n  22103,城建税,,\"64,078.14\",\"202,264.51\",\"145,157.72\",,\"6,971.35\"\r\n  22104,房产税,,0.00,\"10,853.73\",\"10,853.73\",,0.00\r\n  22105,车船使用税,,0.00,0.00,0.00,,0.00\r\n  22106,土地使用税,,0.00,0.00,0.00,,0.00\r\n  22107,所得税,,\"127,563.18\",\"103,146.19\",\"173,478.29\",,\"197,895.28\"\r\n  22108,固资方向税,,0.00,0.00,0.00,,0.00\r\n  22109,印花税,,0.00,\"1,916.19\",\"1,916.19\",,0.00\r\n223,应付利润,,0.00,0.00,0.00,,0.00\r\n  22303,个人投资利润,,0.00,0.00,0.00,,0.00\r\n224,应付股利,,0.00,0.00,\"77,486.97\",,\"77,486.97\"\r\n229,其他应交款,,\"580,213.68\",\"281,522.91\",\"224,140.38\",,\"522,831.15\"\r\n  22901,教育费附加,,\"33,968.35\",\"100,363.07\",\"82,956.88\",,\"16,562.16\"\r\n  22902,防洪保安基金,,\"2,523.74\",\"122,672.77\",\"120,149.03\",,0.00\r\n  22903,大交通基金,,\"2,969.34\",0.00,0.00,,\"2,969.34\"\r\n  22904,粮食补贴基金,,\"15,120.00\",0.00,0.00,,\"15,120.00\"\r\n  22905,土地使用税,,\"200,315.50\",\"47,021.80\",\"9,569.20\",,\"162,862.90\"\r\n  22906,房产税,,\"229,237.75\",\"11,465.27\",\"11,465.27\",,\"229,237.75\"\r\n  22907,印花税,,\"11,931.00\",0.00,0.00,,\"11,931.00\"\r\n  22908,车船使用税,,920.00,0.00,0.00,,920.00\r\n  22909,土地使用费,,\"83,228.00\",0.00,0.00,,\"83,228.00\"\r\n231,预提费用,,0.00,0.00,0.00,,0.00\r\n  23101,租金,,0.00,0.00,0.00,,0.00\r\n233,待扣税金,,0.00,0.00,0.00,,0.00\r\n241,长期借款,,0.00,0.00,0.00,,0.00\r\n251,应付债券,,0.00,0.00,0.00,,0.00\r\n  25101,债券本金,,0.00,0.00,0.00,,0.00\r\n  25102,债券利息,,0.00,0.00,0.00,,0.00\r\n261,长期应付款,,0.00,0.00,0.00,,0.00\r\n265,专项应付款,,\"1,107,137.22\",\"3,000.00\",\"392,249.06\",,\"1,496,386.28\"\r\n  26501,科技拨款,,\"1,060,750.00\",0.00,\"380,000.00\",,\"1,440,750.00\"\r\n  26502,标准拨款,,\"29,454.79\",0.00,0.00,,\"29,454.79\"\r\n  26503,新品拨款,,\"6,649.69\",0.00,0.00,,\"6,649.69\"\r\n  26504,住房基金,,\"10,282.74\",\"3,000.00\",\"12,249.06\",,\"19,531.80\"\r\n301,实收资本,,\"4,566,000.00\",0.00,0.00,,\"4,566,000.00\"\r\n  30101,国家资本金,,0.00,0.00,0.00,,0.00\r\n  30102,法人资本金,,0.00,0.00,0.00,,0.00\r\n  30103,个人资本金,,\"4,566,000.00\",0.00,0.00,,\"4,566,000.00\"\r\n311,资本公积,,\"20,022,653.00\",0.00,\"48,372.09\",,\"20,071,025.09\"\r\n  31101,财产重估增值,,\"122,603.37\",0.00,0.00,,\"122,603.37\"\r\n  31102,住房委托代管,,\"673,140.94\",0.00,0.00,,\"673,140.94\"\r\n  31103,土地委托代管,,\"19,150,000.00\",0.00,0.00,,\"19,150,000.00\"\r\n  31104,所得税返还,,\"76,908.69\",0.00,0.00,,\"76,908.69\"\r\n  31105,其他资本公积,,0.00,0.00,\"48,372.09\",,\"48,372.09\"\r\n313,盈余公积,,\"300,104.60\",0.00,\"282,826.54\",,\"582,931.14\"\r\n  31301,公益金,,\"55,180.61\",0.00,\"43,321.35\",,\"98,501.96\"\r\n  31302,一般盈余公积,,\"37,680.61\",0.00,\"35,221.35\",,\"72,901.96\"\r\n  31303,任意盈余公积,,\"113,041.84\",0.00,\"204,283.84\",,\"317,325.68\"\r\n  31304,补充流动资金,,\"94,201.54\",0.00,0.00,,\"94,201.54\"\r\n321,本年利润,,0.00,\"55,701,350.62\",\"55,231,350.62\",,\"-470,000.00\"\r\n  32101,收入,,0.00,\"27,878,521.21\",\"27,878,521.21\",,0.00\r\n    3210101,产品销售收入,,0.00,\"27,281,884.00\",\"27,281,884.00\",,0.00\r\n    3210102,其他业务收入,,0.00,\"352,876.84\",\"352,876.84\",,0.00\r\n    3210103,营业外收入,,0.00,\"243,760.37\",\"243,760.37\",,0.00\r\n    3210104,投资收益,,0.00,0.00,0.00,,0.00\r\n    3210105,利润总额,,0.00,0.00,0.00,,0.00\r\n  32102,支出合计,,0.00,\"27,822,829.41\",\"27,352,829.41\",,\"-470,000.00\"\r\n    3210201,产品销售成本,,0.00,\"21,593,258.94\",\"21,593,258.94\",,0.00\r\n    3210202,管理费用,,0.00,\"5,043,212.66\",\"4,673,212.66\",,\"-370,000.00\"\r\n    3210203,财务费用,,0.00,\"-122,279.00\",\"-122,279.00\",,0.00\r\n    3210204,产品销售费用,,0.00,\"462,207.37\",\"462,207.37\",,0.00\r\n    3210205,产销税金及附加,,0.00,\"226,756.72\",\"226,756.72\",,0.00\r\n    3210206,其他业为支出,,0.00,\"427,498.96\",\"427,498.96\",,0.00\r\n    3210207,营业外支出,,0.00,\"192,173.76\",\"92,173.76\",,\"-100,000.00\"\r\n  32103,投资收益,,0.00,0.00,0.00,,0.00\r\n  32104,未分配利润,,0.00,0.00,0.00,,0.00\r\n  32105,上年利润调整,,0.00,0.00,0.00,,0.00\r\n322,利润分配,,0.00,\"1,051,383.60\",\"1,051,383.60\",,0.00\r\n  32201,应交所得税,,0.00,\"173,478.29\",\"173,478.29\",,0.00\r\n  32202,盈余公积补亏,,0.00,0.00,0.00,,0.00\r\n  32203,应交其他税,,0.00,0.00,0.00,,0.00\r\n  32204,提取盈余公积,,0.00,\"239,505.19\",\"239,505.19\",,0.00\r\n  32205,应付利润,,0.00,0.00,0.00,,0.00\r\n  32206,应交特种基金,,0.00,0.00,0.00,,0.00\r\n  32207,未分配利润,,0.00,\"525,691.80\",\"525,691.80\",,0.00\r\n  32208,应付股利,,0.00,\"77,486.97\",\"77,486.97\",,0.00\r\n  32209,补充流动资金,,0.00,0.00,0.00,,0.00\r\n  32210,公益金,,0.00,\"35,221.35\",\"35,221.35\",,0.00\r\n323,所得税,,0.00,0.00,0.00,,0.00\r\n401,生产成本,\"493,155.07\",,\"24,494,702.64\",\"24,567,112.18\",\"420,745.53\",\r\n  40101,原材料,\"493,155.07\",,\"16,161,996.09\",\"16,234,405.63\",\"420,745.53\",\r\n  40102,燃料,0.00,,\"117,021.67\",\"117,021.67\",0.00,\r\n  40103,动力,0.00,,\"323,485.66\",\"323,485.66\",0.00,\r\n  40104,工资及福利,0.00,,\"4,208,136.64\",\"4,208,136.64\",0.00,\r\n  40105,制造费用,0.00,,\"2,580,627.18\",\"2,580,627.18\",0.00,\r\n  40106,外加工,0.00,,\"1,103,435.40\",\"1,103,435.40\",0.00,\r\n405,制造费用,0.00,,\"2,587,396.29\",\"2,587,396.29\",0.00,\r\n  40501,工资,0.00,,\"107,435.00\",\"107,435.00\",0.00,\r\n  40502,福利费,0.00,,\"13,406.40\",\"13,406.40\",0.00,\r\n  40503,修理费,0.00,,\"205,329.96\",\"205,329.96\",0.00,\r\n  40504,折旧费,0.00,,\"299,346.32\",\"299,346.32\",0.00,\r\n  40505,办公费,0.00,,216.97,216.97,0.00,\r\n  40506,差旅费,0.00,,\"93,722.10\",\"93,722.10\",0.00,\r\n  40507,低耗品摊销,0.00,,\"157,392.36\",\"157,392.36\",0.00,\r\n  40508,劳动保护费,0.00,,\"362,639.57\",\"362,639.57\",0.00,\r\n  40509,运费,0.00,,\"80,305.50\",\"80,305.50\",0.00,\r\n  40510,其他,0.00,,\"693,775.46\",\"693,775.46\",0.00,\r\n  40511,劳动补助费,0.00,,\"229,055.00\",\"229,055.00\",0.00,\r\n  40512,水电费,0.00,,\"14,681.63\",\"14,681.63\",0.00,\r\n  40513,材料消耗,0.00,,\"330,090.02\",\"330,090.02\",0.00,\r\n501,产品销售收入,,0.00,\"27,321,884.00\",\"27,281,884.00\",,\"-40,000.00\"\r\n502,产品销售成本,0.00,,\"21,593,258.94\",\"21,623,258.94\",\"-30,000.00\",\r\n503,产品销售费用,0.00,,\"462,207.37\",\"462,207.37\",0.00,\r\n  50301,工资福利,0.00,,\"37,893.60\",\"37,893.60\",0.00,\r\n  50302,包装物,0.00,,\"159,960.12\",\"159,960.12\",0.00,\r\n  50303,技术转让费,0.00,,0.00,0.00,0.00,\r\n  50304,其他,0.00,,\"264,353.65\",\"264,353.65\",0.00,\r\n504,产品销售税金及附加,0.00,,\"226,756.72\",\"226,756.72\",0.00,\r\n511,其他业务收入,,0.00,\"352,876.84\",\"352,876.84\",,0.00\r\n  51101,材料销售,,0.00,\"68,759.89\",\"68,759.89\",,0.00\r\n  51102,废料销售,,0.00,\"1,336.88\",\"1,336.88\",,0.00\r\n  51103,固定资产出租,,0.00,\"231,733.00\",\"231,733.00\",,0.00\r\n  51104,运费包装物,,0.00,\"51,047.07\",\"51,047.07\",,0.00\r\n  51105,劳务收入,,0.00,0.00,0.00,,0.00\r\n512,其他业务支出,0.00,,\"427,498.96\",\"427,498.96\",0.00,\r\n  51201,材料成本,0.00,,\"40,165.44\",\"40,165.44\",0.00,\r\n  51202,废料成本,0.00,,0.00,0.00,0.00,\r\n  51203,固资出租成本,0.00,,\"13,614.53\",\"13,614.53\",0.00,\r\n  51204,运费船检及包装费,0.00,,\"373,718.99\",\"373,718.99\",0.00,\r\n521,管理费用,0.00,,\"5,062,107.62\",\"5,100,107.62\",\"-38,000.00\",\r\n  52101,工资,0.00,,\"857,125.00\",\"857,125.00\",0.00,\r\n  52102,福利费,0.00,,\"121,632.00\",\"121,632.00\",0.00,\r\n  52103,修理费,0.00,,\"212,411.02\",\"212,411.02\",0.00,\r\n  52104,折旧费,0.00,,\"168,153.23\",\"168,153.23\",0.00,\r\n  52105,办公费,0.00,,\"115,662.52\",\"115,662.52\",0.00,\r\n  52106,差旅费,0.00,,\"1,118,034.07\",\"1,118,034.07\",0.00,\r\n  52107,低耗品摊销,0.00,,\"68,285.69\",\"68,285.69\",0.00,\r\n  52108,劳动保护费,0.00,,\"87,599.23\",\"87,599.23\",0.00,\r\n  52109,运费,0.00,,\"15,502.68\",\"15,502.68\",0.00,\r\n  52110,其他,0.00,,\"771,266.08\",\"771,266.08\",0.00,\r\n  52111,劳动补助费,0.00,,0.00,0.00,0.00,\r\n  52112,业务招待费,0.00,,\"121,845.65\",\"121,845.65\",0.00,\r\n  52113,存货盘盈亏,0.00,,0.00,0.00,0.00,\r\n  52114,工会经费,0.00,,\"92,285.91\",\"92,285.91\",0.00,\r\n  52115,教育经费,0.00,,\"69,214.43\",\"69,214.43\",0.00,\r\n  52116,待业保险费,0.00,,\"87,457.16\",\"87,457.16\",0.00,\r\n  52117,船检费,0.00,,0.00,0.00,0.00,\r\n  52118,审计费,0.00,,0.00,0.00,0.00,\r\n  52119,诉讼费,0.00,,0.00,0.00,0.00,\r\n  52120,排污费,0.00,,0.00,0.00,0.00,\r\n  52121,绿化费,0.00,,0.00,0.00,0.00,\r\n  52122,税金,0.00,,\"12,769.92\",\"12,769.92\",0.00,\r\n  52123,坏账准备,0.00,,\"-1,690.47\",\"-1,690.47\",0.00,\r\n  52125,劳动保险费,0.00,,\"1,132,553.50\",\"1,132,553.50\",0.00,\r\n    5212501,退休金,0.00,,\"24,343.40\",\"24,343.40\",0.00,\r\n    5212502,医药费,0.00,,\"18,679.80\",\"18,679.80\",0.00,\r\n    5212503,补抚费,0.00,,\"6,000.00\",\"6,000.00\",0.00,\r\n    5212504,离休费,0.00,,0.00,0.00,0.00,\r\n    5212505,其他,0.00,,\"1,083,530.30\",\"1,083,530.30\",0.00,\r\n522,财务费用,0.00,,\"-117,478.15\",\"-117,478.15\",0.00,\r\n  52201,利息支出,0.00,,\"-117,478.15\",\"-117,478.15\",0.00,\r\n531,投资收益,,0.00,0.00,0.00,,0.00\r\n541,营业外收入,,0.00,\"396,044.26\",\"396,044.26\",,0.00\r\n  54101,固资盘盈净益,,0.00,277.76,277.76,,0.00\r\n  54102,罚款收入,,0.00,50.00,50.00,,0.00\r\n  54103,应付款收入,,0.00,\"2,258.09\",\"2,258.09\",,0.00\r\n  54104,其他,,0.00,\"72,787.88\",\"72,787.88\",,0.00\r\n  54105,军品免税收入,,0.00,\"320,670.53\",\"320,670.53\",,0.00\r\n542,营业外支出,0.00,,\"394,457.64\",\"356,457.64\",\"38,000.00\",\r\n  54201,固资盘亏净损,0.00,,0.00,0.00,0.00,\r\n  54202,赔偿违约金,0.00,,0.00,0.00,0.00,\r\n  54203,罚款支出,0.00,,\"59,000.00\",\"59,000.00\",0.00,\r\n  54204,其他,0.00,,\"335,457.64\",\"335,457.64\",0.00,\r\n";
        //var superData = $.csv.toArrays(allData);
        var tbData = [];
        //for (i = 0; i < superData.length; i++) {
        //    if (!superData[i][2]) {
        //        superData[i][2] = 0.00;
        //    }
        //    if (!superData[i][3]) {
        //        superData[i][3] = 0.00;
        //    }
        //    if (!superData[i][4]) {
        //        superData[i][4] = 0.00;
        //    }
        //    if (!superData[i][5]) {
        //        superData[i][5] = 0.00;
        //    }
        //    if (!superData[i][6]) {
        //        superData[i][6] = 0.00;
        //    }
        //    if (!superData[i][7]) {
        //        superData[i][7] = 0.00;
        //    }
        //    var record = {};
        //    record["id"] = i + 1;
        //    record["code"] = superData[i][0];
        //    record["name"] = superData[i][1];
        //    record["initdebit"] = superData[i][2];
        //    record["initcridet"] = superData[i][3];
        //    record["debit"] = superData[i][4];
        //    record["cridet"] = superData[i][5];
        //    record["lastdebit"] = superData[i][6];
        //    record["lastcridet"] = superData[i][7];

        //    tbData.push(record)
        //};
        //var test = new DevExpress.data.CustomStore({
        //    load: function (loadOptions) {

        //    }
        //});
        $scope.selectOptions = {
            dataSource: $scope.trialBalanceOptions,
            valueExpr: 'id',
            displayExpr: 'name',
            placeholder: 'column name'
        };
        var initGrid = function () {           
            var onRowPrepared = function (info) {
                if (info.rowType == 'header') {
                    //var row = '<tr class="dx-row dx-column-lines dx-header-row" role="row">'+
                    //    '<td></td><td><div dx-select-box="{dataSource: trialBalanceOptions,valueExpr: \'id\',displayExpr: \'name\',placeholder: \'Select a column name\'}"></div></td>' +
                    //    '<td><div dx-select-box="selectOptions"></div></td>'+
                    //    '<td><div dx-select-box="selectOptions"></div></td>'+
                    //     '<td><div dx-select-box="selectOptions"></div></td>'+
                    //    '<td><div dx-select-box="selectOptions"></div></td>'+
                    //     '<td><div dx-select-box="selectOptions"></div></td>'+
                    //    '<td><div dx-select-box="selectOptions"></div></td>'+
                    //     '<td><div dx-select-box="selectOptions"></div></td></tr>';

                    var row = $('<tr class="dx-row dx-column-lines dx-header-row" role="row"/>');
                    for (var i = 0; i < 9; i++) {
                        var td = $('<td/>');
                        if (i !== 0) {
                            $("<div/>").dxSelectBox($scope.selectOptions).appendTo(td);
                        }                        
                        td.appendTo(row);
                    }
                    info.rowElement.after(row);

                    //var row = $("#rowHeader").html();
                    //info.rowElement.before(row);
                }else if(info.rowType != 'header'&&(info.rowIndex%2))
                {
                    info.rowElement.addClass('dx-row-alt');
                }
                
            };
            var gridRow = $("#gridRow");           
            $scope.dataGridHeaderOptions = {
                showRowLines: true,
                rowAlternationEnabled: true,
                showBorders: true,
                dataSource: tbData,
                width:'100%',
                // rowTemplate: $("#gridRow"),
                onRowPrepared: onRowPrepared,
                columnAutoWidth: true,
                columns: [
                    { dataField: 'id',  caption: '', alignment: "left" },
                    { dataField: 'code', caption: '1', alignment: "left" },
                    { dataField: 'name', caption: '2', alignment: "left" },
                    { dataField: 'initdebit', caption: '3',  alignment: "left" },
                    { dataField: 'initcridet', caption: '4',  alignment: "left" },
                    { dataField: 'debit', caption: '5',  alignment: "left" },
                   { dataField: 'cridet', caption: '6',  alignment: "left" },
                   { dataField: 'lastdebit', caption: '7',  alignment: "left" },
                   { dataField: 'lastcridet', caption: '8',  alignment: "left" }

                ],              
                //loadPanel: {
                //    enabled: true
                //},
                scrolling: {
                    mode: "infinite"
                },
                sorting: {
                    mode: "none"
                }
                //columnChooser: {
                //    enabled: true,
                //    height: 150,
                //    width: 300,
                //    emptyPanelText: 'A place to hide the columns'
                //},
                //activeStateEnabled: true              
            };
        };
        (function () {
            $scope.showPanel = 2;            
            initGrid();
        })();
    }]);