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("失败");
}
}
