enquiry.cs

Symbol_MC3000_C#.条码扫码范例程序之2

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace Fyfjm
{
    public partial class Enquiry : Form
    {
        private SymbolScanWood.SymbolScanWood _objScan = new SymbolScanWood.SymbolScanWood("Text");
        private SqlCeConnection cn = new SqlCeConnection();
        private Symbol.Audio.Controller MyAudioController = null;
        private SqlCeCommand cm = new SqlCeCommand();
        

        public Enquiry()
        {
            InitializeComponent();
        }

        private void Enquiry_Load(object sender, EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;
            cn = Logic.DataAcess.CreateConnection();//创建连接
            cm = cn.CreateCommand();
            tbSKU.Focus();
            _objScan.MyAfterRead += new EventHandler(_objScan_OnAfterRead);//开启扫描
            Cursor.Current = Cursors.Default;
        }

        private void _objScan_OnAfterRead(object sender, EventArgs e)
        {
            tbSKU.Text = _objScan.BarcodeText;
            BarcodeScan(tbSKU.Text.Trim());
        }

        private void BarcodeScan(string Barcode)//条码处理
        {
            Symbol.Audio.Device MyDevice = (Symbol.Audio.Device)Symbol.StandardForms.SelectDevice.Select(
                                                        Symbol.Audio.Controller.Title, Symbol.Audio.Device.AvailableDevices);
            switch (MyDevice.AudioType)
            {
                //if standard device
                case Symbol.Audio.AudioType.StandardAudio:
                    MyAudioController = new Symbol.Audio.StandardAudio(MyDevice);
                    break;

                //if simulated device
                case Symbol.Audio.AudioType.SimulatedAudio:
                    MyAudioController = new Symbol.Audio.SimulatedAudio(MyDevice);
                    break;

                default:
                    throw new Symbol.Exceptions.InvalidDataTypeException("Unknown Device Type");

            }
            int Duration = 250;
            int Frequency = 2670;
            MyAudioController.PlayAudio(Duration, Frequency);
            MyAudioController.Dispose();

            try
            {
                cm.CommandText = string.Format("select * from Enquiry where SKU = '{0}'", tbSKU.Text.Trim());
                SqlCeDataReader dr = cm.ExecuteReader();
                if (!dr.Read())
                {
                    MessageBox.Show("The Data bank have not found this SKU Barcode's information", "Register", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1);
                    tbCode.Text = "";
                    tbColor.Text = "";
                    tbSize.Text = "";
                    tbPrice.Text = "";
                    tbSKU.Text = "";
                    tbSKU.Focus();
                }
                else
                {
                    tbCode.Text = SymbolScanWood.WoodConvert.ToString(dr["Code"]);
                    tbColor.Text = SymbolScanWood.WoodConvert.ToString(dr["Color"]);
                    tbSize.Text = SymbolScanWood.WoodConvert.ToString(dr["Size"]);
                    tbPrice.Text = SymbolScanWood.WoodConvert.ToString(dr["Price"]);
                    tbSKU.Focus();
                }
            }
            catch (SqlCeException ex)
            {
                MessageBox.Show(ex.Message, "Register", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
                tbSKU.Focus();
            }
            catch (Exception ex1)
            {
                MessageBox.Show(ex1.Message, "Register", MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
                tbSKU.Focus();
            }
        }

        private void tbSKU_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.Enter:
                    BarcodeScan(tbSKU.Text.Trim());
                    break;
                case Keys.Escape:
                    Close();
                    break;
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }

        private void Enquiry_Activated(object sender, EventArgs e)
        {
            if (_objScan.InitReader())
            {
                _objScan.StartRead();
            }
        }

        private void Enquiry_Deactivate(object sender, EventArgs e)
        {
            _objScan.StopRead();
            _objScan.TermReader();
        }

        private void Enquiry_Closing(object sender, CancelEventArgs e)
        {
            _objScan.TermReader();
            Logic.DataAcess.Close();
            cn.Close();
            cn.Dispose();
            cn = null;
        }

        private void btEsc_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void Enquiry_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.F5:
                    Close();
                    break;
                default:
                    break;
            }
        }
    }
}