【数据库+Engine】吉大核酸采样点空间分布与可达性分析系统集采样管理一键式平台报告

无法直接粘贴图片

报告，源程序，介绍视频下载链接如下：

https://download.csdn.net/download/qq_54263076/87354460

第一章 需求分析

1.1确定问题空间和领域范围

每一张表所对应的角色的领域范围和空间如下：

第一子集.核酸总流程表：单号ID，待检员ID，取样员ID，取样时间，取样地点，核酸试剂编号ID

第二子集.人员表：人员ID，姓名，性别，身份证号，住址，手机号，工作单位，是否志愿者，身份ID

第三子集.志愿者表：人员ID，工作任务，志愿时长

第四子集.登录账号表：人员ID，账号（手机号），密码

第五子集.核酸试剂表：核酸试剂编号ID，检测员ID，检测时间，检测地点，检测结果ID

1.2任务概述

1. 背景与目的

背景：近期，国内新冠肺炎疫情中高风险区持续增加，疫情防控工作面临新的压力与挑战。为切实做好我校疫情防控工作，根据国家、省、市新冠疫情防控最新工作要求，高校疫情期间，做到学生每日核酸，并要求手动打卡。

目的：此系统可以方便于校园疫情核酸管理，减少了手动打卡健康吗收集的繁琐流程，并快速获取学生核酸情况,做出安排。

1. 用户特征

主要为使用者，志愿者和统筹者三个主要用户。

（1）使用者是填写自己的基本信息和获取当前的核酸检测结果，并可申请成为志愿者；

（2）志愿者分为取样员，检测员，消毒人员等，取样员负责获取使用者信息与核酸试剂编号一一对应，填写核酸总流程表，检测员主要负责填写核酸试剂表，并上传检测结果；

（3）统筹者获取总体表的情况，快速获取每个人的核酸检测情况或志愿者工作情况，按照特点的条件筛选出特殊的人员，并进行统一安排。也可对志愿者进行工作任务分配和指挥，也可通过可视化地图进行Engine二次开发管理地图，进行核酸检测点的增删和路径分析；

3. 运行条件与限制

本系统适用于吉林大学高校每日核酸检测管理，对于社会层面复杂情况，不予讨论。

1.3功能分析

1. 用例描述

表1.1 使用者用例举例

表1.2 志愿者用例举例

表1.3 统筹者用例举例

2.各模块功能需求

下面都需要对应账号登录：

【1】使用者系统：

1. 填写，修改个人信息。
2. 志愿者申请。
3. 查看个人核酸检测记录。
4. 进行记录排名，获取做检测记录排名。

【2】志愿者系统：

1. （采样人员）上传核酸检测人员信息情况。
2. （检测人员）上传核酸检测最终结果。
3. 查看志愿工作的时间地点，并可以申请修改。
4. 查看上传记录表，留存记录。

【3】统筹者系统：

1. 获取全校核酸检测结果（可导出Excel表），快速获取阳性人员的电话和住址，迅速做出反应防控隔离
2. 审核志愿者信息，志愿者申请请求和志愿者修改请求。

（3）人员核酸检测的总次数和最近时间（可导出Excel表），得到未作核酸人员的名单，并通过电话督促。

（4）获取志愿者名单（可导出Excel表），增加修改志愿任务，可以快速安排志愿者工作身份，让他们具有志愿者系统登录权限。

（5）选择和显示地图。

（6）对地图进行放大，缩小，定位，获取坐标点等基本操作。

（7）在地图上标注核酸检测点，并赋予详细属性，在再上传到任务数据库。

（8）在地图上进行图层的增删改查，并能获取图层的属性表。

（9）在地图上对图层中的要素进行增删改查，并能获取要素的属性值。

（10）能够进行简单的网络路径分析，进行障碍物与可通行点的增添。

1.4系统体系结构

C/S体系结构

C/S（Client/Server）结构，即客户机和服务器结构。这种体系结构模式是以数据库服务器为中心、以客户机为网络基础、在信息系统软件支持下的两层结构模型。这种体系结构中，用户操作模块布置在客户机上，数据存储在服务器上的数据库中。客户机依靠服务器获得所需要的网络资源，而服务器为客户机提供网络必须的资源。目前大多数信息系统是采用Client/Server结构。

1.5性能要求

1、测试时硬件：

表1.4 电脑硬件

2、测试时网络：

表1.5 电脑网络

1.6其他要求

该系统是1.0初始版本，里面大多数功能并不完善，如果需要进行二次更新扩展，可以进行以下项目：

1. 动态显示校园核酸点图和人员分布图功能
2. 对于志愿者者通过二维码来自动获取使用者信息，上传数据
3. 对于统筹者，可以进行手动区划管理，框选核酸警戒区域

（4）可扩展志愿者管理模块功能，对于志愿者的管理更详细

（5）可购买服务器并部署数据库

1.7可行性分析

1. 项目所在城市基本情况：

长春市卫生健康委员会提醒广大公众，零新增不等于零风险，要继续绷紧疫情防控这根弦，切实增强防护意识、遵守防控要求、配合防疫管理，做自己健康的第一责任人。 要密切关注各地发布的疫情动态信息，如与阳性感染者活动轨迹有交集，或近期有疫情发生地区旅居史，请立即主动向社区(村屯)或疾控机构报告，按要求配合做好相关疫情管控措施。如出现发热、咳嗽等急性呼吸道症状，请在做好个人防护的情况下，及时到定点医疗机构发热门]诊就诊。接种新冠疫苗是预防新冠肺炎的有效措施，请广大群众主动尽早接种，要坚持外出戴口罩、勤洗手、常通风、保持社交距离、不聚餐。

对于吉林大学高校要及时做好对核酸检测的统计与监管。

1. 市场分析

手动打卡，比较麻烦和繁琐，需要人工手动或验证查看，且容易漏检和蒙混，不好做到统计和及时做出调整反应。并且可以快速网络上安排志愿者进行核酸检测的志愿工作，做到与校外人员零接触，加强疫情防控的安全性。

1. 项目投资

   无，全由个人完成

1. 项目规划

表1.6 项目规划

• 实体概念设计和关系设计

数据库模型部分详细细节请看文件”ER模型报告.RTF”。

2.1实体概念设计

表2.1 Entity Summary Report

2.1.1 人员People

表2.1 People表

2.1.2 账号AccNumber

表2.2 AccNumber表

2.1.3 账号权限AccAuthority

表2.3 AccAuthority表

2.1.4 待检人员WaitPeolple

表2.4 WaitPeolple表

2.1.5 采样人员SamplePeople

表2.5 SamplePeople表

2.1.6 志愿任务VolunTask

表2.6 VolunTask表

2.1.7 检测人员DetectPeople

表2.7 DetectPeople表

2.1.8 核酸流程DetectList

表2.8 DetectList表

2.1.9 试剂Reagent

表2.9 Reagent表

2.1.10 检测结果DetectResult

表2.10 DetectResulty表

2.2关系设计

Relationship Summary Report

2.2.1 Relationship: 待检人员 to 核酸流程

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.2 Relationship: 采样人员 to 核酸流程

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.3 Relationship: 试剂 to 核酸流程

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.4 Relationship: 检测人员 to 试剂

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.5 Relationship: 账号权限 to 账号

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.6 Relationship: 账号 to 待检人员

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.7 Relationship: 账号 to 采样人员

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.8 Relationship: 账号 to 检测人员

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.9 Relationship: 人员 to 账号

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.10 Relationship: 志愿任务 to 采样人员

Bound Attachments 

Relationship Description 

Relationship Keys 

2.2.11 Relationship: 检测结果 to 试剂

Bound Attachments 

Relationship Description 

Relationship Keys 

第三章 逻辑实现和物理实现

3.1逻辑模型

逻辑模型，是指数据的逻辑结构。逻辑建模是数据仓库实施中的重要一环，因为它能直接反映出业务部门的需求，同时对系统的物理实施有着重要的指导作用，它的作用在于可以通过实体和关系勾勒出企业的数据蓝图。

逻辑模型是严格定义的一组概念的集合，主要由数据结构、数据操作和完整性约束部分组成，通常称为数据三要素。

数据结构是计算机数据组织方式和数据之间联系的框架描述，而数据文件的数据就按照这种框架描述进行组织。

数据结构是所描述对象类型的集合，是对系统的静态描述。

数据操作是指对数据库中各种对象的实例或取值所允许执行操作的集合，其中包括操作方法及有关规则，它是对数据库动态特性的描述。

完全性约束是指对数据的一组完整性规则（约束条件）的集合。逻辑逻辑应该反映和和规定本数据模型必须遵守的基本的通用的完整性约束条件。例如，在关系模型中，任何关系都必须满足实体完整性和参照完整性两个条件。此外，逻辑模型还应该提供用户定义完整性约束条件的机制，以反映具体应用所涉及的数据必须遵守的特定的语义约束条件。

细节查看第二章内容。

建立关系和E-R图，将关系转化为表：1:1关系，1:n关系，m:n关系。对象关联的数据库表示：

图3.1 数据库逻辑E-R图

3.2 物理模型

物理数据模型（Physical Data Model，PDM），是指提供系统初始设计所需要的基础元素，以及相关元素之间的关系。即用于存储结构和访问机制的更高层描述，描述数据是如何在计算机中存储的，如何表达记录结构、记录顺序和访问路径等信息。使用物理数据模型，可以在系统层实现数据库。数据库的物理设计阶段必须在此基础上进行详细的后台设计，包括数据库的存储过程、操作、触发、视图和索引表等；本报告通过Microsoft SQL Server Management Studio 18软件构建数据库的物理模型。

图3.2 数据库物理E-R图

此物理模型的生成详情查看文件”数据库生成.sql”。

第四章 系统初始化介绍

4.1需要软件

本次课程我开发所用到的软件如下：

1.Microsoft SQL Server Management Studio 18

2.Visual Studio 2012

3.ArcMap 10.2

4.ArcEngine 10.2

4.2 初始化以及数据导入

1.新建数据库nucleic

图4.1 新建数据库

图4.2 输入数据库名称

2.导入初始数据

双击”数据库生成.sql”，在SQL SERVER中点击“执行”。

图4.3 打开”数据库生成.sql”

图4.4 点击执行

初始数据数据初始化完成

第五章 主要功能与代码

5.1 自定义类

主要用来方便用于代码的复用

5.1.1 SQL类用来方便数据库的链接

 class SQL

    {

       public  static SqlConnection sqlcon = new SqlConnection();//定义链接变量

        public SQL()

        {

            sqlcon.ConnectionString = "Data Source=" + STATIC.local + ";Initial Catalog=nucleic;Integrated Security=True";//连接服务器

        }

        //sql操作返回处理的行数

        public int excute(String sql)

        {

            int i = 0;

            sqlcon.Open();

  if (sqlcon.State == ConnectionState.Open)

            {

                try

                {

                    //数据库命令

                    SqlCommand cmd = new SqlCommand(sql, sqlcon);

                    //返回操作行数

                    i = cmd.ExecuteNonQuery();

                }

                catch (Exception es) { MessageBox.Show(es.Message); }

            }

            sqlcon.Close();

            return i;

        }

        //sql查询

        public selectDate select(String sql)

        {

                //建立数据集 实例化Datatable类

                selectDate sd = new selectDate();

                DataSet d1 = new DataSet();

                sqlcon.Open();

            try

            {

                if (sqlcon.State == ConnectionState.Open)

                {

                    //建立数据库适配器 建立SQL语句与数据库的连接

                    SqlDataAdapter ada = new SqlDataAdapter(sql, sqlcon);

                    //将结果装入ds01中

                    ada.Fill(d1);

                    sd.ds = d1;

                    sqlcon.Close();

                    sqlcon.Open();

                    SqlCommand cmd1 = new SqlCommand(sql, sqlcon);

                    SqlDataReader data = cmd1.ExecuteReader();

                    //是否有数据

                    bool hasrows = data.HasRows;

                    sd.hasrows = hasrows;

                }

            }

            catch (Exception es) { MessageBox.Show(es.Message); }

            sqlcon.Close();

            return sd;

        }

    }

    //查询语句返回的数据类型，包括  查询数据集合，是否有数据

     class selectDate

    {

        public DataSet ds = new DataSet() ;//查询数据集

        public bool hasrows;//是否查询到数据

}

5.1.2 STATIC类用来存储一些全局变量：

    //全局变量类

    class  STATIC

    {

        public static int ID=1;//pID号

        public static int wpID=0;//wpID

        public static int sampID = 0;//sampID

        public static int detpID = 0;//detpIDID

        public static string local=" ";//实例名

    }

5.2 登录与注册界面

5.2.1 登录

图5.1 登录

   private void button1_Click(object sender, EventArgs e)

        {

            String system = comboBox1.Text;

            String phone = textBox1.Text;

            String password = textBox2.Text;

                //SQL语句，可自己编写需要的。

                string sql = "select auID from AccNumber where pID=(select pID from dbo.People where pPhone='" + phone+"') and aPassword='"+password+"'";

                selectDate sd = SQL1.select(sql);

                try

                {

                    auID = (int)sd.ds.Tables[0].Rows[0]["auID"];

                }

                catch{

                    MessageBox.Show("账号或密码错误，没有账号请先注册账号");

                     return;

                };

                string sql3 = "select pID from dbo.People where pPhone='" + phone + "'";

                selectDate sd3 = SQL1.select(sql3);

                 int ID = Int32.Parse(sd3.ds.Tables[0].Rows[0]["pID"].ToString());

                STATIC.ID = ID;

                //权限登录

                if (comboBox1.Text == "普通人员"&auID!=6)

                {

                    MessageBox.Show("欢迎来到普通人员系统！");

                    Form f1=new 系统窗口.普通人员系统();

                    f1.Show();

                }

                else if (comboBox1.Text == "采样者系统" & (auID == 2 || auID == 5))

                {

                    MessageBox.Show("欢迎来到志愿者系统！");

                    Form f1 = new 系统窗口.志愿者系统();

                    f1.Show();

                }

                else if (comboBox1.Text == "检测者系统" & (auID == 3 || auID == 5))

                {

                    MessageBox.Show("欢迎来到检测者系统！");

                    Form f1 = new 系统窗口.检测者系统();

                    f1.Show();

                }

                else if (comboBox1.Text == "管理者系统" & (auID == 4 || auID == 5))

                {

                    MessageBox.Show("欢迎来到管理者系统！");

                    Form f1 = new 系统窗口.管理员系统();

                    f1.Show();

                }

                else { MessageBox.Show("权限不足，请联系管理员"); }

            }

5.2.2 注册

图5.2 注册

 private void button4_Click_1(object sender, EventArgs e)

        {

            string name = textBox3.Text;

            string sex = comboBox2.Text;

            string phone = textBox4.Text;

            string number = textBox5.Text;

            string add = textBox6.Text;

            string password = textBox7.Text;

            string repassword = textBox8.Text;

            if (password != repassword)

            {

                MessageBox.Show("俩次密码不一致");

                return;

            }

            if (textBox3.Text == string.Empty & textBox4.Text == string.Empty & textBox5.Text == string.Empty & textBox6.Text == string.Empty)

            {

                MessageBox.Show("不能为空");

                return;

            }

            try

            {   //格式要求全是数字

                float iphone = float.Parse(phone);

            float inumber = float.Parse(number);

            //SQL语句，可自己编写需要的。

            string sql1 = "select * from dbo.People where pIDnumber='" + number + "' or pPhone = '" + phone + "'";

            selectDate sd = SQL1.select(sql1);

            if (sd.hasrows == true)

            {//如果查找到

                MessageBox.Show("已存在该用户手机号或身份证");

                return;

            }

            else

            {

                //SQL语句，可自己编写需要的。

                string sql2 = "insert into dbo.People(pName,pSex,pPhone,pIDnumber,pAdd) values('" + name + "','" + sex + "','" + phone + "','" + number + "','" + add + "')";

                int i = SQL1.excute(sql2);

                if (i >= 1)

                {

                    MessageBox.Show("注册成功");

                    tabControl1.SelectedIndex = 0;

                    //获取ID

                    //SQL语句，可自己编写需要的。

                    string sql3 = "select pID from dbo.People where pPhone='" + phone + "'";

                    //建立数据库适配器 建立SQL语句与数据库的连接

                    selectDate sd3 = SQL1.select(sql3);

                    int ID = Int32.Parse(sd3.ds.Tables[0].Rows[0]["pID"].ToString());

                    //插入密码表

                    //SQL语句，可自己编写需要的。

                    string sql4 = "insert into dbo.AccNumber(pID,aPassword,auID) values(" + ID + ",'" + password + "','1')";

                    //建立数据库适配器 建立SQL语句与数据库的连接

                    int i4 = SQL1.excute(sql4);

                }

                else { MessageBox.Show("注册失败"); }

            }

        }

            catch (Exception ex) { MessageBox.Show(ex.Message); }

5.3 普通人员系统

5.3.1 首页

图5.3 首页

  public 普通人员系统()

        {

            InitializeComponent();

            //检测是否存在登录账号，如果存在则在待检人员表里加入

            //SQL语句，可自己编写需要的。

            string sql = "select * from dbo.WaitPeople where pID="+STATIC.ID;

            selectDate sd = SQL1.select(sql);

            if (!sd.hasrows)//如果不存在待测人员账号

            {

                string sql1 = "insert dbo.WaitPeople(pID) values(" + STATIC.ID + ")";

                int i = SQL1.excute(sql1);

                if (i >= 1)

                {

                    MessageBox.Show("成功创建待测人员账号");

                }

            }

            //查询个人信息;

            peopleInformation();

            //获取本待测人员ID,为了数据的安全性，用wpID代替

            selectDate sd2 = SQL1.select(sql);

            STATIC.wpID = Int32.Parse(sd2.ds.Tables[0].Rows[0]["wpID"].ToString());

            //获取本人检测信息

            detectResult();

        }

5.3.2 修改和保存个人信息

图5.4 个人信息

        //个人信息

        public void peopleInformation()

        {

            string sql = "select * from dbo.People where pID=" + STATIC.ID;

            selectDate sd = SQL1.select(sql);

            DataRow dr=sd.ds.Tables[0].Rows[0];

            textBox1.Text = dr["pName"].ToString();

            textBox2.Text = dr["pSex"].ToString();

            textBox3.Text = dr["pPhone"].ToString();

            textBox4.Text = dr["pIDnumber"].ToString();

            textBox5.Text = dr["pAdd"].ToString();

            string sql2 = "select * from dbo.WaitPeople where pID=" + STATIC.ID;

            selectDate sd2 = SQL1.select(sql2);

            DataRow dr2 = sd2.ds.Tables[0].Rows[0];

            textBox6.Text = dr2["stuNumber"].ToString();

            string sql3 = "select * from dbo.SamplePeople where pID=" + STATIC.ID;

            selectDate sd3 = SQL1.select(sql2);

            textBox7.Text = sd3.hasrows ? "是" : "否";

        }

 public int buttonclick = 0;

        private void button1_Click(object sender, EventArgs e)

        {

            if (buttonclick == 0)

            {

                button1.Text = "取消";

                textBox1.Enabled = true;

                textBox2.Enabled = true;

                textBox3.Enabled = true;

                textBox4.Enabled = true;

                textBox5.Enabled = true;

                textBox6.Enabled = true;

                buttonclick =1;

            }

            else {

                button1.Text = "修改";

                textBox1.Enabled = false;

                textBox2.Enabled = false;

                textBox3.Enabled = false;

                textBox4.Enabled = false;

                textBox5.Enabled = false;

                textBox6.Enabled = false;

                buttonclick =0;

                peopleInformation();

            }

        }

        private void button2_Click(object sender, EventArgs e)

        {

            string name = textBox1.Text;

            string sex = textBox2.Text;

            string phone = textBox3.Text;

            string number = textBox4.Text;

            string add = textBox5.Text;

            if (textBox1.Text == string.Empty & textBox2.Text == string.Empty & textBox3.Text == string.Empty & textBox4.Text == string.Empty & textBox5.Text == string.Empty)

            {

                MessageBox.Show("不能为空");

                return;

            }

            try

            {   //格式要求全是数字

                float iphone = float.Parse(phone);

                float inumber = float.Parse(number);

                //SQL语句，可自己编写需要的。

                string sql1 = "select * from dbo.People where pIDnumber='" + number + "' or pPhone = '" + phone + "'";

                selectDate sd = SQL1.select(sql1);

                DataRow dr = sd.ds.Tables[0].Rows[0];

                if (sd.hasrows == true&&(dr["pPhone"].ToString()!=phone|| dr["pIDnumber"].ToString() != number))

                {//如果查找到

                    MessageBox.Show("已存在该用户手机号或身份证");

                    return;

                }

                else

                {

                    //SQL语句，可自己编写需要的。

                    string sql2 = "update dbo.People set pName='" + name + "',pSex='" + sex + "',pPhone='" + phone + "',pIDnumber='" + number + "',pAdd='" + add + "' where pID="+STATIC.ID ;

                    int i = SQL1.excute(sql2);

                    if (i >= 1)

                    {

                        MessageBox.Show("保存成功");

                        button1.Text = "修改";

                        textBox1.Enabled = false;

                        textBox2.Enabled = false;

                        textBox3.Enabled = false;

                        textBox4.Enabled = false;

                        textBox5.Enabled = false;

                        textBox6.Enabled = false;

                        buttonclick = 0;

                    }

                    else { MessageBox.Show("保存失败"); }

                }

            }

            catch (Exception ex) { MessageBox.Show(ex.Message); }

        }

5.3.3 记录和排名

图5.5 记录和排名

 //检测结果

        public void detectResult()

        {

                //更新检测表

                string sql = "select p.pName as '待检人员',w.stuNumber as '学号', sp.pName as '采样人员',l.samTime as '采样时间',l.samADD as '采样地点',dp.department as '检测机构',ddp.pName as '检测人员',t.result as '检测结果',r.deteTime as '检测时间',r.reRemark as '备注' from WaitPeople w ,SamplePeople s,Reagent r,DetectResult t ,DetectList l ,DetectPeople dp,People p,People sp,People ddp where((l.wpID=w.wpID) and(l.sampID=s.sampID) and(l.reaID=r.reaID) and(r.deterID=t.deterID) and(r.detpID=dp.detpID) and(p.pID=w.pID) and(sp.pID=s.pID) and(ddp.pID=dp.pID) and ( w.wpID=" + STATIC.wpID + ") ) order by l.samTime desc";

                selectDate sd = SQL1.select(sql);

                detectTable = sd.ds.Tables[0];

                if (sd.hasrows == true)

                {

                    label1.Text = detectTable.Rows[0]["检测结果"].ToString();

                    label3.Text = detectTable.Rows[0]["检测时间"].ToString();

                }

                else

                {

                    label1.Text = "未检测";

                    label3.Text = "未检测";

                }

                dataGridView1.ReadOnly = true;

                dataGridView1.DataSource = detectTable;

                //更新排名

                string sql2 = "select rank,count from (select rank() over(order by COUNT(wpID) desc) as rank,wpID,COUNT(wpID) as count from DetectList  group by wpID) r where wpID=" + STATIC.wpID;

                selectDate sd2 = SQL1.select(sql2);

                if (sd2.hasrows == true)

                {

                    int rank = int.Parse(sd2.ds.Tables[0].Rows[0]["rank"].ToString());

                    int count = int.Parse(sd2.ds.Tables[0].Rows[0]["count"].ToString());

                    string sql3 = "select count(*) as totle from (select rank() over(order by COUNT(wpID) desc) as rank,wpID,COUNT(wpID) as count from DetectList  group by wpID) r";

                    selectDate sd3 = SQL1.select(sql3);

                    int totle = int.Parse(sd3.ds.Tables[0].Rows[0]["totle"].ToString());

                    label6.Text = "你已经做了" + count.ToString() + "次核酸";

                    label9.Text = "超过了" + ((int)((1 - (rank - 1) / totle) * 1000) / 10).ToString() + "%的检测人员，继续努力哦！";

                }

                else {

                    label6.Text = "你还未做核酸";

                    label9.Text = "未超过任何人";

                }

        }

5.4 采样人员系统

5.4.1 首页

图5.6 首页

  //初始化

        public void Initial()

        {

            string sql0 = "select * from dbo.SamplePeople where pID=" + STATIC.ID;

            selectDate sd0=SQL1.select(sql0);

            comboBox1.SelectedIndex = 0;

            //如果没有需要创建采样者账号

            if (sd0.hasrows == false)

            {

                string sql2 = "insert into SamplePeople(pID) values("+STATIC.ID+")";

                MessageBox.Show("志愿者账号创建成功！");

                SQL1.excute(sql2);

                sd0 = SQL1.select(sql0);

            }

            //更新志愿者ID

            STATIC.sampID = Int32.Parse(sd0.ds.Tables[0].Rows[0]["sampID"].ToString());

            //首页

            string sql = "select * from dbo.People where pID=" + STATIC.ID;

            selectDate sd = SQL1.select(sql);

            string name= sd.ds.Tables[0].Rows[0]["pName"].ToString();

            label5.Text = "欢迎 " + name + " 来到志愿者系统";

            string sql3 = "select * from dbo.samplePeople where pID=" + STATIC.ID;

            selectDate sd3 = SQL1.select(sql3);

            string time = sd3.ds.Tables[0].Rows[0]["volunTime"].ToString();

            label6.Text = "您的志愿时长为：" + time;

            //显示任务表格

            taskTable();

            //显示核酸采样记录

            sampleTable();

        }

5.4.2上传信息

图5.7 上传

private void button1_Click_1(object sender, EventArgs e)

        { //上传

            if (textBox3.Text == "无任务") { MessageBox.Show("你没有任务，快去申请任务");return; }

            string phone = textBox1.Text;

            string time = textBox2.Text;

            string add = textBox3.Text;

            string reName = textBox4.Text;

            if (add == string.Empty)

            {

                MessageBox.Show("对不起，您还没有选择任务\n请在任务界面选择自己的任务");

                return;

            }

            //首先检测有没有该试剂

            string sql0 = "select * from dbo.Reagent where reName='" + reName + "'";

            selectDate sd0 = SQL1.select(sql0);

            if (sd0.hasrows == false)

            {

            //插入该试剂

                string sql1 = "insert into dbo.Reagent(reName) values('" + reName + "')";

                selectDate sd1 = SQL1.select(sql1);

                MessageBox.Show("新建试剂"+reName+"成功");

                sd0 = SQL1.select(sql0);

            }

            try

            {

                //找到该手机号的人员ID

                string sql = "select * from dbo.People p ,dbo.WaitPeople wp where p.pID=wp.pID and pPhone='" + phone + "'";

                selectDate sd = SQL1.select(sql);

                int wid = Int32.Parse(sd.ds.Tables[0].Rows[0]["wpID"].ToString());

                //找到该试剂ID

                int reid = Int32.Parse(sd0.ds.Tables[0].Rows[0]["reaID"].ToString());

                //插入核酸流程表

                string sql2 = "insert into dbo.DetectList(wpID,sampID,samTime,samAdd,reaID) values(" + wid + "," + STATIC.sampID + ",'" + time + "','" + add + "'," + reid + ")";

                SQL1.excute(sql2);

                MessageBox.Show("上传成功");

                sampleTable();

            }

            catch { MessageBox.Show("没有找到该人员或者该人员没有登录过一次系统"); }

        }

5.4.3任务和申请

图5.8 任务和申请

 //显示任务表格

       public void taskTable()

       {

           //所有任务

           string sql = "select voluID,volName as 任务名称 ,starTime as 开始时间,endTime as 结束时间,volAdd as 任务地址 ,remark as 备注 from dbo.VolunTask";

           selectDate sd = SQL1.select(sql);

           dataGridView2.ReadOnly = true;

           dataGridView2.DataSource = sd.ds.Tables[0];

           //个人任务

           string sql2 = "select voluID,volName as 任务名称 ,starTime as 开始时间,endTime as 结束时间,volAdd as 任务地址 ,remark as 备注 from dbo.VolunTask where voluID=(select voluID from samplePeople where sampID="+STATIC.sampID+")";

           selectDate sd2 = SQL1.select(sql2);

           try

           {

               textBox3.Text = sd2.ds.Tables[0].Rows[0]["任务地址"].ToString();

           }

           catch {

               textBox3.Text = "无任务";

           }

           dataGridView3.ReadOnly = true;

           dataGridView3.DataSource = sd2.ds.Tables[0];

       }

 private void button2_Click_1(object sender, EventArgs e)

        {

            try

            {

                int id = Int32.Parse(textBox5.Text);

                DialogResult dr = MessageBox.Show("修改后，当前任务会被刷新，确定修改？", "修改任务", MessageBoxButtons.OKCancel);

                if (dr == DialogResult.OK)

                {

                    string sql = "update dbo.SamplePeople set voluID=" + id;

                    SQL1.excute(sql);

                    //显示任务表格

                    taskTable();

                }

            }

            catch(Exception ex) {

                MessageBox.Show(ex.Message);

            }

        }

5.4.4工作记录

 //显示核酸采样记录

       public void sampleTable()

       {

           string sql = "select l.listID as 'ID', p.pName as '待检人员',w.stuNumber as '学号', sp.pName as '采样人员',l.samTime as '采样时间',l.samADD as '采样地点',r.reName as '试剂名称' from WaitPeople w ,SamplePeople s,Reagent r,DetectList l ,People p,People sp where((l.wpID=w.wpID) and(l.sampID=s.sampID) and(l.reaID=r.reaID) and(s.sampID="+STATIC.sampID+") and(p.pID=w.pID) and(sp.pID=s.pID)) order by l.samTime desc";

           selectDate sd = SQL1.select(sql);

           samplelist = sd.ds.Tables[0];//列表赋值

           dataGridView1.ReadOnly = true;

           dataGridView1.DataSource = sd.ds.Tables[0];

       }

5.4.4.1排名

图5.9 排名

  //显示排名情况

           string sql2 = " select rank,count from (select rank() over(order by COUNT(sampID) desc) as rank,sampID,COUNT(sampID) as count from DetectList  group by sampID) r where r.sampID=" + STATIC.sampID;

           selectDate sd2 = SQL1.select(sql2);

            if (sd2.hasrows == true)

                {

                    int rank = int.Parse(sd2.ds.Tables[0].Rows[0]["rank"].ToString());

                    int count = int.Parse(sd2.ds.Tables[0].Rows[0]["count"].ToString());

                    string sql3 = "select count(*) as totle from (select rank() over(order by COUNT(sampID) desc) as rank,sampID,COUNT(wpID) as count from DetectList  group by sampID) r";

                    selectDate sd3 = SQL1.select(sql3);

                    int totle = int.Parse(sd3.ds.Tables[0].Rows[0]["totle"].ToString());

                    label7.Text = "你已经采样了" + count.ToString() + "次核酸";

                    label8.Text = "超过了" + ((int)((1 - (rank - 1) / totle) * 1000) / 10).ToString() + "%的志愿者，继续努力哦！";

                }

                else {

                    label7.Text = "你还未做过任何采样活动";

                    label8.Text = "未超过任何人";

                }

5.4.4.2采样记录查询

图5.10 查询

        private void button4_Click(object sender, EventArgs e)

        {

            string text = comboBox1.Text;

            string att="";

            switch(text)

            {

                case "待检人员": att = "p.pName"; break;

                case "采样地点": att = "l.samAdd"; break;

                case "试剂名称": att = "r.reName"; break;

            }

            string sql = "select l.listID as 'ID', p.pName as '待检人员',w.stuNumber as '学号', sp.pName as '采样人员',l.samTime as '采样时间',l.samADD as '采样地点',r.reName as '试剂名称' from WaitPeople w ,SamplePeople s,Reagent r,DetectList l ,People p,People sp where((l.wpID=w.wpID) and(l.sampID=s.sampID) and(l.reaID=r.reaID) and(s.sampID=" + STATIC.sampID + ") and(p.pID=w.pID) and(sp.pID=s.pID) and ("+att+"='"+textBox6.Text+"')) order by l.samTime desc";

            selectDate sd = SQL1.select(sql);

            dataGridView1.ReadOnly = true;

            dataGridView1.DataSource = sd.ds.Tables[0];

            if(sd.hasrows==true)MessageBox.Show("查询成功!");

        }

5.4.4.3修改

图5.11 修改

private void button6_Click(object sender, EventArgs e)

        {

             var rows = dataGridView1.SelectedRows ;

            foreach (DataGridViewRow r in rows )

            {

                try

                { string ID = r.Cells["ID"].Value.ToString();

                  string time = r.Cells["采样时间"].Value.ToString();

                    string add = r.Cells["采样地点"].Value.ToString();

                    string sql1 = "update dbo.DetectList set samTime='"+time+"',samAdd='"+add+"' where listID="+ID;

                    SQL1.excute(sql1);

                    sampleTable();

                    MessageBox.Show("修改成功！");

                }

                catch (Exception ex) {MessageBox.Show( ex.Message); }

            }

5.4.4.4 删除

图5.12 删除

        private void button5_Click(object sender, EventArgs e)

        {

            var rows = dataGridView1.SelectedRows ;

            foreach (DataGridViewRow r in rows )

            {

                try

                {

                    string ID = r.Cells["ID"].Value.ToString();

                    string sql = "delete from dbo.DetectList where listID=" + ID;

                    SQL1.excute(sql);

                    sampleTable();

                    MessageBox.Show("删除成功！");

                }

                catch { }

            }

        }

5.5 检测人员系统

5.5.1首页

图5.13 首页

与采样者系统代码类似，代码略。

5.5.2上传检测信息

图5.14 上传

与采样者系统代码类似，代码略。

5.5.3个人信息

图5.15 个人信息

与采样者系统代码类似，代码略。

5.5.4检测记录

图5.16 记录

与采样者系统代码类似，代码略。

5.6 管理人员系统

5.6.1（表格）人员管理

5.6.1.1查看表格

图5.17 查看表格

  private void button1_Click(object sender, EventArgs e)

        {

            string table = comboBox1.Text;

            string sql = "";

            switch (table)

            {

                case "所有人员": sql = "select pID as ID,pName as 姓名 ,pSex as 性别,pPhone as 电话号,pIDnumber as 身份证号 ,pAdd as 住址 from people"; break;

                case "所有待测者": sql = "select p.pID as ID,pName as 姓名 ,w.stuNumber as 学号,pSex as 性别,pPhone as 电话号,pIDnumber as 身份证号 ,pAdd as 住址 from people p,WaitPeople w where p.pID=w.pID"; break;

                case "所有检测者": sql = "select p.pID as ID,pName as 姓名 ,pSex as 性别,w.department as 机构,w.position as 职务,pPhone as 电话号,pIDnumber as 身份证号 ,pAdd as 住址 from people p,DetectPeople w where p.pID=w.pID"; break;

                case "所有采样者": sql = "select p.pID as ID,pName as 姓名 ,pSex as 性别,pPhone as 电话号,pIDnumber as 身份证号 ,pAdd as 住址 from people p,SamplePeople w where p.pID=w.pID"; break;

                case "所有管理者": sql = "select p.pID as ID,pName as 姓名 ,pSex as 性别,pPhone as 电话号,pIDnumber as 身份证号 ,pAdd as 住址 from people p,AccNumber n where (p.pID=n.pID)and (n.auID=4|5)"; break;

            }

            MessageBox.Show("查找成功！");

            richTextBox1.Text = comboBox1.Text;

            selectDate sd = SQL1.select(sql);

            dataGridView1.ReadOnly = true;

            dataGridView1.DataSource = sd.ds.Tables[0];

            t = sd.ds.Tables[0];

            coluName();

        }

5.6.1.2权限管理

图5.18 权限管理

        private void button3_Click(object sender, EventArgs e)

        {

            string ID = textBox2.Text;

            string au = comboBox3.Text;

            string sql = "update AccNumber set auID=(select auID from AccAuthority where auName='" + comboBox3.Text + "') where pID=" + ID;

            int i = SQL1.excute(sql);

            if (i > 0) { MessageBox.Show("设置成功！"); }

            //查看所有人员权限

            string sql2 = "select p.pID as ID ,pName as 姓名,pPhone as 手机号,auName as 权限 from People p,AccNumber a,AccAuthority au where p.pID=a.pID and a.auID=au.auID";

            showTable(SQL1.select(sql2).ds.Tables[0], "权限表");

        }

5.6.2（表格）任务管理

图5.19 任务管理

5.6.2.1新建

        //新建任务

        private void button4_Click(object sender, EventArgs e)

        {

            string name = textBox4.Text;

            string star = textBox6.Text;

            string end = textBox8.Text;

            string add = textBox10.Text;

            string remark = textBox12.Text;

            string sql = "insert into dbo.VolunTask( volName, starTime,endTime,volAdd,remark) values('" + name + "','" + star + "','" + end + "','" + add + "','" + remark + "')";

            int i = SQL1.excute(sql);

            if (i > 0) { MessageBox.Show("新建任务成功！"); }

            string sql2 = "select volName as 任务名称 ,starTime as 任务开始时间,endTime as 任务结束时间 ,volAdd as 任务地点 ,remark as 备注 from dbo.VolunTask";

            showTable(SQL1.select(sql2).ds.Tables[0], "所有任务表");

        }

5.6.2.2查询

        //查看所有任务

        private void button5_Click(object sender, EventArgs e)

        {

            string sql2 = "select voluID,volName as 任务名称 ,starTime as 任务开始时间,endTime as 任务结束时间 ,volAdd as 任务地点 ,remark as 备注 from dbo.VolunTask";

            showTable(SQL1.select(sql2).ds.Tables[0], "所有任务表");

        }

5.6.2.3删除

        private void button6_Click(object sender, EventArgs e)

        {

            var rows = dataGridView1.SelectedRows;

            foreach (DataGridViewRow r in rows)

            {

                try

                {

                    string ID = r.Cells["voluID"].Value.ToString();

                    string sql = "delete from dbo.VolunTask where voluID=" + ID;

                    SQL1.excute(sql);

                    MessageBox.Show("删除成功！");

                }

                catch { }

            }

            string sql2 = "select voluID,volName as 任务名称 ,starTime as 任务开始时间,endTime as 任务结束时间 ,volAdd as 任务地点 ,remark as 备注 from dbo.VolunTask";

            showTable(SQL1.select(sql2).ds.Tables[0], "所有任务表");

        }

5.6.3（表格）核酸管理

图5.20 核酸管理

5.6.3.1查看所有

        private void button7_Click(object sender, EventArgs e)

        {

            string sql = "select p.pName as '待检人员',w.stuNumber as '学号', sp.pName as '采样人员',l.samTime as '采样时间',l.samADD as '采样地点',dp.department as '检测机构',ddp.pName as '检测人员',t.result as '检测结果',r.deteTime as '检测时间',r.reRemark as '备注' from WaitPeople w ,SamplePeople s,Reagent r,DetectResult t ,DetectList l ,DetectPeople dp,People p,People sp,People ddp where((l.wpID=w.wpID) and(l.sampID=s.sampID) and(l.reaID=r.reaID) and(r.deterID=t.deterID) and(r.detpID=dp.detpID) and(p.pID=w.pID) and(sp.pID=s.pID) and(ddp.pID=dp.pID)  ) order by l.samTime desc";

            showTable(SQL1.select(sql).ds.Tables[0], "核酸流程表");

        }

5.6.3.2查看未做核酸

 private void button9_Click(object sender, EventArgs e)

        {

            try

            {

                string day = textBox15.Text;

                string sql = "select a.pName as 姓名,a.stuNumber as 学号,a.pSex as 性别,a.pPhone as 电话,a.stuNumber as 身份证号,a.pAdd as 地址,b.samTime as 最新采样时间 from (select p.pID,wpID,p.pName,p.pSex,w.stuNumber,p.pPhone,p.pAdd from People p,WaitPeople w where p.pID=w.pID) a left join (select d.wpID,MAX(d.samTime) as samTime from DetectList d group by d.wpID) b on a.wpID=b.wpID  where samTime is NULL or GETDATE()- samTime>" + day;

                selectDate sd = SQL1.select(sql);

                showTable(sd.ds.Tables[0], "未做核酸" + day + "天的人员");

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

        }

5.6.4（表格）筛选数据及导出表格

图5.21 查询和导出

//筛选

        private void button2_Click(object sender, EventArgs e)

        {

            try

            {

                String symbol = comboBox4.Text;

                switch (symbol)

                {

                    case "=": for (int i = 0; i < t.Rows.Count; i++)

                        {

                            if ((t.Rows[i][comboBox2.Text]).ToString() != textBox1.Text)

                            {

                                t.Rows.RemoveAt(i);

                            }

                        }; richTextBox1.Text += "_" + comboBox2.Text + "=" + textBox1.Text; break;

                    case ">": for (int i = 0; i < t.Rows.Count; i++)

                        {

                            if (t.Rows[i][comboBox2.Text].GetType() == typeof(int) || t.Rows[i][comboBox2.Text].GetType() == typeof(float) || t.Rows[i][comboBox2.Text].GetType() == typeof(double))

                            {

                                if (float.Parse((t.Rows[i][comboBox2.Text]).ToString()) <= float.Parse(textBox1.Text))

                                {

                                    t.Rows.RemoveAt(i);

                                }

                            }

                            else if (t.Rows[i][comboBox2.Text].GetType() == typeof(DateTime))

                            {

                                if (Convert.ToDateTime(t.Rows[i][comboBox2.Text]) <= Convert.ToDateTime(textBox1.Text))

                                {

                                    t.Rows.RemoveAt(i);

                                }

                            }

                            else

                            {

                                MessageBox.Show("字符串比较大小没有意义哦！"); return;

                            }

                        }; richTextBox1.Text += "_" + comboBox2.Text + ">" + textBox1.Text; break;

                    case "<": for (int i = 0; i < t.Rows.Count; i++)

                        {

                            if (t.Rows[i][comboBox2.Text].GetType() == typeof(int) || t.Rows[i][comboBox2.Text].GetType() == typeof(float) || t.Rows[i][comboBox2.Text].GetType() == typeof(double))

                            {

                                if (float.Parse((t.Rows[i][comboBox2.Text]).ToString()) >= float.Parse(textBox1.Text))

                                {

                                    t.Rows.RemoveAt(i);

                                }

                            }

                            else if (t.Rows[i][comboBox2.Text].GetType() == typeof(DateTime))

                            {

                                if (Convert.ToDateTime(t.Rows[i][comboBox2.Text]) >= Convert.ToDateTime(textBox1.Text))

                                {

                                    t.Rows.RemoveAt(i);

                                }

                            }

                            else

                            {

                                MessageBox.Show("字符串比较大小没有意义哦！"); return;

                            }

                        }; richTextBox1.Text += "_" + comboBox2.Text + "<" + textBox1.Text; break;

                    case "!=": for (int i = 0; i < t.Rows.Count; i++)

                        {

                            if ((t.Rows[i][comboBox2.Text]).ToString() == textBox1.Text)

                            {

                                t.Rows.RemoveAt(i);

                            }

                        }; richTextBox1.Text += "_" + comboBox2.Text + "!=" + textBox1.Text; break;

                }

            }

            catch (Exception ex) { MessageBox.Show("错误：" + ex.Message + "\n小贴士提醒您：请正确输入！！！"); return; }

            dataGridView1.DataSource = t;

            MessageBox.Show("筛选成功！");

        }

5.6.5（可视化地图）打开地图

图5.22 打开地图

        private void 朝阳校区ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.ClearLayers();

            string url = Application.StartupPath + "./地图/朝阳校区.mxd";

            axMapControl1.LoadMxFile(url);

            richTextBox2.Text ="朝阳"+ "校区核酸检测";

        }

        private void 南湖校区ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.ClearLayers();

            string url = Application.StartupPath + "./地图/南湖校区.mxd";

            axMapControl1.LoadMxFile(url);

            richTextBox2.Text = "南湖" + "校区核酸检测";

        }

        private void 新民校区ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.ClearLayers();

            string url = Application.StartupPath + "./地图/新民校区.mxd";

            axMapControl1.LoadMxFile(url);

            richTextBox2.Text = "新民" + "校区核酸检测";

        }

        private void 南岭校区ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.ClearLayers();

            string url = Application.StartupPath + "./地图/南岭校区.mxd";

            axMapControl1.LoadMxFile(url);

            richTextBox2.Text = "南岭" + "校区核酸检测";

        }

        private void 前卫南区ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.ClearLayers();

            string url = Application.StartupPath + "./地图/中心校区.mxd";

            axMapControl1.LoadMxFile(url);

            richTextBox2.Text = "中心" + "校区核酸检测";

        }

5.6.6（可视化地图）工具

图5.23 工具

5.6.6.1鼠标点击事件

 private void axMapControl1_OnMouseDown(object sender, ESRI.ArcGIS.Controls.IMapControlEvents2_OnMouseDownEvent e)

        {

            try

            {

                if (e.button == 2)

                {

                    function = string.Empty;

                }

                string mapUnit = string.Empty;

                switch (axMapControl1.MapUnits)

                {

                    case esriUnits.esriKilometers: mapUnit = "千米"; break;

                    case esriUnits.esriMeters: mapUnit = "米"; break;

                    case esriUnits.esriInches: mapUnit = "英尺"; break;

                    case esriUnits.esriMiles: mapUnit = "英里"; break;

                    case esriUnits.esriCentimeters: mapUnit = "厘米"; break;

                    case esriUnits.esriDecimalDegrees: mapUnit = "十进制"; break;

                    default: mapUnit = "未知单位"; break;

                }

                IEnvelope envelop;

                IGeometry geometry;

                switch (function)

                {

                    case "coordinate":

                        MessageBox.Show("当前地点的坐标为：x:" + e.mapX + mapUnit + ",y:" + e.mapY + mapUnit);

                        break;

                    case "ZoomIn":

                        envelop = axMapControl1.TrackRectangle();

                        axMapControl1.Extent = envelop;

                        axMapControl1.Refresh();

                        break;

                    case "select":

                        geometry = axMapControl1.TrackRectangle();

                        axMapControl1.Map.SelectByShape(geometry, null, false);

                        MessageBox.Show("已选择要素" + axMapControl1.Map.SelectionCount + "个");

                        axMapControl1.Refresh();

                        break;

                    case "createPoint":

                        IFeatureLayer pFLayer = axMapControl1.get_Layer(findlayerByname("核酸检测点")) as IFeatureLayer;

                        IFeatureClass pFC = pFLayer.FeatureClass;

                        //类型不对停止编辑\n               

                        if (pFC.ShapeType != ESRI.ArcGIS.Geometry.esriGeometryType.esriGeometryPoint) { return; }

                        //建立编辑空间\n               

                        IDataset pDataset = pFC as IDataset;

                        IWorkspace pWorkspace = pDataset.Workspace;

                        IWorkspaceEdit pWorkspaceEdit = pWorkspace as IWorkspaceEdit;

                        //开始编辑\n               

                        pWorkspaceEdit.StartEditing(false);

                        pWorkspaceEdit.StartEditOperation();

                        //创建点\n               

                        ESRI.ArcGIS.Geometry.IPoint point = new ESRI.ArcGIS.Geometry.PointClass();

                        point.X = e.mapX;

                        point.Y = e.mapY;

                        richTextBox4.Text = point.X.ToString();

                        richTextBox5.Text = point.Y.ToString();                       

                        IFeature pFeature = pFC.CreateFeature();

                        pFeature.Shape = point;//设置新建的元素为点元素

                        //对元素设置属性值：

                        pFeature.set_Value(pFeature.Fields.FindField("任务名称"), richTextBox2.Text);

                        pFeature.set_Value(pFeature.Fields.FindField("任务描述"), richTextBox3.Text);

                        pFeature.set_Value(pFeature.Fields.FindField("开始时间"), dateTimePicker1.Text);

                        pFeature.set_Value(pFeature.Fields.FindField("结束时间"), dateTimePicker2.Text);

                        pFeature.set_Value(pFeature.Fields.FindField("地点名称"), richTextBox9.Text);

                        pFeature.Store();

                        //数据库新增新元素

                        string sql = "insert into VolunTask(objectID,volName,remark,starTime,endTime,volAdd) values("+pFeature.get_Value( pFeature.Fields.FindField("OBJECTID"))+","+"'" + richTextBox2.Text + "','" + richTextBox3.Text + "','" + DateTime.Parse( dateTimePicker1.Text.Replace("/", "-")) + "','" + DateTime.Parse(dateTimePicker2.Text.Replace("/", "-")) + "','" + richTextBox9.Text + "')";

                        int i=SQL1.excute(sql);

                        if (i > 0)

                        {

                            MessageBox.Show("数据库VolunTask新增数据项成功！");

                        }

                        //停止编辑\n               

                        pWorkspaceEdit.StopEditOperation();

                        pWorkspaceEdit.StopEditing(true);

                        axMapControl1.ActiveView.Refresh();//更新视窗

                        break;

                }

            }

            catch (Exception ex) { MessageBox.Show(ex.Message); }

        }

5.6.6.2放大

        private void 点击放大ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            IEnvelope envelope = axMapControl1.Extent;

            envelope.Expand(0.5, 0.5, true);

            axMapControl1.Extent = envelope;

            axMapControl1.Refresh();

        }

        private void 拉框放大ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            function = "ZoomIn";

        }

5.6.6.3缩小

        private void 缩小ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            IEnvelope envelope = axMapControl1.Extent;

            envelope.Expand(1.5, 1.5, true);

            axMapControl1.Extent = envelope;

            axMapControl1.Refresh();

        }

5.6.6.4全图

        private void 全图ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.Extent = axMapControl1.FullExtent;

        }

5.6.6.5漫游

        private void 漫游ToolStripMenuItem_Click(object sender, EventArgs e)

        {

            axMapControl1.Pan();

        }

5.6.6.6获取坐标点

        private void 获取坐标点ToolStripMenuItem_Click(object sender, EventArgs e)