本文来源:网站建设-网站制作|网络营销专家慧云科技-抢滩登陆2009-7-16 15:24:06
private string InSiteCSDFile;
private string DataBasename;
private string tablename;
private string UserName;
private SqlConnection conn;
private XmlDom ColDom = new XmlDom();
private XmlDomNode ColNod;
private HttpSessionState s;
public ContentEdit1( string columnName, HttpSessionState session )
{
s = session;
InSiteCSDFile = SitePath.CSDFile;//.GetInSite( "CSDFile", session );
ColDom.Load( InSiteCSDFile );
DataBasename = ColDom.RootNode.GetAttr( "dbName" );
ColNod = ColDom.GetNode( "//column[@name=‘" + columnName + "‘]" );
if( ColNod == null ) return;
tablename = columnName;// ColNod.GetAttr( "name" );
if( tablename != "" && DataBasename != "" ) {
string connStr = SitePath.DBSqlConStr( DataBasename ); //WorkPath.GetConnStr( "SiteOperate", session );
conn = new SqlConnection( connStr );
}
}
public string GetQueryList( string XPath )
{
string listNames = "";
if( ColNod == null ) return "";
XmlNodeList nodList = ColNod.GetNodes( XPath ); //.SelectNodes("properties/property[@visible=‘list‘ or @visible=‘always‘ or @visible=‘sys‘]");
if( nodList == null ) return "";
for( int i = 0; i < nodList.Count; i++ ) {
string sListCol = XmlDom.GetAttr( "name", nodList[i] );
listNames += sListCol;
if( i < nodList.Count - 1 ) {
listNames += "|";
}
}
return listNames;
}