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