2,743
edits
(Created page with "{{NavigateDeveloper|collapsed}} __NOTOC__ Objectives: Adding a new GridControl and Formatting the grid's data Implement AutoCount Accounting 1.8 Visual Style requires {{DevE...") |
No edit summary |
||
(9 intermediate revisions by the same user not shown) | |||
Line 1:
{{NavigateDeveloper|collapsed}}▼
__NOTOC__
Objectives:
Implement AutoCount Accounting 1.8 Visual Style requires {{DevExpress}} WinForms Components version 13.1.10.
Add Master and Detail tables relation to GridControl.
''This exercise uses project from
Line 12:
3. Add References of AutoCount Accounting
<syntaxhighlight lang="csharp"
BCE.AutoCount.dll
BCE.AutoCount.CommandAccounting.dll
Line 23:
4. Add References of {{DevExpress}} WinForms.
<syntaxhighlight lang="csharp"
DevExpress.Data.v13.1.dll
DevExpress.Design.v13.1.dll
Line 82:
*Configure GridControl and GridView
<syntaxhighlight lang="csharp" line highlight="6,7, 9-11,
public FormShowSalesInvoice(BCE.Data.DBSetting dbSetting)
{
Line 197:
}
</syntaxhighlight>
Line 216 ⟶ 215:
<syntaxhighlight lang="csharp"
private void BtnInquiry_Click(object sender, EventArgs e)
{
Line 246 ⟶ 245:
+ ",A.SalesAgent, A.FinalTotal"
+ ",D.DebtorType"
+ " FROM IV A JOIN DEBTOR D ON A.DebtorCode = D.AccNo";
DataTable table = mydbset.GetDataTable(sqlSelect, false);
Line 260 ⟶ 258:
+ ",B.Qty, B.UnitPrice, B.DiscountAmt, B.SubTotal"
+ ",I.ItemType"
+ " FROM IV A JOIN IVDTL B ON A.DocKey = B.DocKey"
+ " LEFT JOIN Item I ON
DataTable table = mydbset.GetDataTable(sqlSelect, false);
Line 353 ⟶ 349:
==See Also==
* [[
* [[
* [[Exercise_1:_Build_My_First_Plug-In|Exercise 1: Build My First Plug-In]]
* [[Exercise_2:_Create_Dialog_Box|Exercise 2: Create Dialog Box]]
* [[Exercise_3:_Create_Form|Exercise 3: Create Form]]
* [[Exercise 4: Design Form of AutoCount Accounting 1.8]]
* [[Exercise 5: Design Grid of AutoCount Accounting 1.8]]
<br /><br />
<br /><br />
[[Category:
[[Category:Plug-In]]
[[Category:Programmer Exercise]]
|