在将日期插入 MySql 表时阻止所有星期三和星期四 [英] Block all Wednesdays and Thursdays while inserting dates into MySql table

问题描述

使用下面的代码，我可以将一系列日期插入到 MySql 表中，但我需要根据工作日限制日期.例如，我想限制所有日期进入表格，即星期三.

With the below code I can insert a range of dates into the MySql table, but I need to restrict dates based on Weekdays. For example I want to restrict all dates from entering the table which are Wednesdays.

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;
    }
}
}

那我该怎么办呢?感谢您的帮助

So how can I go about it? Thanks for any help

推荐答案

我没有根据星期三和星期四的 2 个工作日制定条件，而是根据所有其他 5 天编写条件，如下所示.

Instead of making conditions based on the 2 weekdays Wednesday and Thursday, I wrote the conditions based on all the other 5 days as shown below.

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{ 
         }
    }

}

这篇关于在将日期插入 MySql 表时阻止所有星期三和星期四的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！