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