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