//获取查询学生信息
public static DataSet getStudentInfo(Student.StudentInfoData data)
{
string condition = "";
if (data.Sno != null && data.Sno != "")
{
condition += "and Sno='" + data.Sno + "'";
}
if (data.Sname != null && data.Sname != "")
{
condition += "and Sname='" + data.Sname + "'";
}
if (data.Sex != null && data.Sex != "")
{
condition += "and Sex='" + data.Sex + "'";
}
if (data.Grade != null && data.Grade != "")
{
condition += "and Grade='" + data.Grade + "'";
}
if (data.Dept != null && data.Dept != "")
{
condition += "and Dept='" + data.Dept + "'";
}
string sql = "select Sno StudentNumber,Sname StudentName, Sex,Grade,Dept Department from Student where 2=2 " + condition;
return(dataAccess.GetDataSet(sql, "Student"));
}
private void button1_Click(object sender, EventArgs e)
{
string Sno = textBox1.Text.Trim();
string Sname = textBox2.Text;
string Sex = textBox3.Text;
string Grade = textBox4.Text;
string Dept = textBox7.Text;
Student.StudentInfoData data = new Student.StudentInfoData();
data.Sno = Sno;
data.Sname = Sname;
data.Sex = Sex;
data.Grade = Grade;
data.Dept = Dept;
try
{
ds = Student.StudentInfoOperation.getStudentInfo(data);
this.dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
ex.ToString();
}
}
public InsertStudent(string flag)
{
InitializeComponent();
this.FLAG = flag;
if (flag != "")
{
Student.StudentInfoData data = new Student.StudentInfoData();
data.Sno = flag;
DataSet ds = Student.StudentInfoOperation.getStudentInfo(data);
this.textBox1.Text = flag;
this.textBox2.Text = ds.Tables[0].Rows[0]["StudentName"].ToString();
this.textBox3.Text = ds.Tables[0].Rows[0]["Sex"].ToString();
this.textBox4.Text = ds.Tables[0].Rows[0]["Grade"].ToString();
this.textBox5.Text = ds.Tables[0].Rows[0]["Department"].ToString();
this.textBox1.Enabled = false;
this.Text = "Update";
}
}
//修改学生信息
public static bool updateStudentInfo(Student.StudentInfoData data)
{
string sql = "update Student set Sname='" + data.Sname + "',Sex='" + data.Sex + "',Grade=" + data.Grade + ",Dept='" + data.Dept + "' where Sno='" + data.Sno + "'";
return(dataAccess.ExecuteSQL(sql));
}
//插入学生记录
public static bool insertStudentInfo(Student.StudentInfoData data)
{
string sql = "insert into Student(Sno,Sname,Sex,Grade,Dept) values('" + data.Sno + "','" + data.Sname + "','" + data.Sex + "'," + data.Grade + ",'" + data.Dept + "')";
return(dataAccess.ExecuteSQL(sql));
}
private void button1_Click(object sender, EventArgs e)
{
string Sno = textBox1.Text.Trim();
string Sname = textBox2.Text;
string Sex = textBox3.Text;
string Grade = textBox4.Text;
string Dept = textBox5.Text;
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "" || textBox3.Text.Trim() == "" || textBox4.Text.Trim() == "" || textBox5.Text.Trim() == "")
{
MessageBox.Show("请输入完整信息！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBox1.Text.Trim() == null || textBox2.Text.Trim() == null || textBox3.Text.Trim() == null || textBox4.Text.Trim() == null || textBox5.Text.Trim() == null)
{
MessageBox.Show("请输入完整信息！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Student.StudentInfoData data = new Student.StudentInfoData();
data.Sno = Sno;
data.Sname = Sname;
data.Sex = Sex;
data.Grade = Grade;
data.Dept = Dept;
try
{
if (FLAG == "")
{
if (Student.StudentInfoOperation.insertStudentInfo(data))
{
MessageBox.Show("添加成功", "提示");
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
}
else
{
MessageBox.Show("添加失败", "提示");
}
}
else
{
if (Student.StudentInfoOperation.updateStudentInfo(data))
{
MessageBox.Show("修改成功", "提示");
}
else
{
MessageBox.Show("修改失败", "提示");
}
}
}
catch (Exception ex)
{
ex.ToString();
MessageBox.Show("保存失败", "错误");
}
}
private void button3_Click(object sender, EventArgs e)
{
int index = this.dataGridView1.CurrentRow.Index;
if (index < 0)
{
MessageBox.Show("请选择要删除的记录！", "提示");
return;
}
else
{
if (MessageBox.Show("确定要删除吗？", "删除后无法撤回", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
string sno = ds.Tables[0].Rows[index]["StudentNumber"].ToString();
try
{
if (Student.StudentInfoOperation.deleteStudentInfo(sno))
{
MessageBox.Show("删除成功!", "提示");
//binddatagrid
string Sno = textBox1.Text.Trim();
string Sname = textBox2.Text;
string Sex = textBox3.Text;
string Grade = textBox4.Text;
string Dept = textBox7.Text;
Student.StudentInfoData data = new Student.StudentInfoData();
data.Sno = Sno;
data.Sname = Sname;
data.Sex = Sex;
data.Grade = Grade;
data.Dept = Dept;
try
{
ds = Student.StudentInfoOperation.getStudentInfo(data);
this.dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
ex.ToString();
}
}
else
{
MessageBox.Show("删除失败", "错误");
}
}
catch (Exception ex)
{
ex.ToString();
MessageBox.Show("删除失败", "错误");
}
finally
{
Student_overview_Load(sender, e);
}
}
}
}
private void Student_overview_Load(object sender, EventArgs e)
{
Student.StudentInfoData data = new Student.StudentInfoData();
ds = Student.StudentInfoOperation.getStudentInfo(data);
this.dataGridView1.DataSource = ds.Tables[0];
}
