2,756
edits
Programmer:Member List and Point Balance: Difference between revisions
Programmer:Member List and Point Balance (view source)
Revision as of 01:48, 9 August 2018
, 5 years agono edit summary
(Created page with " ==Load Member data== <syntaxhighlight lang="csharp"> public DataTable LoadMemberData(BCE.Data.DBSetting dbSetting) { BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCo...") |
No edit summary |
||
Line 35:
*#:List of members and Balance Point until the toDate.
==Load All Member
<syntaxhighlight lang="csharp">
public DataTable LoadAllMemberBalancePoint(BCE.Data.DBSetting dbSetting)
Line 47:
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//Set the from and to date to future, so the
report.Inquire(new DateTime(2900, 12, 31), new DateTime(2900, 12, 31),
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
Line 56:
[[File:Prog MemberBFBal.png]]<br/>
''Columns''' in return table of '''LoadAllMemberBalancePoint''
==Load selected Member(s) (filter member) and Member Point Balance==
<syntaxhighlight lang="csharp">
public DataTable LoadMemberBalPointByMultiSelectMember(List<string> memberNo, 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");
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
memberNo.ForEach(s => filterMember.Add(s));
//Set the from and to date to future, so the BF Balance is actual member total balance
report.Inquire(new DateTime(2900, 12, 31), new DateTime(2900, 12, 31),
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}
</syntaxhighlight>
<br/>
| |||