2,756
edits
Programmer:Member List and Point Balance: Difference between revisions
Programmer:Member List and Point Balance (view source)
Revision as of 07:34, 13 August 2018
, 5 years agono edit summary
No edit summary |
No edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
Line 1:
==Assemblies version 1.8, 1.9==
{{BaseReferenceAC18}}
'''BCE.AutoCount.GeneralMaint.dll'''
'''BCE.AutoCount.Invoicing.dll'''
'''BCE.AutoCount.Invoicing.Sales.dll'''
==Load Member data==
Retrieve '''single record''' of a member
<syntaxhighlight lang="csharp">
public BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberEntity LoadAMemberData(string memberNo, BCE.Data.DBSetting dbSetting)
{
BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand cmd =
BCE.AutoCount.GeneralMaint.MemberMaintenance.MemberCommand.Create(dbSetting);
return cmd.GetMember(memberNo);
}
</syntaxhighlight>
Load all members data in a '''table'''
<syntaxhighlight lang="csharp">
public DataTable LoadMemberData(BCE.Data.DBSetting dbSetting)
Line 10 ⟶ 26:
</syntaxhighlight>
<br/>
==Load Member Transaction Listing by Date Range with Member Point==
<syntaxhighlight lang="csharp" highlight="17">
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");
Line 22 ⟶ 41:
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//the value true indicates whether to load member whom point balance is zero;
//set to true to load zero balance;
report.Inquire(fromDate, toDate,
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor,
true);
DataSet ds = report.DsBonusPointTransactionListing;
Line 34 ⟶ 56:
*#BalanceBF
*#:List of members and Balance Point until the toDate.
{{Note|'''Prefix''' in the filter such as "B", "C" are fixed value and should not be changed.<br/>It is '''table alias''' that is defined in SQL Command.}}
<br/>
==Load All Member and Member Point Balance==
<syntaxhighlight lang="csharp">
Line 48 ⟶ 72:
//Set the from and to date to future, so the BalanceBF is actual member point balance
report.Inquire(new DateTime(
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
Line 57 ⟶ 81:
''Columns''' in return table of '''LoadAllMemberBalancePoint''
<br/>
==Load selected Member(s) (filter member) and Member Point Balance==
<syntaxhighlight lang="csharp">
public DataTable LoadMemberBalPointByMultiSelectMember(List<string>
{
BCE.AutoCount.Invoicing.Sales.BonusPointTransListing.BonusPointTransactionListing report =
Line 69 ⟶ 94:
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//Filter Member by multi-select
filterMember.Type = BCE.AutoCount.SearchFilter.FilterType.ByIndividual;
//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>
*To call the method of '''LoadMemberBalPointByMultiSelectMember'''
<syntaxhighlight lang="csharp">
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(
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor, true);
| |||