bin/CharXml.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?xml version="1.0" encoding="utf-8"?>
<root>
  <!--用户名称-->
  <define itemname="userName" defname="25" value="徐敏荣">
  </define>
  <!--所属公司-->
  <define itemname="corpName" defname="26" value="Xumingxsh">
  </define>
  <!--用户Email-->
  <define itemname="email" defname="27" value="Xumingxsh21@126.com">
  </define>
  <!--服务器名称-->
  <define itemname="serverName" defname="28" value="localhost">
  </define>
  <!--数据库名称-->
  <define itemname="dataBase" defname="29" value="AppBox">
  </define>
  <!--数据库用户名称-->
  <define itemname="userID" defname="30" value="sa">
  </define>
  <!--数据库用户密码-->
  <define itemname="passWord" defname="31" value="51Aspx">
  </define>
  <!--数据库用户密码-->
  <define itemname="port" defname="33" value="1433">
  </define>
  <!--数据库类型-->
  <define itemname="DBType" defname="32" value="SQLSERVER2005">
  </define>
  <!--列信息SQL语句：Oracle11g-->
  <Column-Info-Oracle><![CDATA[
      SELECT 
      c.table_name AS TableName, 
      c.column_name AS ColumnName,
      data_type AS data_type, 
      data_length as length, 
      data_scale AS decimaldigits,
      comments as Script,
      data_default as DefaultValue,
      nullable as isnullable, 
      global_stats AS IsMarking, 
     c.column_id as colid
      from cols c left join user_col_comments cc on c.table_name=cc.table_name and c.column_name = cc.column_name
      ]]></Column-Info-Oracle>
  <!--列信息SQL语句：Sql-Server2005-->
  <Column-Info-SQL-2005><![CDATA[
      SELECT 
      oj.Name AS TableName, 
      cl.Name AS ColumnName,
      tp.Name AS ColumnType, 
      tp.xtype AS ColumnTypeIndex, 
      cl.length, 
      cl.xscale AS decimaldigits,
      Script =  
	      CASE  
		      WHEN ep.[Value] IS Null THEN cl.Name 
		      ELSE ep.[Value] 
	      END,
      DefaultValue = 
	      CASE