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); } /// ///设置User类的全局变量,类似于Session /// 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(); } /// /// 导入证书 /// 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 多语言(全球化) /// /// 在标题栏右侧添加语言选择下拉框,并应用已保存语言。 /// 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); } /// /// 将登录窗体上的静态文本切换为当前语言。 /// 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 } }