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

no edit summary
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)))
No edit summary
Line 82:
*Configure GridControl and GridView
 
<syntaxhighlight lang="csharp" line highlight="6,7, 9-11, 2223,3536">
public FormShowSalesInvoice(BCE.Data.DBSetting dbSetting)
{
Line 216:
 
<syntaxhighlight lang="csharp" line highlight="16-17">
private void BtnInquiry_Click(object sender, EventArgs e)
{
Line 260:
+ ",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.DocKeyItemCode = BI.DocKeyItemCode";
+ " LEFT JOIN Item I"
+ " ON B.ItemCode = I.ItemCode";
 
DataTable table = mydbset.GetDataTable(sqlSelect, false);