/// <summary>
/// 更新排班信息根据开始时间
/// </summary>
/// <param name="WorkPlanSetM">排班信息</param>
/// <param name="workplanarraryinfo">排班设置</param>
/// <returns>添加是否成功 false:失败，true:成功</returns>
public static bool UpdateWorkPlanInfoByDate(WorkPlanModel WorkPlanSetM, string workplanarraryinfo)
{
try
{
string[] strarray = null;
string recorditems = "";
string[] inseritems = null;
try
{
strarray = workplanarraryinfo.Split('|');
string[] sqlarray = new string[strarray.Length];
string IsRestDay = "";
sqlarray[0] = "DELETE FROM officedba.WorkPlan WHERE CompanyCD='" + WorkPlanSetM.CompanyCD + "' and WorkGroupNo='" + WorkPlanSetM.WorkGroupNo + "'"
+ "and WorkPlanStartDate='" + WorkPlanSetM.WorkPlanStartDate + "' and WorkPlanEndDate is null";
for (int i = 0; i < strarray.Length; i++)
{
StringBuilder WorkPlanSql = new StringBuilder();
recorditems = strarray[i];
inseritems = recorditems.Split(',');
if (recorditems.Length != 0)
{
WorkPlanSetM.WorkShiftIndex = inseritems[0].ToString();
WorkPlanSetM.WorkShiftNo = inseritems[2].ToString();
IsRestDay = inseritems[3].ToString();
WorkPlanSql.AppendLine("INSERT INTO officedba.WorkPlan");
WorkPlanSql.AppendLine(" (CompanyCD ");
WorkPlanSql.AppendLine(" ,WorkGroupNo ");
WorkPlanSql.AppendLine(" ,WorkShiftIndex ");
WorkPlanSql.AppendLine(" ,WorkShiftNo ");
WorkPlanSql.AppendLine(" ,WorkPlanStartDate ");
WorkPlanSql.AppendLine(" ,ModifiedDate ");
WorkPlanSql.AppendLine(" ,IsRestDay ");
WorkPlanSql.AppendLine(" ,ModifiedUserID) ");
WorkPlanSql.AppendLine("VALUES ");
WorkPlanSql.AppendLine(" ('"+ WorkPlanSetM.CompanyCD + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.WorkGroupNo + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.WorkShiftIndex + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.WorkShiftNo + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.WorkPlanStartDate + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.ModifiedDate + "' ");
WorkPlanSql.AppendLine(" ,'"+ IsRestDay + "' ");
WorkPlanSql.AppendLine(" ,'"+ WorkPlanSetM.ModifiedUserID + "') ");
sqlarray[i] = WorkPlanSql.ToString();
}
}
SqlHelper.ExecuteTransForListWithSQL(sqlarray);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
catch
{
return(false);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 更新排班信息根据(更新上一条)
/// </summary>
/// <param name="WorkPlanSetM">更新排班信息</param>
/// <param name="workplanarraryinfo">排班设置信息</param>
/// <returns>更新是否成功 false:失败，true:成功</returns>
public static bool UpdateWorkPlanInfo(WorkPlanModel WorkPlanSetM, string workplanarraryinfo)
{
return(WorkPlanDBHelper.UpdateWorkPlanInfo(WorkPlanSetM, workplanarraryinfo));
}
