public ResultObj Add(NFCCard obj)
{
ResultObj resultObj = new ResultObj();
if (IsExistSameNo(obj))
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "编号已存在。";
return(resultObj);
}
if (IsExistSameDeviceNo(obj))
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "设备已被其他NFC卡绑定过了。";
return(resultObj);
}
obj.CreateUser = obj.CreateUser;
obj.CreateTime = DateTime.Now;
obj.LastUpdateUser = obj.LastUpdateUser;
obj.LastUpdateTime = DateTime.Now;
_context.NFCCard.Add(obj);
_context.SaveChanges();
resultObj.IsSuccess = true;
return(resultObj);
}
public ResultObj Add(InspectCycles obj)
{
ResultObj resultObj = new ResultObj();
if (IsExistSameName(obj))
{
resultObj.IsSuccess = false;
resultObj.ErrMsg = "名称已存在。";
return(resultObj);
}
obj.CreateUser = obj.CreateUser;
obj.CreateTime = DateTime.Now;
obj.LastUpdateUser = obj.LastUpdateUser;
obj.LastUpdateTime = DateTime.Now;
_context.InspectCycles.Add(obj);
_context.SaveChanges();
resultObj.IsSuccess = true;
return(resultObj);
}
public ResultObj Add(InspectData obj)
{
ResultObj resultObj = new ResultObj();
obj.CreateUser = obj.CreateUser;
obj.CreateTime = DateTime.Now;
obj.LastUpdateUser = obj.LastUpdateUser;
obj.LastUpdateTime = DateTime.Now;
_context.InspectData.Add(obj);
_context.SaveChanges();
// 更新任务表：巡检完成时间，巡检完成人，是否完成
var taskObj = _context.InspectTask.Find(obj.TaskId);
// 如果未跳检，则更新巡检任务表
if (taskObj != null && obj.IsJumpInspect.Equals("0"))
{
taskObj.InspectCompleteTime = obj.InspectTime;
taskObj.InspectCompleteUser = obj.InspectUser;
taskObj.IsComplete = "2";
_context.InspectTask.Update(taskObj);
_context.SaveChanges();
// 更新nfc卡的最后巡检时间
List <NFCCard> nfcCardList = _context.NFCCard.Where(p => p.DeviceNo.Equals(obj.DeviceNo)).ToList();
if (nfcCardList.Count > 0)
{
NFCCard nfcCardObj = nfcCardList.First();
nfcCardObj.LastInspectTime = obj.InspectTime;
nfcCardObj.LastInspectUser = obj.InspectUser;
_context.NFCCard.Update(nfcCardObj);
_context.SaveChanges();
}
}
resultObj.IsSuccess = true;
return(resultObj);
}
public List <InspectTaskView> GetTaskList(string queryStr)
{
JObject jObject = new JObject();
if (string.IsNullOrEmpty(queryStr) == false)
{
jObject = JsonConvert.DeserializeObject <JObject>(queryStr);
}
string taskName = jObject.Value <string>("taskName");
string taskNo = jObject.Value <string>("taskNo");
string deviceName = jObject.Value <string>("deviceName");
string inspectName = jObject.Value <string>("inspectName");
string inspectItemName = jObject.Value <string>("inspectItemName");
string inspectTime = jObject.Value <string>("inspectTime");
string inspectUser = jObject.Value <string>("inspectUser");
//防止查询条件都不满足，先生成一个空的查询
var where = (from task in _context.InspectTask
join inspect in _context.Inspect on task.InspectNo equals inspect.InspectNo
join device in _context.Device on task.DeviceNo equals device.DeviceNo
join nfcCard in _context.NFCCard on device.DeviceNo equals nfcCard.DeviceNo
join inspectItem in _context.InspectItems on task.InspectItemNo equals inspectItem.InspectItemNo
select new InspectTaskView
{
GId = task.GId,
InspectNo = task.InspectNo,
DeviceNo = task.DeviceNo,
InspectItemNo = task.InspectItemNo,
TaskOrderNo = task.TaskOrderNo,
TaskNo = task.TaskNo,
TaskName = task.TaskName,
InspectTime = task.InspectTime,
InspectUser = task.InspectUser,
IsComplete = task.IsComplete,
InspectCompleteTime = task.InspectCompleteTime,
InspectCompleteUser = task.InspectCompleteUser,
Remark = task.Remark,
CreateTime = task.CreateTime,
CreateUser = task.CreateUser,
LastUpdateTime = task.LastUpdateTime,
LastUpdateUser = task.LastUpdateUser,
LineName = task.LineName,
InspectCycles = task.InspectCycles,
CycleStartTime = task.CycleStartTime,
CycleEndTime = task.CycleEndTime,
InspectName = inspect.InspectName,
DeviceName = device.DeviceName,
InspectItemName = inspectItem.InspectItemName,
NfcCardNo = nfcCard.NFCCardNo,
Unit = inspectItem.Unit,
ItemRemark = inspectItem.Remark,
//待下发或者待处理的数据都可以请求到,只请求当天的数据
}).Where(p => (p.IsComplete.Equals("0") || p.IsComplete.Equals("1")) && p.InspectTime.Date == DateTime.Now.Date);
if (string.IsNullOrEmpty(taskNo) == false)
{
where = where.Where(p => p.TaskNo.Contains(taskNo));
}
if (string.IsNullOrEmpty(taskName) == false)
{
where = where.Where(p => p.TaskName.Contains(taskName));
}
if (string.IsNullOrEmpty(inspectName) == false)
{
where = where.Where(p => p.InspectName.Contains(inspectName));
}
if (string.IsNullOrEmpty(deviceName) == false)
{
where = where.Where(p => p.DeviceName.Contains(deviceName));
}
if (string.IsNullOrEmpty(inspectItemName) == false)
{
where = where.Where(p => p.InspectItemName.Contains(inspectItemName));
}
if (string.IsNullOrEmpty(inspectTime) == false)
{
DateTime inpectDate = DateTime.Parse(DateTime.Parse(inspectTime).ToShortDateString());
DateTime startTime = inpectDate.AddDays(0);
DateTime endTime = inpectDate.AddDays(1);
where = where.Where(p => p.InspectTime >= startTime && p.InspectTime <= endTime);
}
if (string.IsNullOrEmpty(inspectUser) == false)
{
where = where.Where(p => p.InspectUser.Contains(inspectUser));
}
//默认结果按照任务编号、任务顺序号正序排序
where = where.OrderBy(p => p.TaskNo).ThenBy(p => p.TaskOrderNo);
//获取结果
List <InspectTaskView> dataList = where.ToList();
// 批量更新任务状态：待完成1
List <InspectTask> updateList = new List <InspectTask>();
for (int i = 0; i < dataList.Count; i++)
{
InspectTask updateObj = _context.InspectTask.Find(dataList[i].GId);
if (updateObj != null)
{
updateObj.IsComplete = "1";//待完成
updateObj.LastUpdateTime = DateTime.Now;
updateObj.LastUpdateUser = inspectUser;
updateList.Add(updateObj);
}
}
_context.InspectTask.UpdateRange(updateList);
_context.SaveChanges();
return(dataList);
}