機車物語

var workbook = new XLWorkbook();
var ws1 = workbook.Worksheets.Add("Separate PrintAreas");
ws1.PageSetup.PrintAreas.Add("A1:B2");
ws1.PageSetup.PrintAreas.Add("D3:D5");

Page Breaks

var ws2 = workbook.Worksheets.Add("Page Breaks");
ws2.PageSetup.PrintAreas.Add("A1:D5");
ws2.PageSetup.AddHorizontalPageBreak(2);
ws2.PageSetup.AddVerticalPageBreak(2);
workbook.SaveAs("PrintAreas.xlsx");

========================================

列印印表機設定

Page Tab Example 1

var workbook = new XLWorkbook();
var ws1 = workbook.Worksheets.Add("Page Setup - Page1");
ws1.PageSetup.PageOrientation = XLPageOrientation.Landscape;
ws1.PageSetup.AdjustTo(80);
ws1.PageSetup.PaperSize = XLPaperSize.LegalPaper;
ws1.PageSetup.VerticalDpi = 600;
ws1.PageSetup.HorizontalDpi = 600;

For more information on the paper size enumeration please see the Paper Size Lookup Table

Page Tab Example 2

var ws2 = workbook.Worksheets.Add("Page Setup - Page2");
ws2.PageSetup.PageOrientation = XLPageOrientation.Portrait;
ws2.PageSetup.FitToPages(2, 2); // Alternatively you can use 
// ws2.PageSetup.PagesTall = #
// and/or ws2.PageSetup.PagesWide = #
ws2.PageSetup.PaperSize = XLPaperSize.LetterPaper;
ws2.PageSetup.VerticalDpi = 600;
ws2.PageSetup.HorizontalDpi = 600;
ws2.PageSetup.FirstPageNumber = 5;
workbook.SaveAs("PageTab.xlsx");

(繼續閱讀...)

倧齊發表在痞客邦留言(2) 人氣(742)

個人分類：new 程式碼_Javascript(C#)

▲top

3月 15 週四 201815:06
[MS SQL]取得日期區間內預設工作日

/*取得日期區間內預設工作日*/
CREATE FUNCTION dbo.PL_getDefaultWorkingDays
(
   @StartDate DATE,
   @EndDate   DATE
)
RETURNS INT
AS
BEGIN
   RETURN
       (DATEDIFF(DAY, @StartDate, @EndDate) + 1)
       -(DATEDIFF(WEEK, @StartDate, @EndDate) * 2)
       -(CASE WHEN DATEPART(WEEKDAY, @StartDate) = 1 THEN 1 ELSE 0 END)
       -(CASE WHEN DATEPART(WEEKDAY, @EndDate) = 7 THEN 1 ELSE 0 END)
END
GO

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(572)

個人分類：new 程式碼_Javascript(SQL)

▲top

3月 09 週五 201813:33
[MS SQL]SQL Server 2012：EOMONTH 日期函數，傳回指定日期的當月最後一天

EOMONTH (Transact-SQL)
以選擇性位移，傳回包含指定日期的當月最後一天。
SQL Server 2012 版本新增加。

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(2)

個人分類：new 程式碼_Javascript(SQL)

▲top

3月 09 週五 201811:50
[MS SQL]依現有Table產生Temp Table

-------------------------------------------------------------------------------------------------------------------------------
使用方式
-------------------------------------------------------------------------------------------------------------------------------
/*
PL_setTempTable 'XX'
DROP TABLE #TEMP_XX
*/

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(73)

個人分類：new 程式碼_Javascript(SQL)

▲top

2月 09 週五 201822:21
[G漫][ぐじら]お義父さんのオンナになったボク(かわいい少年は好きですか？

http://gn00982591.pixnet.net/album/set/18271061

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(5,110)

個人分類：private void 十八禁(){}

▲top

2月 08 週四 201811:41
[IIS]Content Type 大全

.* = application/octet-stream
.001 = application/x-001
.301 = application/x-301
.323 = text/h323
.906 = application/x-906
.907 = drawing/907
.a11 = application/x-a11
.acp = audio/x-mei-aac
.ai = application/postscript
.aif = audio/aiff
.aifc = audio/aiff
.aiff = audio/aiff
.anv = application/x-anv
.asa = text/asa
.asf = video/x-ms-asf
.asp = text/asp
.asx = video/x-ms-asf
.au = audio/basic
.avi = video/avi
.awf = application/vnd.adobe.workflow
.biz = text/xml
.bmp = application/x-bmp
.bot = application/x-bot
.c4t = application/x-c4t
.c90 = application/x-c90
.cal = application/x-cals
.cat = application/vnd.ms-pki.seccat
.cdf = application/x-netcdf
.cdr = application/x-cdr
.cel = application/x-cel
.cer = application/x-x509-ca-cert
.cg4 = application/x-g4
.cgm = application/x-cgm
.cit = application/x-cit
.class = java/*
.cml = text/xml
.cmp = application/x-cmp
.cmx = application/x-cmx
.cot = application/x-cot
.crl = application/pkix-crl
.crt = application/x-x509-ca-cert
.csi = application/x-csi
.css = text/css
.cut = application/x-cut
.dbf = application/x-dbf
.dbm = application/x-dbm
.dbx = application/x-dbx
.dcd = text/xml
.dcx = application/x-dcx
.der = application/x-x509-ca-cert
.dgn = application/x-dgn
.dib = application/x-dib
.dll = application/x-msdownload
.doc = application/msword
.dot = application/msword
.drw = application/x-drw
.dtd = text/xml
.dwf = Model/vnd.dwf
.dwf = application/x-dwf
.dwg = application/x-dwg
.dxb = application/x-dxb
.dxf = application/x-dxf
.edn = application/vnd.adobe.edn
.emf = application/x-emf
.eml = message/rfc822
.ent = text/xml
.epi = application/x-epi
.eps = application/x-ps
.eps = application/postscript
.etd = application/x-ebx
.exe = application/x-msdownload
.fax = image/fax
.fdf = application/vnd.fdf
.fif = application/fractals
.fo = text/xml
.frm = application/x-frm
.g4 = application/x-g4
.gbr = application/x-gbr
.gcd = application/x-gcd
.gif = image/gif
.gl2 = application/x-gl2
.gp4 = application/x-gp4
.hgl = application/x-hgl
.hmr = application/x-hmr
.hpg = application/x-hpgl
.hpl = application/x-hpl
.hqx = application/mac-binhex40
.hrf = application/x-hrf
.hta = application/hta
.htc = text/x-component
.htm = text/html
.html = text/html
.htt = text/webviewhtml
.htx = text/html
.icb = application/x-icb
.ico = image/x-icon
.ico = application/x-ico
.iff = application/x-iff
.ig4 = application/x-g4
.igs = application/x-igs
.iii = application/x-iphone
.img = application/x-img
.ins = application/x-internet-signup
.isp = application/x-internet-signup
.IVF = video/x-ivf
.java = java/*
.jfif = image/jpeg
.jpe = image/jpeg
.jpe = application/x-jpe
.jpeg = image/jpeg
.jpg = image/jpeg
.jpg = application/x-jpg
.js = application/x-javascript
.jsp = text/html
.la1 = audio/x-liquid-file
.lar = application/x-laplayer-reg
.latex = application/x-latex
.lavs = audio/x-liquid-secure
.lbm = application/x-lbm
.lmsff = audio/x-la-lms
.ls = application/x-javascript
.ltr = application/x-ltr
.m1v = video/x-mpeg
.m2v = video/x-mpeg
.m3u = audio/mpegurl
.m4e = video/mpeg4
.mac = application/x-mac
.man = application/x-troff-man
.math = text/xml
.mdb = application/msaccess
.mdb = application/x-mdb
.mfp = application/x-shockwave-flash
.mht = message/rfc822
.mhtml = message/rfc822
.mi = application/x-mi
.mid = audio/mid
.midi = audio/mid
.mil = application/x-mil
.mml = text/xml
.mnd = audio/x-musicnet-download
.mns = audio/x-musicnet-stream
.mocha = application/x-javascript
.movie = video/x-sgi-movie
.mp1 = audio/mp1
.mp2 = audio/mp2
.mp2v = video/mpeg
.mp3 = audio/mp3
.mp4 = video/mpeg4
.mpa = video/x-mpg
.mpd = application/vnd.ms-project
.mpe = video/x-mpeg
.mpeg = video/mpg
.mpg = video/mpg
.mpga = audio/rn-mpeg
.mpp = application/vnd.ms-project
.mps = video/x-mpeg
.mpt = application/vnd.ms-project
.mpv = video/mpg
.mpv2 = video/mpeg
.mpw = application/vnd.ms-project
.mpx = application/vnd.ms-project
.mtx = text/xml
.mxp = application/x-mmxp
.net = image/pnetvue
.nrf = application/x-nrf
.nws = message/rfc822
.odc = text/x-ms-odc
.out = application/x-out
.p10 = application/pkcs10
.p12 = application/x-pkcs12
.p7b = application/x-pkcs7-certificates
.p7c = application/pkcs7-mime
.p7m = application/pkcs7-mime
.p7r = application/x-pkcs7-certreqresp
.p7s = application/pkcs7-signature
.pc5 = application/x-pc5
.pci = application/x-pci
.pcl = application/x-pcl
.pcx = application/x-pcx
.pdf = application/pdf
.pdf = application/pdf
.pdx = application/vnd.adobe.pdx
.pfx = application/x-pkcs12
.pgl = application/x-pgl
.pic = application/x-pic
.pko = application/vnd.ms-pki.pko
.pl = application/x-perl
.plg = text/html
.pls = audio/scpls
.plt = application/x-plt
.png = image/png
.png = application/x-png
.pot = application/vnd.ms-powerpoint
.ppa = application/vnd.ms-powerpoint
.ppm = application/x-ppm
.pps = application/vnd.ms-powerpoint
.ppt = application/vnd.ms-powerpoint
.ppt = application/x-ppt
.pr = application/x-pr
.prf = application/pics-rules
.prn = application/x-prn
.prt = application/x-prt
.ps = application/x-ps
.ps = application/postscript
.ptn = application/x-ptn
.pwz = application/vnd.ms-powerpoint
.r3t = text/vnd.rn-realtext3d
.ra = audio/vnd.rn-realaudio
.ram = audio/x-pn-realaudio
.ras = application/x-ras
.rat = application/rat-file
.rdf = text/xml
.rec = application/vnd.rn-recording
.red = application/x-red
.rgb = application/x-rgb
.rjs = application/vnd.rn-realsystem-rjs
.rjt = application/vnd.rn-realsystem-rjt
.rlc = application/x-rlc
.rle = application/x-rle
.rm = application/vnd.rn-realmedia
.rmf = application/vnd.adobe.rmf
.rmi = audio/mid
.rmj = application/vnd.rn-realsystem-rmj
.rmm = audio/x-pn-realaudio
.rmp = application/vnd.rn-rn_music_package
.rms = application/vnd.rn-realmedia-secure
.rmvb = application/vnd.rn-realmedia-vbr
.rmx = application/vnd.rn-realsystem-rmx
.rnx = application/vnd.rn-realplayer
.rp = image/vnd.rn-realpix
.rpm = audio/x-pn-realaudio-plugin
.rsml = application/vnd.rn-rsml
.rt = text/vnd.rn-realtext
.rtf = application/msword
.rtf = application/x-rtf
.rv = video/vnd.rn-realvideo
.sam = application/x-sam
.sat = application/x-sat
.sdp = application/sdp
.sdw = application/x-sdw
.sit = application/x-stuffit
.slb = application/x-slb
.sld = application/x-sld
.slk = drawing/x-slk
.smi = application/smil
.smil = application/smil
.smk = application/x-smk
.snd = audio/basic
.sol = text/plain
.sor = text/plain
.spc = application/x-pkcs7-certificates
.spl = application/futuresplash
.spp = text/xml
.ssm = application/streamingmedia
.sst = application/vnd.ms-pki.certstore
.stl = application/vnd.ms-pki.stl
.stm = text/html
.sty = application/x-sty
.svg = text/xml
.swf = application/x-shockwave-flash
.tdf = application/x-tdf
.tg4 = application/x-tg4
.tga = application/x-tga
.tif = image/tiff
.tif = application/x-tif
.tiff = image/tiff
.tld = text/xml
.top = drawing/x-top
.torrent = application/x-bittorrent
.tsd = text/xml
.txt = text/plain
.uin = application/x-icq
.uls = text/iuls
.vcf = text/x-vcard
.vda = application/x-vda
.vdx = application/vnd.visio
.vml = text/xml
.vpg = application/x-vpeg005
.vsd = application/vnd.visio
.vsd = application/x-vsd
.vss = application/vnd.visio
.vst = application/vnd.visio
.vst = application/x-vst
.vsw = application/vnd.visio
.vsx = application/vnd.visio
.vtx = application/vnd.visio
.vxml = text/xml
.wav = audio/wav
.wax = audio/x-ms-wax
.wb1 = application/x-wb1
.wb2 = application/x-wb2
.wb3 = application/x-wb3
.wbmp = image/vnd.wap.wbmp
.wiz = application/msword
.wk3 = application/x-wk3
.wk4 = application/x-wk4
.wkq = application/x-wkq
.wks = application/x-wks
.wm = video/x-ms-wm
.wma = audio/x-ms-wma
.wmd = application/x-ms-wmd
.wmf = application/x-wmf
.wml = text/vnd.wap.wml
.wmv = video/x-ms-wmv
.wmx = video/x-ms-wmx
.wmz = application/x-ms-wmz
.wp6 = application/x-wp6
.wpd = application/x-wpd
.wpg = application/x-wpg
.wpl = application/vnd.ms-wpl
.wq1 = application/x-wq1
.wr1 = application/x-wr1
.wri = application/x-wri
.wrk = application/x-wrk
.ws = application/x-ws
.ws2 = application/x-ws
.wsc = text/scriptlet
.wsdl = text/xml
.wvx = video/x-ms-wvx
.xdp = application/vnd.adobe.xdp
.xdr = text/xml
.xfd = application/vnd.adobe.xfd
.xfdf = application/vnd.adobe.xfdf
.xhtml = text/html
.xls = application/vnd.ms-excel
.xls = application/x-xls
.xlw = application/x-xlw
.xml = text/xml
.xpl = audio/scpls
.xq = text/xml
.xql = text/xml
.xquery = text/xml
.xsd = text/xml
.xsl = text/xml
.xslt = text/xml
.xwd = application/x-xwd
.x_b = application/x-x_b
.x_t = application/x-x_t

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(32)

個人分類：new 程式碼_Javascript(IIS)

▲top

2月 08 週四 201811:39
[HTML]特殊符號編碼對照表

特殊符号
命名实体
十进制编码
特殊符号
命名实体
十进制编码
特殊符号
命名实体
十进制编码

Α
Α
Α
Β
Β
Β
Γ
Γ
Γ

Δ
Δ
Δ
Ε
Ε
Ε
Ζ
Ζ
Ζ

Η
Η
Η
Θ
Θ
Θ
Ι
Ι
Ι

Κ
Κ
Κ
Λ
Λ
Λ
Μ
Μ
Μ

Ν
Ν
Ν
Ξ
Ξ
Ξ
Ο
Ο
Ο

Π
Π
Π
Ρ
Ρ
Ρ
Σ
Σ
Σ

Τ
Τ
Τ
Υ
Υ
Υ
Φ
Φ
Φ

Χ
Χ
Χ
Ψ
Ψ
Ψ
Ω
Ω
Ω

α
α
α
β
β
β
γ
γ
γ

δ
δ
δ
ε
ε
ε
ζ
ζ
ζ

η
η
η
θ
θ
θ
ι
ι
ι

κ
κ
κ
λ
λ
λ
μ
μ
μ

ν
ν
ν
ξ
ξ
ξ
ο
ο
ο

π
π
π
ρ
ρ
ρ
ς
&sigmaf;
ς

σ
σ
σ
τ
τ
τ
υ
υ
υ

φ
φ
φ
χ
χ
χ
ψ
ψ
ψ

ω
ω
ω
ϑ
&thetasym;
ϑ
ϒ
&upsih;
ϒ

ϖ
ϖ
ϖ
•
•
•
…
…
…

′
′
′
″
″
″
‾
&oline;
‾

⁄
&frasl;
⁄
℘
&weierp;
℘
ℑ
&image;
ℑ

ℜ
&real;
ℜ
™
™
™
ℵ
&alefsym;
ℵ

←
←
←
↑
↑
↑
→
→
→

↓
↓
↓
↔
↔
↔
↵
&crarr;
↵

⇐
⇐
⇐
⇑
&uArr;
⇑
⇒
⇒
⇒

⇓
&dArr;
⇓
⇔
⇔
⇔
∀
∀
∀

∂
∂
∂
∃
∃
∃
∅
∅
∅

∇
∇
∇
∈
∈
∈
∉
∉
∉

∋
&ni;
∋
∏
∏
∏
∑
∑
−

−
−
−
∗
&lowast;
∗
√
√
√

∝
&prop;
∝
∞
∞
∞
∠
&ang;
∠

∧
&and;
⊥
∨
&or;
⊦
∩
∩
∩

∪
∪
∪
∫
∫
∫
∴
&there4;
∴

∼
&sim;
∼
≅
&cong;
≅
≈
≈
≅

≠
≠
≠
≡
&equiv;
≡
≤
≤
≤

≥
≥
≥
⊂
⊂
⊂
⊃
⊃
⊃

⊄
&nsub;
⊄
⊆
&sube;
⊆
⊇
&supe;
⊇

⊕
&oplus;
⊕
⊗
&otimes;
⊗
⊥
&perp;
⊥

⋅
⋅
⋅
⌈
&lceil;
⌈
⌉
&rceil;
⌉

⌊
&lfloor;
⌊
⌋
&rfloor;
⌋
◊
&loz;
◊

♠
&spades;
♠
♣
&clubs;
♣
♥
&hearts;
♥

♦
&diams;
♦

 
 
¡
¡
¡

¢
¢
¢
£
£
£
¤
¤
¤

¥
¥
¥
¦
¦
¦
§
§
§

¨
¨
¨
©
©
©
ª
ª
ª

«
«
«
¬
¬
¬




®
®
®
¯
¯
¯
°
°
°

±
±
±
²
²
²
³
³
³

´
´
´
µ
µ
&#181
"
"
"

<
<
<
>
>
>
'

'

(繼續閱讀...)

倧齊發表在痞客邦留言(0) 人氣(217)

個人分類：new 程式碼_Javascript(HTML)

▲top

var tempValue = 到底要不要說真話 ? 是 : 否 ;
List<興趣> tempList =new List<興趣>();
tempList.add(new 興趣(很多));
tempList.add(new 興趣(超級多));
想加好友的就自已提出申請吧！
但那個時候會過…看心情。

[MS SQL]新增角色並添加執行權限

[Server]啟用開放分散式交易協調器( MSDTC 服務)

回來看看

[C#]CloseXML列印設定

Page Tab Example 1

Page Tab Example 2

[MS SQL]取得日期區間內預設工作日

[MS SQL]SQL Server 2012：EOMONTH 日期函數，傳回指定日期的當月最後一天

[MS SQL]依現有Table產生Temp Table

[G漫][ぐじら]お義父さんのオンナになったボク(かわいい少年は好きですか？

[IIS]Content Type 大全

[HTML]特殊符號編碼對照表

var 倧齊 = new Values();

文章精選

熱門文章

文章分類

祈求平順的生活 (2)

裏技 (1)

頭腦的過度運作 (14)

圈內的心酸 (3)

Counter

參觀人氣

最新文章

動態訂閱

GoogleCodePrettify

var tempValue = 到底要不要說真話 ? 是 : 否 ; List<興趣> tempList =new List<興趣>(); tempList.add(new 興趣(很多)); tempList.add(new 興趣(超級多)); 想加好友的就自已提出申請吧！ 但那個時候會過…看心情。

Page Tab Example 1

Page Tab Example 2

var 倧齊 = new Values();

文章精選

熱門文章

文章分類

祈求平順的生活 (2)

裏技 (1)

頭腦的過度運作 (14)

圈內的心酸 (3)

Counter

參觀人氣

最新文章

動態訂閱

GoogleCodePrettify

var tempValue = 到底要不要說真話 ? 是 : 否 ;
List<興趣> tempList =new List<興趣>();
tempList.add(new 興趣(很多));
tempList.add(new 興趣(超級多));
想加好友的就自已提出申請吧！
但那個時候會過…看心情。