mes-client/UAS-MES/Login.cs

using System;
using System.Windows.Forms;
using System.Data;
using UAS_MES.DataOperate;
using UAS_MES.Entity;
using UAS_MES.PublicMethod;
using System.Security.Cryptography.X509Certificates;
using System.Net;
using System.Net.Sockets;
using System.Threading;

namespace UAS_MES
{
    public partial class Login : Form
    {
        DataHelper dh;
        //用来保存combox中的数据库信息
        DataTable DbComboxData;
        //用来保存其他信息
        DataTable UserInf;
        //注销的时候会重新生成这边变量，所以需要用static
        static LogicHandler lgc;

        Thread LoadMasterInf;



        public Login()
        {
            InitializeComponent();
        }

        protected override void WndProc(ref Message m)
        {
            //拦截双击标题栏、移动窗体的系统消息  
            if (m.Msg != 0xA3)
            {
                base.WndProc(ref m);
            }
        }

        private void Login_Load(object sender, EventArgs e)
        {
            //设置默认数据库
            SystemInf.DefaultDB = Properties.Settings.Default.Properties["MES"].DefaultValue.ToString();
            CheckForIllegalCrossThreadCalls = false;
            LoadMasterInf = new Thread(LoadMaster);
            LoadMasterInf.Start();
            //显示上次用户登录的用户名，将输入框定位到密码
            UserName.Text = Properties.Settings.Default.LastLoginUser;
            Source.Text = Properties.Settings.Default.LastLoginResource;
            if (UserName.Text != "")
                PassWord.Select();
            else
                UserName.Select();
            BaseUtil.SetFormCenter(this);
        }

        private void LoadMaster()
        {
            try
            {
                dh = new DataHelper();
                //将账套的信息查询出来赋给下拉框
                DbComboxData = (DataTable)dh.ExecuteSql("select ms_pwd,ma_user,ma_address from master", "select");
                DB.DataSource = DbComboxData;
                DB.DisplayMember = "ma_user";
                DB.ValueMember = "ma_user";
                DB.Text = Properties.Settings.Default.LastLoginSob;
                LoginButton.Enabled = true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        //点击登陆按钮的时候
        private void LoginButton_Click(object sender, EventArgs e)
        {
            if (DB.SelectedValue == null)
                BaseUtil.ShowError("请选择一个数据库!");
            //设置选中数据库的链接
            for (int i = 0; i < DbComboxData.Rows.Count; i++)
            {
                if (DB.SelectedValue.ToString() == DbComboxData.Rows[i]["ma_user"].ToString())
                {
                    //设置屏幕的宽高信息 
                    SystemInf.ScreenWidth = Screen.PrimaryScreen.WorkingArea.Width;
                    SystemInf.ScreenHeight = Screen.PrimaryScreen.WorkingArea.Height;
                    SystemInf.ConnectionString = "Connection Timeout=0;Pooling=false;Password=" + DbComboxData.Rows[i]["ms_pwd"] + ";User ID=" + DbComboxData.Rows[i]["ma_user"] + ";Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + DbComboxData.Rows[i]["ma_address"].ToString().Split('/')[0] + ")(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))";
                    DataHelper.DBConnectionString = SystemInf.ConnectionString;
                    //重新执行一遍构造函数使得重置之后的链接字符串生效
                    dh = new DataHelper();
                    SystemInf.CurrentDB = DbComboxData.Rows[i]["ma_user"].ToString();
                }
            }
            string ErrorMessage = "";
            //验证用户名和密码
            if (LogicHandler.CheckUserLogin(UserName.Text, PassWord.Text, out ErrorMessage))
            {
                //验证岗位资源,通过验证开启主窗体
                if (LogicHandler.CheckUserAndResourcePassed(UserName.Text, Source.Text, out ErrorMessage))
                {
                    SetInf();//设置User的全局变量
                    this.Hide();
                    //记录登陆信息
                    try
                    {
                        IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
                        string IPAddress = "";
                        for (int i = 0; i < IpEntry.AddressList.Length; i++)
                        {
                            if (IpEntry.AddressList[i].AddressFamily == AddressFamily.InterNetwork)
                                IPAddress = IpEntry.AddressList[i].ToString();
                        }
                        string version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
                        LogicHandler.RecordLogInfo(User.UserCode, User.UserName, version, "CS", IPAddress);
                    }
                    catch (Exception ex)
                    {
                        LogManager.DoLog(ex.Message);
                    }
                    LogManager.DoLog("登陆成功" + User.UserName + "  " + User.UserAccountType);
                    Main dialog = new Main();
                    dialog.ShowDialog();
                    this.Close();
                }
                else
                    MessageBox.Show(ErrorMessage);
            }
            else
                MessageBox.Show(ErrorMessage);
        }

        /// <summary>
        ///设置User类的全局变量，类似于Session
        /// </summary>
        private void SetInf()
        {
            //设置全局用户信息
            string[] field = { "em_code,em_depart,em_type,em_name,em_position,em_professname,em_type,ug_code,ug_name" };
            UserInf = dh.getFieldsDataByCondition("Employee left join cs$userresource on ur_emcode=em_code left join cs$usergroup on ug_code=ur_groupcode", field, "em_code='" + UserName.Text + "'");
            DataTable dt = dh.getFieldsDataByCondition("source", new string[] { "sc_code", "sc_stepcode", "sc_stepname", "sc_linecode" }, "upper(sc_code)='" + Source.Text.ToUpper() + "'");
            //存在岗位资源则要求添加
            if (dt.Rows.Count > 0)
            {
                User.CurrentStepCode = dt.Rows[0]["sc_stepcode"].ToString();
                User.CurrentStepName = dt.Rows[0]["sc_stepname"].ToString();
                User.UserLineCode = dt.Rows[0]["sc_linecode"].ToString();
                User.UserSourceCode = dt.Rows[0]["sc_code"].ToString();
            }
            //通过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();
            //设置系统基础信息
            UserInf = (DataTable)dh.ExecuteSql("select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as systime from dual", "select");
            SystemInf.LoginTime = UserInf.Rows[0]["systime"].ToString();
            //记录在本地用户成功登录的用户名
            Properties.Settings.Default.LastLoginUser = UserName.Text;
            Properties.Settings.Default.LastLoginSob = DB.Text;
            Properties.Settings.Default.LastLoginResource = Source.Text;
            Properties.Settings.Default.Save();
        }

        private void ForGetPwd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            MessageBox.Show("请联系管理员修改密码");
        }

        //用Enter键调用登陆的点击事件
        private void Source_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                LoginButton.PerformClick();
        }

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

        /// <summary>
        /// 导入证书
        /// </summary>
        private void CertImport()
        {
            X509Certificate2 cert = new X509Certificate2(Application.StartupPath + @"\Cert\深圳市优软科技有限公司.pfx", "uasmes");
            if (cert != null)
            {
                var store2 = new X509Store(StoreName.My, StoreLocation.CurrentUser);
                store2.Open(OpenFlags.ReadWrite);
                if (!store2.Certificates.Contains(cert))
                {
                    store2.Add(cert);
                }
                var store = new X509Store(StoreName.Root, StoreLocation.LocalMachine);
                store.Open(OpenFlags.ReadWrite);
                if (!store.Certificates.Contains(cert))
                {
                    store.Add(cert);
                }
            }
        }
    }
}