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