2,743
edits
Programmer:Item Opening Maintenance v2: Difference between revisions
Programmer:Item Opening Maintenance v2 (view source)
Revision as of 07:54, 21 September 2018
, 5 years agono edit summary
(Created page with "==Technical Specification== #Quantity of the Item Opening must not be zero #*When adding a new entry to Item Opening, zero qty entry will be removed before saving to database...") |
mNo edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
Line 15:
#*The filtering will have impact on adding new record of an ItemCode that is not in the range of the filtered range.
#*:If the newly added ItemCode is not in the filter range, system throw exception message of "Item Code is not in Filter range."
#The value of '''Seq''' cannot repeat the same, when the value of below columns are
#*ItemCode
#*UOM
Line 21:
#*BatchNo
#:If there is any occasion when '''Seq''' is repeated for the same ItemCode, UOM, Location and BatchNo, below error message is thrown:
#:'''Sequence for Item''' 'FG00001', '''UOM''' 'UNIT', '''Location''' 'HQ', '''BatchNo''' ' ' '''is not correct'''.
#'''Seq''' will affect how the '''cost''' of '''FIFO''' and '''LIFO''' is calculated.
==References of AutoCount Accounting version 2.0==
{{BaseReferenceAC20}}
'''AutoCount.StockMaint.dll'''
<br/>
Line 133 ⟶ 138:
===Adding two entries of same ItemCode to Item Opening===
<syntaxhighlight lang="csharp" highlight="22-24,31-33,27,36">
public void NewTwoEntriesOfSameItem(AutoCount.Authentication.UserSession userSession)
{
Line 185 ⟶ 190:
==Delete Item Opening entry==
This example uses a function to find the ItemOpeningKey.<br/>
This can avoid the error of '''"Sequence for Item 'FG00001', UOM 'UNIT', Location 'HQ', BatchNo '' is not correct."'''▼
Highlighted shows the function to get the list of keys and deletion of existing keys.<br/><br/>
<syntaxhighlight lang="csharp">▼
▲
<syntaxhighlight lang="csharp" highlight="22,23">
public void CheckNewEntryBeforeAdding(AutoCount.Authentication.UserSession userSession)
{
Line 242 ⟶ 249:
</syntaxhighlight>
Function to find a list of keys that is/are matching.
▲<syntaxhighlight lang="csharp">
public List<long> GetExistItemOpeningKey(DataTable table, string itemCode, string uom, string location, string batchNo)
{
return table.AsEnumerable().Where(r =>
r.RowState != DataRowState.Deleted &&
r.Field<string>("ItemCode") == itemCode &&
r.Field<string>("UOM") == uom &&
r.Field<string>("Location") == location &&
r.Field<string>("BatchNo") == batchNo
).Select(r => r.Field<long>("ItemOpeningKey"))
.ToList();
}
</syntaxhighlight>
Another function to specially handle Deleting matching Item Opening
<syntaxhighlight lang="csharp">
public void DeleteAllMatchingItemOpening(IEnumerable<DataRow> itemOpenings, string itemCode, string uom, string location, string batchNo, Action<long> deleteOpening)
{
itemOpenings.Where(r => r.RowState != DataRowState.Deleted &&
r.Field<string>("ItemCode") == itemCode &&
r.Field<string>("UOM") == uom &&
r.Field<string>("Location") == location &&
r.Field<string>("BatchNo") == batchNo
).Select(r => r.Field<long>("ItemOpeningKey"))
.ToList().ForEach(key => deleteOpening(key));
}
</syntaxhighlight>
To apply this function code;
<syntaxhighlight lang="csharp">
DeleteAllMatchingItemOpening(entities.ItemOpeningTable.AsEnumerable(), "FG00001", "UNIT", "HQ", null, entities.DeleteItemOpening);
</syntaxhighlight>
<br/>
{{SeeAlsoStockV2}}
{{NavigateDeveloper}}
| |||