private void QueryUserList()
{
string strWhereCondition = GetWhereSqlString();
string strSql = @" SELECT UOL.*, ALT.DISPLAYNAME AS APP_DISPLAYNAME, AOT.DISPLAYNAME AS OP_DISPLAYNAME
FROM USER_OPEATION_LOG UOL, APP_LOG_TYPE ALT, APP_OPERATION_TYPE AOT
WHERE AOT.GUID = UOL.OP_GUID
AND ALT.GUID = UOL.APP_GUID
AND AOT.APP_GUID = ALT.GUID " + strWhereCondition + @"
ORDER BY ID DESC " ;
int iStart = Convert.ToInt32(_RootElement.GetAttribute("lastKey"));
int iLength = Convert.ToInt32(_RootElement.GetAttribute("rows"));
using (DbContext context = DbContext.GetContext(LogResource.ConnAlias))
{
Database database = DatabaseFactory.Create(context);
_XmlResult = InnerCommon.GetXmlDoc(database.ExecuteDataSet(CommandType.Text, strSql, iStart, iLength, "USER_OPEATION_LOG"));
string strCount = @" SELECT COUNT(UOL.ID)
FROM USER_OPEATION_LOG UOL
WHERE 1=1 " + strWhereCondition;
XmlHelper.AppendNode <string>(_XmlResult.DocumentElement, "NUMBER", database.ExecuteScalar(CommandType.Text, strCount).ToString());
}
}
public void DeleteAppType()
{
XmlElement root = _XmlRequest.DocumentElement;
string strSort = root.GetAttribute("orgSort");
string strSql = string.Empty;
string strTableName = string.Empty;
string strObjName = string.Empty;
string strLogType = string.Empty;
if (strSort.Length == 8)
{
strTableName = "APP_LOG_TYPE";
strObjName = "应用类型";
strLogType = "DEL_APP_TYPE";
}
else if (strSort.Length == 12)
{
strTableName = "APP_OPERATION_TYPE";
strObjName = "应用操作类型";
strLogType = "DEL_OP_TYPE";
}
strSql = "UPDATE " + strTableName + " SET VISIBLE = 'n' WHERE GUID = "
+ TSqlBuilder.Instance.CheckQuotationMark(root.GetAttribute("Guid"), true);
InnerCommon.ExecuteNonQuery(strSql);
UserDataWrite.InsertUserLog("APP_LOG", strLogType, "从日志审计系统中删除" + strObjName + ":" + root.GetAttribute("DisplayName"),
_XmlRequest.DocumentElement.InnerXml, true);
}
/// <summary>
///
/// </summary>
/// <param name="appTypeGuid"></param>
/// <returns></returns>
// private static string GetClassByGuid(string appTypeGuid)
// {
// string strClass = string.Empty;
// string strSql = "SELECT LEFT(CLASS, 8) FROM APP_OPERATION_TYPE WHERE APP_GUID = " + TSqlBuilder.Instance.CheckQuotationMark(appTypeGuid);
//
// DataAccess da = new DataAccess(HGLogDefine.C_CONN_STRING);
//
// using (da.dBContextInfo)
// {
// da.dBContextInfo.OpenConnection();
//
// object obj = da.SqlDBHelper.ExecuteScalar(da.dBContextInfo.Context, CommandType.Text, strSql);
//
// if(false==(obj is DBNull))
// strClass = (string)obj;
// }
//
// return strClass;
// }
/// <summary>
///
/// </summary>
/// <returns></returns>
public static string GetClassForApp()
{
string strSql = "SELECT ISNULL(MAX(CLASS + 1), 1) FROM APP_LOG_TYPE WHERE LEN(CLASS) = 8";
string strTemp = "00000000" + InnerCommon.ExecuteScalar(strSql).ToString();
return(strTemp.Substring(strTemp.Length - 8, 8));
}
/// <summary>
///
/// </summary>
/// <param name="appTypeGuid"></param>
/// <param name="strSort"></param>
/// <returns></returns>
public static string GetNewClassValue(string appTypeGuid, string strSort)
{
string strSql = "SELECT ISNULL(MAX(CLASS + 1), 1) FROM APP_OPERATION_TYPE WHERE APP_GUID = "
+ TSqlBuilder.Instance.CheckQuotationMark(appTypeGuid, true);
string strTemp = "0000" + InnerCommon.ExecuteScalar(strSql).ToString();
return(strSort + strTemp.Substring(strTemp.Length - 4, 4));
}
private void GetOpSelectList()
{
XmlElement root = _XmlRequest.DocumentElement;
string strDisplayname = root.GetAttribute("appDisplayname");
string strSql = @"SELECT AOT.DISPLAYNAME
FROM APP_LOG_TYPE ALT, APP_OPERATION_TYPE AOT
WHERE AOT.APP_GUID = ALT.GUID
AND AOT.VISIBLE = 'y'
AND ALT.DISPLAYNAME = " + TSqlBuilder.Instance.CheckQuotationMark(strDisplayname, true);
_XmlResult = InnerCommon.GetXmlDoc(InnerCommon.ExecuteDataset(strSql));
}
private void InsertAppType()
{
XmlNode xNode = _XmlRequest.DocumentElement.SelectSingleNode(".//SET");
XmlNode root = null;
string insertSql = string.Empty;
string strSql = string.Empty;
if (_XmlRequest.DocumentElement.SelectSingleNode("APP_OPERATION_TYPE") != null)
{
root = _XmlRequest.DocumentElement.SelectSingleNode("APP_OPERATION_TYPE");
insertSql = "INSERT APP_OPERATION_TYPE ";
string appGuid = ((XmlElement)root).GetAttribute("appGuid");
string strOrgSort = ((XmlElement)root).GetAttribute("strSort");
string typeGuid = Guid.NewGuid().ToString();
InsertSqlClauseBuilder ic = new InsertSqlClauseBuilder();
ic.AppendItem <string>("GUID", typeGuid);
ic.AppendItem <string>("APP_GUID", appGuid);
ic.AppendItem <string>("DISPLAYNAME", xNode.SelectSingleNode("DISPLAYNAME").InnerText);
ic.AppendItem <string>("CODE_NAME", xNode.SelectSingleNode("CODE_NAME").InnerText);
ic.AppendItem <string>("DISCRIPTION", xNode.SelectSingleNode("DESCRIPTION").InnerText);
ic.AppendItem <string>("VISIBLE", "y");
ic.AppendItem <string>("CLASS", LogReader.GetNewClassValue(appGuid, strOrgSort));
strSql = insertSql + ic.ToSqlString(TSqlBuilder.Instance);
UserDataWrite.InsertUserLog("APP_LOG", "", "", "", "ADD_OP_TYPE", "向日志审计系统添加新的操作类型:"
+ xNode.SelectSingleNode("DISPLAYNAME").InnerText, _XmlRequest.DocumentElement.InnerXml, true);
}
else
{
root = _XmlRequest.DocumentElement.SelectSingleNode("APP_LOG_TYPE");
insertSql = "INSERT APP_LOG_TYPE ";
string appGuid = Guid.NewGuid().ToString();
InsertSqlClauseBuilder ic = new InsertSqlClauseBuilder();
ic.AppendItem <string>("GUID", appGuid);
ic.AppendItem <string>("CODE_NAME", xNode.SelectSingleNode("CODE_NAME").InnerText);
ic.AppendItem <string>("DISPLAYNAME", xNode.SelectSingleNode("DISPLAYNAME").InnerText);
ic.AppendItem <string>("VISIBLE", "y");
ic.AppendItem <string>("DISCRIPTION", xNode.SelectSingleNode("DESCRIPTION").InnerText);
ic.AppendItem <string>("CLASS", LogReader.GetClassForApp());
strSql = insertSql + ic.ToSqlString(TSqlBuilder.Instance);
UserDataWrite.InsertUserLog("APP_LOG", "ADD_APP_TYPE", "向日志审计系统添加新的应用:"
+ xNode.SelectSingleNode("DISPLAYNAME").InnerText, _XmlRequest.DocumentElement.InnerXml, true);
}
InnerCommon.ExecuteNonQuery(strSql);
}
/// <summary>
///
/// </summary>
/// <param name="displayName"></param>
/// <param name="strTableName"></param>
/// <returns></returns>
public static string GetGuidByDisplayName(string displayName, string strTableName)
{
string strGuid = string.Empty;
string strSql = "SELECT GUID FROM " + strTableName + " WHERE DISPLAYNAME = "
+ TSqlBuilder.Instance.CheckQuotationMark(displayName, true);
object obj = InnerCommon.ExecuteScalar(strSql);
if (false == (obj is DBNull))
{
strGuid = (string)obj;
}
return(strGuid);
}
public void GetTreeDataList()
{
XmlElement root = _XmlRequest.DocumentElement;
string strLot = root.GetAttribute("listObjectType"); //要求查询的对象类型
string strGuid = root.GetAttribute("appTypeGuid");
string strSql = string.Empty;
if (strGuid != string.Empty)
{
strSql = "SELECT GUID, 'OPTYPE' AS NODE_NAME, CODE_NAME, DISPLAYNAME, APP_GUID, VISIBLE, DISCRIPTION, CLASS FROM APP_OPERATION_TYPE WHERE APP_GUID = '" + strGuid + "' AND VISIBLE = 'y' ORDER BY CLASS";
}
else
{
strSql = "SELECT GUID, 'APPNAME' AS NODE_NAME, CODE_NAME, DISPLAYNAME, VISIBLE, DISCRIPTION, CLASS FROM APP_LOG_TYPE WHERE VISIBLE = 'y' ORDER BY CLASS, CODE_NAME";
}
DataSet ds = InnerCommon.ExecuteDataset(strSql);
_XmlResult = LogReader.GetLevelSortXmlDocAttr(ds.Tables[0], "CLASS", "NODE_NAME", LogReader.LOG_ORIGINAL_SORT.Length);
}
public void UpdateAppType()
{
XmlElement root = _XmlRequest.DocumentElement;
string strTableName = root.FirstChild.Name;
string strGuid = root.SelectSingleNode(".//GUID").InnerText;
string strCodeName = root.SelectSingleNode(".//CODE_NAME").InnerText;
string strDisplayname = root.SelectSingleNode(".//DISPLAYNAME").InnerText;
string strDescription = root.SelectSingleNode(".//DESCRIPTION").InnerText;
string strSql = "UPDATE " + strTableName
+ " SET CODE_NAME = " + TSqlBuilder.Instance.CheckQuotationMark(strCodeName, true)
+ ", DISPLAYNAME = " + TSqlBuilder.Instance.CheckQuotationMark(strDisplayname, true)
+ ", DISCRIPTION = " + TSqlBuilder.Instance.CheckQuotationMark(strDescription, true)
+ " WHERE GUID = '" + strGuid + "'";
InnerCommon.ExecuteNonQuery(strSql);
UserDataWrite.InsertUserLog("APP_LOG", strTableName == "APP_LOG_TYPE" ? "MODIFY_APP_TYPE" : "MODIFY_OP_TYPE",
"从日志审计系统中修改" + (strTableName == "APP_LOG_TYPE" ? "应用" : "操作类型") + "[" + strDisplayname + "]", _XmlRequest.DocumentElement.InnerXml, true);
}
private void QuerySysList()
{
string strWhereCondition = GetWhereSqlString();
string strSql = @" SELECT USER_LOGONNAME, HOST_IP, LOG_DATE, ID, IE_VERSION, WINDOWS_VERSION, KILL_VIRUS, STATUS, HOST_NAME, USER_DISTINCTNAME
FROM SYS_USER_LOGON
WHERE 1=1 " + strWhereCondition + @"
ORDER BY ID DESC " ;
int iStart = Convert.ToInt32(_RootElement.GetAttribute("lastKey"));
int iLength = Convert.ToInt32(_RootElement.GetAttribute("rows"));
using (DbContext context = DbContext.GetContext(LogResource.ConnAlias))
{
Database database = DatabaseFactory.Create(context);
_XmlResult = InnerCommon.GetXmlDoc(database.ExecuteDataSet(CommandType.Text, strSql, iStart, iLength, "SYS_USER_LOGON"));
string strCount = @" SELECT COUNT(ID)
FROM SYS_USER_LOGON
WHERE 1=1 " + strWhereCondition;
XmlHelper.AppendNode <string>(_XmlResult.DocumentElement, "NUMBER", database.ExecuteScalar(CommandType.Text, strCount).ToString());
}
}
