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 setDateView()
{
String mysql = $"select serial as 单号, status as 状态,subject as 会议主题,content as 项目内容,"
+ $"time as 完成时间,zherenren as 责任人 from task where ((shenheren = '{Main_Menu.userInfo.Username}' and substatus = 1) or (zherenren = '{Main_Menu.userInfo.Username}' and substatus = 0)) and status != '已结案' order by sqtime desc";
My_SqlCon mySqlCon = new My_SqlCon();
var sqlConnection = this.mySqlCon.GetConnection();
DataSet ds = mySqlCon.getSqlds(mysql, sqlConnection);
this.dataGridView1.DataSource = ds.Tables[0];
this.dataGridView1.RowHeadersVisible = false;
//设置数据表格为只读
dataGridView1.ReadOnly = true;
//不允许添加行
dataGridView1.AllowUserToAddRows = false;
//背景为白色
//不允许拖动行
dataGridView1.AllowUserToResizeColumns = false;
dataGridView1.AllowUserToResizeRows = false;
// 禁止用户改变列头的高度
dataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
//只允许选中单行
dataGridView1.MultiSelect = false;
//整行选中
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
sqlConnection.Close();
}
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();
}
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();
}
