获取数据：

  <%

    String mContractCode = RequestHelper.GetQueryString("ContractCode");                 

    List<DbParam> mDicSysParam = new List<DbParam>();

    List<DbParam> mDicInputParam = new List<DbParam>();

//从之前页面获取

    mDicInputParam.Add(new DbParam("ContractCode", mContractCode));

    //执行列表页的查询，同样设置功能点，查询所需的

    DataTable mDefaultDataTable = AgileCorpDataService.GetDataFunctionDataTable("contract100122", mDicInputParam, out mDicSysParam);

//获取值

    String mContractCodeview = mDefaultDataTable.Rows[0]["ContractCode"].ToString();

    String mContactName = mDefaultDataTable.Rows[0]["ContactName"].ToString();

    String mContactUser = mDefaultDataTable.Rows[0]["ContactUser"].ToString();

    String mMobile = mDefaultDataTable.Rows[0]["Mobile"].ToString();

    String mAddress = mDefaultDataTable.Rows[0]["Address"].ToString();

    String mSignDate = mDefaultDataTable.Rows[0]["SignDate"].ToString();

    String mTotalAmount = mDefaultDataTable.Rows[0]["TotalAmount"].ToString();

   

                        %>

页面定义：

   <table>

            <tr>

                <td>

                    合同编号

                </td>

                <td>

               

                    <input id="contractcode" type="text" value="<%=mContractCodeview %>" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 100px;

                        text-align: left" />

                </td>

            </tr>

            <tr>

                <td>

                    甲方（出租方）：

                </td>

                <td>

                    <input id="name1" type="text" value="<%=mContactName %>" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 400px;

                        text-align: left" />

                </td>

                <td>

                    邮编：

                </td>

                <td>

                    <input id="postalcode1 " type="text" value="" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 100px;

                        text-align: left" />

                </td>

            </tr>

            <tr>

                <td>

                    住址：

                </td>

                <td>

                    <input id="address1" type="text" value="<%=mAddress %>" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 400px;

                        text-align: left" />

                </td>

            </tr>

            <tr>

                <td>

                    委托代理人：

                </td>

                <td>

                    <input id="contactname" type="text" value="<%=mContactUser %>" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 100px;

                        text-align: left" />

                </td>

                <td>

                    联系电话：

                </td>

                <td>

                    <input id="tel1" type="text" value="<%=mMobile %>" style="border-left: none; border-right: none;

                        border-top: none; border-color: black; line-height: 20px; height: 20px; width: 100px;

                        text-align: left" />

                </td>

            </tr>

        </table>

功能点：

create proc Asset_spQueryContractModelList

(

@pi_ContractCode varchar(100)

)

as

begin

SELECT     dbo.Asset_Contract.ContractCode, dbo.Asset_ContactInfo.Address, dbo.Asset_Contract.SignDate, dbo.Asset_Contract.RendStartDate,

                      dbo.Asset_Contract.RendEndDate, dbo.Asset_Contract.TotalAmount, dbo.Asset_Contract.BusinessScope, dbo.Asset_ShopInfo.HouseUse, dbo.Asset_ShopInfo.Square,

                      dbo.Asset_ContactInfo.ContactName, dbo.Asset_ContactInfo.ContactUser, dbo.Asset_ContactInfo.Mobile

FROM         dbo.Asset_ContractShopInfo INNER JOIN

                      dbo.Asset_ShopInfo ON dbo.Asset_ContractShopInfo.ShopCode = dbo.Asset_ShopInfo.ShopCode INNER JOIN

                      dbo.Asset_Contract INNER JOIN

                      dbo.Asset_ContactInfo ON dbo.Asset_Contract.ContactCode = dbo.Asset_ContactInfo.ContactCode ON

                      dbo.Asset_ContractShopInfo.ContractCode = dbo.Asset_Contract.ContractCode

where

end