Programmer:Member List and Point Balance: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 10: | Line 10: | ||
</syntaxhighlight> |
</syntaxhighlight> |
||
<br/> |
|||
==Load Member Transaction Listing by Date Range with Member Point== |
==Load Member Transaction Listing by Date Range with Member Point== |
||
<syntaxhighlight lang="csharp"> |
<syntaxhighlight lang="csharp"> |
||
Line 38: | Line 39: | ||
*#:List of members and Balance Point until the toDate. |
*#:List of members and Balance Point until the toDate. |
||
<br/> |
|||
==Load All Member and Member Point Balance== |
==Load All Member and Member Point Balance== |
||
<syntaxhighlight lang="csharp"> |
<syntaxhighlight lang="csharp"> |
||
Line 60: | Line 62: | ||
''Columns''' in return table of '''LoadAllMemberBalancePoint'' |
''Columns''' in return table of '''LoadAllMemberBalancePoint'' |
||
<br/> |
|||
==Load selected Member(s) (filter member) and Member Point Balance== |
==Load selected Member(s) (filter member) and Member Point Balance== |
||
<syntaxhighlight lang="csharp"> |
<syntaxhighlight lang="csharp"> |
||
Line 72: | Line 75: | ||
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode"); |
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode"); |
||
//Filter Member by multi-select |
|||
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual; |
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual; |
||
memberNo.ForEach(s => filterMember.Add(s)); |
memberNo.ForEach(s => filterMember.Add(s)); |
||
Line 86: | Line 90: | ||
string[] selectedMembers = { "M-0001", "M-0003" }; |
string[] selectedMembers = { "M-0001", "M-0003" }; |
||
LoadMemberBalPointByMultiSelectMember(selectedMembers.ToList(), mydbset); |
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> |
</syntaxhighlight> |
||