0 〇 líng / 零 líng
1 一 yī / 壹（大写 大寫）
第一 dì-yī
2 二 èr / 贰（简体大写）= 貳（繁體大寫）
第二 dì-èr
3 三 sān / 叁（简体大写）= 參（繁體大寫）
第三 dì-sān
4 四 sì / 肆（大写 大寫）
第四 dì-sì
5 五 wǔ / 伍（大写 大寫）
第五 dì-wǔ
6 六 liù / 陆（简体大写）= 陸（繁體大寫）
第六 dì-liù
7 七 qī / 柒（大写 大寫）
第七 dì-qī
8 八 bā / 捌（大写 大寫）
第八 dì-bā
9 九 jiǔ / 玖（大写 大寫）
第九 dì-jiǔ
10 十 shí / 拾（大写 大寫）
Archive for 九月, 2009
28 九月
中文數字大寫表示(簡體中文與繁體中文)
17 九月
Register JavaScript on Page
StringBuilder strScript = new StringBuilder();
strScript.Append(“<script language=’javascript’> “);
strScript.Append(“document.getElementById(_hdfFields_ClientID).value=’” + strField + “‘;”);
strScript.Append(“document.getElementById(_hdfValues_ClientID).value=’” + strValue + “‘;”);
strScript.Append(“bindQueryParams();”);
strScript.Append(“</script>”);
//UpdatePanel內呼叫，否則Script不會寫到前端去
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(),”testScript” ,strScript.ToString(),false);
//一般ServerSide內呼叫
ClientScript.RegisterStartupScript(this.GetType(), “SetValueScript”, strScript.ToString());
11 九月
How to Save Session In BasePage Class
程式碼已驗證過，可以正常運作，沒有問題
Data From :
http://forums.asp.net/p/1058366/1513099.aspx#1513099
using
System;using
System.Data;using
System.Configuration;using
System.Web;using
System.Web.Security;using
System.Web.UI;using
System.Web.UI.WebControls;using
System.Web.UI.WebControls.WebParts;using
System.Web.UI.HtmlControls;///
<summary>///
Summary description for TestBasePage///
</summary>public
class TestBasePage : System.Web.UI.Page{
protected override void OnInit(EventArgs e){
this.Load += new EventHandler(TestBasePage_Load); base.OnInit(e);}
void TestBasePage_Load(object sender, EventArgs e){
HttpContext.Current.Session["test"] = “test”;Response.Write((
string)HttpContext.Current.Session["test"]);}
}
10 九月
固定表頭欄位,類似Excel的鎖定欄位
這樣一來,表頭欄位就是固定不動,而裡面的資料表會按照使用者的滑鼠轉動
<nobar>
<div id=”detail” runat=”server” style=”vertical-align:top; overflow:auto; width:100%; height:155px;”>
GridView , Repeater or …..Table
</div>
</nobar>
8 九月
Check Page Change By User Or Not(JavaScript)
var originalHeader;
var originalDetail;
function checkChange()
{
var currentHeader = getInnerHTML(‘header’);
var currentDetail = getInnerHTML(‘detail’);
if (currentHeader != originalHeader) alert(‘headerChange’);
if (currentDetail != originalDetail) alert(‘detailChange’);
}
function BodyLoad()
{
originalHeader = getInnerHTML(‘header’);
originalDetail = getInnerHTML(‘detail’);
}
function getInnerHTML(id)
{
var obj=document.getElementById(id);
if(obj!=null)
return obj.innerHTML;
else
return “”;
}
6 九月
TSQL: Parsing delimited string into table
From
http://rbgupta.blogspot.com/2007/10/tsql-parsing-delimited-string-into.html
ALTER FUNCTION dbo.udf_ItemParse (@Input VARCHAR(4000), @Delimeter char(1)=’|’)
RETURNS @ItemList TABLE (Item VARCHAR(200) ,RowID int)
AS
BEGIN
DECLARE @Item varchar(200)
DECLARE @StartPos int, @Length int
DECLARE @Pos int
SET @Pos = 0
WHILE LEN(@Input) > 0
BEGIN
SET @StartPos = CHARINDEX(@Delimeter, @Input)
IF @StartPos < 0 SET @StartPos = 0
SET @Length = LEN(@Input) – @StartPos – 1
IF (@StartPos > 0)
BEGIN
SET @Pos = @Pos + 1
SET @Item = [...]
6 九月
Update From Statement Example
/*資料更新回訂單主檔*/
UPDATE dbo.CN_Order_Header
SET DeliveryDate=ISNULL(hl.DeliveryDate,h.DeliveryDate),
Consignee=ISNULL(hl.Consignee,h.Consignee),
TelNum=ISNULL(hl.TelNum,h.TelNum),
DeliveryAddress=ISNULL(hl.DeliveryAddress,h.DeliveryAddress),
CheckAccount=ISNULL(hl.CheckAccount,h.CheckAccount)
FROM dbo.CN_Order_Header as h
JOIN dbo.CN_Order_Header_Log as hl
ON h.OrderID = hl.OrderID and
hl.ModifySNo = (SELECT MAX(ModifySNo)
FROM dbo.CN_Order_Header_Log
WHERE OrderID=h.OrderID)
and hl.ModifyStatus = ‘1′
and hl.OrderID=@OrderID
/*資料更新回訂單明細檔,可一次更新多筆單身*/
UPDATE dbo.CN_Order_Detail
SET ProductID=ISNULL(dl.ProductID,d.ProductID),
Unit=ISNULL(dl.Unit,d.Unit),
Qty=ISNULL(dl.Qty,d.Qty),
UnitPrice=ISNULL(dl.UnitPrice,d.UnitPrice),
Memo=ISNULL(dl.Memo,d.Memo)
FROM [...]
2 九月
Creating or adding an attribute (xmlAttribute) on a node in c# with Visual Studio2005
//Add attribute id2
XmlDocument xDoc = new XmlDocument();
xDoc.Load (tmpFilename);
foreach (XmlNode unNodo in xDoc.DocumentElement.GetElementsByTagName(“nodo”) )
{
XmlAttribute nAttr;
nAttr = xDoc.CreateAttribute (“id2″);
nAttr.Value= unNodo.Attributes["id"].Value ;
unNodo.Attributes.Append( nAttr);
}
xDoc.Save(tmpFilename);
1 九月
Get Current Week (VB.NET)
Private Function GetCurrentWeek() As String
Dim dat As DateTime = DateTime.Now()
Dim culInfo As New CultureInfo(“zh-TW”)
Dim cal As Calendar = culInfo.Calendar()
Dim week As Integer = cal.GetWeekOfYear(dat, CalendarWeekRule.FirstDay, DayOfWeek.Sunday)
Return week.ToString(“00″)
End Function
