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