/// <summary> /// 重新加载数据 /// </summary> private void ReloadData() { cmbPeWkc.DataSource = MyDataLoadCtrl.LoadEqm(); cmbPeWkc.DisplayMember = "eqm_name"; cmbPeWkc.ValueMember = "eqm_no"; LoadFile(); }
/// <summary> /// 安灯呼叫事件函数 /// </summary> /// <param name="sender">安灯呼叫事件对象</param> /// <param name="e">事件句柄</param> private void btnCall_Click(object sender, EventArgs e) { string adn_Type = string.Empty; string adn_Name = string.Empty; adn_Type = GetAdnType(out adn_Name); if (adn_Type == "Wrong") { Ctrl.MsgFrmCtrl.ShowResult("请选择Andon类型!"); return; } string andonNo = string.Empty; if (btnCall.Text != "呼叫") { List <Model.TableModel.Adn> list = MyDataLoadCtrl.LoadAdn(string.Format("eqm_no='{0}' and andon_type_no='{1}' and is_finished='false';", MyDataUniversal.EqmNo, adn_Type)); if (list == null || list.Count <= 0) { Ctrl.MsgFrmCtrl.ShowResult("没有此类型Andon呼叫,请重新选择!"); return; } else { andonNo = list[0].andon_no; } } frmAdn frm1 = new frmAdn(btnCall.Text, adn_Type, adn_Name, MyDataUniversal.EqmNo, MyDataUniversal.EqmName, new Model.User_P(), andonNo); frm1.FormClosing += frm_FormClosing; frm1.ShowDialog(); }
/// <summary> /// 加载数据设备、质量原因列表和工站信息 /// </summary> private void LoadJamQcCauseAndWkcData() { cmbJamCause.DataSource = MyDataLoadCtrl.GetEqmJamCause(); cmbJamCause.DisplayMember = "jam_cause_name"; cmbQcCause.DataSource = MyDataLoadCtrl.GetQcmQaCause(); cmbQcCause.DisplayMember = "qa_cause_name"; cmbWkc.DataSource = MyDataLoadCtrl.LoadEqm(); cmbWkc.DisplayMember = "eqm_name"; cmbWkc.ValueMember = "eqm_no"; cmbWkc.SelectedValue = MyDataUniversal.EqmNo; LoadPartTypeData(); }
/// <summary> /// 加载质量不良数据 /// </summary> private void LoadQcJamData() { DataTable dt1 = MyDataLoadCtrl.LoadQcmRecordAll(MyDataUniversal.EqmNo); dgvQc.Rows.Clear(); int i = 0; foreach (DataRow item in dt1.Rows) { dgvQc.Rows.Add(); dgvQc.Rows[i].Cells["colQcTypeNo"].Value = item[0]; dgvQc.Rows[i].Cells["colQcSerial"].Value = item[1]; dgvQc.Rows[i].Cells["colQcCause"].Value = item[2]; dgvQc.Rows[i].Tag = item[3]; i++; } }
/// <summary> /// 加载设备不良数据 /// </summary> private void LoadEqmJamData() { string where = string.Format(" eqm_no='{0}' order by submit_time desc", MyDataUniversal.EqmNo); List <Model.TableModel.Eqm_jam_record> list = MyDataLoadCtrl.LoadEqmJamRecordNew(where); dgvJamCause.Rows.Clear(); int i = 0; foreach (Model.TableModel.Eqm_jam_record item in list) { dgvJamCause.Rows.Add(); dgvJamCause.Rows[i].Cells["dgvColumnJamStartTime"].Value = item.submit_time.ToString("yyyy-MM-dd HH:mm:ss"); dgvJamCause.Rows[i].Cells["dgvColumnJamStopTime"].Value = item.reply_time == null ? string.Empty : ((DateTime)item.reply_time).ToString("yyyy-MM-dd HH:mm:ss"); dgvJamCause.Rows[i].Cells["dgvColumnJamCause"].Value = item.jam_cause_name; dgvJamCause.Rows[i].Cells["dgvColumnJamTime"].Value = item.reply_time == null ? string.Empty : ((DateTime)item.reply_time - item.submit_time).Minutes.ToString() + "min"; i++; } }
/// <summary> /// 设置安灯控制按钮显示文本 /// </summary> private void SetAndonBtnCallText() { string adnStatus = MyDataLoadCtrl.LoadAdnStatus(MyDataUniversal.EqmNo); switch (adnStatus) { case "510": btnCall.Text = "呼叫"; break; case "500": btnCall.Text = "回复"; break; case "520": btnCall.Text = "复位"; break; default: btnCall.Text = "错误"; break; } }