80 lines
2.5 KiB
C#
80 lines
2.5 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Windows.Forms;
|
|||
|
|
using CRVM.SIDExcuter;
|
|||
|
|
using CRVM.Entity;
|
|||
|
|
|
|||
|
|
namespace CRVM
|
|||
|
|
{
|
|||
|
|
public partial class OnlineRollForm : Form
|
|||
|
|
{
|
|||
|
|
string exp_msg = "";
|
|||
|
|
public OnlineRollForm()
|
|||
|
|
{
|
|||
|
|
InitializeComponent();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void RollInfo_Load(object sender, EventArgs e)
|
|||
|
|
{
|
|||
|
|
label_alarm.Text = "正在读取在线轧辊信息!";
|
|||
|
|
label_alarm.Visible = true;
|
|||
|
|
|
|||
|
|
backgroundWorker.DoWork += backgroundWorker_DoWork;
|
|||
|
|
backgroundWorker.RunWorkerCompleted += backgroundWorker_RunWorkerCompleted;
|
|||
|
|
|
|||
|
|
if (!backgroundWorker.IsBusy)
|
|||
|
|
{
|
|||
|
|
backgroundWorker.RunWorkerAsync();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
void backgroundWorker_RunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventArgs e)
|
|||
|
|
{
|
|||
|
|
DataTable data = (DataTable)e.Result;
|
|||
|
|
//Console.WriteLine(String.Format(" data.Columns.Count:{ 0}", data.Columns.Count));
|
|||
|
|
string msg = "";
|
|||
|
|
if (data != null)
|
|||
|
|
{
|
|||
|
|
if (data.Rows.Count == 1)
|
|||
|
|
{
|
|||
|
|
for (int i = 0; i < data.Columns.Count; i++)
|
|||
|
|
{
|
|||
|
|
string controlName = "dia_" + i.ToString();
|
|||
|
|
TextBox box = (TextBox)panel2.Controls[controlName];
|
|||
|
|
if (box != null)
|
|||
|
|
{
|
|||
|
|
box.Text = data.Rows[0][i].ToString();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
label_alarm.Visible = false;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
exp_msg = "读取在线轧辊数据失败，请查看数据库连接配置或网络状态！异常信息如下：" + exp_msg;
|
|||
|
|
MessageShowForm form = new MessageShowForm("警告", exp_msg);
|
|||
|
|
form.ShowDialog();
|
|||
|
|
|
|||
|
|
label_alarm.Text = "读取在线轧辊数据失败!";
|
|||
|
|
label_alarm.Visible = true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void backgroundWorker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
|
|||
|
|
{
|
|||
|
|
DataTable data = null;
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
data = DbHelper.GetInstance("").GetL2OnlineRollInfo();
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
exp_msg = ex.ToString();
|
|||
|
|
}
|
|||
|
|
e.Result = data;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|