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