form1.cs

利用共线方程,用迭代法求解后方交会的参数

        }

        private void closeToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Dispose();
        }

        private void 保存SToolStripButton_Click(object sender, EventArgs e)
        {
            save_data();



        }

        private void newDataToolStripMenuItem_Click(object sender, EventArgs e)
        {
            add_new_data();

        }
       
        
        void add_new_data()
        {
            label1.Visible = false;
            dataGridView1.Columns.Clear();

            label9.Text = "请输入新的数据...... 说明:数据行数必须大于3行";
            ys_data.Visible = true;

            dataGridView1.Columns.Add("X_", "X_");
            dataGridView1.Columns.Add("Y_", "Y_");
            dataGridView1.Columns.Add("Z_", "Z_");
            dataGridView1.Columns.Add("x_", "x_");
            dataGridView1.Columns.Add("Y_", "y_");
            
            //读取新值
                listBox1.Items.Add("读取新值........................");
                listBox1.Items.Add("....");
                listBox1.Items.Add("....");

          
 
        } //添加新数据

        void save_data()
        {
          
            if (tb_k.Text == ""||ys_data.Visible != true)
            {
                MessageBox.Show("没有有用得数据\n请你先计算，然后保存");
                button1.Focus();
                return;

            }

            SaveFileDialog new_save = new SaveFileDialog();
            new_save.Filter = "(文本文档)*.txt|*.txt";
            if (new_save.ShowDialog() == DialogResult.OK)
                if (new_save.FileName != null)
                {

                    StreamWriter sw = new StreamWriter(new_save.FileName);
                    int m = this.dataGridView1.RowCount;
                    int n = this.dataGridView1.ColumnCount;


                    sw.WriteLine("原始数据...................."); 
                    sw.WriteLine(); sw.WriteLine(); 
                        for(int i=0;i <m-1;i++)  
                        { 
                           for(int j=0;j <n-1;j++) 
                            {
                                sw.Write(this.dataGridView1.Rows[i].Cells[j].Value.ToString().PadRight(8, ' ') + "|");  
                             } 
                           sw.WriteLine(); 
                         } 

                    sw.WriteLine(); 
                    sw.WriteLine();
                    sw.WriteLine("Xs0 =  " + Xs0);
                    sw.WriteLine("Ys0 = " +Ys0);
                    sw.WriteLine("Zs0 = " + Zs0);
                    sw.WriteLine("ψ = " + ψ);
                    sw.WriteLine("ω = " + ω);
                    sw.WriteLine("κ = " + κ);
                    sw.WriteLine();
                    
                   

                    sw.WriteLine("------------------------------- 声明----------------------------------");
                    sw.WriteLine(" 姓名 : 王波");
                    sw.WriteLine(" 学号: 06014117  ");
                    sw.WriteLine("班级:  GIS 06-1");
                    sw.WriteLine("-------------------------All Rights Reserved -------------------------");
                    sw.Close();

                }
                else
                {
                    MessageBox.Show("没有有效的文件路径");
                }


        } //保存数据

        void add_data()
        {

            label1.Visible = false;
            OpenFileDialog new_openfile = new OpenFileDialog();
            new_openfile.Filter = "(EXCEL)*.xls|*.xls";

            if (new_openfile.ShowDialog() == DialogResult.OK)
            {
                dataGridView1.Columns.Clear();
                ys_data.Visible = true;

                #region //没有实现的功能 txt to  DataGridView
                //{
                //    MessageBox.Show("您将要打开的是:" + new_openfile.FileName);

                //    // add text data
                //    StreamReader sr = null; 
                //    DataTable dt = new DataTable();

                //    try
                //    {
                //        int k=1;
                        
                //         sr = new StreamReader(new_openfile.FileName, System.Text.Encoding.Default); 
                        
                //         while (sr.Peek() > -1)//从文件中读取行，一直读到文件尾 
                //        { 
                //             string[] values = sr.ReadLine().Split('|'); 
                //             DataRow row = dt.NewRow(); 
                //             List<string> list = new List<string>();
                //             row.BeginEdit(); 
                //             for(int j=1;j <5;j++)//列 
                //             { 
                //                list[j] = values[j]; 
                //             } 
                //              row.EndEdit(); 
                //             dt.Rows.Add(list); 
                //       } 
                //     } 

                //   finally
                //    { 

                //        if(sr != null) 

                //        { 

                //            sr.Close(); 

                //            sr.Dispose(); 

                //        } 

                //    } 
  
                //    dataGridView1.DataSource = dt.DefaultView; 



                //}
                #endregion

                string ss = null;
                string cs = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + new_openfile.FileName + ";Excel 8.0;HDR=Yes;IMEX=1";
                OleDbConnection CNN = new OleDbConnection(cs);
                CNN.Open();
                //历遍Sheet，显示每个Sheet名。
                DataTable ttable = CNN.GetSchema("Tables");
                foreach (DataRow row in ttable.Rows)
                    if (row["Table_Type"].ToString() == "TABLE")

                        ss = "select * from [Sheet1$]";

                OleDbCommand CMD = new OleDbCommand(ss, CNN);
                OleDbDataReader RAD = CMD.ExecuteReader();
                DataTable tab = new DataTable();
                for (int i = 0; i < RAD.FieldCount; i++)
                    tab.Columns.Add(RAD.GetName(i), RAD.GetFieldType(i));

                DataRow row1;

                while (RAD.Read())
                {
                    row1 = tab.NewRow();

                    for (int j = 0; j < tab.Columns.Count; j++)
                    {
                        row1[j] = RAD.GetValue(j);
                    }
                    tab.Rows.Add(row1);

                
                }

                dataGridView1.DataSource = tab;


                
             



            }
 
        }
        void help()
        {
            help new_help = new help();
            new_help.Show();
        }

        private void addDataToolStripMenuItem_Click(object sender, EventArgs e)
        {
            add_data();

        }

        private void 新建NToolStripButton_Click(object sender, EventArgs e)
        {
            add_new_data();
        }

        private void 打开OToolStripButton_Click(object sender, EventArgs e)
        {
            add_data();
        }

        private void saveDataToolStripMenuItem_Click(object sender, EventArgs e)
        {
             save_data();
       
        }

        private void helpToolStripMenuItem_Click(object sender, EventArgs e)
        {
            help();
        }

        private void 帮助LToolStripButton_Click(object sender, EventArgs e)
        {
            help();
        }

        private void newDataToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            add_new_data();
        }

        private void addDataToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            add_data();
        }

        private void closeToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            this.Dispose();
        } 
    }
}