📄 frm_sales_update_form.frm
字号:
Height = 495
Index = 11
Left = 120
TabIndex = 27
Top = 1680
Width = 1575
End
Begin VB.Label Label1
BackColor = &H00FFFFFF&
Caption = "Total Amount"
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 4800
TabIndex = 26
Top = 2160
Width = 1335
End
Begin VB.Label Label1
BackColor = &H00FFFFFF&
Caption = "Price Per Unit"
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 6
Left = 2040
TabIndex = 25
Top = 2160
Width = 1335
End
Begin VB.Label Label1
BackColor = &H00FFFFFF&
Caption = "Qty"
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 120
TabIndex = 24
Top = 2160
Width = 375
End
End
Begin VB.TextBox Text2
Appearance = 0 'Flat
BeginProperty Font
Name = "Tahoma"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 855
Left = 4920
MultiLine = -1 'True
TabIndex = 19
Top = 6000
Width = 2775
End
Begin Crystal.CrystalReport CrystalReport1
Left = 600
Top = 5040
_ExtentX = 741
_ExtentY = 741
_Version = 348160
WindowControlBox= -1 'True
WindowMaxButton = -1 'True
WindowMinButton = -1 'True
WindowState = 2
PrintFileLinesPerPage= 60
End
Begin MSDataGridLib.DataGrid DataGrid2
Height = 1335
Left = 120
TabIndex = 21
Top = 5520
Width = 4455
_ExtentX = 7858
_ExtentY = 2355
_Version = 393216
AllowUpdate = -1 'True
BackColor = 11461862
ForeColor = 128
HeadLines = 1
RowHeight = 16
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Tahoma"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Caption = "Current Bill Items"
ColumnCount = 7
BeginProperty Column00
DataField = "item_name"
Caption = "Item Name"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "qty"
Caption = "QTY"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "price_p_unit"
Caption = "Rate Per Unit"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "total_amt"
Caption = "Total Amount"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "item_type"
Caption = "Item Type"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "purchased_from"
Caption = "Purchased From"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column06
DataField = "INVOICE_NO"
Caption = "Invoice Number"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 1033
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
ColumnWidth = 2085.166
EndProperty
BeginProperty Column01
ColumnWidth = 2085.166
EndProperty
BeginProperty Column02
ColumnWidth = 2085.166
EndProperty
BeginProperty Column03
ColumnWidth = 2085.166
EndProperty
BeginProperty Column04
ColumnWidth = 2085.166
EndProperty
BeginProperty Column05
ColumnWidth = 2085.166
EndProperty
BeginProperty Column06
ColumnWidth = 2085.166
EndProperty
EndProperty
End
Begin LVbuttons.LaVolpeButton cmd
Height = 375
Left = 8040
TabIndex = 20
Top = 6480
Width = 1815
_ExtentX = 3201
_ExtentY = 661
BTYPE = 3
TX = "&Update Invoice"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 2
BCOL = 14737632
FCOL = 0
FCOLO = 0
EMBOSSM = 12632256
EMBOSSS = 16777215
MPTR = 0
MICON = "FRM_SALES_UPDATE_FORM.frx":00C4
ALIGN = 1
IMGLST = "(None)"
IMGICON = "(None)"
ICONAlign = 0
ORIENT = 0
STYLE = 0
IconSize = 2
SHOWF = -1 'True
BSTYLE = 0
End
Begin VB.Label Label2
BackColor = &H00FFFFFF&
BackStyle = 0 'Transparent
Caption = "Modify Sales Entry ..."
BeginProperty Font
Name = "Verdana"
Size = 15.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 495
Left = 240
TabIndex = 39
Top = 0
Width = 5175
End
Begin VB.Label issues
BackStyle = 0 'Transparent
Caption = "Please Be Sure while updating Sales entry in to Sales Master."
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 375
Left = 1800
TabIndex = 38
Top = 480
Width = 9135
End
Begin VB.Label Label1
BackColor = &H00FFFFFF&
Caption = "Items Description"
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 12
Left = 4920
TabIndex = 37
Top = 5760
Width = 1935
End
Begin VB.Image Image1
Height = 840
Left = 0
Picture = "FRM_SALES_UPDATE_FORM.frx":00E0
Stretch = -1 'True
Top = 0
Width = 10080
End
End
Attribute VB_Name = "FRM_SALES_UPDATE_FORM"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs_custo_datail As New ADODB.Recordset
Dim rs_sales_master As New ADODB.Recordset
Dim rs_cust_system_detail As New ADODB.Recordset
Dim RS_ITEM As New ADODB.Recordset
Dim rs_item_type As New ADODB.Recordset
Dim rs_cur_invoice_item As New ADODB.Recordset
Dim RS_PUR_ITEMS As New ADODB.Recordset
Dim INVOICE_NUMBER As String
Dim rs_cur_record_count As New ADODB.Recordset
Dim Status As Boolean
Dim RS_SALES_INVOICE_DESC As New ADODB.Recordset
Public SNAME As String
Public FNAME As String
Public SALE_TYPE As String
Public SYSTEM_QTY As Integer
Public TOTAL_TRAN_AMT As Double
Dim GRID2_CLICKED As Boolean
Private Sub cmd_Click()
If SALE_TYPE = "SYSTEM" Then
Dim d As New ADODB.Recordset
d.Open "SELECT * FROM CHECK_QTY", db, adOpenDynamic, adLockOptimistic
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -