/// <summary>
/// 插入员工日常考勤签到信息
/// </summary>
/// <param name="DailyAttendanceM">签到信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool AddDailyAttendanceSignIn(DailyAttendanceModel DailyAttendanceM)
{
try
{
#region 日常考勤签到信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.DailyAttendance");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,EmployeeID ");
sql.AppendLine(" ,Date ");
sql.AppendLine(" ,StartTime ");
sql.AppendLine(" ,WorkShiftTimeID ");
sql.AppendLine(" ,DelayTimeLong ");
sql.AppendLine(" ,IsDelay ");
sql.AppendLine(" ,EmployeeAttendanceSetID ");
sql.AppendLine(" ,SignInRemark) ");
sql.AppendLine("VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@EmployeeID ");
sql.AppendLine(" ,@Date ");
sql.AppendLine(" ,@StartTime ");
sql.AppendLine(" ,@WorkShiftTimeID ");
sql.AppendLine(" ,@DelayTimeLong ");
sql.AppendLine(" ,@IsDelay ");
sql.AppendLine(" ,@EmployeeAttendanceSetID ");
sql.AppendLine(" ,@Remark) ");
#endregion
#region 日常考勤签到信息参数设置
SqlParameter[] param;
param = new SqlParameter[9];
param[0] = SqlHelper.GetParameter("@CompanyCD", DailyAttendanceM.CompanyCD);
param[1] = SqlHelper.GetParameter("@EmployeeID", DailyAttendanceM.EmployeeID);
param[2] = SqlHelper.GetParameter("@Date", DailyAttendanceM.Date);
param[3] = SqlHelper.GetParameter("@StartTime", DailyAttendanceM.StartTime);
param[4] = SqlHelper.GetParameter("@WorkShiftTimeID", DailyAttendanceM.WorkShiftTimeID);
param[5] = SqlHelper.GetParameter("@DelayTimeLong", DailyAttendanceM.DelayTimeLong);
param[6] = SqlHelper.GetParameter("@IsDelay", DailyAttendanceM.IsDelay);
param[7] = SqlHelper.GetParameter("@EmployeeAttendanceSetID", DailyAttendanceM.EmployeeAttendanceSetID);
param[8] = SqlHelper.GetParameter("@Remark", DailyAttendanceM.SignInRemark);
#endregion
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 更新用户补签到签退信息
/// </summary>
/// <param name="DailyAttendanceM">签退信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateExtraDailyAttendanceSignIn_Out(DailyAttendanceModel DailyAttendanceM)
{
try
{
#region 日常考勤签到信息SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.DailyAttendance");
sql.AppendLine(" SET StartTime=@StartTime ");
sql.AppendLine(" ,EndTime=@EndTime ");
sql.AppendLine(" ,DelayTimeLong=@DelayTimeLong ");
sql.AppendLine(" ,ForWardOffTimeLong=@ForWardOffTimeLong ");
sql.AppendLine(" ,IsDelay=@IsDelay ");
sql.AppendLine(" ,IsForwarOff=@IsForwarOff ");
sql.AppendLine(" ,EmployeeAttendanceSetID=@EmployeeAttendanceSetID ");
sql.AppendLine(" ,IsExtraSignIn='1' ");
sql.AppendLine(" ,IsExtraSignOut='1' ");
sql.AppendLine(" ,ProcessSignInReason=@ProcessSignInReason ");
sql.AppendLine(" ,ProcessSignOutReason=@ProcessSignOutReason ");
sql.AppendLine(" ,ProcessUserID=@ProcessUserID ");
sql.AppendLine(" ,ProcessDateTime=@ProcessDateTime ");
sql.AppendLine(" WHERE CompanyCD=@CompanyCD ");
sql.AppendLine(" AND EmployeeID=@EmployeeID ");
sql.AppendLine(" AND Date=@Date ");
sql.AppendLine(" AND WorkShiftTimeID=@WorkShiftTimeID ");
#endregion
#region 日常考勤签到信息参数设置
SqlParameter[] param;
param = new SqlParameter[15];
param[0] = SqlHelper.GetParameter("@CompanyCD", DailyAttendanceM.CompanyCD);
param[1] = SqlHelper.GetParameter("@EmployeeID", DailyAttendanceM.EmployeeID);
param[2] = SqlHelper.GetParameter("@Date", DailyAttendanceM.Date);
param[3] = SqlHelper.GetParameter("@StartTime", DailyAttendanceM.StartTime);
param[4] = SqlHelper.GetParameter("@EndTime", DailyAttendanceM.EndTime);
param[5] = SqlHelper.GetParameter("@WorkShiftTimeID", DailyAttendanceM.WorkShiftTimeID);
param[6] = SqlHelper.GetParameter("@DelayTimeLong", DailyAttendanceM.DelayTimeLong);
param[7] = SqlHelper.GetParameter("@ForWardOffTimeLong", DailyAttendanceM.ForWardOffTimeLong);
param[8] = SqlHelper.GetParameter("@IsDelay", DailyAttendanceM.IsDelay);
param[9] = SqlHelper.GetParameter("@IsForwarOff", DailyAttendanceM.IsForwarOff);
param[10] = SqlHelper.GetParameter("@EmployeeAttendanceSetID", DailyAttendanceM.EmployeeAttendanceSetID);
param[11] = SqlHelper.GetParameter("@ProcessSignInReason", DailyAttendanceM.ProcessSignInReason);
param[12] = SqlHelper.GetParameter("@ProcessSignOutReason", DailyAttendanceM.ProcessSignInReason);
param[13] = SqlHelper.GetParameter("@ProcessUserID", DailyAttendanceM.ProcessUserID);
param[14] = SqlHelper.GetParameter("@ProcessDateTime", DailyAttendanceM.ProcessDateTime);
#endregion
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 补签到前的判断
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetDailyInfoBeforeExtraSign(DailyAttendanceModel DailyAttendanceM)
{
string sql = "select * from officedba.DailyAttendance "
+ "WHERE CompanyCD='" + DailyAttendanceM.CompanyCD + "' AND EmployeeID=" + DailyAttendanceM.EmployeeID + " AND "
+ "Date='" + DailyAttendanceM.Date + "' AND WorkShiftTimeID=" + DailyAttendanceM.WorkShiftTimeID + "";
return SqlHelper.ExecuteSql(sql);
}
/// <summary>
/// 更新用户签退信息
/// </summary>
/// <param name="DailyAttendanceM">签退信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateailyAttendanceSignOut(DailyAttendanceModel DailyAttendanceM)
{
try
{
#region 日常考勤签退信息SQL拼写
string sql = "update officedba.DailyAttendance SET EndTime='" + DailyAttendanceM.EndTime + "',"
+"SignOutRemark='" + DailyAttendanceM .SignOutRemark+ "',"
+ "ForWardOffTimeLong='" + DailyAttendanceM.ForWardOffTimeLong + "',"
+ "IsForwarOff='" + DailyAttendanceM.IsForwarOff + "', "
+ "EmployeeAttendanceSetID='" + DailyAttendanceM.EmployeeAttendanceSetID + "' "
+" where id="
+"(select isnull(max(id),0) as IsExist from officedba.DailyAttendance "
+ "where CompanyCD='" + DailyAttendanceM.CompanyCD + "' and EmployeeID=" + DailyAttendanceM .EmployeeID+ " "
+"and Date=convert(varchar(10),convert(datetime,getdate()),120) "
+"and StartTime is not null and EndTime is null)";
#endregion
SqlHelper.ExecuteTransSql(sql.ToString());
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
catch
{
return false;
}
}
/// <summary>
/// 更新用户签退信息
/// </summary>
/// <param name="DailyAttendanceM">签退信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateailyAttendanceSignOut(DailyAttendanceModel DailyAttendanceM)
{
return DailyAttendanceDBHelper.UpdateailyAttendanceSignOut(DailyAttendanceM);
}
/// <summary>
/// 插入员工日常考勤签到信息
/// </summary>
/// <param name="DailyAttendanceM">签到信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool AddDailyAttendanceSignIn(DailyAttendanceModel DailyAttendanceM)
{
return DailyAttendanceDBHelper.AddDailyAttendanceSignIn(DailyAttendanceM);
}