Row and Column Hover Highlight

Microsoft ASP.NET AJAX UpdatePanel

	//pageLoad is executed after every postback, synchronous or asynchronous.
	//pageLoad is a reserved function name in ASP.NET AJAX that is for this purpose.
	function pageLoad(sender, args) {
	alert('Ajaxed');
	}
	// beginRequest 事件會在非同步回傳的處理開始之前，以及回傳傳送到伺服器之前引發。
	Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequestHandler);
	function BeginRequestHandler(sender, args) {
	alert('Request Begin');
	console.log(args.get_postBackElement()) //觸發元件
	}
	//在完成非同步回傳，並將控制項傳回到瀏覽器之後，便會引發 endRequest 事件。
	Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
	function EndRequestHandler() {
	alert('Request End');
	}

view raw gistfile1.js hosted with ❤ by GitHub

---

PageRequestManager 事件 ASP.NET AJAX > Overview > ASP.NET AJAX Client Life-Cycle Events asp.net ajax - How to have a javascript callback executed after an update panel postback? - Stack Overflow

日期距離計算

Overtime Pay

M Comes

PPI (Pixels Per Inch) 計算器

MediaScannerService wakelocks

問題：SD卡裡面有壞掉的圖檔，導致系統一直重讀，而lock住。
解法：

1. 刪除壞掉圖檔
2. 設定 -> 應用程式 -> 全部 -> 媒體儲存空間
3. 清除資料、清除快取
4. 重新開機

---

[心得分享]解決圖片庫造成的android.process.media一直強佔CPU使用率100%的問題 MediaScannerService wakelocks Media Scanner Service is an annoying little *BLEEP*

BetterBatteryStats (Root)

1. 安裝BetterBatteryStats
2. 設定Advanced -> Root features打勾
3. 放電1-4小時
4. 觀察Partial Wakelocks，找出耗電app

---

[APP][2.1+] BetterBatteryStats [某魚]找出耗電原因補充之補完 - 詳解 BetterBatteryStats

Parameter組合SQL WHERE IN

	Dim sb As New StringBuilder
	Dim strTmp As String = String.Empty
	For i As Integer = 0 To aryDeptID.Length - 1
	strTmp = strTmp + "@param" + i.ToString + ","
	Next
	sb.AppendLine(" SELECT AccountID ")
	sb.AppendLine(" FROM tb_Members ")
	sb.AppendLine(" WHERE DeptID IN (")
	sb.Append(strTmp.TrimEnd(","))
	sb.Append(")")
	cmd = dbConn.GetSqlStringCommand(sb.ToString)
	For i As Integer = 0 To aryDeptID.Length - 1
	dbConn.AddInParameter(cmd, "@param" + i.ToString, DbType.String, aryDeptID(i))
	Next
	dtDeptAcc = dbConn.ExecuteDataSet(cmd).Tables(0)

view raw gistfile1.vb hosted with ❤ by GitHub

---

解決ASP.NET的SqlCommand,利用SqlParameter來下SQL指令"Where In"的問題 - F6 Team- 點部落

Clear Input File Element

var uploadEle =$('#Uploader');
uploadEle.replaceWith(uploadEle = uploadEle.clone(true));

---

html - Clearing <input type='file' /> using jQuery - Stack Overflow javascript - Clearing file input box in Internet Explorer - Stack Overflow

js String.format

	if (!String.prototype.format) {
	String.prototype.format = function() {
	var args = arguments;
	return this.replace(/{(\d+)}/g, function(match, number) {
	return typeof args[number] != 'undefined' ? args[number] : match;
	});
	};
	}

view raw gistfile1.js hosted with ❤ by GitHub

---

JavaScript equivalent to printf/string.format - Stack Overflow

TimerExist

註1：可搭配這款stopwatch使用。
註2：GLOBAL interval可調整偵測頻率(預設3秒/次)。

	#F1::
	GLOBAL winTitle
	GLOBAL counter = 0
	GLOBAL interval = 3
	WinGetTitle, winTitle, A
	TrayTipTime(,"【" winTitle "】監視中")
	ControlSend, , rs, Stop Watch
	t := interval * 1000
	SETTIMER, chkExist, %t%
	RETURN
	chkExist:
	{
	counter++
	IfWinNotExist %winTitle%
	{
	calcElapsedTime()
	ControlSend, , t, Stop Watch
	MSGBOX 【 %winTitle% 】 視窗已關閉.`n`n%counter%
	SETTIMER , chkExist, OFF
	RETURN
	}
	}
	calcElapsedTime()
	{
	totalSec := counter * interval
	M := totalSec // 60
	S := totalSec - M * 60
	counter = Elapsed Time : %M% min. %S% sec.
	}
	TrayTipTime(Title="", Text="", Time=1500, Style=0)
	{
	TrayTip, %Title%, %Text%,, %Style%
	SetTimer, TrayTipRemove, %Time%
	Return
	TrayTipRemove:
	TrayTip
	SetTimer, TrayTipRemove, Off
	Return
	}

view raw gistfile1.ahk hosted with ❤ by GitHub

系統已開機時間

@ECHO OFF
FOR /F "delims=" %%a IN ('SYSTEMINFO ^| FIND "系統存留時間"') DO ECHO %%a
PING -n 3 127.0.0.1 > NUL

UNION ALL vs UNION

• UNION ALL 和 UNION 不同 之處在於 UNION ALL 會將每一筆符合條件的資料都列出來，無論資料值 有無重複。 
• SQL1 union SQL2 : SQL1+SQL2 後的資料會自動重新排序, 且 SQL1 與 SQL2 的重複資料只顯示一筆。
• SQL1 union all SQL2: SQL1+SQL2 後資料不會自動重新排序, 且 SQL2 資料直接銜接到 SQL1 資料之後, 也就是 SQL1 與 SQL2 可以有重複資料。

SQL UNION ALL - 1Keydata SQL語法教學 昭佑.天翔: Oracle PL/SQL 的 union 與 union all 這兩種聯集的比較