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