/// <summary>
/// 更新排班信息根据(更新上一条)
/// </summary>
/// </summary>
/// <param name="EmployeeAttendanceSetM">人员考勤信息</param>
/// <param name="Employees">人员信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateEmployeeAttendanceInfo(EmployeeAttendanceSetModel EmployeeAttendanceSetM, string Employees)
{
try
{
string[] strarray = null;
string recorditems = "";
string[] inseritems = null;
strarray = Employees.Split(',');
string[] sqlarray = new string[strarray.Length];
sqlarray[0] = "UPDATE officedba.EmployeeAttendanceSet SET EndDate='" + EmployeeAttendanceSetM.StartDate + "',"
+ "ModifiledDate='" + EmployeeAttendanceSetM.ModifiledDate + "',ModifiledUserID='" + EmployeeAttendanceSetM.ModifiledUserID + "' "
+ " WHERE EmployeeID=" + Employees.Replace(",", "").Trim() + " and WorkGroupNo='" + EmployeeAttendanceSetM.WorkGroupNo + "'"
+ "and StartDate<'" + EmployeeAttendanceSetM.StartDate + "' and EndDate is null";
for (int i = 0; i < strarray.Length; i++)
{
StringBuilder EmployeeAttendanceSql = new StringBuilder();
recorditems = strarray[i];
inseritems = recorditems.Split(',');
if (recorditems.Length != 0)
{
EmployeeAttendanceSetM.EmployeeID = Convert.ToInt32(inseritems[0].ToString());
EmployeeAttendanceSql.AppendLine("INSERT INTO officedba.EmployeeAttendanceSet");
EmployeeAttendanceSql.AppendLine(" (CompanyCD ");
EmployeeAttendanceSql.AppendLine(" ,EmployeeID ");
EmployeeAttendanceSql.AppendLine(" ,WorkGroupNo ");
EmployeeAttendanceSql.AppendLine(" ,AttendanceType ");
EmployeeAttendanceSql.AppendLine(" ,WorkOverTimeType ");
EmployeeAttendanceSql.AppendLine(" ,WeekRestDay ");
EmployeeAttendanceSql.AppendLine(" ,MonthRestDay ");
EmployeeAttendanceSql.AppendLine(" ,StartDate ");
EmployeeAttendanceSql.AppendLine(" ,ModifiledDate ");
EmployeeAttendanceSql.AppendLine(" ,ModifiledUserID) ");
EmployeeAttendanceSql.AppendLine("VALUES ");
EmployeeAttendanceSql.AppendLine(" ('"+ EmployeeAttendanceSetM.CompanyCD + "' ");
EmployeeAttendanceSql.AppendLine(" ,"+ Employees.Replace(",", "").Trim() + " ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.WorkGroupNo + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.AttendanceType + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.WorkOverTimeType + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.WeekRestDay + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.MonthRestDay + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.StartDate + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.ModifiledDate + "' ");
EmployeeAttendanceSql.AppendLine(" ,'"+ EmployeeAttendanceSetM.ModifiledUserID + "') ");
sqlarray[i + 1] = EmployeeAttendanceSql.ToString();
}
}
SqlHelper.ExecuteTransForListWithSQL(sqlarray);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
catch
{
return(false);
}
}
/// <summary>
/// 更新排班信息根据(更新上一条)
/// </summary>
/// <param name="EmployeeAttendanceSetM">人员考勤信息</param>
/// <param name="Employees">人员信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateEmployeeAttendanceInfo(EmployeeAttendanceSetModel EmployeeAttendanceSetM, string Employees)
{
return(EmployeeAttendanceSetDBHelper.UpdateEmployeeAttendanceInfo(EmployeeAttendanceSetM, Employees));
}
/// <summary>
/// 添加人员考勤设置信息
/// </summary>
/// <param name="EmployeeAttendanceSetM">人员考勤信息</param>
/// <param name="Employees">人员信息</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool AddEmployeeAttendance(EmployeeAttendanceSetModel EmployeeAttendanceSetM, string Employees)
{
return(EmployeeAttendanceSetDBHelper.AddEmployeeAttendance(EmployeeAttendanceSetM, Employees));
}
