string strSQL1=
string strSQL2=
conn = DBConn.GetConn();
da1 = new OracleDataAdapter(strSQL1, conn);
da2 = new OracleDataAdapter(strSQL2, conn);
ds1 = new DataSet();
ds2 = new DataSet();
da1.Fill(ds1, "tab1");
da2.Fill(ds2, "tab2");
int columns1 = ds1.Tables["tab1"].Columns.Count;
string[] dataArray1 = new string[columns1];
for (int j = 0; j < columns1; j++)
{
dataArray1[j] = ds1.Tables["tab1"].Rows[0][j].ToString();
}
int columns2 = ds2.Tables["tab2"].Columns.Count;
string[] dataArray2 = new string[columns2];
for (int j = 0; j < columns2; j++)
{
dataArray2[j] = ds2.Tables["tab2"].Rows[0][j].ToString();
}
DataTable dt = new DataTable();
dt.Columns.Add("轧辊编号");
dt.Columns.Add("库位号");
dt.Columns.Add("轧辊去向");
for (int k = 0; k < 52; k++)
{
if (dataArray1[k] != dataArray2[k])
{
DataRow dr1 = dt.NewRow();
dr1[0] = dataArray1[k];
dr1[1] = GetZGShelveNo(dataArray1[k]);
dr1[2] = "下线入库";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2[0] = dataArray2[k];
dr2[1] = GetZGShelveNo(dataArray2[k]);
dr2[2] = "上线出库";
dt.Rows.Add(dr2);
}
else
{
DataRow dr3 = dt.NewRow();
dr3[0] = dataArray1[k];
dr3[1] = GetZGShelveNo(dataArray1[k]);
dr3[2] = "维持在线";
dt.Rows.Add(dr3);
}
}
dt.DefaultView.Sort = "轧辊去向 ASC";
dt = dt.DefaultView.ToTable();
this.bindingSource1.DataSource = dt;
this.bindingNavigator1.BindingSource = bindingSource1;
this.dataGridView1.DataSource = bindingSource1;
this.dataGridView1.DefaultCellStyle.SelectionBackColor = Color.LightSteelBlue;
this.dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Black;
this.dataGridView1.Columns[0].Width = 300;
this.dataGridView1.Columns[1].Width = 300;
this.dataGridView1.Columns[2].Width = 300;
string strSQL2=
conn = DBConn.GetConn();
da1 = new OracleDataAdapter(strSQL1, conn);
da2 = new OracleDataAdapter(strSQL2, conn);
ds1 = new DataSet();
ds2 = new DataSet();
da1.Fill(ds1, "tab1");
da2.Fill(ds2, "tab2");
int columns1 = ds1.Tables["tab1"].Columns.Count;
string[] dataArray1 = new string[columns1];
for (int j = 0; j < columns1; j++)
{
dataArray1[j] = ds1.Tables["tab1"].Rows[0][j].ToString();
}
int columns2 = ds2.Tables["tab2"].Columns.Count;
string[] dataArray2 = new string[columns2];
for (int j = 0; j < columns2; j++)
{
dataArray2[j] = ds2.Tables["tab2"].Rows[0][j].ToString();
}
DataTable dt = new DataTable();
dt.Columns.Add("轧辊编号");
dt.Columns.Add("库位号");
dt.Columns.Add("轧辊去向");
for (int k = 0; k < 52; k++)
{
if (dataArray1[k] != dataArray2[k])
{
DataRow dr1 = dt.NewRow();
dr1[0] = dataArray1[k];
dr1[1] = GetZGShelveNo(dataArray1[k]);
dr1[2] = "下线入库";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2[0] = dataArray2[k];
dr2[1] = GetZGShelveNo(dataArray2[k]);
dr2[2] = "上线出库";
dt.Rows.Add(dr2);
}
else
{
DataRow dr3 = dt.NewRow();
dr3[0] = dataArray1[k];
dr3[1] = GetZGShelveNo(dataArray1[k]);
dr3[2] = "维持在线";
dt.Rows.Add(dr3);
}
}
dt.DefaultView.Sort = "轧辊去向 ASC";
dt = dt.DefaultView.ToTable();
this.bindingSource1.DataSource = dt;
this.bindingNavigator1.BindingSource = bindingSource1;
this.dataGridView1.DataSource = bindingSource1;
this.dataGridView1.DefaultCellStyle.SelectionBackColor = Color.LightSteelBlue;
this.dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Black;
this.dataGridView1.Columns[0].Width = 300;
this.dataGridView1.Columns[1].Width = 300;
this.dataGridView1.Columns[2].Width = 300;