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