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]["Sno"].ToString();
string cno = ds.Tables[0].Rows[index]["Cno"].ToString();
try
{
if (SC.StuGradeOperation.deleteStuGrade(sno, cno))
{
MessageBox.Show("删除成功!", "提示");
//binddatagrid
string Sno = this.SnoText.Text.Trim();
string Cno = this.CnoText.Text.Trim();
SC.StuGradeData data = new SC.StuGradeData();
data.Sno = Sno;
data.Cno = Cno;
try
{
ds = SC.StuGradeOperation.getStuGrade(data);
this.dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
ex.ToString();
}
}
else
{
MessageBox.Show("删除失败", "错误");
}
}
catch (Exception ex)
{
ex.ToString();
MessageBox.Show("删除失败", "错误");
}
finally
{
SCQuery_Load(sender, e);
}
}
}
}
//获取查询成绩信息
public static DataSet getStuGrade(SC.StuGradeData stuGrade)
{
string condition = "";
if (stuGrade.Sno != null && stuGrade.Sno != "")
{
condition += "and Sno='" + stuGrade.Sno + "'";
}
if (stuGrade.Cno != null && stuGrade.Cno != "")
{
condition += "and Cno='" + stuGrade.Cno + "'";
}
string sql = "select Sno,Cno, SCORE from SC where 2=2 " + condition;
return(dataAccess.GetDataSet(sql, "SC"));
}
private void btnSelect_Click(object sender, EventArgs e)
{
string Sno = this.SnoText.Text.Trim();
string Cno = this.CnoText.Text.Trim();
SC.StuGradeData data = new SC.StuGradeData();
data.Sno = Sno;
data.Cno = Cno;
try
{
ds = SC.StuGradeOperation.getStuGrade(data);
this.dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
ex.ToString();
}
//if (Sno == "" && Cno== "")
//{
// MessageBox.Show("课程号和学号不能同时为空！请输入要查询条件", "提示");
//}
//else
//{
// SqlConnection conn = new SqlConnection();
// DataSet ds = new DataSet("MIS");
// conn.ConnectionString = "server=.;database=jiaoxuedb;uid=sa;pwd=960109";
// conn.Open();
// SqlCommand cmd = new SqlCommand();
// if (Sno == "")
// cmd.CommandText = "select Student.Sname '学生姓名',SC.Cno '课程编号',Course.Cname '课程名',SC.SCORE '分数' from SC, Student, Course where SC.Sno = Student.Sno AND Course.Cno = SC.Cno AND SC.Cno = '" + Cno + "'";
// else if (Cno == "")
// cmd.CommandText = "select Student.Sname '学生姓名',SC.Cno '课程编号',Course.Cname '课程名',SC.SCORE '分数' from SC, Student, Course where SC.Sno = Student.Sno AND Course.Cno = SC.Cno AND SC.Sno = '" + Sno + "'";
// else
// cmd.CommandText = "select Student.Sname '学生姓名',SC.Cno '课程编号',Course.Cname '课程名',SC.SCORE '分数' from SC, Student, Course where SC.Sno = Student.Sno AND Course.Cno = SC.Cno AND SC.Cno = '" + Cno + "' AND SC.Sno='" + Sno + "'";
// cmd.Connection = conn;
// SqlDataAdapter sda = new SqlDataAdapter();
// sda.SelectCommand = cmd;
// SqlCommandBuilder builder = new SqlCommandBuilder(sda);
// sda.Fill(ds, "Score");
// dataGridView1.DataSource = ds.Tables["Score"];
// conn.Close();
//}
}
public InsertSC(string sno, string cno)
{
InitializeComponent();
this.sno = sno;
this.cno = cno;
if (this.sno != "" && this.cno != "")
{
SC.StuGradeData data = new SC.StuGradeData();
data.Sno = sno;
data.Cno = cno;
DataSet ds = SC.StuGradeOperation.getStuGrade(data);
this.comboBox1.Text = sno;
this.comboBox2.Text = cno;
this.textBox1.Text = ds.Tables[0].Rows[0]["SCORE"].ToString();
this.comboBox1.Enabled = false;
this.comboBox2.Enabled = false;
this.Text = "修改成绩";
}
}
//修改成绩信息
public static bool updateStuGrade(SC.StuGradeData stuGrade)
{
string sql = "update SC set SCORE=" + stuGrade.SCORE + " where Sno='" + stuGrade.Sno + "' AND Cno='" + stuGrade.Cno + "'";
return(dataAccess.ExecuteSQL(sql));
}
//插入成绩信息
public static bool insertStuGrade(SC.StuGradeData stuGrade)
{
string sql = "insert into SC(Sno,Cno,SCORE) values (" + stuGrade.Sno + ",'" + stuGrade.Cno + "'," + stuGrade.SCORE + ")";
return(dataAccess.ExecuteSQL(sql));
}
private void button1_Click(object sender, EventArgs e)
{
string sno = this.comboBox1.Text;
string cno = this.comboBox2.Text;
string score = this.textBox1.Text;
if (comboBox1.Text.Trim() == "" || comboBox2.Text.Trim() == "" || textBox1.Text == "")
{
MessageBox.Show("请输入完整信息！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (comboBox1.Text.Trim() == null || comboBox2.Text.Trim() == null || textBox1.Text.Trim() == null)
{
MessageBox.Show("请输入完整信息！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
SC.StuGradeData data = new SC.StuGradeData();
data.Sno = sno;
data.Cno = cno;
data.SCORE = score;
try
{
if (this.sno == "" || this.cno == "")
{
if (SC.StuGradeOperation.insertStuGrade(data))
{
MessageBox.Show("添加成功", "提示");
this.textBox1.Text = "";
this.comboBox1.Text = "";
this.comboBox2.Text = "";
}
else
{
MessageBox.Show("添加失败", "提示");
}
}
else
{
if (SC.StuGradeOperation.updateStuGrade(data))
{
MessageBox.Show("修改成功", "提示");
}
else
{
MessageBox.Show("修改失败", "错误");
}
}
}
catch (Exception ex)
{
ex.ToString();
MessageBox.Show("保存失败", "错误");
}
//string sql = "insert into SC(Sno,Cno,SCORE) values('" + comboBox1.Text + "','" + comboBox2.Text+ "',"+textBox1.Text+")";
//DataAccess dataAccess = new DataAccess();
//if(dataAccess.ExecuteSQL(sql))
//{
// MessageBox.Show("添加成功!", "提示");
//}else
//{
// MessageBox.Show("添加失败!", "错误");
//}
}
