private void out_bound(object sender, RoutedEventArgs e) { ///出库操作 try { List <Model.Outbound> lists = (List <Model.Outbound>)datagridoutbound.ItemsSource; int i = datagridoutbound.SelectedIndex; DataRowView dataRowView = null; Model.Outbound list = lists[i]; WPF_OutOfBox wPF_OutOfBox = new WPF_OutOfBox(dataRowView, "input_excel", list); string sql = "select Box_ID from Material where Material_ID ='" + list.Material_ID + "'"; DataSet ds = MySQLHelper.GetDataSet(MySQLHelper.GetConn(), CommandType.Text, sql, null); foreach (DataRow row in ds.Tables[0].Rows) { wPF_OutOfBox.combobox.Items.Add(row["Box_ID"].ToString());; } wPF_OutOfBox.ShowDialog(); if (wPF_OutOfBox.DialogResult == true)//第3步,然后对DialogResult进行判断 { lists.RemoveAt(i); datagridoutbound.ItemsSource = null; datagridoutbound.ItemsSource = lists; } } catch (InvalidCastException a) { MessageBox.Show("只有导入的出库excel才能进行入库操作"); } }
private void SO_OutOfStock(object sender, RoutedEventArgs e) { ///下架 /// DataRowView mySelectedElement = (DataRowView)datagridso.SelectedItem; WPF_OutOfBox wPF_OutOfBox = new WPF_OutOfBox(mySelectedElement, "input_so", null); string sql = "select Box_ID from Material where Material_ID = '" + mySelectedElement.Row[1].ToString() + "' and Material_Qty != 0"; DataSet ds = MySQLHelper.GetDataSet(MySQLHelper.GetConn(), CommandType.Text, sql, null); foreach (DataRow row in ds.Tables[0].Rows) { wPF_OutOfBox.combobox.Items.Add(row["Box_ID"].ToString());; } wPF_OutOfBox.combobox.Items.Add("托板");; wPF_OutOfBox.ShowDialog(); }