public int InsertSystemLogTable(EntitySystemLog entity)
{
string SqlStr = "";
SqlStr = "insert into tc_system_log";
SqlStr += " values('" + entity.DateLogOn + "','" + entity.DateLogOff + "','" + entity.UserName.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
//***********************************************************************
/// <summary>
/// 关闭按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：赵毅男 2010/09/20 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void MainForm_FormClosed(object sender, FormClosedEventArgs e)
{
//取得日志实体
EntitySystemLog systemLogEntity = new EntitySystemLog();
systemLogEntity.DateLogOn = LoginUser.LogOnTime;
systemLogEntity.DateLogOff = DateTime.Now;
systemLogEntity.UserName = LoginUser.UserName;
try
{
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//调用数据操作类
GetData getData = new GetData(dataAccess.Connection);
int result = getData.InsertSystemLogTable(systemLogEntity);
//如果失败
if (result == -1)
{
MessageBox.Show("添加系统日志失败，请查看数据库连接是否正常！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAccess.Close();
}
//退出系统
Application.Exit();
}
