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);
}
}
}
