public static Task CreateTaskByTable(DataTable dt) { Task task = null; try { task = new Task(); task.TaskNo = (dt.Rows[0]["TaskNo"] == null ? "" : dt.Rows[0]["TaskNo"].ToString()); task.BatchNo = (dt.Rows[0]["BatchNo"] == null ? "" : dt.Rows[0]["BatchNo"].ToString()); task.ItemNo = (dt.Rows[0]["ItemNo"] == null ? "" : dt.Rows[0]["ItemNo"].ToString()); task.ItemName = (dt.Rows[0]["ItemName"] == null ? "" : dt.Rows[0]["ItemName"].ToString()); task.Sn = (dt.Rows[0]["Sn"] == null ? "" : dt.Rows[0]["Sn"].ToString()); task.PV = (dt.Rows[0]["PV"] == null ? 0 : int.Parse(dt.Rows[0]["PV"].ToString())); task.Result = (dt.Rows[0]["Result"] == null ? 0 : int.Parse(dt.Rows[0]["Result"].ToString())); task.redundantVaue = (dt.Rows[0]["RedundantVaue"] == null ? 0 : int.Parse(dt.Rows[0]["RedundantVaue"].ToString())); IFormatProvider ifp = new CultureInfo("zh-CN", true); if (dt.Rows[0]["StartTime"] != null) { DateTime.TryParseExact(dt.Rows[0]["StartTime"].ToString(), DateTimeFormat2, ifp, DateTimeStyles.None, out task.StartTime); } if (dt.Rows[0]["CompleteTime"] != null) { DateTime.TryParseExact(dt.Rows[0]["CompleteTime"].ToString(), DateTimeFormat2, ifp, DateTimeStyles.None, out task.CompleteTime); } return task; } catch (Exception ex) { Program.WriteErrorLog("CreateTaskByTable", ex); return task; } }
public Task LoadCurrentTask() { Task task = null; try { StringBuilder sbstr = new StringBuilder("Select * From T_Task"); DataTable dt = theDB.SelectDataTable(sbstr.ToString()); if (dt.Rows.Count >= 1) { task = new Task(); task = Task.CreateTaskByTable(dt); } return task; } catch (Exception ex) { Program.WriteErrorLog(this.GetType().FullName, ex); return task; } }
private void Frm_Main_Load(object sender, EventArgs e) { Timer_ReadData.Interval = SysPara.RefreshTime; lastTask = mp.LoadCurrentTask(); if (lastTask != null) { FillTaskToUI(lastTask); ctask = lastTask; HideMeasureInfo(); } else { ShowMeasureInfo(); } }
private void FillTaskToUI(Task lasttask) { if (lasttask != null) { txt_batchNo.Text = lasttask.BatchNo; txt_ItemNo.Text = lasttask.ItemNo; txt_ItemName.Text = lasttask.ItemName; txt_StartTime.Text = lasttask.StartTime == new DateTime() ? "" : lasttask.StartTime.ToString(Task.DateTimeFormat1); txt_EndTime.Text = lasttask.CompleteTime == new DateTime() ? "" : lasttask.CompleteTime.ToString(Task.DateTimeFormat1); txt_SumLength.Text = lasttask.PV.ToString(); if (lasttask.Status != eTaskSts.Start) { btnSts_Started(); } } }
private void FillTaskFormUI(Task ctask) { Task lasttask = new Task(); ctask.TaskNo = txt_batchNo.Text; ctask.BatchNo = txt_batchNo.Text; ctask.ItemNo = txt_ItemNo.Text; ctask.ItemName = txt_ItemName.Text; int.TryParse(txt_SumLength.Text, out ctask.PV); int.TryParse(txt_Rongyu.Text, out ctask.PV); }
private void btn_SaveRecord_Click(object sender, EventArgs e) { int.TryParse(txt_SumLength.Text, out ctask.PV); int.TryParse(txt_Rongyu.Text, out ctask.PV); bool res = mp.SaveRecordTask(ctask); if (!res) { MessageBox.Show("记录当前任务失败。"); } else { MessageBox.Show("保存成功。"); ClearUITastInfo(); lastTask = null; ctask = new Task(); } }
private void btn_Create_Click(object sender, EventArgs e) { //检查批次号重复 //创建当前任务 //锁定任务修改 //开启设备连接 //读取计米器数据 try { if (txt_batchNo.Text.Trim().Length < 1) { txt_batchNo.Focus(); throw new ApplicationException("批次不能为空。"); } if (txt_ItemNo.Text.Trim().Length < 1) { txt_batchNo.Focus(); throw new ApplicationException("品规不能为空。"); } ctask = new Task(); FillTaskFormUI(ctask); Task lasttask = mp.LoadCurrentTask(); if (lasttask != null) { DialogResult dres = MessageBox.Show("已存在当前未完成任务是否继续,点(是)继续创建新任务,点(否)读取为完成任务。","任务已存在", MessageBoxButtons.YesNoCancel,MessageBoxIcon.Question,MessageBoxDefaultButton.Button1); if (dres == DialogResult.Yes) { //ClearUITastInfo(); //ClearUIMeasureInfo(); } else if (dres == DialogResult.No) { FillTaskToUI(lasttask); btnSts_Started(); return; } else { return; } } btnSts_Created(); ShowMeasureInfo(); FillTaskFormUI(ctask); bool res = mp.SaveCurrentTask(ctask); if (!res) { throw new ApplicationException("保存作业至数据库失败。"); } } catch (Exception ex) { MessageBox.Show(string.Format("新建作业失败!{0}",ex.Message)); } }
public MeasurerProcess() { CurrentTask = new Task(); theDB = DBServiceFactory.GetDBService("MeasurerXML"); }
public bool SaveRecordTask(Task task) { bool result=false; try { StringBuilder sbstr = new StringBuilder("Insert into T_Record(TaskNo,BatchNo,ItemNo,ItemName,Sn,PV,Result,redundantVaue,Status,StartTime,CompleteTime) Values("); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.TaskNo,true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.BatchNo,true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.ItemNo,true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.ItemName,true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.Sn, true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.PV.ToString(), true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.Result.ToString(), true))); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.redundantVaue.ToString(),true))); sbstr.Append("1,"); sbstr.Append(string.Format("{0},", FunBase.ChkField(task.StartTime.ToString(Task.DateTimeFormat1)))); sbstr.Append(string.Format("{0}", FunBase.ChkField(task.CompleteTime.ToString(Task.DateTimeFormat1)))); sbstr.Append(")"); result = theDB.UpdataDataBase(sbstr.ToString()); if(result) { result = theDB.UpdataDataBase("Delete Table T_Task"); } return result; } catch (Exception ex) { Program.WriteErrorLog(this.GetType().FullName, ex); return false; } }
public bool SaveCurrentTask(Task task) { try { bool result = false; StringBuilder sbstr = new StringBuilder("insert into T_Task(TaskNo,BatchNo,ItemNo,ItemName,Sn,PV,Result,redundantVaue,Status,StartTime,CompleteTime) Values("); sbstr.Append(string.Format("'{0}',", task.TaskNo)); sbstr.Append(string.Format("'{0}',", task.BatchNo)); sbstr.Append(string.Format("'{0}',", task.ItemNo)); sbstr.Append(string.Format("'{0}',", task.ItemName)); sbstr.Append(string.Format("'{0}',", task.Sn)); sbstr.Append(string.Format("'{0}',", task.PV)); sbstr.Append(string.Format("'{0}',", task.Result)); sbstr.Append(string.Format("'{0}',", task.redundantVaue)); sbstr.Append("0,"); sbstr.Append(string.Format("'{0}',", task.StartTime)); sbstr.Append(string.Format("'{0}'", task.CompleteTime)); sbstr.Append(")"); result = theDB.UpdataDataBase("Delete T_Task"); return theDB.UpdataDataBase(sbstr.ToString()); } catch(Exception ex) { Program.WriteErrorLog(this.GetType().FullName, ex); return false; } }