<html>
<head>
<xml:namespace prefix="v"/>
<style>v\:* {behavior=url(#default#VML)}</style>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>lookup字段示例</title>
</head>
<BODY onload='afterload();'>
<p><b>lookup字段示例</b>&nbsp;&nbsp;&nbsp; <font size="2" color="#000000"><a href="sourcecode/paginationhtml.html">网页代码</a> 
&nbsp;&nbsp; <a href="sourcecode/paginationopenjsp.html">JSP代码</a>(OpenUrl)&nbsp; 
<a href="sourcecode/singletablesavejsp.html">JSP代码</a>（PostUrl)</font></p>
</BODY>
</html>

<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/System.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/Query.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBControl.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBGrid.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBNavigator.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBPageNavigator.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript">

function afterload(){
init();
client.Open();
sale.Open();
}

function init(){
new Query('client');
client.MaxRows=5; //code table
client.OpenUrl = "clientopen.jsp";

new Query('sale');
sale.MaxRows=5; //how many record show in a page
sale.OpenUrl = "saleopen.jsp";
sale.PostUrl = "salepost.jsp";

var f=new Field("CLIENT_NAME","lookup");
f.LookupDataSet = client;
f.KeyField = "SALE_CLIENT_ID";
f.LookupKeyField = "CLIENT_ID";
f.LookupResultField = "CLIENT_NAME";

sale.Fields.Add(f);


new DBGrid('dbgrid1');
dbgrid1.DataSet=sale;
dbgrid1.style.width=500;
dbgrid1.style.height=150;
dbgrid1.style.top=140;
dbgrid1.Body.borderColorLight="#0000FF"
dbgrid1.Body.borderColorDark="#0000FF";

dbgrid1.Auto = false;

var col1 = new Column('SALE_ID','销售单号');
dbgrid1.Cols.Add(col1);

var col1 = new Column();
col1.DataField = 'CLIENT_NAME';
col1.Caption = '客户名称';
// col1.CtlType = 'A';
col1.CtlType = 'lookup';
dbgrid1.Cols.Add(col1);

var col1 = new Column('SALE_TYPE','销售类型');
dbgrid1.Cols.Add(col1);

new DBNavigator('nv1');
nv1.style.left=10;
nv1.style.top=60;
nv1.DataSet=sale;

new DBPageNavigator('nv2');
nv2.DataSet=sale;
nv2.style.left=10;
nv2.style.top=90;
}
</SCRIPT>