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