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