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