mes-client/FileWatcher/Login.cs

using System;
using System.Data;
using System.Windows.Forms;

namespace FileWatcher
{
    public partial class Login : Form
    {

        DataHelper dh = new DataHelper();

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

        private void CheckLogin_Click(object sender, EventArgs e)
        {
            string ErrMessage = "";
            DataHelper.DBConnectionString = "Password=select!#%*(;User ID=" + Master.Text + ";Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.253)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
            //重新执行一遍构造函数使得重置之后的链接字符串生效
            dh = new DataHelper();
            AutoAnalysisXmlByStep.dh = dh;
            if (LogicHandler.CheckUserLogin(UserName.Text, PassWord.Text, out ErrMessage))
            {
                if (LogicHandler.CheckUserAndResourcePassed(UserName.Text, Source.Text, out ErrMessage))
                {
                    BaseUtil.SetCacheData("UserName", UserName.Text);
                    BaseUtil.SetCacheData("Source", Source.Text);
                    SOP xml = new SOP(UserName.Text, Source.Text);
                    Hide();
                    xml.ShowDialog();
                    Close();
                }
                else MessageBox.Show(ErrMessage);
            }
            else MessageBox.Show(ErrMessage);
        }

        private void Login_Load(object sender, EventArgs e)
        {
            DataTable DB = (DataTable)dh.ExecuteSql("select ms_pwd,ma_user,ma_address,ma_inneraddress from master ", "select");
            Master.DataSource = DB;
            Master.DisplayMember = "ma_user";
            Master.ValueMember = "ma_user";
            UserName.Text = BaseUtil.GetCacheData("UserName").ToString();
            Source.Text = BaseUtil.GetCacheData("Source").ToString();
            if (UserName.Text != "")
            {
                PassWord.Focus();
            }
        }
    }
}