private void ReceiveBox() { Int32?iSerial = null; Int32?iResult = null; PODetailsTableAdapter taPODetails = new PODetailsTableAdapter(); taPODetails.ReceiveItem(PO, Part, Operator, Qty, 1, SID, Lot, PrintServer, ref iSerial, ref iResult); SerialReceived(iSerial); }
private void LotEntered(String sLot) { Lot = sLot; uxEnterLot.Text = "Clear"; uxLot.Text = Lot; uxLot.Enabled = false; var connection1 = new SqlConnection(connectionString1); string command1 = "SET ARITHABORT ON; select PackingSlip from edi.vw_ASN_DixieWire where SerialNo = '" + uxLot.Text + "'"; string command2 = "SET ARITHABORT ON; select PONumber from edi.vw_ASN_DixieWire where SerialNo = '" + uxLot.Text + "'"; string command3 = "SET ARITHABORT ON; select Part from edi.vw_ASN_DixieWire where SerialNo = '" + uxLot.Text + "'"; string command4 = "SET ARITHABORT ON; select PartQty from edi.vw_ASN_DixieWire where SerialNo = '" + uxLot.Text + "'"; var command5 = new SqlCommand(command1, connection1); var command6 = new SqlCommand(command2, connection1); var command7 = new SqlCommand(command3, connection1); var command8 = new SqlCommand(command4, connection1); MyRFGun.GoodReadNotification(); if (uxSID.Enabled == true && uxPart.Enabled == true && uxPO.Enabled == true && uxQty.Enabled == true) { connection1.Open(); var shipper1 = (string)command5.ExecuteScalar(); if (shipper1 != null) { EnterSID(shipper1); } var po1 = (string)command6.ExecuteScalar(); if (po1 != null) { EnterPO(po1); } var part1 = (string)command7.ExecuteScalar(); if (part1 != null) { EnterPart(part1); } var quanity1 = (string)command8.ExecuteScalar(); if (quanity1 != null) { EnterQty(quanity1); } connection1.Close(); } Decimal? NextDueAmount = null; DateTime?NextDueDate = null; Int32? iResult = null; var taPODetails = new PODetailsTableAdapter { Connection = new SqlConnection { ConnectionString = connectionString1 } }; taPODetails.ValidatePOPartQty(PO, Part, Qty, 1, ref NextDueAmount, ref NextDueDate, ref iResult); }
private void EnterPart(String sPart) { Decimal? NextDueAmount = null; DateTime?NextDueDate = null; Int32? iResult = null; PODetailsTableAdapter taPODetails = new PODetailsTableAdapter(); taPODetails.ValidatePOPartQty(PO, sPart, Qty, 1, ref NextDueAmount, ref NextDueDate, ref iResult); MyRFGun.GoodReadNotification(); PartEntered(sPart); }
private void EnterQty(String sQty) { Decimal decQty = Convert.ToDecimal(sQty); Decimal? NextDueAmount = null; DateTime?NextDueDate = null; Int32? iResult = null; PODetailsTableAdapter taPODetails = new PODetailsTableAdapter(); taPODetails.ValidatePOPartQty(PO, Part, decQty, 1, ref NextDueAmount, ref NextDueDate, ref iResult); MyRFGun.GoodReadNotification(); QtyEntered(decQty); }
private void EnterPO(string sPO) { Int32 iPO = Convert.ToInt32(sPO); Decimal? NextDueAmount = null; DateTime?NextDueDate = null; Int32? iResult = null; PODetailsTableAdapter taPODetails = new PODetailsTableAdapter(); taPODetails.ValidatePOPartQty(iPO, Part, Qty, 1, ref NextDueAmount, ref NextDueDate, ref iResult); MyRFGun.GoodReadNotification(); POEntered(iPO); }
private void ReceiveBox() { Int32?iSerial = null; Int32?iResult = null; var taPODetails = new PODetailsTableAdapter { Connection = new SqlConnection { ConnectionString = connectionString1 } }; taPODetails.ReceiveItem(PO, Part, Operator, Qty, 1, location, SID, Lot, _printServer, ref iSerial, ref iResult); SerialReceived(iSerial); }