public int IsNullMachinesInfo(MachinesInfo model)
{
//设备代码
if (string.IsNullOrEmpty(model.MachineCode))
{
return(-1);
}
//设备名称
if (string.IsNullOrEmpty(model.MachineName))
{
return(-2);
}
////品牌
//if (string.IsNullOrEmpty(model.EquipBrand))
// return -3;
////部门
//if (model.DepartmentID==0)
// return -4;
//工艺类型
if (string.IsNullOrEmpty(model.TaskType))
{
return(-5);
}
return(0);
}
public string GenerateCode(string TaskType, string _FirstLetter = "")
{
string _Code = "";
if (string.IsNullOrEmpty(_FirstLetter))
{
if (TaskType.Contains("1") || TaskType.Contains("4"))
{
_FirstLetter = "C";
}
else if (TaskType.Contains("2"))
{
_FirstLetter = "E";
}
else if (TaskType.Contains("3"))
{
_FirstLetter = "W";
}
else if (TaskType.Contains("6"))
{
_FirstLetter = "G";
}
else if (TaskType.Contains("100"))
{
_FirstLetter = "Q";
}
else
{
_FirstLetter = "Oth";
}
}
int _maxNum = 0;
int _curNum = 0;
MachinesInfo dbEntry = _context.MachinesInfo.Where(m => m.MachineCode.Contains(_FirstLetter)).OrderByDescending(m => m.MachineCode).FirstOrDefault();
try
{
if (dbEntry != null)
{
_maxNum = Convert.ToInt32(dbEntry.MachineCode.Substring(1));
}
}
catch
{
_maxNum = 100;
}
_curNum = _maxNum + 1;
if (_curNum < 10)
{
_Code = _FirstLetter + "0" + _curNum.ToString();
}
else
{
_Code = _FirstLetter + _curNum.ToString();
}
return(_Code);
}
public MachinesInfo GetMInfoByCode(string MachineCode)
{
MachinesInfo dbEntry = _context.MachinesInfo.Where(m => m.MachineCode == MachineCode).FirstOrDefault();
if (dbEntry != null)
{
return(dbEntry);
}
return(null);
}
public bool IsInvalidMInfo(string MCode)
{
MachinesInfo dbEntry = _context.MachinesInfo.Where(m => m.MachineCode.ToUpper() == MCode.ToUpper() && m.IsActive == false).FirstOrDefault();
if (dbEntry != null)
{
return(true);
}
return(false);
}
public JsonResult Service_Get_MachinesInfo(string Code = "")
{
MachinesInfo _machinesinfo = _machinesinfoRepository.GetMInfoByCode(Code);
if (_machinesinfo != null)
{
return(Json(_machinesinfo, JsonRequestBehavior.AllowGet));
}
return(null);
}
public int Service_Del_MachinesInfo(string MCode)
{
MachinesInfo dbEntry = _machinesinfoRepository.GetMInfoByCode(MCode);
if (dbEntry != null)
{
dbEntry.IsActive = false;
dbEntry.Status = -99;
_machinesinfoRepository.Save(dbEntry);
return(0);
}
return(-1);
}
public MachinesInfoGridRowModel(string TaskTypeName, string DepName, MachinesInfo _machinesinfo)
{
cell = new string[10];
cell[0] = _machinesinfo.MachineCode;
cell[1] = _machinesinfo.MachineName;
cell[2] = _machinesinfo.EquipBrand;
cell[3] = DepName;
cell[4] = TaskTypeName;
cell[5] = _machinesinfo.Capacity.ToString();
cell[6] = _machinesinfo.Downtime.ToString();
cell[7] = _machinesinfo.Cost.ToString();
cell[8] = _machinesinfo.Status > 0 ? "true" : "false";
cell[9] = _machinesinfo.DepartmentID.ToString();
}
public JsonResult Service_Save_MachinesInfo(MachinesInfo model)
{
try
{
if (string.IsNullOrEmpty(model.MachineCode) && !string.IsNullOrEmpty(model.TaskType))
{
string _firstletter = "";
if (model.EquipBrand == "委外")
{
_firstletter = "Y";
}
model.MachineCode = _machinesinfoRepository.GenerateCode(model.TaskType, _firstletter);
}
if (_machinesinfoRepository.IsNullMachinesInfo(model) < 0)
{
return(Json(new { Code = -1, Message = "关键信息(名称/工艺)不能为空！" }));
}
int r = _machinesinfoRepository.Save(model);
if (r == 0)
{
#region 更新设备配置表 Machines
List <Machine> _machines = _machinesRepository.Machines.Where(m => m.MachineCode == model.MachineCode).ToList();
if (_machines != null)
{
foreach (var m in _machines)
{
m.Name = model.MachineName;
_machinesRepository.Save(m);
}
}
#endregion
return(Json(new { Code = 0, Message = "" }));
}
else if (r == -1)
{
return(Json(new { Code = -99, Message = "设备代码 " + model.MachineCode + " 重复！" }));
}
else if (r == -2)
{
return(Json(new { Code = -99, Message = "设备名称 " + model.MachineName + " 重复！" }));
}
else if (r == -99)
{
return(Json(new { Code = -99, Message = "设备代码 " + model.MachineCode + " 已失效！" }));
}
}
catch (Exception ex) { LogRecord("设备保存异常信息", "异常信息——" + ex.Message); }
return(Json(new { Code = -99, Message = "设备保存时发生异常，详情请见日志文件！" }));
}
/// <summary>
/// 检查设备Code、Name
/// </summary>
/// <param name="model">设备对象</param>
/// <returns>res="" 全新设备</returns>
public string CheckExistMachinesInfo(MachinesInfo model)
{
string res = "";
MachinesInfo dbEntry;
dbEntry = _context.MachinesInfo.Where(m => m.MachineCode.ToUpper() == model.MachineCode.ToUpper()).FirstOrDefault();
if (dbEntry != null)
{
res = res + dbEntry.MachineCode + ";";
}
dbEntry = _context.MachinesInfo.Where(m => m.MachineName.ToUpper() == model.MachineName.ToUpper()).FirstOrDefault();
if (dbEntry != null)
{
res = res + dbEntry.MachineName + ";";
}
return(res);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns>-2 设备名存在;-1 设备代码存在;0 成功保存</returns>
public int Save(MachinesInfo model)
{
MachinesInfo dbEntry = _context.MachinesInfo.Where(m => m.MachineCode.ToUpper() == model.MachineCode.ToUpper() && m.IsActive == true).FirstOrDefault();
//新增
if (dbEntry == null)
{
//验证是否失效Code -99
if (!IsInvalidMInfo(model.MachineCode))
{
//验证Code -1、Name -2是否都存在
if (IsNullMachinesInfo(model) != -1 && IsNullMachinesInfo(model) != -2)
{
model.IsActive = true;
_context.MachinesInfo.Add(model);
}
else
{
return(IsNullMachinesInfo(model));
}
}
else
{
return(-99);
}
}
//编辑
else
{
dbEntry.MachineName = model.MachineName;
dbEntry.DepartmentID = model.DepartmentID;
dbEntry.Capacity = model.Capacity;
dbEntry.Downtime = model.Downtime;
dbEntry.EquipBrand = model.EquipBrand;
dbEntry.Cost = model.Cost;
dbEntry.IsActive = model.IsActive;
dbEntry.Status = model.Status;
dbEntry.TaskType = model.TaskType;
dbEntry.Stype = model.Stype;
}
_context.SaveChanges();
return(0);
}
public string GetMachineByTask(List <TaskHour> _ths, List <MachinesInfo> _mis, int TaskID)
{
List <int> _FStatelist = new List <int>
{
(int)TaskHourStatus.完成记录,
(int)TaskHourStatus.完成,
(int)TaskHourStatus.暂停,
(int)TaskHourStatus.任务等待,
(int)TaskHourStatus.开始,
(int)TaskHourStatus.外发,
};
var _th = _ths.Where(t => t.TaskID == TaskID && _FStatelist.Contains(t.State)).Where(h => h.TaskType != 5).OrderByDescending(h => h.TaskHourID).FirstOrDefault();
if (_th != null)
{
MachinesInfo _mInfo = _mis.Where(m => m.MachineCode == _th.MachineCode).FirstOrDefault();
if (_mInfo != null)
{
return(_mInfo.MachineName + "_" + _mInfo.MachineCode);
}
}
return("");
}
public string GetMachineBySemiTaskFlag(string SemiTaskFlag)
{
List <int> _FStatelist = new List <int>
{
(int)TaskHourStatus.完成记录,
(int)TaskHourStatus.完成,
(int)TaskHourStatus.暂停,
(int)TaskHourStatus.任务等待,
(int)TaskHourStatus.开始,
(int)TaskHourStatus.外发,
};
TaskHour _taskhour = _context.TaskHours.Where(h => h.SemiTaskFlag.Contains(SemiTaskFlag) && _FStatelist.Contains(h.State)).Where(h => h.TaskType != 5).OrderByDescending(h => h.TaskHourID).FirstOrDefault() ?? new TaskHour();
if (_taskhour != null)
{
MachinesInfo _mInfo = _context.MachinesInfo.Where(m => m.MachineCode == _taskhour.MachineCode).FirstOrDefault();
if (_mInfo != null)
{
return(_mInfo.MachineName + "_" + _mInfo.MachineCode);
}
}
return("");
}
