web/KTLIn.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 KTLIn
    Inherits System.Web.UI.Page
    Dim Syscrf As New SystemBLL()
    Dim sysitem As New Choseitembll
    Dim stritem As New Choseitem
    Dim syspost As New INVENTJOURNALTABLEBLL
    Dim strpost As New INVENTJOURNALTABLE
    Dim strtrans As New INVENTJOURNALTRANS
    Dim systrans As New INVENTJOURNALTRANSBLL
    Private PageSearch As New PageShareMethod
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            LocationTypeGrid()
            'DivLocation()
            getaccount()
            Me.CATEGRID.Attributes.Add("SortExpression", "CNID")
            Me.CATEGRID.Attributes.Add("SortDirection", "ASC")
            Me.dataview.Attributes.Add("SortExpression", "CNID")
            Me.dataview.Attributes.Add("SortDirection", "ASC")
            If Syscrf.countfield("SELECT count(*) from [Choseitem] where createdby='" & Request.Cookies("sh")("userid").ToString & "' and Journalstatus=0") > 0 Then
                Panel1.Visible = True
                DataviewBind()
            End If
            Jscript.BindDateCalendar(txt_transdate)
            txt_transdate.Text = Now.Year.ToString & "-" & Now.Month.ToString & "-" & Now.Day.ToString

        End If
    End Sub
    Public Sub getaccount()
        Dim strsql As String = "SELECT SUM(PRICE) AS price , COUNT(CNID) AS count  FROM [ERPToLGT]  " & 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 [ERPToLGT] " & strWhereTxt()).Tables(0)
        dt.DefaultView.Sort = String.Format("{0} {1}", SortExpression, SortDirection)
        Me.CATEGRID.DataSource = dt
        Me.CATEGRID.DataBind()
    End Sub

    Private Sub DataviewBind()
        Dim SortDirection As String = Me.CATEGRID.Attributes("SortDirection").ToString()