public void UpdateCurrentWorkingData(WorkingEntity workingEntity) { StringBuilder query = new StringBuilder(); var parameters = new List <SqlParameter>(); query.AppendLine("update"); query.AppendLine(" [KGWS].[dbo].[Working]"); query.AppendLine("set [isCurrent]='false'"); query.AppendLine("where"); query.AppendLine(" [workTitleId]=@workTitleId"); query.AppendLine("and"); query.AppendLine(" [workerId]=@workerId"); parameters.Clear(); parameters.Add(new SqlParameter("@workTitleId", workingEntity.WorkTitleId)); parameters.Add(new SqlParameter("@workerId", workingEntity.WorkerId)); SQLServerHelper.Execute(query.ToString(), parameters.ToArray()); query.Clear(); query.AppendLine("update"); query.AppendLine(" [KGWS].[dbo].[Working]"); query.AppendLine("set [isCurrent]='true'"); query.AppendLine("where"); query.AppendLine(" [workTitleId]=@workTitleId"); query.AppendLine("and"); query.AppendLine(" [workerId]=@workerId"); query.AppendLine("and"); query.AppendLine(" [workOpId]=@workOpId"); parameters.Clear(); parameters.Add(new SqlParameter("@workTitleId", workingEntity.WorkTitleId)); parameters.Add(new SqlParameter("@workerId", workingEntity.WorkerId)); parameters.Add(new SqlParameter("@workOpId", workingEntity.WorkOpId)); SQLServerHelper.Execute(query.ToString(), parameters.ToArray()); }
public void UpdateWorkingData(WorkingEntity workingEntity) { StringBuilder query = new StringBuilder(); var parameters = new List <SqlParameter>(); query.AppendLine("update"); query.AppendLine(" [KGWS].[dbo].[Working]"); query.AppendLine("set [isDone]='true'"); query.AppendLine("where"); query.AppendLine(" [id]=@id"); parameters.Clear(); parameters.Add(new SqlParameter("@id", workingEntity.Id)); SQLServerHelper.Execute(query.ToString(), parameters.ToArray()); }
private bool IsWait(WorkingEntity workingEntity) { var countIsSync = Workings.Value.ToList().Where(x => x.WorkOpId == workingEntity.WorkOpId - 1 && x.IsSync == true && x.IsDone == true && x.WorkerId == workingEntity.WorkerId).Count(); if (countIsSync != 0) { var count = Workings.Value.ToList().Where(x => x.WorkOpId == workingEntity.WorkOpId - 1 && x.IsSync == true && x.IsDone == false).Count(); if (count == 0) { return(false); } else { return(true); } } return(false); }