Map工具系列-03-代码生成BySQl工具使用说明

所有cs端工具集成了一个工具面板 -打开(IE)

Map工具系列-09-文件自动对比合并工具

more...

微信小程序之明源商城系列

--------------------------------------------2016-12-4-------------------------

1,UI重做

2,添加吐槽功能

--------------------------------------------------------------------------

1.解决什么问题

我们在不用做表设计的时候，利用以前的字段去做功能的时候，一般步骤是先写好sql，在去写对应的gridxml或者editxml。本工具使你写好sql之后其他的都自动生成。

2.工具使用说明

2.1 SQL需要用sqlpromat格式下。表的名称加dbo,字段在data_dict 有定义

2.2 多表操作

sql:

SELECT  r.RoomGUID ,
                p.ProjName ,
                b.BUCode ,
                o.PayformName
        FROM    dbo.p_Room r
                INNER JOIN dbo.p_Project p ON r.ProjGUID = p.ProjGUID
                LEFT JOIN dbo.myBusinessUnit b ON b.BUGUID = p.BUGUID
                RIGHT JOIN dbo.s_Order o ON o.RoomGUID = r.RoomGUID;

View Code

编辑模式：

GridXml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
     --------------------- p_Room----------------------
         ,RoomGUID
         ,ProjName
         ,BUCode
         ,PayformName
     ,RoomGUID,ProjName,BUCode,PayformName
         <attribute name="RoomGUID" field="RoomGUID" datatype="varchar" title="房间GUID"  format="" />;
         <cell datatype="varchar" width="100" field="ProjName"   title="项目名称" orderby="ProjName" sortable="true" exportfield="ProjName" ></cell>;
         <cell datatype="varchar" width="100" field="BUCode"   title="单位代码" orderby="BUCode" sortable="true" exportfield="BUCode" ></cell>;
         <cell datatype="varchar" width="100" field="PayformName"   title="付款方式" orderby="PayformName" sortable="true" exportfield="PayformName" ></cell>;

View Code

Editxml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
     --------------------- p_Room----------------------
         ,RoomGUID
         ,ProjName
         ,BUCode
         ,PayformName
     ,RoomGUID,ProjName,BUCode,PayformName
         <item type="hidden" name="RoomGUID" field="RoomGUID"  title="房间GUID" />
         <item type="text" name="ProjName" field="ProjName" title="项目名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="400" defaultvalue="" onchange=""  /></item>
         <item type="text" name="BUCode" field="BUCode" title="单位代码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="50" defaultvalue="" onchange=""  /></item>
         <item type="text" name="PayformName" field="PayformName" title="付款方式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>

View Code

新增模式：funcid 31010101

GirdXml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
<?xml version="1.0" encoding="utf-8" ?>
    <page funcid="31010101">
        <controls>
            <control id="appGridMenu">
                <title>房间信息列表</title>
                <menu title="更多操作">
                    <menuitem id="btnDelete" actionid="03" title="删除" action="openDelWin()" display="true" />
                    <menuitem title="-" id="mHx" />
                    <menuitem id="m2" actionid="91" title="打印" action="AppGridPrint(appGrid);" />
                    <menuitem id="m3" actionid="92" title="导出" action="AppGridToExcel(appGrid);" />
                </menu>
                <shortcuts>
                    <shortcut id="btnNew" actionid="01" title="新增" action="openAddWin();" tip="新增" icon="/images/New_16_blue.gif" display="true" />
                    <!--<shortcut id="shtProcess" title="审批" icon="/cbgl/images/Examine_16_blue.gif" display="false">
                      <menuitem id="btnNewProcess" actionid="71" title="发起审批" action="doNewProcess()" display="false" />
                      <menuitem id="btnOpenProcess" actionid="72"  title="审批过程" action="doOpenProcess()"  display="false"/>

                      <menuitem id="btnTjApprove" actionid="81" title="提交审批" action="doProcessLaunch()" display="false" />
                      <menuitem id="btnTgApprove" actionid="82"  title="审批通过" action="doProcessPass()" display="false" />
                      <menuitem id="btnBhApprove" actionid="83"  title="审批驳回" action="doProcessIgnore()" display="false" />
                    </shortcut>-->
                </shortcuts>
            </control>

            <control id="appGrid">
                <datasource entity="p_Room" keyname="RoomGUID">
                <sql>
                    <![CDATA[
                            SELECT 
                                     RoomGUID,
                                     ProjName,
                                     BUCode,
                                     PayformName
                            FROM dbo.p_Room
                            WHERE (1=1) AND (2=2);
                    ]]>    

            </sql>
            <order field="RoomGUID" descending="false" />
            </datasource>
                <grid ondblclick="openModiWin();" onready="" onclick="trClick();">
                    <row>
                        <attributes>
                                     <attribute name="oid" field="RoomGUID" datatype="varchar" title="房间GUID" />
                        </attributes>
                             <cell datatype="varchar" width="100" field="ProjName"   title="项目名称" orderby="ProjName" sortable="true" exportfield="ProjName" ></cell>
                             <cell datatype="varchar" width="100" field="BUCode"   title="单位代码" orderby="BUCode" sortable="true" exportfield="BUCode" ></cell>
                             <cell datatype="varchar" width="100" field="PayformName"   title="付款方式" orderby="PayformName" sortable="true" exportfield="PayformName" ></cell>
                    </row>
                    <!--        <summary>-->
                    <!--            <cell field="Summary1" title="本页合计一" titlewidth="50" align="right" format="#,##0.00" />-->
                    <!--            <cell sumtotalfield="Summary1" title="所有数据合计一" titlewidth="50" align="right" format="#,##0.00" />-->
                    <!--        </summary>-->
                </grid>
            </control>
        </controls>
    </page>

View Code

EditXml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
<?xml version="1.0" encoding="Utf-8" ?>
<page funcid="31010101">
    <controls>
        <control id="appFormMenu">
            <menus>
                <menu id="m1" title="文件">
                    <menuitem id="mClose" title="关闭" action="window.close();" />
                </menu>
                <menu id="m2" title="帮助">
                    <menuitem id="mClose" title="帮助" action="window.document.fireEvent('onhelp');" />
                    <menuitem id="mClose" title="关于明源地产ERP" action="openAbout();" />
                </menu>
            </menus>
            <shortcuts>
                <shortcut id="btnSave" actionid="01,02" title="保存" tip="保存" action="save()" icon="/images/Save_16_blue.gif" display="true" />
                    <shortcut id="btnSaveAndClose" actionid="01,02" title="保存&amp;关闭" tip="保存&amp;关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/>
                        <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&amp;新增" tip="保存&amp;新增" action="saveAndNew();" icon="/images/SaveNew_16_blue.gif"  display="true"/>

                            <!--        <shortcut id="scSpace2" title="|" display="false" />-->
                            <!--        <shortcut actionid="71" id="btnNewProcess" title="发起审批" action="doNewProcess();" icon="/cbgl/images/tjsp_16.gif" display="false"/>-->
                            <!--        <shortcut actionid="72" id="btnOpenProcess" title="审批过程" action="doOpenProcess();" icon="/cbgl/images/ckspgc_16.gif" display="false" />-->
                            <!--        <shortcut actionid="81" id="btnTjApprove" title="提交审批" action="doProcessLaunch();" icon="/cbgl/images/tjsp_16.gif" display="false" />-->
                            <!--        <shortcut actionid="82" id="btnTgApprove" title="审批通过" action="doProcessPass();" icon="/cbgl/images/sptg_16.gif" display="false" />-->
                            <!--        <shortcut actionid="83" id="btnBhApprove" title="审批驳回" action="doProcessIgnore();" icon="/cbgl/images/spbh_16.gif" display="false" />-->
                            <!--
                            <shortcut  id="btnsDefect"  title="研判" icon="/cbgl/images/Examine_16_blue.gif"  display="true"  >
                              <menuitem  actionid="06" id="btnDefectStart" title="发起研判"    tip="发起研判" display="true"/>
                              <menuitem  actionid="06" id="btnDefectProcess" title="研判过程"   tip="研判过程" display="true"/>
                            </shortcut>-->

                            <shortcut title="|" />
                            <shortcut title="关闭" tip="关闭" action="window.close();" icon="/images/Close_16_blue.gif" />
            </shortcuts>
        </control>
        <control id="appNavBar">
            <nav>
                <navitem id="tab_main" title="基本信息" icon="/hyxt/images/Info_16_wihte.gif" onclick="event.returnValue=false" isshowonadd="true" iscreateiframe="true" display="true">
                </navitem>
                <navitem title="相关文档" icon="/cbgl/images/Document_16_wihte.gif" url="/cbgl/PUB/Tab_DocList.aspx?DocType=%u5408%u540C%u53D8%u66F4" display="false">
                    <params>
                        <param name="oid" value="appForm.oid.value" />
                        <param name="funcid" value="__funcid.value" />
                        <param name="mode" value="__mode.value" />
                    </params>
                </navitem>
            </nav>
        </control>

        <control id="appForm">
            <datasource entity="p_Room" keyname="RoomGUID">
                <sql>
                    <![CDATA[
                            SELECT 
                                     RoomGUID,
                                     ProjName,
                                     BUCode,
                                     PayformName
                            FROM dbo.p_Room
                            WHERE (1=1) AND (2=2);
                    ]]>    
                </sql>
            </datasource>
            <form showtab="true">
                <tab title="基本信息">
                    <section title="基本信息" showtitle="true" showbar="true" cols="2" titlewidth="100" secid="Sec1">
                                <item type="hidden" name="oid" field="RoomGUID" title="房间GUID" />
                                                     <item type="text" name="ProjName" field="ProjName" title="项目名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="400" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="BUCode" field="BUCode" title="单位代码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="50" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="PayformName" field="PayformName" title="付款方式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
                    </section>
                </tab>
                
            </form>
        </control>
        
    </controls>
</page>

View Code

2.3 单表的操作

sql:

SELECT  RoomGUID ,
        BUGUID ,
        ProjGUID ,
        BldGUID ,
        MainRoomGUID ,
        Unit ,
        Floor ,
        No ,
        Room ,
        RoomCode ,
        HuXing ,
        Status ,
        IsVirtualRoom ,
        BldArea ,
        TnArea ,
        BlRhDate ,
        RHBLZT ,
        YFBZ ,
        RoomMemo ,
        XPos ,
        YPos ,
        ZxBz ,
        Price ,
        TnPrice ,
        Total ,
        ZxPrice ,
        ZxTotal ,
        IsTempletRoom ,
        Locker ,
        LockTime ,
        TfDate ,
        DjArea ,
        IsAreaModify ,
        VirtualStatus ,
        RHDate ,
        JFRQ ,
        JFMemo ,
        XkRow ,
        XkCol ,
        AreaStatus ,
        West ,
        AreaChangingGUID ,
        ImportDate ,
        ChooseRoom ,
        CstName ,
        CstGUIDList ,
        ChooseRoomCstName ,
        ChooseRoomDate ,
        Jbr ,
        isAnnexe ,
        Sight ,
        RoomStru ,
        AbsolutelyFloor ,
        StatusChgGUID ,
        SaleRentable ,
        RentPrice ,
        CalcRentMode ,
        RentUnit ,
        Bz ,
        RentStatus ,
        ContinueRentStatus ,
        NextRentStatus ,
        RentName ,
        RentGUIDList ,
        RentStatusChgGUID ,
        RentLocker ,
        RentLockTime ,
        RentAmount ,
        BProductTypeCode ,
        YsBldArea ,
        YsTnArea ,
        ScBldArea ,
        ScTnArea ,
        ChooseRoomNo ,
        ImportData_SP5 ,
        FloorNo ,
        UnitNo ,
        SLControlDate ,
        IsHfLock ,
        PriceDj ,
        TnPriceDj ,
        TotalDj ,
        IsDj2AreaLock ,
        IsBzj2AreaLock ,
        IsDjTf ,
        IsBzjTf ,
        IsDjAreaModify ,
        ChooseRoomBookingGUID ,
        Roominfo ,
        dspBldArea ,
        dspTnArea ,
        dspAreaStatus ,
        iPadReserveStatus ,
        IsPreControl ,
        PreControlBy ,
        PreControlOn ,
        ProjBatchGUID ,
        ChooseRoomCstGUID ,
        BookingGUID ,
        AreaCreateOn ,
        AreaCreateBy ,
        AreaAuditOn ,
        AreaAuditBy ,
        AreaChangingOn ,
        AreaChangingBy ,
        OpeningBatchGUID ,
        Createtime4Chk
FROM    dbo.p_Room;

View Code

编辑模式：

GridXMl

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
     --------------------- p_Room----------------------
         ,RoomGUID
         ,BUGUID
         ,ProjGUID
         ,BldGUID
         ,MainRoomGUID
         ,Unit
         ,Floor
         ,No
         ,Room
         ,RoomCode
         ,HuXing
         ,Status
         ,IsVirtualRoom
         ,BldArea
         ,TnArea
         ,BlRhDate
         ,RHBLZT
         ,YFBZ
         ,RoomMemo
         ,XPos
         ,YPos
         ,ZxBz
         ,Price
         ,TnPrice
         ,Total
         ,ZxPrice
         ,ZxTotal
         ,IsTempletRoom
         ,Locker
         ,LockTime
         ,TfDate
         ,DjArea
         ,IsAreaModify
         ,VirtualStatus
         ,RHDate
         ,JFRQ
         ,JFMemo
         ,XkRow
         ,XkCol
         ,AreaStatus
         ,West
         ,AreaChangingGUID
         ,ImportDate
         ,ChooseRoom
         ,CstName
         ,CstGUIDList
         ,ChooseRoomCstName
         ,ChooseRoomDate
         ,Jbr
         ,isAnnexe
         ,Sight
         ,RoomStru
         ,AbsolutelyFloor
         ,StatusChgGUID
         ,SaleRentable
         ,RentPrice
         ,CalcRentMode
         ,RentUnit
         ,Bz
         ,RentStatus
         ,ContinueRentStatus
         ,NextRentStatus
         ,RentName
         ,RentGUIDList
         ,RentStatusChgGUID
         ,RentLocker
         ,RentLockTime
         ,RentAmount
         ,BProductTypeCode
         ,YsBldArea
         ,YsTnArea
         ,ScBldArea
         ,ScTnArea
         ,ChooseRoomNo
         ,ImportData_SP5
         ,FloorNo
         ,UnitNo
         ,SLControlDate
         ,IsHfLock
         ,PriceDj
         ,TnPriceDj
         ,TotalDj
         ,IsDj2AreaLock
         ,IsBzj2AreaLock
         ,IsDjTf
         ,IsBzjTf
         ,IsDjAreaModify
         ,ChooseRoomBookingGUID
         ,Roominfo
         ,dspBldArea
         ,dspTnArea
         ,dspAreaStatus
         ,iPadReserveStatus
         ,IsPreControl
         ,PreControlBy
         ,PreControlOn
         ,ProjBatchGUID
         ,ChooseRoomCstGUID
         ,BookingGUID
         ,AreaCreateOn
         ,AreaCreateBy
         ,AreaAuditOn
         ,AreaAuditBy
         ,AreaChangingOn
         ,AreaChangingBy
         ,OpeningBatchGUID
         ,Createtime4Chk
     ,RoomGUID,BUGUID,ProjGUID,BldGUID,MainRoomGUID,Unit,Floor,No,Room,RoomCode,HuXing,Status,IsVirtualRoom,BldArea,TnArea,BlRhDate,RHBLZT,YFBZ,RoomMemo,XPos,YPos,ZxBz,Price,TnPrice,Total,ZxPrice,ZxTotal,IsTempletRoom,Locker,LockTime,TfDate,DjArea,IsAreaModify,VirtualStatus,RHDate,JFRQ,JFMemo,XkRow,XkCol,AreaStatus,West,AreaChangingGUID,ImportDate,ChooseRoom,CstName,CstGUIDList,ChooseRoomCstName,ChooseRoomDate,Jbr,isAnnexe,Sight,RoomStru,AbsolutelyFloor,StatusChgGUID,SaleRentable,RentPrice,CalcRentMode,RentUnit,Bz,RentStatus,ContinueRentStatus,NextRentStatus,RentName,RentGUIDList,RentStatusChgGUID,RentLocker,RentLockTime,RentAmount,BProductTypeCode,YsBldArea,YsTnArea,ScBldArea,ScTnArea,ChooseRoomNo,ImportData_SP5,FloorNo,UnitNo,SLControlDate,IsHfLock,PriceDj,TnPriceDj,TotalDj,IsDj2AreaLock,IsBzj2AreaLock,IsDjTf,IsBzjTf,IsDjAreaModify,ChooseRoomBookingGUID,Roominfo,dspBldArea,dspTnArea,dspAreaStatus,iPadReserveStatus,IsPreControl,PreControlBy,PreControlOn,ProjBatchGUID,ChooseRoomCstGUID,BookingGUID,AreaCreateOn,AreaCreateBy,AreaAuditOn,AreaAuditBy,AreaChangingOn,AreaChangingBy,OpeningBatchGUID,Createtime4Chk
         <attribute name="RoomGUID" field="RoomGUID" datatype="varchar" title="房间GUID"  format="" />;
         <attribute name="BUGUID" field="BUGUID" datatype="varchar" title="单位GUID"  format="" />;
         <attribute name="ProjGUID" field="ProjGUID" datatype="varchar" title="项目GUID"  format="" />;
         <attribute name="BldGUID" field="BldGUID" datatype="varchar" title="楼栋GUID"  format="" />;
         <attribute name="MainRoomGUID" field="MainRoomGUID" datatype="varchar" title="主房间GUID"  format="" />;
         <attribute name="AreaChangingGUID" field="AreaChangingGUID" datatype="varchar" title="面积变更GUID"  format="" />;
         <attribute name="StatusChgGUID" field="StatusChgGUID" datatype="varchar" title="销售状态变更GUID"  format="" />;
         <attribute name="RentStatusChgGUID" field="RentStatusChgGUID" datatype="varchar" title="租赁状态变更GUID"  format="" />;
         <attribute name="ChooseRoomBookingGUID" field="ChooseRoomBookingGUID" datatype="varchar" title="选房预约单GUID"  format="" />;
         <attribute name="PreControlBy" field="PreControlBy" datatype="varchar" title="预销控人员"  format="" />;
         <attribute name="ProjBatchGUID" field="ProjBatchGUID" datatype="varchar" title="项目推盘批次GUID"  format="" />;
         <attribute name="BookingGUID" field="BookingGUID" datatype="varchar" title="预约单GUID"  format="" />;
         <attribute name="OpeningBatchGUID" field="OpeningBatchGUID" datatype="varchar" title="开盘批次GUID"  format="" />;
         <cell datatype="varchar" width="100" field="Unit"   title="单元" orderby="Unit" sortable="true" exportfield="Unit" ></cell>;
         <cell datatype="varchar" width="100" field="Floor"   title="楼层" orderby="Floor" sortable="true" exportfield="Floor" ></cell>;
         <cell datatype="varchar" width="100" field="No"   title="号码" orderby="No" sortable="true" exportfield="No" ></cell>;
         <cell datatype="varchar" width="100" field="Room"   title="房号" orderby="Room" sortable="true" exportfield="Room" ></cell>;
         <cell datatype="varchar" width="100" field="RoomCode"   title="房间编码" orderby="RoomCode" sortable="true" exportfield="RoomCode" ></cell>;
         <cell datatype="varchar" width="100" field="HuXing"   title="户型" orderby="HuXing" sortable="true" exportfield="HuXing" ></cell>;
         <cell datatype="varchar" width="100" field="Status"   title="销售状态" orderby="Status" sortable="true" exportfield="Status" ></cell>;
         <cell  field="IsVirtualRoom" width="80"  title="是否虚拟房间" orderby="IsVirtualRoom" sortable="true" exportfield="IsVirtualRoom" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="BldArea"  title="建筑面积" orderby="BldArea" sortable="true" exportfield="BldArea" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="TnArea"  title="套内面积" orderby="TnArea" sortable="true" exportfield="TnArea" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="BlRhDate"  title="实际交付日期" orderby="BlRhDate" sortable="true" exportfield="BlRhDate" ></cell>;
         <cell datatype="varchar" width="100" field="RHBLZT"   title="交付办理状态" orderby="RHBLZT" sortable="true" exportfield="RHBLZT" ></cell>;
         <cell datatype="varchar" width="100" field="YFBZ"   title="验房标准" orderby="YFBZ" sortable="true" exportfield="YFBZ" ></cell>;
         <cell datatype="varchar" width="100" field="RoomMemo"   title="房间备注" orderby="RoomMemo" sortable="true" exportfield="RoomMemo" ></cell>;
         <cell datatype="int" width="80"   field="XPos"  title="X坐标" orderby="XPos" sortable="true" exportfield="XPos" ></cell>;
         <cell datatype="int" width="80"   field="YPos"  title="Y坐标" orderby="YPos" sortable="true" exportfield="YPos" ></cell>;
         <cell datatype="varchar" width="100" field="ZxBz"   title="装修标准" orderby="ZxBz" sortable="true" exportfield="ZxBz" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="Price"  title="建筑单价" orderby="Price" sortable="true" exportfield="Price" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="TnPrice"  title="套内单价" orderby="TnPrice" sortable="true" exportfield="TnPrice" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="Total"  title="标准总价" orderby="Total" sortable="true" exportfield="Total" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="ZxPrice"  title="装修单价" orderby="ZxPrice" sortable="true" exportfield="ZxPrice" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="ZxTotal"  title="装修款" orderby="ZxTotal" sortable="true" exportfield="ZxTotal" ></cell>;
         <cell  field="IsTempletRoom" width="80"  title="样板房" orderby="IsTempletRoom" sortable="true" exportfield="IsTempletRoom" ></cell>;
         <cell datatype="varchar" width="100" field="Locker"   title="锁定人" orderby="Locker" sortable="true" exportfield="Locker" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="LockTime"  title="锁定时间" orderby="LockTime" sortable="true" exportfield="LockTime" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="TfDate"  title="退房日期" orderby="TfDate" sortable="true" exportfield="TfDate" ></cell>;
         <cell datatype="varchar" width="100" field="DjArea"   title="计价方式" orderby="DjArea" sortable="true" exportfield="DjArea" ></cell>;
         <cell  field="IsAreaModify" width="80"  title="定价后面积发生变更" orderby="IsAreaModify" sortable="true" exportfield="IsAreaModify" ></cell>;
         <cell datatype="varchar" width="100" field="VirtualStatus"   title="虚拟销售状态" orderby="VirtualStatus" sortable="true" exportfield="VirtualStatus" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="RHDate"  title="交付通知日期" orderby="RHDate" sortable="true" exportfield="RHDate" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="JFRQ"  title="交付办理日期" orderby="JFRQ" sortable="true" exportfield="JFRQ" ></cell>;
         <cell datatype="varchar" width="100" field="JFMemo"   title="交付房间备注" orderby="JFMemo" sortable="true" exportfield="JFMemo" ></cell>;
         <cell datatype="varchar" width="100" field="XkRow"   title="销控Row" orderby="XkRow" sortable="true" exportfield="XkRow" ></cell>;
         <cell datatype="varchar" width="100" field="XkCol"   title="销控col" orderby="XkCol" sortable="true" exportfield="XkCol" ></cell>;
         <cell datatype="varchar" width="100" field="AreaStatus"   title="面积状态" orderby="AreaStatus" sortable="true" exportfield="AreaStatus" ></cell>;
         <cell datatype="varchar" width="100" field="West"   title="朝向" orderby="West" sortable="true" exportfield="West" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="ImportDate"  title="引入日期" orderby="ImportDate" sortable="true" exportfield="ImportDate" ></cell>;
         <cell  field="ChooseRoom" width="80"  title="是否选房" orderby="ChooseRoom" sortable="true" exportfield="ChooseRoom" ></cell>;
         <cell datatype="varchar" width="100" field="CstName"   title="客户名称" orderby="CstName" sortable="true" exportfield="CstName" ></cell>;
         <cell  datatype="text"  field="CstGUIDList"   title="客户GUID" orderby="CstGUIDList" sortable="true" exportfield="CstGUIDList" ></cell>;
         <cell datatype="varchar" width="100" field="ChooseRoomCstName"   title="选房客户名称" orderby="ChooseRoomCstName" sortable="true" exportfield="ChooseRoomCstName" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="ChooseRoomDate"  title="选房时间" orderby="ChooseRoomDate" sortable="true" exportfield="ChooseRoomDate" ></cell>;
         <cell datatype="varchar" width="100" field="Jbr"   title="经办人" orderby="Jbr" sortable="true" exportfield="Jbr" ></cell>;
         <cell  field="isAnnexe" width="80"  title="是否附属房产" orderby="isAnnexe" sortable="true" exportfield="isAnnexe" ></cell>;
         <cell datatype="varchar" width="100" field="Sight"   title="景观" orderby="Sight" sortable="true" exportfield="Sight" ></cell>;
         <cell datatype="varchar" width="100" field="RoomStru"   title="房间结构" orderby="RoomStru" sortable="true" exportfield="RoomStru" ></cell>;
         <cell datatype="varchar" width="100" field="AbsolutelyFloor"   title="实际楼层" orderby="AbsolutelyFloor" sortable="true" exportfield="AbsolutelyFloor" ></cell>;
         <cell datatype="varchar" width="100" field="SaleRentable"   title="租售类型" orderby="SaleRentable" sortable="true" exportfield="SaleRentable" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="RentPrice"  title="租金单价" orderby="RentPrice" sortable="true" exportfield="RentPrice" ></cell>;
         <cell datatype="varchar" width="100" field="CalcRentMode"   title="计租模式" orderby="CalcRentMode" sortable="true" exportfield="CalcRentMode" ></cell>;
         <cell datatype="varchar" width="100" field="RentUnit"   title="租金单位" orderby="RentUnit" sortable="true" exportfield="RentUnit" ></cell>;
         <cell datatype="varchar" width="100" field="Bz"   title="币种" orderby="Bz" sortable="true" exportfield="Bz" ></cell>;
         <cell datatype="varchar" width="100" field="RentStatus"   title="租赁状态" orderby="RentStatus" sortable="true" exportfield="RentStatus" ></cell>;
         <cell datatype="varchar" width="100" field="ContinueRentStatus"   title="续租状态" orderby="ContinueRentStatus" sortable="true" exportfield="ContinueRentStatus" ></cell>;
         <cell datatype="varchar" width="100" field="NextRentStatus"   title="租赁下家状态" orderby="NextRentStatus" sortable="true" exportfield="NextRentStatus" ></cell>;
         <cell datatype="varchar" width="100" field="RentName"   title="租户名称" orderby="RentName" sortable="true" exportfield="RentName" ></cell>;
         <cell  datatype="text"  field="RentGUIDList"   title="租户GUID列表" orderby="RentGUIDList" sortable="true" exportfield="RentGUIDList" ></cell>;
         <cell datatype="varchar" width="100" field="RentLocker"   title="租赁锁定人" orderby="RentLocker" sortable="true" exportfield="RentLocker" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="RentLockTime"  title="租赁锁定时间" orderby="RentLockTime" sortable="true" exportfield="RentLockTime" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="RentAmount"  title="租金" orderby="RentAmount" sortable="true" exportfield="RentAmount" ></cell>;
         <cell datatype="varchar" width="100" field="BProductTypeCode"   title="产品类型全代码" orderby="BProductTypeCode" sortable="true" exportfield="BProductTypeCode" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="YsBldArea"  title="预售建筑面积" orderby="YsBldArea" sortable="true" exportfield="YsBldArea" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="YsTnArea"  title="预售套内面积" orderby="YsTnArea" sortable="true" exportfield="YsTnArea" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="ScBldArea"  title="实测建筑面积" orderby="ScBldArea" sortable="true" exportfield="ScBldArea" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="ScTnArea"  title="实测套内面积" orderby="ScTnArea" sortable="true" exportfield="ScTnArea" ></cell>;
         <cell datatype="int" width="80"   field="ChooseRoomNo"  title="选房单号" orderby="ChooseRoomNo" sortable="true" exportfield="ChooseRoomNo" ></cell>;
         <cell datatype="varchar" width="100" field="ImportData_SP5"   title="SP5升级数据时使用" orderby="ImportData_SP5" sortable="true" exportfield="ImportData_SP5" ></cell>;
         <cell datatype="int" width="80"   field="FloorNo"  title="实际楼层序号" orderby="FloorNo" sortable="true" exportfield="FloorNo" ></cell>;
         <cell datatype="int" width="80"   field="UnitNo"  title="单元序号" orderby="UnitNo" sortable="true" exportfield="UnitNo" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="SLControlDate"  title="销售放盘日期" orderby="SLControlDate" sortable="true" exportfield="SLControlDate" ></cell>;
         <cell  field="IsHfLock" width="80"  title="是否换房锁定" orderby="IsHfLock" sortable="true" exportfield="IsHfLock" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="PriceDj"  title="底价建筑单价" orderby="PriceDj" sortable="true" exportfield="PriceDj" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="TnPriceDj"  title="底价套内单价" orderby="TnPriceDj" sortable="true" exportfield="TnPriceDj" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="TotalDj"  title="底价总价" orderby="TotalDj" sortable="true" exportfield="TotalDj" ></cell>;
         <cell  field="IsDj2AreaLock" width="80"  title="是否底价方案锁定" orderby="IsDj2AreaLock" sortable="true" exportfield="IsDj2AreaLock" ></cell>;
         <cell  field="IsBzj2AreaLock" width="80"  title="是否标准价方案锁定" orderby="IsBzj2AreaLock" sortable="true" exportfield="IsBzj2AreaLock" ></cell>;
         <cell  field="IsDjTf" width="80"  title="退房后底价确认标识" orderby="IsDjTf" sortable="true" exportfield="IsDjTf" ></cell>;
         <cell  field="IsBzjTf" width="80"  title="退房后标准价确认标识" orderby="IsBzjTf" sortable="true" exportfield="IsBzjTf" ></cell>;
         <cell  field="IsDjAreaModify" width="80"  title="面积改变后底价确认标识" orderby="IsDjAreaModify" sortable="true" exportfield="IsDjAreaModify" ></cell>;
         <cell datatype="varchar" width="100" field="Roominfo"   title="房间全名" orderby="Roominfo" sortable="true" exportfield="Roominfo" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="dspBldArea"  title="待审批建筑面积" orderby="dspBldArea" sortable="true" exportfield="dspBldArea" ></cell>;
         <cell datatype="money" width="80" format="0.00"  field="dspTnArea"  title="待审批套内面积" orderby="dspTnArea" sortable="true" exportfield="dspTnArea" ></cell>;
         <cell datatype="varchar" width="100" field="dspAreaStatus"   title="待审批面积状态" orderby="dspAreaStatus" sortable="true" exportfield="dspAreaStatus" ></cell>;
         <cell  field="iPadReserveStatus" width="80"  title="iPad选房预留状态" orderby="iPadReserveStatus" sortable="true" exportfield="iPadReserveStatus" ></cell>;
         <cell  field="IsPreControl" width="80"  title="是否预销控" orderby="IsPreControl" sortable="true" exportfield="IsPreControl" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="PreControlOn"  title="预销控时间" orderby="PreControlOn" sortable="true" exportfield="PreControlOn" ></cell>;
         <cell datatype="varchar" width="100" field="ChooseRoomCstGUID"   title="选房客户GUID" orderby="ChooseRoomCstGUID" sortable="true" exportfield="ChooseRoomCstGUID" ></cell>;
         <cell datatype="varchar" width="100" field="AreaCreateOn"   title="未知" orderby="AreaCreateOn" sortable="true" exportfield="AreaCreateOn" ></cell>;
         <cell datatype="varchar" width="100" field="AreaCreateBy"   title="未知" orderby="AreaCreateBy" sortable="true" exportfield="AreaCreateBy" ></cell>;
         <cell datatype="varchar" width="100" field="AreaAuditOn"   title="未知" orderby="AreaAuditOn" sortable="true" exportfield="AreaAuditOn" ></cell>;
         <cell datatype="varchar" width="100" field="AreaAuditBy"   title="未知" orderby="AreaAuditBy" sortable="true" exportfield="AreaAuditBy" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="AreaChangingOn"  title="面积变更标准价审核时间" orderby="AreaChangingOn" sortable="true" exportfield="AreaChangingOn" ></cell>;
         <cell datatype="varchar" width="100" field="AreaChangingBy"   title="面积变更标准价审核人" orderby="AreaChangingBy" sortable="true" exportfield="AreaChangingBy" ></cell>;
         <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="Createtime4Chk"  title="创建时间" orderby="Createtime4Chk" sortable="true" exportfield="Createtime4Chk" ></cell>;

View Code

EditXml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
     --------------------- p_Room----------------------
         ,RoomGUID
         ,BUGUID
         ,ProjGUID
         ,BldGUID
         ,MainRoomGUID
         ,Unit
         ,Floor
         ,No
         ,Room
         ,RoomCode
         ,HuXing
         ,Status
         ,IsVirtualRoom
         ,BldArea
         ,TnArea
         ,BlRhDate
         ,RHBLZT
         ,YFBZ
         ,RoomMemo
         ,XPos
         ,YPos
         ,ZxBz
         ,Price
         ,TnPrice
         ,Total
         ,ZxPrice
         ,ZxTotal
         ,IsTempletRoom
         ,Locker
         ,LockTime
         ,TfDate
         ,DjArea
         ,IsAreaModify
         ,VirtualStatus
         ,RHDate
         ,JFRQ
         ,JFMemo
         ,XkRow
         ,XkCol
         ,AreaStatus
         ,West
         ,AreaChangingGUID
         ,ImportDate
         ,ChooseRoom
         ,CstName
         ,CstGUIDList
         ,ChooseRoomCstName
         ,ChooseRoomDate
         ,Jbr
         ,isAnnexe
         ,Sight
         ,RoomStru
         ,AbsolutelyFloor
         ,StatusChgGUID
         ,SaleRentable
         ,RentPrice
         ,CalcRentMode
         ,RentUnit
         ,Bz
         ,RentStatus
         ,ContinueRentStatus
         ,NextRentStatus
         ,RentName
         ,RentGUIDList
         ,RentStatusChgGUID
         ,RentLocker
         ,RentLockTime
         ,RentAmount
         ,BProductTypeCode
         ,YsBldArea
         ,YsTnArea
         ,ScBldArea
         ,ScTnArea
         ,ChooseRoomNo
         ,ImportData_SP5
         ,FloorNo
         ,UnitNo
         ,SLControlDate
         ,IsHfLock
         ,PriceDj
         ,TnPriceDj
         ,TotalDj
         ,IsDj2AreaLock
         ,IsBzj2AreaLock
         ,IsDjTf
         ,IsBzjTf
         ,IsDjAreaModify
         ,ChooseRoomBookingGUID
         ,Roominfo
         ,dspBldArea
         ,dspTnArea
         ,dspAreaStatus
         ,iPadReserveStatus
         ,IsPreControl
         ,PreControlBy
         ,PreControlOn
         ,ProjBatchGUID
         ,ChooseRoomCstGUID
         ,BookingGUID
         ,AreaCreateOn
         ,AreaCreateBy
         ,AreaAuditOn
         ,AreaAuditBy
         ,AreaChangingOn
         ,AreaChangingBy
         ,OpeningBatchGUID
         ,Createtime4Chk
     ,RoomGUID,BUGUID,ProjGUID,BldGUID,MainRoomGUID,Unit,Floor,No,Room,RoomCode,HuXing,Status,IsVirtualRoom,BldArea,TnArea,BlRhDate,RHBLZT,YFBZ,RoomMemo,XPos,YPos,ZxBz,Price,TnPrice,Total,ZxPrice,ZxTotal,IsTempletRoom,Locker,LockTime,TfDate,DjArea,IsAreaModify,VirtualStatus,RHDate,JFRQ,JFMemo,XkRow,XkCol,AreaStatus,West,AreaChangingGUID,ImportDate,ChooseRoom,CstName,CstGUIDList,ChooseRoomCstName,ChooseRoomDate,Jbr,isAnnexe,Sight,RoomStru,AbsolutelyFloor,StatusChgGUID,SaleRentable,RentPrice,CalcRentMode,RentUnit,Bz,RentStatus,ContinueRentStatus,NextRentStatus,RentName,RentGUIDList,RentStatusChgGUID,RentLocker,RentLockTime,RentAmount,BProductTypeCode,YsBldArea,YsTnArea,ScBldArea,ScTnArea,ChooseRoomNo,ImportData_SP5,FloorNo,UnitNo,SLControlDate,IsHfLock,PriceDj,TnPriceDj,TotalDj,IsDj2AreaLock,IsBzj2AreaLock,IsDjTf,IsBzjTf,IsDjAreaModify,ChooseRoomBookingGUID,Roominfo,dspBldArea,dspTnArea,dspAreaStatus,iPadReserveStatus,IsPreControl,PreControlBy,PreControlOn,ProjBatchGUID,ChooseRoomCstGUID,BookingGUID,AreaCreateOn,AreaCreateBy,AreaAuditOn,AreaAuditBy,AreaChangingOn,AreaChangingBy,OpeningBatchGUID,Createtime4Chk
         <item type="hidden" name="RoomGUID" field="RoomGUID"  title="房间GUID" />
         <item type="hidden" name="BUGUID" field="BUGUID"  title="单位GUID" />
         <item type="hidden" name="ProjGUID" field="ProjGUID"  title="项目GUID" />
         <item type="hidden" name="BldGUID" field="BldGUID"  title="楼栋GUID" />
         <item type="hidden" name="MainRoomGUID" field="MainRoomGUID"  title="主房间GUID" />
         <item type="hidden" name="AreaChangingGUID" field="AreaChangingGUID"  title="面积变更GUID" />
         <item type="hidden" name="StatusChgGUID" field="StatusChgGUID"  title="销售状态变更GUID" />
         <item type="hidden" name="RentStatusChgGUID" field="RentStatusChgGUID"  title="租赁状态变更GUID" />
         <item type="hidden" name="ChooseRoomBookingGUID" field="ChooseRoomBookingGUID"  title="选房预约单GUID" />
         <item type="hidden" name="PreControlBy" field="PreControlBy"  title="预销控人员" />
         <item type="hidden" name="ProjBatchGUID" field="ProjBatchGUID"  title="项目推盘批次GUID" />
         <item type="hidden" name="BookingGUID" field="BookingGUID"  title="预约单GUID" />
         <item type="hidden" name="OpeningBatchGUID" field="OpeningBatchGUID"  title="开盘批次GUID" />
         <item type="text" name="Unit" field="Unit" title="单元" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="Floor" field="Floor" title="楼层" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="No" field="No" title="号码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="Room" field="Room" title="房号" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RoomCode" field="RoomCode" title="房间编码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="200" defaultvalue="" onchange=""  /></item>
         <item type="text" name="HuXing" field="HuXing" title="户型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="Status" field="Status" title="销售状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="radio" name="IsVirtualRoom" field="IsVirtualRoom" title="是否虚拟房间" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="number" name="BldArea" field="BldArea" title="建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="TnArea" field="TnArea" title="套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="datetime" name="BlRhDate" field="BlRhDate" title="实际交付日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="RHBLZT" field="RHBLZT" title="交付办理状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
         <item type="text" name="YFBZ" field="YFBZ" title="验房标准" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="40" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RoomMemo" field="RoomMemo" title="房间备注" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="0" defaultvalue="" onchange=""  /></item>
         <item type="number" name="XPos" field="XPos" title="X坐标" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
         <item type="number" name="YPos" field="YPos" title="Y坐标" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
         <item type="text" name="ZxBz" field="ZxBz" title="装修标准" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
         <item type="number" name="Price" field="Price" title="建筑单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="TnPrice" field="TnPrice" title="套内单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="Total" field="Total" title="标准总价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="ZxPrice" field="ZxPrice" title="装修单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="ZxTotal" field="ZxTotal" title="装修款" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="radio" name="IsTempletRoom" field="IsTempletRoom" title="样板房" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="text" name="Locker" field="Locker" title="锁定人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="LockTime" field="LockTime" title="锁定时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="datetime" name="TfDate" field="TfDate" title="退房日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="DjArea" field="DjArea" title="计价方式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="radio" name="IsAreaModify" field="IsAreaModify" title="定价后面积发生变更" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="text" name="VirtualStatus" field="VirtualStatus" title="虚拟销售状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="RHDate" field="RHDate" title="交付通知日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="datetime" name="JFRQ" field="JFRQ" title="交付办理日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="JFMemo" field="JFMemo" title="交付房间备注" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="0" defaultvalue="" onchange=""  /></item>
         <item type="text" name="XkRow" field="XkRow" title="销控Row" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="2" defaultvalue="" onchange=""  /></item>
         <item type="text" name="XkCol" field="XkCol" title="销控col" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="2" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AreaStatus" field="AreaStatus" title="面积状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="50" defaultvalue="" onchange=""  /></item>
         <item type="text" name="West" field="West" title="朝向" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="ImportDate" field="ImportDate" title="引入日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="radio" name="ChooseRoom" field="ChooseRoom" title="是否选房" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="text" name="CstName" field="CstName" title="客户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="1000" defaultvalue="" onchange=""  /></item>
         <item type="memo" name="CstGUIDList" field="CstGUIDList" title="客户GUID" req="0" colspan="2" createapi="1" updateapi="1">  <attribute rows="3"  maxlength="4000"/></item>
         <item type="text" name="ChooseRoomCstName" field="ChooseRoomCstName" title="选房客户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="60" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="ChooseRoomDate" field="ChooseRoomDate" title="选房时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="Jbr" field="Jbr" title="经办人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
         <item type="radio" name="isAnnexe" field="isAnnexe" title="是否附属房产" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="text" name="Sight" field="Sight" title="景观" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RoomStru" field="RoomStru" title="房间结构" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AbsolutelyFloor" field="AbsolutelyFloor" title="实际楼层" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="SaleRentable" field="SaleRentable" title="租售类型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="number" name="RentPrice" field="RentPrice" title="租金单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="text" name="CalcRentMode" field="CalcRentMode" title="计租模式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RentUnit" field="RentUnit" title="租金单位" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="Bz" field="Bz" title="币种" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RentStatus" field="RentStatus" title="租赁状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="ContinueRentStatus" field="ContinueRentStatus" title="续租状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="NextRentStatus" field="NextRentStatus" title="租赁下家状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
         <item type="text" name="RentName" field="RentName" title="租户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="1000" defaultvalue="" onchange=""  /></item>
         <item type="memo" name="RentGUIDList" field="RentGUIDList" title="租户GUID列表" req="0" colspan="2" createapi="1" updateapi="1">  <attribute rows="3"  maxlength="4000"/></item>
         <item type="text" name="RentLocker" field="RentLocker" title="租赁锁定人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="RentLockTime" field="RentLockTime" title="租赁锁定时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="number" name="RentAmount" field="RentAmount" title="租金" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="text" name="BProductTypeCode" field="BProductTypeCode" title="产品类型全代码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="100" defaultvalue="" onchange=""  /></item>
         <item type="number" name="YsBldArea" field="YsBldArea" title="预售建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="YsTnArea" field="YsTnArea" title="预售套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="ScBldArea" field="ScBldArea" title="实测建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="ScTnArea" field="ScTnArea" title="实测套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="ChooseRoomNo" field="ChooseRoomNo" title="选房单号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
         <item type="text" name="ImportData_SP5" field="ImportData_SP5" title="SP5升级数据时使用" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="100" defaultvalue="" onchange=""  /></item>
         <item type="number" name="FloorNo" field="FloorNo" title="实际楼层序号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
         <item type="number" name="UnitNo" field="UnitNo" title="单元序号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
         <item type="datetime" name="SLControlDate" field="SLControlDate" title="销售放盘日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="radio" name="IsHfLock" field="IsHfLock" title="是否换房锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="number" name="PriceDj" field="PriceDj" title="底价建筑单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="TnPriceDj" field="TnPriceDj" title="底价套内单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="TotalDj" field="TotalDj" title="底价总价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="radio" name="IsDj2AreaLock" field="IsDj2AreaLock" title="是否底价方案锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="radio" name="IsBzj2AreaLock" field="IsBzj2AreaLock" title="是否标准价方案锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="radio" name="IsDjTf" field="IsDjTf" title="退房后底价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="radio" name="IsBzjTf" field="IsBzjTf" title="退房后标准价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="radio" name="IsDjAreaModify" field="IsDjAreaModify" title="面积改变后底价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="text" name="Roominfo" field="Roominfo" title="房间全名" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="250" defaultvalue="" onchange=""  /></item>
         <item type="number" name="dspBldArea" field="dspBldArea" title="待审批建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="number" name="dspTnArea" field="dspTnArea" title="待审批套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
         <item type="text" name="dspAreaStatus" field="dspAreaStatus" title="待审批面积状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="40" defaultvalue="" onchange=""  /></item>
         <item type="radio" name="iPadReserveStatus" field="iPadReserveStatus" title="iPad选房预留状态" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="radio" name="IsPreControl" field="IsPreControl" title="是否预销控" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
         <item type="datetime" name="PreControlOn" field="PreControlOn" title="预销控时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="ChooseRoomCstGUID" field="ChooseRoomCstGUID" title="选房客户GUID" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="400" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AreaCreateOn" field="AreaCreateOn" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AreaCreateBy" field="AreaCreateBy" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AreaAuditOn" field="AreaAuditOn" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
         <item type="text" name="AreaAuditBy" field="AreaAuditBy" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="AreaChangingOn" field="AreaChangingOn" title="面积变更标准价审核时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
         <item type="text" name="AreaChangingBy" field="AreaChangingBy" title="面积变更标准价审核人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
         <item type="datetime" name="Createtime4Chk" field="Createtime4Chk" title="创建时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>

View Code

新增模式：funcid 31010101

GirdXML

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
<?xml version="1.0" encoding="utf-8" ?>
    <page funcid="31010101">
        <controls>
            <control id="appGridMenu">
                <title>房间信息列表</title>
                <menu title="更多操作">
                    <menuitem id="btnDelete" actionid="03" title="删除" action="openDelWin()" display="true" />
                    <menuitem title="-" id="mHx" />
                    <menuitem id="m2" actionid="91" title="打印" action="AppGridPrint(appGrid);" />
                    <menuitem id="m3" actionid="92" title="导出" action="AppGridToExcel(appGrid);" />
                </menu>
                <shortcuts>
                    <shortcut id="btnNew" actionid="01" title="新增" action="openAddWin();" tip="新增" icon="/images/New_16_blue.gif" display="true" />
                    <!--<shortcut id="shtProcess" title="审批" icon="/cbgl/images/Examine_16_blue.gif" display="false">
                      <menuitem id="btnNewProcess" actionid="71" title="发起审批" action="doNewProcess()" display="false" />
                      <menuitem id="btnOpenProcess" actionid="72"  title="审批过程" action="doOpenProcess()"  display="false"/>

                      <menuitem id="btnTjApprove" actionid="81" title="提交审批" action="doProcessLaunch()" display="false" />
                      <menuitem id="btnTgApprove" actionid="82"  title="审批通过" action="doProcessPass()" display="false" />
                      <menuitem id="btnBhApprove" actionid="83"  title="审批驳回" action="doProcessIgnore()" display="false" />
                    </shortcut>-->
                </shortcuts>
            </control>

            <control id="appGrid">
                <datasource entity="p_Room" keyname="RoomGUID">
                <sql>
                    <![CDATA[
                            SELECT 
                                     RoomGUID,
                                     BUGUID,
                                     ProjGUID,
                                     BldGUID,
                                     MainRoomGUID,
                                     Unit,
                                     Floor,
                                     No,
                                     Room,
                                     RoomCode,
                                     HuXing,
                                     Status,
                                     IsVirtualRoom,
                                     BldArea,
                                     TnArea,
                                     BlRhDate,
                                     RHBLZT,
                                     YFBZ,
                                     RoomMemo,
                                     XPos,
                                     YPos,
                                     ZxBz,
                                     Price,
                                     TnPrice,
                                     Total,
                                     ZxPrice,
                                     ZxTotal,
                                     IsTempletRoom,
                                     Locker,
                                     LockTime,
                                     TfDate,
                                     DjArea,
                                     IsAreaModify,
                                     VirtualStatus,
                                     RHDate,
                                     JFRQ,
                                     JFMemo,
                                     XkRow,
                                     XkCol,
                                     AreaStatus,
                                     West,
                                     AreaChangingGUID,
                                     ImportDate,
                                     ChooseRoom,
                                     CstName,
                                     CstGUIDList,
                                     ChooseRoomCstName,
                                     ChooseRoomDate,
                                     Jbr,
                                     isAnnexe,
                                     Sight,
                                     RoomStru,
                                     AbsolutelyFloor,
                                     StatusChgGUID,
                                     SaleRentable,
                                     RentPrice,
                                     CalcRentMode,
                                     RentUnit,
                                     Bz,
                                     RentStatus,
                                     ContinueRentStatus,
                                     NextRentStatus,
                                     RentName,
                                     RentGUIDList,
                                     RentStatusChgGUID,
                                     RentLocker,
                                     RentLockTime,
                                     RentAmount,
                                     BProductTypeCode,
                                     YsBldArea,
                                     YsTnArea,
                                     ScBldArea,
                                     ScTnArea,
                                     ChooseRoomNo,
                                     ImportData_SP5,
                                     FloorNo,
                                     UnitNo,
                                     SLControlDate,
                                     IsHfLock,
                                     PriceDj,
                                     TnPriceDj,
                                     TotalDj,
                                     IsDj2AreaLock,
                                     IsBzj2AreaLock,
                                     IsDjTf,
                                     IsBzjTf,
                                     IsDjAreaModify,
                                     ChooseRoomBookingGUID,
                                     Roominfo,
                                     dspBldArea,
                                     dspTnArea,
                                     dspAreaStatus,
                                     iPadReserveStatus,
                                     IsPreControl,
                                     PreControlBy,
                                     PreControlOn,
                                     ProjBatchGUID,
                                     ChooseRoomCstGUID,
                                     BookingGUID,
                                     AreaCreateOn,
                                     AreaCreateBy,
                                     AreaAuditOn,
                                     AreaAuditBy,
                                     AreaChangingOn,
                                     AreaChangingBy,
                                     OpeningBatchGUID,
                                     Createtime4Chk
                            FROM dbo.p_Room
                            WHERE (1=1) AND (2=2);
                    ]]>    

            </sql>
            <order field="RoomGUID" descending="false" />
            </datasource>
                <grid ondblclick="openModiWin();" onready="" onclick="trClick();">
                    <row>
                        <attributes>
                                     <attribute name="oid" field="RoomGUID" datatype="varchar" title="房间GUID" />
                                     <attribute name="BUGUID" field="BUGUID" datatype="varchar" title="单位GUID" />
                                     <attribute name="ProjGUID" field="ProjGUID" datatype="varchar" title="项目GUID" />
                                     <attribute name="BldGUID" field="BldGUID" datatype="varchar" title="楼栋GUID" />
                                     <attribute name="MainRoomGUID" field="MainRoomGUID" datatype="varchar" title="主房间GUID" />
                                     <attribute name="AreaChangingGUID" field="AreaChangingGUID" datatype="varchar" title="面积变更GUID" />
                                     <attribute name="StatusChgGUID" field="StatusChgGUID" datatype="varchar" title="销售状态变更GUID" />
                                     <attribute name="RentStatusChgGUID" field="RentStatusChgGUID" datatype="varchar" title="租赁状态变更GUID" />
                                     <attribute name="ChooseRoomBookingGUID" field="ChooseRoomBookingGUID" datatype="varchar" title="选房预约单GUID" />
                                     <attribute name="PreControlBy" field="PreControlBy" datatype="varchar" title="预销控人员" />
                                     <attribute name="ProjBatchGUID" field="ProjBatchGUID" datatype="varchar" title="项目推盘批次GUID" />
                                     <attribute name="BookingGUID" field="BookingGUID" datatype="varchar" title="预约单GUID" />
                                     <attribute name="OpeningBatchGUID" field="OpeningBatchGUID" datatype="varchar" title="开盘批次GUID" />
                        </attributes>
                             <cell datatype="varchar" width="100" field="Unit"   title="单元" orderby="Unit" sortable="true" exportfield="Unit" ></cell>
                             <cell datatype="varchar" width="100" field="Floor"   title="楼层" orderby="Floor" sortable="true" exportfield="Floor" ></cell>
                             <cell datatype="varchar" width="100" field="No"   title="号码" orderby="No" sortable="true" exportfield="No" ></cell>
                             <cell datatype="varchar" width="100" field="Room"   title="房号" orderby="Room" sortable="true" exportfield="Room" ></cell>
                             <cell datatype="varchar" width="100" field="RoomCode"   title="房间编码" orderby="RoomCode" sortable="true" exportfield="RoomCode" ></cell>
                             <cell datatype="varchar" width="100" field="HuXing"   title="户型" orderby="HuXing" sortable="true" exportfield="HuXing" ></cell>
                             <cell datatype="varchar" width="100" field="Status"   title="销售状态" orderby="Status" sortable="true" exportfield="Status" ></cell>
                             <cell  field="IsVirtualRoom" width="80"  title="是否虚拟房间" orderby="IsVirtualRoom" sortable="true" exportfield="IsVirtualRoom" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="BldArea"  title="建筑面积" orderby="BldArea" sortable="true" exportfield="BldArea" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="TnArea"  title="套内面积" orderby="TnArea" sortable="true" exportfield="TnArea" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="BlRhDate"  title="实际交付日期" orderby="BlRhDate" sortable="true" exportfield="BlRhDate" ></cell>
                             <cell datatype="varchar" width="100" field="RHBLZT"   title="交付办理状态" orderby="RHBLZT" sortable="true" exportfield="RHBLZT" ></cell>
                             <cell datatype="varchar" width="100" field="YFBZ"   title="验房标准" orderby="YFBZ" sortable="true" exportfield="YFBZ" ></cell>
                             <cell datatype="varchar" width="100" field="RoomMemo"   title="房间备注" orderby="RoomMemo" sortable="true" exportfield="RoomMemo" ></cell>
                             <cell datatype="int" width="80"   field="XPos"  title="X坐标" orderby="XPos" sortable="true" exportfield="XPos" ></cell>
                             <cell datatype="int" width="80"   field="YPos"  title="Y坐标" orderby="YPos" sortable="true" exportfield="YPos" ></cell>
                             <cell datatype="varchar" width="100" field="ZxBz"   title="装修标准" orderby="ZxBz" sortable="true" exportfield="ZxBz" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="Price"  title="建筑单价" orderby="Price" sortable="true" exportfield="Price" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="TnPrice"  title="套内单价" orderby="TnPrice" sortable="true" exportfield="TnPrice" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="Total"  title="标准总价" orderby="Total" sortable="true" exportfield="Total" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="ZxPrice"  title="装修单价" orderby="ZxPrice" sortable="true" exportfield="ZxPrice" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="ZxTotal"  title="装修款" orderby="ZxTotal" sortable="true" exportfield="ZxTotal" ></cell>
                             <cell  field="IsTempletRoom" width="80"  title="样板房" orderby="IsTempletRoom" sortable="true" exportfield="IsTempletRoom" ></cell>
                             <cell datatype="varchar" width="100" field="Locker"   title="锁定人" orderby="Locker" sortable="true" exportfield="Locker" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="LockTime"  title="锁定时间" orderby="LockTime" sortable="true" exportfield="LockTime" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="TfDate"  title="退房日期" orderby="TfDate" sortable="true" exportfield="TfDate" ></cell>
                             <cell datatype="varchar" width="100" field="DjArea"   title="计价方式" orderby="DjArea" sortable="true" exportfield="DjArea" ></cell>
                             <cell  field="IsAreaModify" width="80"  title="定价后面积发生变更" orderby="IsAreaModify" sortable="true" exportfield="IsAreaModify" ></cell>
                             <cell datatype="varchar" width="100" field="VirtualStatus"   title="虚拟销售状态" orderby="VirtualStatus" sortable="true" exportfield="VirtualStatus" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="RHDate"  title="交付通知日期" orderby="RHDate" sortable="true" exportfield="RHDate" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="JFRQ"  title="交付办理日期" orderby="JFRQ" sortable="true" exportfield="JFRQ" ></cell>
                             <cell datatype="varchar" width="100" field="JFMemo"   title="交付房间备注" orderby="JFMemo" sortable="true" exportfield="JFMemo" ></cell>
                             <cell datatype="varchar" width="100" field="XkRow"   title="销控Row" orderby="XkRow" sortable="true" exportfield="XkRow" ></cell>
                             <cell datatype="varchar" width="100" field="XkCol"   title="销控col" orderby="XkCol" sortable="true" exportfield="XkCol" ></cell>
                             <cell datatype="varchar" width="100" field="AreaStatus"   title="面积状态" orderby="AreaStatus" sortable="true" exportfield="AreaStatus" ></cell>
                             <cell datatype="varchar" width="100" field="West"   title="朝向" orderby="West" sortable="true" exportfield="West" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="ImportDate"  title="引入日期" orderby="ImportDate" sortable="true" exportfield="ImportDate" ></cell>
                             <cell  field="ChooseRoom" width="80"  title="是否选房" orderby="ChooseRoom" sortable="true" exportfield="ChooseRoom" ></cell>
                             <cell datatype="varchar" width="100" field="CstName"   title="客户名称" orderby="CstName" sortable="true" exportfield="CstName" ></cell>
                             <cell  datatype="text"  field="CstGUIDList"   title="客户GUID" orderby="CstGUIDList" sortable="true" exportfield="CstGUIDList" ></cell>
                             <cell datatype="varchar" width="100" field="ChooseRoomCstName"   title="选房客户名称" orderby="ChooseRoomCstName" sortable="true" exportfield="ChooseRoomCstName" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="ChooseRoomDate"  title="选房时间" orderby="ChooseRoomDate" sortable="true" exportfield="ChooseRoomDate" ></cell>
                             <cell datatype="varchar" width="100" field="Jbr"   title="经办人" orderby="Jbr" sortable="true" exportfield="Jbr" ></cell>
                             <cell  field="isAnnexe" width="80"  title="是否附属房产" orderby="isAnnexe" sortable="true" exportfield="isAnnexe" ></cell>
                             <cell datatype="varchar" width="100" field="Sight"   title="景观" orderby="Sight" sortable="true" exportfield="Sight" ></cell>
                             <cell datatype="varchar" width="100" field="RoomStru"   title="房间结构" orderby="RoomStru" sortable="true" exportfield="RoomStru" ></cell>
                             <cell datatype="varchar" width="100" field="AbsolutelyFloor"   title="实际楼层" orderby="AbsolutelyFloor" sortable="true" exportfield="AbsolutelyFloor" ></cell>
                             <cell datatype="varchar" width="100" field="SaleRentable"   title="租售类型" orderby="SaleRentable" sortable="true" exportfield="SaleRentable" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="RentPrice"  title="租金单价" orderby="RentPrice" sortable="true" exportfield="RentPrice" ></cell>
                             <cell datatype="varchar" width="100" field="CalcRentMode"   title="计租模式" orderby="CalcRentMode" sortable="true" exportfield="CalcRentMode" ></cell>
                             <cell datatype="varchar" width="100" field="RentUnit"   title="租金单位" orderby="RentUnit" sortable="true" exportfield="RentUnit" ></cell>
                             <cell datatype="varchar" width="100" field="Bz"   title="币种" orderby="Bz" sortable="true" exportfield="Bz" ></cell>
                             <cell datatype="varchar" width="100" field="RentStatus"   title="租赁状态" orderby="RentStatus" sortable="true" exportfield="RentStatus" ></cell>
                             <cell datatype="varchar" width="100" field="ContinueRentStatus"   title="续租状态" orderby="ContinueRentStatus" sortable="true" exportfield="ContinueRentStatus" ></cell>
                             <cell datatype="varchar" width="100" field="NextRentStatus"   title="租赁下家状态" orderby="NextRentStatus" sortable="true" exportfield="NextRentStatus" ></cell>
                             <cell datatype="varchar" width="100" field="RentName"   title="租户名称" orderby="RentName" sortable="true" exportfield="RentName" ></cell>
                             <cell  datatype="text"  field="RentGUIDList"   title="租户GUID列表" orderby="RentGUIDList" sortable="true" exportfield="RentGUIDList" ></cell>
                             <cell datatype="varchar" width="100" field="RentLocker"   title="租赁锁定人" orderby="RentLocker" sortable="true" exportfield="RentLocker" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="RentLockTime"  title="租赁锁定时间" orderby="RentLockTime" sortable="true" exportfield="RentLockTime" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="RentAmount"  title="租金" orderby="RentAmount" sortable="true" exportfield="RentAmount" ></cell>
                             <cell datatype="varchar" width="100" field="BProductTypeCode"   title="产品类型全代码" orderby="BProductTypeCode" sortable="true" exportfield="BProductTypeCode" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="YsBldArea"  title="预售建筑面积" orderby="YsBldArea" sortable="true" exportfield="YsBldArea" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="YsTnArea"  title="预售套内面积" orderby="YsTnArea" sortable="true" exportfield="YsTnArea" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="ScBldArea"  title="实测建筑面积" orderby="ScBldArea" sortable="true" exportfield="ScBldArea" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="ScTnArea"  title="实测套内面积" orderby="ScTnArea" sortable="true" exportfield="ScTnArea" ></cell>
                             <cell datatype="int" width="80"   field="ChooseRoomNo"  title="选房单号" orderby="ChooseRoomNo" sortable="true" exportfield="ChooseRoomNo" ></cell>
                             <cell datatype="varchar" width="100" field="ImportData_SP5"   title="SP5升级数据时使用" orderby="ImportData_SP5" sortable="true" exportfield="ImportData_SP5" ></cell>
                             <cell datatype="int" width="80"   field="FloorNo"  title="实际楼层序号" orderby="FloorNo" sortable="true" exportfield="FloorNo" ></cell>
                             <cell datatype="int" width="80"   field="UnitNo"  title="单元序号" orderby="UnitNo" sortable="true" exportfield="UnitNo" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="SLControlDate"  title="销售放盘日期" orderby="SLControlDate" sortable="true" exportfield="SLControlDate" ></cell>
                             <cell  field="IsHfLock" width="80"  title="是否换房锁定" orderby="IsHfLock" sortable="true" exportfield="IsHfLock" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="PriceDj"  title="底价建筑单价" orderby="PriceDj" sortable="true" exportfield="PriceDj" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="TnPriceDj"  title="底价套内单价" orderby="TnPriceDj" sortable="true" exportfield="TnPriceDj" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="TotalDj"  title="底价总价" orderby="TotalDj" sortable="true" exportfield="TotalDj" ></cell>
                             <cell  field="IsDj2AreaLock" width="80"  title="是否底价方案锁定" orderby="IsDj2AreaLock" sortable="true" exportfield="IsDj2AreaLock" ></cell>
                             <cell  field="IsBzj2AreaLock" width="80"  title="是否标准价方案锁定" orderby="IsBzj2AreaLock" sortable="true" exportfield="IsBzj2AreaLock" ></cell>
                             <cell  field="IsDjTf" width="80"  title="退房后底价确认标识" orderby="IsDjTf" sortable="true" exportfield="IsDjTf" ></cell>
                             <cell  field="IsBzjTf" width="80"  title="退房后标准价确认标识" orderby="IsBzjTf" sortable="true" exportfield="IsBzjTf" ></cell>
                             <cell  field="IsDjAreaModify" width="80"  title="面积改变后底价确认标识" orderby="IsDjAreaModify" sortable="true" exportfield="IsDjAreaModify" ></cell>
                             <cell datatype="varchar" width="100" field="Roominfo"   title="房间全名" orderby="Roominfo" sortable="true" exportfield="Roominfo" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="dspBldArea"  title="待审批建筑面积" orderby="dspBldArea" sortable="true" exportfield="dspBldArea" ></cell>
                             <cell datatype="money" width="80" format="0.00"  field="dspTnArea"  title="待审批套内面积" orderby="dspTnArea" sortable="true" exportfield="dspTnArea" ></cell>
                             <cell datatype="varchar" width="100" field="dspAreaStatus"   title="待审批面积状态" orderby="dspAreaStatus" sortable="true" exportfield="dspAreaStatus" ></cell>
                             <cell  field="iPadReserveStatus" width="80"  title="iPad选房预留状态" orderby="iPadReserveStatus" sortable="true" exportfield="iPadReserveStatus" ></cell>
                             <cell  field="IsPreControl" width="80"  title="是否预销控" orderby="IsPreControl" sortable="true" exportfield="IsPreControl" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="PreControlOn"  title="预销控时间" orderby="PreControlOn" sortable="true" exportfield="PreControlOn" ></cell>
                             <cell datatype="varchar" width="100" field="ChooseRoomCstGUID"   title="选房客户GUID" orderby="ChooseRoomCstGUID" sortable="true" exportfield="ChooseRoomCstGUID" ></cell>
                             <cell datatype="varchar" width="100" field="AreaCreateOn"   title="未知" orderby="AreaCreateOn" sortable="true" exportfield="AreaCreateOn" ></cell>
                             <cell datatype="varchar" width="100" field="AreaCreateBy"   title="未知" orderby="AreaCreateBy" sortable="true" exportfield="AreaCreateBy" ></cell>
                             <cell datatype="varchar" width="100" field="AreaAuditOn"   title="未知" orderby="AreaAuditOn" sortable="true" exportfield="AreaAuditOn" ></cell>
                             <cell datatype="varchar" width="100" field="AreaAuditBy"   title="未知" orderby="AreaAuditBy" sortable="true" exportfield="AreaAuditBy" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="AreaChangingOn"  title="面积变更标准价审核时间" orderby="AreaChangingOn" sortable="true" exportfield="AreaChangingOn" ></cell>
                             <cell datatype="varchar" width="100" field="AreaChangingBy"   title="面积变更标准价审核人" orderby="AreaChangingBy" sortable="true" exportfield="AreaChangingBy" ></cell>
                             <cell datatype="datetime" width="80" format="yyyy-MM-dd"  field="Createtime4Chk"  title="创建时间" orderby="Createtime4Chk" sortable="true" exportfield="Createtime4Chk" ></cell>
                    </row>
                    <!--        <summary>-->
                    <!--            <cell field="Summary1" title="本页合计一" titlewidth="50" align="right" format="#,##0.00" />-->
                    <!--            <cell sumtotalfield="Summary1" title="所有数据合计一" titlewidth="50" align="right" format="#,##0.00" />-->
                    <!--        </summary>-->
                </grid>
            </control>
        </controls>
    </page>

View Code

EditXml

<!-----------------------------更多干货尽在大明滴小站(http://dmsite.chinacloudsites.cn/)-------------------------------->
<?xml version="1.0" encoding="Utf-8" ?>
<page funcid="31010101">
    <controls>
        <control id="appFormMenu">
            <menus>
                <menu id="m1" title="文件">
                    <menuitem id="mClose" title="关闭" action="window.close();" />
                </menu>
                <menu id="m2" title="帮助">
                    <menuitem id="mClose" title="帮助" action="window.document.fireEvent('onhelp');" />
                    <menuitem id="mClose" title="关于明源地产ERP" action="openAbout();" />
                </menu>
            </menus>
            <shortcuts>
                <shortcut id="btnSave" actionid="01,02" title="保存" tip="保存" action="save()" icon="/images/Save_16_blue.gif" display="true" />
                    <shortcut id="btnSaveAndClose" actionid="01,02" title="保存&amp;关闭" tip="保存&amp;关闭" action="saveAndClose();" icon="/images/SaveClose_16_blue.gif" display="true"/>
                        <shortcut id="btnSaveAndNew" actionid="01,02" title="保存&amp;新增" tip="保存&amp;新增" action="saveAndNew();" icon="/images/SaveNew_16_blue.gif"  display="true"/>

                            <!--        <shortcut id="scSpace2" title="|" display="false" />-->
                            <!--        <shortcut actionid="71" id="btnNewProcess" title="发起审批" action="doNewProcess();" icon="/cbgl/images/tjsp_16.gif" display="false"/>-->
                            <!--        <shortcut actionid="72" id="btnOpenProcess" title="审批过程" action="doOpenProcess();" icon="/cbgl/images/ckspgc_16.gif" display="false" />-->
                            <!--        <shortcut actionid="81" id="btnTjApprove" title="提交审批" action="doProcessLaunch();" icon="/cbgl/images/tjsp_16.gif" display="false" />-->
                            <!--        <shortcut actionid="82" id="btnTgApprove" title="审批通过" action="doProcessPass();" icon="/cbgl/images/sptg_16.gif" display="false" />-->
                            <!--        <shortcut actionid="83" id="btnBhApprove" title="审批驳回" action="doProcessIgnore();" icon="/cbgl/images/spbh_16.gif" display="false" />-->
                            <!--
                            <shortcut  id="btnsDefect"  title="研判" icon="/cbgl/images/Examine_16_blue.gif"  display="true"  >
                              <menuitem  actionid="06" id="btnDefectStart" title="发起研判"    tip="发起研判" display="true"/>
                              <menuitem  actionid="06" id="btnDefectProcess" title="研判过程"   tip="研判过程" display="true"/>
                            </shortcut>-->

                            <shortcut title="|" />
                            <shortcut title="关闭" tip="关闭" action="window.close();" icon="/images/Close_16_blue.gif" />
            </shortcuts>
        </control>
        <control id="appNavBar">
            <nav>
                <navitem id="tab_main" title="基本信息" icon="/hyxt/images/Info_16_wihte.gif" onclick="event.returnValue=false" isshowonadd="true" iscreateiframe="true" display="true">
                </navitem>
                <navitem title="相关文档" icon="/cbgl/images/Document_16_wihte.gif" url="/cbgl/PUB/Tab_DocList.aspx?DocType=%u5408%u540C%u53D8%u66F4" display="false">
                    <params>
                        <param name="oid" value="appForm.oid.value" />
                        <param name="funcid" value="__funcid.value" />
                        <param name="mode" value="__mode.value" />
                    </params>
                </navitem>
            </nav>
        </control>

        <control id="appForm">
            <datasource entity="p_Room" keyname="RoomGUID">
                <sql>
                    <![CDATA[
                            SELECT 
                                     RoomGUID,
                                     BUGUID,
                                     ProjGUID,
                                     BldGUID,
                                     MainRoomGUID,
                                     Unit,
                                     Floor,
                                     No,
                                     Room,
                                     RoomCode,
                                     HuXing,
                                     Status,
                                     IsVirtualRoom,
                                     BldArea,
                                     TnArea,
                                     BlRhDate,
                                     RHBLZT,
                                     YFBZ,
                                     RoomMemo,
                                     XPos,
                                     YPos,
                                     ZxBz,
                                     Price,
                                     TnPrice,
                                     Total,
                                     ZxPrice,
                                     ZxTotal,
                                     IsTempletRoom,
                                     Locker,
                                     LockTime,
                                     TfDate,
                                     DjArea,
                                     IsAreaModify,
                                     VirtualStatus,
                                     RHDate,
                                     JFRQ,
                                     JFMemo,
                                     XkRow,
                                     XkCol,
                                     AreaStatus,
                                     West,
                                     AreaChangingGUID,
                                     ImportDate,
                                     ChooseRoom,
                                     CstName,
                                     CstGUIDList,
                                     ChooseRoomCstName,
                                     ChooseRoomDate,
                                     Jbr,
                                     isAnnexe,
                                     Sight,
                                     RoomStru,
                                     AbsolutelyFloor,
                                     StatusChgGUID,
                                     SaleRentable,
                                     RentPrice,
                                     CalcRentMode,
                                     RentUnit,
                                     Bz,
                                     RentStatus,
                                     ContinueRentStatus,
                                     NextRentStatus,
                                     RentName,
                                     RentGUIDList,
                                     RentStatusChgGUID,
                                     RentLocker,
                                     RentLockTime,
                                     RentAmount,
                                     BProductTypeCode,
                                     YsBldArea,
                                     YsTnArea,
                                     ScBldArea,
                                     ScTnArea,
                                     ChooseRoomNo,
                                     ImportData_SP5,
                                     FloorNo,
                                     UnitNo,
                                     SLControlDate,
                                     IsHfLock,
                                     PriceDj,
                                     TnPriceDj,
                                     TotalDj,
                                     IsDj2AreaLock,
                                     IsBzj2AreaLock,
                                     IsDjTf,
                                     IsBzjTf,
                                     IsDjAreaModify,
                                     ChooseRoomBookingGUID,
                                     Roominfo,
                                     dspBldArea,
                                     dspTnArea,
                                     dspAreaStatus,
                                     iPadReserveStatus,
                                     IsPreControl,
                                     PreControlBy,
                                     PreControlOn,
                                     ProjBatchGUID,
                                     ChooseRoomCstGUID,
                                     BookingGUID,
                                     AreaCreateOn,
                                     AreaCreateBy,
                                     AreaAuditOn,
                                     AreaAuditBy,
                                     AreaChangingOn,
                                     AreaChangingBy,
                                     OpeningBatchGUID,
                                     Createtime4Chk
                            FROM dbo.p_Room
                            WHERE (1=1) AND (2=2);
                    ]]>    
                </sql>
            </datasource>
            <form showtab="true">
                <tab title="基本信息">
                    <section title="基本信息" showtitle="true" showbar="true" cols="2" titlewidth="100" secid="Sec1">
                                <item type="hidden" name="oid" field="RoomGUID" title="房间GUID" />
                                <item type="hidden" name="BUGUID" field="BUGUID" title="单位GUID" />
                                <item type="hidden" name="ProjGUID" field="ProjGUID" title="项目GUID" />
                                <item type="hidden" name="BldGUID" field="BldGUID" title="楼栋GUID" />
                                <item type="hidden" name="MainRoomGUID" field="MainRoomGUID" title="主房间GUID" />
                                <item type="hidden" name="AreaChangingGUID" field="AreaChangingGUID" title="面积变更GUID" />
                                <item type="hidden" name="StatusChgGUID" field="StatusChgGUID" title="销售状态变更GUID" />
                                <item type="hidden" name="RentStatusChgGUID" field="RentStatusChgGUID" title="租赁状态变更GUID" />
                                <item type="hidden" name="ChooseRoomBookingGUID" field="ChooseRoomBookingGUID" title="选房预约单GUID" />
                                <item type="hidden" name="PreControlBy" field="PreControlBy" title="预销控人员" />
                                <item type="hidden" name="ProjBatchGUID" field="ProjBatchGUID" title="项目推盘批次GUID" />
                                <item type="hidden" name="BookingGUID" field="BookingGUID" title="预约单GUID" />
                                <item type="hidden" name="OpeningBatchGUID" field="OpeningBatchGUID" title="开盘批次GUID" />
                                                     <item type="text" name="Unit" field="Unit" title="单元" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="Floor" field="Floor" title="楼层" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="No" field="No" title="号码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="Room" field="Room" title="房号" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RoomCode" field="RoomCode" title="房间编码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="200" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="HuXing" field="HuXing" title="户型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="Status" field="Status" title="销售状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="radio" name="IsVirtualRoom" field="IsVirtualRoom" title="是否虚拟房间" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="number" name="BldArea" field="BldArea" title="建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="TnArea" field="TnArea" title="套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="datetime" name="BlRhDate" field="BlRhDate" title="实际交付日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="RHBLZT" field="RHBLZT" title="交付办理状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="YFBZ" field="YFBZ" title="验房标准" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="40" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RoomMemo" field="RoomMemo" title="房间备注" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="0" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="XPos" field="XPos" title="X坐标" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
                             <item type="number" name="YPos" field="YPos" title="Y坐标" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
                             <item type="text" name="ZxBz" field="ZxBz" title="装修标准" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="Price" field="Price" title="建筑单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="TnPrice" field="TnPrice" title="套内单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="Total" field="Total" title="标准总价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="ZxPrice" field="ZxPrice" title="装修单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="ZxTotal" field="ZxTotal" title="装修款" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="radio" name="IsTempletRoom" field="IsTempletRoom" title="样板房" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="text" name="Locker" field="Locker" title="锁定人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="LockTime" field="LockTime" title="锁定时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="datetime" name="TfDate" field="TfDate" title="退房日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="DjArea" field="DjArea" title="计价方式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="radio" name="IsAreaModify" field="IsAreaModify" title="定价后面积发生变更" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="text" name="VirtualStatus" field="VirtualStatus" title="虚拟销售状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="RHDate" field="RHDate" title="交付通知日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="datetime" name="JFRQ" field="JFRQ" title="交付办理日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="JFMemo" field="JFMemo" title="交付房间备注" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="0" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="XkRow" field="XkRow" title="销控Row" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="2" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="XkCol" field="XkCol" title="销控col" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="2" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AreaStatus" field="AreaStatus" title="面积状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="50" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="West" field="West" title="朝向" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="ImportDate" field="ImportDate" title="引入日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="radio" name="ChooseRoom" field="ChooseRoom" title="是否选房" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="text" name="CstName" field="CstName" title="客户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="1000" defaultvalue="" onchange=""  /></item>
                             <item type="memo" name="CstGUIDList" field="CstGUIDList" title="客户GUID" req="0" colspan="2" createapi="1" updateapi="1">  <attribute rows="3"  maxlength="4000"/></item>
                             <item type="text" name="ChooseRoomCstName" field="ChooseRoomCstName" title="选房客户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="60" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="ChooseRoomDate" field="ChooseRoomDate" title="选房时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="Jbr" field="Jbr" title="经办人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
                             <item type="radio" name="isAnnexe" field="isAnnexe" title="是否附属房产" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="text" name="Sight" field="Sight" title="景观" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RoomStru" field="RoomStru" title="房间结构" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="30" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AbsolutelyFloor" field="AbsolutelyFloor" title="实际楼层" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="SaleRentable" field="SaleRentable" title="租售类型" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="RentPrice" field="RentPrice" title="租金单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="text" name="CalcRentMode" field="CalcRentMode" title="计租模式" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RentUnit" field="RentUnit" title="租金单位" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="Bz" field="Bz" title="币种" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RentStatus" field="RentStatus" title="租赁状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="ContinueRentStatus" field="ContinueRentStatus" title="续租状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="NextRentStatus" field="NextRentStatus" title="租赁下家状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="10" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="RentName" field="RentName" title="租户名称" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="1000" defaultvalue="" onchange=""  /></item>
                             <item type="memo" name="RentGUIDList" field="RentGUIDList" title="租户GUID列表" req="0" colspan="2" createapi="1" updateapi="1">  <attribute rows="3"  maxlength="4000"/></item>
                             <item type="text" name="RentLocker" field="RentLocker" title="租赁锁定人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="16" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="RentLockTime" field="RentLockTime" title="租赁锁定时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="number" name="RentAmount" field="RentAmount" title="租金" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="text" name="BProductTypeCode" field="BProductTypeCode" title="产品类型全代码" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="100" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="YsBldArea" field="YsBldArea" title="预售建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="YsTnArea" field="YsTnArea" title="预售套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="ScBldArea" field="ScBldArea" title="实测建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="ScTnArea" field="ScTnArea" title="实测套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="ChooseRoomNo" field="ChooseRoomNo" title="选房单号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
                             <item type="text" name="ImportData_SP5" field="ImportData_SP5" title="SP5升级数据时使用" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="100" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="FloorNo" field="FloorNo" title="实际楼层序号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
                             <item type="number" name="UnitNo" field="UnitNo" title="单元序号" req="0" colspan="1" createapi="1" updateapi="1"><attribute min="0" max="100000000000" grp="false" acc="0" dt=""  onreturnvaluechange="" ondblclick=""  /></item>
                             <item type="datetime" name="SLControlDate" field="SLControlDate" title="销售放盘日期" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="radio" name="IsHfLock" field="IsHfLock" title="是否换房锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="number" name="PriceDj" field="PriceDj" title="底价建筑单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="TnPriceDj" field="TnPriceDj" title="底价套内单价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="TotalDj" field="TotalDj" title="底价总价" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="radio" name="IsDj2AreaLock" field="IsDj2AreaLock" title="是否底价方案锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="radio" name="IsBzj2AreaLock" field="IsBzj2AreaLock" title="是否标准价方案锁定" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="radio" name="IsDjTf" field="IsDjTf" title="退房后底价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="radio" name="IsBzjTf" field="IsBzjTf" title="退房后标准价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="radio" name="IsDjAreaModify" field="IsDjAreaModify" title="面积改变后底价确认标识" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="text" name="Roominfo" field="Roominfo" title="房间全名" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="250" defaultvalue="" onchange=""  /></item>
                             <item type="number" name="dspBldArea" field="dspBldArea" title="待审批建筑面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="number" name="dspTnArea" field="dspTnArea" title="待审批套内面积" req="0" colspan="1" createapi="1" updateapi="1" format="#,##0.00"><attribute min="0" max="100000000000" grp="true" acc="2" dt=""  onreturnvaluechange="" ondblclick="" /></item>
                             <item type="text" name="dspAreaStatus" field="dspAreaStatus" title="待审批面积状态" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="40" defaultvalue="" onchange=""  /></item>
                             <item type="radio" name="iPadReserveStatus" field="iPadReserveStatus" title="iPad选房预留状态" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="radio" name="IsPreControl" field="IsPreControl" title="是否预销控" req="0" colspan="1" createapi="1" updateapi="1"><option value="1">是</option> <option value="0">否</option></item>
                             <item type="datetime" name="PreControlOn" field="PreControlOn" title="预销控时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="ChooseRoomCstGUID" field="ChooseRoomCstGUID" title="选房客户GUID" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="400" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AreaCreateOn" field="AreaCreateOn" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AreaCreateBy" field="AreaCreateBy" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AreaAuditOn" field="AreaAuditOn" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
                             <item type="text" name="AreaAuditBy" field="AreaAuditBy" title="未知" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="256" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="AreaChangingOn" field="AreaChangingOn" title="面积变更标准价审核时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                             <item type="text" name="AreaChangingBy" field="AreaChangingBy" title="面积变更标准价审核人" req="0" colspan="1" createapi="1" updateapi="1"><attribute maxlength="20" defaultvalue="" onchange=""  /></item>
                             <item type="datetime" name="Createtime4Chk" field="Createtime4Chk" title="创建时间" req="0" colspan="1" createapi="1" updateapi="1" time="0"> <attribute onreturnvaluechange="" onbeforedeactivate=""/></item>
                    </section>
                </tab>
                
            </form>
        </control>
        
    </controls>
</page>

View Code

3.结束语

有啥问题可以在这留言，觉的该工具有用的话记得在公司多转下邮件，让更多人可以早点回去陪女朋友。不说了，说多了都是泪。

posted @ 2016-11-13 11:10 晓明的哥哥阅读(1030) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

晓明的哥哥

路漫漫其修远兮，吾将上下而求索

Map工具系列-03-代码生成BySQl工具使用说明

所有cs端工具集成了一个工具面板 -打开(IE)

Map工具系列-01-Map代码生成工具说明

Map工具系列-02-数据迁移工具使用说明