資源簡介
你還在為多表查詢,多表操作編程痛苦嗎?現在你只需要一條語句就可以實現所有的功能!里面自己封裝了一個SQL控件,一條語句就可以實現數據庫的多表查詢修改以及增刪,非常智能。還蘊含了農歷轉成新歷的方法,還算比較高效的。代碼簡潔,是學習的好樣本。希望大家能從中學到一些東西,這個是一個獲獎作品。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Globalization;
namespace?BirthDayTips
{
????public?class?Change
????{
??#region???農歷轉新歷
????????
????public?static?DateTime?GetNewDate(DateTime?dt)
????{
????????System.Globalization.ChineseLunisolarCalendar?cls?=?new?ChineseLunisolarCalendar();
????????return?cls.ToDateTime(dt.Year?dt.Month?dt.Day?0?0?0?0);
????}
??#endregion
??#region????農歷數組
????????//天干
private?static?string[]?TianGan?=?{?“甲“?“乙“?“丙“?“丁“?“戊“?“己““庚“?“辛“?“壬“?“癸“?};
//地支
private?static?string[]?DiZhi?=?{?“子“?“丑“?“寅“?“卯“?“辰“?“巳““午“?“未“?“申“?“酉“?“戌“?“亥“?};
//十二生肖
private?static?string[]?ShengXiao?=?{?“鼠“?“牛“?“虎“?“兔“?“龍““蛇“?“馬“?“羊“?“猴“?“雞“?“狗“?“豬“?};
//農歷日期
private?static?string[]?DayName?=?{“*““初一““初二““初三““初四““初五“
“初六““初七““初八““初九““初十“
“十一““十二““十三““十四““十五“
“十六““十七““十八““十九““二十“
“廿一““廿二““廿三““廿四““廿五“
“廿六““廿七““廿八““廿九““三十“};
//農歷月份
private?static?string[]?MonthName?=?{?“*“?“正“?“二“?“三“?“四““五“?“六“?“七“?“八“?“九“?“十“?“十一“?“臘“?};
//公歷月計數天
private?static?int[]?MonthAdd?=?{?0?31?59?90?120?151?181212?243?273?304?334?};
//農歷數據
private?static?int[]?LunarData?={26353333871701174826770169423911334231175396438
340237493311771453694201326235046519732213402
40020229011386267611605234913751527094645331738
290133042112422651199255132352970637331706398762
2741120626743826471318204070347746165313862413
330077119726372688773365531109290029223980422395
117926741526356610671701174839877227422391330031
1175161120001037495277171452274233239723503222
26894934023493133973138646421960523493341232709
289026794627735925651210265139586313232707265877};
#endregion
??#region?????農歷日期轉新歷字符串
??///
///?獲取對應日期的農歷
///
///?公歷日期
///
??public?static?string?GetLunarCalendarLongString(DateTime?dtDay)
??{
??????string?sYear?=?dtDay.Year.ToString();
??????string?sMonth?=?dtDay.Month.ToString();
??????string?sDay?=?dtDay.Day.ToString();
??????int?year;
??????int?month;
??????int?day;
??????try
??????{
??????????year?=?int.Parse(sYear);
??????????month?=?int.Parse(sMonth);
??????????day?=?int.Parse(sDay);
??????}
??????catch
??????{
??????????year?=?DateTime.Now.Year;
??????????month?=?DateTime.Now.Month;
??????????day?=?DateTime.Now.Day;
??????}
??????int?nTheDate;
??????int?nIsEnd;
??????int?k?m?n?nBit?i;
??????string?calendar?=?string.Empty;
??????//計算到初始時間1921年2月8日的天數:1921-2-8(正月初一)
??????nTheDate?=?(year?-?1921)?*?365?+?(year?-?1921)?/?4?+?day?+?MonthAdd[month?-?1]?-?38;
??????if?((year?%?4?==?0)?&&?(month?>?2))
??????????nTheDate?+=?1;
??????//計算天干地支月日
??????nIsEnd?=
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
????..A..H.?????26112??2011-10-07?14:05??BirthDayTips.suo
?????文件???????5612??2011-09-24?21:58??BirthDayTips\Properties\Resources.resx
?????文件????????249??2011-09-24?21:58??BirthDayTips\Properties\Settings.settings
?????文件???????1380??2011-09-24?21:58??BirthDayTips\Properties\AssemblyInfo.cs
?????文件???????2874??2011-09-24?21:58??BirthDayTips\Properties\Resources.Designer.cs
?????文件???????1097??2011-09-24?21:58??BirthDayTips\Properties\Settings.Designer.cs
?????文件??????10995??2011-10-07?13:59??BirthDayTips\DateTimeShow.resx
?????文件??????41821??2011-10-07?13:59??BirthDayTips\DateTimeShow.Designer.cs
?????文件???????4608??2011-10-07?10:47??BirthDayTips\BirthDayTips.csproj
?????文件??????14328??2011-09-20?23:28??BirthDayTips\bin\Debug\BirthDayTips.vshost.exe
?????文件????????207??2011-09-25?04:08??BirthDayTips\bin\Debug\BirthDayTips.vshost.exe.config
?????文件????????490??2007-07-21?01:33??BirthDayTips\bin\Debug\BirthDayTips.vshost.exe.manifest
?????文件????????207??2011-09-25?04:08??BirthDayTips\bin\Debug\BirthDayTips.exe.config
?????文件??????39936??2011-09-20?22:26??BirthDayTips\bin\Debug\BirthDayTips.exe
?????文件??????75264??2011-09-20?22:26??BirthDayTips\bin\Debug\BirthDayTips.pdb
?????文件????????207??2011-09-25?04:08??BirthDayTips\bin\Release\BirthDayTips.exe.config
?????文件????????207??2011-09-25?04:08??BirthDayTips\bin\Release\BirthDayTips.vshost.exe.config
?????文件????????490??2007-07-21?01:33??BirthDayTips\bin\Release\BirthDayTips.vshost.exe.manifest
?????文件??????14328??2011-10-07?14:02??BirthDayTips\bin\Release\BirthDayTips.vshost.exe
?????文件?????140800??2011-10-07?13:59??BirthDayTips\bin\Release\BirthDayTips.pdb
?????文件??????37888??2011-09-20?23:33??BirthDayTips\bin\Release\新建文件夾\BirthDayTips.exe
?????文件????????207??2011-09-20?23:39??BirthDayTips\bin\Release\新建文件夾\App.config
?????文件??????73216??2011-10-07?13:59??BirthDayTips\bin\Release\BirthDayTips.exe
?????文件????????180??2011-09-20?22:26??BirthDayTips\obj\Debug\BirthDayTips.MainTips.resources
?????文件????????180??2011-09-20?22:26??BirthDayTips\obj\Debug\BirthDayTips.Properties.Resources.resources
?????文件????????854??2011-09-20?22:18??BirthDayTips\obj\Debug\BirthDayTips.csproj.GenerateResource.Cache
?????文件??????75264??2011-09-20?22:26??BirthDayTips\obj\Debug\BirthDayTips.pdb
?????文件??????39936??2011-09-20?22:26??BirthDayTips\obj\Debug\BirthDayTips.exe
?????文件????????755??2011-09-20?23:28??BirthDayTips\obj\Debug\BirthDayTips.csproj.FileListAbsolute.txt
?????文件????????870??2011-10-07?14:02??BirthDayTips\obj\Release\BirthDayTips.csproj.FileListAbsolute.txt
............此處省略42個文件信息
評論
共有 條評論