[计算机软件及应用]程序代码.docVIP

仓储管理系统代码 【李彩享、字朝龙】 一、窗体（frmLogin）登录的代码程序 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WMS { public partial class frmLogin : Form { public static string M_str_name; //记录登录用户名字 public static string M_str_pwd; //记录登录用户密码 public static string M_str_right; //记录登录用户的权限 public frmLogin() { InitializeComponent(); } private void frmLogin_Load(object sender, EventArgs e) //启动窗口时加载用户名 { DbOperator db = new DbOperator(); SqlConnection cnn = db.GetCon(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = select UserName from tbUserInfo ; // cmd.Connection = cnn; cnn.Open(); SqlDataReader dr; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { cmbUserList.Items.Add(dr[UserName].ToString().Trim());//在控件中显示用户名 } cmbUserList.Sorted=true; } else { MessageBox.Show(表中无记录！, 提示?, MessageBoxButtons.YesNo, MessageBoxIcon.Information); } dr.Close(); cnn.Close(); } private void btnCancel_Click(object sender, EventArgs e) { if (MessageBox.Show(你确定要退出吗?, 提示?, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) this.Close(); else cmbUserList.Focus(); return; } private void btnLoad_Click(object sender, EventArgs e)//用存储过程实现验证登录 { DbOperator db = new DbOperator(); SqlConnection cnn = db.GetCon();