private void ConnectMES() { if (L3Session.Opened) { pbMESStatus.Image = MainResources.button_green.ToBitmap(); } else { L3Session.ConnectionStr = Properties.Settings.Default.MESServer; L3Session.User = Properties.Settings.Default.Account; L3Session.Password = Properties.Settings.Default.Password; pbMESStatus.Image = MainResources.button_yellow.ToBitmap(); if (L3Session.Open() != 0) { // Cannot connect to AppServer pbMESStatus.Image = MainResources.button_red.ToBitmap(); } else { // Connected to AppServer pbMESStatus.Image = MainResources.button_green.ToBitmap(); } } try { AppSvrIF.Command cmdNull = new AppSvrIF.Command(); cmdNull.Type = (int)AppSvrIF.CommandType.Empty; L3Session.Execute(cmdNull); } catch { } }
private void btnTest_Click(object sender, EventArgs e) { frmLogin login = new frmLogin(); string account = "Administrator"; string pwd = ""; if (!login.Login(ref account, ref pwd, LoginFlags.loginNormal)) { return; } string connstr = string.Format("{0}:{1}", tbAddress.Text, tbPort.Text); int iRet = L3Session.Open(connstr, account, pwd); if (iRet == 0) { MessageBox.Show("连接测试成功!"); L3Session.Close(); } else { string msg = string.Format("连接测试失败!错误码:0x{0:X}", iRet); MessageBox.Show(msg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnTest_Click(object sender, EventArgs e) { //frmLogin login = new frmLogin(); string account = "Administrator"; string pwd = ""; //if (!login.Login(ref account, ref pwd, LoginFlags.loginNormal)) // return; string connstr = string.Format("{0}:{1}", tbAddress.Text, tbPort.Text); connstr = connstr.Replace("1089", "2525"); int iRet = L3Session.Open(connstr, account, pwd); if (iRet == 0) { MessageBox.Show("连接测试成功!"); L3Session.Close(); } else { string msg = string.Format("连接测试失败!错误码:0x{0:X}", iRet); if (msg.Contains("A0001400")) { msg = "服务器无效或已死机!"; } else if (msg.Contains("A0000402")) { msg = "密码错误!"; } else if (msg.Contains("A0000400")) { msg = "用户名不存在!"; } MessageBox.Show(msg, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void OnLogin(object sender, EventArgs e) { ConnectionStringSettings conn = frmConfigConnection.GetCurrentConnection(); if (conn == null) { MessageBox.Show("没有配置服务!请先配置服务的连接。"); return; } string connstr = conn.ConnectionString; connstr = connstr.Replace("1089", "2525"); frmLogin login = new frmLogin(); string account = ConfigurationManager.AppSettings["LastAccount"]; string pwd = ""; if (!login.Login(ref account, ref pwd, LoginFlags.loginNormal)) { return; } int iRet = L3Session.Open(connstr, account, pwd); //int iRet = L3Session.Open(connstr, "10910", "xgmes"); if (iRet != 0) { string msg = string.Format("连接服务{0}失败!错误代码:{1:X}", conn.Name, iRet); if (msg.Contains("A0001400")) { msg = "服务器无效或已死机!"; } else if (msg.Contains("A0000402")) { msg = "密码错误!"; } else if (msg.Contains("A0000400")) { msg = "用户名不存在!"; } MessageBox.Show(msg, "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { // timer3.Enabled = true; timer2.Enabled = true; labelUser.Text = account; // ConfigurationManager.AppSettings["LastAccount"] = account; //获取Configuration对象 Configuration config = System.Configuration.ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); config.AppSettings.Settings["LastAccount"].Value = account; config.Save(ConfigurationSaveMode.Modified); menuLogout.Enabled = true; menuChangePassWord.Enabled = true; menuLogin.Enabled = false; //校对时间 if (cmdGetServerTime.Execute() >= 0) { string strdt = Convert.ToString(cmdGetServerTime.Command.Return); if (strdt != "") { SynchronousTime(strdt); } } //L3DataAdapter.ReCheckAccessRights(); //var ubof=L3Session.GetResourceRights("menuBOF"); //if (ubof == 3) //{ // UnitMag.PublicResource.bofMenu = true; //} //var ulf = L3Session.GetResourceRights("menuLF"); //if (ulf == 3) //{ // UnitMag.PublicResource.lfMenu = true; //} //var urh = L3Session.GetResourceRights("menuRH"); //if (urh == 3) //{ // UnitMag.PublicResource.rhMenu = true; //} //var uccm = L3Session.GetResourceRights("menuCCM"); //if (uccm == 3) //{ // UnitMag.PublicResource.ccmMenu = true; //} //var S = L3Session.GetResourceRights("menuBO"); l3dbxWarning.L3DataAdapter = L3DataAdapter; l3dbxWarning.LoadData(); dsTeamID.L3DataAdapter = this.L3DataAdapter; dsShiftID.L3DataAdapter = this.L3DataAdapter; l3DataBoxTeamID.L3DataAdapter = null; l3DataBoxShiftID.L3DataAdapter = null; l3DataBoxTeamID.L3DataAdapter = this.L3DataAdapter; l3DataBoxShiftID.L3DataAdapter = this.L3DataAdapter; //登录时,记录账号、IP等信息 string version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(); string strsql = "insert into TS_USER_LOGIN(userid,ip,pcname,flag,version) values ('"; strsql += account + "','" + GetLocalIP() + "','" + GetComputerName() + "','" + existms() + "','" + version + "')"; exeSql(L3DataAdapter, strsql); if (existms() == "是") { toolStripStatusLabel4.Text = ""; } else { toolStripStatusLabel4.Text = "未安装MES监控程序,一个小时退出一次"; } //add by hyh 2012-03-30 根据邢钢要求,定时修改密码,否则不应许登陆 //try //{ // if (account.Equals("Administrator")) // return; // string strDateSpan = ConfigurationManager.AppSettings["PwdLockCycle"]; // string strCurTime = Convert.ToString(cmdGetServerTime.Command.Return); // //获取上次修改密码时间 // cmdGetUserLastUpdPwdTime.Parameters[0].ConstantValue = account; // if (pwd == "") // pwd = "null"; // cmdGetUserLastUpdPwdTime.Parameters[1].ConstantValue = pwd; // int iret = cmdGetUserLastUpdPwdTime.Execute(); // string strLastTime = Convert.ToString(cmdGetUserLastUpdPwdTime.Command.Return); // DateTime dtCur = Convert.ToDateTime(strCurTime); // DateTime dtLastTime = Convert.ToDateTime(strLastTime); // TimeSpan ts = dtCur.Subtract(dtLastTime); // double day = ts.TotalDays; // int ttt = Convert.ToInt32(day); // if (ts.TotalDays > Convert.ToDouble(strDateSpan)) // { // MessageBox.Show("密码已过期,请联系管理员,并定期在" + strDateSpan + "天内修改密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); // L3Session.Close(); // } // else if (ttt > 54) // { // MessageBox.Show("距密码过期还有" + Convert.ToInt32(60 - Convert.ToInt32(day)) + "天,请及时修改密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); // } //} //catch { return; } //end } }
private void OnLogin(object sender, EventArgs e) { ConnectionStringSettings conn = frmConfigConnection.GetCurrentConnection(); if (conn == null) { MessageBox.Show("没有配置服务!请先配置服务的连接。"); return; } string connstr = conn.ConnectionString; frmLogin login = new frmLogin(); string account = ConfigurationManager.AppSettings["LastAccount"]; string pwd = ""; if (!login.Login(ref account, ref pwd, LoginFlags.loginNormal)) return; int iRet = L3Session.Open(connstr, account, pwd); //int iRet = L3Session.Open(connstr, "10910", "xgmes"); if (iRet != 0) { string msg = string.Format("连接服务{0}失败!错误代码:{1:X}", conn.Name, iRet); MessageBox.Show(msg, "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { labelUser.Text = account; ConfigurationManager.AppSettings["LastAccount"] = account; menuLogout.Enabled = true; menuChangePassWord.Enabled = true; menuLogin.Enabled = false; //校对时间 if (cmdGetServerTime.Execute() >= 0) { string strdt = Convert.ToString(cmdGetServerTime.Command.Return); if (strdt != "") SynchronousTime(strdt); } L3DataAdapter.ReCheckAccessRights(); l3dbxWarning.L3DataAdapter = L3DataAdapter; l3dbxWarning.LoadData(); dsTeamID.L3DataAdapter = this.L3DataAdapter; dsShiftID.L3DataAdapter = this.L3DataAdapter; l3DataBoxTeamID.L3DataAdapter = null; l3DataBoxShiftID.L3DataAdapter = null; l3DataBoxTeamID.L3DataAdapter = this.L3DataAdapter; l3DataBoxShiftID.L3DataAdapter = this.L3DataAdapter; //add by hyh 2012-03-30 根据邢钢要求,定时修改密码,否则不应许登陆 //try //{ // if (account.Equals("Administrator")) // return; // string strDateSpan = ConfigurationManager.AppSettings["PwdLockCycle"]; // string strCurTime = Convert.ToString(cmdGetServerTime.Command.Return); // //获取上次修改密码时间 // cmdGetUserLastUpdPwdTime.Parameters[0].ConstantValue = account; // if (pwd == "") // pwd = "null"; // cmdGetUserLastUpdPwdTime.Parameters[1].ConstantValue = pwd; // int iret = cmdGetUserLastUpdPwdTime.Execute(); // string strLastTime = Convert.ToString(cmdGetUserLastUpdPwdTime.Command.Return); // DateTime dtCur = Convert.ToDateTime(strCurTime); // DateTime dtLastTime = Convert.ToDateTime(strLastTime); // TimeSpan ts = dtCur.Subtract(dtLastTime); // double day = ts.TotalDays; // int ttt = Convert.ToInt32(day); // if (ts.TotalDays > Convert.ToDouble(strDateSpan)) // { // MessageBox.Show("密码已过期,请联系管理员,并定期在" + strDateSpan + "天内修改密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); // L3Session.Close(); // } // else if (ttt > 54) // { // MessageBox.Show("距密码过期还有" + Convert.ToInt32(60 - Convert.ToInt32(day)) + "天,请及时修改密码!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); // } //} //catch { return; } //end } }