mysql 获取农历年份_获取农历日期

using System;

using System.Data;

using System.Configuration;

using System.Collections;

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;

using System.Collections.Generic;

using System.Text;

using System.Globalization;

public partial class TestDate : System.Web.UI.Page

{

private static ChineseLunisolarCalendar calendar = new ChineseLunisolarCalendar();

private static string ChineseNumber = "〇一二三四五六七八九";

public const string CelestialStem = "甲乙丙丁戊己庚辛壬癸";

public const string TerrestrialBranch = "子丑寅卯辰巳午未申酉戌亥";

public static readonly string[] ChineseDayName = new string[] {

"初一","初二","初三","初四","初五","初六","初七","初八","初九","初十",

"十一","十二","十三","十四","十五","十六","十七","十八","十九","二十",

"廿一","廿二","廿三","廿四","廿五","廿六","廿七","廿八","廿九","三十"};

public static readonly string[] ChineseMonthName = new string[] { "正", "二", "三", "四", "五", "六", "七", "八", "九", "十", "十一", "腊" };

protected void Page_Load(object sender, EventArgs e)

{

Response.Write(DateTime.Now.ToString()+"
");

Response.Write(GetChineseDate(DateTime.Now));

}

private void Transform(DateTime dt)

{

}

///

/// 获取一个公历日期对应的完整的农历日期

///

/// 一个公历日期

/// 农历日期

public string GetChineseDate(DateTime time)

{

string strY = GetYear(time);

string strM = GetMonth(time);

string strD = GetDay(time);

string strSB = GetStemBranch(time);

string strDate = strY + "(" + strSB + ")年 " + strM + "月 " + strD;

return strDate;

}

///

/// 获取一个公历日期的农历干支纪年

///

/// 一个公历日期

/// 农历干支纪年

public string GetStemBranch(DateTime time)

{

int sexagenaryYear = calendar.GetSexagenaryYear(time);

string stemBranch = CelestialStem.Substring(sexagenaryYear % 10 - 1, 1) + TerrestrialBranch.Substring(sexagenaryYear % 12 - 1, 1);

return stemBranch;

}

///

/// 获取一个公历日期的农历年份

///

/// 一个公历日期

/// 农历年份

public string GetYear(DateTime time)

{

StringBuilder sb = new StringBuilder();

int year = calendar.GetYear(time);

int d;

do

{

d = year % 10;

sb.Insert(0, ChineseNumber[d]);

year = year / 10;

} while (year > 0);

return sb.ToString();

}

///

/// 获取一个公历日期的农历月份

///

/// 一个公历日期

/// 农历月份

public string GetMonth(DateTime time)

{

int month = calendar.GetMonth(time);

int year = calendar.GetYear(time);

int leap = 0;

//正月不可能闰月

for (int i = 3; i <= month; i++)

{

if (calendar.IsLeapMonth(year, i))

{

leap = i;

break; //一年中最多有一个闰月

}

}

if (leap > 0) month--;

return (leap == month + 1 ? "闰" : "") + ChineseMonthName[month - 1];

}

///

/// 获取一个公历日期的农历日

///

/// 一个公历日期

/// 农历日

public string GetDay(DateTime time)

{

return ChineseDayName[calendar.GetDayOfMonth(time) - 1];

}

}

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
数据很详细 CREATE TABLE `zb_calendar` ( `GregorianDateTime` varchar(255) DEFAULT NULL COMMENT '公历日期时间', `LunarDateTime` varchar(255) DEFAULT NULL COMMENT '农历日期时间', `LunarShow` varchar(255) DEFAULT NULL, `IsJieJia` varchar(255) DEFAULT NULL, `LJie` varchar(255) DEFAULT NULL COMMENT '农历节日', `GJie` varchar(255) DEFAULT NULL COMMENT '公历节日', `Yi` varchar(255) DEFAULT NULL COMMENT '宜', `Ji` varchar(255) DEFAULT NULL COMMENT '忌', `ShenWei` varchar(255) DEFAULT NULL COMMENT '神位', `Taishen` varchar(255) DEFAULT NULL COMMENT '胎神', `Chong` varchar(255) DEFAULT NULL COMMENT '冲煞', `SuiSha` varchar(255) DEFAULT NULL COMMENT '岁煞', `WuxingJiazi` varchar(255) DEFAULT NULL COMMENT '五行甲子', `WuxingNaYear` varchar(255) DEFAULT NULL COMMENT '纳音五行年', `WuxingNaMonth` varchar(255) DEFAULT NULL COMMENT '纳音五行月', `WuxingNaDay` varchar(255) DEFAULT NULL COMMENT '纳音五行日', `MoonName` varchar(255) DEFAULT NULL COMMENT '农历月名称', `XingEast` varchar(255) DEFAULT NULL COMMENT '星宿吉凶(东方星座)', `XingWest` varchar(255) DEFAULT NULL COMMENT '四方(星座)', `PengZu` varchar(255) DEFAULT NULL COMMENT '彭祖百忌', `JianShen` varchar(255) DEFAULT NULL COMMENT '黄历12值神建', `TianGanDiZhiYear` varchar(255) DEFAULT NULL COMMENT '天干地支年', `TianGanDiZhiMonth` varchar(255) DEFAULT NULL COMMENT '天干地支月', `TianGanDiZhiDay` varchar(255) DEFAULT NULL COMMENT '天干地支日', `LMonthName` varchar(255) DEFAULT NULL COMMENT '农历月名称', `LYear` varchar(255) DEFAULT NULL COMMENT '生肖', `LMonth` varchar(255) DEFAULT NULL COMMENT '农历月', `LDay` varchar(255) DEFAULT NULL COMMENT '农历日', `SolarTermName` varchar(255) DEFAULT NULL COMMENT '农历节气的名称' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='万年历';
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值