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> |
||
Revision as of 02:30, 9 August 2018
Load Member data
public DataTable LoadMemberData(BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand cmd =
BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand.Create(dbSetting);
return cmd.LoadBrowseTable();
}
Load Member Transaction Listing by Date Range with Member Point
public DataSet LoadAllMemberListingByDateWithPoint(DateTime fromDate, DateTime toDate, BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report
= BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing.Create(dbSetting);
//5 filters are required by report.Inquire
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");
//the value of true to indicate whether to load Zero Balance member
report.Inquire(fromDate, toDate,
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
DataSet ds = report.DsBonusPointTransactionListing;
return ds;
}
- Contains 2 Tables in the DataSet
- Master
- Table of member listing and transactions with earning points by date range.
- BalanceBF
- List of members and Balance Point until the toDate.
- Master
Load All Member and Member Point Balance
public DataTable LoadAllMemberBalancePoint(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");
//Set the from and to date to future, so the BalanceBF is actual member point balance
report.Inquire(new DateTime(9900, 12, 31), new DateTime(9900, 12, 31),
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}
Columns in return table of LoadAllMemberBalancePoint
Load selected Member(s) (filter member) and Member Point Balance
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");
//Filter Member by multi-select
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(9900, 12, 31), new DateTime(9900, 12, 31),
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
return report.DsBonusPointTransactionListing.Tables["BalanceBF"];
}
- To call the method of LoadMemberBalPointByMultiSelectMember
string[] selectedMembers = { "M-0001", "M-0003" };
LoadMemberBalPointByMultiSelectMember(selectedMembers.ToList(), mydbset);
Load a range of MemberType (filter MemberType) and Member Point Balance
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"];
}
See Also
- AR Debtor (Customer) - [1.8, 1.9] [2.0]
- Stock Item (Item Maintenance) - [1.8, 1.9] [2.0]
Maintenance (Master Data)
- Member - [1.8, 1.9] [2.0]
- Member Type - [1.8, 1.9] [2.0]
- Race - [1.8, 1.9] [2.0]
Transactions
- Bonus Point Adjustment - [1.8, 1.9] [2.0]
- Bonus Point Redemption - [1.8, 1.9] [2.0]
- Earn Point with Sale Invoice - [1.8, 1.9] [2.0]
Reporting
![]() |
Go to top
|
![]() |
Resources For AutoCount Software Developers
|