页面通过功能点获取值
获取数据:
<%
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