/// <summary> /// 搜索按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DMButton_Search_Click(object sender, RoutedEventArgs e) { stockBase.StockList.Clear(); List <WMS_Stock_Model> list = new List <WMS_Stock_Model>(); DataTable dt = WMS_Stock_Bll.Select_Stock(" SN = '" + SearchText.Text.Trim() + "'"); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Stock_Model wMS_Stock_Model = new WMS_Stock_Model { ShelfNo = dt.Rows[i]["ShelfNo"].ToString(), AreaNo = dt.Rows[i]["AreaNo"].ToString(), WarehouseNo = dt.Rows[i]["WarehouseNo"].ToString(), SN = dt.Rows[i]["SN"].ToString(), ProductionNo = dt.Rows[i]["ProductionNo"].ToString(), PutInNo = dt.Rows[i]["PutInNo"].ToString() }; list.Add(wMS_Stock_Model); } foreach (var model in list) { stockBase.StockList.Add(model); } this.StockDataGrid.ItemsSource = stockBase.StockList; }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <WMS_Stock_Model> GetStockList() { List <WMS_Stock_Model> list = new List <WMS_Stock_Model>(); DataTable dt = WMS_Stock_Bll.Select_Stock(string.Empty); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Stock_Model wms_Stock_Model = new WMS_Stock_Model { ShelfNo = dt.Rows[i]["ShelfNo"].ToString(), AreaNo = dt.Rows[i]["AreaNo"].ToString(), WarehouseNo = dt.Rows[i]["WarehouseNo"].ToString(), SN = dt.Rows[i]["SN"].ToString(), ProductionNo = dt.Rows[i]["ProductionNo"].ToString(), PutInNo = dt.Rows[i]["PutInNo"].ToString() }; list.Add(wms_Stock_Model); } return(list); }