private void query_Click_1(object sender, EventArgs e) { if (this.mbbriefTextBox.Text.Trim() == "") { return; } try { List <useClass> list = new List <useClass>(); List <string> mpnList = new List <string>(); mConn = new SqlConnection(Constlist.ConStr); mConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = mConn; cmd.CommandType = CommandType.Text; cmd.CommandText = "select distinct mpn from MBMaterialCompare where mb_brief like '%" + this.mbbriefTextBox.Text.Trim() + "%'"; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { mpnList.Add(querySdr[0].ToString()); } querySdr.Close(); foreach (string str in mpnList) { cmd.CommandText = "select mpn,number,house,place from store_house where mpn like '%" + str + "%'"; querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { string storeNum = querySdr[1].ToString(); try { if (Int32.Parse(storeNum) > 0) { useClass temp = new useClass(); temp.mpn = querySdr[0].ToString(); temp.storeNum = querySdr[1].ToString(); temp.house = querySdr[2].ToString(); temp.place = querySdr[3].ToString(); list.Add(temp); } } catch (Exception ex) { } } querySdr.Close(); } mConn.Close(); dataGridView1.DataSource = list; dataGridView1.RowHeadersVisible = false; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } string[] hTxt = { "MPN", "数量", "库房", "储位" }; for (int i = 0; i < hTxt.Length; i++) { dataGridView1.Columns[i].HeaderText = hTxt[i]; } }
private void similatorBGABrief() { try { List <useClass> orilist = new List <useClass>(); List <useClass> targetList = new List <useClass>(); SqlConnection mConn = new SqlConnection(Constlist.ConStr); mConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = mConn; cmd.CommandType = CommandType.Text; cmd.CommandText = "select distinct mpn, vendor from bga_in_stock where describe like '%" + this.bga_brieftextBox.Text + "%'"; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { useClass useclass = new useClass(); string temp = querySdr[0].ToString(); if (temp != "") { useclass.mpn = temp; useclass.vendor = querySdr[1].ToString(); useclass.mpnVendor = useclass.mpn + "_" + useclass.vendor; orilist.Add(useclass); } } querySdr.Close(); foreach (useClass temp in orilist) { cmd.CommandText = "select house,place,number from store_house where mpn='" + temp.mpn + "_" + temp.vendor + "'"; querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { try { int number = Int16.Parse(querySdr[2].ToString()); if (number > 0) { temp.house = querySdr[0].ToString(); temp.place = querySdr[1].ToString(); temp.storeNum = querySdr[2].ToString(); temp.stockplace = temp.house + "," + temp.place; targetList.Add(temp); } } catch (Exception ex) { continue; } } querySdr.Close(); } this.dataGridView2.DataSource = null; dataGridView2.Columns.Clear(); dataGridView2.DataSource = targetList; dataGridView2.RowHeadersVisible = false; string[] hTxt = { "MPN_Vendor", "数量", "位置" }; for (int i = 0; i < hTxt.Length; i++) { dataGridView2.Columns[i].HeaderText = hTxt[i]; dataGridView2.Columns[i].Name = hTxt[i]; } mConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void queryStock_Click(object sender, EventArgs e) { if (this.vendorcomboBox.Text == "") { MessageBox.Show("厂商不能为空!"); return; } try { this.dataGridView2.DataSource = null; dataGridView2.Columns.Clear(); SqlConnection mConn = new SqlConnection(Constlist.ConStr); mConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = mConn; List <useClass> list = new List <useClass>(); string sql = "select mpn,stock_place,stock_in_num,vendor,describe from fru_smt_in_stock where vendor='" + this.vendorcomboBox.Text + "' and material_type='FRU'"; if (this.productcomboBox.Text != "") { sql += " and product='" + this.productcomboBox.Text + "'"; } if (this.mb_brieftextBox.Text != "") { sql += " and mb_brief like '%" + this.mb_brieftextBox.Text + "%'"; } if (this.material_nameTextBox.Text != "") { sql += " and material_name like '%" + this.material_nameTextBox.Text + "%'"; } if (this.mpnTextBox.Text != "") { sql += " and mpn like '%" + this.mpnTextBox.Text + "%'"; } cmd.CommandText = sql; cmd.CommandType = CommandType.Text; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { useClass useclass = new useClass(); string mpn = querySdr[0].ToString(); bool exist = false; foreach (useClass temp in list) { if (temp.mpn == mpn) { exist = true; break; } } if (exist) { continue; } useclass.mpn = mpn; useclass.stock_place = querySdr[1].ToString(); useclass.stock_in_num = querySdr[2].ToString(); useclass.vendor = querySdr[3].ToString(); useclass.describe = querySdr[4].ToString(); list.Add(useclass); } querySdr.Close(); foreach (useClass temp in list) { cmd.CommandText = "select number from store_house where mpn ='" + temp.mpn + "_" + temp.vendor + "'"; querySdr = cmd.ExecuteReader(); string storeNum = "0"; while (querySdr.Read()) { storeNum = querySdr[0].ToString(); } temp.stock_in_num = storeNum; querySdr.Close(); } dataGridView2.DataSource = list; dataGridView2.RowHeadersVisible = false; mConn.Close(); string[] hTxt = { "MPN", "库位", "已有数量", "厂商", "描述" }; for (int i = 0; i < hTxt.Length; i++) { dataGridView2.Columns[i].HeaderText = hTxt[i]; dataGridView2.Columns[i].Name = hTxt[i]; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void query_Click(object sender, EventArgs e) { try { SqlConnection mConn; if (this.trackNoTxt.Text.Trim().Equals("")) { MessageBox.Show("请输入跟踪条码内容!"); return; } List <useClass> list = new List <useClass>(); mConn = new SqlConnection(Constlist.ConStr); mConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = mConn; cmd.CommandText = "select vendor,custom_order,custommaterialNo,track_serial_no,custom_serial_no,mb_describe from DeliveredTable where track_serial_no='" + this.trackNoTxt.Text.Trim() + "' "; cmd.CommandType = CommandType.Text; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { useClass useclass = new useClass(); useclass.vendor = querySdr[0].ToString(); useclass.orderNo = querySdr[1].ToString(); useclass.customNo = querySdr[2].ToString(); useclass.trackNo = querySdr[3].ToString(); useclass.customSerialNo = querySdr[4].ToString(); useclass.mb_describe = querySdr[5].ToString(); list.Add(useclass); } querySdr.Close(); foreach (useClass temp in list) { cmd.CommandText = "select inputdate,inputer from stationInfoRecord where trackno ='" + temp.trackNo + "' and station='Test1'"; querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { temp.testStart = querySdr[0].ToString(); temp.tester = querySdr[1].ToString(); } querySdr.Close(); cmd.CommandText = "select inputdate from stationInfoRecord where trackno ='" + temp.trackNo + "' and station='Test2'"; querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { temp.testEnd = querySdr[0].ToString(); } querySdr.Close(); } dataGridView1.DataSource = list; mConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } //厂商 订单编号 客户料号 跟踪条码 客户序号 mb描述 测试开始时间 测试结束时间 测试人 string[] hTxt = { "厂商", "订单编号", "客户料号", "跟踪条码", "客户序号", "MB描述", "测试开始时间", "测试结束时间", "测试人" }; for (int i = 0; i < hTxt.Length; i++) { dataGridView1.Columns[i].HeaderText = hTxt[i]; } }