/// <summary> /// select * from ELE_SETTING_TABLE where EDM_SETTING_NAME='{0}' and SETING_REV={1} /// </summary> /// <param name="SettingName"></param> /// <param name="Version"></param> /// <returns></returns> public EDMDetail GetSetting(String SettingName, int Version) { string _url = "/Task/GetEDMDetail?SettingName=" + SettingName + "&Version=" + Version; string _result = _server.ReceiveStream(_url); EDMDetail _setting = JsonConvert.DeserializeObject <EDMDetail>(_result); return(_setting); }
/// <summary> /// insert_update_ELE_SETTING_TABLE /// </summary> /// <param name="EDMSetting"></param> public int SaveEDMSetting(EDMDetail EDMDetail) { string _url = "/Task/SaveEDMDetail"; EDMDetail.Lock = 0; EDMDetail.Expire = false; EDMDetail.TaskID = 0; //EDMDetail.CreateDate = DateTime.Now; string _result = _server.SendObject(_url, "SettingData", EDMDetail); return(Convert.ToInt16(_result)); }
public void Lock(int TaskID, string TaskName, int Version) { List <EDMDetail> _details = _context.EDMDetails.Where(t => t.SettingName == TaskName).OrderByDescending(t => t.EDMDetailID).ToList(); EDMDetail _curVersion = _details.First(); _curVersion.Lock = 1; _details.Remove(_curVersion); foreach (EDMDetail _oldVersion in _details) { _oldVersion.Expire = true; } _context.SaveChanges(); }
private CNCMachInfo GetCNCMachinfo(Task _task, //ICNCMachInfoRepository MachInfoRepository, //ITaskRepository TaskRepository, //IEDMDetailRepository EDMDetailRepository, List <CNCMachInfo> cncmacInfos, // List <Task> _tasks, // List <EDMDetail> _edmDetails // ) { CNCMachInfo _machinfo = null; switch (_task.TaskType) { case 1: _machinfo = cncmacInfos.Where(m => m.DrawIndex == _task.TaskID).FirstOrDefault(); //MachInfoRepository.QueryByELEIndex(_task.TaskID); return(_machinfo); case 2: try { EDMDetail _detail = _edmDetails.Where(t => t.TaskID == _task.TaskID).Where(t => t.Expire == false).FirstOrDefault(); //EDMDetailRepository.QueryByTaskID(_task.TaskID); string[] _eleList = _detail.EleDetail.Split(';'); string _eleItem = _eleList[0].Substring(0, _eleList[0].Length - 4); int _ver = Convert.ToInt16(_eleList[0].Substring(_eleList[0].IndexOf("_V") + 2)); Task _cnctask = QueryByNameVersion(_tasks, _eleItem, _ver); //TaskRepository.QueryByNameVersion(_eleItem, _ver); _machinfo = cncmacInfos.Where(m => m.DrawIndex == _cnctask.TaskID).FirstOrDefault(); //MachInfoRepository.QueryByELEIndex(_cnctask.TaskID); return(_machinfo); } catch { return(null); } default: return(null); } }
public int Save(EDMDetail EDMDetail) { EDMDetail _dbEntry = null; bool _isNew = false; if (EDMDetail.EDMDetailID == 0) { _dbEntry = QueryBySetting(EDMDetail.SettingName, EDMDetail.Version); if (_dbEntry == null) { _isNew = true; _context.EDMDetails.Add(EDMDetail); } else { _dbEntry.EleDetail = EDMDetail.EleDetail; _dbEntry.TaskID = EDMDetail.TaskID; _dbEntry.CADDetail = EDMDetail.CADDetail; _dbEntry.SettingName = EDMDetail.SettingName; _dbEntry.Version = EDMDetail.Version; _dbEntry.ModifyName = EDMDetail.ModifyName; _dbEntry.ModifyCount = EDMDetail.ModifyCount; _dbEntry.CADCount = EDMDetail.CADCount; //_dbEntry.CreateDate = EDMDetail.CreateDate; _dbEntry.Designer = EDMDetail.Designer; _dbEntry.Lock = EDMDetail.Lock; _dbEntry.Expire = EDMDetail.Expire; _dbEntry.MoldName = EDMDetail.MoldName; _dbEntry.EleCount = EDMDetail.EleCount; _dbEntry.QCPoint = EDMDetail.QCPoint; _dbEntry.ProcessName = EDMDetail.ProcessName ?? ""; _dbEntry.Deletor = EDMDetail.Deletor; _dbEntry.DeleteTime = EDMDetail.DeleteTime; } } else { _dbEntry = _context.EDMDetails.Find(EDMDetail.EDMDetailID); if (_dbEntry != null) { _dbEntry.EleDetail = EDMDetail.EleDetail; _dbEntry.TaskID = EDMDetail.TaskID; _dbEntry.CADDetail = EDMDetail.CADDetail; _dbEntry.SettingName = EDMDetail.SettingName; _dbEntry.Version = EDMDetail.Version; _dbEntry.ModifyName = EDMDetail.ModifyName; _dbEntry.ModifyCount = EDMDetail.ModifyCount; _dbEntry.CADCount = EDMDetail.CADCount; //_dbEntry.CreateDate = EDMDetail.CreateDate; _dbEntry.Designer = EDMDetail.Designer; _dbEntry.Lock = EDMDetail.Lock; _dbEntry.Expire = EDMDetail.Expire; _dbEntry.MoldName = EDMDetail.MoldName; _dbEntry.EleCount = EDMDetail.EleCount; _dbEntry.QCPoint = EDMDetail.QCPoint; _dbEntry.ProcessName = EDMDetail.ProcessName ?? ""; _dbEntry.Deletor = EDMDetail.Deletor; _dbEntry.DeleteTime = EDMDetail.DeleteTime; } } _context.SaveChanges(); if (_isNew) { return(EDMDetail.EDMDetailID); } else { return(_dbEntry.EDMDetailID); } }
public int AddEDMDetail(EDMDetail EDMDetail) { _context.EDMDetails.Add(EDMDetail); _context.SaveChanges(); return(EDMDetail.EDMDetailID); }