1         private static string identifier(string wmiClass, string wmiProperty, string wmiMustBeTrue)
 2         {
 3             string result = "";
 4             System.Management.ManagementClass mc = new System.Management.ManagementClass(wmiClass);
 5             System.Management.ManagementObjectCollection moc = mc.GetInstances();
 6             foreach (System.Management.ManagementObject mo in moc)
 7             {
 8                 if (mo[wmiMustBeTrue].ToString() == "True")
 9                 {
10                     if (result == "")
11                     {
12                         try
13                         {
14                             result = mo[wmiProperty].ToString();
15                             break;
16                         }
17                         catch
18                         {
19                         }
20                     }
21 
22                 }
23             }
24             return result;
25         }
26 
27 
28         private static string identifier(string wmiClass, string wmiProperty)
29         {
30             string result = "";
31             System.Management.ManagementClass mc = new System.Management.ManagementClass(wmiClass);
32             System.Management.ManagementObjectCollection moc = mc.GetInstances();
33             foreach (System.Management.ManagementObject mo in moc)
34             {
35                 if (result == "")
36                 {
37                     try
38                     {
39                         result = mo[wmiProperty].ToString();
40                         break;
41                     }
42                     catch
43                     {
44                     }
45                 }
46 
47             }
48             return result;
49         }

1         private static string cpuId()
2         {     
3             string retVal = identifier("Win32_Processor", "UniqueId");  //CPUID   
4             retVal += identifier("Win32_Processor", "ProcessorId");
5             retVal += identifier("Win32_Processor", "Name");  //处理器名称
6             retVal += identifier("Win32_Processor", "Manufacturer");  //处理器制造商
7             retVal +=identifier("Win32_Processor", "MaxClockSpeed");  //最大时钟频率
8             return retVal;
9         }

 1         //BIOS信息
 2         private static string biosId()
 3         {
 4             return identifier("Win32_BIOS", "Manufacturer")          //BIOS制造商名称
 5                     + identifier("Win32_BIOS", "SMBIOSBIOSVersion")  //
 6                     + identifier("Win32_BIOS", "IdentificationCode") //
 7                     + identifier("Win32_BIOS", "SerialNumber")       //BIOS序列号
 8                     + identifier("Win32_BIOS", "ReleaseDate")        //出厂日期
 9                     + identifier("Win32_BIOS", "Version");           //版本号
10         }

1         private static string diskId()
2         {
3             return identifier("Win32_DiskDrive", "Model")           //模式
4                     + identifier("Win32_DiskDrive", "Manufacturer") //制造商
5                     + identifier("Win32_DiskDrive", "Signature")    //签名
6                     + identifier("Win32_DiskDrive", "TotalHeads");  //扇区头
7         }

1         private static string baseId()
2         {
3             return identifier("Win32_BaseBoard", "Model")              
4                     + identifier("Win32_BaseBoard", "Manufacturer")    
5                     + identifier("Win32_BaseBoard", "Name")
6                     + identifier("Win32_BaseBoard", "SerialNumber");
7         }

1         private static string videoId()
2         {
3             return identifier("Win32_VideoController", "DriverVersion")
4                     + identifier("Win32_VideoController", "Name");
5         }

1         private static string macId()
2         {
3             return identifier("Win32_NetworkAdapterConfiguration", "MACAddress", "IPEnabled"); 
4         }

 1 SELECT    
 2 (case when a.colorder=1 then d.name else '' end) as 表名,--如果表名相同就返回空   syscolumns(表字段信息表) a  sysobjects d 
 3      a.colorder as 字段序号,   
 4      a.name as 字段名,   
 5      (case when COLUMNPROPERTY( a.id,a.name, 'IsIdentity' )=1 then '√' else '' end) as 标识,   --返回IsIdentity的值，IsIdentity只有两个值：0、1
 6      (case when (SELECT count(*) FROM sysobjects--查询主键   
 7                      WHERE (name in    
 8                              (SELECT name FROM sysindexes    
 9                              WHERE (id = a.id)   AND (indid in    
10                                      (SELECT indid FROM sysindexkeys   
11                                        WHERE (id = a.id) AND (colid in    
12                                          (SELECT colid FROM syscolumns   
13                                          WHERE (id = a.id) AND (name = a.name))   
14                          )))))    
15          AND (xtype = 'PK' ))>0 then '√' else '' end) as 主键,--查询主键END   
16 b.name as 类型,   --systypes b 
17 a.length as 占用字节数,   
18 COLUMNPROPERTY(a.id,a.name,'PRECISION' ) as    长度,   
19 isnull(COLUMNPROPERTY(a.id,a.name,'Scale' ),0) as 小数位数,   
20 (case when a.isnullable=1 then '√' else '' end) as 允许空,   
21 isnull(e.text,'' ) as 默认值,   --syscomments e 
22 isnull(g.[value],'' ) AS 字段说明    --sys.extended_properties g (字段信息表)
23 FROM syscolumns a left join systypes b    
24 on a.xtype=b.xusertype   
25 inner join sysobjects d    
26 on a.id=d.id and d.xtype='U' and d.name<> 'dtproperties'    
27 left join syscomments e   
28 on a.cdefault=e.id   
29 left join sys.extended_properties g   
30 on a.id=g.major_id AND a.colid = g.minor_id    
31      where d.name='systempara' --所要查询的表   
32 order by a.id,a.colorder