• 博客园logo
  • 会员
  • 周边
  • 众包
  • 新闻
  • 博问
  • 闪存
  • 赞助商
  • Chat2DB
    • 搜索
      所有博客
    • 搜索
      当前博客
  • 写随笔 我的博客 短消息 简洁模式
    用户头像
    我的博客 我的园子 账号设置 会员中心 简洁模式 ... 退出登录
    注册 登录
素蔓、无暇至永恒
承诺总是那么不堪一击~
博客园    首页    新随笔    联系   管理    订阅  订阅

页面通过功能点获取值

获取数据:
  <%
    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 Asset_Contract.ContractCode=@pi_ContractCode
end

posted @ 2012-07-30 17:57  pain1033  阅读(169)  评论(0)    收藏  举报
刷新页面返回顶部
博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3