/// <summary> /// 添加班次信息 /// </summary> /// <param name="WorkShiftSetM">班次信息</param> /// <param name="WorkShiftTimeInfos">班段信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddWorkShiftInfo(WorkShiftSetModel WorkShiftSetM, string WorkShiftTimeInfos) { try { StringBuilder WorkShiftSql = new StringBuilder(); WorkShiftSql.AppendLine("INSERT INTO officedba.WorkshiftSet"); WorkShiftSql.AppendLine(" (CompanyCD "); WorkShiftSql.AppendLine(" ,WorkShiftNo "); WorkShiftSql.AppendLine(" ,WorkShiftName "); WorkShiftSql.AppendLine(" ,DayWorkLong "); WorkShiftSql.AppendLine(" ,LateAbsent "); WorkShiftSql.AppendLine(" ,ForwardAbsent "); WorkShiftSql.AppendLine(" ,WorkOvertime "); WorkShiftSql.AppendLine(" ,ModifiedDate "); WorkShiftSql.AppendLine(" ,ModifiedUserID) "); WorkShiftSql.AppendLine("VALUES "); WorkShiftSql.AppendLine(" ('" + WorkShiftSetM.CompanyCD + "' "); WorkShiftSql.AppendLine(" ,'" + WorkShiftSetM.WorkShiftNo + "' "); WorkShiftSql.AppendLine(" ,'" + WorkShiftSetM.WorkShiftName + "' "); WorkShiftSql.AppendLine(" ," + WorkShiftSetM.DayWorkLong + " "); WorkShiftSql.AppendLine(" ," + WorkShiftSetM.LateAbsent + " "); WorkShiftSql.AppendLine(" ," + WorkShiftSetM.ForwardAbsent + " "); WorkShiftSql.AppendLine(" ," + WorkShiftSetM.WorkOvertime + " "); WorkShiftSql.AppendLine(" ,'" + WorkShiftSetM.ModifiedDate + "'"); WorkShiftSql.AppendLine(" ,'" + WorkShiftSetM.ModifiedUserID + "') "); return InsertAll(WorkShiftSql.ToString(), WorkShiftTimeInfos, WorkShiftSetM.WorkShiftNo, WorkShiftSetM.CompanyCD, WorkShiftSetM.ModifiedUserID); } catch { return false; } }
/// <summary> /// 更新班次信息 /// </summary> /// <param name="WorkShiftSetM">班次信息</param> /// <param name="WorkShiftTimeInfos">班段信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateWorkShiftInfo(WorkShiftSetModel WorkShiftSetM, string WorkShiftTimeInfos) { return WorkShiftDBHelper.UpdateEquipMnetAndFitInfo(WorkShiftSetM, WorkShiftTimeInfos); }
/// <summary> /// 添加班次信息 /// </summary> /// <param name="WorkShiftSetM">班次信息</param> /// <param name="WorkShiftTimeInfos">班段信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool AddWorkShiftInfo(WorkShiftSetModel WorkShiftSetM,string WorkShiftTimeInfos) { return WorkShiftDBHelper.AddWorkShiftInfo(WorkShiftSetM, WorkShiftTimeInfos); }
/// <summary> /// 更新班次信息 /// </summary> /// <param name="WorkShiftSetM">班次信息</param> /// <param name="WorkShiftTimeInfos">班段信息</param> /// <returns>更新是否成功 false:失败,true:成功</returns> public static bool UpdateEquipMnetAndFitInfo(WorkShiftSetModel WorkShiftSetM, string WorkShiftTimeInfos) { try { StringBuilder UpdateWorkShiftSql = new StringBuilder(); UpdateWorkShiftSql.AppendLine("UPDATE officedba.WorkshiftSet"); UpdateWorkShiftSql.AppendLine("SET "); UpdateWorkShiftSql.AppendLine(" CompanyCD='" + WorkShiftSetM.CompanyCD + "' "); UpdateWorkShiftSql.AppendLine(" ,WorkShiftName='" + WorkShiftSetM.WorkShiftName + "' "); UpdateWorkShiftSql.AppendLine(" ,DayWorkLong=" + WorkShiftSetM.DayWorkLong + " "); UpdateWorkShiftSql.AppendLine(" ,LateAbsent=" + WorkShiftSetM.LateAbsent + " "); UpdateWorkShiftSql.AppendLine(" ,ForwardAbsent=" + WorkShiftSetM.ForwardAbsent + " "); UpdateWorkShiftSql.AppendLine(" ,WorkOvertime=" + WorkShiftSetM.WorkOvertime + " "); UpdateWorkShiftSql.AppendLine(" ,ModifiedDate='" + WorkShiftSetM.ModifiedDate + "' "); UpdateWorkShiftSql.AppendLine(" ,ModifiedUserID='" + WorkShiftSetM.ModifiedUserID + "' "); UpdateWorkShiftSql.AppendLine("WHERE WorkShiftNo='" + WorkShiftSetM.WorkShiftNo + "' "); return UpdateAll(UpdateWorkShiftSql.ToString(), WorkShiftTimeInfos, WorkShiftSetM.WorkShiftNo, WorkShiftSetM.CompanyCD, WorkShiftSetM.ModifiedUserID); } catch { return false; } }