使用下面的代碼，我可以將一系列日期插入到 MySql 表中，但我需要根據(jù)工作日限制日期。例如，我想限制所有日期進(jìn)入星期三的表格。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; }}}那我該怎么辦呢？謝謝你的幫助
3 回答
米琪卡哇伊
TA貢獻(xiàn)1998條經(jīng)驗(yàn) 獲得超6個(gè)贊
您可以嘗試DateTime.DayOfWeek跳過所有具有DayOfWeek.Wednesday或DayOfWeek.Thursday類似以下內(nèi)容的日期：
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;
}
}
揚(yáng)帆大魚
TA貢獻(xiàn)1799條經(jīng)驗(yàn) 獲得超9個(gè)贊
我沒有根據(jù)星期三和星期四的 2 個(gè)工作日制定條件，而是根據(jù)所有其他 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 關(guān)注
- 234 瀏覽
添加回答
舉報(bào)
0/150
提交
取消