//提交
private void btnOk_Click(object sender, EventArgs e)
{
List <SqlParameter> list = new List <SqlParameter>();
ClassInformation cf = new ClassInformation();
cf.Id = Convert.ToInt32(txtId.Text);
cf.StudentNumber = txtNumber.Text.ToString();
cf.CourseId = txtBh.Text.ToString();
cf.Credit = txtXf.Text.ToString();
cf.CNONumber = txtKch.Text.ToString();
SqlParameter[] ps =
{
new SqlParameter("@Number", cf.StudentNumber),
new SqlParameter("@CourseId", cf.CourseId),
new SqlParameter("@CNONumber", cf.CNONumber),
new SqlParameter("@Credit", cf.Credit)
};
list.AddRange(ps);
string sql = "";
if (p == 2)
{
list.Add(new SqlParameter("@id", cf.Id));
sql = "update 课程信息表 set 学号=@Number,课程编号=@CourseId,课程号=@CNONumber,学分=@Credit where id=@id";
}
else if (p == 1)
{
sql = "insert into 课程信息表 (学号,课程编号,课程号,学分) values (@StudentNumber,@CourseId,@CNONumber,@Credit)";
}
int r = SqlHelper.ExecuteNonQuery(sql, list.ToArray());
MessageBox.Show(r > 0?"操作成功！":"操作失败");
this.Close();
}
/// <summary>
/// 触发事件,并且判断是增加还是修改,修改的话传值
/// </summary>
/// <param name="sender"></param>
/// <param name="args"></param>
public void SetText(object sender, EventArgs args)
{
EventArg ea = args as EventArg;
this.p = ea.p;
foreach (Control item in this.Controls)
{
if (item is TextBox)
{
TextBox txt = item as TextBox;
txt.Text = "";
}
}
if (this.p == 1)
{
}
else if (this.p == 2)
{
ClassInformation cf = ea.obj as ClassInformation;
txtId.Text = cf.Id.ToString();
txtNumber.Text = cf.StudentNumber.ToString();
txtXf.Text = cf.Credit.ToString();
txtBh.Text = cf.CourseId.ToString();
txtKch.Text = cf.CNONumber.ToString();
}
}
private void btnUpdater_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
ClassInformation cf = new ClassInformation();
cf.StudentNumber = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
cf.CourseId = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
cf.CNONumber = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
cf.Credit = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
cf.Id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value);
ea.obj = cf;
ShowAddAndUpdate(2);
}
else
{
MessageBox.Show("请选择要修改的行");
}
}
