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