web/Sales.aspx.vb

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

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

Imports BLL
Imports Model
Imports System.Data
Imports System.Data.SqlClient
Imports System.Drawing
Imports System.Drawing.Imaging
Imports System.IO
Partial Class Sales
    Inherits System.Web.UI.Page
    Dim Syscrf As New SystemBLL()
    Private PageSearch As New PageShareMethod


    Protected imagePath As String

    Protected imageType As String

    Protected imageName As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            'getbatchno()
            'DropTypeGrid()
            'PRODTypeGrid()
            LocationTypeGrid()
            Me.CATEGRID.Attributes.Add("SortExpression", "itemid")
            Me.CATEGRID.Attributes.Add("SortDirection", "ASC")
            getaccount()
            GridViewBind()
            'Dim dt As DataTable = Syscrf.seachData("select ACCOUNT from userinfo where userid='" & Request.Cookies("usoffice")("eua").ToString.Trim & "'").Tables(0)
            'If dt.Rows(0)("ACCOUNT").ToString = "admin" Then
            '    Lb_salesid.Visible = True
            '    'txt_SALESID.Visible = True
            'Else
            '    Lb_salesid.Visible = False
            '    'txt_SALESID.Visible = False
            'End If
        End If

    End Sub
    Public Sub getaccount()
        Dim strsql As String = "SELECT SUM(PRICE) AS price , COUNT(itemid) AS count  FROM [INVENTSUMVIEW]  " & strWhereTxt()
        Dim dt As DataTable = Syscrf.seachData(strsql).Tables(0)
        If dt.Rows(0)("price").ToString.Length > 0 Then
            Dim intprice As Integer = dt.Rows(0)("price")
            txt_account.Text = intprice.ToString("n")
        Else
            txt_account.Text = "0"
        End If

        txt_account0.Text = dt.Rows(0)("count").ToString
    End Sub


    Private Sub GridViewBind()
        Dim SortDirection As String = Me.CATEGRID.Attributes("SortDirection").ToString()
        Dim SortExpression As String = Me.CATEGRID.Attributes("SortExpression").ToString()
        Dim dt As DataTable = Syscrf.seachData("SELECT * from [INVENTSUMVIEW] " & strWhereTxt()).Tables(0)
        dt.DefaultView.Sort = String.Format("{0} {1}", SortExpression, SortDirection)
        Me.CATEGRID.DataSource = dt
        Me.CATEGRID.DataBind()