/// <summary>
/// 判断考勤卡号是否存在
/// </summary>
/// <param name="cardNo"></param>
/// <returns></returns>
public bool IsCradNoExisted(string cardNo)
{
string sql = "select count(1) from Students where CardNo=" + cardNo;
var count = (int)SQLHelper.GetSignalResult(sql);
return(count == 1 ? true : false);
}
/// <summary>
/// 修改学员信息判断考勤卡号和其他学员是否重复
/// </summary>
/// <param name="cardNo"></param>
/// <param name="studentId"></param>
/// <returns></returns>
public bool IsCradNoExisted(string cardNo, int studentId)
{
string sql = $"select count(1) from Students where CardNo={cardNo} and StudentId<>{studentId}";
var count = (int)SQLHelper.GetSignalResult(sql);
return(count == 1 ? true : false);
}
/// <summary>
/// 获取学员总数
/// </summary>
/// <returns></returns>
public int GetStudentCount()
{
string sql = "select count(1) from Students";
try
{
return((int)SQLHelper.GetSignalResult(sql));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询打卡人数
/// </summary>
/// <param name="whereSql"></param>
/// <returns></returns>
private int QuerySignAttendanceCount(string whereSql)
{
string sql = "select count(distinct CardNo) from Attendance";
sql += whereSql;
try
{
return((int)SQLHelper.GetSignalResult(sql));
}
catch (Exception ex)
{
throw ex;
}
}
