web/SysPRICE.aspx.vb

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

Imports BLL
Imports Model
Imports System.Data
Imports System.Data.SqlClient
Partial Class SysPRICE
    Inherits System.Web.UI.Page
    Dim Syscrf As New SystemBLL()
    Dim sysuserinfo As New USERINFOBLL
    Dim struserinfo As New UserInfo
    Private PageSearch As New PageShareMethod
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        delete_btn.Attributes.Add("onclick", "javascript:return confirm('Are you sure to delete ?');")
        GridViewBind()
        GridViewCount()
    End Sub


    Public Sub GridViewBind()
        Dim conn As New SqlConnection(Syscrf.Context)
        conn.Open()
        Dim da As New SqlDataAdapter("SELECT * from PRICETABLE " & strWhereTxt() & "  ORDER BY CreatedDate DESC", conn)
        Dim ds As New DataSet()
        da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "CRFView")
        AspNetPager1.AlwaysShow = True
        CATEGRID.DataSource = ds
        CATEGRID.DataBind()
        ds.Dispose()
        da.Dispose()
        conn.Close()
        conn.Dispose()

    End Sub


    Public Sub GridViewCount()
        Dim conn As New SqlConnection(Syscrf.Context)
        conn.Open()
        Dim cmd As New SqlCommand("SELECT count(*) from PRICETABLE  " & strWhereTxt(), conn)
        cmd.Connection = conn
        AspNetPager1.RecordCount = CInt(cmd.ExecuteScalar())
        AspNetPager1.RecordCount = CInt(cmd.ExecuteScalar())
        cmd.Dispose()
        conn.Close()
        conn.Dispose()
    End Sub

    Private Function strWhereTxt() As String
        PageSearch.AddWhereItem("cnID", txt_cnid.Text.Trim, 1)
        If txt_startdate.Text <> "" AndAlso txt_enddate.Text <> "" Then
            PageSearch.AddWhereItem("[PRICETABLE]" + ".SALESPRICE", "'" + txt_startdate.Text.Trim + "' AND '" + txt_enddate.Text.Trim + "'", PageShareMethod.Between)
        End If
        Return PageSearch.MakeWhereText()
        PageSearch = Nothing
    End Function

    Protected Sub AspNetPager1_PageChanging(ByVal src As Object, ByVal e As Wuqi.Webdiyer.PageChangingEventArgs) Handles AspNetPager1.PageChanging
        AspNetPager1.CurrentPageIndex = e.NewPageIndex
        GridViewBind()
        GridViewCount()
    End Sub