public virtual clsMsg getData(clsCmd cmd) { string sQuery = "select * from " + viewName; var t = _adapter.getData(sQuery); return(g.msg("", t)); }
public clsMsg getDropDownData(string sPath , clsCmd cmd) { XmlNode xNode = xDoc.SelectSingleNode("//appConfig/requestData[@type='DropDown']/dt[@name='" + sPath + "']"); if (xNode.getXmlAttributeValue("type") == "sql") { string sSQL = xNode.getXmlText("sql"); cmd.SQL = sqlbuilder.sqlUtility.joinWhereCondition(sSQL, cmd); var t = _adapter.getData(cmd); //var t = _adapter.getData(sSQL); return(g.msg("", t)); } return(g.msg("")); }