mes-client/PLCDataReader/Login.cs

using System;
using DevExpress.XtraEditors;
using UAS_PLCDataReader.Entity;
using System.Data;
using UAS_PLCDataReader.DataOperate;
using UAS_PLCDataReader.PublicMethod;

namespace UAS_PLCDataReader
{
    public partial class Login : XtraForm
    {
        DataHelper dh = new DataHelper();

        public DataTable UserInf { get; private set; }

        public Login()
        {
            InitializeComponent();
        }

        private void Login_Load(object sender, EventArgs e)
        {
            SystemInf.dh = dh;
            DataTable dt = (DataTable)dh.ExecuteSql("select ma_user,ma_function from master", "select");
            BaseUtil.FillComBoxEditWidthDataTable(Master, "ma_function", "ma_user", dt, false);
            string index = BaseUtil.GetCacheData("Master").ToString();
            Master.SelectedIndex = int.Parse(index == "" ? "0" : index);
        }

        private void LoginButton_Click(object sender, EventArgs e)
        {
            if (UserName.Text != "" && PassWord.Text != "")
            {
                string oErrMessage = "";
                string master = BaseUtil.GetComboxEditValue(Master);
                if (LogicHandler.CheckUserLogin(UserName.Text, PassWord.Text, master, out oErrMessage))
                {
                    DataHelper.DBConnectionString = "Connection Timeout=0;Pooling=false;Password=select!#%*(;User ID=" + master + ";Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=183.238.39.179)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
                    dh = new DataHelper();
                    SystemInf.dh = dh;
                    BaseUtil.SetCacheData("Master", Master.SelectedIndex);
                    SetInf();
                    Main main = new Main();
                    Hide();
                    main.ShowDialog();
                    Close();
                }
                else XtraMessageBox.Show(oErrMessage);
            }
            else XtraMessageBox.Show("用户名和密码不能为空!");
        }

        /// <summary>
        ///设置User类的全局变量，类似于Session
        /// </summary>
        private void SetInf()
        {
            //设置全局用户信息
            string[] field = { "em_code,em_depart,em_type,em_name,em_position,em_professname,em_type" };
            UserInf = dh.getFieldsDataByCondition("Employee ", field, "upper(em_code)='" + UserName.Text.ToUpper() + "'");
            //通过Source表关联岗位资源编号查询出当前的执行工序
            User.UserCode = UserInf.Rows[0]["em_code"].ToString();
            User.UserDepartment = UserInf.Rows[0]["em_depart"].ToString();
            User.UserName = UserInf.Rows[0]["em_name"].ToString();
            User.UserPosition = UserInf.Rows[0]["em_position"].ToString();
            User.UserProfessName = UserInf.Rows[0]["em_professname"].ToString();
            User.UserAccountType = UserInf.Rows[0]["em_type"].ToString();
            //User.UserGroupCode = UserInf.Rows[0]["ug_code"].ToString();
            //User.UserGroup = UserInf.Rows[0]["ug_name"].ToString();
        }

        private void PassWord_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
        {
            if (e.KeyCode == System.Windows.Forms.Keys.Enter)
            {
                LoginButton.PerformClick();
            }
        }
    }
}