2,756
edits
Programmer:Member List and Point Balance: Difference between revisions
Programmer:Member List and Point Balance (view source)
Revision as of 02:30, 9 August 2018
, 5 years agono edit summary
No edit summary |
|||
Line 10:
</syntaxhighlight>
<br/>
==Load Member Transaction Listing by Date Range with Member Point==
<syntaxhighlight lang="csharp">
Line 38 ⟶ 39:
*#:List of members and Balance Point until the toDate.
<br/>
==Load All Member and Member Point Balance==
<syntaxhighlight lang="csharp">
Line 60 ⟶ 62:
''Columns''' in return table of '''LoadAllMemberBalancePoint''
<br/>
==Load selected Member(s) (filter member) and Member Point Balance==
<syntaxhighlight lang="csharp">
Line 72 ⟶ 75:
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//Filter Member by multi-select
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
memberNo.ForEach(s => filterMember.Add(s));
Line 86 ⟶ 90:
string[] selectedMembers = { "M-0001", "M-0003" };
LoadMemberBalPointByMultiSelectMember(selectedMembers.ToList(), mydbset);
</syntaxhighlight>
<br/>
==Load a range of MemberType (filter MemberType) and Member Point Balance==
<syntaxhighlight lang="csharp">
public DataTable LoadMemberBalPointByRangeSelectMemberType(string fromMemberType, string toMemberType, BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);
BCE.AutoCount.SearchFilter.Filter filterMember = new BCE.AutoCount.SearchFilter.Filter("B", "MemberNo");
BCE.AutoCount.SearchFilter.Filter filterMemberType = new BCE.AutoCount.SearchFilter.Filter("B", "MemberType");
BCE.AutoCount.SearchFilter.Filter filterAgent = new BCE.AutoCount.SearchFilter.Filter("C", "SalesAgent");
BCE.AutoCount.SearchFilter.Filter filterArea = new BCE.AutoCount.SearchFilter.Filter("B", "AreaCode");
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//Filter MemberType by range
filterMemberType.Type = BCE.AutoCount.SearchFilter.FilterType.ByRange;
filterMemberType.From = fromMemberType;
filterMemberType.To = toMemberType;
//Set the from and to date to future, so the BF Balance is actual member total balance
report.Inquire(new DateTime(9900, 12, 31), new DateTime(9900, 12, 31),
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}
</syntaxhighlight>
| |||