E10 - Data Directive RowMod?

system · June 8, 2016, 2:50pm

aaronmathis711, can you explain how this should be used? We have a boat-load of BPMs where we check to see if RowMod = A or U, and then take action. I am assuming that the Condition would be replaced by Execute Custom Code, and then that would lead to the action, but there are more than a few things I don't understand (sorry, new to C#).

If you don't use LastOrDefault when querying, what do you use?

And logically, I would think I would need a True or False result in order to determine whether to execute my action or not. How do I make your code example give me a True/False result?

Thanks in advance for any light you can shine on this.

system · September 28, 2015, 6:58pm

I have a Intransit Data Directive BPM on OrderRel (using a custom code), where when custom date field (PendShipDate_c) is changed an email is sent out.Â This works really well except, that it turns out it also stops the deletion of any Order, OrderDtl, or OrderRel record.Â Big ambiguous error messages in Epicor that took support 2 weeks to figure out... oops.

So I thought, "oh I need to add the RowMod = "A" or "U" logic, however RowMod isn't available in a Data Directives. Â

Can I do something similar in a Method?Â Even if the field in question is being changed in an Updateable Dashboard?Â I also need the before and after value.

Code Below...

Thanks,

Norman Hutchins

System Administrator

Howell Laboratories, Inc.

â€‹
/* PendShipDate Ack EMail -- Adapted from NewOrder Ack code Finshed: 7/27/2015 */
/* Updated to addÂ divisionÂ (HLI or SLI) logic 9/18/2015 */

string bpmFrom = string.Empty;
string bpmTo = string.Empty;
string bpmSubject = string.Empty;
string bpmBody = string.Empty;
string bpmReqDate = string.Empty;
string SetORChanged = string.Empty;
string ttPendDate = string.Empty;
string Status = string.Empty;
//string msg = string.Empty;

var ttORel = (from Â row in ttOrderRel select row).LastOrDefault();

if (ttORel != null)
{
Erp.Tables.OrderHed OrderHed = (from OrderHed_Row in Db.OrderHed
where (OrderHed_Row.Company == ttORel.Company) &&
(OrderHed_Row.OrderNum == ttORel.OrderNum)
select OrderHed_Row).FirstOrDefault();

Erp.Tables.OrderDtl OrderDtl = (from OrderDtl_Row in Db.OrderDtl
where (OrderDtl_Row.Company == ttORel.Company) &&
(OrderDtl_Row.OrderNum == ttORel.OrderNum) &&
(OrderDtl_Row.OrderLine == ttORel.OrderLine)
select OrderDtl_Row).FirstOrDefault();

Erp.Tables.OrderRel OrderRel = (from OrderRel_Row in Db.OrderRel
where (OrderRel_Row.Company == ttORel.Company) &&
(OrderRel_Row.OrderNum == ttORel.OrderNum) &&
(OrderRel_Row.OrderLine == ttORel.OrderLine) &&
(OrderRel_Row.OrderRelNum == ttORel.OrderRelNum)
select OrderRel_Row).FirstOrDefault();

Erp.Tables.Customer Customer = (from Customer_Row in Db.Customer
where (Customer_Row.Company == OrderHed.Company) &&
(Customer_Row.CustNum == OrderHed.CustNum)
select Customer_Row).FirstOrDefault();

//Check if PendShipDate Changed during update
if (ttORel.Date01 != OrderRel.Date01)
{
Status = "With a Status of " + OrderRel.Character01;

//Check if PendShipDate was set or changed
if (ttORel.Date01 == null)
{
SetORChanged = "Set";
ttPendDate = "was set to " + String.Format("{0:M/d/yyyy}",ttORel.Date01);

}
else
{
SetORChanged = "Changed";
ttPendDate = "was changed from " + String.Format("{0:M/d/yyyy}",OrderRel.Date01) + " to " + String.Format("{0:M/d/yyyy}",ttORel.Date01);

}

// Build Email Header
bpmFrom = "howell@...";

// Check which Division
if (Customer.TerritoryID == "HLI")
{
bpmTo = "pendingalert@...";
}
else
{
bpmTo = "pendingalert@...";
}

bpmSubject = "Pending Ship Date " + SetORChanged + " for "Â
+ System.Convert.ToString(ttORel.OrderNum) + "-" + System.Convert.ToString(ttORel.OrderLine) + "-" + System.Convert.ToString(ttORel.OrderRelNum);
bpmReqDate = String.Format("{0:M/d/yyyy}",OrderHed.RequestDate);

// Build Email Body: Order Header
bpmBody =Â
"The Pending Ship Date " + ttPendDate + " for Order: "Â
+ System.Convert.ToString(ttORel.OrderNum) + "-" + System.Convert.ToString(ttORel.OrderLine) + "-" + System.Convert.ToString(ttORel.OrderRelNum) +Â
"\n" + Status + "\n\n" +
"\nOrder Number: " + System.Convert.ToString(ttORel.OrderNum) +Â
"\n\nCustomer: " + System.Convert.ToString(Customer.Name) +Â
"\n\nOrder Date: " + String.Format("{0:M/d/yyyy}",OrderHed.OrderDate) +Â
"\n\nShip By: " + bpmReqDate +Â
"\n\nOrder Line:\n" +
" Â Â Item " + System.Convert.ToString(ttORel.OrderLine) + "-" + System.Convert.ToString(ttORel.OrderRelNum) +
": Â " + System.Convert.ToString(OrderDtl.PartNum) +Â
" Â " + System.Convert.ToString(OrderDtl.LineDesc) +Â
"\n Â Â Â Â Â Â Qty: Â " + Â OrderDtl.OrderQty.ToString("F") + " " + System.Convert.ToString(OrderDtl.SalesUM) +
" Â Ship By: Â " + String.Format("{0:M/d/yyyy}",OrderDtl.RequestDate) +Â
"\nLINE COMMENTS:\n" + OrderDtl.OrderComment +
"\n";

// Build Email Body: Footer
bpmBody = bpmBody +Â
"_______________________________" +
"\nSales Person: " + System.Convert.ToString(OrderHed.SalesRepList) +Â
"\n\nHEADER COMMENTS: \n" + System.Convert.ToString(OrderHed.OrderComment) +Â
"\n\n\nPLEASE NOTE: This e-mail was sent from a notification-only address\nthat cannot accept incoming e-mail. Do not reply to this message";

// Send Email
var mailer = GetMailer(async: true);
var message = new Ice.Mail.SmtpMail();
message.SetFrom(bpmFrom);
message.SetTo(bpmTo);
message.SetSubject(bpmSubject);
message.SetBody(bpmBody);
mailer.Send(message);
}
}

system · September 29, 2015, 9:03am

Hi Norman,

Can you try using a "In-Transaction" directive, with the following code?

var ttOrderRel_xRow = (from ttOrderRel_Row in ttOrderRel

where ttOrderRel_Row.RowMod == IceRow.ROWSTATE_ADDED

|| ttOrderRel_Row.RowMod == IceRow.ROWSTATE_UPDATED

select ttOrderRel_Row).FirstOrDefault();

if (ttOrderRel_xRow != null)

{

}

Dora Chavarria Sr. Consultant Analysis Services, ERP Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com

On Monday, September 28, 2015 5:58 PM, "Norman Hutchins nhutchins@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-162490884yiv0961631965ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-family:verdana, sans-serif;"><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;">I have a Intransit Data Directive BPM on OrderRel (using a custom code), where when custom date field (PendShipDate_c) is changed an email is sent out.&nbsp; This works really well except, that it turns out it also stops the deletion of any Order, OrderDtl, or OrderRel record.&nbsp; Big ambiguous error messages in Epicor that took support 2 weeks to figure out... oops.</div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;"><br clear="none"></div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;">So I thought, &quot;oh I need to add the RowMod = &quot;A&quot; or &quot;U&quot; logic, however RowMod isn&#39;t available in a Data Directives. &nbsp;</div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;"><br clear="none"></div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;">Can I do something similar in a Method?&nbsp; Even if the field in question is being changed in an Updateable Dashboard?&nbsp; I also need the before and after value.</div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;"><br clear="none"></div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;">Code Below...</div><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-size:12.8px;"><br clear="none"></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><div>Thanks,</div><div><br clear="none"></div><div>Norman Hutchins</div><div>System Administrator</div><div>Howell Laboratories, Inc.</div></div></div><blockquote><span title="qreply"> <blockquote style="margin:0 0 0 40px;padding:0px;"><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><div><br clear="none"></div></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><div class="ygrps-yiv-162490884yiv0961631965gmail_default" style="font-family:verdana, sans-serif;">â€‹</div><font face="verdana, sans-serif">/* PendShipDate Ack EMail -- Adapted from NewOrder Ack code Finshed: 7/27/2015 */</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">/* Updated to add&nbsp;division&nbsp;(HLI or SLI) logic 9/18/2015 */</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><br clear="none"></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string bpmFrom = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string bpmTo = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string bpmSubject = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string bpmBody = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string bpmReqDate = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string SetORChanged = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string ttPendDate = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">string Status = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">//string msg = string.Empty;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">var ttORel = (from &nbsp;row in ttOrderRel select row).LastOrDefault();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">if (ttORel != null)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>Erp.Tables.OrderHed OrderHed = (from OrderHed_Row in Db.OrderHed</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>where (OrderHed_Row.Company == ttORel.Company) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderHed_Row.OrderNum == ttORel.OrderNum)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>select OrderHed_Row).FirstOrDefault();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>Erp.Tables.OrderDtl OrderDtl = (from OrderDtl_Row in Db.OrderDtl</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>where (OrderDtl_Row.Company == ttORel.Company) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderDtl_Row.OrderNum == ttORel.OrderNum) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderDtl_Row.OrderLine == ttORel.OrderLine)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>select OrderDtl_Row).FirstOrDefault();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>Erp.Tables.OrderRel OrderRel = (from OrderRel_Row in Db.OrderRel</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>where (OrderRel_Row.Company == ttORel.Company) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderRel_Row.OrderNum == ttORel.OrderNum) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderRel_Row.OrderLine == ttORel.OrderLine) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(OrderRel_Row.OrderRelNum == ttORel.OrderRelNum)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>select OrderRel_Row).FirstOrDefault();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>Erp.Tables.Customer Customer = (from Customer_Row in Db.Customer</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>where (Customer_Row.Company == OrderHed.Company) &amp;&amp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>(Customer_Row.CustNum == OrderHed.CustNum)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>select Customer_Row).FirstOrDefault();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">//Check if PendShipDate Changed during update</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>if (ttORel.Date01 != OrderRel.Date01)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>Status = &quot;With a Status of &quot; + OrderRel.Character01;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">	</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>//Check if PendShipDate was set or changed</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>if (ttORel.Date01 == null)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>SetORChanged = &quot;Set&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>ttPendDate = &quot;was set to &quot; + String.Format(&quot;{0:M/d/yyyy}&quot;,ttORel.Date01);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><br clear="none"></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>}</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>else</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>SetORChanged = &quot;Changed&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>ttPendDate = &quot;was changed from &quot; + String.Format(&quot;{0:M/d/yyyy}&quot;,OrderRel.Date01) + &quot; to &quot; + String.Format(&quot;{0:M/d/yyyy}&quot;,ttORel.Date01);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><br clear="none"></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>}</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">	</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>// Build Email Header</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>bpmFrom = &quot;<a rel="nofollow" shape="rect" target="_blank" href="mailto:howell@...">howell@...</a>&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">			</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>// Check which Division</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>if (Customer.TerritoryID == &quot;HLI&quot;)</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">				</span>bpmTo = &quot;<a rel="nofollow" shape="rect" target="_blank" href="mailto:pendingalert@...">pendingalert@...</a>&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>}</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>else</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>{</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">				</span>bpmTo = &quot;<a rel="nofollow" shape="rect" target="_blank" href="mailto:pendingalert@...">pendingalert@...</a>&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>}</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">			</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>bpmSubject = &quot;Pending Ship Date &quot; + SetORChanged + &quot; for &quot;&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">				</span>+ System.Convert.ToString(ttORel.OrderNum) + &quot;-&quot; + System.Convert.ToString(ttORel.OrderLine) + &quot;-&quot; + System.Convert.ToString(ttORel.OrderRelNum);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>bpmReqDate = String.Format(&quot;{0:M/d/yyyy}&quot;,OrderHed.RequestDate);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">	</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>// Build Email Body: Order Header</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>bpmBody =&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;The Pending Ship Date &quot; + ttPendDate + &quot; for Order: &quot;&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">						</span>+ System.Convert.ToString(ttORel.OrderNum) + &quot;-&quot; + System.Convert.ToString(ttORel.OrderLine) + &quot;-&quot; + System.Convert.ToString(ttORel.OrderRelNum) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&quot; + Status + &quot;&#92;n&#92;n&quot; +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;nOrder Number: &quot; + System.Convert.ToString(ttORel.OrderNum) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&#92;nCustomer: &quot; + System.Convert.ToString(Customer.Name) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&#92;nOrder Date: &quot; + String.Format(&quot;{0:M/d/yyyy}&quot;,OrderHed.OrderDate) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&#92;nShip By: &quot; + bpmReqDate +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&#92;nOrder Line:&#92;n&quot; +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot; &nbsp; &nbsp; Item &quot; + System.Convert.ToString(ttORel.OrderLine) + &quot;-&quot; + System.Convert.ToString(ttORel.OrderRelNum) +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;: &nbsp; &quot; + System.Convert.ToString(OrderDtl.PartNum) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot; &nbsp; &quot; + System.Convert.ToString(OrderDtl.LineDesc) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Qty: &nbsp; &quot; + &nbsp;OrderDtl.OrderQty.ToString(&quot;F&quot;) + &quot; &quot; + System.Convert.ToString(OrderDtl.SalesUM) +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot; &nbsp; Ship By: &nbsp; &quot; + String.Format(&quot;{0:M/d/yyyy}&quot;,OrderDtl.RequestDate) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;nLINE COMMENTS:&#92;n&quot; + OrderDtl.OrderComment +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">					</span>&quot;&#92;n&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;"><font face="verdana, sans-serif">			</font></span></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>// Build Email Body: Footer</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>bpmBody = bpmBody +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>&quot;_______________________________&quot; +</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>&quot;&#92;nSales Person: &quot; + System.Convert.ToString(OrderHed.SalesRepList) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>&quot;&#92;n&#92;nHEADER COMMENTS: &#92;n&quot; + System.Convert.ToString(OrderHed.OrderComment) +&nbsp;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>&quot;&#92;n&#92;n&#92;nPLEASE NOTE: This e-mail was sent from a notification-only address&#92;nthat cannot accept incoming e-mail. Do not reply to this message&quot;;</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><br clear="none"></font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">		</span>// Send Email</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>var mailer = GetMailer(async: true);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>var message = new Ice.Mail.SmtpMail();</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>message.SetFrom(bpmFrom);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>message.SetTo(bpmTo);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>message.SetSubject(bpmSubject);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>message.SetBody(bpmBody);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">			</span>mailer.Send(message);</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif"><span class="ygrps-yiv-162490884yiv0961631965class" style="white-space:pre;">	</span>}</font></div></div><div><div class="ygrps-yiv-162490884yiv0961631965gmail_signature"><font face="verdana, sans-serif">}</font></div></div></blockquote>

</div>
 


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

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965 -- #ygrps-yiv-162490884yiv0961631965ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp #ygrps-yiv-162490884yiv0961631965hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp #ygrps-yiv-162490884yiv0961631965ads {
margin-bottom:10px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp .ygrps-yiv-162490884yiv0961631965ad {
padding:0 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp .ygrps-yiv-162490884yiv0961631965ad p {
margin:0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mkp .ygrps-yiv-162490884yiv0961631965ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ygrp-lc {
font-family:Arial;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ygrp-lc #ygrps-yiv-162490884yiv0961631965hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ygrp-lc .ygrps-yiv-162490884yiv0961631965ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity span {
font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity span span {
color:#ff7900;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965activity span .ygrps-yiv-162490884yiv0961631965underline {
text-decoration:underline;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965attach div a {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965attach img {
border:none;padding-right:5px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965attach label a {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965bold a {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 dd.ygrps-yiv-162490884yiv0961631965last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 dd.ygrps-yiv-162490884yiv0961631965last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 dd.ygrps-yiv-162490884yiv0961631965last p span.ygrps-yiv-162490884yiv0961631965yshortcuts {
margin-right:0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965attach-table div div a {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965attach-table {
width:400px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965file-title a, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965file-title a:active, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965file-title a:hover, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965file-title a:visited {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965photo-title a, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965photo-title a:active, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965photo-title a:hover, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div.ygrps-yiv-162490884yiv0961631965photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 div#ygrps-yiv-162490884yiv0961631965ygrp-mlmsg #ygrps-yiv-162490884yiv0961631965ygrp-msg p a span.ygrps-yiv-162490884yiv0961631965yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965green {
color:#628c2a;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 o {
font-size:0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965photos div {
float:left;width:72px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965reco-category {
font-size:77%;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965reco-desc {
font-size:77%;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 .ygrps-yiv-162490884yiv0961631965replbq {
margin:4px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg select, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 input, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg pre, #ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 code {
font:115% monospace;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-mlmsg #ygrps-yiv-162490884yiv0961631965logo {
padding-bottom:10px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-msg p#ygrps-yiv-162490884yiv0961631965attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-reco #ygrps-yiv-162490884yiv0961631965reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-sponsor #ygrps-yiv-162490884yiv0961631965ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-text {
font-family:Georgia;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-text tt {
font-size:120%;}

#ygrps-yiv-162490884 #ygrps-yiv-162490884yiv0961631965 #ygrps-yiv-162490884yiv0961631965ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-162490884

system · September 29, 2015, 9:23am

You do have access to the row mod, just not the way you think. Try using this:

var ttORel = (from ttORel_Row in ttOrderRel
where (string.Equals(ttORel_Row.RowMod, IceRow.ROWSTATE_ADDED, StringComparison.OrdinalIgnoreCase)) || (string.Equals(ttORel_Row.RowMod, IceRow.ROWSTATE_UPDATED, StringComparison.OrdinalIgnoreCase))
select ttORel_Row).FirstOrDefault();

This will get you the updated or added row you are looking for. Don't use LastOrDefault when querying. Only use it on List when you know you want the last. Its risky and can break things like in this scenario.

system · September 29, 2015, 9:25am

Also I don't see why this can't be a standard data directive.

system · September 30, 2015, 1:08pm

Thanks for the help, I'll give them a try.

Aaron,Â

Can I get access to the before and after values in a standard data directive?Â If so, how would you do that? I tried a normal data directive done couldn't get both values, so I switch it to in-transit.Â

Thanks

â€‹ againâ€‹

,

Norman Hutchins

System Administrator

Howell Laboratories, Inc.

Topic		Replies	Views
E10: Comparing RowMod in BPM Yahoo Archive	2	2610	December 17, 2014
BPM data directive? store old data before update Yahoo Archive	3	1996	November 25, 2015
BPM to prevent deleting lines if order>1 day old not triggering Epicor ERP 10 bpm	7	1282	July 10, 2020
BPM in 9.05.700C Yahoo Archive	4	467	November 13, 2014
E10 C# BPM "Row has been modified by another user and couldn't b Yahoo Archive	5	1766	March 4, 2015

E10 - Data Directive RowMod?

Related Topics