Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
        }
Пример #5
0
        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);
        }
Пример #6
0
        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);
        }