/// <summary>
/// 产品选择下拉列表选择触发事件
/// 选择后将对应代码产品信息填入货物信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void comboBox_Product_SelectedIndexChanged(object sender, EventArgs e)
{
KeyValuePair <int, string> kv = (KeyValuePair <int, string>)comboBox_Product.SelectedItem;
int product_id = kv.Key;
string sql = "SELECT * FROM OSM_STORAGE WHERE ID = " + product_id;
AccessDB adb = new AccessDB();
DataTable dt = adb.SQLTableQuery(sql);
if (dt.Rows.Count == 1)
{
DataRow dr = dt.Rows[0];
textBox_HW_NAME.Text = dr["HW_NAME"].ToString();
textBox_HW_CODE.Text = dr["HW_CODE"].ToString();
for (int i = 0; i < comboBox_HW_TYPE.Items.Count; i++)
{
KeyValuePair <string, string> item = (KeyValuePair <string, string>)comboBox_HW_TYPE.Items[i];
if (item.Key == dr["HW_TYPE"].ToString())
{
comboBox_HW_TYPE.SelectedIndex = i;
break;
}
}
hw.setPRODUCT_ID(int.Parse(dr["ID"].ToString()));
}
}
