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)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (MasterCombo.SelectedValue.ToString() == dt.Rows[i]["ma_user"].ToString())
                {
                    DataHelper.DBConnectionString = "Data Source=" + dt.Rows[i]["ma_address"] + ";User ID=" + dt.Rows[i]["ma_user"] + ";PassWord=" + dt.Rows[i]["ms_pwd"];
                    //重新执行一遍构造函数使得重置之后的链接字符串生效
                    dh = new DataHelper();
                }
            }
            WorkCenter.DisplayMember = "wc_name";
            WorkCenter.ValueMember = "wc_code";
            WorkCenter.DataSource = dh.ExecuteSql("select wc_code,wc_name from workcenter", "select");
        }
    }
}