I think you also need to add the order number and line number in your whereclause, currently you only have the orderrelnum which isn’t enough for the BO to return the record youre looking for…
DataSet ds = _boReader.GetRows("OrderRel", "OrderNum = " + e.Row.Cells["OrderNum"].Value.ToString() + " and OrderLine = " + e.Row.Cells["OrderLine"].Value.ToString() + " and OrderRelNum='"+e.Row.Cells["OrderRel"].Value.ToString()+"'","ShortChar01");
I didn’t test out all the syntax..
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:
1.234354861@...]<
http://www.dsmfg.com/>
(Click the logo to view our site)<
http://www.dsmfg.com/>
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of
sel.michal@...
Sent: Monday, October 28, 2013 10:58 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] RE: UltraGridID
Hi,
could you please help me with the column addition? I have followed your guide but it seems something is wrong in my code. I need to addd OrderRel.ShortChar01 to Picked Orders List (Cust. Shipment Entry - Actions), after saving customization I can see new column there but without data
grdPickedOrders = (Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("65ef8a4d-0c7d-45a7-8c65-6ff73cf71cb1");
grdPickedOrders.DisplayLayout.Bands[0].Columns.Add("ShortChar01", "Project").Header.VisiblePosition = 0;
grdPickedOrders.InitializeRow += new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdPickedOrders_InitializeRow);
_boReader = new BOReader(((Session)oTrans.Session).ConnectionPool);
}
private void grdPickedOrders_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
{
if (!String.IsNullOrEmpty(e.Row.Cells["OrderRelNum"].Value.ToString()))
{
DataSet ds = _boReader.GetRows("OrderRel","OrderRelNum='"+e.Row.Cells["OrderRel"].Value.ToString()+"'","ShortChar01");
if(ds.Tables[0].Rows.Count>0)
e.Row.Cells["ShortChar01"].Value=ds.Tables[0].Rows[0]["ShortChar01"];
}
}
public void DestroyCustomCode()
{
grdPickedOrders.InitializeRow -= new Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdPickedOrders_InitializeRow);
}
}
Thank you,
Michal
---In
vantage@yahoogroups.com, <lisa.saren@...> wrote:
Ooh, as simple as that. Thank you so much for your reply!!
Have nice day,
//Lisa
--- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@...> wrote:
>
> That means that Date01 is already avaiable simply go to the UltraGrid
> Properties and make it visible :)
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Thu, Apr 4, 2013 at 7:15 AM, lisassar <lisa.saren@...> wrote:
>
> > **
> >
> >
> > Nothing in the server log, but the error message has the following details:
> >
> > Stack Trace
> > ===========
> > at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[]
> > arguments, SignatureStruct& sig, MethodAttributes methodAttributes,
> > RuntimeTypeHandle typeOwner)
> > at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[]
> > arguments, Signature sig, MethodAttributes methodAttributes,
> > RuntimeTypeHandle typeOwner)
> > at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> > invokeAttr, Binder binder, Object[] parameters, CultureInfo culture,
> > Boolean skipVisibilityChecks)
> > at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> > invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> > at
> > Epicor.Mfg.UI.Customization.CustomScriptMethodInvoker.InvokeScriptMethod(MethodInfo
> > scriptMethod, Object[] parameters)
> > at
> > Epicor.Mfg.UI.Customization.CustomScriptMethodInvoker.InvokeInitializeCustomCodeIfExists()
> > at
> > Epicor.Mfg.UI.Customization.CustomScriptManager.TryActionShowExceptionBoxOrLogVerificationErrorIfException(Action
> > action, String exceptionBoxTitle)
> >
> > Inner Exception
> > ===============
> > Key already exists
> > Parameter name: Key
> >
> > Inner Stack Trace
> > =================
> > at
> > Infragistics.Shared.KeyedSubObjectsCollectionBase.ValidateKeyDoesNotExist(String
> > key, IKeyedSubObject ignoreObject)
> > at
> > Infragistics.Shared.KeyedSubObjectsCollectionBase.ValidateKeyDoesNotExist(String
> > key)
> > at Infragistics.Win.UltraWinGrid.ColumnsCollection.Add(String key, String
> > caption)
> > at Script.InitializeCustomCode()
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@> wrote:
> > >
> > > What is the exception?
> > > On Apr 4, 2013 5:50 AM, "lisassar" <lisa.saren@> wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Was looking for a solution for a similar problem. Trying to add a
> > column
> > > > to the PO Entry Summary, Inventory grid list with the field
> > > > (PODetail.Date01).
> > > >
> > > > When I use the guide you so nicely shares on your webpage I get a error
> > > > (Exception has been thrown by the target of an invocation.) when I try
> > > > Columns.Add("Date01"), if i try Add.(PODetail.Date01) instead the
> > columns
> > > > shows without any errormessage, but no value is populating.
> > > >
> > > > Got any idea what I'm doing wrong here?
> > > >
> > > > Epicor.Mfg.UI.FrameWork.EpiUltraGrid mygrid;
> > > > BOReader _boReader;
> > > > 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
> > > > mygrid =
> > > >
> > (Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("619b890f-7d96-4dbe-9309-fd59da524a6a");
> > > > mygrid.DisplayLayout.Bands[0].Columns.Add("Date01", "Ship
> > > > Date").Header.VisiblePosition = 0;
> > > > mygrid.InitializeRow += new
> > > >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(gridMatList_InitializeRow);
> > > > _boReader = new BOReader(((Session)oTrans.Session).ConnectionPool);
> > > >
> > > > this.dteConfDate.ValueChanged += new
> > > > System.EventHandler(this.dteConfDate_ValueChanged);
> > > > // End Wizard Added Custom Method Calls
> > > > }
> > > >
> > > > private void gridMatList_InitializeRow(object sender,
> > > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> > > > {
> > > > if (!String.IsNullOrEmpty(e.Row.Cells["POLine"].Value.ToString()))
> > > > {
> > > > DataSet ds =
> > > >
> > _boReader.GetRows("PO","POLine='"+e.Row.Cells["POLine"].Value.ToString()+"'","Date01");
> > > >
> > > > if(ds.Tables[0].Rows.Count>0)
> > > > e.Row.Cells["Date01"].Value=ds.Tables[0].Rows[0]["Date01"];
> > > > }
> > > >
> > > > }
> > > >
> > > > }
> > > >
> > > > Kind regards
> > > > Lisa
> > > >
> > > > --- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@> wrote:
> > > > >
> > > > > Here you go, hopefully this helps
> > > > >
> > > > >
> > > >
> > http://www.usdoingstuff.com/2012/06/15/add-column-to-grid-in-epicor-specifically-to-chart-tracker/
> > > > >
> > > > >
> > > > > Thanks!
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *
> > > > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > > > > http://www.josecgomez.com
> > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > http://www.facebook.com/josegomez>
> > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > http://www.twitter.com/joc85>
> > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > <http://www.josecgomez.com/feed/>
> > > > > <http://www.usdoingstuff.com>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > >
> > > > > On Fri, Jun 15, 2012 at 8:49 AM, Jose Gomez <jose@> wrote:
> > > > >
> > > > > > I am not sure exactly what screen you are talking about but here
> > is how
> > > > > > you add a column to ANY grid.
> > > > > >
> > > > > >
> > > > > > //Using
> > > > > > using Epicor.Mfg.BO;
> > > > > >
> > > > > > using Epicor.Mfg.Core;
> > > > > >
> > > > > > using Epicor.Mfg.Lib;
> > > > > >
> > > > > >
> > > > > > //Clare
> > > > > > static Epicor.Mfg.UI.FrameWork.EpiUltraGrid grdMatLst;
> > > > > >
> > > > > > static BOReader _boReader;
> > > > > >
> > > > > >
> > > > > > //On Init
> > > > > > grdMatLst =
> > > >
> > (Epicor.Mfg.UI.FrameWork.EpiUltraGrid)csm.GetNativeControlReference("4d59326f-7a76-4c5c-8e2c-54e630db64da");
> > > > > >
> > > > > > grdMatLst.DisplayLayout.Bands[0].Columns.Add("MatAnal","Material
> > > > Analysis");
> > > > > >
> > > > > > grdMatLst.InitializeRow+= new
> > > >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_InitializeRow);
> > > >
> > > > > >
> > > > > > _boReader = new BOReader(((Session)oTrans.Session).ConnectionPool);
> > > > > >
> > > > > >
> > > > > > //On Event Look up the Data and Fill in the New Column
> > > > > >
> > > > > >
> > > > > > private static void grdMatLst_InitializeRow(object sender,
> > > > Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
> > > > > >
> > > > > > {
> > > > > >
> > > > > > String whereClause =
> > > > "Part.PartNum='"+e.Row.Cells["PartNum"].Value.ToString()+"'";
> > > > > >
> > > > > > DataSet ds =
> > > >
> > _boReader.GetRows("Part","Part.PartNum='"+e.Row.Cells["PartNum"].Value.ToString()+"'","Mtl-AnalysisCode");
> > > > > >
> > > > > >
> > > > > >
> > > > > > if(ds.Tables[0].Rows.Count>0)
> > > > > >
> > > > > > {
> > > > > >
> > > > > >
> > > >
> > e.Row.Cells["MatAnal"].Value=ds.Tables[0].Rows[0]["Mtl-AnalysisCode"].ToString();
> > > > > >
> > > > > > }
> > > > > >
> > > > > > }
> > > > > >
> > > > > > //On Destroy
> > > > > > grdMatLst.InitializeRow-= new
> > > >
> > Infragistics.Win.UltraWinGrid.InitializeRowEventHandler(grdMatLst_InitializeRow);
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *
> > > > > > *checkout my new blog <http://www.usdoingstuff.com> *
> > > > > > *
> > > > > > *T: 904.469.1524 mobile
> > > > > > E: jose@
> > > > > > http://www.josecgomez.com
> > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > http://www.facebook.com/josegomez>
> > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > http://www.twitter.com/joc85>
> > > > > > <http://www.josecgomez.com/professional-resume/> <
> > > > http://www.josecgomez.com/feed/>
> > > > > > <http://www.usdoingstuff.com>
> > > > > >
> > > > > > *Quis custodiet ipsos custodes?*
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Thu, Jun 14, 2012 at 10:35 PM, mbetts1953 <mbetts1953@> wrote:
> > > > > >
> > > > > >> **
> > > > > >>
> > > > > >>
> > > > > >> Jose,
> > > > > >> Want to add the Invoice date to the Transaction Detail grid in
> > Chart
> > > > > >> Tracker. I know it is there if you drill down to the transaction
> > > > level. Any
> > > > > >> help with how to do this would be much appreciated.
> > > > > >>
> > > > > >>
> > > > > >>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
