/// <summary> /// 添加人员考勤设置信息 /// </summary> /// <param name="EmployeeAttendanceSetM">人员考勤信息</param> /// <param name="Employees">人员信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddEmployeeAttendance(EmployeeAttendanceSetModel EmployeeAttendanceSetM, string Employees) { try { string[] strarray = null; string recorditems = ""; string[] inseritems = null; strarray = Employees.Split(','); string[] sqlarray = new string[strarray.Length]; //sqlarray[0] = ""; 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] = 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); }