xml

<?xml version="1.0" encoding="utf-8" ?>
<system>
  <struct>
    <db>
      <object name="clientinfo" type="table" label="客户信息表">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="name" type="varchar(50)" label="客户名称" ></item>
        <item name="address" type="varchar(100)" label="客户地址" ></item>
        <item name="contactperson" type="varchar(50)" label="联系人" ></item>
        <item name="phone" type="varchar(50)" label="联系电话" ></item>
        <item name="desc" type="varchar(200)" label="备注" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
        <item name="delete" type="bit" label="删除标志" ></item>
      </object>
      <object name="staff" type="table" label="员工">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="name" type="varchar(50)" label="名称" ></item>
        <item name="idcard" type="varchar(20)" label="身份证" ></item>
        <item name="type" type="int" label="员工类型" ref="stafftype" ></item>
        <item name="cometime" type="datetime" label="入职时间" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
        <item name="delete" type="bit" label="删除标志" ></item>
      </object>
      <object name="stafftype" type="table" label="员工类型">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="desc" type="varchar(50)" label="描述" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
      </object>
      <object name="gasjar" type="table" label="钢瓶信息">
        <item name="f_rowid" type="identity int" label="id" ref="gasjartype" ></item>
        <item name="Number" type="varchar(50)" label="编号" ></item>
        <item name="type" type="int" label="类型" ref="gasjartype" ></item>
        <item name="leavefactorytime" type="datetime" label="出厂日期" ></item>
        <item name="lastchecktime" type="datetime" label="最近一次检查日期" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
        <item name="delete" type="bit" label="删除标志" ></item>
      </object>
      <object name="gasjartype" type="table" label="钢瓶类型">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="desc" type="varchar(50)" label="类型" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
      </object>
      <object name="order" type="table" label="订单">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="clientid" type="int" label="客户编号" ref="clientinfo" ></item>
        <item name="ordertime" type="datetime" label="订单日期" ></item>
        <item name="order" type="int" label="销售员" ></item>
        <item name="sum" type="int" label="订单实际金额" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
        <item name="delete" type="bit" label="删除标志" ></item>
      </object>
      <object name="trade" type="table" label="交易流水">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="orderId" type="int" label="订单编号" ></item>
        <item name="productid" type="int" label="商品" ></item>
        <item name="count" type="int" label="数量" ></item>
        <item name="price" type="float" label="零售价格" ></item>
        <item name="actureprice" type="float" label="成交价格" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
      </object>
      <object name="savecheckhistory" type="table" label="安全检测历史">
        <item name="f_rowid" type="identity int" label="id" ></item>
        <item name="clientid" type="int" label="客户号" ></item>
        <item name="checkcontent" type="varchar(50)" label="检查内容" ></item>
        <item name="checktime" type="datetime" label="检查日期" ></item>
        <item name="checkperson" type="int" label="检查人" ></item>
        <item name="addtime" type="datetime" label="新增时间" ></item>
      </object>
      <object name="xxxx" type="relation" label="关系" relation="1:n" >
        <item name="xxx1" type="identity int" label="id" ></item>
        <item name="xxx3" type="int" label="表1" refT="xxxx" refF="xxx1" ></item>
        <item name="xxx3" type="int" label="表2" refT="xxxx2" refF="xxx1" ></item>
      </object>
    </db>
  </struct>
  <sqls>
    <sql>
     
    </sql>
  </sqls>
  <modules>
    <module name="客户查询">
      <list sqlid="">
        <searchitems>
          <searchitem name="" label=""></searchitem>
          <searchitem name="" label=""></searchitem>
        </searchitems>
        <listitems>
          <listitem name="" label="" type="label"></listitem>
          <listitem name="" label="" type="textbox"></listitem>
          <listitem name="" label="" type="singleselect"></listitem>
          <listitem name="" label="" type="mutiselect"></listitem>
          <listitem name="" label="" type="date"></listitem>
          <listitem name="" label="" type="datetime"></listitem>
        </listitems>
      </list>
    </module>
  </modules>
</system>