public List <FGPicking> GetPickingDetailList(FGPicking baseFGPicking) { List <FGPicking> collections = new List <FATHBarcode.Model.Object.FGPicking>(); var script = @"SELECT [Part No.], [Location], [Tag No.], [Qty.] FROM FGPicking WHERE [Delivery Order Tag] = @DELIVERYORDERTAG AND [Part No.] = @PARTNO"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", baseFGPicking["Delivery Order Tag"]); cmd.Parameters.Add("PARTNO", baseFGPicking["Part No."]); var reader = cmd.ExecuteReader(); while (reader.Read()) { var fgPicking = new FGPicking(); fgPicking["Delivery Order Tag"] = baseFGPicking["Delivery Order Tag"]; fgPicking["Location"] = reader["Location"]; fgPicking["Part No."] = reader["Part No."]; fgPicking["Tag No."] = reader["Tag No."]; fgPicking["Qty."] = reader["Qty."]; collections.Add(fgPicking); } } } return(collections); }
private void fgPickingDataGrid_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var fgPicking = new FATHBarcode.Model.Object.FGPicking(); fgPicking["Delivery Order Tag"] = deliveryOrderTagTextbox.Text; fgPicking["Part No."] = fgPickingDataGrid[fgPickingDataGrid.CurrentCell.RowNumber, 1].ToString(); var view = new FGPickingDetail(); var repository = new FATHBarcode.Model.Object.FGPickingRepository(); var presenter = new Presenter.FGPickingDetailPresenter(view, repository, fgPicking, Presenter.Screen); view.ShowDialog(); if (presenter.DeleteFrag) { Presenter.UpdateAllQty(); } } }
public int RemoveFATHTag(FGPicking fGPicking) { var script = @"DELETE FROM FATHTag WHERE ([Delivery Order Tag] = @DELIVERYORDERTAG) AND ([Part No.] = @PARTNO) AND ([Tag No.] = @TAGNO)"; using (var conn = dbConnect.GetConnection()) { conn.Open(); using (var cmd = new SqlCeCommand(script, conn)) { cmd.Parameters.Add("DELIVERYORDERTAG", fGPicking["Delivery Order Tag"].ToString()); cmd.Parameters.Add("PARTNO", fGPicking.PartNo); cmd.Parameters.Add("TAGNO", fGPicking.TagNo); return(cmd.ExecuteNonQuery()); } } }