Exercise 5: Design Grid of AutoCount Accounting 1.8: Difference between revisions

← Older edit

Exercise 5: Design Grid of AutoCount Accounting 1.8 (view source)

Revision as of 08:37, 25 February 2019

254 bytes added , 5 years ago

no edit summary

DanielY

authors, Bureaucrats, Confirmed users, Rollbackers, Administrators

2,743

edits

Revision as of 07:38, 1 November 2017 (view source) DanielY (talk \| contribs) m (Protected "Exercise 5: Design Grid of AutoCount Accounting 1.8" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite))) ← Older edit		Latest revision as of 08:37, 25 February 2019 (view source) DanielY (talk \| contribs) No edit summary
(8 intermediate revisions by the same user not shown)
Line 1: {{NavigateDeveloper\|collapsed}}▼ __NOTOC__ Objectives: ~~Adding~~Add a new GridControl and apply Formatting on the grid~~'s data~~. 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 ~~precious~~previous exercise.'' Line 12: 3. Add References of AutoCount Accounting <syntaxhighlight lang="csharp" ~~line~~> BCE.AutoCount.dll BCE.AutoCount.CommandAccounting.dll Line 23: 4. Add References of {{DevExpress}} WinForms. <syntaxhighlight lang="csharp" ~~line~~ highlight="5, 6"> 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, 2223,3536"> public FormShowSalesInvoice(BCE.Data.DBSetting dbSetting) { Line 197: } </syntaxhighlight> Line 216 ⟶ 215: <syntaxhighlight lang="csharp" ~~line~~ highlight="16-17"> 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"; ~~+ " 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 AB.~~DocKey~~ItemCode = BI.~~DocKey~~ItemCode"; ~~+ " LEFT JOIN Item I"~~ ~~+ " ON B.ItemCode = I.ItemCode";~~ DataTable table = mydbset.GetDataTable(sqlSelect, false); Line 353 ⟶ 349: ==See Also== [[~~201a.GettingStarted\|201a: AutoCount Accounting~~ Plug-In 1.8 Getting Started]] * [[~~201b~~Plug-In 1.~~UserControl~~8 User Control & Interface]] * [[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:~~Developers~~Programmer]] ~~[[Category:Tutorials]]~~ [[Category:Plug-In]] [[Category:Programmer Exercise]] ▲{{NavigateDeveloper~~\|collapsed~~}}