Browse by Tags

CSV 轉換利器－ServiceStack.Text

做專案免不了遇到匯出或讀取 CSV 的需求，將物件轉成逗號分隔字串看似小菜一碟，用 C# 串字串也能搞定，但魔鬼在細節裡：字串值如包含逗號就要用雙引號包夾，遇到雙引號要置換成兩個雙引號，如果字串內容有換行符號更是讀取識別時的一大挑戰… 不管是匯出或解析 CSV 都得費不少力氣。最近發現一個處理 CSV 的強大元件－ServiceStack.Text 的 CsvSerializer！ ServiceStack 是一套用於快速打造 SOA 服務的 Framework 工具組（可取代 WCF、WebAPI...

Posted 13 May 2017 09:27 AM 由 Jeffrey | with no comments 16,381

Filed under: Tools, .NET

HTML轉PDF - 使用Pechkin套件

剛好跟人討論到HTML轉PDF需求，便對工具進行簡單評估以備不時之需。 網路上比較多人推的是 WkHtmlToPdf ，如果是用.NET開發，已經有人包成NuGet套件，直接搜尋pechkin就可找到，它有兩個版本: Pechkin適用單執行緒，如要非同步執行請選用Pechkin.Synchronized。 安裝NuGet套件後，相關Unmanage DLL也會一併下載並加入專案，不用額外安裝HkHtmlToPdf就可開始寫程式，十分方便。但由於Unmanaged部分為32位元，記得要將專案目標平台切成x86...

Posted 07 July 2013 08:11 AM 由 Jeffrey | 4 comment(s) 33,017

Filed under: Tools, .NET

小試SmartAssembly .NET混淆器

可輕易反組譯是採用中介語言(.NET, Java)平台的共有特性，也是實務應用的資安隱憂，面對這個問題，最有效的解決方案是 -- 混淆器( Obfuscator )。 混淆器的運作原因，是解析編譯好的DLL或EXE檔，將其轉換成執行結果相同的組件，差別在於私有類別、屬性、方法、欄位、參數名稱都已改到面目全非，難以閱讀理解；更進一步還可以打亂程式碼的排列流程(執行順序不變)、加密程式碼中的字串常數，讓反組譯的程式碼亂如咒語天書，令有意破解者卻步，至少要讓對方追程式追到流涕痛哭。天下沒有破解不了的程式...

Posted 05 April 2013 08:52 AM 由 Jeffrey | 2 comment(s) 26,569

Filed under: Tools, .NET

TOOL-Converting JSON DateTime String to .NET DateTime Structure

[Abstract] Sample code for converting "\/Date(1270051200000)\/" JSON format to .NET DateTime structure, it is used to convert log files with JSON-serialized data to make the date information readable. 專案裡有個Log機制會以JSON格式保存呼叫歷程中的參數物件，以便事後偵錯及追蹤之用...

Posted 29 November 2011 10:21 PM 由 Jeffrey | with no comments 6,440

Filed under: Tools, Javascript, .NET

Mini C# Lab 1.4 Release

The primary new feature of Ver 1.4 is batch mode ! Now you can run Mini C# Lab program as a scheduled task, no UI interactivity is needed. Here are some batch argument examples: Load and execute x:\temp\test.cs, use the output to overwrie x:\temp\log...

Posted 05 March 2010 09:30 PM 由 Jeffrey | 6 comment(s) 13,483

Filed under: Tools, .NET, English

TOOLS-IDbCommand.Parameters抓漏工具

不知天生粗枝大葉還是怎樣，每回只要操作大量欄位Table的新增修改，我總會迷失在茫茫的Parameter大海中...(這也解釋了為什麼我愛死了 LINQ to SQL / LINQ to Oracle ) 複雜的資料表有三四十個欄位是家常便飯，CommandText就得宣告三四十個參數名稱，然後照著這堆參數名稱一一Parameters.Add，只要名稱打錯或多一個少一個，就會冒出"ORA-01036 illegal variable name/number 變數名稱/號碼無效"之類的錯誤...

Posted 10 November 2009 09:54 AM 由 Jeffrey | 2 comment(s) 12,175

Filed under: Tools, .NET

測試DTC設定-使用Mini C# Lab

每次安裝Web測試環境的一項重要檢查工作，是要確認Web與SQL間的DTC連線暢通，在經驗裡這是件眉眉角角很多的任務，光從我過去針對它 寫過的KB、文章 數量就可見一斑。 測試DTC通不通的方法，除了直接執行引用DTC的程式之外，還可以用MS的DTCPing工具。不過，這次介紹如何使用我寫的小工具 Mini C# Lab 來測試DTC。 測試原理請大家參考" .NET 分散式交易程式開發FAQ (PDF)"一文，用Mini C# Lab跑以下的小程式，在TransactionScope中對SQL建立兩條連線會觸發使用DTC...

Posted 22 February 2009 09:17 AM 由 Jeffrey | 7 comment(s) 18,428

Filed under: Tips, Tools, .NET

Mini C# Lab ver 1.3 Release Note

After Mini C# Lab ver 1.2, I got several important feedbacks from community, a friend, elleryq, told me that there is a free software Snippet Compiler providing colorful formatting, line number, document outlining, method list dropdown, even Intellisence...

Posted 11 July 2008 07:23 AM 由 Jeffrey | 30 comment(s) 98,109

Filed under: Tools, .NET, English

Mini C# Lab ver 1.2 supports VB.NET now

After Mini C# Lab 1.1 was released, the most frequently asked quesitons are: 1) Could it support VB.NET? 2) Where is the source code? Now, here comes Mini C# Lab ver 1.2 and some wishful features are added. First, it supports VB.NET now! Yes, **VB.NET...

Posted 04 June 2008 07:20 AM 由 Jeffrey | 10 comment(s) 22,184

Filed under: Tools, 潛盾機, .NET, English

Mini C# Lab Ver 1.1

After Mini C# Lab 1.0 was released, I got good suggestions from friends. I agree that these improvements can make Mini C# Lab handier, so I add some useful features to it, then the Mini C# Lab ver 1.1 is coming... New features: The *TERRIBLE* Ctrl-X shortcut...

Posted 30 May 2008 01:31 AM 由 Jeffrey | 5 comment(s) 16,539

Filed under: Tools, 潛盾機, .NET, English

TOOLS-Mini C# Lab Ver 1.0

Did this ever occur to you? You wanted to write several lines of C# code to clarify some syntax or parameter format, or you needed a one-time program to process log files. You started Visual Studio 2005/2008, created a new console application project...

Posted 27 May 2008 02:56 PM 由 Jeffrey | 15 comment(s) 23,729

Filed under: Tools, .NET, English

XML Notepad Improvement

XML Notepad is good but it just doesn't fit my need... Updated @ 2008-12-06: XML Notepad 2.5 already supports getting XML data from clipboard, thank Ah Phu. I wrote a workflow system and it stores the form context and flow context in XML format. While...

Posted 24 October 2007 09:01 PM 由 Jeffrey | 4 comment(s) 27,560

Filed under: Tools, .NET

搜尋