/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
shelfBase.ShelfList.Clear();
List <WMS_Shelf_Model> list = new List <WMS_Shelf_Model>();
DataTable dt = WMS_Shelf_Bll.Select_Shelf(" ShelfName = '" + SearchText.Text.Trim() + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Shelf_Model wMS_Shelf_Model = new WMS_Shelf_Model
{
ShelfName = dt.Rows[i]["ShelfName"].ToString(),
ShelfNo = dt.Rows[i]["ShelfNo"].ToString(),
AreaNo = dt.Rows[i]["AreaNo"].ToString(),
WarehouseNo = dt.Rows[i]["WarehouseNo"].ToString(),
Remark = dt.Rows[i]["Remark"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wMS_Shelf_Model);
}
foreach (var model in list)
{
shelfBase.ShelfList.Add(model);
}
this.ShelfDataGrid.ItemsSource = shelfBase.ShelfList;
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Delete_Click(object sender, RoutedEventArgs e)
{
foreach (var no in selectShelfName)
{
WMS_Shelf_Bll.Delete_Shelf(" ShelfName = '" + no + "'");
}
Page_Frush();
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Save_Click(object sender, RoutedEventArgs e)
{
if (editFlag == 1)
{
WMS_Shelf_Bll.Insert_Shelf(wms_Shelf_Model);
}
else if (editFlag == 2)
{
WMS_Shelf_Bll.Update_Shelf(wms_Shelf_Model, " ShelfName = '" + shelfName + "'");
}
editFlag = 0;
Page_Frush();
ShelfDataGrid.CanUserAddRows = false;
ShelfDataGrid.IsReadOnly = true;
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_Shelf_Model> GetShelfList()
{
List <WMS_Shelf_Model> list = new List <WMS_Shelf_Model>();
DataTable dt = WMS_Shelf_Bll.Select_Shelf(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Shelf_Model wms_Shelf_Model = new WMS_Shelf_Model
{
ShelfName = dt.Rows[i]["ShelfName"].ToString(),
ShelfNo = dt.Rows[i]["ShelfNo"].ToString(),
AreaNo = dt.Rows[i]["AreaNo"].ToString(),
WarehouseNo = dt.Rows[i]["WarehouseNo"].ToString(),
Remark = dt.Rows[i]["Remark"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_Shelf_Model);
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_StoreDisplay_Model> GetStoreDisplayList()
{
List <WMS_StoreDisplay_Model> list = new List <WMS_StoreDisplay_Model>();
DataTable dataTable = WMS_Stock_Bll.Select_StockDisplay();
DataTable shelfDt = WMS_Shelf_Bll.Select_Shelf("ORDER");
for (int i = 0; i < shelfDt.Rows.Count; i++) //货架数
{
DataTable dt = new DataTable();
dt = dataTable.AsEnumerable().Where(o => o.Field <string>("AreaNo").ToString() == shelfDt.Rows[i]["AreaNo"].ToString()).CopyToDataTable();
int f = 1;
for (int m = 0; m < dt.Rows.Count; m++) //已存PACK
{
for (int j = 1; j <= int.Parse(dt.Rows[m]["ShelfNo"].ToString().Substring(2)); j++) //以空补足未存位置--竖
{
if (int.Parse(dt.Rows[m]["LocationNo"].ToString().Substring(2)) == j)
{
for (int n = f; n < int.Parse(dt.Rows[m]["ShelfNo"].ToString().Substring(0, 2)); n++)//以空补足未存位置--横
{
if (int.Parse(dt.Rows[m]["LocationNo"].ToString().Substring(0, 2)) == f)
{
SetColumn(f, dt.Rows[m]["SN"].ToString());
}
f++;
if (f == int.Parse(dt.Rows[m]["ShelfNo"].ToString().Substring(0, 2)))
{
f = 1;
}
}
}
list.Add(wMS_StoreDisplay_Model);
wMS_StoreDisplay_Model = new WMS_StoreDisplay_Model();
}
}
}
return(list);
}