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