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