mes-client/UAS_KanBan/Setting.cs

using CCWin;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using CCWin.SkinControl;

namespace UAS_KanBan
{
    public partial class Setting : BaseForm
    {

        DataHelper dh = new DataHelper();

        DataTable dt;

        public static int RefreshRate = 0;

        public Setting()
        {
            StartPosition = FormStartPosition.CenterScreen;
            InitializeComponent();
        }

        private void Setting_Load(object sender, EventArgs e)
        {
            MasterCombo.DisplayMember = "ma_user";
            MasterCombo.ValueMember = "ma_user";
            dt = (DataTable)dh.ExecuteSql("select ms_pwd,ma_user,ma_address from master", "select");
            MasterCombo.DataSource = dt;
            MasterCombo.Text = Properties.Settings.Default.Master;
            WorkCenter.Text = Properties.Settings.Default.WorkCenter;
            TimeSpan.Text = Properties.Settings.Default.TimeSpan;
        }

        private void Start_Click(object sender, EventArgs e)
        {
            try
            {
                RefreshRate = int.Parse(TimeSpan.Text);
            }
            catch (Exception)
            {
                MessageBox.Show("刷新时间必须是正整数");
                return;
            }
            Properties.Settings.Default.Master = MasterCombo.Text;
            Properties.Settings.Default.LineCode = Line.Text;
            Properties.Settings.Default.WorkCenter = WorkCenter.Text;
            Properties.Settings.Default.TimeSpan = TimeSpan.Text;
            Properties.Settings.Default.Save();
            Process pr = new Process(Line.SelectedValue.ToString(), WorkCenter.SelectedValue.ToString());
            pr.ShowDialog();
        }

        private void WorkCenter_SelectedIndexChanged(object sender, EventArgs e)
        {
            Line.DisplayMember = "li_name";
            Line.ValueMember = "li_code";
            Line.DataSource = dh.ExecuteSql("select li_code,li_name from line where li_wccode='" + WorkCenter.SelectedValue.ToString() + "' order by li_code ", "select");
            Line.Text = Properties.Settings.Default.LineCode;
        }

        private void MasterCombo_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (MasterCombo.SelectedValue.ToString().ToUpper())
            {
                case "MES_TEST":
                    DataHelper.DBConnectionString = "Password=select!#%*(;User ID=MES_TEST;Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.230.200)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
                    break;
                case "MES":
                    DataHelper.DBConnectionString = "Password=select!#%*(;User ID=MES;Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.230.200)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
                    break;
                default:
                    break;
            }
            dh = new DataHelper();
            WorkCenter.DisplayMember = "wc_name";
            WorkCenter.ValueMember = "wc_code";
            WorkCenter.DataSource = dh.ExecuteSql("select wc_code,wc_name from workcenter", "select");
        }
    }
}