form1.cs

windows mobile读取GPS数据

            this.subline_baseTableAdapter.Fill(qxpdaDataSet.subline_base);
            this.subline_baseBindingSource.ResetBindings(false);
            this.subline_baseBindingSource.MoveLast();
            UpdateButtonState();
            MessageBox.Show("删除当前记录成功！");
 
        }
        private void gt_delete_Click(object sender, EventArgs e)
        {
            int nId = 0;
            string strSql = "";
            if (MessageBox.Show("是否继续删除该条记录?", "警告:", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.OK)
            {
                return;
            }
            //获取当前记录的id
            DataRowView drv = (DataRowView)this.pole_towerBindingSource.Current;
            nId = (int)drv.Row["id"];

            MessageBox.Show(nId.ToString());

            //删除当前记录
            strSql = "delete from pole_tower where id = " + nId;
            ExcuteSql(strSql);

            this.pole_towerTableAdapter.Fill(qxpdaDataSet.pole_tower);
            this.pole_towerBindingSource.ResetBindings(false);
            this.pole_towerBindingSource.MoveLast();
            UpdateButtonState();
            MessageBox.Show("删除当前记录成功！");
        } 
        private void lc_delete_Click(object sender, EventArgs e)
        {
            int nLcCode = 0;
            string strSql = "";
            if (MessageBox.Show("是否继续删除该条记录?", "警告:", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.OK)
            {
                return;
            }
            //获取当前记录的lc_code
            DataRowView drv = (DataRowView)this.line_crossBindingSource.Current;
            nLcCode = (int)drv.Row["lc_code"];

            MessageBox.Show(nLcCode.ToString());
            //删除当前记录
            strSql = "delete from line_cross where lc_code = " + nLcCode;
            ExcuteSql(strSql);

            this.line_crossTableAdapter.Fill(qxpdaDataSet.line_cross);
            this.line_crossBindingSource.ResetBindings(false);
            this.line_crossBindingSource.MoveNext();
            UpdateButtonState();
            MessageBox.Show("删除当前记录成功！");

        }
       
        /// <summary>
        /// 退出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void exit_Click(object sender, EventArgs e)
        {
            if (gps.Opened)
                gps.Close();
            Close();
        }
        //获取坐标事件
        private void bdz_get_one_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(bdz_x1, bdz_y1);
        }
        private void bdz_get_two_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(bdz_x2, bdz_y2);
        }
        private void bdz_get_thr_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(bdz_x1, bdz_y1);
        }
        private void bdz_get_four_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(bdz_x1, bdz_y1);
        }
        private void gt_getpoint_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(gt_longitude, gt_latitude);
        }
        private void lc_get_one_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(lc_x1, lc_y1);
        }
        private void lc_get_two_Click(object sender, EventArgs e)
        {
            GetGpsLocationData(lc_x2, lc_y2);
        }
        
        //自动备份功能的相关实现
        private void auto_backup_data_CheckStateChanged(object sender, EventArgs e)
        {
            if (auto_backup_data.Checked)
            {
                if (IsSDMemeryCardExists())
                {
                    SetControlEnable(true);
                }
                else
                {
                    MessageBox.Show("设备没有检测到扩展SD存储卡,无法启动此功能！");
                }
            }
            else
            {
                SetControlEnable(false);
            }
        }
        /// <summary>
        /// 检测是否存在扩展SD存储卡
        /// </summary>
        /// <returns></returns>
        private bool IsSDMemeryCardExists()
        {
            return true;
        }
        /// <summary>
        /// 定时控件time1的触发函数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void start_to_backup(object sender, EventArgs e)
        {
            
        }
        /// <summary>
        /// 设定控件的可用状态
        /// </summary>
        /// <param name="bEnable"></param>
        private void SetControlEnable(bool bEnable)
        {
            time_label.Enabled = bEnable;
            auto_back_time.Enabled = bEnable;
            fen_label.Enabled = bEnable;
        }
        private void set_time_Click(object sender, EventArgs e)
        {
            ClassIniFile Readini = new ClassIniFile(strIniFilePath);
            int nTimeInterval=0;
            if (auto_backup_data.Checked)
            {
                if(auto_back_time.Text.Length>0)
                {
                    nTimeInterval = Convert.ToInt32(auto_back_time.Text);
                }
                else
                {
                    MessageBox.Show("请选择备份时间间隔！");
                    return;
                 }
                Readini.WriteString("AutoDataBackUp", "IsInUse", "true");
                Readini.WriteInt("AutoDataBackUp", "TimeInterval", nTimeInterval);
                timer1.Interval = nTimeInterval * 1000;
                timer1.Enabled = true;
            }
            else
            {
                Readini.WriteString("AutoDataBackUp", "IsInUse", "false");
                Readini.WriteInt("AutoDataBackUp", "TimeInterval", 0);
                timer1.Enabled = false;
            }
        }
        /// <summary>
        /// 根据Ini文件设定定时控件的状态
        /// </summary>
        /// <param name="strFilePath">Ini文件路径</param>
        private void SetTimeCtrl(string strFilePath)
        {
            string strIsInUse = "";
            int nTimeInterval = 0;
            ClassIniFile readIni = new ClassIniFile(strFilePath);
            strIsInUse = readIni.GetString("AutoDataBackUp", "IsInUse", "");
            nTimeInterval = readIni.GetInt("AutoDataBackUp", "TimeInterval", 0);
            MessageBox.Show(strIsInUse + nTimeInterval.ToString());
            if (strIsInUse.Equals("true"))
            {
                if (nTimeInterval > 0)
                {
                    timer1.Interval = nTimeInterval * 1000;
                    timer1.Enabled = true;
                }
            }
            else
            {
                timer1.Enabled = false;
            }
        }
   
        //下拉框事件处理
        private void sub_bdz_name_SelectedValueChanged(object sender, EventArgs e)
        {
            if (bLoadOver)
            {
                string strSql = "select * from line_base where bdz_code =" + sub_bdz_name.SelectedValue + " order by line_code asc";
                ComboxBind(sub_line_name, strSql, "line_name", "line_code", "");
            }
        }
        private void gt_bdz_name_SelectedValueChanged(object sender, EventArgs e)
        {
            if (bLoadOver)
            {
                string strSql = "select * from line_base where bdz_code =" + gt_bdz_name.SelectedValue + " order by line_code asc";
                bLineNameLoadOver = false;
                ComboxBind(gt_line_name, strSql, "line_name", "line_code", "");
                bLineNameLoadOver = true;
            }
        }
        private void lc_bdz_name_SelectedValueChanged(object sender, EventArgs e)
        {
            if (bLoadOver)
            {
                string strSql = "select * from line_base where bdz_code =" + lc_bdz_name.SelectedValue + " order by line_code asc";
                bLineNameLoadOver = false;
                ComboxBind(lc_line_name, strSql, "line_name", "line_code", "");
                bLineNameLoadOver = true;
            }
        }
        private void gt_line_name_SelectedValueChanged(object sender, EventArgs e)
        {
            if (bLoadOver && bLineNameLoadOver)
            {
                string strSql = "select * from subline_base where bdz_code =" + gt_bdz_name.SelectedValue+" and line_code=" + gt_line_name.SelectedValue + " order by subline_code asc";
                ComboxBind(gt_subline_name, strSql, "subline_name", "subline_code", "");
            }
        }
        private void lc_line_name_SelectedValueChanged(object sender, EventArgs e)
        {
            if (bLoadOver&& bLineNameLoadOver)
            {
                string strSql = "select * from subline_base where bdz_code =" + lc_bdz_name.SelectedValue + " and line_code=" + lc_line_name.SelectedValue + " order by subline_code asc";
                ComboxBind(lc_subline_name, strSql, "subline_name", "subline_code", "");
            }
        }
        //checkbox控件事件处理
        private void b_plane_poleCheckBox_CheckStateChanged(object sender, EventArgs e)
        {
            if (b_plane_poleCheckBox.Checked)
            {
                b_corner_poleCheckBox.Checked = false;
                b_bear_poleCheckBox.Checked = false;
                b_terminal_poleCheckBox.Checked = false;
            }
        }
        private void b_terminal_poleCheckBox_CheckStateChanged(object sender, EventArgs e)
        {
            if (b_terminal_poleCheckBox.Checked)
            {
                b_bear_poleCheckBox.Checked = true;
                b_plane_poleCheckBox.Checked = false;
            }
        }
        private void b_corner_poleCheckBox_CheckStateChanged(object sender, EventArgs e)
        {
            if (b_corner_poleCheckBox.Checked)
            {
                b_plane_poleCheckBox.Checked = false;
            }
        }
        private void b_bear_poleCheckBox_CheckStateChanged(object sender, EventArgs e)
        {
            if (b_bear_poleCheckBox.Checked)
            {
                b_plane_poleCheckBox.Checked = false;
            }
        }
        //对tabControl的一些处理
        private void tabControl_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (tabControl1.SelectedIndex)
            {
                case 0:
                    break;
                case 1:
                    if (qxpdaDataSetUtil.DesignerUtil.IsRunTime())
                    {
                        this.subline_baseTableAdapter.Fill(this.qxpdaDataSet.subline_base);
                    }
                    break;
                case 2:
                    if (bPtComboxDataLoadFirst)
                    {
                        LoadPtComboxData();
                        UpdateButtonState();
                        bPtComboxDataLoadFirst = false;
                    }
                    break;
                case 3:
                    if (bLcComboxDataLoadFirst)
                    {
                        LoadLcComboxData();
                        UpdateButtonState();
                        bLcComboxDataLoadFirst = false;
                    }
                    break;
                case 4:
                    break;
                default:
                    break;
            }
        }
        private void LoadPtComboxData()
        {
            if (qxpdaDataSetUtil.DesignerUtil.IsRunTime())
            {
                this.pole_towerTableAdapter.Fill(this.qxpdaDataSet.pole_tower);
            }
            string strSql = "";
            strSql = "select * from c_code where code_lb='gg' order by code";
            ComboxBind(gt_pole_height, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='gx' order by code";
            ComboxBind(gt_pole_type, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='sj' order by code";
            ComboxBind(gt_tip_radius, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='hdlx' order by code";
            ComboxBind(gt_cross_type, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='dxxh' order by code";
            ComboxBind(gt_lead_model, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='jyzlx' order by code";
            ComboxBind(gt_isolation_type, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='dxplfs' order by code";
            ComboxBind(gt_lead_range_model, strSql, "name", "code", "");
            strSql = "select * from c_code where code_lb='cffs' order by code";
            ComboxBind(gt_trans_mode, strSql, "name", "code", "");
        }
        private void LoadLcComboxData()
        {
            if (qxpdaDataSetUtil.DesignerUtil.IsRunTime())
            {
                this.line_crossTableAdapter.Fill(this.qxpdaDataSet.line_cross);
            }
            string strSql = "select * from c_code where code_lb='jckylx' order by code";
            ComboxBind(lc_cross_span, strSql, "name", "code", "");
        }
        
        //数据备份
        private void backup_database_Click(object sender, EventArgs e)
        {
            SaveFileDialog sfd = new SaveFileDialog();
            string strFilePath = "";
            if (sfd.ShowDialog() == DialogResult.Yes)
            {
                strFilePath = sfd.FileName;
            }
            File.Copy(strConnectString, strFilePath, false);
        }

    }
}