3 回答

TA贡献1998条经验 获得超6个赞
您可以尝试DateTime.DayOfWeek跳过所有具有DayOfWeek.Wednesday或DayOfWeek.Thursday类似以下内容的日期:
for (DateTime date = startdate; date <= enddate; date = date.AddDays(1))
{
if (date.DayOfWeek == DayOfWeek.Wednesday || date.DayOfWeek == DayOfWeek.Thursday)
{
// skip to next day
continue;
}
try
{
// write to database
}
catch (Exception)
{
Console.Write("not entered");
//lblError.Text = ex.Message;
}
}

TA贡献1799条经验 获得超9个赞
我没有根据星期三和星期四的 2 个工作日制定条件,而是根据所有其他 5 天编写条件,如下所示。
protected void Submit_click(object sender, EventArgs e)
{
DateTime startdate = Convert.ToDateTime(txtstartdate.Text);
DateTime enddate = Convert.ToDateTime(txtenddate.Text);
for (DateTime date = startdate; date <= enddate; date = date.AddDays(1))
{
if (date.DayOfWeek == DayOfWeek.Monday || date.DayOfWeek == DayOfWeek.Tuesday || date.DayOfWeek == DayOfWeek.Friday || date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday)
{
var shtdate = date.ToShortDateString();
string MyConString = "SERVER=localhost;DATABASE=mydb;UID=myid;PASSWORD=abc123;";
MySqlConnection connection = new MySqlConnection(MyConString);
string cmdText = "INSERT INTO approved(agentlogin ,leavetype ,date ,time, reason)VALUES ( @login, @type, @date, 'Full day', @reason)";
MySqlCommand cmd = new MySqlCommand(cmdText, connection);
cmd.Parameters.AddWithValue("@login", Label1.Text);
cmd.Parameters.AddWithValue("@type", ddlleavetype.Text);
cmd.Parameters.AddWithValue("@date", shtdate);
cmd.Parameters.AddWithValue("@reason", txtreason.Text);
connection.Open();
int result = cmd.ExecuteNonQuery();
}
else{
}
}
}
没有找到匹配的内容?试试慕课网站内搜索吧
- 3 回答
- 0 关注
- 209 浏览
添加回答
举报