DbNetSuite Sample

Example

Source

Menu

|

|

Run as

The function of the Insert button can be modified to insert multiple records directly from a lookup dialog by seting the bulkInsert column property. In this example multiple Order Lines can be added in a single action by selecting the Product from a list of products. Note that once a product has been added to the order it is no longer available in the lookup dialog. The sample also demonstrates use of the onBeforeBulkInsert event to supply a default value for the quantity column.

Customers

Orders

Order Details

Include the client JavaScript & CSS libraries

	<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" />
	<script language="JavaScript" src="dbnetsuite.js.ashx"></script>

Client-side configuration script

	<script>
	jQuery(document).ready( init )

	function init()
	{
		var dbnetgrid1 = new DbNetGrid("dbnetgrid1");
		var dbnetgrid2 = new DbNetGrid("dbnetgrid2");
		var dbnetgrid3 = new DbNetGrid("dbnetgrid3");

		with (dbnetgrid3)
		{
			connectionString = "SamplesDatabase"
			fromPart = "[order details]"
			setColumnExpressions("OrderID","ProductID","Quantity","UnitPrice");

			setColumnProperty("OrderID", "foreignKey", true);
			setColumnProperty("ProductID", "lookup", "select productid, productname from products");

			setColumnProperty("ProductID", "bulkInsert", true);
			setColumnProperty(["Quantity","UnitPrice"], "inlineEdit", true);
			multiRowSelect = true;

			bind("onBeforeBulkInsert", setDefaultQuantity);
		}

		with (dbnetgrid2)
		{
			connectionString = "SamplesDatabase"
			fromPart = "orders"
			setColumnExpressions("OrderID","CustomerID","EmployeeID","OrderDate","RequiredDate","ShippedDate","ShipVia","Freight");

			setColumnProperty("CustomerID", "display", false);
			setColumnProperty("CustomerID", "foreignKey", true);
			setColumnProperty("EmployeeID", "lookup", "select employeeid, lastname + ',' + firstname from employees order by lastname,firstname");
			setColumnProperty("CustomerID", "lookup", "select customerid, companyname from customers");
			setColumnProperty("ShipVia", "lookup", "select shipperid, companyname from shippers");
			addLinkedControl( dbnetgrid3 )
		}

		with (dbnetgrid1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "customers"
			setColumnExpressions("CustomerID","CompanyName","Address","City");
			setColumnProperty("CustomerID", "display", false);

			addLinkedControl( dbnetgrid2 )
			initialize()
		}

	}

	function setDefaultQuantity(sender, args)
	{
		args.params["quantity"] = 5;
	}
	</script>

HTML markup

    <table>
        <tr>
            <td style="vertical-align: top">
                <fieldset>   
                <legend>Customers</legend>   
					<div id="dbnetgrid1"></div>
                </fieldset>
            </td>
            <td style="vertical-align: top">
                <fieldset>   
                <legend>Orders</legend>   
					<div id="dbnetgrid2"></div>
                </fieldset>
                
                <fieldset>   
                <legend>Order Details</legend>   
					<div id="dbnetgrid3"></div>
                </fieldset>
            </td>
        </tr>
    </table>