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