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