8,497
社区成员
发帖
与我相关
我的任务
分享
student st = new student();
st.studentID = id;
st.names = txtName.Text.Trim();
st.@class = txtBtClass.Text.Trim();
st.graduatedSchool = txtBSchool.Text.Trim();
st.userName = Properties.Settings.Default.userName;
st.opTime = DateTime.Now;
db.students.InsertOnSubmit(st);
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
var s = from st in db.students
where st.studentID == id
select st;
studentsBindingSource.DataSource = s;
var inquey = from tu in db.tuitions
where tu.receiptID == int.Parse(maskedTxtReceptID.Text)
select tu;
foreach (var item in inquey)
{
int? id = item.studentID;
item.studentID = int.Parse(maskedTxtStudentID.Text);
item.date = dateTimePicker.Value;
item.@class = txtRClass.Text.Trim();
item.years = int.Parse(maskedTxtRYear.Text);
item.term = cmbRTerm.Text;
item.sums = int.Parse(maskedTxtRSum.Text.Trim());
item.insurance = radInsure.Checked ? 1 : 0; //保险填1
item.userName = Properties.Settings.Default.userName;
item.opTime = DateTime.Now;
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
MessageBox.Show("添加收据成功!");
// this.tuitionsDataGridView.Refresh();
var s = from st in db.students
where st.studentID == id
select st;
studentsBindingSource.DataSource = s;