|
||||||||||||||
<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" /> <script language="JavaScript" src="dbnetsuite.js.ashx"></script>
<script>
jQuery(document).ready( init )
var dbnetgrid1
//////////////////////////////////////////
function init()
//////////////////////////////////////////
{
dbnetgrid1 = new DbNetGrid("dbnetgrid1");
with (dbnetgrid1)
{
connectionString = "SamplesDatabase"
fromPart = "Orders"
setColumnExpressions("CustomerID","EmployeeID","OrderDate","ShipVia","ShipCountry");
setColumnProperty("CustomerID","label", "Customer");
setColumnProperty("CustomerID","lookup", "select customerid, companyname from customers");
setColumnProperty("CustomerID","filter", true);
setColumnProperty("EmployeeID","label", "Employee");
setColumnProperty("EmployeeID","lookup", "select employeeid, lastname from employees");
setColumnProperty("EmployeeID","filter", true);
setColumnProperty("OrderDate","filter", true);
setColumnProperty("ShipCountry","filter", true);
setColumnProperty("ShipVia","lookup", "select shipperid, companyname from shippers");
setColumnProperty("ShipVia","filter", true);
setFilterColumnMode()
setFilterMode()
}
}
//////////////////////////////////////////
function setFilterColumnMode()
//////////////////////////////////////////
{
with (dbnetgrid1)
{
filterColumnMode = document.getElementById("filterColumnMode").value;
}
}
//////////////////////////////////////////
function setFilterMode()
//////////////////////////////////////////
{
var filterMode = document.getElementById("filterMode").value;
with (dbnetgrid1)
{
setColumnProperty("CustomerID","filterMode", filterMode);
setColumnProperty("EmployeeID","filterMode", filterMode);
setColumnProperty("OrderDate","filterMode", filterMode);
setColumnProperty("ShipCountry","filterMode", filterMode);
setColumnProperty("ShipVia","filterMode", filterMode);
initialize();
}
}
</script>
<table> <td>Filter Type</td> <td> <select id="filterColumnMode" onchange="setFilterColumnMode()"> <option value="Simple">Simple</option> <option value="Composite">Composite</option> </select> </td> <td>Filter Selection Mode</td> <td> <select id="filterMode" onchange="setFilterMode()"> <option value="List">List</option> <option value="Input">Input</option> </select> </td> </table> <div id="dbnetgrid1"></div>