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;

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

        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)
        {
            ftpOperater ftp = new ftpOperater();
            //从FTP的配置文件读取的数据库信息，并且进行解密
            //SystemInf.DefaultDB = Encryption.DecryptStr((ftp.GetFileContent("db.config")));
            //设置默认数据库
            SystemInf.DefaultDB = Properties.Settings.Default.Properties["MES"].DefaultValue.ToString();
            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";
            if (DbComboxData.Rows.Count > 0)
            {
                DB.Text = DbComboxData.Rows[0]["ma_user"].ToString();
            }
            //if (Properties.Settings.Default.LastLoginSob != null)
            //{
            //    DB.SelectedValue = Properties.Settings.Default.LastLoginSob;
            //}
            //显示上次用户登录的用户名，将输入框定位到密码
            UserName.Text = Properties.Settings.Default.LastLoginUser;
            Source.Text = Properties.Settings.Default.LastLoginResource;
            if (UserName.Text != "")
                PassWord.Select();
            else
                UserName.Select();
            //本来static是不要实例化的，但是需要调用触发添加键值对的构造函数
            if (lgc == null)
                lgc = new LogicHandler();
            BaseUtil.SetFormCenter(this);
            try { CertImport(); }
            catch (Exception) { }
        }

        //点击登陆按钮的时候
        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 = "Data Source=" + DbComboxData.Rows[i]["ma_address"] + ";User ID=" + DbComboxData.Rows[i]["ma_user"] + ";PassWord=" + DbComboxData.Rows[i]["ms_pwd"];
                    Console.WriteLine(SystemInf.ConnectionString);
                    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.CheckUserAndSourcePassed(UserName.Text, Source.Text, out ErrorMessage))
                {
                    this.Hide();
                    SetInf();//设置User的全局变量
                    LogManager.DoLog("登陆成功" + User.UserName + ",超级用户");
                    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_stepcode", "sc_stepname", "sc_linecode" }, "sc_code='" + Source.Text + "'");
            //存在岗位资源则要求添加
            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();
            }
            //通过Source表关联岗位资源编号查询出当前的执行工序
            User.UserSourceCode = Source.Text;
            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();
            User.UserAccountType = UserInf.Rows[0]["em_type"].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_Click(sender, e);
        }

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

        /// <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);
                }
            }
        }
    }
}