Exemplo n.º 1
0
        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));
        }
Exemplo n.º 2
0
        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);
        }