/// <summary>
///
/// </summary>
/// <param name="ELE_IndexCode"></param>
/// <returns></returns>
public QCTask GetEleDrawingByELE_Index(string ELE_IndexCode)
{
string _url = "/Task/GetEleDrawingByELE_Index?ELE_IndexCode=" + ELE_IndexCode;
QCTask _item = JsonConvert.DeserializeObject <QCTask>(_server.ReceiveStream(_url));
return(_item);
}
/// <summary>
/// Private Sub ELECheckGridView_CellContentClick
/// Private Sub ELEHGridView_CellContentClick
/// Private Sub LkOpen_Click
/// 获取具体某一电极对应的电极加工任务名、版本和模具号
/// </summary>
/// <param name="CNCItemID">电极表ID号</param>
/// <returns></returns>
public QCTask GetEleDrawing(int QCTaskID)
{
string _url = "/Task/GetTaskByQCTaskID?QCTaskID=" + QCTaskID;
QCTask _qctask = JsonConvert.DeserializeObject <QCTask>(_server.ReceiveStream(_url));
return(_qctask);
}
public QCTask GetEleDrawing(string LabelName)
{
string _url = "/Task/GetTaskByLabelName?LabelName=" + LabelName;
QCTask _qctask = JsonConvert.DeserializeObject <QCTask>(_server.ReceiveStream(_url));
return(_qctask);
}
public QCTaskGridRowModel(QCTask QCTask)
{
cell = new string[10];
cell[0] = QCTask.QCTaskID.ToString();
cell[1] = QCTask.DrawingFile == ""? "":"<a href='/File/" + QCTask.DrawingFile + "/" + QCTask.DrawingFile + "'>Open</a>";
cell[2] = QCTask.TaskName;
cell[3] = QCTask.Version.ToString();
cell[4] = QCTask.Priority.ToString();
}
/// <summary>
/// 接收数据库数据传输
/// </summary>
/// <param name="strMethod"></param>
/// <param name="sender"></param>
public void DataTransfer_Event(string strMethod, object sender)
{
switch (strMethod)
{
//显示质控编号和质控任务
case "QueryBigestQCTaskInfoForToday":
List <QCTaskInfo> lstQCTask = (List <QCTaskInfo>)XmlUtility.Deserialize(typeof(List <QCTaskInfo>), sender as string);
this.DisplayTaskInfo(lstQCTask);
break;
//显示所有项目信息
case "QueryAssayProNameAllInfo":
lstAssayProInfos = (List <string>)XmlUtility.Deserialize(typeof(List <string>), sender as string);
projectPage1.ClearLastSelectedInfo();
projectPage2.ClearLastSelectedInfo();
projectPage3.ClearLastSelectedInfo();
projectPage1.LstAssayProInfos = lstAssayProInfos;
projectPage2.LstAssayProInfos = lstAssayProInfos;
projectPage3.LstAssayProInfos = lstAssayProInfos;
this.BeginInvoke(new EventHandler(delegate { tabcProject.SelectedTabPageIndex = 0; }));
break;
//质控品信息
case "QueryQCAllInfoForUnLocked":
lstQCInfos = (List <QualityControlInfo>)XmlUtility.Deserialize(typeof(List <QualityControlInfo>), sender as string);
this.Invoke(new EventHandler(delegate
{
combPosition.Properties.Items.Clear();
if (lstQCInfos != null)
{
List <string> lstQCPos = new List <string>();
foreach (QualityControlInfo qcInfo in lstQCInfos)
{
lstQCPos.Add(qcInfo.Pos);
}
lstQCPos.Sort();
combPosition.Properties.Items.AddRange(lstQCPos);
combPosition.Text = "请选择";
}
}));
break;
case "QueryProjectNameInfoByQC":
lstQCRelateProject = (List <string[]>)XmlUtility.Deserialize(typeof(List <string[]>), sender as string);
if (lstQCRelateProject != null)
{
this.Invoke(new EventHandler(delegate
{
if (tabcProject.SelectedTabPageIndex != 0)
{
tabcProject.SelectedTabPageIndex = 0;
}
else
{
tabcProject_SelectedPageChanged(null, null);
}
}));
}
break;
//显示添加质控任务是否成功
case "AddQCTask":
string strAddResult = sender as string;
if (strAddResult == "添加质控任务失败！")
{
MessageBox.Show("添加质控任务失败！");
return;
}
else
{
List <QCTaskInfo> lstQCTaskInfo = new QCTask().QueryBigestQCTaskInfoForToday("QueryBigestQCTaskInfoForToday");
this.DisplayTaskInfo(lstQCTaskInfo);
this.btnApply_Click(null, null);
}
break;
//获取质控任务。UI端已注释
case "QueryQCTaskForLstv":
break;
case "QueryQCTaskBySampleNum":
QCTaskInfoQuery qCTaskInfoQuery = (QCTaskInfoQuery)XmlUtility.Deserialize(typeof(QCTaskInfoQuery), sender as string);
if (qCTaskInfoQuery != null)
{
this.Invoke(new EventHandler(delegate
{
taskFlag = true;
qcTaskDictionary.Clear();
txtSumpleNum.Text = qCTaskInfoQuery.SampleNum;
combPosition.Text = qCTaskInfoQuery.Position;
combSampleType.SelectedItem = qCTaskInfoQuery.SampleType;
txtQCName.Text = qCTaskInfoQuery.QCName;
txtLotNum.Text = qCTaskInfoQuery.LotNum;
txtQCConc.Text = qCTaskInfoQuery.LevelConc;
txtManufacturer.Text = qCTaskInfoQuery.Manufacturer;
projectPage1.TaskProjects = lstprojectName;
projectPage2.TaskProjects = lstprojectName;
projectPage3.TaskProjects = lstprojectName;
}));
taskFlag = false;
}
break;
default:
break;
}
}
public int Save(QCTask QCTask, int Mode = 0)
{
bool _isNew = false;
QCTask _dbEntry = null;
if (Mode == 0)
{
if (QCTask.QCTaskID == 0)
{
_dbEntry = _context.QCTasks.Where(q => q.TaskName == QCTask.TaskName).Where(q => q.Version == QCTask.Version).FirstOrDefault();
if (_dbEntry == null)
{
_isNew = true;
_context.QCTasks.Add(QCTask);
}
else
{
_dbEntry.TaskID = QCTask.TaskID;
_dbEntry.DrawingFile = QCTask.DrawingFile;
_dbEntry.TaskName = QCTask.TaskName;
_dbEntry.TaskType = QCTask.TaskType;
_dbEntry.Version = QCTask.Version;
_dbEntry.Priority = QCTask.Priority;
_dbEntry.Quantity = QCTask.Quantity;
_dbEntry.ForecastTime = QCTask.ForecastTime;
_dbEntry.CreateTime = QCTask.CreateTime;
_dbEntry.StartTime = QCTask.StartTime;
_dbEntry.FinishTime = QCTask.FinishTime;
_dbEntry.Memo = QCTask.Memo;
_dbEntry.StateMemo = QCTask.StateMemo;
_dbEntry.State = QCTask.State;
_dbEntry.ProjectID = QCTask.ProjectID;
_dbEntry.QCUser = QCTask.QCUser;
_dbEntry.MoldNumber = QCTask.MoldNumber;
_dbEntry.Enabled = QCTask.Enabled;
_dbEntry.Finisher = QCTask.Finisher ?? "";
_dbEntry.Deletor = QCTask.Deletor ?? "";
_dbEntry.DeleteTime = QCTask.DeleteTime;
}
}
else
{
_dbEntry = _context.QCTasks.Find(QCTask.QCTaskID);
if (_dbEntry != null)
{
_dbEntry.TaskID = QCTask.TaskID;
_dbEntry.DrawingFile = QCTask.DrawingFile;
_dbEntry.TaskName = QCTask.TaskName;
_dbEntry.TaskType = QCTask.TaskType;
_dbEntry.Version = QCTask.Version;
_dbEntry.Priority = QCTask.Priority;
_dbEntry.Quantity = QCTask.Quantity;
_dbEntry.ForecastTime = QCTask.ForecastTime;
_dbEntry.CreateTime = QCTask.CreateTime;
_dbEntry.StartTime = QCTask.StartTime;
_dbEntry.FinishTime = QCTask.FinishTime;
_dbEntry.Memo = QCTask.Memo;
_dbEntry.StateMemo = QCTask.StateMemo;
_dbEntry.State = QCTask.State;
_dbEntry.ProjectID = QCTask.ProjectID;
_dbEntry.QCUser = QCTask.QCUser;
_dbEntry.MoldNumber = QCTask.MoldNumber;
_dbEntry.Enabled = QCTask.Enabled;
_dbEntry.Finisher = QCTask.Finisher ?? "";
_dbEntry.Deletor = QCTask.Deletor;
_dbEntry.DeleteTime = QCTask.DeleteTime;
}
}
}
else
{
_isNew = true;
_context.QCTasks.Add(QCTask);
}
_context.SaveChanges();
if (_isNew)
{
return(QCTask.QCTaskID);
}
else
{
return(_dbEntry.QCTaskID);
}
}
public QCTask QueryByID(int QCTaskID)
{
QCTask _qcTask = _context.QCTasks.Find(QCTaskID);
return(_qcTask);
}
public QCTask QueryByTaskID(int TaskID)
{
QCTask _dbEntry = _context.QCTasks.Where(q => q.TaskID == TaskID).Where(q => q.Enabled == true).FirstOrDefault();
return(_dbEntry);
}
