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