Skip to content

Instantly share code, notes, and snippets.

using System;
using System.Collections.Generic;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.IO;
using System.Linq;
using NPOI.XSSF.Streaming;
namespace BigGridTest
{
#set-option -gw xterm-keys on
bind-key -n C-t new-window
bind-key -n C-w kill-window
bind-key -n C-Right next-window
bind-key -n C-Left previous-window
set -g default-terminal "screen-256color"
@tony1223
tony1223 / Readme.txt
Created June 8, 2018 06:59 — forked from jcward/Readme.txt
Generating iOS P12 / certs without Mac OSX Keychain (on linux, windows, etc)
1) Generate a private key and certificate signing request:
openssl genrsa -out ios_distribution.key 2048
openssl req -new -key ios_distribution.key -out ios_distribution.csr -subj '/[email protected], CN=Example, C=US'
2) Upload CSR to apple at: https://developer.apple.com/account/ios/certificate/create
- choose Production -> App Store and Ad Hoc
3) Download the resulting ios_distribution.cer, and convert it to .pem format:
MD:嘉義縣,台灣燈會在嘉義 1 四腳獸 https://www.ingress.com/intel?ll=23.467882,120.294114&z=19&pll=23.468415,120.294232 23.468415,120.294232
MD:嘉義縣,田園減碳的足跡 1 和園 https://www.ingress.com/intel?ll=23.479485,120.298787&z=17&pll=23.481008,120.29888 23.481008,120.29888
MD:嘉義縣,日式洋風的記憶 1 北歐工坊小矮人 https://www.ingress.com/intel?ll=23.470815,120.255723&z=17&pll=23.469983,120.256438 23.469983,120.256438
MD:嘉義縣,甜瞻鐵道的奔馳 1 俊與婆 https://www.ingress.com/intel?ll=23.459308,120.322525&z=18&pll=23.458713,120.32264 23.458713,120.32264
MD:嘉義縣,伴著媽祖的翱翔 1 港口宮 https://www.ingress.com/intel?ll=23.463409,120.212119&z=17&pll=23.462633,120.212142 23.462633,120.212142
MD:嘉義縣,大航海王的秘寶 1 自己人 龍圖騰 https://www.ingress.com/intel?ll=23.450613,120.131786&z=17&pll=23.450554,120.134356 23.450554,120.134356
MD:嘉義縣,南藍海風的能量 1 水中貓 https://www.ingress.com/intel?ll=23.33798,120.138618&z=18&pll=23.337936,120.138635 23.337936,120.138635
MD:嘉義縣,媽祖娘娘的祝福 1 新港瓦片藝術堤防 https://www.ingress.com/intel?ll=23.570952,120.313292&z=17&pll=23.570548,120.313924 23.570548,120.313924
MD:嘉義縣,得
=== 靠近燈區的旅館
@ 樺舍(就在燈區內,約2000上下 )
http://www.huashe-hotel.com.tw/web/huashe-hotel/-/2018-01-04-?inheritRedirect=true&redirect=%2Fweb%2Fhuashe-hotel%2Fhotel_Chiayi
@ 山海大飯店(約2000上下、算靠近朴子)
http://www.bbnet.com.tw/skk/reserve/?fromid=1
@美儷閣商務汽車旅館
@向日葵汽車旅館
[{"ref_1":"10","ref_2":"000","ref_3":"01","ref_4":"01","amount":173720000,"last_amount":163241000,"comment":"一、本科目包括行政管理\n二、本年度預算數包括:\n  人事費154,656千元\n  業務費18,939千元\n  獎補助費210千元\n三、本年度預算數與上年度比較:\n  增加 85千元\n  減列 人事費1,097千元\n  增列 業務費1,734千元\n  減列 獎補助費552千元\n四、本科目增減項目如下:\n1.增列退休離職儲金22千元。\n2.減列法定編制人員待遇48千元、技工及工友待遇624千元、獎金238千元、其他給與96千元、加班費73千元、保險費40千元。\n3.減列物品171千元。\n4.減列一般事務費61千元。\n5.減列保險費7千元。\n6.增列通訊費1,821千元。\n7.增列臨時人員酬金144千元。\n8.增列車輛及辦公器具養護費8千元。\n9.減列獎勵及慰問552千元。\n","year":2018,"code":"34141410101","topname":"財政稅務局主管","depname":"財政稅務局主管","category":"一般行政","name":"行政管理","cat":"財政稅務局主管","depcat":"一般行政"},{"ref_1":"10","ref_2":"000","ref_3":"02","ref_4":"01","amount":1912000,"last_amount":1446000,"comment":"一、本科目包括財務收支管理\n二、本年度預算數包括:\n  人事費300千元\n  業務費1,636千元\n三、本年度預算數與上年度比較:\n  增加 24千元\n  增列 業務費24千元\n四、本科目增減項目如下:\n1.增列臨時人員酬金36千元。\n2.減列物品12千元。\n","year":2018,"code":"34141411201","topname":"財政稅務局主管","depname":"財政稅務局主管","category":"財政及公產業務","name":"財務收支管理","cat":"財政稅務局主管","depcat":"財政及公產業務"},{"ref_1":"10","ref_2":"0
[{"ref_1":"01","ref_2":"001","ref_3":"01","ref_4":"01","amount":52403000,"last_amount":54079000,"comment":"一、本年度預算數包括:\n  人事費32,684,000元\n  業務費19,629,000元\n  獎補助費90,000元\n二、本年度預算數與上年度比較:\n  減少 1,676,000元\n  增列 人事費272,000元\n  減列 業務費1,948,000元\n","year":2017,"code":"31011010101","topname":"縣議會主管","depname":"澎湖縣議會","category":"一般行政","name":"行政管理","cat":"縣議會主管","depcat":"一般行政"},{"ref_1":"01","ref_2":"001","ref_3":"01","ref_4":"02","amount":462000,"last_amount":485000,"comment":"一、本年度預算數包括:\n  業務費462,000元\n二、本年度預算數與上年度比較:\n  減少 23,000元\n  減列 業務費23,000元\n","year":2017,"code":"31011010102","topname":"縣議會主管","depname":"澎湖縣議會","category":"一般行政","name":"車輛維護","cat":"縣議會主管","depcat":"一般行政"},{"ref_1":"01","ref_2":"001","ref_3":"01","ref_4":"03","amount":17502000,"last_amount":16329000,"comment":"一、本年度預算數包括:\n  業務費17,502,000元\n二、本年度預算數與上年度比較:\n  增加 1,173,000元\n  增列 業務費1,173,000元\n","year":2017,"code":"31011010103","topname":"縣議會主管","depname":"澎湖縣議會","category":"一般行政","name":"財產保養","cat":"縣議會主管","depcat":"一般行政"},{"ref_1":"
[{"year":"2018","code":"150101","amount":310861555,"last_amount":207646077,"ref_1":"1","topname":"市議會主管","ref_2":"1","depname":"市議會","ref_3":"1","category":"一般行政","ref_4":"1","name":"行政管理","comment":"本年度預算數之內容與上年度之比較如下:1.人事費 212,683,626元,較上年度增列 84,454,861元,主要係配合預算員額移列整合各計畫覈實編列及依勞基法第56條規定提撥駕駛、技工、工友等退休退職準備金之不足。2.臨時工工資及其退休準備金由經常議事工作改列本工作計畫覈實編列 16,902,665元。3.新增第13屆議員就職活動等 2,170,000元。新增冰水主機設備維護費及議場服務人員、駐衛警夏季制服 531,000元。4.其他合共 78,574,264元,較上年度減列 843,048元。","ref":"1.1.1.1","cat":"市議會主管","depcat":"一般行政"},{"year":"2018","code":"150201","amount":52941710,"last_amount":53708510,"ref_1":"1","topname":"市議會主管","ref_2":"1","depname":"市議會","ref_3":"2","category":"議事業務","ref_4":"1","name":"大會議事工作","comment":"本年度預算數之內容與上年度之比較如下:1.寄發協調會開會通知郵資及代書酬酢品工資等 1,800,000元,較上年度減列 766,800元。2.其他合共 51,141,710元,較上年度無增減。","ref":"1.1.2.1","cat":"市議會主管","depcat":"議事業務"},{"year":"2018","code":"150202","amount":393450696,"last_amount":441617329,"ref_1":"1","topname":"市議會主管","ref_2":"1","depname":"市議會","ref_3":"2","category":"議事業務","ref_4":"2","nam
--postgres
SELECT concat('table.',data_type,'("',column_name,'");') FROM information_schema.columns WHERE
table_name = 'light_report' ;