C#_会员管理系统：开发七（用户分类）

最新推荐文章于 2024-02-28 10:13:10 发布

weixin_30859423

最新推荐文章于 2024-02-28 10:13:10 发布

阅读量225

点赞数

文章标签： c# 数据库操作系统

原文链接：http://www.cnblogs.com/start-from-scratch/p/5429849.html

版权

登录界面(VIPLogin.cs)详细代码：

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Configuration;
  5 using System.Data;
  6 using System.Drawing;
  7 using System.Linq;
  8 using System.Text;
  9 using System.Threading.Tasks;
 10 using System.Windows.Forms;
 11 using System.Data.SqlClient;
 12 
 13 namespace 会员管理系统
 14 {
 15     public partial class VIPLogin : Form
 16     {
 17         public VIPLogin()
 18         {
 19             InitializeComponent();
 20         }
 21         //用于连接配置文件App.config
 22         string connStr = ConfigurationManager.ConnectionStrings["str"].ConnectionString;
 23         //定义一个全局变量 Uid;
 24         //用于获取登录成功后的用户名
 25         public static string uid;
 26         //定义一个全局变量 time;
 27         //用于获取用户登录时的时间
 28         public static DateTime time;
 29         //定义一个全局变量situation
 30         //用于获取用户的登录状态
 31         public static string situation;
 32         //定义一个全局变量UserType
 33         //用于获取用户权限
 34         public static string UserType;
 35 
 36         //登录按钮
 37         private void btnLogin_Click(object sender, EventArgs e)
 38         {
 39             //连接数据库语句
 40             using(SqlConnection con=new SqlConnection(connStr))
 41             {
 42                 //操作数据库语句
 43                 string sql = "select vuserpwd,usertype from vipaccount where vUserName='" + txtName.Text + "'";
 44                 using(SqlCommand cmd=new SqlCommand(sql,con))
 45                 {
 46                     //打开数据库
 47                     con.Open();
 48                     //使用 SqlDataReader 来 读取数据库
 49                     using (SqlDataReader sdr = cmd.ExecuteReader())
 50                     {
 51                         //SqlDataReader 在数据库中为 从第1条数据开始 一条一条往下读
 52                         if (sdr.Read()) //如果读取账户成功(文本框中的用户名在数据库中存在)
 53                         {
 54                             //则将第1条 密码 赋给 字符串pwd  ,并且依次往后读取 所有的密码
 55                             //Trim()方法为移除字符串前后的空白
 56                             string pwd = sdr.GetString(0).Trim();
 57                             //读取器sdr获取了2列数据 第1列为密码 第2列 即索引为1的是用户类型
 58                             string uType = sdr.GetString(1).Trim() ;
 59                             //如果 文本框中输入的密码 ==数据库中的密码
 60                             if (pwd == txtPwd.Text)
 61                             {
 62                                 uid = txtName.Text;
 63                                 time = DateTime.Now;
 64                                 situation = "登录";
 65                                 //将登录成功的用户类型 赋给全局变量UserType
 66                                 //用于获取当前登录 用户的类型
 67                                 UserType = uType;
 68                                 //说明在该账户下 密码正确, 系统登录成功
 69                                 MessageBox.Show("登录成功，正在进入主界面......");
 70                                 //***************新增代码***************
 71                                 VIPLog vl = new VIPLog();
 72                                 //添加当前的用户信息到日志中
 73                                 vl.AddMsg();
 74                                 //退出程序
 75                                 //创建新的会员资料管理界面窗体并显示，同时把登录界面隐藏
 76                                 //VIPManager vm=new VIPManager();
 77                                 VIPMain vmain = new VIPMain();
 78                                 vmain.Show();
 79                                 this.Hide();
 80                                 //***************新增代码***************
 81                             }
 82                             else
 83                             {
 84                                 //密码错误
 85                                 MessageBox.Show("密码错误，请重新输入");
 86                                 txtPwd.Text = "";
 87                             }
 88                         }
 89                         else
 90                         {
 91                             //用户名错误
 92                             MessageBox.Show("用户名错误，请重新输入!");
 93                             txtName.Text = "";
 94                         }
 95                     }
 96                 }
 97             }
 98         }
 99         
100         //设置快捷键
101         private void VIPLogin_KeyDown(object sender, KeyEventArgs e)
102         {
103             //如果按下ESC键
104             if (e.KeyCode == Keys.Escape)
105             {
106                 //关闭窗体
107                 this.Close();
108             }
109             //如果按下F5键
110             else if (e.KeyCode == Keys.F5)
111             {
112                 //调用登录按钮单击事件
113                 this.btnLogin_Click(null,null);
114             }
115         }
116 
117         //关闭
118         private void btnClose_Click(object sender, EventArgs e)
119         {
120             //彻底的退出
121             System.Environment.Exit(0);
122         }
123 
124         //当登录窗体为活动窗体时
125         private void VIPLogin_Activated(object sender, EventArgs e)
126         {
127             //设置文本框txtName获得焦点
128             txtName.Focus();
129         }
130 
131         //获取文本框txtName的快捷键
132         private void txtName_KeyUp(object sender, KeyEventArgs e)
133         {
134             if (e.KeyCode == Keys.Enter)
135             {
136                 txtPwd.Focus();
137                 txtPwd.SelectAll();
138             }
139         }
140 
141         //获取文本框txtPwd的快捷键
142         private void txtPwd_KeyUp(object sender, KeyEventArgs e)
143         {
144             if (e.KeyCode == Keys.Enter)
145             {
146                 btnLogin_Click(null, null);
147             }
148         }
149     }
150 }

主界面(VIPMain.cs)新增一个Label控件：

详细代码如下：

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Linq;
  7 using System.Text;
  8 using System.Threading.Tasks;
  9 using System.Windows.Forms;
 10 
 11 namespace 会员管理系统
 12 {
 13     public partial class VIPMain : Form
 14     {
 15         public VIPMain()
 16         {
 17             InitializeComponent();
 18         }
 19 
 20         private void btnVIPManager_Click(object sender, EventArgs e)
 21         {
 22             VIPManager vm = new VIPManager();
 23             vm.Show();
 24             this.Hide();
 25         }
 26 
 27         private void btnVIPLogin_Click(object sender, EventArgs e)
 28         {
 29             VIPLog vipl = new VIPLog();
 30             vipl.GetExitTime();
 31             vipl.AddMsg();
 32             VIPLogin vp = new VIPLogin();
 33             vp.Show();
 34             this.Hide();
 35         }
 36 
 37         private void btnClose_Click(object sender, EventArgs e)
 38         {
 39             VIPLog vipl = new VIPLog();
 40             vipl.GetExitTime();
 41             vipl.AddMsg();
 42             //彻底的退出
 43             System.Environment.Exit(0);
 44         }
 45 
 46         private void btnPwdChange_Click(object sender, EventArgs e)
 47         {
 48             VIPPwdChange vpc = new VIPPwdChange();
 49             vpc.Show();
 50             this.Hide();
 51         }
 52 
 53         private void VIPMain_Load(object sender, EventArgs e)
 54         {
 55             lblCurrentUser.Text = "当前登录用户为："+VIPLogin.uid+ "   用户类型：" + VIPLogin.UserType + "   登录时间为："+VIPLogin.time;
 56             //给当前用户打招呼 
 57             //这里通过获取当前用户电脑上的时间 以及判断登录用户的类型 来给不同类型的用户打招呼  
 58             // 定义整型变量 intTime 来获取 用户电脑上的具体小时数 然后在如下进行判断
 59             int inttime = VIPLogin.time.Hour;
 60             //获取VIPLogin窗体的全局变量 UserType 用户类型, 用于给不同类型的用户打招呼
 61             string uType = VIPLogin.UserType;
 62             //在凌晨0-6点的时候
 63             if (inttime >= 0 && inttime < 6)
 64             {
 65                 if (uType == "Administrator")
 66                 {
 67                     lblSayHi.Text = "尊敬的"+ VIPLogin.uid + "您好,现在已夜深，请注意休息！";
 68                 }
 69                 else if (uType == "NormalUser")
 70                 {
 71                     lblSayHi.Text = "亲爱的" + VIPLogin.uid + "您好,现在已夜深，请注意休息！";
 72                 }
 73             }
 74             //早上6点-中午12点的时候
 75             else if (inttime >= 6 && inttime < 12)
 76             {
 77                 if (uType == "Administrator")
 78                 {
 79                     lblSayHi.Text = "尊敬的" + VIPLogin.uid + "早上好！";
 80                 }
 81                 else if (uType == "NormalUser")
 82                 {
 83                     lblSayHi.Text = "亲爱的" + VIPLogin.uid + "早上好！";
 84                 }
 85             }
 86             //中午12点-下午6点的时候
 87             else if (inttime >= 12 && inttime < 18)
 88             {
 89                 if (uType == "Administrator")
 90                 {
 91                     lblSayHi.Text = "尊敬的" + VIPLogin.uid + "下午好！";
 92                 }
 93                 else if (uType == "NormalUser")
 94                 {
 95                     lblSayHi.Text = "亲爱的" + VIPLogin.uid + "下午好！";
 96                 }
 97             }
 98             //晚上
 99             else if (inttime >= 18 && inttime < 24)
100             {
101                 if (uType == "Administrator")
102                 {
103                     lblSayHi.Text = "尊敬的" + VIPLogin.uid + "晚上好！";
104                 }
105                 else if (uType == "NormalUser")
106                 {
107                     lblSayHi.Text = "亲爱的" + VIPLogin.uid + "晚上好！";
108                 }
109             }
110             //否则 默认为
111             else 
112             {
113                 lblSayHi.Text = "欢迎使用会员管理系统！";
114             }
115             //判断用户类型 并给用户设置功能权限
116             if (uType == "NormalUser")
117             {
118                 btnRegistration.Enabled = false;
119                 btnLog.Enabled = false;
120             }
121         }
122 
123         private void btnLog_Click(object sender, EventArgs e)
124         {
125             VIPLog vl=new VIPLog();
126             vl.Show();
127             this.Hide();
128         }
129 
130         private void btnRegistration_Click(object sender, EventArgs e)
131         {
132             VIPRegistration vrn = new VIPRegistration();
133             vrn.Show();
134             this.Hide();
135         }
136     }
137 }

会员资料管理(VIPManager.cs)详细代码：

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Configuration;
  5 using System.Data;
  6 using System.Data.SqlClient;
  7 using System.Drawing;
  8 using System.Linq;
  9 using System.Text;
 10 using System.Threading.Tasks;
 11 using System.Windows.Forms;
 12 
 13 namespace 会员管理系统
 14 {
 15     public partial class VIPManager : Form
 16     {
 17         public VIPManager()
 18         {
 19             InitializeComponent();
 20         }
 21 
 22         //连接字符串 获取配置文件里的连接路径,多次需要调用，放在外面方便
 23         static string connStr = ConfigurationManager.ConnectionStrings["str"].ConnectionString;
 24         //窗体运行自动加载
 25         private void VipManager_Load(object sender, EventArgs e)
 26         {
 27             //刷新数据
 28             Refresh();
 29             cmbforfieldSelecting.Text = "全局搜索";
 30             cmbforfieldSelecting.Items.Add("全局搜索");
 31             cmbforfieldSelecting.Items.Add("编号");
 32             cmbforfieldSelecting.Items.Add("名字");
 33             cmbforfieldSelecting.Items.Add("性别");
 34             cmbforfieldSelecting.Items.Add("年龄");
 35             cmbforfieldSelecting.Items.Add("地址");
 36             cmbforfieldSelecting.Items.Add("电话");
 37             //添加对用户 类型的判断 用来设置功能按钮的使用权限
 38             if (VIPLogin.UserType == "NormalUser")
 39             {
 40                 btnAdd.Enabled = false;
 41                 btnDelete.Enabled = false;
 42                 btnSave.Enabled = false;
 43             }
 44         }
 45 
 46         //写一个刷新数据的方法(跟查看数据一样)
 47         public void Refresh(bool isAdded = false)
 48         {
 49             //查询数据库字符串
 50             string sql = String.Format("select vId '{0}',vName '{1}',vGender '{2}',vAge '{3}',vAddress '{4}',vPhone '{5}' from VipInformation", "编号", "名字", "性别", "年龄", "地址", "电话");
 51             //连接数据库对象
 52             SqlConnection conn = new SqlConnection(connStr);
 53             //操作数据库对象
 54             SqlCommand cmd = new SqlCommand(sql, conn);
 55             //创建表对象
 56             System.Data.DataTable dt = new System.Data.DataTable();
 57             //创建数据库填充操作对象(语句)
 58             SqlDataAdapter sda = new SqlDataAdapter(cmd);
 59             //把数据填充进dt表中
 60             sda.Fill(dt);
 61             //指定dgvManager控件的数据源:dt
 62             dgvManager.DataSource = dt;
 63 
 64             //if (isAdded)
 65             //{
 66             //    if (dt.Rows.Count > 0)
 67             //        dgvManager.Rows[0].Selected = false;
 68             //    dgvManager.Rows[dt.Rows.Count - 1].Selected = true;
 69             //}
 70         }
 71 
 72         //刷新数据界面
 73         private void btnView_Click(object sender, EventArgs e)
 74         {
 75             //刷新数据
 76             Refresh();
 77         }
 78 
 79         //添加数据
 80         private void btnAdd_Click(object sender, EventArgs e)
 81         {
 82             //判断文本框是否为空，提示数据完整性
 83             if (txtName.Text == "" || txtGender.Text == "" || txtAge.Text == "" || txtAddress.Text == "" || txtPhone.Text == "")
 84             {
 85                 MessageBox.Show("数据不能为空，请填写齐全");
 86                 return;
 87             }
 88             //插入数据库字符串
 89             string sql = string.Format("insert into VipInformation values('{0}','{1}',{2},'{3}','{4}')",txtName.Text.Trim(),txtGender.Text.Trim(),txtAge.Text.Trim(),txtAddress.Text.Trim(),txtPhone.Text.Trim());
 90             //连接数据库对象
 91             SqlConnection conn = new SqlConnection(connStr);
 92             //操作数据库对象
 93             SqlCommand cmd = new SqlCommand(sql, conn);
 94             //创建表对象
 95             System.Data.DataTable dt = new DataTable();
 96             //创建数据库填充操作对象(语句)
 97             SqlDataAdapter sda = new SqlDataAdapter(cmd);
 98             //把数据填充进dt表中
 99             sda.Fill(dt);
100             //指定dgvManager控件的数据源:dt
101             dgvManager.DataSource = dt;
102             //刷新数据
103             Refresh();
104         }
105 
106         //删除数据
107         private void btnDelete_Click(object sender, EventArgs e)
108         {
109             //使用sql删除语句,where 1=1 就是没有条件，等于全部数据删除
110             string sql = "delete from VipInformation where 1=1";
111             //如果选中某行则执行
112             if (dgvManager.CurrentRow.Selected)
113             {
114                 sql = sql + " and vid=" + Convert.ToInt32(dgvManager.CurrentRow.Cells[0].Value.ToString());
115             }
116             int n = 0;
117             //创建连接数据库对象
118             SqlConnection conn = new SqlConnection(connStr);
119             //创建操作数据库对象
120             SqlCommand cmd = new SqlCommand(sql, conn);
121             //打开数据库
122             conn.Open();
123             //取得ExecuteNonQuery返回的受影响行数，无影响则为0
124             n = cmd.ExecuteNonQuery();
125             if (n == 0)
126             {
127                 MessageBox.Show("删除操作失败!不存在的ID");
128                 conn.Close();
129                 return;
130             }
131             else if (n > 0)
132             {
133                 MessageBox.Show("删除操作成功!");
134             }
135             //关闭数据库连接
136             conn.Close();
137             //刷新数据界面
138             Refresh();
139         }
140 
141         //修改数据
142         private void btnSave_Click(object sender, EventArgs e)
143         {
144             if (txtName.Text == "" || txtGender.Text == "" || txtAge.Text == "" || txtAddress.Text == "" || txtPhone.Text == "")
145             {
146                 MessageBox.Show("所提供的数据不完整，请填写完整数据");
147                 return;
148             }
149             int n = 0;
150             //更新SQL语句
151             string sqlupdate = "update VipInformation set vName='" + txtName.Text + "',vgender='" + txtGender.Text + "',vage=" + txtAge.Text + ",vaddress='" + txtAddress.Text + "',vphone='" + txtPhone.Text + "' where vid='" + dgvManager.CurrentRow.Cells[0].Value.ToString() + "'";
152             SqlConnection conn = new SqlConnection(connStr);
153             SqlCommand cmd = new SqlCommand(sqlupdate, conn);
154             conn.Open();
155             n = cmd.ExecuteNonQuery();
156             if (n == 0)
157             {
158                 MessageBox.Show("修改操作失败！");
159                 conn.Close();
160                 return;
161             }
162             else if (n > 0)
163             {
164                 MessageBox.Show("修改操作成功!");
165             }
166             conn.Close();
167             Refresh();
168         }
169 
170         //点击dgvManager在文本框上显示
171         private void dgvManager_CellContentClick(object sender, DataGridViewCellEventArgs e)
172         {
173             txtName.Text = dgvManager.CurrentRow.Cells[1].Value.ToString();
174             txtGender.Text = dgvManager.CurrentRow.Cells[2].Value.ToString();
175             txtAge.Text = dgvManager.CurrentRow.Cells[3].Value.ToString();
176             txtAddress.Text = dgvManager.CurrentRow.Cells[4].Value.ToString();
177             txtPhone.Text = dgvManager.CurrentRow.Cells[5].Value.ToString();
178         }
179 
180         string selectedValue;
181         //事件索引改变时触发
182         private void cmbforfieldSelecting_SelectedIndexChanged(object sender, EventArgs e)
183         {
184             string strSelected = cmbforfieldSelecting.Text;
185             switch (strSelected)
186             {
187                 case "全局搜索":
188                     selectedValue = "全局搜索";
189                     break;
190                 case "编号":
191                     selectedValue="vid";
192                     break;
193                 case "名字":
194                     selectedValue = "vname";
195                     break;
196                 case "性别":
197                     selectedValue = "vgender";
198                     break;
199                 case "年龄":
200                     selectedValue = "vage";
201                     break;
202                 case "地址":
203                     selectedValue = "vaddress";
204                     break;
205                 case "电话":
206                     selectedValue = "vphone";
207                     break;
208                 default:
209                     selectedValue = "全局搜索";
210                     break;
211             }
212         }
213 
214         private void txtDataforQuery_TextChanged(object sender, EventArgs e)
215         {
216             string sql = "";
217             if (txtDataforQuery.Text.Trim() == "")
218             {
219                 //执行查询语句
220                 sql = "select * from VipInformation";
221             }
222             else if (cmbforfieldSelecting.Text.Trim() == "全局搜索" || selectedValue == "全局搜索")
223             {
224                 //全字段搜索
225                 sql = "select * from VipInformation where vName like '%" + txtDataforQuery.Text.Trim() + "%' or vgender like '%" + txtDataforQuery.Text.Trim() + "%' or vage like '%" + txtDataforQuery.Text.Trim() + "%' or vaddress like '%" + txtDataforQuery.Text.Trim() + "%' or vphone like '%" + txtDataforQuery.Text.Trim() + "%'";
226             }
227             else if (selectedValue == "vid" || selectedValue == "vname" || selectedValue == "vgender" || selectedValue == "vage" || selectedValue == "vaddress" || selectedValue == "vphone")
228             {
229                 //通过相应的字段进行搜索
230                 sql = "select * from VipInformation where " + selectedValue + " like '%" + txtDataforQuery.Text.Trim() + "%'";
231             }
232 
233             SqlConnection conn = new SqlConnection(connStr);
234             SqlCommand cmd = new SqlCommand(sql, conn);
235             conn.Open();
236             DataTable dt = new DataTable();
237             SqlDataAdapter sda = new SqlDataAdapter(cmd);
238             sda.Fill(dt);
239             dgvManager.DataSource = dt;
240             conn.Close();
241         }
242 
243         private void btnBack_Click(object sender, EventArgs e)
244         {
245             VIPMain vmain = new VIPMain();
246             vmain.Show();
247             this.Hide();
248         }
249 
250         private void btnClose_Click(object sender, EventArgs e)
251         {
252             VIPLog vpl = new VIPLog();
253             vpl.GetExitTime();
254             vpl.AddMsg();
255             //彻底的退出
256             System.Environment.Exit(0);
257         }
258          
259 
260     }
261 }

用户注册界面(VIPRegistration.cs)新增控件，如图：

详细代码：

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Linq;
  7 using System.Text;
  8 using System.Threading.Tasks;
  9 using System.Windows.Forms;
 10 using System.Data.SqlClient;
 11 using System.Configuration;
 12 
 13 namespace 会员管理系统
 14 {
 15     public partial class VIPRegistration : Form
 16     {
 17         public VIPRegistration()
 18         {
 19             InitializeComponent();
 20         }
 21 
 22 
 23         //提交按钮
 24         private void btnOK_Click(object sender, EventArgs e)
 25         {
 26             
 27             string connstr = ConfigurationManager.ConnectionStrings["str"].ConnectionString;
 28             SqlConnection conn = new SqlConnection(connstr);
 29             string sql = string.Format("select vusername from VipAccount where vUserName='{0}' ",txtName.Text);
 30             SqlCommand cmd = new SqlCommand(sql, conn);
 31             conn.Open();
 32             SqlDataReader sda=cmd.ExecuteReader();
 33 
 34             //new一个 uType 来获取 radiobutton 点击事件下 触发的用户类型赋值
 35             string uType = "";
 36             if (rdoAdministrator.Checked)
 37             {
 38                 uType = "Administrator";
 39             }
 40             else if (rdoNormalUser.Checked)
 41             {
 42                 uType = "NormalUser";
 43             }
 44             else
 45             {
 46                 uType = "NormalUser";
 47             }
 48 
 49             //---------------------------
 50             if (txtName.Text.Trim() == "")
 51             {
 52                 lblName.Text="用户名不能为空";
 53                 return;
 54             }
 55             else if (txtPwd.Text.Trim() == ""|| txtPwdConfirm.Text.Trim()=="")
 56             {
 57                 lblPwd.Text = "密码不能为空";
 58                 return;
 59             }
 60             else if (txtPwdConfirm.Text.Trim()!= txtPwd.Text.Trim())
 61             {
 62                 lblPwdConfirm.Text = "两次密码输入不同，请确认后再输";
 63                 return;
 64             }
 65             else if (sda.Read())
 66             {
 67                 lblName.Text = "用户名已存在，请重新输入";
 68                 return;
 69             }
 70             else
 71             {
 72                 conn.Close();
 73                 SqlConnection conninsert = new SqlConnection(connstr);
 74                 //string insertsql = string.Format("insert into VipAccount(vUserName,vUserPwd) values('{0}','{1}')",txtName.Text,txtPwd.Text);
 75                 string insertsql = "insert into VipAccount(vUserName,vUserPwd,UserType) values(@vUserName,@vUserPwd,@UserType) ";
 76                 //使用1个SQL参数数组 来装载 需要插入的数据
 77                 SqlParameter[] param = {
 78                                             new SqlParameter("@vUserName",txtName.Text),
 79                                             new SqlParameter("@vUserPwd",txtPwd.Text),
 80                                             new SqlParameter("@UserType",uType)
 81                                        };
 82                 
 83                 SqlCommand cmdinsert = new SqlCommand(insertsql, conninsert);
 84                 conninsert.Open();
 85                 cmdinsert.Parameters.AddRange(param);
 86                 int n = cmdinsert.ExecuteNonQuery();
 87                 if (n == 0)
 88                 {
 89                     MessageBox.Show("注册失败，请重新输入");
 90                 }
 91                 else
 92                 {
 93                     MessageBox.Show("注册成功");
 94                 }
 95                 conninsert.Close();
 96 
 97             }
 98             //conn.Close();
 99         }
100 
101         //返回主菜单
102         private void btnBack_Click(object sender, EventArgs e)
103         {
104             VIPMain vm = new VIPMain();
105             vm.Show();
106             this.Hide();
107         }
108 
109         private void VIPRegistration_Load(object sender, EventArgs e)
110         {
111             lblName.Text = "";
112             lblPwd.Text = "";
113             lblPwdConfirm.Text = "";
114         }
115         
116     }
117 }