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 |
||
| (6 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 12 ⟶ 28:
<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)
{
Line 25 ⟶ 41:
BCE.AutoCount.SearchFilter.Filter filterDebtor = new BCE.AutoCount.SearchFilter.Filter("B", "DebtorCode");
//the value
//set to true to load zero balance;
report.Inquire(fromDate, toDate,
filterMember, filterMemberType, filterAgent, filterArea, filterDebtor,
true);
DataSet ds = report.DsBonusPointTransactionListing;
Line 38 ⟶ 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/>
Line 65 ⟶ 84:
==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 77 ⟶ 96:
//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
Line 93 ⟶ 112:
<br/>
==Load a range of MemberType (filter MemberType) and Member Point Balance==
<syntaxhighlight lang="csharp">
| |||