//获取静态MsmqManage对象
public static MSMQserver GetMsmq()
{
if (MQ == null)
{
MSMQserver.MQ = new MSMQserver();
}
return MSMQserver.MQ;
}
protected void ExitLog()
{
string strLogType = "退出";
string strUserTable = "Sys_Operator";
string strUserIP = System.Net.Dns.Resolve(System.Net.Dns.GetHostName()).AddressList[0].ToString();
string strUserCode = StaticParameter.UserName;
string strUserDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string strRemark = "退出CS调运系统";
string strSysCode = "s2000";
string strRelationID = "1001";
StringBuilder sbsql = new StringBuilder();
sbsql.Append("insert into Sys_OperateLog (LogType,OperateTable,Operator,OperateDate,OperateIP,Remark,SysCode,RelationID)");
sbsql.Append(" values('" + strLogType + "','" + strUserTable + "','" + strUserCode + "','" + strUserDate + "','" + strUserIP + "','" + strRemark + "','" + strSysCode + "','" + strRelationID + "')");
DbHelperSQL.ExecuteSql(sbsql.ToString());
StringBuilder sbInsertsql = new StringBuilder();
sbInsertsql.Append("insert into Sys_OperateLog (LogType,OperateTable,Operator,OperateDate,OperateIP,Remark,SysCode,RelationID)");
sbInsertsql.Append(" values('" + strLogType + "','" + strUserTable + "','" + strUserCode + "','" + strUserDate + "','" + strUserIP + "','" + strRemark + "','" + strSysCode + "','" + strRelationID + "')");
//登陆日志上传到服务器
string isConnection = ini.IniReadValue("Connection", "isConnection");
MSMQserver mqServer = new MSMQserver();
if (isConnection == "0")
{
mqServer.AddMsmq(MC.ServerStation + MC.Prefix + "Sys_OperateLog" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbInsertsql.ToString());
}
else
{
MC.AddNewSqlText(MC.ServerStation + MC.Prefix + "Sys_OperateLog" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbInsertsql.ToString());
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
RWini ini = new RWini();
string ip = ini.IniReadValue("Connection", "SServer");
string strIp;
if (GetCmdPingResult(ip) == "1")
{
strIp = ini.IniReadValue("Connection", "isConnection");
if (strIp != "0")
{
ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("0"));
}
}
else
{
strIp = ini.IniReadValue("Connection", "isConnection");
if (strIp == "0")
{
//ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("1"));
//MessageBox.Show("系统与服务器断开连接，请重新登陆系统！");
MessageBox.Show("系统与服务器断开连接，请联系中心机房！");
Application.ExitThread();
Application.Exit();
}
}
MC = new MSMQClient();
if (cbxUserName.SelectedValue != null && txbPassWord.Text.Trim() != "")
{
string strUserCode = cbxUserName.SelectedValue.ToString();
string password = CommonMethod.MD5Crypt(txbPassWord.Text.Trim());
if (operbll.IsLoginInfo(strUserCode, password) > 0)
{
StaticParameter.UserCode = strUserCode;
StaticParameter.UserName = cbxUserName.Text;
string strLogType = "登录";
string strUserTable = "Sys_Operator";
string strUserIP = System.Net.Dns.Resolve(System.Net.Dns.GetHostName()).AddressList[0].ToString();
strUserCode = this.cbxUserName.SelectedValue.ToString();
string strUserDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string strRemark = "登录CS调运系统";
string strSysCode = "s2000";
string strRelationID = strUserCode;
StringBuilder sbsql = new StringBuilder();
sbsql.Append("insert into Sys_OperateLog (LogType,OperateTable,Operator,OperateDate,OperateIP,Remark,SysCode,RelationID)");
sbsql.Append(" values('" + strLogType + "','" + strUserTable + "','" + StaticParameter.UserName + "','" + strUserDate + "','" + strUserIP + "','" + strRemark + "','" + strSysCode + "','" + strRelationID + "')");
DbHelperSQL.ExecuteSql(sbsql.ToString());
//登陆日志上传到服务器
if (strIp == "0")
{
//MsmqManageServer mqServer = new MsmqManageServer();
MSMQserver mqServer = new MSMQserver();
mqServer.AddMsmq(MC.ServerStation + MC.Prefix + "Sys_OperateLog" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbsql.ToString());
}
else
{
MC.AddNewSqlText(MC.ServerStation + MC.Prefix + "Sys_OperateLog" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + sbsql.ToString());
}
if (_isFirst == "0")
{
this.Hide();
#region 登录成功之后选择系统
if (StaticParameter.UserCode != "0")
{
#region 非超级管理员登录
if (StaticParameter.FormType == "1")
{
new RMainForm(strUserCode).ShowDialog();
}
else
{
new CMainForm(strUserCode).ShowDialog();
}
#endregion
}
else
{
#region 超级管理员登录
if (StaticParameter.FormType == "2")
{
new CMainForm(strUserCode).ShowDialog();
}
if (StaticParameter.FormType == "1")
{
new RMainForm(strUserCode).ShowDialog();
}
#endregion
}
#endregion
}
else
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
MessageBox.Show("登录验证失败，请检查用户名和密码后重新输入!", "天大天科调运系统", MessageBoxButtons.OK, MessageBoxIcon.Error);
txbPassWord.Text = "";
}
}
else
{
MessageBox.Show("请检查用户名和密码后重新输入!", "天大天科调运系统", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
