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