//设置所有部门名称
void setDept()
{
String cmdText = "select dname from dept";
SqlParameter[] sprm = new SqlParameter[] { };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
while (dr.Read())
{
comboBox1.Items.Add(dr["dname"].ToString());
}
dr.Close();
}
private void signRecord_Load(object sender, EventArgs e)
{
getMouthDate();
daycount.Text = mCount.ToString();
zcqd.Text = getCount("True").ToString();
cd.Text = getCount("False").ToString();
wqd.Text = (mCount - getCount("True") - getCount("False")).ToString();
//获取该月
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
String strYM = currentTime.ToString("y");
for (int i = 1; i < mCount; i++)
{
String cmdText = "select * from sign where eid=@eid and sdate='" + strYM + i + "日'";
//MessageBox.Show(cmdText);
SqlParameter eidsprm = new SqlParameter("@eid", numStr);
// SqlParameter dsprm = new SqlParameter("@date", strYM+"%");
SqlParameter[] sprms = new SqlParameter[] { eidsprm };
SqlDataReader r = DBhelper.GetDR(cmdText, sprms);
if (!r.HasRows)
{
//没找到该数据，说明该天未签到
String sdate = strYM + i + "日";
String stime = "";
String sflag = "未签到";
String[] strs = { sdate, stime, sflag };
ListViewItem item = new ListViewItem(strs, 0);
listView1.Items.Add(item);
}
while (r.Read())
{
String sdate = r["sdate"].ToString();
String stime = r["stime"].ToString();
//MessageBox.Show(r["sflag"].ToString());
String f = r["sflag"].ToString();
String sflag;
if (f == "True")
{
sflag = "签到";
}
else
{
sflag = "迟到";
}
String[] strs = { sdate, stime, sflag };
ListViewItem item = new ListViewItem(strs, 0);
listView1.Items.Add(item);
}
}
}
String deptel; //记录部门电话
//获取每个部门的人数
public int getDeptCountPerson(int depid)
{
String cmdText = "select count(*) from employee where did=@id";
SqlParameter idsprm = new SqlParameter("@id", depid);
SqlParameter[] sprms = new SqlParameter[] { idsprm };
int count = DBhelper.GetCountPrm(cmdText, sprms);
if (count < 0)
{
count = 0;
}
return(count);
}
//设置签到了的所有日期到comboBox1中
void setDate()
{
//去重处理
String cmdText = "select distinct sdate from sign";
SqlParameter[] sprm = new SqlParameter[] { };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
while (dr.Read())
{
comboBox1.Items.Add(dr["sdate"].ToString());
}
dr.Close();
}
//设置所有员工姓名
void setPersonName()
{
String cmdText = "select ename from employee";
SqlParameter[] sprm = new SqlParameter[] { };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
while (dr.Read())
{
lastName = dr["ename"].ToString();
comboBox1.Items.Add(dr["ename"].ToString());
}
dr.Close();
}
private void alterbtn_Click(object sender, EventArgs e)
{
//密码不为空
if (this.pwd.Text == "")
{
this.pwdtext.ForeColor = Color.Red;
this.pwdtext.Text = "请设置密码！";
this.pwd.Focus();
}
else
{
this.pwdtext.ForeColor = Color.Green;
this.pwdtext.Text = "OK";
}
//须二次输入密码
if (this.againpwd.Text == "")
{
this.apwdtext.ForeColor = Color.Red;
this.apwdtext.Text = "请再次输入密码！";
this.againpwd.Focus();
}
else
{
//两次密码须一致
if (this.pwd.Text == this.againpwd.Text)
{
this.apwdtext.ForeColor = Color.Green;
this.apwdtext.Text = "OK";
String cmdText = "update employee set password=@pwd where eid=@eid";
SqlParameter pwdsprm = new SqlParameter("@pwd", pwd.Text.Trim());
SqlParameter eidsprm = new SqlParameter("@eid", strnum);
SqlParameter[] sprms = new SqlParameter[] { pwdsprm, eidsprm };
int count = DBhelper.Add(cmdText, sprms);
if (count > 0)
{
MessageBox.Show("修改成功！");
}
else
{
MessageBox.Show("修改失败！");
}
}
else
{
this.apwdtext.ForeColor = Color.Red;
this.apwdtext.Text = "两次密码不一致！！";
this.againpwd.Focus();
}
}
}
//获取每个时间公告的条数
public int getDateCountAD(String date)
{
String cmdText = "select count(*) from ad where date=@d";
SqlParameter dsprm = new SqlParameter("@d", date);
SqlParameter[] sprms = new SqlParameter[] { dsprm };
int count = DBhelper.GetCountPrm(cmdText, sprms);
if (count < 0)
{
count = 0;
}
return(count);
}
//获取该天正常签到或迟到的次数
public int getCount(String str, String f)
{
String cmdText = "select count(*) from sign where sdate=@date and sflag=@flag";
SqlParameter dsprm = new SqlParameter("@date", str);
SqlParameter fsprm = new SqlParameter("@flag", f);
SqlParameter[] sprms = new SqlParameter[] { dsprm, fsprm };
int count = DBhelper.GetCountPrm(cmdText, sprms);
if (count < 0)
{
count = 0;
}
return(count);
}
private void selectad_Load(object sender, EventArgs e)
{
setDate();
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
String strYMD = currentTime.ToLongDateString();
comboBox1.Text = strYMD;
count.Text = getDateCountAD(comboBox1.Text).ToString();
String cmdText = "select * from ad where date='" + comboBox1.Text + "' ";
dataGridView1.DataSource = DBhelper.GetTable(cmdText);
this.dataGridView1.Columns[0].FillWeight = 20;
this.dataGridView1.Columns[1].FillWeight = 170;
}
//根据部门名称获取部门id
public int getDeptId(String name)
{
String cmdText = "select id from dept where dname=@n";
SqlParameter namesprm = new SqlParameter("@n", name);
SqlParameter[] sprm = new SqlParameter[] { namesprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
if (!dr.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
dr.Read();
return((int)dr["id"]);
}
//获取该月正常签到或迟到的次数
public int getCount(String f)
{
String cmdText = "select count(*) from sign where eid=@id and sflag=@flag";
SqlParameter idsprm = new SqlParameter("@id", numStr);
SqlParameter fsprm = new SqlParameter("@flag", f);
SqlParameter[] sprms = new SqlParameter[] { idsprm, fsprm };
int count = DBhelper.GetCountPrm(cmdText, sprms);
if (count < 0)
{
count = 0;
}
return(count);
}
//根据部门id获取部门名称
public String getDeptName(int id)
{
String cmdText = "select dname from dept where id=@d";
SqlParameter idsprm = new SqlParameter("@d", id);
SqlParameter[] sprm = new SqlParameter[] { idsprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
if (!dr.HasRows)
{
MessageBox.Show("没有找到该数据");
}
dr.Read();
return(dr["dname"].ToString());
}
//根据员工ID获取员工姓名
public String getEmpName(String num)
{
String cmdText = "select ename from employee where eid=@n";
SqlParameter namesprm = new SqlParameter("@n", num);
SqlParameter[] sprm = new SqlParameter[] { namesprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
if (!dr.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
dr.Read();
return(dr["ename"].ToString());
}
//获取最后一项的员工id
public void getLastId()
{
String cmdText = "select id from employee";
SqlParameter[] sprm = new SqlParameter[] {};
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
if (!dr.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
while (dr.Read())
{
id = (int)dr["id"];
}
}
//根据ID找到用户名
public String setFindName(String str)
{
String name = "";
//去重处理
String cmdText = "select ename from employee where eid=@eid";
SqlParameter eidsprm = new SqlParameter("@eid", str);
SqlParameter[] sprm = new SqlParameter[] { eidsprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
while (dr.Read())
{
name = dr["ename"].ToString();
}
return(name);
}
private void updatebtn_Click(object sender, EventArgs e)
{
int id = getEmpId(comboBox1.Text);
String cmdText = "select id from employee where eid=@num";
SqlParameter numsprm = new SqlParameter("@num", num.Text.Trim());
SqlParameter[] sprms = new SqlParameter[] { numsprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprms);
dr.Read();
if (!dr.HasRows || (int)dr["id"] == id)
{
//进行更新数据库操作操作
String cmdText1 = "update employee set eid=@eid,ename=@name,eage=@age,etel=@tel,ecreatedate=@cd,did=@did where id=@id";
SqlParameter eidsprm = new SqlParameter("@eid", num.Text.Trim());
SqlParameter nasprm = new SqlParameter("@name", name.Text.Trim());
SqlParameter agesprm = new SqlParameter("@age", age.Text.Trim());
SqlParameter telsprm = new SqlParameter("@tel", tel.Text.Trim());
SqlParameter cdsprm = new SqlParameter("@cd", date.Value);
SqlParameter idsprm = new SqlParameter("@id", id);
//根据输入的部门名获取部门id
int did = getDeptId(dept.Text);
SqlParameter didsprm = new SqlParameter("@did", did);
SqlParameter[] sprms1 = new SqlParameter[] { eidsprm, nasprm, agesprm, telsprm, cdsprm, didsprm, idsprm };
int count = DBhelper.Add(cmdText1, sprms1);
if (count > 0)
{
MessageBox.Show("更新成功！");
//更新之前要clear一下，否则重复
comboBox1.Items.Clear();
//更新comboBox列表
setPersonName();
}
else
{
MessageBox.Show("更新失败！");
}
//更新修改后的员工名字
comboBox1.Text = name.Text;
}
else
{
MessageBox.Show("该员工工号已经存在" + "\n" + "请再次填写");
}
}
private void deletead_Load(object sender, EventArgs e)
{
setDate();
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
String strYMD = currentTime.ToLongDateString();
comboBox1.Text = strYMD;
sda = DBhelper.GetSDA("select * from ad where date='" + comboBox1.Text + "' ");
SqlCommandBuilder acb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds, "st");
dt = ds.Tables["st"];
dataGridView1.DataSource = dt;
this.dataGridView1.Columns[0].FillWeight = 20;
this.dataGridView1.Columns[1].FillWeight = 170;
}
private void nextpage_Click(object sender, EventArgs e)
{
if (int.Parse(allpage.Text) == 0)
{
MessageBox.Show("该部门目前没有人员");
}
else
{
if (index >= pagecount)
{
MessageBox.Show("当前已经是最后一页了");
index = pagecount;
}
else
{
index++;
dataGridView1.DataSource = DBhelper.GetPartTable(cmdT, index, pagesize);
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
depid = getDeptId(comboBox1.Text);
allcount.Text = getDeptCountPerson(depid).ToString();
cmdT = "select eid as 员工号,ename as 姓名,eage as 年龄,etel as 手机号,ecreatedate as 入职日期 from employee where did=" + depid + "";
DataTable dt = DBhelper.GetTable(cmdT);
int count = dt.Rows.Count;
if (count % pagesize == 0)
{
pagecount = count / pagesize;
}
else
{
pagecount = count / pagesize + 1;
}
allpage.Text = pagecount.ToString();
index = 1;
SetDGV();
}
private void prevpage_Click(object sender, EventArgs e)
{
if (int.Parse(allpage.Text) == 0)
{
MessageBox.Show("该部门目前没有人员");
}
else
{
if (index <= 1)
{
MessageBox.Show("当前已经是第一页了");
index = 1;
}
else
{
index--;
dataGridView1.DataSource = DBhelper.GetPartTable(cmdT, index, pagesize);
}
}
}
private void addbtn_Click(object sender, EventArgs e)
{
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
String strYMD = currentTime.ToLongDateString();
String cmdText = "insert into ad(cont,date) values(@con,@date)";
SqlParameter consprm = new SqlParameter("@con", richTextBox1.Text.Trim());
SqlParameter datesprm = new SqlParameter("@date", strYMD);
SqlParameter[] sprm = new SqlParameter[] { consprm, datesprm };
int count = DBhelper.Add(cmdText, sprm);
if (count > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
zc.Text = getCount(comboBox1.Text, "True").ToString();
cd.Text = getCount(comboBox1.Text, "False").ToString();
wqd.Text = (getPersonCount() - getCount(comboBox1.Text, "True") - getCount(comboBox1.Text, "False")).ToString();
cmdT = "select eid as 员工号,stime as 签到时间,sflag as 签到状态 from sign where sdate='" + comboBox1.Text + "'";
DataTable dt = DBhelper.GetTable(cmdT);
int count = dt.Rows.Count;
if (count % pagesize == 0)
{
pagecount = count / pagesize;
}
else
{
pagecount = count / pagesize + 1;
}
allpage.Text = pagecount.ToString();
index = 1;
SetDGV();
}
private void myInformation_Load(object sender, EventArgs e)
{
setDept();
//把信息，填入对应的textbox中
int deptid;
String cmdText = "select * from employee where eid=@enum";
SqlParameter numsprm = new SqlParameter("@enum", strText);
SqlParameter[] sprm = new SqlParameter[] { numsprm };
SqlDataReader r = DBhelper.GetDR(cmdText, sprm);
if (!r.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
else
{
r.Read();
id = (int)r["id"];
deptid = (int)r["did"];
num.Text = r["eid"].ToString();
name.Text = r["ename"].ToString();
age.Text = r["eage"].ToString();
tel.Text = r["etel"].ToString();
createdate.Text = r["ecreatedate"].ToString();
if (r["img"].ToString().Equals("") || r["img"] == null)
{
img.Image = null;
}
else
{
MemoryStream MStream = new MemoryStream((byte[])r["img"]);
imgname = (byte[])r["img"];
img.Image = Image.FromStream(MStream);
}
//根据did在dept表中找到部门名称
dept.Text = getDeptName(deptid);
}
r.Close();
}
private void btn_Click(object sender, EventArgs e)
{
int day = getDate();
if (day == 1)
{
}
else
{
//超过9点，视为迟到
if (strH < 9)
{
flag = 1;
}
else
{
flag = 0;
}
String name = getPersonName();
String cmdText = "insert into sign(eid,sflag,sdate,stime) values(@eid,@sflag,@sdate,@stime)";
SqlParameter eidsprm = new SqlParameter("@eid", numStr);
SqlParameter sflagsprm = new SqlParameter("@sflag", flag);
SqlParameter sdatesprm = new SqlParameter("@sdate", strYMD);
SqlParameter stimesprm = new SqlParameter("@stime", strT);
SqlParameter[] sprms = new SqlParameter[] { eidsprm, sflagsprm, sdatesprm, stimesprm };
int count = DBhelper.Add(cmdText, sprms);
if (count > 0)
{
MessageBox.Show(name + "签到成功！！");
btn.Text = "已签到";
btn.Enabled = false;
}
else
{
MessageBox.Show("签到失败！");
}
}
}
//判断今天有没有签到过
public int getDate()
{
int dayflag = 0;
String cmdText = "select * from sign where eid=@n and sdate=@d";
SqlParameter nsprm = new SqlParameter("@n", numStr);
SqlParameter dsprm = new SqlParameter("@d", strYMD);
SqlParameter[] sprm = new SqlParameter[] { nsprm, dsprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprm);
if (!dr.HasRows)
{
dayflag = 0;
}
else
{
dr.Read();
dayflag = 1;
}
return(dayflag);
}
private void deptinfo_Load(object sender, EventArgs e)
{
alldept.Text = getDeptCount().ToString();
String cmdText = "select * from dept";
SqlParameter[] sprms = new SqlParameter[] { };
SqlDataReader r = DBhelper.GetDR(cmdText, sprms);
if (!r.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
while (r.Read())
{
depid = (int)r["id"];
depcount = getDeptCountPerson(depid);
depname = r["dname"].ToString();
deptel = r["dtel"].ToString();
String[] strs = { depname, deptel, depcount.ToString() };
ListViewItem item = new ListViewItem(strs, 0);
listView1.Items.Add(item);
}
}
private void empalter_Load(object sender, EventArgs e)
{
setFirstName();
setPersonName();
setDeptName();
comboBox1.Text = lastName;
String cmdText = "select * from employee where ename=@ename";
SqlParameter enamesprm = new SqlParameter("@ename", lastName);
SqlParameter[] sprm = new SqlParameter[] { enamesprm };
SqlDataReader r = DBhelper.GetDR(cmdText, sprm);
if (!r.HasRows)
{
MessageBox.Show("没有找到该数据！");
}
else
{
r.Read();
num.Text = r["eid"].ToString();
name.Text = r["ename"].ToString();
age.Text = r["eage"].ToString();
tel.Text = r["etel"].ToString();
date.Text = r["ecreatedate"].ToString();
//根据did在dept表中找到部门名称
if (r["did"] == null || r["did"].ToString().Equals(""))
{
dept.Text = "";
}
else
{
String deptname = getDeptName((int)r["did"]);
dept.Text = deptname;
}
}
}
private void alterbtn_Click(object sender, EventArgs e)
{
//点击按钮编辑信息
if (this.alterbtn.Text == "编辑资料")
{
num.ReadOnly = false;
name.ReadOnly = false;
age.Enabled = true;
tel.ReadOnly = false;
createdate.Enabled = true;
dept.Enabled = true;
lookbtn.Enabled = true;
this.alterbtn.Text = "保存资料";
}
//点击按钮保存信息
else if (this.alterbtn.Text == "保存资料")
{
num.ReadOnly = true;
name.ReadOnly = true;
age.Enabled = false;
tel.ReadOnly = false;
createdate.Enabled = false;
dept.Enabled = false;
lookbtn.Enabled = false;
MessageBox.Show("save");
this.alterbtn.Text = "编辑资料";
//查询修改后的部门id
int deid = getDeptId(dept.Text.Trim());
//要保证员工号的唯一性，
//两种情况，第一种员工号未修改的情况，保证查找id是对应原来的id
//第二种员工号修改了，保证查找的id是不存在
String cmdText = "select id from employee where eid=@num";
SqlParameter numsprm = new SqlParameter("@num", num.Text.Trim());
SqlParameter[] sprms = new SqlParameter[] { numsprm };
SqlDataReader dr = DBhelper.GetDR(cmdText, sprms);
dr.Read();
if (!dr.HasRows || (int)dr["id"] == id)
{
this.numtext.ForeColor = Color.Green;
this.numtext.Text = "OK";
//进行更新操作
MessageBox.Show("更新中。。。。");
byte[] byteImage;
if (strImage == null)
{
byteImage = imgname;
}
else
{
FileStream FStream = new FileStream(strImage, FileMode.Open, FileAccess.Read);
BinaryReader BReader = new BinaryReader(FStream);
byteImage = BReader.ReadBytes((int)FStream.Length);
}
String cmdText1 = "update employee set eid=@eid,ename=@name,eage=@age,etel=@tel,ecreatedate=@cd,did=@did,img=@img where id=@id";
SqlParameter imgsprm = new SqlParameter("@img", byteImage);
SqlParameter eidsprm = new SqlParameter("@eid", num.Text.Trim());
SqlParameter nasprm = new SqlParameter("@name", name.Text.Trim());
SqlParameter agesprm = new SqlParameter("@age", age.Text.Trim());
SqlParameter telsprm = new SqlParameter("@tel", tel.Text.Trim());
SqlParameter cdsprm = new SqlParameter("@cd", createdate.Value);
SqlParameter idsprm = new SqlParameter("@id", id);
SqlParameter didsprm = new SqlParameter("@did", deid);
SqlParameter[] sprms1 = new SqlParameter[] { eidsprm, nasprm, agesprm, telsprm, cdsprm, didsprm, imgsprm, idsprm };
int count = DBhelper.Add(cmdText1, sprms1);
if (count > 0)
{
MessageBox.Show("更新成功！");
}
else
{
MessageBox.Show("更新失败！");
}
}
else
{
this.numtext.ForeColor = Color.Red;
this.numtext.Text = "已存在";
MessageBox.Show("该工号属于他人，请检查是否填错");
}
dr.Close();
}
else
{
}
}
private void registerbtn_Click(object sender, EventArgs e)
{
//帐号不为空
if (this.num.Text == "")
{
this.numtext.ForeColor = Color.Red;
this.numtext.Text = "请输入你的员工号！";
this.num.Focus();
}
else
{
//账号不能在数据库中已存在
String cmdText = "select count(*) from employee where eid=@num";
SqlParameter numsprm = new SqlParameter("@num", num.Text.Trim());
SqlParameter[] sprm = new SqlParameter[] { numsprm };
int count = DBhelper.GetCountPrm(cmdText, sprm);
if (count >= 1)
{
this.numtext.ForeColor = Color.Red;
this.numtext.Text = "帐号已经注册过了了！！";
}
else
{
this.numtext.ForeColor = Color.Green;
this.numtext.Text = "OK";
flag1 = 1;
}
}
//密码不为空
if (this.pwd.Text == "")
{
this.pwdtext.ForeColor = Color.Red;
this.pwdtext.Text = "请设置密码！";
this.pwd.Focus();
}
else
{
this.pwdtext.ForeColor = Color.Green;
this.pwdtext.Text = "OK";
}
//须二次输入密码
if (this.againpwd.Text == "")
{
this.apwdtext.ForeColor = Color.Red;
this.apwdtext.Text = "请再次输入密码！";
this.againpwd.Focus();
}
else
{
//两次密码须一致
if (this.pwd.Text == this.againpwd.Text)
{
this.apwdtext.ForeColor = Color.Green;
this.apwdtext.Text = "OK";
flag2 = 1;
}
else
{
this.apwdtext.ForeColor = Color.Red;
this.apwdtext.Text = "两次密码不一致！！";
this.againpwd.Focus();
}
}
//须填写真实姓名
if (this.name.Text == "")
{
this.nametext.ForeColor = Color.Red;
this.nametext.Text = "请输入你的真实姓名！";
this.name.Focus();
}
else
{
this.nametext.ForeColor = Color.Green;
this.nametext.Text = "OK";
}
//字符串转为小写,进行比较判断
if (yzc.Check.ToLower() == this.check.Text.ToLower())
{
//验证码正确,输入框变绿
this.checktext.ForeColor = Color.Green;
this.checktext.Text = "验证码输入正确!";
flag = 1;
}
else
{
//验证码错误,有红色字体提示
this.checktext.ForeColor = Color.Red;
this.checktext.Text = "验证码输入错误!";
this.check.Focus();
flag = 0;
}
if (flag == 1 && flag1 == 1 && flag2 == 1 && this.name.Text != "")
{
//验证通过，数据插入数据库中
String cmdText = "insert into employee(eid,password,ename) values(@num,@pwd,@name)";
SqlParameter numsprm = new SqlParameter("@num", num.Text);
SqlParameter pwdsprm = new SqlParameter("@pwd", pwd.Text);
SqlParameter namesprm = new SqlParameter("@name", name.Text);
SqlParameter[] sprms = new SqlParameter[] { numsprm, pwdsprm, namesprm };
int count = DBhelper.Add(cmdText, sprms);
if (count > 0)
{
MessageBox.Show(num.Text.Trim() + "注册成功！！");
Main m = new Main();
m.Show();
}
else
{
MessageBox.Show("注册失败！");
}
}
}
//点击登录，进行验证码验证，和数据库数据验证
private void loginbtn_Click(object sender, EventArgs e)
{
int flag = 0;
//字符串转为小写,进行比较判断
if (yzc.Check.ToLower() == this.check.Text.ToLower())
{
//验证码正确,输入框变绿
this.checktext.ForeColor = Color.Green;
this.checktext.Text = "验证码输入正确!";
flag = 1;
}
else
{
//验证码错误,有红色字体提示
this.checktext.ForeColor = Color.Red;
this.checktext.Text = "验证码输入错误!";
this.check.Focus();
flag = 0;
}
//没有输入内容
if (this.number.Text == "" || this.paw.Text == "")
{
this.nptext.ForeColor = Color.Red;
this.nptext.Text = "帐号或密码不能为空！！";
}
else
{
this.nptext.Text = "";
//管理员登录
if (comboBox1.Text == "管理员")
{
this.nptext.ForeColor = Color.Green;
this.nptext.Text = "管理员帐号正在登录中....";
if (this.number.Text == "admin")
{
if (this.paw.Text == "admin")
{
if (flag == 1)
{
MessageBox.Show("管理者，欢迎你的登录！！");
adminMain am = new adminMain();
am.Show();
}
else
{
this.pwdtext.ForeColor = Color.Green;
this.pwdtext.Text = "密码正确！！";
}
}
else
{
this.pwdtext.ForeColor = Color.Red;
this.pwdtext.Text = "密码不正确！！";
}
}
else
{
this.nptext.ForeColor = Color.Red;
this.nptext.Text = "管理员帐号不正确，应为admin";
}
}
//用户登录
else
{
this.nptext.ForeColor = Color.Green;
this.nptext.Text = "用户帐号正在登录中....";
String cmdText = "select count(*) from employee where eid=@num";
SqlParameter numsprm = new SqlParameter("@num", number.Text.Trim());
SqlParameter[] sprm = new SqlParameter[] { numsprm };
int count = DBhelper.GetCountPrm(cmdText, sprm);
if (count < 1)
{
this.nptext.ForeColor = Color.Red;
this.nptext.Text = "帐号不存在！！";
}
else
{
String cmdText1 = "select count(*) from employee where eid=@number and password=@pwd";
SqlParameter numsprm1 = new SqlParameter("@number", number.Text.Trim());
SqlParameter pwdsprm = new SqlParameter("@pwd", paw.Text.Trim());
SqlParameter[] sprm1 = new SqlParameter[] { numsprm1, pwdsprm };
int count1 = DBhelper.GetCountPrm(cmdText1, sprm1);
if (count1 < 1)
{
this.pwdtext.ForeColor = Color.Red;
this.pwdtext.Text = "密码不正确！！";
}
else
{
this.pwdtext.ForeColor = Color.Green;
this.pwdtext.Text = "密码正确！！";
if (flag == 1)
{
MessageBox.Show(number.Text.Trim() + "欢迎你的登录！！");
Constant.number = number.Text.Trim();
Main m = new Main();
m.Show();
}
}
}
}
}
}
