private void skinButton1_Click(object sender, EventArgs e)
{
if (skinTextBox1.Text != "")
{
//string sql = "insert into student(sno,sname,ssex,sclass,zno,Admission_time,Graduation_time,inschool) values('" + skinTextBox1.Text.ToString() + "','"
// + skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','" + skinTextBox3.Text + "','"
//+ skinComboBox2.SelectedItem + "','" + dateTimePicker1.Value + "','"
//+ dateTimePicker2.Value + "'," + skinComboBox3.SelectedItem + ")";
string sql = "insert into student(sno,sname,ssex,sclass,zno,Admission_time,Graduation_time,inschool) values('" + skinTextBox1.Text + "','"
+ skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','" + skinTextBox3.Text + "','"
+ skinComboBox2.SelectedItem + "','" + dateTimePicker1.Value + "','"
+ dateTimePicker2.Value + "'," + skinComboBox3.SelectedItem + ")";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("新建成功！");
}
else
{
MessageBox.Show("创建失败！");
}
}
else
{
MessageBox.Show("信息输入不全！");
}
}
private void skinDataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
//获取行号
int rowindex = e.RowIndex;
string value0 = skinDataGridView1.Rows[rowindex].Cells[0].Value.ToString();
string value1 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString();
string value2 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString();
string value3 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString();
string sql = "UPDATE Teacher_teaching SET lesson_time = '" + value3 + "' WHERE tno = '" + value0 + "' and cno = '" + value1 + "'";
//string sql = "update grade set grade='" + value3 + "' where sno='" + value0 + "'and cno='" + value1 + "'and tno='" + value2 + "'";
if (op.OPSQL(sql))
{
//修改成功
label1.Text = "更新课表信息成功!! 职工号：" + value0 + " 行号：" + rowindex;
//MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("更新课表信息成功!!职工号：" + value0 + " 行号：" + rowindex);
label1.Text = "更新课表信息失败!! 职工号：" + value0 + " 行号：" + rowindex;
}
}
private void skinButton1_Click(object sender, EventArgs e)
{
if (skinTextBox1.Text != "")
{
string sql = "UPDATE teacher SET tno = '" + skinTextBox1.Text + "',tname = '" + skinTextBox2.Text + "', tsex = '" + skinComboBox1.SelectedItem + "', tduties='" + skinComboBox2.SelectedItem + "' WHERE tno = '" + skinTextBox1.Text + "'";
//string sql = "insert into student(sno,sname,ssex,date,nation,nativeplace,grade,profession,scholarship) values('" + txtID.Text + "','" + txtName.Text + "','" + comboSex.SelectedItem + "','" + dateTime.Value + "','" + txtNation.Text + "','" + txtNative.Text + "','" + txtScore.Text + "','" + comboMajor.SelectedItem + "','" + txtGrant.Text + "')";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("更新成功！");
}
else
{
MessageBox.Show("更新失败！");
}
}
else
{
MessageBox.Show("请输入要修改的职工号");
}
}
private void skinDataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
//获取行号
int rowindex = e.RowIndex;
string value0 = skinDataGridView1.Rows[rowindex].Cells[0].Value.ToString();
string value1 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString();
string value2 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString();
string value3 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString();
string value4 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString();
string value5 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString();
string value6 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString();
string value7 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString();
// int value7 = int.Parse(skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString());
string sql = "UPDATE student SET sno='" + value0 + "',sname = '"
+ value1 + "',ssex = '"
+ value2 + "',sclass = '"
+ value3 + "',zno = '"
+ value4 + "',Admission_time = '"
+ value5 + "',Graduation_time = '"
+ value6 + "',inschool = "
+ value7 + " WHERE sno = '"
+ value0 + "'";
//string sql = "update grade set grade='" + value3 + "' where sno='" + value0 + "'and cno='" + value1 + "'and tno='" + value2 + "'";
if (op.OPSQL(sql))
{
//修改成功
label1.Text = "更新学生信息成功!! 学号：" + value0 + " 行号：" + rowindex;
//MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("更新学生信息成功!!学号：" + value0 + " 行号：" + rowindex);
label1.Text = "更新学生信息失败!! 学号：" + value0 + " 行号：" + rowindex;
}
}
private void skinButton1_Click(object sender, EventArgs e)
{
if (skinTextBox1.Text != "")
{
string sql = "insert into teacher(tno,tname,tsex,tduties) values('" + skinTextBox1.Text + "','"
+ skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','"
+ skinComboBox2.SelectedItem + "')";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("新建成功！");
}
else
{
MessageBox.Show("创建失败！");
}
}
else
{
MessageBox.Show("信息输入不全！");
}
}
