예제 #1
0
        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");
            }
        }
예제 #2
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();
            }
        }