private void btOk_Click_1(object sender, EventArgs e)
{
string findSql = "select * from DT_students where stunum = '" + tBun.Text + "'";
SqlHelp sqlHelper = new SqlHelp();
if (tBpw.Text.Trim() != tBrpw.Text.Trim())
{
wrong1();
}
if (cbCg.Text == "" || tBjl.Text == "" || cbMj.Text == "" || tBpw.Text == "" || tBrpw.Text == "" || tBun.Text == "" || tbDobd.Text == "" || tbDobm.Text == "" || tbDobn.Text == "" || tbName.Text == "" || tbNp.Text == "")
{
wrong3();
}
else if (sqlHelper.SqlServerRecordCount(findSql) > 0)
{
wrong2();
}
else
{
Close();
Usernum = tBun.Text;
Username = tbName.Text;
Password = tBpw.Text;
State = tBjl.Text;
College = cbCg.Text;
Major = cbMj.Text;
Place = tbNp.Text;
dateofbirth = tbDobn.Text + "/" + tbDobm.Text + "/" + tbDobd.Text;
userManage a = new userManage();
a.ShowDialog();
}
}
private void btOui_Click(object sender, EventArgs e)
{
string findSql = "select * from DT_employer where careernum ='" + tbCrn.Text + "'";
string instSql1 = "Insert into DT_employer" + "(careerNUM,classNUM,needNUM,lastNUM,employer)" + "values('" + tbCrn.Text + "','" + tbCln.Text + "','" + tbNn.Text + "','" + tbLn.Text + "','" + tbEr.Text + "')";
SqlHelp sqlHelper = new SqlHelp();
int count2 = sqlHelper.SqlServerRecordCount(findSql);
if (tbCln.Text == "" || tbCrn.Text == "" || tbEr.Text == "" || tbLn.Text == "" || tbNn.Text == "")
{
wrong3();
}
else
if (count2 > 0)
{
wrong1();
}
else if (int.Parse(tbNn.Text) < int.Parse(tbLn.Text))
{
wrong2();
}
else
if (sqlHelper.ExecuteNonQueryCount(instSql1) > 0)
{
right();
Close();
}
else
{
MessageBox.Show("存在违规信息，请核实！", "信息提示");
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
string username = this.textBox1.Text.Trim();
string password = this.textBox2.Text.Trim();
if (username.Equals("") || password.Equals(""))
{
wrong2();
}
else
{
string selesql = "select * from DT_USER where username='******' and userpass='******'";
string seleLm = "select limits from DT_USER where username='******'";
SqlHelp sqlHelper = new SqlHelp();
int count = sqlHelper.SqlServerRecordCount(selesql);
if (count > 0)
{
Username = textBox1.Text;
right();
Hide();
string limits = sqlHelper.GetDataReaderValue(seleLm);
if (limits == "毕业生")
{
graduateLog();
graduated a = new TryDBMS.graduated();
a.ShowDialog();
}
else if (limits == "管理员")
{
admainLog();
admainpage a = new TryDBMS.admainpage();
a.ShowDialog();
}
else
{
workclassLog();
WorkPage a = new TryDBMS.WorkPage();
a.ShowDialog();
}
}
else
{
wrong1();
}
}
}