How to custom configure the starting day of last week and this week to query business data in C#?
When doing a certain report management function, there is a requirement: it is necessary to count the order data of last week and this week based on the custom configured [Start Day of Week]. There is no encapsulated method in C# to directly obtain the day from the previous week to the day and the day from the current week to the day according to our needs, so we need to encapsulate the method ourselves to implement it (we can also use other languages to follow this idea) ).
Author: Xigua Programmer
Home page portal: https://www.cnblogs.com/kimiliucn
Foreword
When doing a certain report management function, there is a requirement: it is necessary to count the order data of last week and this week based on the custom configured [Start Day of Week]. There is no encapsulated method in C# to directly obtain the day from the previous week to the day and the day from the current week to the day according to our needs, so we need to encapsulate the method ourselves to implement it (we can also use other languages to follow this idea) ).
1. Needs and ideas
The demand is like this. We need to count the order data of last week and this week based on the custom configured [Start Day of Week]. See the details below.
1.1-Requirements Introduction
For example: Suppose today is [September 19, 2023 (Tuesday)], if the configuration is [Monday], then the time to be queried last week is counted from last Monday to last Sunday (2023 September 11 – September 17, 2023), then the time to be queried this week is counting from this Monday to this Sunday (September 18, 2023 – September 24, 2023). 
If configured is [Sunday], then the time to be queried last week is from last Sunday to last Saturday (September 10, 2023 – September 16, 2023), then the time to be queried this week is Last Sunday counts to this Saturday (September 17, 2023 – September 23, 2023). [Note: Because the above assumes that today is September 19, 2023 (Tuesday), and the configuration is (Sunday), when this day has not yet arrived, all the Sundays from the nearest previous week need to be taken]
Another scenario, if we assume today It is [September 24, 2023 (Sunday)]. If it is configured as [Sunday], then the time to be queried last week is from last Sunday to this Saturday (September 17, 2023 – 2023 September 23), then the time to be queried this week is from last Sunday to this Saturday (September 24, 2023 – September 30, 2023). 
1.2-Development Ideas
Step one: First create a new configuration table to store the day of the week we configured. [Xigua Programmer] stores string numbers (1-7) here, 1 means Monday, 2 means Tuesday , 7 means Sunday, and so on.
The second step [Core]: Calculate based on the configured [week start day], the day on which the data to be queried last week starts and ends, and the data to be queried this week is calculated. On which day the data should start and end (the code demonstration in this article mainly introduces this piece of logic).
Step 3: Based on the calculated start/end date, you can judge it based on the [order creation time] (according to your business needs) and the calculated date.
Second, code implementation
2.1-Package
///
/// Get the configuration time of last week and this week (used to read data)
///
/// Configured [week start day]
/// Current time
///
public static (string upper_week_begin, string upper_week_end, string this_week_begin, string this_week_end) GetWeekTimeStr(int startWeekDay, DateTime now)
{
if (startWeekDay 7)
{
throw new ArgumentOutOfRangeException(nameof(startWeekDay), "startWeekDay must be between 1 and 7.");
}
//Get the current day of the week
int currentDayOfWeek = GetWeekValues(now.DayOfWeek);
DateTime currentDate = now.Date;
string upper_week_begin, upper_week_end, this_week_begin, this_week_end;
//If the configured week is greater than the current week
if (startWeekDay > currentDayOfWeek || startWeekDay == currentDayOfWeek)
{
DayOfWeek week = GetWeekEnums(startWeekDay);
DateTime lastThursday = GetDayOfWeek(currentDate, week);//Start date of this week
DateTime lastWeekSunday = lastThursday.AddDays(6);//The end date of this week is pushed back 6 days based on [Start Date of this Week]
DateTime lastLastThursday = GetDayOfWeek(lastThursday.AddDays(-1), week);//Based on the start time of this week, push forward 1 day to find the start time of the previous week
DateTime lastLastWeekSunday = lastLastThursday.AddDays(6);//The end time of the previous week
upper_week_begin = lastLastThursday.ToString("yyyy-MM-dd");
upper_week_end = lastLastWeekSunday.ToString("yyyy-MM-dd");
this_week_begin = lastThursday.ToString("yyyy-MM-dd");
this_week_end = lastWeekSunday.ToString("yyyy-MM-dd");
}
else
{
//Return the start and end dates of this week and last week
DayOfWeek week = GetWeekEnums(startWeekDay);
DateTime thisWeekMonday = GetDayOfWeek(now, week);//Start date of this week
DateTime thisWeekSunday = thisWeekMonday.AddDays(6); //The end date of this week is pushed back 6 days based on the [start date of this week]
DateTime lastWeekMonday = thisWeekMonday.AddDays(-7);//According to [Start Date of this Week], push forward 7 days to get [Start Time of Last Week]
DateTime lastWeekSunday = thisWeekMonday.AddDays(-1); //According to [the start date of this week], push forward 1 day to get [the end time of last week]
upper_week_begin = lastWeekMonday.ToString("yyyy-MM-dd");
upper_week_end = lastWeekSunday.ToString("yyyy-MM-dd");
this_week_begin = thisWeekMonday.ToString("yyyy-MM-dd");
this_week_end = thisWeekSunday.ToString("yyyy-MM-dd");
}
return (upper_week_begin, upper_week_end, this_week_begin, this_week_end);
}
///
/// Get the date of the previous specified week
///
///
///
///
public static DateTime GetDayOfWeek(DateTime date, DayOfWeek targetDayOfWeek)
{
int diff = (7 + (date.DayOfWeek - targetDayOfWeek)) % 7;
return date.AddDays(-diff).Date;
}
///
/// Get the day of the week value based on the enumeration
///
///
///
public static int GetWeekValues(DayOfWeek targetDayOfWeek)
{
switch(targetDayOfWeek)
{
case DayOfWeek.Monday:
return 1;
case DayOfWeek.Tuesday:
return 2;
case DayOfWeek.Wednesday:
return 3;
case DayOfWeek.Thursday:
return 4;
case DayOfWeek.Friday:
return 5;
case DayOfWeek.Saturday:
return 6;
case DayOfWeek.Sunday:
return 7;
default:
return 1;//Default Monday
}
}
///
/// Get the enumeration based on the day of the week value
///
///
///
public static DayOfWeek GetWeekEnums(int startWeekDay)
{
switch (startWeekDay)
{
case 1:
return DayOfWeek.Monday;
case 2:
return DayOfWeek.Tuesday;
case 3:
return DayOfWeek.Wednesday;
case 4:
return DayOfWeek.Thursday;
case 5:
return DayOfWeek.Friday;
case 6:
return DayOfWeek.Saturday;
case 7:
return DayOfWeek.Sunday;
default:
return DayOfWeek.Monday; //Default Monday
}
}
2.2-Use
var item = GetWeekTimeStr(startWeekDay, now);
// Get data
if (!string.IsNullOrEmpty(item.upper_week_begin))
{
}
if (!string.IsNullOrEmpty(item.upper_week_end))
{
}
if (!string.IsNullOrEmpty(item.this_week_begin))
{
}
if (!string.IsNullOrEmpty(item.this_week_end))
{
}
Then apply it to the business scenario you need based on the queried time period.
Original link: https://www.cnblogs.com/kimiliucn/p/17715464.html
Copyright statement: This article is an original article, and the copyright belongs to [Xigua Programmer]. Please indicate the source when reprinting. If you have any questions, please send a private message.
Original link: https://www.cnblogs.com/kimiliucn/p/17715464.html
微信扫一扫打赏
支付宝扫一扫打赏
