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 |
|||
| (2 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 40 ⟶ 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">
| |||