//提交 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("请选择要修改的行"); } }