Programmer:Member List and Point Balance: Difference between revisions
Content added Content deleted
(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: | Line 35: | ||
*#:List of members and Balance Point until the toDate. |
*#:List of members and Balance Point until the toDate. |
||
==Load Member |
==Load All Member and Member Point Balance== |
||
<syntaxhighlight lang="csharp"> |
<syntaxhighlight lang="csharp"> |
||
public DataTable LoadAllMemberBalancePoint(BCE.Data.DBSetting dbSetting) |
public DataTable LoadAllMemberBalancePoint(BCE.Data.DBSetting dbSetting) |
||
Line 47: | Line 47: | ||
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode"); |
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode"); |
||
//Set the from and to date to future, so the |
//Set the from and to date to future, so the BalanceBF is actual member point balance |
||
report.Inquire(new DateTime(2900, 12, 31), new DateTime(2900, 12, 31), |
report.Inquire(new DateTime(2900, 12, 31), new DateTime(2900, 12, 31), |
||
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true); |
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true); |
||
Line 56: | Line 56: | ||
[[File:Prog MemberBFBal.png]]<br/> |
[[File:Prog MemberBFBal.png]]<br/> |
||
''Columns''' in return table of '''LoadAllMemberBalancePoint'' |
''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/> |
<br/> |