public string GetAbsDetail(int stuNumber, DateTime getDate) { string absDetail = string.Empty; DataSet dsAbsDetail; using (StuVisitInfoDataAccess stuVisitInfoDataAcess = new StuVisitInfoDataAccess()) { try { dsAbsDetail = stuVisitInfoDataAcess.SetAbsentDaysInMonth(stuNumber, getDate); absDetail = "该幼儿本月连续缺勤2天累积天数为: " + stuVisitInfoDataAcess.GetAbsSum.ToString() + "天!" + "\t\t具体情况为:\t\t\t\t\t"; foreach (DataRow absDetailRow in dsAbsDetail.Tables[0].Rows) { absDetail += "统计日期: " + Convert.ToDateTime(absDetailRow[1]).ToString("yyyy-MM-dd") + "\t\t\t\t统计结果: " + "该幼儿从上个出勤日截止到统计日" + "\t\t\t连续缺勤 " + absDetailRow[2].ToString() + " 天\t\t\t\t"; } } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); return(null); } } return(absDetail); }
public void DoAbsenceUpdate() { using (StuVisitInfoDataAccess stuVisitInfoDataAccess = new StuVisitInfoDataAccess()) { try { stuVisitInfoDataAccess.DoAbsenceInfoUpdate(stuVisit); } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); } } }
public DataSet Get2DaysAbsence(string getGrade, string getClass, DateTime getDate) { using (StuVisitInfoDataAccess stuVisitInfoDataAccess = new StuVisitInfoDataAccess()) { try { return(stuVisitInfoDataAccess.Set2DaysAbs(getGrade, getClass, getDate)); } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); return(null); } } }
public int DoAbsenceInfoInsert() { using (StuVisitInfoDataAccess stuVisitInfoDataAccess = new StuVisitInfoDataAccess()) { try { return(stuVisitInfoDataAccess.DoAbsenceInfoInsert(stuVisit)); } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); return(-1); } } }
public DataSet GetAbsenceDetail(string getGrade, string getClass, string getName, string getNumber, DateTime getBegDate, DateTime getEndDate) { using (StuVisitInfoDataAccess stuVisitInfoDataAccess = new StuVisitInfoDataAccess()) { try { return(stuVisitInfoDataAccess.SetAbsenceDetail(getGrade, getClass, getName, getNumber, getBegDate, getEndDate)); } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); return(null); } } }