/// <summary>
/// 是否已登记考勤
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="StaffId">职员编号</param>
/// <param name="AttendanceTime">考勤时间</param>
/// <param name="AttendanceType">考情类型</param>
/// <param name="AttendanceId">考勤id，新增时AttendanceId=""</param>
/// <returns></returns>
public bool ExistsNum(string CompanyId, string StaffId, DateTime AttendanceTime, EyouSoft.Model.EnumType.GovStructure.AttendanceType AttendanceType, string AttendanceId)
{
if (!string.IsNullOrEmpty(StaffId) && !string.IsNullOrEmpty(CompanyId) && AttendanceTime != null && AttendanceId != null)
{
return(dal.ExistsNum(CompanyId, StaffId, AttendanceTime, AttendanceType, AttendanceId));
}
return(false);
}
/// <summary>
/// 是否已登记考勤(0准点 1迟到 2早退 3旷工)
/// 如果 准点 就不能 迟到 矿工
/// 如果 迟到 就不能 准点 矿工
/// 如果 早退 就不能 矿工
/// 如果 矿工 就不能 准点 迟到 早退
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="StaffId">职员编号</param>
/// <param name="AttendanceTime">考勤时间</param>
/// <param name="AttendanceType">考情类型</param>
/// <param name="AttendanceId">考勤id，新增时AttendanceId=""</param>
/// <returns></returns>
public bool ExistsNum(string CompanyId, string StaffId, DateTime AttendanceTime, EyouSoft.Model.EnumType.GovStructure.AttendanceType AttendanceType, string AttendanceId)
{
string StrSql = "SELECT Count(1) FROM tbl_GovAttendance WHERE CompanyId=@CompanyId AND StaffId=@StaffId AND datediff(dd, @AttendanceTime, AttendanceTime) = 0 ";
//if (AttendanceType.ToString() == "准点" || AttendanceType.ToString() == "迟到")
//{
// StrSql += " AND (AttendanceType=0 or AttendanceType=1 or AttendanceType=3) ";
//}
//if (AttendanceType.ToString() == "早退")
//{
// StrSql += " AND (AttendanceType=2 or AttendanceType=3) ";
//}
//if (AttendanceType.ToString() == "旷工")
//{
// StrSql += " AND (AttendanceType=0 or AttendanceType=1 or AttendanceType=2 or AttendanceType=3) ";
//}
if (AttendanceId.Trim() != "")
{
StrSql += " AND [AttendanceId]<>@AttendanceId";
}
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
if (AttendanceId.Trim() != "")
{
this._db.AddInParameter(dc, "AttendanceId", DbType.AnsiStringFixedLength, AttendanceId);
}
this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, CompanyId);
this._db.AddInParameter(dc, "StaffId", DbType.AnsiStringFixedLength, StaffId);
this._db.AddInParameter(dc, "AttendanceTime", DbType.DateTime, AttendanceTime);
this._db.AddInParameter(dc, "AttendanceType", DbType.Byte, (int)AttendanceType);
return(EyouSoft.Toolkit.DAL.DbHelper.Exists(dc, _db));
}
