mes-client/UAS_MES_STW/Login.cs

using System;
using System.Windows.Forms;
using System.Data;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using System.Security.Cryptography.X509Certificates;
using System.Net;
using System.Net.Sockets;
using System.Threading;
using System.Drawing;
using UAS_MES_NEW.Properties;
using UAS_MES_NEW.I18n;
using System.IO;
using System.Net.NetworkInformation;

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

        int Close_Size = 24;

        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)
        {
            BaseUtil.FormStepInOrOut(this, true);
            //设置默认数据库
            SystemInf.DefaultDB = "Connection Timeout=0;Pooling=false;Password=select!#%*(;User ID=N_MES;Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.11.30)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
            SystemInf.ProcessesID = System.Diagnostics.Process.GetCurrentProcess().Id;
            CheckForIllegalCrossThreadCalls = false;
            LoadMasterInf = new Thread(LoadMaster);
            LoadMasterInf.Start();
            if (!Directory.Exists(Application.StartupPath + @"\" + DateTime.Now.ToString("yyyy-MM-dd")))
            {
                Directory.CreateDirectory(Application.StartupPath + @"\" + DateTime.Now.ToString("yyyy-MM-dd"));
            }
            //SystemInf.OpenByNet = true;
            //显示上次用户登录的用户名，将输入框定位到密码
            UserName.Text = BaseUtil.GetCacheData("LastLoginUser").ToString();
            Source.Text = BaseUtil.GetCacheData("LastLoginResource").ToString();
            if (UserName.Text != "")
                PassWord.Select();
            else
                UserName.Select();
            BaseUtil.SetFormCenter(this);
            SetupLanguageSelector();
            LocalizeLogin();
        }

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

        //点击登陆按钮的时候
        private void LoginButton_Click(object sender, EventArgs e)
        {
            if (DB.SelectedValue == null)
                BaseUtil.ShowError(LanguageManager.T("请选择一个数据库!"));
            //设置选中数据库的链接
            string DBUser = DB.SelectedValue.ToString().Split('#')[0];
            string Address = DB.SelectedValue.ToString().Split('#')[1];
            DataHelper.DBConnectionString = "Password=select!#%*(;User ID=" + DBUser + ";Pooling=false;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.81.208)(PORT=11724)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));";
            SystemInf.CurrentDB = DBUser;
            //设置屏幕的宽高信息
            SystemInf.ScreenWidth = Screen.PrimaryScreen.WorkingArea.Width;
            SystemInf.ScreenHeight = Screen.PrimaryScreen.WorkingArea.Height;
            //重新执行一遍构造函数使得重置之后的链接字符串生效
            dh = new DataHelper();
            SystemInf.dh = dh;
            string ErrorMessage = "";
            //验证用户名和密码
            if (LogicHandler.CheckUserLogin(UserName.Text, PassWord.Text, DBUser, out ErrorMessage))
            {
                //验证岗位资源,通过验证开启主窗体
                if (LogicHandler.CheckUserAndResourcePassed(UserName.Text, Source.Text, out ErrorMessage))
                {
                    SetInf();//设置User的全局变量
                    this.Hide();
                    //记录登陆信息
                    try
                    {
                        string macAddress = "";
                        foreach (NetworkInterface nic in NetworkInterface.GetAllNetworkInterfaces())
                        {
                            if (nic.OperationalStatus == OperationalStatus.Up)
                            {
                                macAddress = nic.GetPhysicalAddress().ToString();
                                break;
                            }
                        }
                        SystemInf.MacAddress = macAddress;
                        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, "upper(em_code)='" + UserName.Text.ToUpper() + "' or em_mobile='" + UserName.Text.ToUpper() + "'");
            DataTable dt = dh.getFieldsDataByCondition("source left join step on sc_stepcode=st_code", new string[] { "st_badgroupcode", "sc_wccode", "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.DefaultBadGroup = dt.Rows[0]["st_badgroupcode"].ToString();
                User.UserLineCode = dt.Rows[0]["sc_linecode"].ToString();
                User.UserSourceCode = dt.Rows[0]["sc_code"].ToString();
                User.WorkCenter = dt.Rows[0]["sc_wccode"].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();
            //记录在本地用户成功登录的用户名
            BaseUtil.SetCacheData("LastLoginUser", UserName.Text);
            BaseUtil.SetCacheData("LastLoginSob", DB.Text);
            BaseUtil.SetCacheData("LastLoginResource", Source.Text);
        }

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

        //用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)
                Source.Focus();
        }

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

        private void Login_FormClosing(object sender, FormClosingEventArgs e)
        {
            BaseUtil.FormStepInOrOut(this, false);
            try
            {
                dh.Dispose();
            }
            catch (Exception)
            {

            }
        }

        private void UserName_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
                PassWord.Focus();
        }

        private void Login_Paint(object sender, PaintEventArgs e)
        {
            Bitmap image = Resources.dialog_close_24px_1173781_easyicon_net;
            Rectangle rect = this.ClientRectangle;
            //画关闭符号
            using (Pen objpen = new Pen(Color.Black))
            {
                //使用图片
                Bitmap bt = new Bitmap(image);
                Point p5 = new Point(Width - Close_Size - 4, 4);
                e.Graphics.DrawImage(bt, p5);
            }
        }

        private Point offset;
        private void Login_MouseDown(object sender, MouseEventArgs e)
        {
            if (MouseButtons.Left != e.Button) return;
            Point cur = this.PointToScreen(e.Location);
            offset = new Point(cur.X - this.Left, cur.Y - this.Top);

            Rectangle rect = this.ClientRectangle;
            rect.Offset(Width - Close_Size - 4, 4);
            rect.Width = Close_Size;
            rect.Height = Close_Size;
            int x = e.X, y = e.Y;
            bool isClose = x > rect.X && x < rect.Right && y > rect.Y && y < rect.Bottom;
            if (isClose)
                Close();
        }

        private void Login_MouseMove(object sender, MouseEventArgs e)
        {
            if (MouseButtons.Left != e.Button) return;
            Point cur = MousePosition;
            this.Location = new Point(cur.X - offset.X, cur.Y - offset.Y);
        }

        #region 多语言（全球化）
        /// <summary>
        /// 在标题栏右侧添加语言选择下拉框，并应用已保存语言。
        /// </summary>
        private void SetupLanguageSelector()
        {
            LanguageManager.Initialize();

            ComboBox langCombo = new ComboBox();
            langCombo.Name = "LangCombo";
            langCombo.DropDownStyle = ComboBoxStyle.DropDownList;
            langCombo.Font = new System.Drawing.Font("微软雅黑", 9F);
            langCombo.BackColor = System.Drawing.SystemColors.Window;
            // 防止被 Localize 当作普通控件翻译，避免选择被改写后引发语言来回切换
            langCombo.Tag = "NoTranslate";
            foreach (var kvp in LanguageManager.SupportedLanguages)
                langCombo.Items.Add(kvp.Value);

            // syncing=true 期间对 SelectedIndexChanged 的触发（含程序赋值引起）不响应
            bool syncing = false;

            if (LanguageManager.SupportedLanguages.TryGetValue(LanguageManager.CurrentCulture, out var curName))
            {
                syncing = true;
                try { langCombo.SelectedItem = curName; } finally { syncing = false; }
            }

            langCombo.Location = new System.Drawing.Point(panel2.Width - 104, 4);
            langCombo.Size = new System.Drawing.Size(100, 23);
            langCombo.SelectedIndexChanged += (s, e) =>
            {
                if (syncing) return;
                string name = langCombo.SelectedItem?.ToString();
                if (string.IsNullOrEmpty(name)) return;
                foreach (var kvp in LanguageManager.SupportedLanguages)
                {
                    if (kvp.Value == name)
                    {
                        LanguageManager.SetCulture(kvp.Key);
                        break;
                    }
                }
                syncing = true;
                try { LocalizeLogin(); } finally { syncing = false; }
            };

            // 在其它界面切换语言时，同步本下拉框的选中项（不触发切换逻辑）
            LanguageManager.LanguageChanged += (s, e) =>
            {
                syncing = true;
                try
                {
                    if (LanguageManager.SupportedLanguages.TryGetValue(LanguageManager.CurrentCulture, out var n)
                        && !string.Equals(langCombo.SelectedItem?.ToString(), n, StringComparison.Ordinal))
                        langCombo.SelectedItem = n;
                }
                finally { syncing = false; }
            };

            panel2.Controls.Add(langCombo);
        }

        /// <summary>
        /// 将登录窗体上的静态文本切换为当前语言。
        /// </summary>
        private void LocalizeLogin()
        {
            // 自动翻译登录窗体其余静态文本（如设计器中其它中文标签/按钮）
            LanguageManager.Localize(this);
            label1.Text = LanguageManager.T("用户名");
            label2.Text = LanguageManager.T("密码");
            label4.Text = LanguageManager.T("资源");
            label3.Text = LanguageManager.T("数据库");
            LoginButton.Text = LanguageManager.T("登录");
            ForGetPwd.Text = LanguageManager.T("忘记密码");
            label5.Text = LanguageManager.T("优软MES");
        }
        #endregion
    }
}