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(); } } }