private void button4_Click(object sender, EventArgs e) { if (button4.Text == "返回") { this.Close(); } else if (button4.Text == "退回责任人") { mysql = $"update task set status='审核退回',substatus=0 where serial='{task.Serial}'"; var sqlConnection = mySqlCon.GetConnection(); var cmd = mySqlCon.getCmd(mysql: mysql, sqlConnection); if (cmd.ExecuteNonQuery() != 0) { MessageBox.Show("退回成功"); sqlConnection.Close(); this.Close(); } else { MessageBox.Show("服务器正忙,请稍后再试"); } } }
private void dataGridView1_CellPainting(object sender, DataGridViewCellPaintingEventArgs e) { for (var i = 0; i < dataGridView1.RowCount; i++) { var dataGridViewRow = dataGridView1.Rows[i]; var nowTime = DateTime.Now.ToString("yyMMdd"); //完成时间小于当天日期,字体显示为红色 if (int.Parse(Convert.ToDateTime(dataGridViewRow.Cells["完成时间"].Value.ToString()).ToString("yyMMdd")) - int.Parse(DateTime.Now.ToString("yyMMdd")) < 0) { dataGridViewRow.DefaultCellStyle.ForeColor = Color.Red; dataGridViewRow.DefaultCellStyle.SelectionBackColor = Color.Red; /*if (dataGridViewRow.Cells["状态"].Value.ToString() != "已超时") * { * var sqlCommand = * mySqlCon.getCmd( * $"update task set status='已超时' where serial='{dataGridViewRow.Cells["单号"].Value.ToString()}'"); * sqlCommand.ExecuteNonQuery(); * dataGridViewRow.Cells["状态"].Value = "已超时"; * }*/ var sqlConnection = mySqlCon.GetConnection(); var sqlCommand = mySqlCon.getCmd( $"update task set timeout=1 where serial='{dataGridViewRow.Cells["单号"].Value.ToString()}'", sqlConnection); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); } } }
/** * 提交数据 */ private void button3_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(textBox4.Text.Trim()) || String.IsNullOrEmpty(textBox2.Text.Trim()) || String.IsNullOrEmpty(textBox3.Text.Trim()) || String.IsNullOrEmpty(richTextBox1.Text.Trim()) || String.IsNullOrEmpty(comboBox1.Text.Trim())) { MessageBox.Show("请把表单输入完整!!!"); } else { var serial = this.getSerial(); String status = "待完成"; //String mysql = "insert into task(faqiren,shenheren,time,zherenren,content,sqtime,bu,serial,subject)"+ // " values ('"+textBox1.Text+"','"+textBox2.Text+"','"+dateTimePicker1.Value+"','"+textBox3.Text+"','"+richTextBox1.Text+"','"+DateTime.Now+"','"+comboBox1.Text+"','"+serial+"','"+textBox4.Text+"')"; String mysql = $"insert into task(faqiren,shenheren,time,zherenren,content,sqtime,bu,serial,subject,status,substatus) values ('{textBox1.Text}','{textBox2.Text}','{dateTimePicker1.Value.ToString("yyyy-MM-dd")}','{textBox3.Text}','{richTextBox1.Text}','{DateTime.Now}','{comboBox1.Text}','{serial}','{textBox4.Text}','{status}','0')"; var sqlConnection = mySqlCon.GetConnection(); SqlCommand cmd = mySqlCon.getCmd(mysql, sqlConnection); if (cmd.ExecuteNonQuery() != 0) { MessageBox.Show("提交成功"); sqlConnection.Close(); this.Close(); } else { MessageBox.Show("服务器正忙,请稍后再试"); } } }
public void ChangeTask() { String mysql = $"update task set changetime='{DateTime.Now}',shenheren='{textBox2.Text.ToString()}'," + $"time='{dateTimePicker1.Value.ToString("yyyy-MM-dd")}',zherenren='{textBox3.Text.ToString()}'," + $"bu='{comboBox1.Text.ToString()}',subject='{textBox4.Text.ToString()}',content='{richTextBox1.Text.ToString()}',substatus=0 " + $"where serial='{task.Serial}'"; var sqlCon = new My_SqlCon(); var connection = sqlCon.GetConnection(); var sqlCommand = sqlCon.getCmd(mysql, connection); if (sqlCommand.ExecuteNonQuery() != 0) { MessageBox.Show("修改成功"); connection.Close(); this.Close(); } else { MessageBox.Show("服务器正忙,请稍后再试"); } submitted.SetDataView(); }