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 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_CellContentClick(object sender, DataGridViewCellEventArgs e) { task = new Task(); var mySqlCon = new My_SqlCon(); var sqlConnection = mySqlCon.GetConnection(); String serial = dataGridView1.CurrentRow.Cells[0].Value.ToString(); var dr = mySqlCon.getSqlDr_Login($"select * from task where serial='{serial}'", sqlConnection); if (dr.Read()) { task.Id = dr[0].ToString(); task.Serial = dr[1].ToString(); task.Shenheren = dr[2].ToString(); task.Time = dr[3].ToString(); task.Zherenren = dr[4].ToString(); task.Content = dr[5].ToString(); task.Gonghao = dr[6].ToString(); task.Sqtime = dr[7].ToString(); task.Status = dr[8].ToString(); task.Bu = dr[9].ToString(); task.Faqiren = dr[10].ToString(); task.Timeformat = dr[11].ToString(); task.Subject = dr[12].ToString(); } var formInfo_Sub = new FormInfo_Sub(task, this); dr.Close(); sqlConnection.Close(); formInfo_Sub.ShowDialog(); }
public void SetDataView() { String mysql = $"select serial as 单号, status as 状态,subject as 会议主题,content as 项目内容," + $"time as 完成时间,zherenren as 责任人 from task where faqiren='{Main_Menu.userInfo.Username}' order by sqtime desc"; My_SqlCon mySqlCon = new My_SqlCon(); var sqlConnection = mySqlCon.GetConnection(); DataSet ds = mySqlCon.getSqlds(mysql, sqlConnection); dataGridView1.DataSource = ds.Tables[0]; /*//设置数据表格上显示的列标题 * dataGridView1.Columns[0].HeaderText = "编号"; * dataGridView1.Columns[1].HeaderText = "课程名称"; * dataGridView1.Columns[2].HeaderText = "学分"; * dataGridView1.Columns[3].HeaderText = "备注";*/ //设置数据表格为只读 dataGridView1.ReadOnly = true; //不允许添加行 dataGridView1.AllowUserToAddRows = false; //背景为白色 dataGridView1.BackgroundColor = Color.White; //只允许选中单行 dataGridView1.MultiSelect = false; //整行选中 dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; this.dataGridView1.RowHeadersVisible = false; sqlConnection.Close(); }
public void Auto_Login() { string usernameConfig = WebConfigurationManager.AppSettings["username"]; string islogined = WebConfigurationManager.AppSettings["islogined"]; string passwd = WebConfigurationManager.AppSettings["passwd"]; if (islogined == "1") { My_SqlCon sqlCon = new My_SqlCon(); var sqlConnection = sqlCon.GetConnection(); SqlDataReader dr = sqlCon.getSqlDr_Login("select * from usermanage where gh='" + usernameConfig + "'and passwd='" + passwd + "'", sqlConnection); if (dr.Read()) { String username = (string)dr[0]; Main_Menu.userInfo = new UserInfo(); Main_Menu.userInfo.Username = username; Main_Menu.userInfo.Type = (string)dr[2]; dr.Close(); sqlConnection.Close(); var thread1 = new Thread(this.openForm); thread1.Start(); } } }
private void button1_Click(object sender, EventArgs e) { var mySqlCon = new My_SqlCon(); var sqlConnection = mySqlCon.GetConnection(); if (string.IsNullOrEmpty(textBox1.Text) && String.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("请输入查询内容"); } //搜索姓名 if (!String.IsNullOrEmpty(textBox1.Text) && string.IsNullOrEmpty(textBox2.Text)) { var dataSet = mySqlCon.getSqlds($"select username as 姓名,gh as 工号 from usermanage where username like '%{textBox1.Text}%'", sqlConnection); dataGridView1.DataSource = dataSet.Tables[0]; } //搜索工号 if (!string.IsNullOrEmpty(textBox2.Text) && string.IsNullOrEmpty(textBox1.Text)) { var dataSet = mySqlCon.getSqlds($"select username as 姓名,gh as 工号 from usermanage where gh='{textBox2.Text}'", sqlConnection); dataGridView1.DataSource = dataSet.Tables[0]; } if (!string.IsNullOrEmpty(textBox1.Text) && !String.IsNullOrEmpty(textBox2.Text)) { var dataSet = mySqlCon.getSqlds($"select username as 姓名,gh as 工号 from usermanage where username like '%{textBox1.Text}%' and gh='{textBox2.Text}'", sqlConnection); dataGridView1.DataSource = dataSet.Tables[0]; } sqlConnection.Close(); }
private void ChooseUser_Load(object sender, EventArgs e) { string mysql = "select username as 姓名 ,gh as 工号 from usermanage"; My_SqlCon mySqlCon = new My_SqlCon(); var sqlConnection = mySqlCon.GetConnection(); var dataSet = mySqlCon.getSqlds(mysql, sqlConnection); dataGridView1.DataSource = dataSet.Tables[0]; sqlConnection.Close(); }
/** * 生成单号 */ private String getSerial() { String mysql = ""; String serialString = null; var connection = mySqlCon.GetConnection(); if (comboBox1.Text == "电子线事业部") { mysql = "select max(left(right(serial,9),6)),MAX(right(serial,9)) from task where serial like 'HLCQ%'"; DataSet dataSet = mySqlCon.getSqlds(mysql, connection); String maxSer = dataSet.Tables[0].Rows[0][0].ToString(); String maxSerL = dataSet.Tables[0].Rows[0][1].ToString(); if (maxSer.Equals(DateTime.Now.ToString("yyMMdd"))) { serialString = "HLCQ" + (Convert.ToInt32(maxSerL) + 1); } else { serialString = "HLCQ" + DateTime.Now.ToString("yyMMdd") + "001"; } } else if (comboBox1.Text == "声学事业部") { mysql = "select max(left(right(serial,9),6)),MAX(right(serial,9)) from task where serial like 'HLSX%'"; DataSet dataSet = mySqlCon.getSqlds(mysql, connection); String maxSer = dataSet.Tables[0].Rows[0][0].ToString(); String maxSerL = dataSet.Tables[0].Rows[0][1].ToString(); if (maxSer.Equals(DateTime.Now.ToString("yyMMdd"))) { serialString = "HLSX" + (Convert.ToInt32(maxSerL) + 1); } else { serialString = "HLSX" + DateTime.Now.ToString("yyMMdd") + "001"; } } connection.Close(); return(serialString); }
public bool Sql() { My_SqlCon sqlCon = new My_SqlCon(); var sqlConnection = sqlCon.GetConnection(); SqlDataReader dr = sqlCon.getSqlDr_Login("select * from usermanage where gh='" + textBox_UserName.Text + "'and passwd='" + textBox_Passwd.Text + "'", sqlConnection); if (dr.Read()) { String username = (string)dr[0]; Main_Menu.userInfo = new UserInfo(); Main_Menu.userInfo.Username = username; Main_Menu.userInfo.Type = (string)dr[2]; return(true); } dr.Close(); sqlConnection.Close(); return(false); }
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(); }