/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
stockBase.PutInList.Clear();
List <WMS_PutIn_Model> list = new List <WMS_PutIn_Model>();
DataTable dt = WMS_PutIn_Bll.Select_PutIn(" SN = '" + SearchText.Text.Trim() + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_PutIn_Model wMS_PutIn_Model = new WMS_PutIn_Model
{
ShelfNo = dt.Rows[i]["ShelfNo"].ToString(),
PutInNo = dt.Rows[i]["PutInNo"].ToString(),
SN = dt.Rows[i]["SN"].ToString(),
OrderNo = dt.Rows[i]["OrderNo"].ToString(),
PutInType = dt.Rows[i]["PutInType"].ToString(),
Status = dt.Rows[i]["Status"].ToString(),
PutInTime = dt.Rows[i]["PutInTime"].ToString()
};
list.Add(wMS_PutIn_Model);
}
foreach (var model in list)
{
stockBase.PutInList.Add(model);
}
this.PutInDataGrid.ItemsSource = stockBase.PutInList;
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Delete_Click(object sender, RoutedEventArgs e)
{
foreach (var no in selectSnName)
{
WMS_PutIn_Bll.Delete_PutIn(" SN = '" + 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_PutIn_Bll.Insert_PutIn(wms_PutIn_Model);
}
else if (editFlag == 2)
{
WMS_PutIn_Bll.Update_PutIn(wms_PutIn_Model, " SN = '" + snName + "'");
}
editFlag = 0;
Page_Frush();
PutInDataGrid.CanUserAddRows = false;
PutInDataGrid.IsReadOnly = true;
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_PutIn_Model> GetPutInList()
{
List <WMS_PutIn_Model> list = new List <WMS_PutIn_Model>();
DataTable dt = WMS_PutIn_Bll.Select_PutIn(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_PutIn_Model wms_PutIn_Model = new WMS_PutIn_Model
{
ShelfNo = dt.Rows[i]["ShelfNo"].ToString(),
PutInNo = dt.Rows[i]["PutInNo"].ToString(),
SN = dt.Rows[i]["SN"].ToString(),
OrderNo = dt.Rows[i]["OrderNo"].ToString(),
PutInType = dt.Rows[i]["PutInType"].ToString(),
Status = dt.Rows[i]["Status"].ToString(),
PutInTime = dt.Rows[i]["PutInTime"].ToString()
};
list.Add(wms_PutIn_Model);
}
return(list);
}
