AG-AIRS/FeildParam.xaml.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.IO;
using System.Data.SQLite;
using System.Data;

namespace AIRS
{
    /// <summary>
    /// FeildParam.xaml 的交互逻辑
    /// </summary>
    public partial class FeildParam : Window
    {
        public string standard = "";
        public string ret_shape = "";
        public double ret_dia = 0;
        public int ret_mul = 0;

        private string path = Directory.GetCurrentDirectory();          //程序工作目录
        System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
        System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();

        private string _shape = "";
        private string _diameter = "";
        private string _multiple = "";

        public FeildParam()
        {
            InitializeComponent();
        }

        private void rdb_circle_Checked(object sender, RoutedEventArgs e)
        {
            _shape = "Circle";
        }

        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            connstr.DataSource = path + "\\datas.db";
            conn.ConnectionString = connstr.ToString();
            conn.Open();
            System.Data.SQLite.SQLiteDataAdapter da = new SQLiteDataAdapter("select * from t_standard where opt_standard='" + standard + "'", conn);
            DataTable ds = new DataTable();
            da.Fill(ds);
            if(ds.Rows.Count>0)
            { 
                if(ds.Rows[0][2].ToString().Substring(0,2)=="GB" && ds.Rows[0][4]!= DBNull.Value)
                {
                    _shape = ds.Rows[0][4].ToString();
                    if(_shape=="Circle")
                    {
                        rdb_circle.IsChecked = true;
                    }
                    else
                    {
                        rdb_rect.IsChecked = true;
                    }
                    _diameter = ds.Rows[0][5].ToString();
                    String[] dia = _diameter.Split(',');
                    foreach(string dd in dia)
                    {
                        ComboBoxItem cbbi = new ComboBoxItem();
                        cbbi.Content = dd;
                        cbbdiameter.Items.Add(cbbi);
                    }
                    cbbdiameter.SelectedIndex = 0;
                    _multiple = ds.Rows[0][6].ToString();
                    String[] mul = _multiple.Split(',');
                    foreach (string mull in mul)
                    {
                        ComboBoxItem cbbi = new ComboBoxItem();
                        cbbi.Content = mull;
                        cbbmultiple.Items.Add(cbbi);
                    }
                    cbbmultiple.SelectedIndex = 0;
                }
                else
                {
                    ComboBoxItem comboBox = new ComboBoxItem();
                    comboBox.Content = "70";
                    cbbdiameter.Items.Add(comboBox);
                    comboBox = new ComboBoxItem();
                    comboBox.Content = "80";
                    cbbdiameter.Items.Add(comboBox);
                    comboBox = new ComboBoxItem();
                    comboBox.Content = "100";
                    cbbmultiple.Items.Add(comboBox);
                    comboBox = new ComboBoxItem();
                    comboBox.Content = "500";
                    cbbmultiple.Items.Add(comboBox);
                }
            }
            else
            {
                ComboBoxItem comboBox = new ComboBoxItem();
                comboBox.Content = "70";
                cbbdiameter.Items.Add(comboBox);
                comboBox = new ComboBoxItem();
                comboBox.Content = "80";
                cbbdiameter.Items.Add(comboBox);
                comboBox = new ComboBoxItem();
                comboBox.Content = "100";
                cbbmultiple.Items.Add(comboBox);
                comboBox = new ComboBoxItem();
                comboBox.Content = "500";
                cbbmultiple.Items.Add(comboBox);
            }
        }

        private void rdb_rect_Checked(object sender, RoutedEventArgs e)
        {
            _shape = "Rectangle";
        }

        private void BtnExit_Click(object sender, RoutedEventArgs e)
        {
            this.DialogResult = false;
        }

        private void BtnLogin_Click(object sender, RoutedEventArgs e)
        {
            ret_shape = _shape;
            if(!Double.TryParse(cbbdiameter.Text, out ret_dia))
            {
                MessageBox.Show("直径输入错误！", "提示");
                cbbdiameter.Focus();
                return;
            }
            if (!Int32.TryParse(cbbmultiple.Text, out ret_mul))
            {
                MessageBox.Show("放大倍数输入错误！", "提示");
                cbbmultiple.Focus();
                return;
            }
            this.DialogResult = true;
        }
    }
}