工作需要筆記

SELECT 1/0
哇哈哈，Got you !!! 世宇教的！

overflow-x:hidden
y軸必要時才出現，若overflow-y:scroller，y軸會一直出現，花了快半小時在瞎用jquery處理，鴨鴨！
 

.popupProductSizeTabContent {float: left;display: block;width: 924px;height:612px;background: #fff;border: 1px #b6b6b6 solid;overflow-x:hidden;font-family:微軟正黑體;color:#000;padding:20px;}

function calculate(str,limit) {
String.prototype.lenB = function () { return this.replace(/[^ -]/g, "**").length; }
if (str.lenB() > limit)
return false;
else
return true;
}

using System;
using System.Timers;
namespace TimerExample
{
class Program
{

Response.write "<form name=""myform"" id=""myform"" action=""https://www.einvoice.nat.gov.tw/APMEMBERVAN/membercardlogin"" method=""POST"" >"
Response.Write "<input type=""hidden"" id=""card_ban"" name=""card_ban"" value=""xxxxxxxx"">"
Response.Write "<input type=""hidden"" id=""card_no1"" name=""card_no1"" value=" & card_no1 & ">"
Response.Write "<input type=""hidden"" id=""card_no2"" name=""card_no2"" value=" & card_no2 & ">"
Response.Write "<input type=""hidden"" id=""card_type"" name=""card_type"" value=" & card_type & ">"
Response.Write "<input type=""hidden"" id=""back_url"" name=""back_url"" value=""http://xxx.xxxx.xxx/xxx.asp"">"
Response.Write "<input type=""hidden"" id=""token"" name=""token"" value=" & token & ">"
Response.write "</form>"
Response.write "<script language=""javascript"">document.getElementById(""myform"").submit();</script>"

C#
HttpUtility.JavaScriptStringEncode(xxxx)
javaScript

jQuery Number Format
https://www.customd.com/articles/11/jquery-number-format
https://github.com/customd/jquery-number/blob/master/jquery.number.js

一、抓不到append element
要把append element 放在 ajax success 裡
 
二、click事件 trigger many times

SELECT m.OrderID ,left(m.productIDs,len(m.productIDs)-1) as productIDsFinal from
(SELECT OrderID,(SELECT cast(ProductID AS NVARCHAR ) + ',' from [Order Details]
where OrderID = ord.OrderID
FOR XML PATH('')) as productIDs
from orders ord
GROUP BY orderid) M --這個M一定要加，不知道為啥
ORDER by M.OrderID