/// <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>
/// <returns></returns>
public static int Update_PutIn(WMS_PutIn_Model wms_PutIn_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_PutIn_Dal.Update_PutIn(wms_PutIn_Model, condition)));
}
}
/// <summary>
/// 插入入库
/// </summary>
/// <returns></returns>
public static int Insert_PutIn(WMS_PutIn_Model wms_PutIn_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_PutIn_Dal.Insert_PutIn(wms_PutIn_Model)));
}
}
/// <summary>
/// 插入入库
/// </summary>
/// <returns></returns>
public static string Insert_PutIn(WMS_PutIn_Model wms_PutIn_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_PutIn]"
+ "([ShelfNo],[PutInNo],[SN],[OrderNo],[PutInType]"
+ ",[Status],[PutInTime])VALUES('" + wms_PutIn_Model.ShelfNo
+ "','" + wms_PutIn_Model.PutInNo + "','" + wms_PutIn_Model.SN
+ "','" + wms_PutIn_Model.OrderNo + "','" + wms_PutIn_Model.PutInType
+ "','" + wms_PutIn_Model.Status + "','" + wms_PutIn_Model.PutInTime
+ "')";
return(_insertSql);
}
/// <summary>
/// 更新入库
/// </summary>
/// <returns></returns>
public static string Update_PutIn(WMS_PutIn_Model wms_PutIn_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_PutIn]"
+ "SET[ShelfNo] = '" + wms_PutIn_Model.ShelfNo
+ "',[PutInNo] = '" + wms_PutIn_Model.PutInNo
+ "',[SN] = '" + wms_PutIn_Model.SN
+ "',[OrderNo] = '" + wms_PutIn_Model.OrderNo
+ "',[PutInType] = '" + wms_PutIn_Model.PutInType
+ "',[Status] = '" + wms_PutIn_Model.Status
+ "',[PutInTime] = '" + wms_PutIn_Model.PutInTime
+ "' WHERE " + condition;
return(_updateSql);
}
/// <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);
}
/// <summary>
/// 编辑事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void StockDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
wms_PutIn_Model = e.Row.Item as WMS_PutIn_Model;
snName = wms_PutIn_Model.SN;
}
