<#assign fields=table.columnList>
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%
String pk=Request["${pkName}"];
String sql="Select * from ${table.name} where ${pkName}='" + pk +"'";
SqlConnection conn = new SqlConnection(@"Data Source=192.168.1.112;Initial Catalog=bpm;UID=sa;PWD=sasa;Max Pool Size=512;");
SqlDataAdapter myAdapter= new SqlDataAdapter(sql, conn);
SqlCommandBuilder myBuilder = new SqlCommandBuilder(myAdapter);
DataSet dataSet = new DataSet();
myAdapter.Fill(dataSet);
int count=dataSet.Tables[0].Rows.Count;
if(count>0)
{
DataRow row = dataSet.Tables[0].Rows[0];
%>
${table.comment } |
<#assign index=0>
<#list fields as field>
<#if index % 2 == 0>
| ${field.comment}: |
<%=row["${field.name}"]%>
|
<#if index % 2 == 0 && !field_has_next>
|
|
<#if index % 2 == 1 || !field_has_next>
<#assign index=index+1>
<%}%>