/// <summary> /// 請假輸入兩個日期：（只考慮最多相差一個月）对于不同月份的数据考虑月份数据分界 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { DateTime enterStar,enterEnd,stardate1, endate1, stardate2, enddate2; int betweenyear, betweenmonth, betweenday; enterStar=dateTimePicker1.Value; enterEnd=dateTimePicker2.Value; TimeSpan ts = enterEnd - enterStar; betweenyear = TimeSpanExtensions.GetYears(ts); betweenmonth = TimeSpanExtensions.GetMonths(ts); betweenday = ts.Days; //betweenday=enterStar.CompareTo(enterEnd); if (betweenday > 0) { if (betweenyear == 0 && betweenmonth == 1)//同年不同月 { stardate1 = dateTimePicker1.Value;//月初 dateTimePicker3.Value = stardate1; endate1 = new DateTime(stardate1.Year, stardate1.Month, DateTime.DaysInMonth(stardate1.Year, stardate1.Month));//DaysInMonth 指定年月中的天數 dateTimePicker4.Value = endate1;//月末 stardate2 = new DateTime(enterEnd.Year, enterEnd.Month, 1); dateTimePicker5.Value = stardate2;//月初 enddate2 = enterEnd; dateTimePicker6.Value = enddate2;//月末 } if (betweenyear == 1 && betweenmonth == 1)//不同年不同月 { stardate1=enterStar;//月初 dateTimePicker3.Value = stardate1; endate1=new DateTime(stardate1.Year, stardate1.Month, DateTime.DaysInMonth(stardate1.Year, stardate1.Month));//月末 dateTimePicker4.Value = endate1; stardate2=new DateTime(enterEnd.Year, enterEnd.Month, 1); //月初 dateTimePicker5.Value = stardate2; enddate2=enterEnd;//月末 dateTimePicker6.Value = enddate2; } if (betweenyear == 0 && betweenmonth == 0)//同年同月 { stardate1 = enterStar;//月初 dateTimePicker3.Value = stardate1; endate1 = enterEnd;//月末 dateTimePicker4.Value = endate1; } } }
---sql 請假輸入兩個日期：（只考慮最多相差一個月）对于不同月份的数据考虑月份数据分界---1.要判斷是否同一年同一月，不同年，不同月要分開顯示兩組不同月日期之間數據---2.同年不同月,要分開顯示兩組不同月日期之間數據---3.同年同月不用分組顯示declare @enterStar datetime,@enterEnd datetime,@stardate1 datetime,@endate1 datetime,@stardate2 datetime,@enddate2 datetimedeclare @betweenyear int,@betweenmonth int,@betweenday intset @enterStar='2012-12-05'set @enterEnd='2013-01-25'select @betweenyear=DATEDIFF(year, @enterStar, @enterEnd) SELECT @betweenmonth =DATEDIFF(month, @enterStar, @enterEnd)SELECT @betweenday=DATEDIFF(day, @enterStar, @enterEnd)if (@betweenday>0)beginif(@betweenyear=0 and @betweenmonth=1)begin select @stardate1=@enterStar--Dateadd(mm,datediff(mm,0,@enterStar),0) --月初select @endate1=Dateadd(ms,-3,dateadd(mm,datediff(m,0,@enterStar)+1,0)) --月末 select @stardate2=Dateadd(mm,datediff(mm,0,@enterEnd),0) --月初select @enddate2=@enterEnd--Dateadd(ms,-3,dateadd(mm,datediff(m,0,@enterEnd)+1,0)) --月末select @stardate1,@endate1,@stardate2,@enddate2endif(@betweenyear=1 and @betweenmonth=1)begin select @stardate1=@enterStar--Dateadd(mm,datediff(mm,0,@enterStar),0) --月初select @endate1=Dateadd(ms,-3,dateadd(mm,datediff(m,0,@enterStar)+1,0)) --月末 select @stardate2=Dateadd(mm,datediff(mm,0,@enterEnd),0) --月初select @enddate2=@enterEnd--Dateadd(ms,-3,dateadd(mm,datediff(m,0,@enterEnd)+1,0)) --月末 select @stardate1,@endate1,@stardate2,@enddate2endif(@betweenyear=0 and @betweenmonth=0)beginselect @stardate1=@enterStarselect @endate1=@enterEnd select @stardate1,@endate1 endend
