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