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
}
}