Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.53 KB | None | 0 0
  1. Private Sub CreateQuoteReferenceDetailsDataSet()
  2.  
  3. 'Create a DataSet
  4. Dim quotationDataSet As New DataSet
  5.  
  6. 'Initialize DataTables for the DataSet
  7. Dim quoteDataTable As DataTable = quotationDataSet.Tables.Add("QuoteDetails")
  8. Dim quotedItemsDataTable As DataTable = quotationDataSet.Tables.Add("QuotedItems")
  9.  
  10. 'Create DataRows for every DataTable
  11. Dim quoteDetailsDataRow As DataRow = Nothing
  12. Dim quotedItemsDataRow As DataRow = Nothing
  13.  
  14. 'Prepare columns for the DataTable named DeliveryDetails
  15. With quotationDataSet.Tables(0).Columns
  16.  
  17. .Add("quoteDate", Type.GetType("System.String"))
  18. .Add("quoteReferenceNumber", Type.GetType("System.String"))
  19. .Add("quoteCompany", Type.GetType("System.String"))
  20. .Add("quoteStreetAddress", Type.GetType("System.String"))
  21. .Add("quoteCity", Type.GetType("System.String"))
  22. .Add("quoteContactPerson", Type.GetType("System.String"))
  23. .Add("quoteSubject", Type.GetType("System.String"))
  24. .Add("quoteTerms", Type.GetType("System.String"))
  25. .Add("quoteDelivery", Type.GetType("System.String"))
  26. .Add("quoteProposalValidity", Type.GetType("System.String"))
  27.  
  28. End With
  29.  
  30. 'Prepare columns for the DataTable named DeliveredItems
  31. With quotationDataSet.Tables(1).Columns
  32.  
  33. .Add("quoteCatNumber", Type.GetType("System.String"))
  34. .Add("quotePartName", Type.GetType("System.String"))
  35. .Add("quoteDescription", Type.GetType("System.String"))
  36. .Add("quoteQuantity", Type.GetType("System.String"))
  37. .Add("quoteGrandTotal", Type.GetType("System.String"))
  38.  
  39. End With
  40.  
  41. 'If dataset already exists on startup, then dispose newly created dataset. Else, write a new
  42. 'DataSet file.
  43. If IO.File.Exists(Application.StartupPath & "quoteReferenceDetailsSchema.xsd") = True Then
  44. quotationDataSet.Dispose()
  45. Exit Sub
  46. Else
  47. quotationDataSet.WriteXmlSchema(Application.StartupPath & "quoteReferenceDetailsSchema.xsd")
  48. End If
  49.  
  50. End Sub
  51.  
  52. Private Sub CreateReport()
  53.  
  54. 'Initialize the needed objects for report document.
  55. Dim myQuotationReport As New rptQuotationReference
  56. Dim dataSet As New DataSet
  57.  
  58. 'Initialize DataTables for the DataSet
  59. Dim quoteDataTable As DataTable = dataSet.Tables.Add("QuoteDetails")
  60. Dim quotedItemsDataTable As DataTable = dataSet.Tables.Add("QuotedItems")
  61.  
  62. 'Create DataRows for every DataTable
  63. Dim quoteDetailsDataRow As DataRow = Nothing
  64. Dim quotedItemsDataRow As DataRow = Nothing
  65.  
  66. 'Declare other related variables for the subroutine.
  67. Dim counter As Integer = 0
  68.  
  69. 'Prepare columns for the DataTable named QuoteDetails
  70. With dataSet.Tables(0).Columns
  71.  
  72. .Add("quoteDate", Type.GetType("System.String"))
  73. .Add("quoteReferenceNumber", Type.GetType("System.String"))
  74. .Add("quoteCompany", Type.GetType("System.String"))
  75. .Add("quoteStreetAddress", Type.GetType("System.String"))
  76. .Add("quoteCity", Type.GetType("System.String"))
  77. .Add("quoteContactPerson", Type.GetType("System.String"))
  78. .Add("quoteSubject", Type.GetType("System.String"))
  79. .Add("quoteTerms", Type.GetType("System.String"))
  80. .Add("quoteDelivery", Type.GetType("System.String"))
  81. .Add("quoteProposalValidity", Type.GetType("System.String"))
  82.  
  83. End With
  84.  
  85. Dim termsOfPayment As String = cboTermsOfPayment.SelectedItem
  86. Dim deliveryDuration As String = nudDurationValue.Value.ToString() + cboDuration.SelectedItem
  87. Dim deliveryValidity As String = nudValidityValue.Value.ToString() + cboValidityDuration.SelectedItem
  88.  
  89. 'Initialize and insert delivery heading to the DataTable.
  90. quoteDetailsDataRow = dataSet.Tables(0).NewRow
  91. quoteDetailsDataRow(0) = dtpQuoteRefDate.Value.ToString()
  92. quoteDetailsDataRow(1) = txtQRNumber.Text
  93. quoteDetailsDataRow(2) = txtQuotationTargetClient.Text
  94. quoteDetailsDataRow(3) = txtQuotationClientAddress.Text
  95. quoteDetailsDataRow(4) = txtQuotationClientCity.Text
  96. quoteDetailsDataRow(5) = txtContactPerson.Text
  97. quoteDetailsDataRow(6) = txtQuoteSubject.Text
  98. quoteDetailsDataRow(7) = termsOfPayment
  99. quoteDetailsDataRow(8) = deliveryDuration
  100. quoteDetailsDataRow(9) = deliveryValidity
  101. dataSet.Tables(0).Rows.Add(quoteDetailsDataRow)
  102.  
  103. 'Prepare columns for the DataTable named QuotedItems
  104. With dataSet.Tables(1).Columns
  105.  
  106. .Add("quoteCatNumber", Type.GetType("System.String"))
  107. .Add("quotePartName", Type.GetType("System.String"))
  108. .Add("quoteDescription", Type.GetType("System.String"))
  109. .Add("quoteQuantity", Type.GetType("System.String"))
  110. .Add("quoteGrandTotal", Type.GetType("System.String"))
  111.  
  112. End With
  113.  
  114. For counter = lviQuotedList.Items.Count - 1 To 0 Step -1
  115.  
  116. quotedItemsDataRow = dataSet.Tables(1).NewRow
  117.  
  118. With lviQuotedList
  119.  
  120. quotedItemsDataRow(0) = .Items.Item(counter).Text
  121. quotedItemsDataRow(1) = .Items.Item(counter).SubItems.Item(1).Text
  122. quotedItemsDataRow(2) = .Items.Item(counter).SubItems.Item(2).Text
  123. quotedItemsDataRow(3) = .Items.Item(counter).SubItems.Item(3).Text
  124. quotedItemsDataRow(4) = .Items.Item(counter).SubItems.Item(4).Text
  125.  
  126. End With
  127.  
  128. dataSet.Tables(1).Rows.Add(quotedItemsDataRow)
  129. quotedItemsDataRow = Nothing
  130.  
  131. Next counter
  132.  
  133. 'Set Data Sources for the Crystal Report.
  134. **myQuotationReport.SetDataSource(dataSet)**
  135. frmQuotationReferenceReport.crvQuotationReferenceReport.ReportSource = myQuotationReport
  136.  
  137. 'Dispose after using.
  138. dataSet.Dispose()
  139. dataSet = Nothing
  140.  
  141. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement