在将日期插入 MySql 表时阻止所有星期三和星期四

Question

使用下面的代码，我可以将一系列日期插入到 MySql 表中，但我需要根据工作日限制日期。例如，我想限制所有日期进入星期三的表格。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)){    try    {        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();        connection.Close();        //lblError.Text = "Data Saved";    }    catch (Exception)    {        Console.Write("not entered");        //lblError.Text = ex.Message;    }}}那我该怎么办呢？谢谢你的帮助

Answer 1

您可以尝试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;

    }

}

Answer 2

我没有根据星期三和星期四的 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{ 

         }

    }

}

Answer 3

DateTime 有一个 DayOfWeek 属性。（在这里查看）。

你可以在 if 语句中使用它，你就可以开始了。