public DataSet GetTeaDept()
{
using ( RealtimeInfo_TeacherDataAccess realTimeInfo_TeacherDataAccess = new RealtimeInfo_TeacherDataAccess() )
{
try
{
return realTimeInfo_TeacherDataAccess.GetTeaDeptInfo("");
}
catch(Exception e)
{
Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE);
return null;
}
}
}
public DataSet BuildRealtimeMorningInfo(string getDept)
{
using ( RealtimeInfo_TeacherDataAccess realTimeInfo_TeacherDataAccess = new RealtimeInfo_TeacherDataAccess() )
{
try
{
DataSet buildRealtimeTeacher = realTimeInfo_TeacherDataAccess.GetTeaDeptInfo(getDept);
DataSet dsDutyID = realTimeInfo_TeacherDataAccess.GetDutyID(DateTime.Now.ToString("HH:mm:ss"));
int teaAttNumbersInDutyAll = 0;
int teaAttOnTimeNumbersInDutyAll = 0;
int teaAttNotOnTimNumbersInDutyAll = 0;
buildRealtimeTeacher.Tables[0].Columns.AddRange(new DataColumn[]{new DataColumn("info_onTime"),new DataColumn("info_notOnTime"),
new DataColumn("info_shouldAtt"),new DataColumn("info_haveAtt"),
new DataColumn("info_absence"),new DataColumn("info_attPer")});
for ( int row=0; row<buildRealtimeTeacher.Tables[0].Rows.Count; row++ )
{
int teaAttNumbersInDuty = 0;
int teaAttOnTimeNumbersInDuty = 0;
int teaAttNotOnTimeNumbersInDuty = 0;
if (dsDutyID.Tables[0] != null && dsDutyID.Tables[0].Rows.Count > 0)
{
foreach ( DataRow dutyRow in dsDutyID.Tables[0].Rows )
{
teaAttNumbersInDuty += realTimeInfo_TeacherDataAccess.GetTeaNumbers(DateTime.Now.DayOfWeek.ToString(),dutyRow[0].ToString(),buildRealtimeTeacher.Tables[0].Rows[row][0].ToString());
realTimeInfo_TeacherDataAccess.GetTeaWorkingNumbers(dutyRow[0].ToString(),ref teaAttOnTimeNumbersInDuty,ref teaAttNotOnTimeNumbersInDuty,buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.Date);
}
int noDutyTotal = 0;
int noDutyAttend = 0;
int noDutyLeave = 0;
realTimeInfo_TeacherDataAccess.GetTeacherRealTimeInfoWithNoDuty(buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.DayOfWeek.ToString(), ref noDutyTotal, ref noDutyAttend,ref noDutyLeave);
// buildRealtimeTeacher.Tables[0].Rows[row][1] = attend; //准时
// buildRealtimeTeacher.Tables[0].Rows[row][2] = 0; //迟到
// buildRealtimeTeacher.Tables[0].Rows[row][3] = total; //应到
// buildRealtimeTeacher.Tables[0].Rows[row][4] = attend; //实到
// buildRealtimeTeacher.Tables[0].Rows[row][5] = total - attend; //缺席
// buildRealtimeTeacher.Tables[0].Rows[row][6] = total == 0 ? "0.00%" : ((double)attend/(double)total).ToString("0.00%"); //出勤率
teaAttNumbersInDuty += noDutyTotal;
teaAttOnTimeNumbersInDuty += noDutyAttend;
buildRealtimeTeacher.Tables[0].Rows[row][1] = teaAttOnTimeNumbersInDuty+" ("+((double)teaAttOnTimeNumbersInDuty/(double)teaAttNumbersInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][2] = teaAttNotOnTimeNumbersInDuty+" ("+((double)teaAttNotOnTimeNumbersInDuty/(double)teaAttNumbersInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][3] = teaAttNumbersInDuty;
buildRealtimeTeacher.Tables[0].Rows[row][4] = (teaAttOnTimeNumbersInDuty+teaAttNotOnTimeNumbersInDuty);
buildRealtimeTeacher.Tables[0].Rows[row][5] = (teaAttNumbersInDuty-teaAttOnTimeNumbersInDuty-teaAttNotOnTimeNumbersInDuty)+ " ("
+(1-((double)teaAttOnTimeNumbersInDuty+(double)teaAttNotOnTimeNumbersInDuty)/teaAttNumbersInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][6] = (((double)teaAttOnTimeNumbersInDuty+(double)teaAttNotOnTimeNumbersInDuty)/teaAttNumbersInDuty).ToString("0.00%");
buildRealtimeTeacher.Tables[0].Rows[row][1] = buildRealtimeTeacher.Tables[0].Rows[row][1].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][2] = buildRealtimeTeacher.Tables[0].Rows[row][2].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][3] = buildRealtimeTeacher.Tables[0].Rows[row][3].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][4] = buildRealtimeTeacher.Tables[0].Rows[row][4].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][5] = buildRealtimeTeacher.Tables[0].Rows[row][5].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][6] = buildRealtimeTeacher.Tables[0].Rows[row][6].ToString().Replace("非数字", "0.00%");
teaAttNumbersInDutyAll += teaAttNumbersInDuty;
teaAttOnTimeNumbersInDutyAll += teaAttOnTimeNumbersInDuty;
teaAttNotOnTimNumbersInDutyAll += teaAttNotOnTimeNumbersInDuty;
}
else
{
int noDutyTotal = 0;
int noDutyAttend = 0;
int noDutyLeave = 0;
realTimeInfo_TeacherDataAccess.GetTeacherRealTimeInfoWithNoDuty(buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.DayOfWeek.ToString(), ref noDutyTotal, ref noDutyAttend, ref noDutyLeave);
buildRealtimeTeacher.Tables[0].Rows[row][1] = noDutyAttend; //准时
buildRealtimeTeacher.Tables[0].Rows[row][2] = 0; //迟到
buildRealtimeTeacher.Tables[0].Rows[row][3] = noDutyTotal; //应到
buildRealtimeTeacher.Tables[0].Rows[row][4] = noDutyAttend; //实到
buildRealtimeTeacher.Tables[0].Rows[row][5] = noDutyTotal - noDutyAttend; //缺席
buildRealtimeTeacher.Tables[0].Rows[row][6] = noDutyTotal == 0 ? "0.00%" : ((double)noDutyAttend/(double)noDutyTotal).ToString("0.00%"); //出勤率
teaAttNumbersInDutyAll += noDutyTotal;
teaAttOnTimeNumbersInDutyAll += noDutyAttend;
teaAttNotOnTimNumbersInDutyAll = 0;
}
if ( row == buildRealtimeTeacher.Tables[0].Rows.Count - 1 )
{
DataRow newRow = buildRealtimeTeacher.Tables[0].NewRow();
newRow[0] = "[总计]";
if ( teaAttNumbersInDutyAll == 0 )
{
newRow[1] = "--";
newRow[2] = "--";
newRow[3] = "--";
newRow[4] = "--";
newRow[5] = "--";
newRow[6] = "--";
}
else
{
newRow[1] = teaAttOnTimeNumbersInDutyAll+" ("+((double)teaAttOnTimeNumbersInDutyAll/(double)teaAttNumbersInDutyAll).ToString("0.00%")+")";
newRow[2] = teaAttNotOnTimNumbersInDutyAll+" ("+((double)teaAttNotOnTimNumbersInDutyAll/(double)teaAttNumbersInDutyAll).ToString("0.00%")+")";
newRow[3] = teaAttNumbersInDutyAll;
newRow[4] = (teaAttOnTimeNumbersInDutyAll+teaAttNotOnTimNumbersInDutyAll);
newRow[5] = (teaAttNumbersInDutyAll-teaAttOnTimeNumbersInDutyAll-teaAttNotOnTimNumbersInDutyAll)+ " ("
+(1-((double)teaAttOnTimeNumbersInDutyAll+(double)teaAttNotOnTimNumbersInDutyAll)/teaAttNumbersInDutyAll).ToString("0.00%")+")";
newRow[6] = (((double)teaAttOnTimeNumbersInDutyAll+(double)teaAttNotOnTimNumbersInDutyAll)/teaAttNumbersInDutyAll).ToString("0.00%");
newRow[1] = newRow[1].ToString().Replace("(非数字)", string.Empty);
newRow[2] = newRow[2].ToString().Replace("(非数字)", string.Empty);
newRow[3] = newRow[3].ToString().Replace("(非数字)", string.Empty);
newRow[4] = newRow[4].ToString().Replace("(非数字)", string.Empty);
newRow[5] = newRow[5].ToString().Replace("(非数字)", string.Empty);
newRow[6] = newRow[6].ToString().Replace("非数字", "0.00%");
}
buildRealtimeTeacher.Tables[0].Rows.Add(newRow);
break;
}
}
return buildRealtimeTeacher;
}
catch(Exception e)
{
Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE);
return null;
}
}
}
public DataSet BuildRealtimeBackInfo(string getDept)
{
using ( RealtimeInfo_TeacherDataAccess realTimeInfo_TeacherDataAccess = new RealtimeInfo_TeacherDataAccess() )
{
try
{
DataSet buildRealtimeTeacher = realTimeInfo_TeacherDataAccess.GetTeaDeptInfo(getDept);
DataSet dsDutyID = realTimeInfo_TeacherDataAccess.GetDutyID(DateTime.Now.ToString("HH:mm:ss"));
int teaShouldLeaveAll = 0;
int teaLeaveOnTimeNumbersInDutyAll = 0;
int teaLeaveNotOnTimeNumbersInDutyAll = 0;
buildRealtimeTeacher.Tables[0].Columns.AddRange(new DataColumn[]{new DataColumn("info_leaveOnTime"),new DataColumn("info_leaveNotOnTime"),
new DataColumn("info_shouldLeave"),new DataColumn("info_remain"),
new DataColumn("info_leavePer")});
for ( int row=0; row<buildRealtimeTeacher.Tables[0].Rows.Count; row++ )
{
// int teaAttNumbersInDuty = 0;
int teaAttOnTimeNumbersInDuty = 0;
int teaAttNotOnTimeNumbersInDuty = 0;
int teaLeaveOnTimeNumbersInDuty = 0;
int teaLeaveNotOnTimeNumbersInDuty = 0;
int teaShouldLeaveInDuty = 0;
if ( dsDutyID.Tables[0].Rows.Count > 0 )
{
foreach ( DataRow dutyRow in dsDutyID.Tables[0].Rows )
{
// teaAttNumbersInDuty += realTimeInfo_TeacherDataAccess.GetTeaNumbers(DateTime.Now.DayOfWeek.ToString(),dutyRow[0].ToString(),buildRealtimeTeacher.Tables[0].Rows[row][0].ToString());
realTimeInfo_TeacherDataAccess.GetTeaWorkingNumbers(dutyRow[0].ToString(),ref teaAttOnTimeNumbersInDuty,ref teaAttNotOnTimeNumbersInDuty,buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.Date);
realTimeInfo_TeacherDataAccess.GetTeaLeaveNumbers(dutyRow[0].ToString(),ref teaLeaveOnTimeNumbersInDuty,ref teaLeaveNotOnTimeNumbersInDuty,buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.Date);
}
teaShouldLeaveInDuty = teaAttOnTimeNumbersInDuty + teaAttNotOnTimeNumbersInDuty;
int noDutyTotal = 0;
int noDutyAttend = 0;
int noDutyLeave = 0;
realTimeInfo_TeacherDataAccess.GetTeacherRealTimeInfoWithNoDuty(buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.DayOfWeek.ToString(), ref noDutyTotal, ref noDutyAttend,ref noDutyLeave);
// buildRealtimeTeacher.Tables[0].Rows[row][1] = leave; //离开
// buildRealtimeTeacher.Tables[0].Rows[row][2] = 0; //早退
// buildRealtimeTeacher.Tables[0].Rows[row][3] = attend; //应离开
// buildRealtimeTeacher.Tables[0].Rows[row][4] = attend - leave; //剩余
// buildRealtimeTeacher.Tables[0].Rows[row][5] = attend == 0 ? "0.00%" : ((double)leave/(double)leave).ToString("0.00%"); //离开率
teaLeaveOnTimeNumbersInDuty += noDutyLeave;
teaShouldLeaveInDuty += noDutyAttend;
buildRealtimeTeacher.Tables[0].Rows[row][1] = teaLeaveOnTimeNumbersInDuty+" ("+((double)teaLeaveOnTimeNumbersInDuty/(double)teaShouldLeaveInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][2] = teaLeaveNotOnTimeNumbersInDuty+" ("+((double)teaLeaveNotOnTimeNumbersInDuty/(double)teaShouldLeaveInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][3] = teaShouldLeaveInDuty; //teaAttNumbersInDuty;
buildRealtimeTeacher.Tables[0].Rows[row][4] = (teaShouldLeaveInDuty - teaLeaveOnTimeNumbersInDuty - teaLeaveNotOnTimeNumbersInDuty)+ " ("
+(1-((double)teaLeaveOnTimeNumbersInDuty+(double)teaLeaveNotOnTimeNumbersInDuty)/(double)teaShouldLeaveInDuty).ToString("0.00%")+")";
buildRealtimeTeacher.Tables[0].Rows[row][5] = (((double)teaLeaveOnTimeNumbersInDuty + (double)teaLeaveNotOnTimeNumbersInDuty)/(double)teaShouldLeaveInDuty).ToString("0.00%");
buildRealtimeTeacher.Tables[0].Rows[row][1] = buildRealtimeTeacher.Tables[0].Rows[row][1].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][2] = buildRealtimeTeacher.Tables[0].Rows[row][2].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][3] = buildRealtimeTeacher.Tables[0].Rows[row][3].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][4] = buildRealtimeTeacher.Tables[0].Rows[row][4].ToString().Replace("(非数字)", string.Empty);
buildRealtimeTeacher.Tables[0].Rows[row][5] = buildRealtimeTeacher.Tables[0].Rows[row][5].ToString().Replace("非数字", "0.00%");
teaShouldLeaveAll += teaShouldLeaveInDuty;
teaLeaveOnTimeNumbersInDutyAll += teaLeaveOnTimeNumbersInDuty;
teaLeaveNotOnTimeNumbersInDutyAll += teaLeaveNotOnTimeNumbersInDuty;
}
else
{
int noDutyTotal = 0;
int noDutyAttend = 0;
int noDutyLeave = 0;
realTimeInfo_TeacherDataAccess.GetTeacherRealTimeInfoWithNoDuty(buildRealtimeTeacher.Tables[0].Rows[row][0].ToString(),DateTime.Now.DayOfWeek.ToString(), ref noDutyTotal, ref noDutyAttend,ref noDutyLeave);
buildRealtimeTeacher.Tables[0].Rows[row][1] = noDutyLeave; //离开
buildRealtimeTeacher.Tables[0].Rows[row][2] = 0; //早退
buildRealtimeTeacher.Tables[0].Rows[row][3] = noDutyAttend; //应离开
buildRealtimeTeacher.Tables[0].Rows[row][4] = noDutyAttend - noDutyLeave; //剩余
buildRealtimeTeacher.Tables[0].Rows[row][5] = noDutyAttend == 0 ? "100%" : ((double)noDutyLeave/(double)noDutyAttend).ToString("0.00%"); //离开率
teaLeaveOnTimeNumbersInDutyAll += noDutyLeave;
teaLeaveNotOnTimeNumbersInDutyAll = 0;
teaShouldLeaveAll += noDutyAttend;
}
if ( row == buildRealtimeTeacher.Tables[0].Rows.Count - 1 )
{
DataRow newRow = buildRealtimeTeacher.Tables[0].NewRow();
newRow[0] = "[总计]";
if ( teaShouldLeaveAll == 0 )
{
newRow[1] = 0;
newRow[2] = 0;
newRow[3] = 0;
newRow[4] = 0;
newRow[5] = 0;
}
else
{
newRow[1] = teaLeaveOnTimeNumbersInDutyAll+" ("+((double)teaLeaveOnTimeNumbersInDutyAll/(double)teaShouldLeaveAll).ToString("0.00%")+")";
newRow[2] = teaLeaveNotOnTimeNumbersInDutyAll+" ("+((double)teaLeaveNotOnTimeNumbersInDutyAll/(double)teaShouldLeaveAll).ToString("0.00%")+")";
newRow[3] = teaShouldLeaveAll;
newRow[4] = (teaShouldLeaveAll - teaLeaveOnTimeNumbersInDutyAll - teaLeaveNotOnTimeNumbersInDutyAll)+ " ("
+(1-((double)teaLeaveOnTimeNumbersInDutyAll+(double)teaLeaveNotOnTimeNumbersInDutyAll)/(double)teaShouldLeaveAll).ToString("0.00%")+")";
newRow[5] = (((double)teaLeaveOnTimeNumbersInDutyAll+(double)teaLeaveNotOnTimeNumbersInDutyAll)/(double)teaShouldLeaveAll).ToString("0.00%");
newRow[1] = newRow[1].ToString().Replace("(非数字)", string.Empty);
newRow[2] = newRow[2].ToString().Replace("(非数字)", string.Empty);
newRow[3] = newRow[3].ToString().Replace("(非数字)", string.Empty);
newRow[4] = newRow[4].ToString().Replace("(非数字)", string.Empty);
newRow[5] = newRow[5].ToString().Replace("非数字", "0.00%");
}
buildRealtimeTeacher.Tables[0].Rows.Add(newRow);
break;
}
}
return buildRealtimeTeacher;
}
catch(Exception e)
{
Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE);
return null;
}
}
}
