阅读二代证的WinCE PDA智能设备应用程序

        最近有用VS 2005 .NET Compact Framework 库开发一个PDA智能设备应用程序，该PDA采用WinCE5.0嵌入式操作系统及SQL Server CE 数据库，本程序主要功能是：阅读二代居民身份证信息及保存、打印来访登记信息。

  以下是程序部分截屏：

以下是“登记携带物品”函数实现：

       //登记携带物品
        private void btnDJWP_Click(object sender, EventArgs e)
        {
            string szIDCode = tbIDCode.Text.Trim();
            if (szIDCode == null || szIDCode.Equals(""))
            {
                MessageBox.Show("请先读身份证!");
                return;
            }           

            if (this.connection.State.Equals(ConnectionState.Closed))
                this.connection.Open();

            // Dispose previous SqlCeCommand and previous SqlCeResultSet
            if (null != this.command) this.command.Dispose();

            //Creates a Command with the associated connection           
            this.command = this.connection.CreateCommand();

            SqlCeTransaction tx = this.connection.BeginTransaction();
            this.command.Transaction = tx;

            try
            {
                //保存携带物品
                string szQuery =
                         "INSERT INTO Article " +
                         "( [ArtName], [ArtCount], [ArtDesc], [IDCode], [InTime] ) " +
                         "VALUES( @ArtName, @ArtCount, @ArtDesc, @IDCode, @InTime )";

                this.command.CommandText = szQuery;
                this.command.Parameters.Add("@ArtName", SqlDbType.NVarChar, 20).Value = tbArtName.Text.Trim();
              // 略... ...                
                this.command.ExecuteNonQuery();

                tx.Commit();
                MessageBox.Show("物品登记成功!");

                cbDept.Focus();

            }
            catch (Exception ex)
            {
                tx.Rollback();
                MessageBox.Show("物品登记错误:" + ex.Message);
            }
            finally
            {
                if (this.connection != null && !this.connection.State.Equals(ConnectionState.Closed))
                {
                    this.connection.Close();
                }

            }                
        }

 

 

 

【友情链接 | 橱窗推荐】