public tb_Register GetRegisterModel(int id) { tb_Register result = null; using (SchoolContext context = new SchoolContext()) { result = context.tb_Register.FirstOrDefault(x => x.Id == id); } return(result); }
public int UpdateRegister(tb_Register reg) { int result = 0; using (SchoolContext context = new SchoolContext()) { var dataReg = context.tb_Register.FirstOrDefault(x => x.Id == reg.Id); dataReg.Money = reg.Money; dataReg.States = reg.States; // dataReg.StudentId = reg.StudentId; dataReg.Year = reg.Year; result = context.SaveChanges(); } return(result); }
public int InsertRegister(tb_student student, tb_Register reg) { int result = 0; using (SchoolContext context = new SchoolContext()) { if (student.Id > 0) { var dataStudent = context.tb_student.FirstOrDefault(x => x.Id == student.Id); dataStudent.Name = student.Name; dataStudent.Sex = student.Sex; dataStudent.Contact = student.Contact; dataStudent.Address = student.Address; dataStudent.Description = student.Description; } else { context.tb_student.Add(student); } if (reg.Id > 0) { var dataReg = context.tb_Register.FirstOrDefault(x => x.Id == reg.Id); dataReg.Money = reg.Money; dataReg.States = reg.States; dataReg.Year = reg.Year; dataReg.CourseId = reg.CourseId; dataReg.GradeId = reg.GradeId; } else { reg.Student = student; reg.Course = context.tb_course.FirstOrDefault(x => x.Id == reg.CourseId); reg.Grade = context.tb_grade.FirstOrDefault(x => x.Id == reg.GradeId); context.tb_Register.Add(reg); } result = context.SaveChanges(); } return(result); }
private void btnOK_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtStudentName.Text)) { MessageBox.Show("请输入学生姓名!"); return; } if (string.IsNullOrWhiteSpace(txtMoney.Text)) { MessageBox.Show("请输入金额!"); return; } if (cbxYear.SelectedValue.ToInt() == 0) { MessageBox.Show("请选择入学年份!"); return; } if (cbxGrade.SelectedValue.ToInt() == 0) { MessageBox.Show("请选择入学年级!"); return; } if (cbxCourse.SelectedValue.ToInt() == 0) { MessageBox.Show("请选择入学班类!"); return; } if (cbxStates.SelectedValue.ToInt() == -1) { MessageBox.Show("请选择缴费状态!"); return; } try { tb_student student = new tb_student(); student.Id = _studentId; student.Address = txtAddress.Text.Trim(); student.Contact = txtPhone.Text.Trim(); student.Description = txtRemarks.Text.Trim(); student.Name = txtStudentName.Text.Trim(); student.Sex = radioButton1.Checked ? 1 : 0; tb_Register reg = new tb_Register(); reg.Id = _regId; reg.CourseId = cbxCourse.SelectedValue.ToInt(); reg.CreateAt = DateTime.Now; reg.GradeId = cbxGrade.SelectedValue.ToInt(); reg.Money = txtMoney.Text.ToToDecimal(); reg.States = cbxStates.SelectedValue.ToInt(); reg.Year = cbxYear.SelectedValue.ToInt(); if (service.InsertRegister(student, reg) > 0) { MessageBox.Show("成功"); DialogResult = DialogResult.OK; } else { MessageBox.Show("失败"); } } catch (Exception ex) { MessageBox.Show("失败"); } }