2,743
edits
Report Script: Create a Packing List in report script: Difference between revisions
Report Script: Create a Packing List in report script (view source)
Revision as of 09:17, 31 July 2018
, 5 years agono edit summary
No edit summary |
No edit summary |
||
Line 43:
return;
//Get total smallest UOM Qty of same ItemCode and UOMRate
decimal smallestQty = GetSmallestQty(GetCurrentColumnValue("
decimal uomRate;
Line 64 ⟶ 65:
</syntaxhighlight>
<syntaxhighlight lang="csharp">
//ItemCode and UOMRate are the grouping in this report
private decimal GetSmallestQty(object
{
if (oItemCode == null)
return 0;
return (Report.DataSource as DataSet).Tables["Master"].AsEnumerable()
.Where(r =>
r.Field<string>("ItemCode") == oItemCode.ToString() &&
r.Field<decimal>("UOMRate") == BCE.Data.Convert.ToDecimal(oUomRate)
)
.GroupBy(r => new {
ItemCode = r.Field<string>("ItemCode"),
UOMRate = r.Field<decimal>("UOMRate")
})
.Select(g => g.Sum(r => r.Field<decimal>("Qty") * r.Field<decimal>("Rate")))
.FirstOrDefault();
}
</syntaxhighlight>
Line 82 ⟶ 97:
{
//Format the display text of qty and uom
if (qty == 0)
return result;
string formatQtyUom = string.Format("{0} {1}", qty, uom);
return string.IsNullOrEmpty(result) ? formatQtyUom
: string.Format("{0}
}
</syntaxhighlight>
| |||