首页 > 编程语言 >[转]C#根据当前时间确定日期范围(本周、本月、本季度、本年度及常见日期方法荟萃 - 岁末年初

[转]C#根据当前时间确定日期范围(本周、本月、本季度、本年度及常见日期方法荟萃 - 岁末年初

时间:2022-12-06 13:45:50浏览次数:69  
标签:00 C# AddDays System DateTime 本季度 日期 date dt


DateTime dt = DateTime.Now;  //当前时间DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d")));  //本周周一DateTime endWeek = startWeek.AddDays(6);  //本周周日DateTime startMonth = dt.AddDays(1 - dt.Day);  //本月月初DateTime endMonth = startMonth.AddMonths(1).AddDays(-1);  //本月月末//DateTime endMonth = startMonth.AddDays((dt.AddMonths(1) - dt).Days - 1);  //本月月末DateTime startQuarter = dt.AddMonths(0 - (dt.Month - 1) % 3).AddDays(1 - dt.Day);  //本季度初DateTime endQuarter = startQuarter.AddMonths(3).AddDays(-1);  //本季度末DateTime startYear = new DateTime(dt.Year, 1, 1);  //本年年初DateTime endYear = new DateTime(dt.Year, 12, 31);  //本年年末

昨天、明天、上周、上月、上季度、上年度等等,只要AddDays()、AddMonths()、AddYears()这几种方法组合

一.如何获得当月有多少天

int m=System.DateTime.DaysInMonth(System.DateTime.Now.Year,System.DateTime.Now.Month);

二.日期型格式处理通用方法
1.在webconfig中配置如下

<add key="ShortDatePattern" value="MM-dd-yyyy" /><add key="LongDatePattern" value="dddd-MMMM dd-yyyy" /><add key="ShortTimePattern" value="hh:mm tt" /><add key="LongTimePattern" value="hh:mm tt" />2.在global.asax中
protected void Application_BeginRequest(Object sender, EventArgs e){Thread currentThread = Thread.CurrentThread;CultureInfo cul = currentThread.CurrentCulture.Clone() as CultureInfo;cul.DateTimeFormat.ShortDatePattern= BLLFacade.Common.GetShortDatePattern();cul.DateTimeFormat.LongDatePattern= BLLFacade.Common.GetLongDatePattern();cul.DateTimeFormat.ShortTimePattern= BLLFacade.Common.GetShortTimePattern();cul.DateTimeFormat.LongTimePattern= BLLFacade.Common.GetLongTimePattern();currentThread.CurrentCulture = cul;}

3.在业务逻辑层中

public static string GetShortDatePattern(){return System.Configuration.ConfigurationSettings.AppSettings["ShortDatePattern"];}public static string GetLongDatePattern(){return System.Configuration.ConfigurationSettings.AppSettings["LongDatePattern"];}public static string GetShortTimePattern(){return System.Configuration.ConfigurationSettings.AppSettings["ShortTimePattern"];}public static string GetLongTimePattern(){return System.Configuration.ConfigurationSettings.AppSettings["LongTimePattern"];}

4.然后在其他地方正常调用就可以了,如果需要修改格式只需要修改webconfig中的,且可以保证整个系统中的所有格式都是一致的
三.在asp.net中怎么样计算两个日期相差的年、月份、日期、小时、分钟 、妙等
在asp.net中怎么样计算两个日期相差的年、月份、日期、小时、分钟 、妙等#region 在asp.net中怎么样计算两个日期相差的年、月份、日期、小时、分钟 、妙等
// 调用

//        DateTime a=Convert.ToDateTime("2005-09-03 20:15");//        DateTime b=Convert.ToDateTime("2005-09-04 09:09 ");//        double d=Bll.Common.DateDiff(Bll.Common.EnumDateCompare.day,a,b);//        Response.Write(d.ToString("f0"));//四舍五入        public enum EnumDateCompare        {            year    =1,            month    =2,            day        =3,            hour    =4,            minute    =5,            second    =6        }        public static double DateDiff(EnumDateCompare howtocompare, System.DateTime startDate, System.DateTime endDate)        {            double diff=0;            System.TimeSpan TS = new System.TimeSpan(endDate.Ticks-startDate.Ticks);            switch (howtocompare)            {                case EnumDateCompare.year:                    diff = Convert.ToDouble(TS.TotalDays/365);                    break;                case EnumDateCompare.month:                    diff = Convert.ToDouble((TS.TotalDays/365)*12);                    break;                case EnumDateCompare.day:                    diff = Convert.ToDouble(TS.TotalDays);                    break;                case EnumDateCompare.hour:                    diff = Convert.ToDouble(TS.TotalHours);                    break;                case EnumDateCompare.minute:                    diff = Convert.ToDouble(TS.TotalMinutes);                    break;                case EnumDateCompare.second:                    diff = Convert.ToDouble(TS.TotalSeconds);                    break;            }            return diff;        }

四.获取某月的实际工作日(即不包括周六日)
//调用

//int days =getDays(System.DateTime.Now));private int getDays(System.DateTime date1){    int m=System.DateTime.DaysInMonth(date1.Year,date1.Month);    int mm=0;    for(int i=1;i<=m;i++)    {        System.DateTime date=Convert.ToDateTime(date1.Year+"-"+date1.Month+"-"+i);        switch (date.DayOfWeek)        {            case System.DayOfWeek.Monday:            case System.DayOfWeek.Thursday:            case System.DayOfWeek.Tuesday:            case System.DayOfWeek.Wednesday:            case System.DayOfWeek.Friday:                mm=mm+1;                break;        }    }    return mm;}

五.获得任意两日期之间的有效工作日(不包括周六日) 获得任意两日期之间的有效工作日(不包括周六日)#region 获得任意两日期之间的有效工作日(不包括周六日)
//调用

        //DateTime date1=Convert.ToDateTime("2005-10-20");        //DateTime date2=Convert.ToDateTime("2005-11-01");        //int days =getDays(date1,date2);        private int getDays(System.DateTime date1,System.DateTime date2)        {            string m=DateDiff(EnumDateCompare.day,date1,date2).ToString("f0");            int mm=0;            for(int i=0;i<=Convert.ToInt32(m);i++)            {                System.DateTime date=Convert.ToDateTime(date1.AddDays(i));                switch (date.DayOfWeek)                {                    case System.DayOfWeek.Monday:                    case System.DayOfWeek.Thursday:                    case System.DayOfWeek.Tuesday:                    case System.DayOfWeek.Wednesday:                    case System.DayOfWeek.Friday:                        mm=mm+1;                        break;                }            }            return mm;        }

六.格式输出
格式输出#region 格式输出

        private void Page_Load(object sender, System.EventArgs e)        {            System.Globalization.DateTimeFormatInfo myDTFI = new System.Globalization.CultureInfo( "en-US", false ).DateTimeFormat;//中国用zh-cn            DateTime myDT =System.DateTime.Now;            Response.Write(myDT.ToString("f",myDTFI));            /**//**//**//*            This code produces the following output.            FORMAT  en-US EXAMPLE            CHAR    VALUE OF ASSOCIATED PROPERTY, IF ANY              d     1/3/2002                    M/d/yyyy (ShortDatePattern)              D     Thursday, January 03, 2002                    dddd, MMMM dd, yyyy (LongDatePattern)              f     Thursday, January 03, 2002 12:00 AM              F     Thursday, January 03, 2002 12:00:00 AM                    dddd, MMMM dd, yyyy h:mm:ss tt (FullDateTimePattern)              g     1/3/2002 12:00 AM              G     1/3/2002 12:00:00 AM              m     January 03                    MMMM dd (MonthDayPattern)              M     January 03                    MMMM dd (MonthDayPattern)              r     Thu, 03 Jan 2002 00:00:00 GMT                    ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (RFC1123Pattern)              R     Thu, 03 Jan 2002 00:00:00 GMT                    ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (RFC1123Pattern)              s     2002-01-03T00:00:00                    yyyy'-'MM'-'dd'T'HH':'mm':'ss (SortableDateTimePattern)              t     12:00 AM                    h:mm tt (ShortTimePattern)              T     12:00:00 AM                    h:mm:ss tt (LongTimePattern)              u     2002-01-03 00:00:00Z                    yyyy'-'MM'-'dd HH':'mm':'ss'Z' (UniversalSortableDateTimePattern)              U     Thursday, January 03, 2002 8:00:00 AM              y     January, 2002                    MMMM, yyyy (YearMonthPattern)              Y     January, 2002                    MMMM, yyyy (YearMonthPattern)            */        }

七.获得本周的周六和周日

ConvertDateToWeek#region ConvertDateToWeek        public static void ConvertDateToWeek(DateTime date,out DateTime firstdate,out DateTime lastdate)        {            DateTime first=System.DateTime.Now;            DateTime last=System.DateTime.Now;            switch (date.DayOfWeek)            {                case System.DayOfWeek.Monday:                    first=date.AddDays(-1);                    last=date.AddDays(5);                    break;                case System.DayOfWeek.Tuesday:                    first=date.AddDays(-2);                    last=date.AddDays(4);                    break;                case System.DayOfWeek.Wednesday:                    first=date.AddDays(-3);                    last=date.AddDays(3);                    break;                case System.DayOfWeek.Thursday:                    first=date.AddDays(-4);                    last=date.AddDays(2);                    break;                case System.DayOfWeek.Friday:                    first=date.AddDays(-5);                    last=date.AddDays(1);                    break;                case System.DayOfWeek.Saturday:                    first=date.AddDays(-6);                    last=date;                    break;                case System.DayOfWeek.Sunday:                    first=date;                    last=date.AddDays(6);                    break;            }            firstdate=first;            lastdate=last;        }        #endregion

//调用

DateTime firstdate=System.DateTime.Now;DateTime lastdate=System.DateTime.Now;ConvertDateToWeek(date,out firstdate,out lastdate);八获得当前日期是该年度的第几周DateTime dt = Convert.ToDateTime("2006-05-01");int weeks = dt.DayOfYear / 7 + 1;

---------------------
作者:岁末年初
来源:CNBLOGS
原文:https://www.cnblogs.com/xptopsky/p/16385220.html
版权声明:本文为作者原创文章,转载请附上博文链接!
内容解析By:CSDN,CNBLOG博客文章一键转载插件

标签:00,C#,AddDays,System,DateTime,本季度,日期,date,dt
From: https://www.cnblogs.com/kevinl/p/16954987.html

相关文章

  • docker镜像保存及导出(save,export)
    前言:有时自己的做好的docker镜像,想将这个docker容器弄到其他服务器上去运行;或者已经运行的容器,将其弄导出,运行到其他地方进行测试 1.查看要要保存的镜像的IDdocker i......
  • centos下安装Docker和Rancher的安装
    1.Docker,centos7安装指定版本Docker1.yum更新sudoyum-yupdate 2.清空历史sudoyumremovedockerdocker-clientdocker-client-latestdocker-commondo......
  • SpringBoot整合Netty+WebSocket
    SpringBoot整合Netty+WebSocket构建环境pom.xml<?xmlversion="1.0"encoding="UTF-8"?><projectxmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w......
  • LINUX漏洞复现之ShellShock漏洞
    简介ShellShock漏洞,中文称为"破壳漏洞",是UnixShell中的安全漏洞在一些网络服务器的部署中,使用bash来处理某些请求,允许攻击者通过低版本的bash执行任意Shell命令......
  • java读取csv文件
    java读取csv文件 /***读取CSV文件内容*@paramcsvFileName*@throwsIOException*/publicstaticvoidreadCSVAndWrite(StringinputCsvFileName......
  • vue3 使用watch 监听多个数据
    //监听时间选择watch([internalSubmTimer,internalTimer,externalSubmTimer,externaTimer,callbackTimer,],(newValue,oldValue)=......
  • C# 元组类型和元组文本
    从C#7.0开始,可以使用元组类型和元组文本轻松实现此目的。元组类型定义元组元素的数据类型。元组文本提供返回的元组的实际值。在下面的示例中,(string,string,str......
  • DC-1
    Wappalyzer、exploit-db.com、msf、python-c'importpty;pty.spawn("/bin/bash")'发现主机:nmap-sP192.168.88.0/24查看端口nmap-p-192.168.88.136发现开启了......
  • devenv vdproj is build other project, not package msi
    公司有个老项目,是用VS2010开发的Winform程序,采用的是VS的Installer打包的,最近弄了Jenkins自动打包脚本,发现不好使,无法生成msi。使用VS2010可以正常打包,但是在CMD下执行de......
  • DC-2
    重定向发现主机:Hostisup(0.000063slatency).Nmapscanreportfor192.168.88.138扫描端口发现PORT  STATESERVICE80/tcp openhttp7744/tcpopenraq......