public void RefreshQueryContent(DataTable dt)
{
if (this.dataGridView1.InvokeRequired)
{
DelegateRefreshDT dlgt = new DelegateRefreshDT(RefreshQueryContent);
this.Invoke(dlgt, new object[] { dt });
}
else
{
if (dt == null)
{
return;
}
BindingSource bs = new BindingSource();
bs.DataSource = dt;
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs;
bs.Sort = "inputTime";
this.dataGridView1.Columns[0].Width = 300;
this.dataGridView1.Columns[1].Width = 200;
this.dataGridView1.Columns[2].Width = 200;
this.dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.dataGridView1.Columns[3].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
//this.dataGridView1.Columns[4].Width = 100;
//this.dataGridView1.Columns[2].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
//this.dataGridView1.Columns[3].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
//this.dataGridView1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
// strSql.Append("select produceRecordID as 记录序号,productBarcode as 主机条码,inputTime as 投产时间,outputTime as 下线时间,lineOuted as 是否已经下线,outputNode 下线工位");
this.dataGridView1.Columns["productBarcode"].HeaderText = "主机条码";
this.dataGridView1.Columns["rfidCode"].HeaderText = "RFID";
this.dataGridView1.Columns["currentNode"].HeaderText = "当前工位";
this.dataGridView1.Columns["inputTime"].HeaderText = "投产时间";
//this.dataGridView1.Columns["lineOuted"].HeaderText = "是否已经下线";
//this.dataGridView1.Columns["outputNode"].HeaderText = "下线工位";
}
}
public void RefreshQueryContent(DataTable dt)
{
if (this.dataGridView1.InvokeRequired)
{
DelegateRefreshDT dlgt = new DelegateRefreshDT(RefreshQueryContent);
this.Invoke(dlgt, new object[] { dt });
}
else
{
if (dt == null)
{
return;
}
BindingSource bs = new BindingSource();
bs.DataSource = dt;
bindingNavigator1.BindingSource = bs;
dataGridView1.DataSource = bs;
this.dataGridView1.Columns["SERIAL_NUMBER"].HeaderText = "主机条码";
this.dataGridView1.Columns["STEP_NUMBER"].HeaderText = "工位号";
this.dataGridView1.Columns["STATUS"].HeaderText = "状态";
this.dataGridView1.Columns["TRX_TIME"].HeaderText = "数据上传时间";
this.dataGridView1.Columns["TRX_TIME"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
this.dataGridView1.Columns["LAST_MODIFY_TIME"].HeaderText = "最后一次修改时间";
this.dataGridView1.Columns["LAST_MODIFY_TIME"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
this.dataGridView1.Columns["RECID"].HeaderText = "记录ID";
this.dataGridView1.Columns["UPLOAD_FLAG"].HeaderText = "上传状态";
this.dataGridView1.Columns["STATUS"].Width = 50;
this.dataGridView1.Columns["AutoStationName"].Width = 100;
this.dataGridView1.Columns["AutoStationName"].HeaderText = "产线工位名称";
this.dataGridView1.Columns["SERIAL_NUMBER"].Width = 150;
this.dataGridView1.Columns["TRX_TIME"].Width = 150;
this.dataGridView1.Columns["LAST_MODIFY_TIME"].Width = 150;
if (this.comboBox1.Text == "基本信息表")
{
this.dataGridView1.Columns["CHECK_RESULT"].HeaderText = "检测结果";
this.dataGridView1.Columns["STEP_MARK"].HeaderText = "工位标识(检测/下线)";
this.dataGridView1.Columns["USER_NAME"].HeaderText = "操作者";
this.dataGridView1.Columns["DEFECT_CODES"].HeaderText = "不合格项代码";
this.dataGridView1.Columns["RECID"].HeaderText = "记录ID";
this.dataGridView1.Columns["USER_NAME"].HeaderText = "操作者";
this.dataGridView1.Columns["REASON"].HeaderText = "原因说明";
this.dataGridView1.Columns["UPLOAD_FLAG"].HeaderText = "上传状态";
this.dataGridView1.Columns["REASON"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.dataGridView1.Columns["CHECK_RESULT"].Width = 50;
this.dataGridView1.Columns["STEP_MARK"].Width = 50;
this.dataGridView1.Columns["CHECK_RESULT"].Width = 50;
}
else
{
this.dataGridView1.Columns["DATA_NAME"].HeaderText = "数据名称";
this.dataGridView1.Columns["DATA_VALUE"].HeaderText = "检测数值";
this.dataGridView1.Columns["DATA_NAME"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
//bs.Sort = "TRX_TIME";
//this.dataGridView1.Columns[0].Width = 100;
//this.dataGridView1.Columns[1].Width = 200;
//this.dataGridView1.Columns[2].Width = 200;
//this.dataGridView1.Columns[3].Width = 200;
//this.dataGridView1.Columns[4].Width = 80;
//this.dataGridView1.Columns[2].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
//this.dataGridView1.Columns[3].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
//this.dataGridView1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
