try {
conn = new SqlConnection(Resource1.String1);
comdstr = \姓名,密码,职称,编号 from 员工\ mycomand = new SqlCommand(comdstr, conn); conn.Open();
dr = mycomand.ExecuteReader(); while (dr.Read()) {
if (dr[0].ToString().Trim(' ') == ntBx.Text) {
if (dr[1].ToString().Trim(' ') == ptBx.Text) {
bcon = true; break; } } }
if (bcon) {
if (dr[2].ToString().Trim(' ') == \管理员\ {
MForm mForm = new MForm(); this.Hide();
mForm.label1.Text = dr[0].ToString(); mForm.label2.Text = dr[3].ToString(); mForm.ShowDialog(); this.Close(); }
else if (dr[2].ToString().Trim(' ') == \销售员\ {
采购 sForm = new 采购();
sForm.label6.Text = dr[0].ToString(); sForm.label7.Text = dr[3].ToString(); this.Hide();
sForm.ShowDialog();
this.Close(); }
else if (dr[2].ToString().Trim(' ') == \采购员\ {
BForm bForm = new BForm(); this.Hide();
- 15 -
bForm.label6.Text = dr[0].ToString(); bForm.label7.Text = dr[3].ToString(); bForm.ShowDialog(); this.Close(); }
else {
MessageBox.Show(\密码错误,请重新输入\ } }
else
{
MessageBox.Show(\密码错误,请重新输入\ } }
finally
{
conn.Close(); }
改密选择关键代码：
SqlConnection conn = null; string comdstr = \
SqlCommand mycomand = null; SqlDataReader dr = null; try {
bool ft = false;
conn = new SqlConnection(Resource1.String1); comdstr = \姓名,密码,职称 from 员工\ mycomand = new SqlCommand(comdstr, conn); conn.Open();
dr = mycomand.ExecuteReader(); while (dr.Read()) {
if (dr[0].ToString().Trim(' ') == ntBx.Text) {
if (dr[1].ToString().Trim(' ') == ptBx.Text) {
ft = true; break;
- 16 -
} }
}
if (ft) {
gaimi GM = new gaimi(); GM.label4.Text = dr[2].ToString(); this.Hide(); GM.ShowDialog(); this.Close(); }
else {
MessageBox.Show(\你输入的用户名或密码错误,请重新输入\ } }
finally {
conn.Close(); }
- 17 -
4.2、管理模块
1.库存查询
2.员工信息查询 3.订单查询
4.客户信息查询 5.供货商信息查询
关键代码： //库存量查询
comdstr = \商品名称,库存量,单价 from 库存\ mycomand = new SqlCommand(comdstr, con); con.Open();
dr = mycomand.ExecuteReader(); listView2.Items.Clear(); while (dr.Read()) {
ListViewItem item = new ListViewItem(dr[0].ToString().Trim(' ')); item.SubItems.Add(dr[1].ToString()); item.SubItems.Add(dr[2].ToString()); listView2.Items.Add(item); }
//员工信息查询
comdstr = \编号,姓名,电话,手机,邮箱,地址,职称,基本工资,密码 from
- 18 -
员工\
mycomand = new SqlCommand(comdstr, con); con.Open();
dr = mycomand.ExecuteReader(); listView1.Items.Clear(); while (dr.Read())
{
ListViewItem item = new ListViewItem(dr[0].ToString().Trim(' ')); item.SubItems.Add(dr[1].ToString().Trim(' ')); item.SubItems.Add(dr[2].ToString().Trim(' ')); item.SubItems.Add(dr[3].ToString().Trim(' ')); item.SubItems.Add(dr[4].ToString().Trim(' ')); item.SubItems.Add(dr[5].ToString().Trim(' ')); item.SubItems.Add(dr[6].ToString().Trim(' ')); item.SubItems.Add(dr[7].ToString().Trim(' '));
item.SubItems.Add(dr[8].ToString().Trim(' ')); listView1.Items.Add(item);
} //订单查询
//1. comdstr = \客户姓名,商品名称,销售量,销售单价,账单编号,销售日期
from 销售\
mycomand = new SqlCommand(comdstr, con); con.Open();
dr = mycomand.ExecuteReader(); listView3.Items.Clear(); while (dr.Read()) {
ListViewItem item = new ListViewItem(dr[4].ToString().Trim(' ')); item.SubItems.Add(dr[1].ToString().Trim(' ')); item.SubItems.Add(dr[2].ToString()); item.SubItems.Add(dr[3].ToString());
item.SubItems.Add(dr[0].ToString().Trim(' '));
item.SubItems.Add(DateTime.Parse(dr[5].ToString()).Year.ToString()
+ \ + \ listView3.Items.Add(item); } //2.
comdstr = \账单编号,名称,进货数量,单价,供货商姓名,进货日期 from 采购\ mycomand = new SqlCommand(comdstr, con); con.Open();
dr = mycomand.ExecuteReader();
- 19 -
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库数据库课程设计报告 (销售管理)(4)在线全文阅读。
相关推荐：