上访人员识别系统的设计与实现_毕业论文范文网-论文范文

搜索高级搜索

原创毕业论文

上访人员识别系统的设计与实现

作者: 浏览:10次

免费专业论文
政治工作论文
计算机论文
营销专业论文
工程管理论文范文
医药医学论文范文
法律论文范文
生物专业论文
物理教学论文范文
人力资源论文范文
化学教学论文范文
电子专业论文范文
历史专业论文
电气工程论文
社会学专业论文
英语专业论文
行政管理论文范文
语文专业论文
电子商务论文范文
焊工钳工技师论文
社科文学论文
教育论文范文
数学论文范文
物流论文范文
建筑专业论文
食品专业论文
财务管理论文范文
工商管理论文范文
会计专业论文范文
专业论文格式
化工材料专业论文
英语教学专业论文
电子通信论文范文
旅游管理论文范文
环境科学专业论文
经济论文
人力资源论文范文
营销专业论文范文
财务管理论文范文
物流论文范文
财务会计论文范文
数学教育论文范文
数学与应用数学论文
电子商务论文范文
法律专业论文范文
工商管理论文范文
汉语言文学论文
计算机专业论文
教育管理论文范文
现代教育技术论文
小学教育论文范文
机械模具专业论文
报告,总结,申请书
心理学论文范文
学前教育论文范文

收费计算机专业论文范文

收费计算机专业论文
Delphi
ASP
VB
JSP
ASP.NET
VB.NET
java
VC
pb
VS
dreamweaver
c#.net
vf
VC++
计算机论文

毕业论文范文题目：上访人员识别系统的设计与实现，论文范文关键词：上访人员识别系统的设计与实现
上访人员识别系统的设计与实现毕业论文范文介绍开始：

上访人员识别系统的设计与实现
[摘要] 信访工作，是党和政府联系人民群众的桥梁和纽带。近年来，随着大多数人的维权意识逐步加强，群众信访活动非常活跃，信访总量在高位运行。信访出现了许多新情况、新问题。大部分群众的上访行为理性、合法，但也有少数人对《信访条例》在理解上有欠缺，不按规定的法律程序上访；还有一些群众的诉求虽然合理，但在上访过程中存在违法现象，严重扰乱社会正常秩序，给新形势下的信访工作提出了新的要求。上访人员识别系统正是为适应新形势下信访快节奏的要求，运用现代化的通信网络，简单快速识别是否为重点上访人员而开发的系统。信访工作作为各级党政部门与群众联系，群众与党政机关联系的桥梁和纽带，在构建和谐社会这一战略中，起到举足轻重的作用。特别是随着改革不断深化、经济社会加速转型以及社会利益格局的调整，管理机制也随之发生重大变革。
[关键词]上访人员 ACCESS C# 身份证阅读器
[引言]上访人员识别系统正是为了快速识别上访人员是否曾经不按规定的法律程序上访或上访过程中存在违法现象而开发的系统。
上访人员识别系统通过第二代身份证阅读器检验上访人员的身份证，来识别此上访人员是否曾经有不按规定的法律程序上访或上访过程中存在违法的现象。
上访人员识别系统采用ACCESS数据库，C#语言开发而成。此系统可以增加、修改、删除违法上访人员信息，也可以导入导出违法上访人员信息（上访人员信息数据格式为EXCEL文件），跟第二代身份证阅读器的接口相接。只要运行上访人员识别系统，把身份证放到身份证阅读器上就可以识别是否为曾经有不按规定的法律程序上访或上访过程中存在违法现象的上访人员。
一、需求分析
1、特性需求分析
目前信访工作很复杂，一些违法人员为了逃避信访工作人员的劝阻，想方设法的进京上访，给首都的治安造成很大的不确定性。为了躲住这些人员的交通方式，特设在汽车站、火车站、路卡设置有上访人员识别系统，这就促使该系统具有以下特性：（1）速度快；（2）可靠性；（3）稳定性；（4）操作简单、傻瓜化。
2、上访人员识别系统初步设计要实现以下功能：
2.1违法上访人员信息的浏览；
2.2违法上访人员信息的增加、修改、删除；
2.3违法上访人员信息的导入、导出；
2.4用身份证阅读器识别是否为违法上访人员；
2.5检验出违法上访人员信息后，用红色显示浏览，双击后弹出违法上访人员的详细信息；
2.6检验出违法上访人员信息后，用声音提示；
2.7系统权限分为管理员与操作员；
3、上访人员识别系统的基本结构图如下：

用声音提示

4、数据库设计

上访人员识别系统采用的是 Access 数据库，建立一个数据库文件，是rysb.mdb。在其中建立两个表，一个是登录人员（Cashier），表内包含7个字段。其结构如下图：

另一个是上访人员信息表（Customer），表内包含33个字段。其包含的字段名称是自动编号、身份证号、姓名、性别、民族、民族、身份、文化程度、责任单位、责任单位、户口所在地、上访省份、现住址、重点人级别、问题类别、反映问题、标题、发生时间起、发生地点、发生地点详址、管辖部门、填报部门、行为方式、涉及人数、简要情况、问题分类、反映问题_1、发现人单位、出警单位、情况分类、行为方式说明、是否正常访、初访重访。其结构如下图：

二、概要设计
1、技术路线
本系统采用C#语言编写，数据库为ACCESS。编写工具使用Microsoft Visual Studio 2010，编写过程中要用到第二代身份证阅读器的接口程序。
2、实现过程
2.1安装Microsoft Visual Studio 2010、安装Microsoft Office 2007(装ACCESS)、安装第二代身份证阅读器驱动；
2.2按照需求分析中建立一个数据库sfry.mdb;
打开Microsoft Access 2007，新建一个数据库，名称为sfry。
2.3设计系统的登录窗口和登录后的界面；
打开Microsoft Visual Studio 2010，新建一个项目MemCardSys.sln，然后新建一个项为frmLogin.cs，然后设计登录界面如下：
在项目MemCardSys.sln中再新建一个项frmMain.cs，然后设计界面如下：
2.4按照需求分析中设计违法上访人员信息的浏览；
在项目MemCardSys.sln中新建一个项frmList.cs，设计界面如下：
2.5按照需求分析中设计违法上访人员信息的增加、修改、删除；
设计增加、修改、删除功能时，因为涉及到人员权限，所以把增加记录、修改记录、删除记录按钮的Visible属性值设置为Flase。如下图：
2.6按照需求分析中设计违法上访人员信息的导入、导出；
设计导入、导出功能时，因为涉及到人员权限，所以把导入EXCEL、导出EXCEL按钮的Visible属性值设置为Flase。如下图：

2.7按照需求分析中设计身份证阅读器的接口程序与本系统对接；
引用身份证阅读器的接口，如下图：

然后在项frmMain.cs中添加using SYNCARDOCXLib;
2.8按照需求分析中检验出违法上访人员后，系统的显示与声音提示；
此处涉及到在公众场所引起混乱，所以系统设计声音隐蔽性提示，如是违法人员，系统声音提示“请稍等”，如是一般群众，系统声音提示“您好”。具体代码实现如下：
            //卡号验证
            if (txtValue.Text.Trim() == String.Empty)
            {
                this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
            }
            else
            {
                if (txtValue.Enabled && DataValidator.IsIdCard(txtValue.Text.Trim()))
                {
                    this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Red;
                    System.Media.SoundPlayer player = new System.Media.SoundPlayer(AppDomain.CurrentDomain.BaseDirectory + @"\wait.wav");
                    player.LoadAsync();
                    player.PlayLooping(); //asynchronous (loop)playing in new thread
                    Thread.Sleep(1000);
                    player.Stop();
                }
                else
                {
                    this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
                    System.Media.SoundPlayer player = new System.Media.SoundPlayer(AppDomain.CurrentDomain.BaseDirectory + @"\hello.wav");
                    player.LoadAsync();
                    player.PlayLooping(); //asynchronous (loop)playing in new thread
                    Thread.Sleep(1000);
                    player.Stop();
                }
            }
            RefreshList(); //刷新列表
2.9按照需求分析中设计系统的权限；
系统权限分为管理员权限和一般人员权限，管理员权限是系统里面的所有功能都可以使用，一般人员权限只有刷身份证的权限。所以在各个功能处添加以下语句：
switch (type)
            {
                case Constant.FunType.CardSend:
                    this.Text = "上访人员信息";
                    if (CN.SH.SDD.MemCardSys.Base.Global.station == 0)
                    {
                        tsbtAdd.Visible = true;
                        tsbtUpdate.Visible = true;
                        tsbtDelete.Visible = true;
                        tsbtDaoRu.Visible = true;
                        tsbtDaoChu.Visible = true;
                        //tsbtExit.Visible = true;
                    }
                    break;
            }
三、详细设计
1、功能模块设计
1.1登录模块
用户登录模块是系统管理员进入主页面的入口，其运行结果如图所示。

其代码实现如下：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CN.SH.SDD.MemCardSys;
using CN.SH.SDD.MemCardSys.Base;
using CN.SH.SDD.MemCardSys.Commons;
using CN.SH.SDD.MemCardSys.Entity;
using System.Data.OleDb;
namespace CN.SH.SDD.MemCardSys
{
    public partial class frmLogin : Form
    {
        private SqlHelper m_helper;
        private StringBuilder m_sbSql;
        private string m_usr;
        private string m_pwd;
        public frmLogin()
        {
            InitializeComponent();
            m_helper = new SqlHelper();
        }
        /// <summary>
        /// 显示列表窗体
        /// </summary>
        /// <param name="type"></param>
        private void ShowForm(Constant.FunType type)
        {
            frmList frm = new frmList(type);
            frm.TopLevel = false;
            frm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
            //plMain.Controls.Clear();
            //plMain.Controls.Add(frm);
            frm.Show();
            //plMain.Refresh();

}

        /// <summary>
        /// 查询SQL语句
        /// </summary>
        private void QuerySqlString()
        {
            m_sbSql = new StringBuilder();
            m_sbSql.Append(" SELECT *FROM Cashier WHERE");
            m_sbSql.Append(" CashierId = '" + m_usr + "'");

        }
        /// <summary>
        /// 取得管理员信息
        /// </summary>
        private Cashier GetInfo()
        {
            Cashier entity = null;

            try
            {
                QuerySqlString();
                OleDbDataReader reader = m_helper.ReturnDataReader(m_sbSql.ToString());
                if (reader.Read())
                {
                    entity = new Cashier();
                    entity.Id = reader.GetInt32(0);
                    entity.CashierId = reader.GetString(1);
                    entity.CashierName = reader.GetString(2);
                    entity.Station = reader.GetByte(3);
                    entity.Password = reader.GetString(4);
                    entity.Status = reader.GetByte(5);
                    entity.CreateDate = reader.GetDateTime(6);
                }
            }
            catch (System.Exception ex)
            {
                entity = null;
                System.Console.WriteLine(ex.ToString());
            }finally{
                m_helper.CloseConnection();
            }

            return entity;
        }
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnLogin_Click(object sender, EventArgs e)
        {
            lbMsg.Text = string.Empty;

            m_usr = txtUser.Text.Trim();
            m_pwd = txtPwd.Text.Trim();
            if(null == m_usr || m_usr.Equals(string.Empty))
            {
                lbMsg.Text = "用户名不能为空！ ";
                return;
            }
            if (null == m_pwd || m_pwd.Equals(string.Empty))
            {
                lbMsg.Text = "密码不能为空！";
                return;
            }
            Cashier entity = GetInfo();
            if (entity.Status != 0)
            {
                lbMsg.Text = "该用户已注销！ ";
                return;
            }
            if (null == entity || !entity.Password.Equals(m_pwd))
            {
                lbMsg.Text = "该用户名不存在或密码输入错误！ ";
                return;
            }
            Global.cashierId = entity.CashierId;
            Global.station = entity.Station;
            this.DialogResult = DialogResult.OK;
            this.Close();
        }
    }
}
    系统登陆是上访人员识别系统中最先使用的功能，因为用户登陆在数据库中使用的是用户表。在登陆时要根据数据库的字段来判断此用户是否具有管理员的权限。
1.2信息浏览模块
系统登录进去后，用户点菜单上访人员信息，就可进入此功能，在此界面下还可以实现以下功能：信息导入、导出模块、系统与身份证阅读器接口对接模块、系统检验出违法上访人员后的显示与提示模块，如下图：

实现代码如下：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CN.SH.SDD.MemCardSys.Commons;
using CN.SH.SDD.MemCardSys.Base;
using CN.SH.SDD.MemCardSys.Entity;
using System.Threading;
using System.Media;
using System.IO;

namespace CN.SH.SDD.MemCardSys
{
public partial class frmList : Form
{

#region -------------------------- 成员变量----------------------------
private SqlHelper helper;

        /// <summary>
        /// 查询条件
        /// </summary>
        private string m_cardNo     = String.Empty;
        private string m_name       = String.Empty;
        private string m_cfcf     = String.Empty;
        private void RefreshDataSource()
        {
        }

#endregion

#region -------------------------- 数据处理----------------------------

        /// <summary>
        /// 生成SQL语句
        /// </summary>
        private string CreateSqlString()
        {
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append(" SELECT ");
            sbSql.Append(" CardNo                   AS 身份证号,");
            sbSql.Append(" Name                      AS 姓名,");
            sbSql.Append(" IIF(IsNull(Xb),null,Xb)   AS 性别,");
            sbSql.Append(" IIF(IsNull(Mz),null,Mz)   AS 民族,");
            sbSql.Append(" IIF(IsNull(Csrq),null,Csrq) AS 出生日期,");
            sbSql.Append(" IIF(IsNull(Sf),null,Sf)      AS 身份,");
            sbSql.Append(" IIF(IsNull(Whcd),null,Whcd)   AS 文化程度,");
            sbSql.Append(" IIF(IsNull(Zrdw),null,Zrdw)   AS 责任单位,");
            sbSql.Append(" IIF(IsNull(Gzdw),null,Gzdw)   AS 工作单位,");
            sbSql.Append(" IIF(IsNull(Hkszd),null,Hkszd) AS 户口所在地,");
            sbSql.Append(" IIF(IsNull(Sfsf),null,Sfsf)   AS 上访省份,");
            sbSql.Append(" IIF(IsNull(Xzz),null,Xzz)     AS 现住址,");
            sbSql.Append(" IIF(IsNull(Zdrjb),null,Zdrjb) AS 重点人级别,");
            sbSql.Append(" IIF(IsNull(Wtlb),null,Wtlb)   AS 问题类别,");
            sbSql.Append(" IIF(IsNull(Fywt),null,Fywt)   AS 反映问题,");
            sbSql.Append(" IIF(IsNull(Bt),null,Bt)       AS 标题,");
            sbSql.Append(" IIF(IsNull(Fssj),null,Fssj)   AS 发生时间起,");
            sbSql.Append(" IIF(IsNull(Fsdd),null,Fsdd)   AS 发生地点,");
            sbSql.Append(" IIF(IsNull(Fsddxz),null,Fsddxz) AS 发生地点详址,");
            sbSql.Append(" IIF(IsNull(Gxbm),null,Gxbm)    AS 管辖部门,");
            sbSql.Append(" IIF(IsNull(Tbbm),null,Tbbm)    AS 填报部门,");
            sbSql.Append(" IIF(IsNull(Xwfs),null,Xwfs)    AS 行为方式,");
            sbSql.Append(" IIF(IsNull(Sjrs),null,Sjrs)    AS 涉及人数,");
            sbSql.Append(" IIF(IsNull(Jyqk),null,Jyqk)    AS 简要情况,");
            sbSql.Append(" IIF(IsNull(Wtfl),null,Wtfl)    AS 问题分类,");
            sbSql.Append(" IIF(IsNull(Fywt_1),null,Fywt_1) AS 反映问题_1,");
            sbSql.Append(" IIF(IsNull(Fxrdw),null,Fxrdw)   AS 发现人单位,");
            sbSql.Append(" IIF(IsNull(Cjdw),null,Cjdw)    AS 出警单位,");
            sbSql.Append(" IIF(IsNull(Qkfl),null,Qkfl)    AS 情况分类,");
            sbSql.Append(" IIF(IsNull(Xwfssm),null,Xwfssm) AS 行为方式说明,");
            sbSql.Append(" IIF(IsNull(Sfzc),null,Sfzc)     AS 是否正常访,");
            sbSql.Append(" IIF(IsNull(Cfcf),null,Cfcf)     AS 初访重访,");
            sbSql.Append(" Id                              AS 自动编号");
            sbSql.Append(" FROM Customer");
            sbSql.Append(" WHERE 1=1");
            sbSql.Append(" AND CardNo LIKE '%" + m_cardNo + "%'");
            sbSql.Append(" AND Name LIKE '%" + m_name + "%'");
            sbSql.Append(" AND IIF(IsNull(Cfcf),0,Cfcf) LIKE '%" + m_cfcf + "%'");
            return sbSql.ToString();
        }
        /// <summary>
        /// 记录删除
        /// </summary>
        /// <param name="cardNo"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        private string DeleteSqlString(int Id)
        {
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append(" Delete *FROM Customer WHERE Id =" + Id);
            return sbSql.ToString();
        }
        #endregion

        #region -------------------------- 业务处理----------------------------
        /// <summary>
        /// 构造函数
        /// </summary>
        public frmList(Constant.FunType type)
        {
            InitializeComponent();
            InitLayout(type);
            helper = new SqlHelper();
            RefreshList();
            txtValue.Text = Global.stmp;
            btnSearch_Click(this, null);
        }

        private void InitLayout(Constant.FunType type)
        {
            switch (type)
            {
                case Constant.FunType.CardSend:
                    this.Text = "上访人员信息";
                    if (CN.SH.SDD.MemCardSys.Base.Global.station == 0)
                    {
                        tsbtAdd.Visible = true;
                        tsbtUpdate.Visible = true;
                        tsbtDelete.Visible = true;
                        tsbtDaoRu.Visible = true;
                        tsbtDaoChu.Visible = true;
                        //tsbtExit.Visible = true;
                    }
                    break;
            }
        }
        /// <summary>
        /// 刷新数据
        /// </summary>
        private void RefreshList()
        {
            //绑定数据到DataGridView
            dgvList.DataSource = this.GetCustomerInfo().Tables[0];
        }
        /// <summary>
        /// 重置查询条件t
        /// </summary>
        private void ResetValues()
        {
            m_cardNo = String.Empty;
            m_name = String.Empty;
            m_cfcf = String.Empty;
        }
        /// <summary>
        /// 会员信息取得
        /// </summary>
        /// <returns></returns>
        private DataSet GetCustomerInfo()
        {
            return helper.ReturnDataSet(CreateSqlString());
        }
        /// <summary>
        /// 记录删除
        /// </summary>
        /// <returns></returns>
        private bool DeleteCustomer(int Id)
        {
            bool rslt = false;
            try
            {
                helper.ExeSQL(DeleteSqlString(Id));
                rslt = true;
            }
            catch (System.Exception ex)
            {
                System.Console.WriteLine(ex.ToString());
            }
            return rslt;
        }

#endregion

        #region ------------------------ 事件处理------------------------------
        /// <summary>
        /// 查询事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSearch_Click(object sender, EventArgs e)
        {

ResetValues(); //重置查询条件

            int conditionType = cmbCondition.SelectedIndex;
            switch (conditionType)
            {
                case 0: m_cardNo = txtValue.Text.Trim(); break;
                case 1: m_name = txtValue.Text.Trim(); break;
                case 2: m_cfcf = txtValue.Text.Trim(); break;
            }
            //卡号验证
            if (txtValue.Text.Trim() == String.Empty)
            {
                this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
            }
            else
            {
                if (txtValue.Enabled && DataValidator.IsIdCard(txtValue.Text.Trim()))
                {
                    this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Red;
                    System.Media.SoundPlayer player = new System.Media.SoundPlayer(AppDomain.CurrentDomain.BaseDirectory + @"\wait.wav");
                    player.LoadAsync();
                    player.PlayLooping(); //asynchronous (loop)playing in new thread
                    Thread.Sleep(1000);
                    player.Stop();
                }
                else
                {
                    this.dgvList.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
                    System.Media.SoundPlayer player = new System.Media.SoundPlayer(AppDomain.CurrentDomain.BaseDirectory + @"\hello.wav");
                    player.LoadAsync();
                    player.PlayLooping(); //asynchronous (loop)playing in new thread
                    Thread.Sleep(1000);
                    player.Stop();
                }
            }
            RefreshList(); //刷新列表
        }
        /// <summary>
        /// 添加会员信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtAdd_Click(object sender, EventArgs e)
        {
            frmMember frm = new frmMember(Constant.DlgType.CardAdd);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                RefreshList();
            }
        }
        /// <summary>
        /// 修改会员信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtUpdate_Click(object sender, EventArgs e)
        {
            int id = int.Parse(dgvList.SelectedRows[0].Cells[32].Value.ToString());
            frmMember frm = new frmMember(Constant.DlgType.CardModify,id);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                RefreshList();
            }
        }
        /// <summary>
        /// 退出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtExit_Click(object sender, EventArgs e)
        {
            this.Close();
            txtValue.Text = String.Empty;
            Global.stmp = String.Empty;
        }
        /// <summary>
        /// 记录删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtDelete_Click(object sender, EventArgs e)
        {
            int Id = int.Parse(dgvList.SelectedRows[0].Cells[32].Value.ToString());
            DialogResult result = MessageBox.Show("你确定要删除记录号：[" + Id + "]吗？", "删除", MessageBoxButtons.OKCancel);
            if (DialogResult.OK == result)
            {
                if (DeleteCustomer(Id))
                    MessageBox.Show("删除成功！");
                RefreshList();
            }
        }
        /// <summary>
        /// 记录导入EXCEL
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtDaoRu_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("导入将追加本表格数据", "警告", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                if (openFileDialog1.ShowDialog() == DialogResult.OK)
                {
                    if (openFileDialog1.OpenFile() != null)
                    {
                        if (Comm.EduceExcel(openFileDialog1.FileName))
                        {
                            try
                            {
                                b oakk = new b();
                                oakk.qingkong();
                                for (int i = 0; i < Comm.Dt.Rows.Count; i++)
                                {
                                    Customer ok = new Customer();
                                    ok.CardNo = Comm.Dt.Rows[i].ItemArray[0].ToString();
                                    ok.Name = Comm.Dt.Rows[i].ItemArray[1].ToString();
                                    ok.Xb = Comm.Dt.Rows[i].ItemArray[2].ToString();
                                    ok.Mz = Comm.Dt.Rows[i].ItemArray[3].ToString();
                                    ok.Csrq = Comm.Dt.Rows[i].ItemArray[4].ToString();
                                    ok.Sf = Comm.Dt.Rows[i].ItemArray[5].ToString();
                                    ok.Whcd = Comm.Dt.Rows[i].ItemArray[6].ToString();
                                    ok.Zrdw = Comm.Dt.Rows[i].ItemArray[7].ToString();
                                    ok.Gzdw = Comm.Dt.Rows[i].ItemArray[8].ToString();
                                    ok.Hkszd = Comm.Dt.Rows[i].ItemArray[9].ToString();
                                    ok.Sfsf = Comm.Dt.Rows[i].ItemArray[10].ToString();
                                    ok.Xzz = Comm.Dt.Rows[i].ItemArray[11].ToString();
                                    ok.Zdrjb = Comm.Dt.Rows[i].ItemArray[12].ToString();
                                    ok.Wtlb = Comm.Dt.Rows[i].ItemArray[13].ToString();
                                    ok.Fywt = Comm.Dt.Rows[i].ItemArray[14].ToString();
                                    ok.Bt = Comm.Dt.Rows[i].ItemArray[15].ToString();
                                    ok.Fssj = Comm.Dt.Rows[i].ItemArray[16].ToString();
                                    ok.Fsdd = Comm.Dt.Rows[i].ItemArray[17].ToString();
                                    ok.Fsddxz = Comm.Dt.Rows[i].ItemArray[18].ToString();
                                    ok.Gxbm = Comm.Dt.Rows[i].ItemArray[19].ToString();
                                    ok.Tbbm = Comm.Dt.Rows[i].ItemArray[20].ToString();
                                    ok.Xwfs = Comm.Dt.Rows[i].ItemArray[21].ToString();
                                    ok.Sjrs = Comm.Dt.Rows[i].ItemArray[22].ToString();
                                    ok.Jyqk = Comm.Dt.Rows[i].ItemArray[23].ToString();
                                    ok.Wtfl = Comm.Dt.Rows[i].ItemArray[24].ToString();
                                    ok.Fywt_1 = Comm.Dt.Rows[i].ItemArray[25].ToString();
                                    ok.Fxrdw = Comm.Dt.Rows[i].ItemArray[26].ToString();
                                    ok.Cjdw = Comm.Dt.Rows[i].ItemArray[27].ToString();
                                    ok.Qkfl = Comm.Dt.Rows[i].ItemArray[28].ToString();
                                    ok.Xwfssm = Comm.Dt.Rows[i].ItemArray[29].ToString();
                                    ok.Sfzc = Comm.Dt.Rows[i].ItemArray[30].ToString();
                                    ok.Cfcf = Comm.Dt.Rows[i].ItemArray[31].ToString();

b okk = new b(); okk.aadd(ok);
}

                                RefreshList();
                                MessageBox.Show("恭喜，上访信息导入成功！\t\t", "提示");
                            }
                            catch
                            {
                                MessageBox.Show("对不起，上访信息导入失败！ \t\t", "提示");
                            }
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 记录导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tsbtDaoChu_Click(object sender, EventArgs e)
{
    if (saveFileDialog1.ShowDialog() == DialogResult.OK)
    {
        Thread thread = null;
        switch (saveFileDialog1.FilterIndex)
        {
            case 1:
                thread = new Thread(new ThreadStart(DoExportExcel));
                break;
            case 2:
                thread = new Thread(new ThreadStart(DoExportCSV));
                break;
        }
        if (thread != null) thread.Start();
    }
}
        private void DoExportExcel()
        {
            Comm.ExportToExcel(dgvList, saveFileDialog1.FileName, false);
        }
        private void DoExportCSV()
        {
            Comm.ExportToCSV(this.dgvList, saveFileDialog1.FileName, false);
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
        }
        #endregion

private void stspMain_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{

}

        private void dgvList_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            int id = int.Parse(dgvList.SelectedRows[0].Cells[32].Value.ToString());
            frmMember frm = new frmMember(Constant.DlgType.CardCharge, id);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                RefreshList();
            }

}

        private void dgvList_DoubleClick(object sender, EventArgs e)
        {
            int id = int.Parse(dgvList.SelectedRows[0].Cells[32].Value.ToString());
            frmMember frm = new frmMember(Constant.DlgType.CardCharge, id);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                RefreshList();
            }

}
}
}
1.3信息增加、修改、删除模块
信息增加、修改、删除功能与上面的浏览功能相互联系，在浏览功能中双击某一条信息，就会弹出以下对话框：

其代码实现如下：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Windows.Forms;
using CN.SH.SDD.MemCardSys.Base;
using CN.SH.SDD.MemCardSys.Commons;
using CN.SH.SDD.MemCardSys.Entity;
using System.Data.OleDb;

namespace CN.SH.SDD.MemCardSys
{
    public partial class frmMember : Form
    {
        [System.Runtime.InteropServices.DllImport("kernel32.dll")]
        public static extern int Beep(int a, int b);
        private SqlHelper helper;
        private Customer customer;
        private int m_id;
        private bool chargeFlag = true;
        /// <summary>
        /// 业务类型
        /// </summary>
        private Constant.DlgType m_type;

        public frmMember(Constant.DlgType type)
        {
            InitializeComponent();
            helper = new SqlHelper();
            customer = new Customer();
            this.m_type = type;

        }
        public frmMember(Constant.DlgType type,int id)
        {
            InitializeComponent();
            helper = new SqlHelper();
            customer = new Customer();
            this.m_type = type;
            this.m_id = id;
            DBTOUI(id);
            this.Refresh();
        }

        private void frmMember_Load(object sender, EventArgs e)
        {
            InitDialog();

        }

        private void InitDialog()
        {
            switch (m_type)
            {
                case Constant.DlgType.CardAdd:
                    this.Text = "新增记录";
                    break;
                case Constant.DlgType.CardModify:
                    this.Text = "修改记录";
                    //this.txtCardNo.Enabled = false;
                    break;
                case Constant.DlgType.CardCharge:
                    this.Text = "人员详情";
                    this.btnCancle.Text = "退出(&E)";
                    this.btnOK.Visible = false;
                    break;
                default:
                    break;
            }


        }
        /// <summary>
        /// 构建新增会员实体
        /// </summary>
        /// <returns></returns>
        private void UITOEntity()
        {
            customer.CardNo = txtCardNo.Text.Trim();
            customer.Name = txtName.Text.Trim();
            customer.Xb = txtXb.Text.Trim();
            customer.Mz = txtMz.Text.Trim();
            customer.Csrq = txtCsrq.Text.Trim();
            customer.Sf = txtSf.Text.Trim();
            customer.Whcd = txtWhcd.Text.Trim();
            customer.Zrdw = txtZrdw.Text.Trim();
            customer.Gzdw = txtGzdw.Text.Trim();
            customer.Hkszd = txtHkszd.Text.Trim();
            customer.Sfsf = txtSfsf.Text.Trim();
            customer.Xzz = txtXzz.Text.Trim();
            customer.Zdrjb = txtZdrjb.Text.Trim();
            customer.Wtlb = txtWtlb.Text.Trim();
            customer.Fywt = txtFywt.Text.Trim();
            customer.Bt = txtBt.Text.Trim();
            customer.Fssj = txtFssj.Text.Trim();
            customer.Fsdd = txtFsdd.Text.Trim();
            customer.Fsddxz = txtFsddxz.Text.Trim();
            customer.Gxbm = txtGxbm.Text.Trim();
            customer.Tbbm = txtTbbm.Text.Trim();
            customer.Xwfs = txtXwfs.Text.Trim();
            customer.Sjrs = txtSjrs.Text.Trim();
            customer.Jyqk = txtJyqk.Text.Trim();
            customer.Wtfl = txtWtfl.Text.Trim();
            customer.Fywt_1 = txtFywt_1.Text.Trim();
            customer.Fxrdw = txtFxrdw.Text.Trim();
            customer.Cjdw = txtCjdw.Text.Trim();
            customer.Qkfl = txtQkfl.Text.Trim();
            customer.Xwfssm = txtXwfssm.Text.Trim();
            customer.Sfzc = txtSfzc.Text.Trim();
            customer.Cfcf = txtCfcf.Text.Trim();
        }

        /// <summary>
        /// 读取数据到界面
        /// </summary>
        private void DBTOUI(int id)
        {
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append(" SELECT * FROM Customer WHERE ID =" + id + "");
            OleDbDataReader reader = helper.ReturnDataReader(sbSql.ToString());
            if (reader.Read())
            {

                txtCardNo.Text = reader.GetString(0);
                txtName.Text = reader.GetString(1);
                if (reader["Xb"] == System.DBNull.Value)
                {
                    txtXb.Text = string.Empty;
                }
                else
                {
                    txtXb.Text = reader.GetString(2);
                }
                if (reader["Mz"] == System.DBNull.Value)
                {
                    txtMz.Text = string.Empty;
                }
                else
                {
                    txtMz.Text = reader.GetString(3);
                }
                if (reader["Csrq"] == System.DBNull.Value)
                {
                    txtCsrq.Text = string.Empty;
                }
                else
                {
                    txtCsrq.Text = reader.GetString(4);
                }
                if (reader["Sf"] == System.DBNull.Value)
                {
                    txtSf.Text = string.Empty;
                }
                else
                {
                    txtSf.Text = reader.GetString(5);
                }
                if (reader["Whcd"] == System.DBNull.Value)
                {
                    txtWhcd.Text = string.Empty;
                }
                else
                {
                    txtWhcd.Text = reader.GetString(6);
                }
                if (reader["Zrdw"] == System.DBNull.Value)
                {
                    txtZrdw.Text = string.Empty;
                }
                else
                {
                    txtZrdw.Text = reader.GetString(7);
                }
                if (reader["Gzdw"] == System.DBNull.Value)
                {
                    txtGzdw.Text = string.Empty;
                }
                else
                {
                    txtGzdw.Text = reader.GetString(8);
                }
                if (reader["Hkszd"] == System.DBNull.Value)
                {
                    txtHkszd.Text = string.Empty;
                }
                else
                {
                    txtHkszd.Text = reader.GetString(9);
                }
                if (reader["Sfsf"] == System.DBNull.Value)
                {
                    txtSfsf.Text = string.Empty;
                }
                else
                {
                txtSfsf.Text = reader.GetString(10);
                }
                    if (reader["Xzz"] == System.DBNull.Value)
                {
                    txtXzz.Text = string.Empty;
                }
                else
                {
                txtXzz.Text = reader.GetString(11);
                    }
                        if (reader["Zdrjb"] == System.DBNull.Value)
                {
                    txtZdrjb.Text = string.Empty;
                }
                else
                {
                txtZdrjb.Text = reader.GetString(12);
                        }
                            if (reader["Wtlb"] == System.DBNull.Value)
                {
                    txtWtlb.Text = string.Empty;
                }
                else
                {
                txtWtlb.Text = reader.GetString(13);
                            }
                                if (reader["Fywt"] == System.DBNull.Value)
                {
                    txtFywt.Text = string.Empty;
                }
                else
                {
                txtFywt.Text = reader.GetString(14);
                                }
                                    if (reader["Bt"] == System.DBNull.Value)
                {
                    txtBt.Text = string.Empty;
                }
                else
                {
                txtBt.Text = reader.GetString(15);
                                    }
                                        if (reader["Fssj"] == System.DBNull.Value)
                {
                    txtFssj.Text = string.Empty;
                }
                else
                {
                txtFssj.Text = reader.GetString(16);
                                        }
                                        if (reader["Fsdd"] == System.DBNull.Value)
                                        {
                                            txtFsdd.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtFsdd.Text = reader.GetString(17);
                                        }
                                        if (reader["Fsddxz"] == System.DBNull.Value)
                                        {
                                            txtFsddxz.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtFsddxz.Text = reader.GetString(18);
                                        }
                                        if (reader["Gxbm"] == System.DBNull.Value)
                                        {
                                            txtGxbm.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtGxbm.Text = reader.GetString(19);
                                        }
                                        if (reader["Tbbm"] == System.DBNull.Value)
                                        {
                                            txtTbbm.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtTbbm.Text = reader.GetString(20);
                                        }
                                        if (reader["Xwfs"] == System.DBNull.Value)
                                        {
                                            txtXwfs.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtXwfs.Text = reader.GetString(21);
                                        }
                                        if (reader["Sjrs"] == System.DBNull.Value)
                                        {
                                            txtSjrs.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtSjrs.Text = reader.GetString(22);
                                        }
                                        if (reader["Jyqk"] == System.DBNull.Value)
                                        {
                                            txtJyqk.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtJyqk.Text = reader.GetString(23);
                                        }
                                        if (reader["Wtfl"] == System.DBNull.Value)
                                        {
                                            txtWtfl.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtWtfl.Text = reader.GetString(24);
                                        }
                                        if (reader["Fywt_1"] == System.DBNull.Value)
                                        {
                                            txtFywt_1.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtFywt_1.Text = reader.GetString(25);
                                        }
                                        if (reader["Fxrdw"] == System.DBNull.Value)
                                        {
                                            txtFxrdw.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtFxrdw.Text = reader.GetString(26);
                                        }
                                        if (reader["Cjdw"] == System.DBNull.Value)
                                        {
                                            txtCjdw.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtCjdw.Text = reader.GetString(27);
                                        }
                                        if (reader["Qkfl"] == System.DBNull.Value)
                                        {
                                            txtQkfl.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtQkfl.Text = reader.GetString(28);
                                        }
                                        if (reader["Xwfssm"] == System.DBNull.Value)
                                        {
                                            txtXwfssm.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtXwfssm.Text = reader.GetString(29);
                                        }
                                        if (reader["Sfzc"] == System.DBNull.Value)
                                        {
                                            txtSfzc.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtSfzc.Text = reader.GetString(30);
                                        }
                                        if (reader["Cfcf"] == System.DBNull.Value)
                                        {
                                            txtCfcf.Text = string.Empty;
                                        }
                                        else
                                        {
                                            txtCfcf.Text = reader.GetString(31);
                                        }
            }
            else
            {
                txtCardNo.Text = string.Empty;
                txtName.Text = string.Empty;
                txtXb.Text = string.Empty;
                txtMz.Text = string.Empty;
                txtCsrq.Text = string.Empty;
                txtSf.Text = string.Empty;
                txtWhcd.Text = string.Empty;
                txtZrdw.Text = string.Empty;
                txtGzdw.Text = string.Empty;
                txtHkszd.Text = string.Empty;
                txtSfsf.Text = string.Empty;
                txtXzz.Text = string.Empty;
                txtZdrjb.Text = string.Empty;
                txtWtlb.Text = string.Empty;
                txtFywt.Text = string.Empty;
                txtBt.Text = string.Empty;
                txtFssj.Text = string.Empty;
                txtFsdd.Text = string.Empty;
                txtFsddxz.Text = string.Empty;
                txtGxbm.Text = string.Empty;
                txtTbbm.Text = string.Empty;
                txtXwfs.Text = string.Empty;
                txtSjrs.Text = string.Empty;
                txtJyqk.Text = string.Empty;
                txtWtfl.Text = string.Empty;
                txtFywt_1.Text = string.Empty;
                txtFxrdw.Text = string.Empty;
                txtCjdw.Text = string.Empty;
                txtQkfl.Text = string.Empty;
                txtXwfssm.Text = string.Empty;
                txtSfzc.Text = string.Empty;
                txtCfcf.Text = string.Empty;
            }
            this.Refresh();
            //关闭数据库
            helper.CloseConnection();
        }

        private string ISNULL(string p)
        {
            throw new NotImplementedException();
        }
        /// <summary>
        /// 构建新增会员SQL
        /// </summary>
        /// <returns></returns>
        private string CreateSql()
        {
            UITOEntity();
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append(" INSERT INTO Customer");
            sbSql.Append(" ([CardNo],[Name],[Xb],[Mz],[Csrq],[Sf],[Whcd],[Zrdw],[Gzdw],[Hkszd],[Sfsf],[Xzz],[Zdrjb],[Wtlb],[Fywt],[Bt],[Fssj],[Fsdd],[Fsddxz],[Gxbm],[Tbbm],[Xwfs],[Sjrs],[Jyqk],[Wtfl],[Fywt_1],[Fxrdw],[Cjdw],[Qkfl],[Xwfssm],[Sfzc],[Cfcf])");
            sbSql.Append(" VALUES");
            sbSql.Append(" ('" + customer.CardNo + "'");
            sbSql.Append(" ,'" + customer.Name+"'");
            sbSql.Append(" ,'" + customer.Xb + "'");
            sbSql.Append(" ,'" + customer.Mz + "'");
            sbSql.Append(" ,'" + customer.Csrq + "'");
            sbSql.Append(" ,'" + customer.Sf + "'");
            sbSql.Append(" ,'" + customer.Whcd + "'");
            sbSql.Append(" ,'" + customer.Zrdw + "'");
            sbSql.Append(" ,'" + customer.Gzdw + "'");
            sbSql.Append(" ,'" + customer.Hkszd + "'");
            sbSql.Append(" ,'" + customer.Sfsf + "'");
            sbSql.Append(" ,'" + customer.Xzz + "'");
            sbSql.Append(" ,'" + customer.Zdrjb + "'");
            sbSql.Append(" ,'" + customer.Wtlb + "'");
            sbSql.Append(" ,'" + customer.Fywt + "'");
            sbSql.Append(" ,'" + customer.Bt + "'");
            sbSql.Append(" ,'" + customer.Fssj + "'");
            sbSql.Append(" ,'" + customer.Fsdd + "'");
            sbSql.Append(" ,'" + customer.Fsddxz + "'");
            sbSql.Append(" ,'" + customer.Gxbm + "'");
            sbSql.Append(" ,'" + customer.Tbbm + "'");
            sbSql.Append(" ,'" + customer.Xwfs + "'");
            sbSql.Append(" ,'" + customer.Sjrs + "'");
            sbSql.Append(" ,'" + customer.Jyqk + "'");
            sbSql.Append(" ,'" + customer.Wtfl + "'");
            sbSql.Append(" ,'" + customer.Fywt_1 + "'");
            sbSql.Append(" ,'" + customer.Fxrdw + "'");
            sbSql.Append(" ,'" + customer.Cjdw + "'");
            sbSql.Append(" ,'" + customer.Qkfl + "'");
            sbSql.Append(" ,'" + customer.Xwfssm + "'");
            sbSql.Append(" ,'" + customer.Sfzc + "'");
            sbSql.Append(" ,'" + customer.Cfcf + "'");
            sbSql.Append(")");
            return sbSql.ToString();
        }

        /// <summary>
        /// 构建修改会员SQL
        /// </summary>
        /// <returns></returns>
        private string UpdateSql()
        {
            UITOEntity();
            StringBuilder sbSql = new StringBuilder();
            sbSql.Append(" UPDATE Customer SET");
            sbSql.Append(" Customer.CardNo='" + customer.CardNo + "',");
            sbSql.Append(" Customer.Name='" + customer.Name + "',");
            sbSql.Append(" Customer.Xb='" + customer.Xb + "',");
            sbSql.Append(" Customer.Mz='" + customer.Mz + "',");
            sbSql.Append(" Customer.Csrq='" + customer.Csrq + "',");
            sbSql.Append(" Customer.Sf='" + customer.Sf + "',");
            sbSql.Append(" Customer.Whcd='" + customer.Whcd + "',");
            sbSql.Append(" Customer.Zrdw='" + customer.Zrdw + "',");
            sbSql.Append(" Customer.Gzdw='" + customer.Gzdw + "',");
            sbSql.Append(" Customer.Hkszd='" + customer.Hkszd + "',");
            sbSql.Append(" Customer.Sfsf='" + customer.Sfsf + "',");
            sbSql.Append(" Customer.Xzz='" + customer.Xzz + "',");
            sbSql.Append(" Customer.Zdrjb='" + customer.Zdrjb + "',");
            sbSql.Append(" Customer.Wtlb='" + customer.Wtlb + "',");
            sbSql.Append(" Customer.Fywt='" + customer.Fywt + "',");
            sbSql.Append(" Customer.Bt='" + customer.Bt + "',");
            sbSql.Append(" Customer.Fssj='" + customer.Fssj + "',");
            sbSql.Append(" Customer.Fsdd='" + customer.Fsdd + "',");
            sbSql.Append(" Customer.Fsddxz='" + customer.Fsddxz + "',");
            sbSql.Append(" Customer.Gxbm='" + customer.Gxbm + "',");
            sbSql.Append(" Customer.Tbbm='" + customer.Tbbm + "',");
            sbSql.Append(" Customer.Xwfs='" + customer.Xwfs + "',");
            sbSql.Append(" Customer.Sjrs='" + customer.Sjrs + "',");
            sbSql.Append(" Customer.Jyqk='" + customer.Jyqk + "',");
            sbSql.Append(" Customer.Wtfl='" + customer.Wtfl + "',");
            sbSql.Append(" Customer.Fywt_1='" + customer.Fywt_1 + "',");
            sbSql.Append(" Customer.Fxrdw='" + customer.Fxrdw + "',");
            sbSql.Append(" Customer.Cjdw='" + customer.Cjdw + "',");
            sbSql.Append(" Customer.Qkfl='" + customer.Qkfl + "',");
            sbSql.Append(" Customer.Xwfssm='" + customer.Xwfssm + "',");
            sbSql.Append(" Customer.Sfzc='" + customer.Sfzc + "',");
            sbSql.Append(" Customer.Cfcf='" + customer.Cfcf + "'");
            sbSql.Append(" WHERE ID=" + this.m_id);
            return sbSql.ToString();
        }

        /// <summary>
        /// 新增会员信息
        /// </summary>
        /// <returns></returns>
        private bool AddCustomer()
        {
            bool rslt = false;
            try
            {
                helper.ExeSQL(CreateSql());
                rslt = true;
            }
            catch (System.Exception ex)
            {
                System.Console.WriteLine(ex.ToString());
            }

            return rslt;
        }
        /// <summary>
        /// 修改会员信息
        /// </summary>
        /// <returns></returns>
        private bool UpdateCustomer()
        {
            return helper.ExeSQL(UpdateSql());
        }

       /// <summary>
       /// 确认事件
       /// </summary>
       /// <param name="sender"></param>
       /// <param name="e"></param>
       private void btnOK_Click(object sender, EventArgs e)
       {
           //数据验证
           if (!CheckData())
           {
               this.DialogResult = DialogResult.None;
               return;
           }

           //处理分支
           switch (m_type)
           {
               case Constant.DlgType.CardAdd:
                   AddCustomer();
                   break;
               case Constant.DlgType.CardModify:
                   UpdateCustomer();
                   break;
               case Constant.DlgType.CardCharge:
                   if (chargeFlag )
                   this.btnOK.Enabled = false;
                   this.DialogResult = DialogResult.None;
                   break;
               default:
                   break;
           }

       }
       /// <summary>
       /// 填充会员信息
       /// </summary>
       /// <param name="sender"></param>
       /// <param name="e"></param>
       private void txtCardNo_LostFocus(object sender, EventArgs e)
       {
           DBTOUI(Id);
           this.btnOK.Enabled = true;
           this.lbMsg.Text = string.Empty;
       }

        /// <summary>
        /// 数据验证
        /// </summary>
        /// <returns></returns>
       private bool CheckData()
       {
           //卡号
           if (txtCardNo.Enabled && !DataValidator.IsNumber(txtCardNo.Text.Trim()))
           {
               MessageBox.Show("卡号格式不正确", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
               txtCardNo.Focus();
               return false;
           }

           //姓名
           if (txtName.Enabled && string.IsNullOrEmpty(txtName.Text.Trim()))
           {
               MessageBox.Show("姓名不能为空", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
               txtName.Focus();
               return false;
           }
           return true;
       }

private void txtMemo_TextChanged(object sender, EventArgs e)
{

}

private void lbMemo_Click(object sender, EventArgs e)
{

}

private void label7_Click(object sender, EventArgs e)
{

}

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{

}

private void textBox13_TextChanged(object sender, EventArgs e)
{

}

private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{

}

private void textBox17_TextChanged(object sender, EventArgs e)
{

}

private void label8_Click(object sender, EventArgs e)
{

        }
        private void label13_Click(object sender, EventArgs e)
        {

        }
        private void textcsrq_TextChanged(object sender, EventArgs e)
        {

        }
        public int Id { get; set; }
    }
}
2、数据库详细设计
建一个项为SqlHelper.cs，具体代码如下：
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Configuration;

namespace CN.SH.SDD.MemCardSys.Commons
{
    class SqlHelper
    {
        /// <summary>
        /// 连接数据库字符串
        /// </summary>
        private string connectionString;

        /// <summary>
        /// 存储数据库连接（保护类，只有由它派生的类才能访问）
        /// </summary>
        protected OleDbConnection Connection;

        /// <summary>
        /// 构造函数：数据库的默认连接
        /// </summary>
        public SqlHelper()
        {
            string connStr;
            connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
            connectionString = connStr;
            Connection = new OleDbConnection(connectionString);
        }

        /// <summary>
        /// 构造函数：带有参数的数据库连接
        /// </summary>
        /// <param name="newConnectionString"></param>
        public SqlHelper(string newConnectionString)
        {
            connectionString = newConnectionString;
            Connection = new OleDbConnection(connectionString);
        }

        /// <summary>
        /// 获得连接字符串
        /// </summary>
        public string ConnectionString
        {
            get
            {
                return connectionString;
            }
        }

        /// <summary>
        /// 执行SQL语句没有返回结果，如执行删除、更新、插等操作
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>操作成功标志</returns>
        public bool ExeSQL(string strSQL)
        {
            bool resultState = false;

            Connection.Open();
            OleDbTransaction myTrans = Connection.BeginTransaction();
            OleDbCommand command = new OleDbCommand(strSQL, Connection, myTrans);

            try
            {
                command.ExecuteNonQuery();
                myTrans.Commit();
                resultState = true;
            }
            catch(OleDbException ex)
            {
                System.Console.WriteLine(ex.ToString());
                myTrans.Rollback();
                resultState = false;
            }
            finally
            {
                Connection.Close();
            }

            return resultState;
        }

        /// <summary>
        /// 执行SQL语句返回结果到中
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>dataReader</returns>
        public OleDbDataReader ReturnDataReader(string strSQL)
        {
            Connection.Open();
            OleDbCommand command = new OleDbCommand(strSQL, Connection);
            OleDbDataReader dataReader = command.ExecuteReader();
            //Connection.Close();
            return dataReader;
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void CloseConnection()
        {
            try
            {
                if (Connection != null)
                {
                    Connection.Close();
                }

            }
            catch (System.Exception ex)
            {
                System.Console.WriteLine(ex.ToString());
            }

        }
        /// <summary>
        /// 执行SQL语句返回结果到中
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>DataSet</returns>
        public DataSet ReturnDataSet(string strSQL)
        {
            Connection.Open();
            DataSet dataSet = new DataSet();
            OleDbDataAdapter OleDbDA = new OleDbDataAdapter(strSQL, Connection);
            OleDbDA.Fill(dataSet, "objDataSet");

            Connection.Close();
            return dataSet;
        }

        /// <summary>
        /// 执行查询语句同时返回查询结果数目
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>sqlResultCount</returns>
        public int ReturnSqlResultCount(string strSQL)
        {
            int sqlResultCount = 0;

            try
            {
                Connection.Open();
                OleDbCommand command = new OleDbCommand(strSQL, Connection);
                OleDbDataReader dataReader = command.ExecuteReader();

                while (dataReader.Read())
                {
                    sqlResultCount++;
                }
                dataReader.Close();
            }
            catch
            {
                sqlResultCount = 0;
            }
            finally
            {
                Connection.Close();
            }
            return sqlResultCount;
        }

}//

四、结语信访维稳是政法综治工作的重要内容，是维护大局稳定，促进经济发展构建和谐社会的关键性政治工作。建立上访人员识别系统正是顺应时代发展的需要。
本文查阅了大量文献资料，对信访维稳工作的发展概况、目前的软件系统的一些应用情况以及存在的问题等作了详细的调查和研究。在对信访工作的基本理论和最新思想的研究的基础上，结合国内外软件系统的应用现状，以及现有计算机网络通信技术的发展和应用等，提出采用先进的技术手段，建立基于C#的上访人员识别系统。并对该系统的实现方法、体系结构等作了分析研究，最后实现了基于C#的上访人员识别系统。具体来说，主要完成了以下工作:
(1)阐述了当前信访工作中出现的新问题，分析这些问题并运用软件系统来管理这些问题。
(2)对上访人员识别系统进行了需求分析和系统分析。
(3)对上访人员识别系统的一些功能模块进行一些介绍，并以截图的方式，展现给用户，以便用户能很好的了解本系统。
(4)对上访人员识别系统的一些代码进行分析如何实现。
通过本文的研究，基本上实现的上访人员识别系统，运行效果好。对实现管控维稳信访工作提供了一个好的思路，具有一定的参考价值。但是，由于多方面的原因，本课题的研究还有很多不足之处，今后的工作主要体现在以下一些方面:
(1)C#页面设计还有待提高。
(2)所实现的识别系统功能还有待完善，界面的友好方面也有待改善。
五、参考文献
1、王小科，赵会东：C#程序开发范例宝典(第3版),人民邮电出版社

以上为本篇毕业论文范文上访人员识别系统的设计与实现的介绍部分。

本论文在计算机论文栏目，由论文网(www.zjwd.net)整理,更多论文,请点论文范文查找