/* summary: 支付当前学期学费
* param: termNo(学期号) ,studNo(专业号),学号(studNo)
* return: void
* author: myThis
* */
public void PayStudTuition(string termNo, string specNo, string studNo)
{
// 获得总金额
int all = GetPayAllByTermNoAndSpecNo(termNo, specNo, studNo);
// 改写学生的学费表
StudTuition reStuT = (from studtui in db.StudTuition
where studtui.studNo == studNo && studtui.termNo == termNo
select studtui).First();
// 获得学费缴纳表
Tuition reTuition = (from tuition in db.Tuition
where tuition.termNo == termNo && tuition.specNo == specNo
select tuition).First();
// 获得当前的日期 如2018-11-11
string NowData = DateTime.Now.ToString("yyyy-MM-dd");;
// 填写学费
if (reStuT != null && reTuition != null)
{
reStuT.sAccom = reTuition.accom; // 住宿费
reStuT.sBook = reTuition.book; // 书本费
reStuT.sData = NowData; // 当前日期
reStuT.sOther = reTuition.other; // 其他费(学杂费)
reStuT.sPremiun = reTuition.premiun; // 保险费
reStuT.sRealCharge = all; // 实际缴费费
reStuT.sRealPay = all; // 实际支付费
reStuT.sTuition = reTuition.tuition1; // 学费
}
// 提交数据
db.SubmitChanges();
}
/* summary: 修改学费减免与贷款信息
* param: string termNo(学期) string studNo(学号) int tuiWaiver(减免) int loans(贷款)
* return: void
* author: myThis
* */
public void SetStudTuition(string termNo, string studNo, int tuiWaiver, int loans)
{
StudTuition studTuition = (from st in db.StudTuition
where st.termNo == termNo && st.studNo == studNo
select st).First();
studTuition.sTuiWaiver = tuiWaiver;
studTuition.sLoans = loans;
db.SubmitChanges();
}
