private void button1_Click(object sender, EventArgs e) { if (textBox4.Text.Trim() != "" && textBox5.Text.Trim() != "") { string Start = dateTimePicker1.Value.ToString("yyyy-MM-dd 00:00:00"); string Due = dateTimePicker2.Value.ToString("yyyy-MM-dd 23:59:59"); string DayInterval = textBox1.Text.Trim(); string minInterval = textBox2.Text.Trim(); string RepeatCount = textBox6.Text.Trim(); string author = textBox3.Text.Trim(); string title = textBox4.Text.Trim(); string Message = textBox5.Text.Trim(); Task.Run(() => { try { string sqlstr = $@"exec [ManagementDB].dbo.[usp_RegisterAnnounce] '0','{SayType}','{SayPosition}','{123}','{Start}','{Due}','{DayInterval}','{minInterval}','{RepeatCount}',N'{author}',N'{title}',N'{Message}'"; db._SQL_IDU(sqlstr); this.Invoke(new Action(delegate { MessageBox.Show("操作成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); })); } catch (Exception ex) { this.Invoke(new Action(delegate { MessageBox.Show($"发送异常! \r\n{ex.Message}", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Error); })); } }); } }
private void 除公告ToolStripMenuItem_Click(object sender, EventArgs e) { int registerID = Convert.ToInt32(listView1.SelectedItems[0].Tag);; Task.Run(() => { string sqlstr = $@"delete [ManagementDB].dbo.[Announce] where [registerID] = '{registerID}'"; int count = db._SQL_IDU(sqlstr); this.Invoke(new Action(delegate { if (count > 0) { MessageBox.Show("删除成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } })); }); }