| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 971 人关注过本帖, 1 人收藏
标题:VB高手帮个忙
只看楼主 加入收藏
msl5225017
Rank: 1
等 级:新手上路
帖 子:6
专家分:0
注 册:2009-10-17
结帖率:0
收藏(1)
已结贴  问题点数:10 回复次数:5 
VB高手帮个忙



编制程序,进行客户信息管理。给出窗体,完成如下功能:
1、    输入客户信息,至少包括:客户代号、姓名、生日、客户类型、消费额和电话;
2、    将信息保存在文件中;
3、    查询信息:按姓名、按生日;
4、    按消费额排序。

要求:
提交综合报告,报告内容包括:
    A、窗体设计画面;
    B、设计窗体的详细操作步骤;
    C、程序的代码。

会的请加QQ  305792776  或发送到我的邮箱里305792776@ 用您10分钟时间帮小弟解决一下燃眉之急。没学过VB要会都不麻烦大家了。
搜索更多相关主题的帖子: 我的邮箱 时间 电话 姓名 
2009-10-17 13:23
suxin868
Rank: 4
等 级:业余侠客
威 望:1
帖 子:145
专家分:203
注 册:2008-12-31
收藏
得分:5 
不知道高手的标准是什么,但我10分钟绝对完成不了你的这个作业。我估计没人会花时间,花精力去帮你做作业的。除非你雇人

--------------当你无力改变这个世界的时候,就让这个世界改变你-------------------
2009-10-17 15:43
msl5225017
Rank: 1
等 级:新手上路
帖 子:6
专家分:0
注 册:2009-10-17
收藏
得分:0 
VERSION 5.00
Object = "{BEEECC20-4D5F-4F8B-BFDC-5D9B6FBDE09D}#1.0#0"; "vsFlex8.ocx"
Begin VB.Form Form1  
   Caption         =   "Form1"
   ClientHeight    =   6585
   ClientLeft      =   60
   ClientTop       =   465
   ClientWidth     =   10440
   LinkTopic       =   "Form1"
   ScaleHeight     =   6585
   ScaleWidth      =   10440
   StartUpPosition =   3  '窗口缺省
   Begin Command2  
      Caption         =   "模糊搜索(按姓名,生日)"
      Height          =   615
      Left            =   5760
      TabIndex        =   4
      Top             =   5400
      Width           =   1695
   End
   Begin VB.TextBox Text1  
      Height          =   615
      Left            =   2880
      TabIndex        =   3
      Top             =   5400
      Width           =   1575
   End
   Begin VSFlex8Ctl.VSFlexGrid VSFlexGrid1  
      Height          =   2775
      Left            =   2040
      TabIndex        =   2
      Top             =   1680
      Width           =   7575
      _cx             =   13361
      _cy             =   4895
      Appearance      =   1
      BorderStyle     =   1
      Enabled         =   -1  'True
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}  
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      MousePointer    =   0
      BackColor       =   -2147483643
      ForeColor       =   -2147483640
      BackColorFixed  =   -2147483633
      ForeColorFixed  =   -2147483630
      BackColorSel    =   -2147483635
      ForeColorSel    =   -2147483634
      BackColorBkg    =   -2147483636
      BackColorAlternate=   -2147483643
      GridColor       =   -2147483633
      GridColorFixed  =   -2147483632
      TreeColor       =   -2147483632
      FloodColor      =   192
      SheetBorder     =   -2147483642
      FocusRect       =   1
      HighLight       =   1
      AllowSelection  =   -1  'True
      AllowBigSelection=   -1  'True
      AllowUserResizing=   0
      SelectionMode   =   0
      GridLines       =   1
      GridLinesFixed  =   2
      GridLineWidth   =   1
      Rows            =   50
      Cols            =   10
      FixedRows       =   1
      FixedCols       =   1
      RowHeightMin    =   0
      RowHeightMax    =   0
      ColWidthMin     =   0
      ColWidthMax     =   0
      ExtendLastCol   =   0   'False
      FormatString    =   ""
      ScrollTrack     =   0   'False
      ScrollBars      =   3
      ScrollTips      =   0   'False
      MergeCells      =   0
      MergeCompare    =   0
      AutoResize      =   -1  'True
      AutoSizeMode    =   0
      AutoSearch      =   0
      AutoSearchDelay =   2
      MultiTotals     =   -1  'True
      SubtotalPosition=   1
      OutlineBar      =   0
      OutlineCol      =   0
      Ellipsis        =   0
      ExplorerBar     =   0
      PicturesOver    =   0   'False
      FillStyle       =   0
      RightToLeft     =   0   'False
      PictureType     =   0
      TabBehavior     =   0
      OwnerDraw       =   0
      Editable        =   0
      ShowComboButton =   1
      WordWrap        =   0   'False
      TextStyle       =   0
      TextStyleFixed  =   0
      OleDragMode     =   0
      OleDropMode     =   0
      DataMode        =   0
      VirtualData     =   -1  'True
      DataMember      =   ""
      ComboSearch     =   3
      AutoSizeMouse   =   -1  'True
      FrozenRows      =   0
      FrozenCols      =   0
      AllowUserFreezing=   0
      BackColorFrozen =   0
      ForeColorFrozen =   0
      WallPaperAlignment=   9
      AccessibleName  =   ""
      AccessibleDescription=   ""
      AccessibleValue =   ""
      AccessibleRole  =   24
   End
   Begin Command1  
      Caption         =   "add"
      Height          =   375
      Left            =   5760
      TabIndex        =   1
      Top             =   4680
      Width           =   1815
   End
   Begin VB.Label Label1  
      AutoSize        =   -1  'True
      Caption         =   "客户信息管理"
      BeginProperty Font  
         Name            =   "宋体"
         Size            =   36
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   720
      Left            =   3480
      TabIndex        =   0
      Top             =   480
      Width           =   4320
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
 
 
 
 
 
 
Private Sub Command1_Click()
    Form2.Show vbModal
End Sub
 
Private Sub Command2_Click()
    Call search
End Sub
 
Private Sub Form_Load()
    Call init
End Sub
 
 
 
Sub init()
    strSQL = "select * from [user] order by qian asc"
    Set rs = conn.Execute(strSQL)
    Set VSFlexGrid1.DataSource = rs
    rs.Close
End Sub
 
 
 
 
Sub search()
    strSQL = "select * from [user] where [name] like '%" & Text1.Text & "%' or birthday like '%" & Text1.Text & "%' order by qian asc"
    Set rs = conn.Execute(strSQL)
    Set VSFlexGrid1.DataSource = rs
    rs.Close
End Sub
 
2009-10-17 16:27
msl5225017
Rank: 1
等 级:新手上路
帖 子:6
专家分:0
注 册:2009-10-17
收藏
得分:0 
VERSION 5.00
Begin VB.Form Form2  
   Caption         =   "Form2"
   ClientHeight    =   4245
   ClientLeft      =   60
   ClientTop       =   465
   ClientWidth     =   8115
   LinkTopic       =   "Form2"
   ScaleHeight     =   4245
   ScaleWidth      =   8115
   StartUpPosition =   3  '窗口缺省
   Begin Combo4  
      Height          =   300
      Left            =   2040
      TabIndex        =   15
      Top             =   1800
      Width           =   2775
   End
   Begin Combo3  
      Height          =   300
      Left            =   3840
      TabIndex        =   14
      Text            =   "Combo3"
      Top             =   1320
      Width           =   855
   End
   Begin Combo2  
      Height          =   300
      Left            =   3000
      TabIndex        =   13
      Text            =   "Combo2"
      Top             =   1320
      Width           =   495
   End
   Begin Combo1  
      Height          =   300
      Left            =   1920
      TabIndex        =   12
      Top             =   1320
      Width           =   735
   End
   Begin Command2  
      Caption         =   "取消"
      Height          =   375
      Left            =   3480
      TabIndex        =   11
      Top             =   3720
      Width           =   1095
   End
   Begin VB.TextBox Text6  
      Height          =   495
      Left            =   2040
      TabIndex        =   9
      Top             =   3000
      Width           =   2775
   End
   Begin Command1  
      Caption         =   "保存"
      Height          =   495
      Left            =   1680
      TabIndex        =   3
      Top             =   3600
      Width           =   1455
   End
   Begin VB.TextBox Text5  
      Height          =   375
      Left            =   2040
      TabIndex        =   2
      Text            =   "0"
      Top             =   2520
      Width           =   2775
   End
   Begin VB.TextBox Text2  
      Height          =   375
      Left            =   2040
      TabIndex        =   1
      Top             =   720
      Width           =   2655
   End
   Begin VB.TextBox Text1  
      Enabled         =   0   'False
      Height          =   495
      Left            =   2040
      TabIndex        =   0
      Top             =   120
      Width           =   2655
   End
   Begin VB.Label Label8  
      Caption         =   "如:13812345678"
      Height          =   375
      Left            =   5160
      TabIndex        =   17
      Top             =   3120
      Width           =   1455
   End
   Begin VB.Label Label7  
      Caption         =   "如:1000"
      Height          =   375
      Left            =   5280
      TabIndex        =   16
      Top             =   2520
      Width           =   975
   End
   Begin VB.Label Label6  
      Caption         =   "电话"
      Height          =   255
      Left            =   600
      TabIndex        =   10
      Top             =   3240
      Width           =   735
   End
   Begin VB.Label Label5  
      Caption         =   "消费额"
      Height          =   375
      Left            =   600
      TabIndex        =   8
      Top             =   2520
      Width           =   975
   End
   Begin VB.Label Label4  
      Caption         =   "客户类型"
      Height          =   375
      Left            =   600
      TabIndex        =   7
      Top             =   1920
      Width           =   975
   End
   Begin VB.Label Label3  
      Caption         =   "生日"
      Height          =   375
      Left            =   480
      TabIndex        =   6
      Top             =   1320
      Width           =   855
   End
   Begin VB.Label Label2  
      Caption         =   "姓名"
      Height          =   375
      Left            =   480
      TabIndex        =   5
      Top             =   720
      Width           =   735
   End
   Begin VB.Label Label1  
      Caption         =   "客户代号"
      Height          =   495
      Left            =   480
      TabIndex        =   4
      Top             =   120
      Width           =   855
   End
End
Attribute VB_Name = "Form2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
    Dim birthday As String
    birthday = Combo1.Text & "-" & Combo2.Text & "-" & Combo3.Text
    strSQL = "insert into  [user](userid,name,birthday,type,qian,tel) values(" & Text1.Text & ",'" & Text2.Text & "','" & birthday & "','" & Combo4.Text & "'," & Val(Text5.Text) & ",'" & Text6.Text & "')"
    Set rs = conn.Execute(strSQL)
    Form1.init
     
     
End Sub
 
Private Sub Command2_Click()
    End
End Sub
 
Private Sub Form_Load()
    strSQL = "select top 1 userid  from  [user] order by userid desc"
    Set rs = conn.Execute(strSQL)
    Text1.Text = rs("userid") + 1
    rs.Close
     
     
    Combo1.Text = "1949": Combo2.Text = "1": Combo3.Text = "1"
    For i = 1950 To 2008
        Combo1.AddItem i
    Next
    For i = 2 To 12
        Combo2.AddItem i
    Next
    For i = 2 To 31
        Combo3.AddItem i
    Next
 
    Combo4.Text = "普通客户"
    Combo4.AddItem "高级客户"
    Combo4.AddItem "vip客户"
 
End Sub
 



不知道这答案对吗?请各路高手看一下。
2009-10-17 16:28
mafia3k
Rank: 1
等 级:新手上路
帖 子:9
专家分:7
注 册:2009-10-12
收藏
得分:5 
回复 4楼 msl5225017
恩。很强啊。不过为啥你要搞的那么复杂,而且还不用version 6.0,还自问自答
2009-10-17 21:48
suxin868
Rank: 4
等 级:业余侠客
威 望:1
帖 子:145
专家分:203
注 册:2008-12-31
收藏
得分:0 
回复 楼主 msl5225017
setup.part1.rar (1.43 MB)
setup.part2.rar (763.81 KB)

--------------当你无力改变这个世界的时候,就让这个世界改变你-------------------
2009-10-20 17:58
快速回复:VB高手帮个忙
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.024309 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved