public ReportFrm()
{
InitializeComponent();
DataTable mydt = DataBaseTools.Query(mySql());
dataTableToListview(listView1, mydt);
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "SELECT DISTINCT trayIndex FROM REP_FRAME ";
DataTable mydt = DataBaseTools.Query(sql);
dataTableToListview(listView1, mydt);
}
private void init() //初始化产品排列信息
{
myFInfo.ImageXNum = 3;
myFInfo.ImageYNum = 2;
myFInfo.FrameXNum = 6;
myFInfo.FrameYNum = 42;
string sql = "SELECT DISTINCT trayIndex FROM REP_FRAME WHERE lotGUID='" + myGuid + "'";
DataTable mydt = DataBaseTools.Query(sql);
int length = mydt.Rows.Count;
for (int i = 0; i < length; i++)
{
comboBox1.Items.Add(mydt.Rows[i][0].ToString());
}
comboBox1.SelectedIndex = 0;
string sql2 = "SELECT lotNo FROM REP_INST WHERE lotGUID = '" + myGuid + "'";
DataTable mydt2 = DataBaseTools.Query(sql2);
lb_LOT.Text = "LOT: " + mydt2.Rows[0][0].ToString();
string sql3 = "SELECT operatorID FROM REP_INST WHERE lotGUID = '" + myGuid + "'";
DataTable mydt3 = DataBaseTools.Query(sql3);
lb_Operator.Text = "Operator: " + mydt3.Rows[0][0].ToString();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
mTable.Clear();
string trayIndex = comboBox1.SelectedItem.ToString();
string sql = "SELECT frameIndex,unitContent from REP_FRAME WHERE lotGUID='" + myGuid + "' AND trayIndex='" + trayIndex + "'";
DataTable mydt = DataBaseTools.Query(sql);
//textBox1.Text = mydt.Rows.Count.ToString() + "," + mydt.Rows[3][0].ToString();
int length = mydt.Rows.Count;
for (int i = 0; i < length * (myFInfo.FrameXNum + 1); i++)
{
mTable.Rows.Add("");
}
for (int i = 0; i < length; i++)
{
int startP = i * (myFInfo.FrameXNum + 1);
string ss = mydt.Rows[i][0].ToString();
mTable.Rows[startP][0] = "Frame" + ss;
string ss2 = mydt.Rows[i][1].ToString();
int[] tempI = Array.ConvertAll(ss2.TrimEnd(',').Split(','), int.Parse);
for (int j = 0; j < tempI.Length; j++)
{
Point p = GetPosition((j + 1), myFInfo);
mTable.Rows[p.X - 1 + startP][p.Y] = tempI[j];
}
}
}
private void bt_Query_Click(object sender, EventArgs e)
{
DataTable mydt = DataBaseTools.Query(mySql());
dataTableToListview(listView1, mydt);
}
