/* 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(); }