private void Menu_Storage(object sender, RoutedEventArgs e)
{
///查看对应代码库存记录
///
YF_WMS.Model.Outbound SelectedElement = (YF_WMS.Model.Outbound)datagridoutbound.SelectedItem;
string sql = "select sum(Material_Qty) as total from Material where Material_ID ='" + SelectedElement.Material_ID + "'";
Console.WriteLine(sql);
DataSet ds = MySQLHelper.GetDataSet(MySQLHelper.GetConn(), CommandType.Text, sql, null);
if (!((ds == null) || (ds.Tables.Count == 0) || (ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 0)))
{
if (ds.Tables[0].Rows[0]["total"].ToString().Equals("") || ds.Tables[0].Rows[0]["total"].ToString().Equals(null))
{
MessageBox.Show("库存为：0");
}
else
{
MessageBox.Show("库存为：" + ds.Tables[0].Rows[0]["total"].ToString());
}
}
else
{
MessageBox.Show("库存为：0");
}
}
public WPF_OutOfBox(DataRowView view, string operation, YF_WMS.Model.Outbound list)
{
InitializeComponent();
_view = view;
_operation = operation;
_list = list;
if (_list != null)
{
material_sqty.Text = _list.Material_SQty.ToString();
material_sqty.IsEnabled = false;
material_qty.IsEnabled = false;
_Outbound_Time = DateTime.Parse(_list.Outbound_Time).ToString("yyyy-MM-dd HH:mm:ss");
_Custom_Name = _list.Custom_Name;
_Box_ID = combobox.Text;
_Sale_ID = _list.Sale_ID;
_Material_ID = _list.Material_ID;
_Material_Spec = _list.Material_Spec;
_Material_SQty = material_sqty.Text.Trim();
_Material_SerialNum = _list.Material_SerialNum;
_Material_RSQty = material_sqty.Text.Trim();
}
else
{
_Outbound_Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
_Custom_Name = _view.Row["FName1"].ToString();
_Box_ID = combobox.Text;
_Sale_ID = _view.Row["FBillNo"].ToString();
_Material_ID = _view.Row["FNumber"].ToString();
_Material_Spec = _view.Row["FModel"].ToString();
_Material_SQty = material_sqty.Text.Trim();
_Material_SerialNum = _list.Material_SerialNum;
_Material_RSQty = _view.Row["FAuxQty"].ToString();
}
}
