Add column to existing E-10

Yahoo Archive
1

Thank you Rob,

 

Changing it to  Infragistics.Win.UltraWinGrid.InitializeRowEventHandler worked.    I’m assuming you use one or the other based on the type of grid ?

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 10, 2016 4:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

In your class declaration drop the private on

Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;

 

Try

grdreceiptsview.InitializeRow+= new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdreceiptsview _InitializeRow);

 

 

Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St. | PO Box 279

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...

Visit our newly redesigned Website at www.dsmfg.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 10, 2016 6:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

Can anybody see what I might be  missing ? I’m trying to add a column to an  AP invoice entry grid and it won’t compile I get this error:  Error: CS0426 - line 42 (448) - The type name 'InitializeRowEventHandler' does not exist in the type 'Ice.Lib.Framework.EpiUltraGrid' .

 

Here's part of the code.

 

// Begin Wizard Added Module Level Variables **

private Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;

private Ice.Proxy.Lib.BOReaderImpl _bor;

                // End Wizard Added Module Level Variables **

 

                // Add Custom Module Level Variables Here **

 

                public void InitializeCustomCode()

                {

                                // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

                                // Begin Wizard Added Variable Initialization

 

                                // End Wizard Added Variable Initialization

 

                                // Begin Wizard Added Custom Method Calls

 

                                // End Wizard Added Custom Method Calls

               

                grdreceiptsview =(Ice.Lib.Framework.EpiUltraGrid)csm.GetNativeControlReference("0e165491-a688-4d5c-aa9d-642135d51e15-1");

                grdreceiptsview.DisplayLayout.Bands[0].Columns.Add("Taxable"," PO Taxable");

              grdreceiptsview.InitializeRow+= new Ice.Lib.Framework.EpiUltraGrid.InitializeRowEventHandler(grdreceiptsview_InitializeRow);

              _bor = WCFServiceSupport.CreateImpl<Ice.Proxy.Lib.BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);

                }

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 9, 2016 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

Thanks Patrick. That worked.

2
Hi,

So I would like to know what the difficulty level would be to add a column to an existing grid view.

Here's what I'm looking for:

In the Work queue screen on the MES, it lists the job number and asm sequence, which is good enough to identify the traveler. But if someone wants to do the same part numbers together, it's hard for them to find them on the list. (We are an engineer to order so we will have the same part in a lot of different assemblies for the same job, but they come down with separate travelers because everything is to order, not stocked). If they could have the part number as a column, the could then sort by part number and clock into all of them at once with only a few clicks, and would have a good validation that they have all of the parts that they should for that job.

Is this possible? With my dashboards I would just add the filed to the query and it would show up. BUT, I don't think that the query from Epicor is visible (or is it?) so how can I add a column.

Thanks,
Brandon


3
Here’s a customization where I added a column to part advisor using the boReader to get the added information. Depending on the information returned and the number of rows present in your grid view (because it will perform a look up for each row) you may get a performance hit.


public class Script
{
// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **
// Begin Wizard Added Module Level Variables **

// End Wizard Added Module Level Variables **

// Add Custom Module Level Variables Here **
Ice.Lib.Framework.EpiUltraGrid grdinvoiceview;
Ice.Proxy.Lib.BOReaderImpl _bor;

public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization

// End Wizard Added Variable Initialization

// Begin Wizard Added Custom Method Calls

// End Wizard Added Custom Method Calls
/* Change the GUID below to the grid you want to add your column to */
grdinvoiceview = (Ice.Lib.Framework.EpiUltraGrid)csm.GetNativeControlReference("0f6f0566-39c9-476c-b570-95e7aa2d4460");
/* Next two lines are the custom columns added */
grdinvoiceview.DisplayLayout.Bands[0].Columns.Add("JobNum","Job Number");
grdinvoiceview.DisplayLayout.Bands[0].Columns.Add("CustomerPO","Customer PO");
grdinvoiceview.InitializeRow+= new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdinvoiceview_InitializeRow);
_bor = WCFServiceSupport.CreateImpl<Ice.Proxy.Lib.BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);

}

public void DestroyCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Object Disposal' lines **
// Begin Wizard Added Object Disposal

// End Wizard Added Object Disposal

// Begin Custom Code Disposal

grdinvoiceview.InitializeRow -= new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdinvoiceview_InitializeRow);

// End Custom Code Disposal
}

private void grdinvoiceview_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
{
/* change OrderDtlSearch to the BO you are getting your info from, change values in whereclause to your specific search string needed
“Character01, JobNum” change these the the columns you want returned from your query */
DataSet dso = _bor.GetRows("OrderDtlSearch", "OrderNum = " + e.Row.Cells["OrderNum"].Value.ToString() + " and OrderLine = " + e.Row.Cells["OrderLine"].Value.ToString(), "Character01, JobNum");
if(dso.Tables[0].Rows.Count>0)
{
/* Set your custom columns to the value of the columns returned above */
e.Row.Cells["CustomerPO"].Value = dso.Tables[0].Rows[0]["Character01"].ToString();
e.Row.Cells["JobNum"].Value = dso.Tables[0].Rows[0]["JobNum"].ToString();
}
}
}

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 9, 2016 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] add column to existing E-10



Hi,

So I would like to know what the difficulty level would be to add a column to an existing grid view.

Here's what I'm looking for:

In the Work queue screen on the MES, it lists the job number and asm sequence, which is good enough to identify the traveler. But if someone wants to do the same part numbers together, it's hard for them to find them on the list. (We are an engineer to order so we will have the same part in a lot of different assemblies for the same job, but they come down with separate travelers because everything is to order, not stocked). If they could have the part number as a column, the could then sort by part number and clock into all of them at once with only a few clicks, and would have a good validation that they have all of the parts that they should for that job.

Is this possible? With my dashboards I would just add the filed to the query and it would show up. BUT, I don't think that the query from Epicor is visible (or is it?) so how can I add a column.

Thanks,
Brandon





[Non-text portions of this message have been removed]
4
Sorry I am 9.05 - so I don't know if Part# is for sure still available in the collection in E10m but it is on 9.05
5
Part# is already an available field in the collection you just need to toggle is to un-hide it then move it over so they can see it without having to scroll.
6
Dumb question here. How/where do I toggle the hide/unhide columns? Is that is customization? Or is it available in personalization?
7
you can actually do it either way. in customization mode - click on the
grid so it is active. then in the properties box under layout, where it
says Columns it will say (Collection). click on this and then the little
dropdown next to it and it will show you all of the available columns in
that grid. form there you can hide/unhide them. This is 9.05 I am not
sure it is the same in 10.
[image: Inline image 1]



*This e-mail may contain information which is confidential or privileged.
The information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, be aware that any
disclosure, copying, distribution or use of the contents of this e-mail is
prohibited. In the event of any error in transmission, unauthorized
recipients are requested to contact the sender immediately and not to
disclose or make use of this information. No employee or agent is
authorized to conclude any binding agreement on behalf of NyproMold with
another party by email without express written confirmation by NyproMold
Offices.*

P *Please consider the environmental impact of printing this e-mail.*


[Non-text portions of this message have been removed]
8
That's great! I figured out where it was from your help and we should be able to get it rolled out to the shop floor here soon.
9
So we were able to add the column, does anyone know how to re-order the columns within the customization? It looks like it shows up at the end no matter what. Does one have to remove all of the columns and then add them in the order you want then to show up? Or is there a way to just change the order? 
10


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Mon, May 9, 2016 at 3:26 PM, brandonanderson7979@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>So we were able to add the column, does anyone know how to re-order the columns within the customization? It looks like it shows up at the end no matter what. Does one have to remove all of the columns and then add them in the order you want then to show up? Or is there a way to just change the order? </p>

</div><span class="ygrps-yiv-1944230136">
 


<div style="color:#fff;min-height:0;"></div>


11

I have had luck in version 9.05.702 loading the personalization of the customization and saving it as a new customization which then kept the column order and tab order (sometimes.)

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 09, 2016 14:26
To: vantage@yahoogroups.com
Subject: [Vantage] Re: add column to existing E-10

 

 

So we were able to add the column, does anyone know how to re-order the columns within the customization? It looks like it shows up at the end no matter what. Does one have to remove all of the columns and then add them in the order you want then to show up? Or is there a way to just change the order? 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  
12
Thanks Patrick. That worked.
13

Can anybody see what I might be  missing ? I’m trying to add a column to an  AP invoice entry grid and it won’t compile I get this error:  Error: CS0426 - line 42 (448) - The type name 'InitializeRowEventHandler' does not exist in the type 'Ice.Lib.Framework.EpiUltraGrid' .

 

Here's part of the code.

 

// Begin Wizard Added Module Level Variables **

private Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;

private Ice.Proxy.Lib.BOReaderImpl _bor;

                // End Wizard Added Module Level Variables **

 

                // Add Custom Module Level Variables Here **

 

                public void InitializeCustomCode()

                {

                                // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

                                // Begin Wizard Added Variable Initialization

 

                                // End Wizard Added Variable Initialization

 

                                // Begin Wizard Added Custom Method Calls

 

                                // End Wizard Added Custom Method Calls

               

                grdreceiptsview =(Ice.Lib.Framework.EpiUltraGrid)csm.GetNativeControlReference("0e165491-a688-4d5c-aa9d-642135d51e15-1");

                grdreceiptsview.DisplayLayout.Bands[0].Columns.Add("Taxable"," PO Taxable");

              grdreceiptsview.InitializeRow+= new Ice.Lib.Framework.EpiUltraGrid.InitializeRowEventHandler(grdreceiptsview_InitializeRow);

              _bor = WCFServiceSupport.CreateImpl<Ice.Proxy.Lib.BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);

                }

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 9, 2016 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

Thanks Patrick. That worked.

14

In your class declaration drop the private on

Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;

 

Try

grdreceiptsview.InitializeRow+= new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdreceiptsview _InitializeRow);

 

 

Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St. | PO Box 279

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...

Visit our newly redesigned Website at www.dsmfg.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 10, 2016 6:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

Can anybody see what I might be  missing ? I’m trying to add a column to an  AP invoice entry grid and it won’t compile I get this error:  Error: CS0426 - line 42 (448) - The type name 'InitializeRowEventHandler' does not exist in the type 'Ice.Lib.Framework.EpiUltraGrid' .

 

Here's part of the code.

 

// Begin Wizard Added Module Level Variables **

private Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;

private Ice.Proxy.Lib.BOReaderImpl _bor;

                // End Wizard Added Module Level Variables **

 

                // Add Custom Module Level Variables Here **

 

                public void InitializeCustomCode()

                {

                                // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

                                // Begin Wizard Added Variable Initialization

 

                                // End Wizard Added Variable Initialization

 

                                // Begin Wizard Added Custom Method Calls

 

                                // End Wizard Added Custom Method Calls

               

                grdreceiptsview =(Ice.Lib.Framework.EpiUltraGrid)csm.GetNativeControlReference("0e165491-a688-4d5c-aa9d-642135d51e15-1");

                grdreceiptsview.DisplayLayout.Bands[0].Columns.Add("Taxable"," PO Taxable");

              grdreceiptsview.InitializeRow+= new Ice.Lib.Framework.EpiUltraGrid.InitializeRowEventHandler(grdreceiptsview_InitializeRow);

              _bor = WCFServiceSupport.CreateImpl<Ice.Proxy.Lib.BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);

                }

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 9, 2016 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10

 

 

Thanks Patrick. That worked.

15
Also make sure you have in your usings
using Ice.Lib.Framework;

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 10, 2016 6:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10


Can anybody see what I might be missing ? I’m trying to add a column to an AP invoice entry grid and it won’t compile I get this error: Error: CS0426 - line 42 (448) - The type name 'InitializeRowEventHandler' does not exist in the type 'Ice.Lib.Framework.EpiUltraGrid' .

Here's part of the code.

// Begin Wizard Added Module Level Variables **
private Ice.Lib.Framework.EpiUltraGrid grdreceiptsview;
private Ice.Proxy.Lib.BOReaderImpl _bor;
// End Wizard Added Module Level Variables **

// Add Custom Module Level Variables Here **

public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Variable Initialization

// End Wizard Added Variable Initialization

// Begin Wizard Added Custom Method Calls

// End Wizard Added Custom Method Calls

grdreceiptsview =(Ice.Lib.Framework.EpiUltraGrid)csm.GetNativeControlReference("0e165491-a688-4d5c-aa9d-642135d51e15-1");
grdreceiptsview.DisplayLayout.Bands[0].Columns.Add("Taxable"," PO Taxable");
grdreceiptsview.InitializeRow+= new Ice.Lib.Framework.EpiUltraGrid.InitializeRowEventHandler(grdreceiptsview_InitializeRow);
_bor = WCFServiceSupport.CreateImpl<Ice.Proxy.Lib.BOReaderImpl>((Ice.Core.Session)oTrans.Session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BOReaderSvcContract>.UriPath);
}




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, May 9, 2016 1:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: add column to existing E-10



Thanks Patrick. That worked.



[Non-text portions of this message have been removed]