基于工作实际需求的Ext.Net和C#搭配应用之一 取出网域(AD)中所有计算机名及位置描述等信息

应用技术：DirectoryServices、DataTable、Ext.Net（数据和相关控件、事件与后台C#交互）、数据库操作、LDAP

需求背景：公司应用了Windows2008的域（从2003升级），所有的电脑都加入了网域，但是维护人员常更换，有时也没有认真填写电脑在网域中的描述信息，有的人员离职了或更换工作地点、部门、电脑也可能更换了，但是都没有更新（好像是咱公司网管工作不到位）。现在由于特别的需要，要得到当前网域中在中国区的所有电脑名，包括描述、LDAP地址、所在的OU等信息。

需求内容：给出一个OU的LDAP地址，取出其所有的（包括子OU和组）电脑信息，在WEB中可以实时查询，以EXT做前台显示。可以通过前台实现更新CN下的所有电脑信息到数据库表中，以便信息应用。

实际图片：

前台实时查询

保存到数据库的信息

设计：用一个类实现取指定LDAP地址下的所有电脑名及信息；用一个页面做实时查询，EXT做前台显示；用一个地址实现数据更新到数据库指定的表中。

实现过程：

建立一个类用于存储电脑信息（电脑名、描述、操作系统的名称和版本、登录的时间、加入网域的时间和更改的时间），PC.CS内容如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Core.DarrenAdHelper
{
    /// <summary>
    /// 描述：
    /// 程序員：谢堂文(Darren Xie)
    /// 創建日期：
    /// 版本：1.0
    /// </summary>
    public class PC
    {
        string cn;
        /// <summary>
        /// 电脑名
        /// </summary>
        public string Cn
        {
            get { return cn; }
            set { cn = value; }
        }
        string description;
        /// <summary>
        /// 描述信息
        /// </summary>
        public string Description
        {
            get { return description; }
            set { description = value; }
        }
        string whenCreated;
        /// <summary>
        /// 加入网域的时间
        /// </summary>
        public string WhenCreated
        {
            get { return whenCreated; }
            set { whenCreated = value; }
        }
        string whenChanged;
        /// <summary>
        /// 最后更改时间
        /// </summary>
        public string WhenChanged
        {
            get { return whenChanged; }
            set { whenChanged = value; }
        }
        string lastLogoff;
        /// <summary>
        /// 最后注消时间
        /// </summary>
        public string LastLogoff
        {
            get { return lastLogoff; }
            set { lastLogoff = value; }
        }
        string lastLogon;
        /// <summary>
        /// 最后登录时间
        /// </summary>
        public string LastLogon
        {
            get { return lastLogon; }
            set { lastLogon = value; }
        }
        string operatingSystem;
        /// <summary>
        /// 操作系统名称
        /// </summary>
        public string OperatingSystem
        {
            get { return operatingSystem; }
            set { operatingSystem = value; }
        }
        string operatingSystemVersion;
        /// <summary>
        /// 操作系统版本
        /// </summary>
        public string OperatingSystemVersion
        {
            get { return operatingSystemVersion; }
            set { operatingSystemVersion = value; }
        }
        string operatingSystemServicePack;
        /// <summary>
        /// 操作系统补丁
        /// </summary>
        public string OperatingSystemServicePack
        {
            get { return operatingSystemServicePack; }
            set { operatingSystemServicePack = value; }
        }
        string distinguishedName;
        /// <summary>
        /// LDAP地址
        /// </summary>
        public string DistinguishedName
        {
            get { return distinguishedName; }
            set { distinguishedName = value; }
        }
    }
}

扫描AD信息取计算机名的类的关键代码如下：

        #region 取出AD中的电脑名
        public DataTable GetPCInfoTab()
        {
            return GetPCInfoTab(this.ADPath);
        }
        public DataTable GetPCInfoTab(string path)
        {
            return GetPCInfoTab(GetPC(path));
        }
        public DataTable GetPCInfoTab(List<Core.DarrenAdHelper.PC> l)
        {
            DataTable dt = new DataTable("pc");
            dt.Columns.Add("cn");
            dt.Columns.Add("Description");
            dt.Columns.Add("OperatingSystem");
            dt.Columns.Add("OperatingSystemVersion");
            dt.Columns.Add("OperatingSystemServicePack");
            dt.Columns.Add("WhenCreated");
            dt.Columns.Add("WhenChanged");
            dt.Columns.Add("LastLogon");
            dt.Columns.Add("LastLogoff");
            dt.Columns.Add("DistinguishedName");
            foreach (Core.DarrenAdHelper.PC pc in l)
            {
                DataRow dr = dt.NewRow();
                dr["cn"] = pc.Cn;
                dr["Description"] = pc.Description;
                dr["OperatingSystem"] = pc.OperatingSystem;
                dr["OperatingSystemVersion"] = pc.OperatingSystemVersion;
                dr["OperatingSystemServicePack"] = pc.OperatingSystemServicePack;
                dr["WhenCreated"] = pc.WhenCreated;
                dr["WhenChanged"] = pc.WhenChanged;
                dr["LastLogon"] = pc.LastLogon;
                dr["LastLogoff"] = pc.LastLogoff;
                dr["DistinguishedName"] = pc.DistinguishedName;
                dt.Rows.Add(dr);
            }
            return dt;
        }
        public List<Core.DarrenAdHelper.PC> GetPC()
        {
            return GetPC(this.ADPath);
        }
        public List<Core.DarrenAdHelper.PC> GetPC(string path)
        {
            using (DirectoryEntry de = new DirectoryEntry())
            {

                de.Path = path;
                List<Core.DarrenAdHelper.PC> l = new List<Core.DarrenAdHelper.PC>();

                List<string> o = new List<string>();
                foreach (DirectoryEntry obj in de.Children)
                {
                    if (obj.SchemaClassName == "computer" && obj.Name.Length >= 3)
                    {
                        Core.DarrenAdHelper.PC pc = new Core.DarrenAdHelper.PC();
                        pc.Cn = obj.Properties.Contains("cn") == true ? obj.Properties["cn"].Value.ToString() : "-";
                        pc.Description = obj.Properties.Contains("description") == true ? obj.Properties["description"].Value.ToString() : "-";
                        pc.WhenCreated = obj.Properties.Contains("whenCreated") == true ? obj.Properties["whenCreated"].Value.ToString() : "-";
                        pc.WhenChanged = obj.Properties.Contains("whenChanged") == true ? obj.Properties["whenChanged"].Value.ToString() : "-";
                        pc.LastLogoff = obj.Properties.Contains("lastLogoff") == true ? obj.Properties["lastLogoff"].Value.ToString() : "-";
                        pc.LastLogon = obj.Properties.Contains("lastLogon") == true ? obj.Properties["lastLogon"].Value.ToString() : "-";
                        pc.OperatingSystem = obj.Properties.Contains("operatingSystem") == true ? obj.Properties["operatingSystem"].Value.ToString() : "-";
                        pc.OperatingSystemVersion = obj.Properties.Contains("operatingSystemVersion") == true ? obj.Properties["operatingSystemVersion"].Value.ToString() : "-";
                        pc.OperatingSystemServicePack = obj.Properties.Contains("operatingSystemServicePack") == true ? obj.Properties["operatingSystemServicePack"].Value.ToString() : "-";
                        pc.DistinguishedName = obj.Properties.Contains("distinguishedName") == true ? obj.Properties["distinguishedName"].Value.ToString() : "-";
                        l.Add(pc);
                    }
                    else if (obj.SchemaClassName == "organizationalUnit")
                    {
                        o.Add(obj.Path);

                    }

                }
                foreach (string stroupath in o)
                {
                    foreach (Core.DarrenAdHelper.PC pc1 in GetPC(stroupath))
                    {
                        l.Add(pc1);
                    }
                }
                return l;
            }
        }

        #endregion

页面前台代码：

ADPCInfo.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ADPCInfo.aspx.cs" Inherits="ADPCInfo" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Xml.Xsl" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Linq" %>
<%@ Import Namespace="Ext" %>
<%@ Import Namespace="Core.DarrenCoreLib.DB" %>
<%@ Import Namespace="Core.DarrenEncodeOrDecode" %>
<%@ Import Namespace="Core.DarrenAdHelper" %>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Import Namespace="System.DirectoryServices" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<script runat="server">
    private void GetInfo(object sender, DirectEventArgs e)
    {
        try
        {
            this.Store1.DataSource = this.GetDataTable();
            this.Store1.DataBind();
        }
        catch (Exception ee)
        {

            this.Store1.DataSource =  GetDataTableByErr(ee.Message);
            this.Store1.DataBind();
        }
    }
    public DataTable GetPCInfoTab(string path)
    {
        return GetPCInfoTab(GetPC(path));
    }
    public DataTable GetPCInfoTab(List<Core.DarrenAdHelper.PC> l)
    {
        DataTable dt = new DataTable("pc");
        dt.Columns.Add("cn");
        dt.Columns.Add("Description");
        dt.Columns.Add("OperatingSystem");
        dt.Columns.Add("OperatingSystemVersion");
        dt.Columns.Add("OperatingSystemServicePack");
        dt.Columns.Add("WhenCreated");
        dt.Columns.Add("WhenChanged");
        dt.Columns.Add("LastLogon");
        dt.Columns.Add("LastLogoff");
        dt.Columns.Add("DistinguishedName");
        dt.Columns.Add("spath");
        foreach (Core.DarrenAdHelper.PC pc in l)
        {
            DataRow dr = dt.NewRow();
            dr["cn"] = pc.Cn;
            dr["Description"] = pc.Description;
            dr["OperatingSystem"] = pc.OperatingSystem;
            dr["OperatingSystemVersion"] = pc.OperatingSystemVersion;
            dr["OperatingSystemServicePack"] = pc.OperatingSystemServicePack;
            dr["WhenCreated"] = pc.WhenCreated;
            dr["WhenChanged"] = pc.WhenChanged;
            dr["LastLogon"] = pc.LastLogon;
            dr["LastLogoff"] = pc.LastLogoff;
            dr["DistinguishedName"] = pc.DistinguishedName;
            string[] strpath = pc.DistinguishedName.Replace(",", "").Split(new string[] { "OU=", "DC=", "CN=" }, StringSplitOptions.RemoveEmptyEntries);
            string spath = string.Empty;
            for (int i = strpath.Length - 3; i >= 1; i--)
            {
                spath += strpath[i] + @"\";
            }
            dr["spath"] = spath;
            dt.Rows.Add(dr);
        }
        return dt;
    }
    public List<Core.DarrenAdHelper.PC> GetPC(string path)
    {
        using (DirectoryEntry de = new DirectoryEntry())
        {

            de.Path = path;
            System.Collections.Generic.List<Core.DarrenAdHelper.PC> l = new List<Core.DarrenAdHelper.PC>();

            List<string> o = new List<string>();
            foreach (DirectoryEntry obj in de.Children)
            {
                if (obj.SchemaClassName == "computer" && obj.Name.Length >= 3)
                {
                    Core.DarrenAdHelper.PC pc = new Core.DarrenAdHelper.PC();
                    pc.Cn = obj.Properties.Contains("cn") == true ? obj.Properties["cn"].Value.ToString() : "-";
                    pc.Description = obj.Properties.Contains("description") == true ? obj.Properties["description"].Value.ToString() : "-";
                    pc.WhenCreated = obj.Properties.Contains("whenCreated") == true ? obj.Properties["whenCreated"].Value.ToString() : "-";
                    pc.WhenChanged = obj.Properties.Contains("whenChanged") == true ? obj.Properties["whenChanged"].Value.ToString() : "-";
                    pc.LastLogoff = obj.Properties.Contains("lastLogoff") == true ? obj.Properties["lastLogoff"].Value.ToString() : "-";
                    pc.LastLogon = obj.Properties.Contains("lastLogon") == true ? obj.Properties["lastLogon"].Value.ToString() : "-";
                    pc.OperatingSystem = obj.Properties.Contains("operatingSystem") == true ? obj.Properties["operatingSystem"].Value.ToString() : "-";
                    pc.OperatingSystemVersion = obj.Properties.Contains("operatingSystemVersion") == true ? obj.Properties["operatingSystemVersion"].Value.ToString() : "-";
                    pc.OperatingSystemServicePack = obj.Properties.Contains("operatingSystemServicePack") == true ? obj.Properties["operatingSystemServicePack"].Value.ToString() : "-";
                    pc.DistinguishedName = obj.Properties.Contains("distinguishedName") == true ? obj.Properties["distinguishedName"].Value.ToString() : "-";
                    l.Add(pc);
                }
                else if (obj.SchemaClassName == "organizationalUnit")
                {
                    o.Add(obj.Path);

                }

            }
            foreach (string stroupath in o)
            {
                foreach (Core.DarrenAdHelper.PC pc1 in GetPC(stroupath))
                {
                    l.Add(pc1);
                }
            }
            return l;
        }
    }
    private System.Data.DataTable GetDataTable()
    {
        try
        {
            System.Collections.Generic.List<Core.DarrenAdHelper.PC> l = GetPC(path.Text + ",DC=cree1, DC=com");

            if(l.Count>0)
            {
                return GetPCInfoTab(l);
            }
            else
            {
                return GetDataTableByErr("沒有任何信息.");
            }
        }
        catch (Exception ee)
        {
            try
            {
                if (Session["sv"] == "")
                {
                    return GetDataTableByErr("請從菜單中選取你要檢查的對象.");
                }
                else
                {
                    return GetDataTableByErr(ee.Message);
                }
            }
            catch (Exception er)
            {
                return GetDataTableByErr(er.Message);
            }

        }
    }
    private System.Data.DataTable GetDataTableByErr(string errmsg)
    {
        try
        {
            DataTable dt = new DataTable("err");


            DataColumn dc = new DataColumn("cn");

            dc.DataType = System.Type.GetType("System.String");
            dc.DefaultValue = "ERR:"+errmsg;
            dt.Columns.Add(dc);
            DataRow dw = dt.NewRow();
            dt.Rows.Add(dw);
            return dt;
        }
        catch (Exception ee)
        {
            throw new Exception(ee.Message);
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!X.IsAjaxRequest)
        {
            try
            {
                this.Store1.DataSource = this.GetDataTable();
                this.Store1.DataBind();
            }
            catch (Exception ee)
            {
                this.Store1.DataSource = this.GetDataTableByErr(ee.Message);
                this.Store1.DataBind();
            }
        }


    }

    protected void Store1_RefreshData(object sender, StoreRefreshDataEventArgs e)
    {
        this.Store1.DataSource = this.GetDataTable();
        this.Store1.DataBind();
    }

    protected void Store1_Submit(object sender, StoreSubmitDataEventArgs e)
    {
        string format = this.FormatType.Value.ToString();

        XmlNode xml = e.Xml;

        this.Response.Clear();

        switch (format)
        {
            case "xml":
                string strXml = xml.OuterXml;
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xml");
                this.Response.AddHeader("Content-Length", strXml.Length.ToString());
                this.Response.ContentType = "application/xml";
                this.Response.Write(strXml);

                break;
            case "xls":
                this.Response.ContentType = "application/vnd.ms-excel";
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xls");
                XslCompiledTransform xtExcel = new XslCompiledTransform();
                xtExcel.Load(Server.MapPath("Excel.xsl"));
                xtExcel.Transform(xml, null, Response.OutputStream);

                break;
            case "csv":
                this.Response.ContentType = "application/octet-stream";
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.csv");
                XslCompiledTransform xtCsv = new XslCompiledTransform();
                xtCsv.Load(Server.MapPath("Csv.xsl"));
                xtCsv.Transform(xml, null, Response.OutputStream);

                break;
        }

        this.Response.End();
    }
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>AD PC Info
    </title>
    <link href="../../../../resources/css/examples.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript">
        var template = '<span style="color:{0};">{1}</span>';

        var change = function (value) {
            return String.format(template, (value > 0) ? "green" : "red", value);
        };

        var pctChange = function (value) {
            return String.format(template, (value > 0) ? "green" : "red", value + "%");
        };

        var exportData = function (format) {
            FormatType.setValue(format);
            var store = GridPanel1.store;
            store.directEventConfig.isUpload = true;

            var records = store.reader.readRecords(store.proxy.data).records,
                values = [];

            for (i = 0; i < records.length; i++) {
                var obj = {}, dataR;

                if (store.reader.meta.id) {
                    obj[store.reader.meta.id] = records[i].id;
                }

                dataR = Ext.apply(obj, records[i].data);

                if (!Ext.isEmptyObj(dataR)) {
                    values.push(dataR);
                }
            }

            store.submitData(values);

            store.directEventConfig.isUpload = false;
        };
    </script>
</head>
<body>
    <form id="Form1" runat="server">
    <ext:ResourceManager ID="ResourceManager1" runat="server" />
    <ext:Store ID="Store1" runat="server" AutoDataBind="true" remarks="" OnRefreshData="Store1_RefreshData"
        OnSubmitData="Store1_Submit">
        <Reader>
            <ext:JsonReader>
                <Fields>
                    <ext:RecordField Name="cn">
                    </ext:RecordField>
                    <ext:RecordField Name="Description">
                    </ext:RecordField>
                    <ext:RecordField Name="OperatingSystem">
                    </ext:RecordField>
                    <ext:RecordField Name="OperatingSystemVersion">
                    </ext:RecordField>
                    <ext:RecordField Name="OperatingSystemServicePack">
                    </ext:RecordField>
                    <ext:RecordField Name="WhenCreated">
                    </ext:RecordField>
                    <ext:RecordField Name="WhenChanged">
                    </ext:RecordField>
                    <ext:RecordField Name="LastLogon">
                    </ext:RecordField>
                    <ext:RecordField Name="LastLogoff">
                    </ext:RecordField>
                    <ext:RecordField Name="DistinguishedName">
                    </ext:RecordField>
                    <ext:RecordField Name="spath">
                    </ext:RecordField>
                </Fields>
            </ext:JsonReader>
        </Reader>
    </ext:Store>
    <ext:Hidden ID="FormatType" runat="server" />
    <ext:Panel ID="Panel1" runat="server" Height="470" Title="" Width="600">
        <Items>
            <ext:Toolbar ID="Toolbar2" runat="server" Width="600">
                <Items>
                    <ext:TextField ID="path" runat="server" Text="LDAP://hzrdc01/OU=Huizhou2,OU=CN"  Width="500" MinWidth="200">
                    </ext:TextField>
                    <ext:Button ID="btnAddNewQaItem" runat="server" Text="更新信息">
                        <DirectEvents>
                            <Click OnEvent="GetInfo">
                                <EventMask MinDelay="10000" Msg="正在從後台查詢數據..." ShowMask="true" />
                            </Click>
                        </DirectEvents>
                    </ext:Button>
                </Items>

            </ext:Toolbar>
            <ext:GridPanel ID="GridPanel1" runat="server" StoreID="Store1" Title="" Width="600"
                Height="430" AutoExpandColumn="cn" Icon="Mail">
                <ColumnModel ID="ColumnModel1" runat="server">
                    <Columns>
                        <ext:Column ColumnID="cn" Header="cn" Width="70" DataIndex="cn" Wrap="true">


                        </ext:Column>
                        <ext:Column ColumnID="Description" Header="Description" Width="150" Wrap="true"></ext:Column>
                        <ext:Column ColumnID="OperatingSystem" Header="OperatingSystem" Width="100" Wrap="true">
                        </ext:Column>
                        <ext:Column ColumnID="OperatingSystemVersion" Header="OperatingSystemVersion" Width="50"
                            Wrap="true">
                        </ext:Column>
                        <ext:Column ColumnID="OperatingSystemServicePack" Header="OperatingSystemServicePack"
                            Width="150" Wrap="true">
                        </ext:Column>
                        <ext:Column ColumnID="WhenCreated" Header="WhenCreated" Width="70" Wrap="true">
                        </ext:Column>
                        <ext:Column ColumnID="WhenChanged" Header="WhenChanged" Width="70" Wrap="true">
                        </ext:Column>
                        <ext:Column ColumnID="LastLogon" Header="LastLogon" Width="70" Wrap="true" Hidden="true">
                        </ext:Column>
                        <ext:Column ColumnID="LastLogoff" Header="LastLogoff" Width="70" Wrap="true" Hidden="true">
                        </ext:Column>
                        <ext:Column ColumnID="DistinguishedName" Header="DistinguishedName" Width="150" Wrap="true">
                        </ext:Column>
                       <ext:Column ColumnID="spath" Header="spath" Width="150" Wrap="true">
                        </ext:Column>
                    </Columns>
                </ColumnModel>
                <SelectionModel>
                    <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
                </SelectionModel>
                <LoadMask ShowMask="true" />
                <TopBar>
                    <ext:Toolbar ID="Toolbar1" runat="server">
                        <Items>
                            <ext:ToolbarFill ID="ToolbarFill1" runat="server" />
                            <ext:Button ID="Button1" runat="server" Text="To XML" Icon="PageCode">
                                <Listeners>
                                    <Click Handler="exportData('xml');" />
                                </Listeners>
                            </ext:Button>
                            <ext:Button ID="Button2" runat="server" Text="To Excel" Icon="PageExcel">
                                <Listeners>
                                    <Click Handler="exportData('xls');" />
                                </Listeners>
                            </ext:Button>
                            <ext:Button ID="Button3" runat="server" Text="To CSV" Icon="PageAttach">
                                <Listeners>
                                    <Click Handler="exportData('csv');" />
                                </Listeners>
                            </ext:Button>
                        </Items>
                    </ext:Toolbar>
                </TopBar>
                <BottomBar>
                    <ext:PagingToolbar ID="PagingToolbar1" runat="server" PageSize="120" StoreID="Store1" />
                </BottomBar>
            </ext:GridPanel>
            <ext:TextArea ID="TextArea1" runat="server" Width="600" Height="380">
            </ext:TextArea>
        </Items>

    </ext:Panel>
    </form>
</body>
</html>

ADPCInfo2DB.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ADPCInfo2DB.aspx.cs" Inherits="ADPCInfo2DB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

    </div>
    </form>
</body>
</html>

页面后台代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.DirectoryServices;
using System.Data;
using System.Data.SqlClient;

public partial class ADPCInfo2DB : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        System.Collections.Generic.List<Core.DarrenAdHelper.PC> l = GetPC("LDAP://cnrdc01/OU=CN " + ",DC=cree1, DC=com");

        if (l.Count > 0)
        {
            SqlConnection conn = new SqlConnection(Core.DarrenEncodeOrDecode.EncodeOrDecode.Decode(System.Configuration.ConfigurationManager.ConnectionStrings["CotwapConnectionString"].ConnectionString));
            string sql = sql = "delete PCInfo;";

                if (conn.State != ConnectionState.Open)
                    conn.Open();
                SqlTransaction st = conn.BeginTransaction();
                try
                {
                    Core.DarrenCoreLib.DB.SqlHelper.ExecuteNonQuery(st, CommandType.Text, sql);

                    foreach (Core.DarrenAdHelper.PC pc1 in l)
                    {
                        sql = sql = "INSERT INTO [PCInfo]([Cn],[Description],[OperatingSystem],[OperatingSystemVersion],[OperatingSystemServicePack],[WhenCreated],[WhenChanged],[LastLogon],[LastLogoff],[DistinguishedName],[SPath]) ";
                        string[] strpath = pc1.DistinguishedName.Replace(",", "").Split(new string[] { "OU=", "DC=", "CN=" }, StringSplitOptions.RemoveEmptyEntries);
                        string spath = string.Empty;
                        for (int i = strpath.Length - 3; i >= 1; i--)
                        {
                            spath += strpath[i] + @"\";
                        }
                        sql += " select '";
                        sql += pc1.Cn + "','" + pc1.Description + "','" + pc1.OperatingSystem + "','" + pc1.OperatingSystemVersion + "','" + pc1.OperatingSystemServicePack + "','" + pc1.WhenCreated + "','" + pc1.WhenChanged + "','";
                        sql += pc1.LastLogon + "','" + pc1.LastLogoff + "','" + pc1.DistinguishedName + "','" + spath + "' ";
                        Core.DarrenCoreLib.DB.SqlHelper.ExecuteNonQuery(st, System.Data.CommandType.Text, sql);

                    }
                    st.Commit();
                }
                catch
                {
                    st.Rollback();
                }
                finally
                {
                    if (conn.State != ConnectionState.Closed)
                        conn.Close();
                    Page.Response.Redirect("KillWindow.aspx");
                }
        }
    }
    public DataTable GetPCInfoTab(string path)
    {
        return GetPCInfoTab(GetPC(path));
    }
    public DataTable GetPCInfoTab(List<Core.DarrenAdHelper.PC> l)
    {
        DataTable dt = new DataTable("pc");
        dt.Columns.Add("cn");
        dt.Columns.Add("Description");
        dt.Columns.Add("OperatingSystem");
        dt.Columns.Add("OperatingSystemVersion");
        dt.Columns.Add("OperatingSystemServicePack");
        dt.Columns.Add("WhenCreated");
        dt.Columns.Add("WhenChanged");
        dt.Columns.Add("LastLogon");
        dt.Columns.Add("LastLogoff");
        dt.Columns.Add("DistinguishedName");
        dt.Columns.Add("spath");
        foreach (Core.DarrenAdHelper.PC pc in l)
        {
            DataRow dr = dt.NewRow();
            dr["cn"] = pc.Cn;
            dr["Description"] = pc.Description;
            dr["OperatingSystem"] = pc.OperatingSystem;
            dr["OperatingSystemVersion"] = pc.OperatingSystemVersion;
            dr["OperatingSystemServicePack"] = pc.OperatingSystemServicePack;
            dr["WhenCreated"] = pc.WhenCreated;
            dr["WhenChanged"] = pc.WhenChanged;
            dr["LastLogon"] = pc.LastLogon;
            dr["LastLogoff"] = pc.LastLogoff;
            dr["DistinguishedName"] = pc.DistinguishedName;
            string[] strpath = pc.DistinguishedName.Replace(",", "").Split(new string[] { "OU=", "DC=", "CN=" }, StringSplitOptions.RemoveEmptyEntries);
            string spath = string.Empty;
            for (int i = strpath.Length - 3; i >= 1; i--)
            {
                spath += strpath[i] + @"\";
            }
            dr["spath"] = spath;
            dt.Rows.Add(dr);
        }
        return dt;
    }
    public List<Core.DarrenAdHelper.PC> GetPC(string path)
    {
        using (DirectoryEntry de = new DirectoryEntry())
        {

            de.Path = path;
            System.Collections.Generic.List<Core.DarrenAdHelper.PC> l = new List<Core.DarrenAdHelper.PC>();

            List<string> o = new List<string>();
            foreach (DirectoryEntry obj in de.Children)
            {
                if (obj.SchemaClassName == "computer" && obj.Name.Length >= 3)
                {
                    Core.DarrenAdHelper.PC pc = new Core.DarrenAdHelper.PC();
                    pc.Cn = obj.Properties.Contains("cn") == true ? obj.Properties["cn"].Value.ToString() : "-";
                    pc.Description = obj.Properties.Contains("description") == true ? obj.Properties["description"].Value.ToString() : "-";
                    pc.WhenCreated = obj.Properties.Contains("whenCreated") == true ? obj.Properties["whenCreated"].Value.ToString() : "-";
                    pc.WhenChanged = obj.Properties.Contains("whenChanged") == true ? obj.Properties["whenChanged"].Value.ToString() : "-";
                    pc.LastLogoff = obj.Properties.Contains("lastLogoff") == true ? obj.Properties["lastLogoff"].Value.ToString() : "-";
                    pc.LastLogon = obj.Properties.Contains("lastLogon") == true ? obj.Properties["lastLogon"].Value.ToString() : "-";
                    pc.OperatingSystem = obj.Properties.Contains("operatingSystem") == true ? obj.Properties["operatingSystem"].Value.ToString() : "-";
                    pc.OperatingSystemVersion = obj.Properties.Contains("operatingSystemVersion") == true ? obj.Properties["operatingSystemVersion"].Value.ToString() : "-";
                    pc.OperatingSystemServicePack = obj.Properties.Contains("operatingSystemServicePack") == true ? obj.Properties["operatingSystemServicePack"].Value.ToString() : "-";
                    pc.DistinguishedName = obj.Properties.Contains("distinguishedName") == true ? obj.Properties["distinguishedName"].Value.ToString() : "-";
                    l.Add(pc);
                }
                else if (obj.SchemaClassName == "organizationalUnit")
                {
                    o.Add(obj.Path);

                }

            }
            foreach (string stroupath in o)
            {
                foreach (Core.DarrenAdHelper.PC pc1 in GetPC(stroupath))
                {
                    l.Add(pc1);
                }
            }
            return l;
        }
    }
    private System.Data.DataTable GetDataTable()
    {
        try
        {
            System.Collections.Generic.List<Core.DarrenAdHelper.PC> l = GetPC("LDAP://cnrdc01/OU=CN " + ",DC=cree, DC=com");

            if (l.Count > 0)
            {
                return GetPCInfoTab(l);
            }
            throw new Exception("沒有信息.");
        }
        catch (Exception ee)
        {
            throw new Exception("沒有信息.");

        }
    }
}

其中还用到了自定义的加密解密类，对于配置文件，有一些企业的内容，不好放出来，只是给个方法。如果有兴趣可以一起讨论讨论。