//PL
Dim _objreport As New datalayer.clsreport
Private Sub btnsaerch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsaerch.Click
reportcustomer()
End Sub
'-----------fetch purchasing-----------------'
Public Sub reportcustomer()
If (cmbtype.SelectedItem = "purchasing") Then
Dim dt As New DataTable
Dim dst As New goldserchreport
dt = _objreport.Fetchsearchpurchasereport(dtpsearchstart.Value, dtpsearchend.Value)
dst.Tables.Add(dt)
Dim objCrystal As New reporetpurchasing
objCrystal.SetDataSource(dt)
CrystalReportViewer1.ReportSource = objCrystal
End If
'-----------feach sales-----------------'
If (cmbtype.SelectedItem = "sale") Then
Dim dt As New DataTable
Dim dst As New goldserchreport
dt = _objreport.Fetchsearchpsalereport(dtpsearchstart.Value, dtpsearchend.Value)
dst.Tables.Add(dt)
Dim objCrystal As New salesreport
objCrystal.SetDataSource(dt)
CrystalReportViewer1.ReportSource = objCrystal
End If
If (cmbtype.Text = "select") Then
MsgBox("select type")
End If
End Sub
//clsReport
Public Function Fetchsearchpurchasereport(ByVal dtstart As Date, ByVal dtend As Date) As DataTable
Dim dt As New DataTable
sqlcommand = New SqlCommand("purchasereport", serverconnection)
sqlcommand.CommandType = CommandType.StoredProcedure
Try
sqlcommand.Parameters.AddWithValue("@dtstart", dtstart)
sqlcommand.Parameters.AddWithValue("@dtend", dtend)
sqlcommand.ExecuteNonQuery()
Catch ex As Exception
Throw ex
End Try
Dim sql As New SqlDataAdapter(sqlcommand)
sql.Fill(dt)
Return dt
End Function
No comments:
Post a Comment