Intersoft Solutions - Community - WebGrid Enterprise

armore1972Member

Posted: March 18, 2015 3:27 PM in response to Yudi

Thanks for the answer.

Is not possible to try with other browser (like firefox and chrome) because the page is part of external site used by CRM 2011 with a Rollup that doesn't allow to use other browser.
There's not other pages that use the hierarchical, but the strange think is that in second tab seems working well (the invoices has two tabs, the shows different type of invoices and use the same store procedure for display the child row).
I enable debugger but when i try to reproduce the issue the IE is blocking and is not possible to access to the debug mode (f12).

I try to make a video.
This is the aspx code that use ( if you need i give to you also the server side)
Thanks
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="InvoiceHistory.aspx.cs" Inherits="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistory" %>

<%@ Register Assembly="ISNet.WebUI.WebInput" Namespace="ISNet.WebUI.WebControls"
TagPrefix="ISWebInput" %>
<%@ Register Assembly="ISNet.WebUI.WebGrid" Namespace="ISNet.WebUI.WebGrid" TagPrefix="ISWebGrid" %>
<%@ Register Assembly="ISNet.WebUI.WebCombo" Namespace="ISNet.WebUI.WebCombo" TagPrefix="ISWebCombo" %>
<%@ Register Assembly="ISNet.WebUI.WebDesktop" Namespace="ISNet.WebUI.WebDesktop"
TagPrefix="ISWebDesktop" %>
<%@ Register Assembly="ISNet.WebUI.ISDataSource, Version=1.0.1500.1, Culture=neutral, PublicKeyToken=c4184ef0d326354b"
Namespace="ISNet.WebUI.DataSource" TagPrefix="ISDataSource" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html>
<head id="Head1" runat="server">
<style type="text/css">
html, body {
margin: 0; /* Remove body margin/padding */
padding: 0;
border: none;

background-color:#f6f8fa;
scrollbar-3dlight-color:#A5ACB5;
scrollbar-arrow-color:#3B3B3B;
scrollbar-base-color:#E9EDF1;
scrollbar-darkshadow-color:#A5ACB5;
scrollbar-face-color:#E9EDF1;
scrollbar-highlight-color:#E9EDF1;
scrollbar-shadow-color:#E9EDF1;
scrollbar-track-color:#E3E8ED;
}
</style>
<title>Invoice History</title>
<link href="#]*)");
var qs = regex.exec(window.location.href);
if (qs == null)
return default_;
else
return qs[1];
}

function CollapseGrid(controlId) {

var grid = wgGetGridById(controlId);
for (i = 0; i < grid.TotalLoadedRows; i++) {
var row = grid.RootTable.GetRow(i);
if (row.Table.ChildTables.length > 0) {
if (row.ChildExpanded) {
row.CollapseChildRow();
}
}

}

}

function HideCommission() {
var grid = ISGetObject("WebGrid1");
var col = grid.RootTable.Columns.GetNamedItem("speedy_provisionvalue");
//var col = grid.RootTable.ChildTables[0].Columns.GetNamedItem("speedy_commissionvalue");

var visCol = !col.Visible;
document.getElementById('HiddenFieldShowInvCommission').value = visCol;

grid.AddInput("action", "ShowInvCommission");
grid.SendCustomRequest();
}

function WebGrid1_OnChildRowCollapse(controlId, tblName, rowIndex, rowEl) {
}

function WebGrid2_OnChildRowCollapse(controlId, tblName, rowIndex, rowEl) {
}

function WebGrid1_OnRowSelect(controlId, tblName, rowIndex, rowEl) {

var grid1 = ISGetObject("WebGrid1");

var webTab = ISGetObject("WebTabHI");
var webInvoicesHeaderItem = webTab.TabPages.GetNamedItem("Invoices");

if (webInvoicesHeaderItem.IsActiveTab()) {
var invoiceNumber = getTextSelectRowByCell(grid1, "invoicenumber");
var productCode = getTextSelectRowByCell(grid1, "productnumber");
if (invoiceNumber != null) {
var productid = getTextSelectHiddenRowByCell(grid1, "speedy_invoicedate", "productid");
synchProductID = productid;
synchInvoiceDetailID = getTextSelectHiddenRowByCell(grid1, "accountidname", "invoicedetailid");

}
else {
var productid = getTextSelectHiddenRowByCell(grid1, "productnumber", "productid");
synchProductID = productid;
synchInvoiceDetailID = getTextSelectHiddenRowByCell(grid1, "productname", "invoicedetailid");

}
}
return true;
}

function WebGrid2_OnRowSelect(controlId, tblName, rowIndex, rowEl) {

var grid2 = ISGetObject("WebGrid2");
var webTab = ISGetObject("WebTabHI");
var webSoldItem = webTab.TabPages.GetNamedItem("SoldProducts");

if (webSoldItem.IsActiveTab()) {
var invoiceNumber = getTextSelectRowByCell(grid2, "invoicenumber");
var productCode = getTextSelectRowByCell(grid2, "TProductCode");
if (invoiceNumber != null) {
synchInvoiceID = getTextSelectHiddenRowByCell(grid2, "speedy_invoicedate", "invoiceid");
synchInvoiceDetailID = getTextSelectHiddenRowByCell(grid2, "productname", "invoicedetailid");

}
else {
synchInvoiceID = getTextSelectHiddenRowByCell(grid2, "TDescription", "invoiceid");
synchInvoiceDetailID = getTextSelectHiddenRowByCell(grid2, "TFreq", "invoicedetailid");

}
}

return true;
}

function WebGrid3_OnRowSelect(controlId, tblName, rowIndex, rowEl) {

var grid3 = ISGetObject("WebGrid3");
var webTab = ISGetObject("WebTabHI");
var webInvoicesPosItem = webTab.TabPages.GetNamedItem("ProductHistory");

if (webInvoicesPosItem.IsActiveTab()) {

synchInvoiceDetailID = getTextSelectHiddenRowByCell(grid3, "productname", "invoicedetailid");
synchInvoiceID = getTextSelectHiddenRowByCell(grid3, "invoicenumber", "invoiceid");
synchProductID = getTextSelectHiddenRowByCell(grid3, "productnumber", "productid");

}
return true;

}

function loadAllRowsGrid(synchInvoiceDetailID) {
var grid = ISGetObject("WebGrid3");
if (grid.TotalLoadedRows == grid.TotalRows)
return;
if (grid.IsInProgress)
setTimeout(function () { loadAllRowsGrid(synchInvoiceDetailID); }, 40000)
var row = grid.RootTable.GetRowByKeyValue(synchInvoiceDetailID);
if (!row) {
wgLoadMore('WebGrid3');
setTimeout(function () { loadAllRowsGrid(synchInvoiceDetailID); }, 40000)
} else {
row.Select();
}
}

function getRowIndexForHistory(controlId, cellInv, textInv, cellProd, textProd) {

var grid = wgGetGridById(controlId);
var TotalRows = grid.TotalRows;
var index = 0;
while (index < TotalRows) {
var row = grid.RootTable.GetRow(index);
var cells = row.GetCells();
if ((cells.GetNamedItem(cellInv).Text == textInv) && (cells.GetNamedItem(cellProd).Text == textProd))
return index;
index = index + 1;
}
return 0;
}

function getRowIndexByText(controlId, cellName, text) {
var grid = wgGetGridById(controlId);
var TotalRows = grid.TotalRows;
var index = 0;
while (index < TotalRows) {
var row = grid.RootTable.GetRow(index);
var cells = row.GetCells();
if (cells.GetNamedItem(cellName).Text == text)
return index;
index = index + 1;
}
return 0;
}

function findChildRow(controlId, cellNameChild, textChild) {

var grid = wgGetGridById(controlId);
var TotalRows = grid.TotalRows;
var index = 0;
var found = false;
while (index < TotalRows) {
grid.RootTable.GetRow(index).ExpandChildRow(true);
var childRows = grid.RootTable.GetRow(index).GetChildRows();
for (var j = 0; j < childRows.length; j++) {
var text = childRows[j].GetCells().GetNamedItem(cellNameChild).Value;
if (text == textChild) {
grid.RootTable.GetRow(index).Select();
childRows[j].Select();
j = childRows.length;
index = TotalRows;
found = true;
}
}
if (!found) {
grid.RootTable.GetRow(index).CollapseChildRow();
}
index = index + 1;
}

}

function expandChildRowAndSelectByKey(controlId, rowObject, TableName, textKey) {
if (!rowObject.ChildExpanded) {
rowObject.ExpandChildRow(true);
}
var grid = wgGetGridById(controlId);
var gridChild = grid.Tables[TableName];
//gridChild.Refresh();
gridChild.GetRowByKeyValue(textKey).Select();
}

function expandChildRowAndSelectByText(controlId, rowObject, cellName, textChild) {
if (!rowObject.ChildExpanded) {
rowObject.ExpandChildRow(true);
}
var childRows = rowObject.GetChildRows();
for (var j = 0; j < childRows.length; j++) {
var text = childRows[j].GetCells().GetNamedItem(cellName).Value;
if (text == textChild) {
childRows[j].Select();
j = childRows.length;
return true;
}
}
return false;
}

function getTextSelectRowByCell(controlId, cellName) {
var grid = wgGetGridById(controlId);
var selObject = grid.GetSelectedObject();
if (selObject) {
var row = selObject.ToRowObject();
if (row) {
var cells = row.GetCells();
var cellInvoiceNumber = cells.GetNamedItem(cellName);
if (cellInvoiceNumber) {
invoiceNumber = cells.GetNamedItem(cellName).Text;
return invoiceNumber;
}
}
}

return null;
}

function getTextSelectHiddenRowByCell(controlId, SourceCellName, HiddenCellName) {

var grid = wgGetGridById(controlId);
var selObject = grid.GetSelectedObject();
if (selObject) {
var row = selObject.ToRowObject();
if (row) {
var text = row.GetCell(SourceCellName).CellElement.getAttribute(HiddenCellName);
return text;
}
}
return null;
}

function WebGrid1_OnCellDoubleClick(controlId, tblName, rowIndex, cellIndex, cellEl) {

var creditnote = getQuerystring('creditnote');

var grd = ISGetObject(controlId);
var selRow = grd.GetSelectedObject().GetRowObject();

if (selRow.Type == "Record") {
var cells = selRow.GetCells();
var cellProductNumber = cells.GetNamedItem("productnumber");
var productNumber;

if (creditnote != "") {
if (selRow.Table.IsRootTable) {
var invoiceNr = cells.GetNamedItem("invoicenumber").Text;
var invoiceId = selRow.KeyValue;
try {
if (window.opener.CheckInvoiceId(invoiceNr)) {
window.opener.UpdateInvoice(invoiceNr, invoiceId);
}
else alert(msgCreditNotePrefix);
}
catch (err) { }
}
else {
var parentRow = selRow.GetParentRow();
var parentCells = parentRow.GetCells();
var invoiceNr = parentCells.GetNamedItem("invoicenumber").Text;
var invoiceId = parentRow.KeyValue;
try {
if (window.opener.CheckInvoiceId(invoiceNr)) {
window.opener.UpdateInvoice(invoiceNr, invoiceId);
}
else alert(msgCreditNotePrefix);
}
catch (err) { }
}
}
else {
if (cellProductNumber != null) {
var productId = selRow.GetCell('productnumber').CellElement.getAttribute('productid');
productNumber = cells.GetNamedItem("productnumber").Text;
// Now pass the value to the Parent form
if (window.opener != null) {
try {
window.opener.callEvent(productNumber, productId);
}
catch (err) {
//alert(msgPageNotValide);
}
}
}
}
}
return true;
}

function WebGrid2_OnCellDoubleClick(controlId, tblName, rowIndex, cellIndex, cellEl) {

var creditnote = getQuerystring('creditnote');
var grid2 = ISGetObject("WebGrid2");
var grd = ISGetObject(controlId);
var selRow = grd.GetSelectedObject().GetRowObject();
if (selRow.Type == "Record") {
var cells = selRow.GetCells();
var cellProductNumber = cells.GetNamedItem("productnumber");
var cellTProductCode = cells.GetNamedItem("TProductCode");
var productId;
if (creditnote != "") {
if (!selRow.Table.IsRootTable) {
var invoiceNr = cells.GetNamedItem("invoicenumber").Text;
var invoiceId = getTextSelectHiddenRowByCell(grid2, "speedy_invoicedate", "invoiceid");
try {
if (window.opener.CheckInvoiceId(invoiceNr)) {
window.opener.UpdateInvoice(invoiceNr, invoiceId);
}
else alert(msgCreditNotePrefix);
}
catch (err) { }
}

}
else {

var productNumber = null;
// Now pass the value to the Parent form
if (cellProductNumber != null) {
productId = selRow.GetCell('productnumber').CellElement.getAttribute('productid');
productNumber = cellProductNumber.Text;
}
else {
if (cellTProductCode != null) {
productId = productId = selRow.GetCell('TProductCode').CellElement.getAttribute('TProductID');
productNumber = cellTProductCode.Text;
}
}
if ((productNumber != null) && (productId != null)) {
if (window.opener != null) {
try {
window.opener.callEvent(productNumber, productId);
}
catch (err) {
//alert(msgPageNotValide);
}
}
}
}
}
return true;
}

function WebGrid3_OnCellDoubleClick(controlId, tblName, rowIndex, cellIndex, cellEl) {
var creditnote = getQuerystring('creditnote');
var grid3 = ISGetObject("WebGrid3");
var grd = ISGetObject(controlId);
var selRow = grd.GetSelectedObject().GetRowObject();
if (selRow.Type == "Record") {
var cells = selRow.GetCells();

if (creditnote != "") {
var invoiceNr = cells.GetNamedItem("invoicenumber").Text;
var invoiceId = getTextSelectHiddenRowByCell(grid3, "invoicenumber", "invoiceid");
try {
if (window.opener.CheckInvoiceId(invoiceNr)) {
window.opener.UpdateInvoice(invoiceNr, invoiceId);
}
else alert(msgCreditNotePrefix);
}
catch (err) { }
}
else {

var productId = selRow.GetCell('productnumber').CellElement.getAttribute('productid');
var productNumber = cells.GetNamedItem("productnumber").Text;
// Now pass the value to the Parent form
if (window.opener != null) {
try {
window.opener.callEvent(productNumber, productId);
}
catch (err) {
//alert(msgPageNotValide);
}
}
}
}

return true;
}

function refreshPage() {
window.location.reload();
}

</script>
<div>
<table style="width: 100%; height: 10%">
<tr>
<td style="width: 40%; text-align: left"><asp:Label Font-Bold="true" ID="Label1" runat="server" Text="Type"></asp:Label>
</td>

</tr>
</table>
</div>
<ISDataSource:ISDataSource ID="ISInvoiceDS" runat="server"
SchemaName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSet" EnableCaching="No">
<tables>
<ISDataSource:ISDataSourceTable SelectMethod="GetData"
TableName="p_ShowInvoiceHeader"
TypeName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSetTableAdapters.p_ShowInvoiceHeaderTableAdapter">
<SelectParameters>
<asp:QueryStringParameter Name="accountID" QueryStringField="accountid"
Type="Object" />
<asp:QueryStringParameter Name="UserLCID" QueryStringField="UserLCID"
Type="String" />
<asp:QueryStringParameter Name="OrgLCID" QueryStringField="OrgLCID"
Type="String" />
</SelectParameters>
</ISDataSource:ISDataSourceTable>
<ISDataSource:ISDataSourceTable SelectMethod="GetData" TableName="p_ShowInvoiceDetails"
TypeName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSetTableAdapters.p_ShowInvoiceDetailsTableAdapter"
DataObjectTypeName="System.Nullable`1[[System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]">
<SelectParameters>
<asp:QueryStringParameter Name="accountID" QueryStringField="accountid"
Type="Object" />

</SelectParameters>
</ISDataSource:ISDataSourceTable>
</tables>
</ISDataSource:ISDataSource>
<ISDataSource:ISDataSource ID="ISSoldProducts" runat="server"
SchemaName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSet" EnableCaching="No">
<tables>
<ISDataSource:ISDataSourceTable SelectMethod="GetData" TableName="SoldProducts"

TypeName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSetTableAdapters.SoldProductsTableAdapter"
DataObjectTypeName="System.Nullable`1[[System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]">
<SelectParameters>
<asp:QueryStringParameter Name="accountid" QueryStringField="accountid"
Type="Object" />
</SelectParameters>
</ISDataSource:ISDataSourceTable>
<ISDataSource:ISDataSourceTable SelectMethod="GetData"
TableName="p_ShowInvoiceDetails"

TypeName="Wuerth.Phoenix.Speedy.OrderlineGrid.InvoiceHistoryTask.InvoiceHistoryGridDataSetTableAdapters.p_ShowInvoiceDetailsTableAdapter"
DataObjectTypeName="System.Nullable`1[[System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]">
<SelectParameters>
<asp:QueryStringParameter Name="accountID" QueryStringField="accountid"
Type="Object" />
</SelectParameters>
</ISDataSource:ISDataSourceTable>
</tables>
</ISDataSource:ISDataSource>

<asp:HiddenField ID="HiddenFieldShowInvCommission" Value="false" runat="server" />

<table style="width: 100%; height: 90%; overflow:auto;">

<tr>
<td>
<ISWebDesktop:WebTab ID="WebTabHI" runat="server" ActiveTabIndex="1">
<FrameStyle Overflow="Scroll" OverflowY="Scroll" OverflowX="Scroll" Height="100%">
</FrameStyle>
<ContainerStyle Overflow="Auto" OverflowY="Auto" OverflowX="Auto" BackColor="#EAF3FF" Height="100%" Width="100%"
BorderColor="#C5C5C5" BorderStyle="Solid" BorderWidth="1px" > <Padding Top="0px" Left="0px" Right="0px" Bottom="0px"></Padding>
</ContainerStyle>
<RoundCornerSettings TopBorderColor="230, 139, 44" FillerBorderColor="255, 199, 60">
</RoundCornerSettings>
<DisabledStyle ForeColor="Gray" BackColor="#EAF3FF" BorderColor="#C5C5C5" Font-Names="Tahoma"
Font-Size="9pt" >
</DisabledStyle>
<TabPages>
<ISWebDesktop:WebTabItem Name="Invoices" Text="Invoices">
<PageTemplate>

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" DataMember="p_ShowInvoiceHeader" DataSourceID="ISInvoiceDS" OnInitializeLayout="WebGrid1_InitializeLayout" OnInitializeRow="WebGrid1_InitializeRow" OnInitializePostBack="WebGrid1_InitializePostBack"
DefaultStyleMode="Win7" UseDefaultStyle="True" Height="100%" Width="100%">
<LayoutSettings AllowSorting="Yes" Hierarchical="true" AutoHeight="false" RowHeightDefault="-1" AutoFitColumns="true" AllowFilter="Yes" FilterBarVisible="true" PagingMode="VirtualLoad" VirtualPageSize="45">
<ClientSideEvents OnCellDblClick="WebGrid1_OnCellDoubleClick" OnChildRowCollapse="WebGrid1_OnChildRowCollapse"/>
<TextSettings Language="UseCustom" />
</LayoutSettings>
<RootTable Caption="Invoices" DataMember="p_ShowInvoiceHeader" DataKeyField="invoiceid" AllowFilter="Yes" >
<SelectedRowStyle BackColor="LightBlue" />
<ChildTables>
<ISWebGrid:WebGridTable Caption="Invoice Details" DataMember="p_ShowInvoiceDetails" DataKeyField="invoicedetailid" AllowFilter="Yes" AutomaticFilter="true" >
<SelectedRowStyle BackColor="LightBlue" />
<Columns>
<ISWebGrid:WebGridColumn Caption="InvoiceDetailID" DataMember="invoicedetailid" Name="invoicedetailid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="ProductID" DataMember="productid" Name="productid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Pos" DataMember="lineitemnumber" Name="lineitemnumber" Visible="true" Width="30px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Cust.Ord.Ref." DataMember="speedy_customerorderreference" Name="speedy_customerorderreference" Visible="true" Width="60px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Product Number" DataMember="productnumber" HiddenDataMember="productid" Name="productnumber" ColumnType="Custom" TreatMarkupAsLiteralText="true" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Product Name" DataMember="productname" HiddenDataMember="invoicedetailid" Name="productname" AllowMultiLine="true" TreatMarkupAsLiteralText="true" Visible="true" Width="130px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Cust.Prod.Ref." DataMember="speedy_custprodreference" Name="speedy_custprodreference" Visible="true" Width="60px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="speedy_prodgroupdes c" InputRequired="false" DataMember="speedy_prodgroupdes" Name="speedy_prodgroupdes" Width="50px" EditType="NoEdit">
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Quantity" DataFormatString="#0" DataMember="quantity" Name="quantity" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Type" DataMember="pricetype" Name="pricetype" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="ListName" DataMember="speedy_pricelistname" Name="speedy_pricelistname" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="GrossPrice" DataFormatString="c" DataMember="speedy_grossprice" Name="speedy_grossprice" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Price" DataFormatString="c" DataMember="priceperunit" Name="priceperunit" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn DataFormatString="#" Caption="Unit" DataType="System.Int32" DataMember="priceunit" Name="priceunit" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Disc1.%" DataFormatString="#0" DataMember="speedy_discount1" Name="speedy_discount1" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Disc2.%" DataFormatString="#0" DataMember="speedy_discount2" Name="speedy_discount2" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="DiscAmount" DataFormatString="c" DataMember="speedy_discountamount" Name="speedy_discountamount" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Provv.%" DataFormatString="#0" DataMember="speedy_commission" Name="speedy_commission" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Provv." DataFormatString="c" DataMember="speedy_commissionvalue" Name="speedy_commissionvalue" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Order Date" DataType="System.DateTime" DataFormatString="d" DataMember="speedy_orderdate" Name="speedy_orderdate" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Ord.ID" DataMember="speedy_orderid" Name="speedy_orderid" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Ord.Pos." DataMember="speedy_orderposid" Name="speedy_orderposid" Visible="true" Width="70px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Total Net Value" DataMember="speedy_totalnetvalue" DataFormatString="c" Name="speedy_totalnetvalue" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Seller Support" DataMember="speedy_support" Name="speedy_support" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Office" DataMember="speedy_office" Name="speedy_office" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Person" DataMember="speedy_person" Name="speedy_person" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
</Columns>
<SortedColumns>
<ISWebGrid:WebGridGroup ColumnMember="lineitemnumber" SortOrder="Ascending" />
</SortedColumns>
</ISWebGrid:WebGridTable>
</ChildTables>
<Columns>
<ISWebGrid:WebGridColumn Caption="ProductID" DataMember="productid" Name="productid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="InvoiceID" DataMember="invoiceid" Name="invoiceid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="InvoicedetailID" DataMember="invoicedetailid" Name="invoicedetailid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Invoice Number" DataMember="invoicenumber" HiddenDataMember="invoiceid" Name="invoicenumber" ColumnType="Custom" TreatMarkupAsLiteralText="true" Visible="true" Width="150px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Invoice Date" DataMember="speedy_invoicedate" HiddenDataMember="productid" Name="speedy_invoicedate" DataType="System.DateTime" DataFormatString="d" Visible="true" Width="100px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Cust.Ord.Ref." DataMember="speedy_customerorderreference" Name="speedy_customerorderreference" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Order ID" DataMember="speedy_orderid" HiddenDataMember="speedy_orderid" Name="speedy_orderid" Visible="true" Width="150px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Payment" DataMember="speedy_paytype" Name="speedy_paytype" Visible="false" Width="100px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="TermsOfPay" DataMember="paymenttermscode" Name="paymenttermscode" Visible="true" Width="150px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Day1" DataMember="speedy_day1" Name="speedy_day1" Visible="false" Width="50px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Day2" DataMember="speedy_day2" Name="speedy_day2" Visible="false" Width="50px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Day3" DataMember="speedy_day3" Name="speedy_day3" Visible="false" Width="50px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Amount" DataFormatString="c" DataMember="totalamount" Name="totalamount" Visible="true" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Seller" DataMember="speedy_sellercreate" Name="speedy_sellercreate" Visible="false" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Exp.%" DataFormatString="#0.00" DataMember="speedy_expencespercent" Name="speedy_expencespercent" Visible="true" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Exp." DataFormatString="c" DataMember="speedy_expencesvalue" Name="speedy_expencesvalue" Visible="true" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Provv.%" DataFormatString="#0" DataMember="speedy_provisionpercent" Name="speedy_provisionpercent" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Provv." DataFormatString="c" DataMember="speedy_provisionvalue" Name="speedy_provisionvalue" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Freight A." DataMember="FreightAmount" Name="FreightAmount" DataFormatString="c" Visible="true" Width="80px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
</Columns>
<SortedColumns>
<ISWebGrid:WebGridGroup ColumnMember="invoicenumber" SortOrder="Descending" />
</SortedColumns>
</RootTable>
</ISWebGrid:WebGrid>
</PageTemplate>
</ISWebDesktop:WebTabItem>
<ISWebDesktop:WebTabItem Name="SoldProducts" Text="Sold Products">
<PageTemplate>

<ISWebGrid:WebGrid ID="WebGrid2" runat="server" DataMember="SoldProducts" OnInitializeLayout="WebGrid2_InitializeLayout" OnInitializeRow="WebGrid2_InitializeRow"
DataSourceID="ISSoldProducts" DefaultStyleMode="Win7" UseDefaultStyle="true" Height="100%" Width="100%" >
<LayoutSettings AllowSorting="Yes" Hierarchical="true" AutoHeight="false" RowHeightDefault="-1" AllowFilter="Yes" FilterBarVisible="true" AutoFitColumns="True" PagingMode="VirtualLoad" VirtualPageSize="45">
<ClientSideEvents OnCellDblClick="WebGrid2_OnCellDoubleClick" OnKeyDown="WebGrid2_OnKeydown" OnRowSelect="WebGrid2_OnRowSelect" OnChildRowCollapse="WebGrid2_OnChildRowCollapse"/>
<TextSettings Language="UseCustom" />
</LayoutSettings>
<RootTable Caption="SoldProducts" DataMember="SoldProducts" DataKeyField="TProductID" AllowFilter="Yes">
<SelectedRowStyle BackColor="LightBlue" />
<ChildTables>
<ISWebGrid:WebGridTable Caption="Invoice Details" DataMember="p_ShowInvoiceDetails" DataKeyField="invoicedetailid" AllowFilter="Yes" AutomaticFilter="true">
<SelectedRowStyle BackColor="LightBlue" />
<Columns>
<ISWebGrid:WebGridColumn Caption="ProductID" DataMember="productid" Name="productid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="InvoiceID" DataMember="invoiceid" Name="invoiceid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Invoice Number" DataMember="invoicenumber" Name="invoicenumber" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Invoice Date" DataMember="speedy_invoicedate" HiddenDataMember="invoiceid" Name="speedy_invoicedate" DataType="System.DateTime" DataFormatString="d" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Pos" DataMember="lineitemnumber" Name="lineitemnumber" Visible="true" Width="30px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Product Number" DataMember="productnumber" HiddenDataMember="productid" Name="productnumber" ColumnType="Custom" TreatMarkupAsLiteralText="true" Visible="true" Width="100px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Cust.Prod.Ref." DataMember="speedy_custprodreference" Name="speedy_custprodreference" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Product Name" DataMember="productname" HiddenDataMember="invoicedetailid" Name="productname" ColumnType="Custom" TreatMarkupAsLiteralText="true" Visible="true" Width="120px">
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Quantity" DataFormatString="#0" DataMember="quantity" Name="quantity" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Type" DataMember="pricetype" Name="pricetype" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="ListName" DataMember="speedy_pricelistname" Name="speedy_pricelistname" Visible="true" Width="80px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="GrossPrice" DataFormatString="c" DataMember="speedy_grossprice" Name="speedy_grossprice" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Price" DataFormatString="c" DataMember="priceperunit" Name="priceperunit" Visible="true" Width="80px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn DataFormatString="#" Caption="Unit" DataType="System.Int32" DataMember="priceunit" Name="priceunit" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Disc.1%" DataFormatString="#0" DataMember="speedy_discount1" Name="speedy_discount1" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Disc.2%" DataFormatString="#0" DataMember="speedy_discount2" Name="speedy_discount2" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="DiscAmount" DataFormatString="c" DataMember="speedy_discountamount" Name="speedy_discountamount" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Provv.%" DataFormatString="#0" DataMember="speedy_commission" Name="speedy_commission" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Provv." DataFormatString="c" DataMember="speedy_commissionvalue" Name="speedy_commissionvalue" Visible="true" Width="50px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Order Date" DataType="System.DateTime" DataFormatString="d" DataMember="speedy_orderdate" Name="speedy_orderdate" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Ord.ID" DataMember="speedy_orderid" Name="speedy_orderid" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Ord.Pos." DataMember="speedy_orderposid" Name="speedy_orderposid" Visible="true" Width="70px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Total Net Value" DataMember="speedy_totalnetvalue" DataFormatString="c" Name="speedy_totalnetvalue" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Seller Support" DataMember="speedy_support" Name="speedy_support" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Office" DataMember="speedy_office" Name="speedy_office" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Person" DataMember="speedy_person" Name="speedy_person" Visible="true" Width="70px">
</ISWebGrid:WebGridColumn>

</Columns>
<SortedColumns>
<ISWebGrid:WebGridGroup ColumnMember="speedy_invoicedate" SortOrder="Descending" />
</SortedColumns>
</ISWebGrid:WebGridTable>
</ChildTables>
<Columns>
<ISWebGrid:WebGridColumn Caption="InvoiceID" DataMember="invoiceid" Name="invoiceid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="InvoiceDetailID" DataMember="invoicedetailid" Name="invoicedetailid" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="ProductID" DataMember="TProductID" Name="TProductID" Visible="false" Width="0px">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Product Code" DataMember="TProductCode" HiddenDataMember="TProductID" Name="TProductCode" Width="120px" ColumnType="Custom" TreatMarkupAsLiteralText="true">
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="Description" DataMember="TDescription" HiddenDataMember="invoiceid" Name="TDescription" ColumnType="Custom" TreatMarkupAsLiteralText="true" AllowMultiLine="true" Width="250px">
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="speedy_prodgroupdes c" InputRequired="false" DataMember="speedy_prodgroupdes" Name="speedy_prodgroupdes" Width="100px" EditType="NoEdit">
</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="Freq" DataFormatString="#0" DataMember="TFreq" HiddenDataMember="invoicedetailid" Name="TFreq" ColumnType="Custom" TreatMarkupAsLiteralText="true" Width="90px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="SumQty" DataFormatString="#0" DataMember="TSumQty" Name="TSumQty" Width="100px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="AccTurnover" DataFormatString="c" DataMember="TAccTurnover" Name="TAccTurnover" Width="150px">
<CellStyle HorizontalAlign="Right">
</CellStyle>
</ISWebGrid:WebGridColumn>
<ISWebGrid:WebGridColumn Caption="LastOrderDate" DataType="System.DateTime" DataFormatString="d" DataMember="TLastOrderDate" Name="TLastOrderDate" Width="120px">
</ISWebGrid:WebGridColumn>
</Columns>
<SortedColumns>
<ISWebGrid:WebGridGroup ColumnMember="TProductCode" SortOrder="Ascending" />
</SortedColumns>
</RootTable>
</ISWebGrid:WebGrid>
</PageTemplate>
</ISWebDesktop:WebTabItem>
</TabPages>
<TabItemStyle>
<Normal Cursor="Hand" BackColor="#EAF3FF" BorderColor="#C5C5C5" BorderStyle="Solid"
BorderWidth="1px" Font-Names="Tahoma" Font-Size="9pt" Height="100%" Width="100%">
<Padding Top="2px" Left="10px" Right="10px" Bottom="0px"></Padding>
</Normal>
<Over BaseStyle="Normal" BackColor="#EAE3FF" BorderColor="#C5C5C5" BorderStyle="Solid"
BorderWidth="1px" Font-Names="Tahoma" Font-Size="9pt">
</Over>
<Active BaseStyle="Normal" BackColor="#EAF3FF" BorderColor="#C5C5C5" BorderStyle="Solid"
BorderWidth="1px" Font-Names="Tahoma" Font-Size="9pt">
</Active>
</TabItemStyle>
</ISWebDesktop:WebTab>
</td>
</tr>
</table>
<asp:ScriptManager ID="InvoiceHistoryScriptManager" runat="server">
<CompositeScript>
<Scripts>
<asp:ScriptReference Path="../script/shortcut.js"/>
<asp:ScriptReference Path="../script/Utility.js"/>
</Scripts>
</CompositeScript>
</asp:ScriptManager>
</form>
</body>
</html>

Quick Reply

Quote

Services

Support

Community / WebGrid

strange behaviour when collapse

Answers

All Replies

Business Platform

Development Tools

Community / WebGrid

strange behaviour when collapse

Answers

All Replies

Sign in to Intersoft Account

Sign in to Intersoft Account

Link Existing Account

Create New Account

Link Existing Account

Sign in to Intersoft Account

Sign in to Intersoft Account

Create New Intersoft Account

Forgot Password

Your new password has been sent to your email.