private void tsmDlt_Click(object sender, EventArgs e)
{
if (!this.dataGridView1.Rows[index].IsNewRow)
{
string selestr1 = "select username from DT_USER where usernum ='" + this.dataGridView1.CurrentCell.Value + "'";
string deletestr1 = "delete from DT_USER where usernum ='" + this.dataGridView1.CurrentCell.Value + "'";
string deletestr2 = "delete from DT_students where stunum ='" + this.dataGridView1.CurrentCell.Value + "'";
SqlHelp sqlHelper = new SqlHelp();
string name = sqlHelper.GetDataReaderValue(selestr1);
if (sqlHelper.ExecuteNonQueryCount(deletestr1) > 0 && sqlHelper.ExecuteNonQueryCount(deletestr2) > 0)
{
this.dataGridView1.Rows.RemoveAt(index);
right(name);
}
}
}
public admainManage()
{
InitializeComponent();
skinEngine1.SkinFile = "mdc_summer.ssk";
skinEngine1.SkinDialogs = false;
lbuserName.Text = Login.Username;
string seleSt = "select state from DT_students where name = '" + lbuserName.Text + "'";
string seleSex = "select sex from DT_students where name = '" + lbuserName.Text + "'";
string seleDob = "select birthday from DT_students where name = '" + lbuserName.Text + "'";
string seleNp = "select [native place] from DT_students where name = '" + lbuserName.Text + "'";
SqlHelp sqlHelper = new SqlHelp();
lbState.Text = sqlHelper.GetDataReaderValue(seleSt);
lbSex.Text = sqlHelper.GetDataReaderValue(seleSex);
lbDob.Text = sqlHelper.GetDataReaderValue(seleDob);
lbNp.Text = sqlHelper.GetDataReaderValue(seleNp);
}
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();
}
}
}
private void btOk_Click(object sender, EventArgs e)
{
string userSex = "";
string dateofbirth = tbDobn.Text + "/" + tbDobm.Text + "/" + tbDobd.Text;
string findCl = "select yxnum from dt_yx where yxname ='" + cbCg.Text + "'";
string findMj = "select zynum from dt_zy where zyname ='" + cbMj.Text + "'";
SqlHelp sqlHelper = new SqlHelp();
if (rbFemale.Checked)
{
userSex = "女";
}
else
{
userSex = "男";
}
string updt = "update DT_students set sex = '" + userSex + "', yxnum ='" + sqlHelper.GetDataReaderValue(findCl) + "', zynum ='" + sqlHelper.GetDataReaderValue(findMj) + "', birthday ='" + dateofbirth + "', [native place] ='" + tbNp.Text + "' where name ='" + lbUnm.Text + "'";
if (cbCg.Text == "" || tbDobd.Text == "" || tbDobm.Text == "" || tbDobn.Text == "" || cbMj.Text == "" || tbNp.Text == "")
{
wrong1();
}
else
{
if (sqlHelper.ExecuteNonQueryCount(updt) > 0)
{
right();
}
else
{
wrong2();
}
}
Hide();
graduated a = new graduated();
a.ShowDialog();
}
public graduated()
{
InitializeComponent();
skinEngine1.SkinFile = "mdc_summer.ssk";
skinEngine1.SkinDialogs = false;
lbuserName.Text = Login.Username;
string seleSt = "select state from DT_students where name = '" + lbuserName.Text + "'";
string seleSex = "select sex from DT_students where name = '" + lbuserName.Text + "'";
string seleNum = "select stunum from DT_students where name = '" + lbuserName.Text + "'";
string seleDob = "select birthday from DT_students where name = '" + lbuserName.Text + "'";
string seleNp = "select [native place] from DT_students where name = '" + lbuserName.Text + "'";
string seleCg = "select yxname from DT_YX where yxnum in (select yxnum from DT_students where name ='" + lbuserName.Text + "')";
string seleMj = "select zyname from DT_ZY where zynum in (select zynum from DT_students where name ='" + lbuserName.Text + "')";
SqlHelp sqlHelper = new SqlHelp();
lbState.Text = sqlHelper.GetDataReaderValue(seleSt);
lbSex.Text = sqlHelper.GetDataReaderValue(seleSex);
lbNum.Text = sqlHelper.GetDataReaderValue(seleNum);
lbDob.Text = sqlHelper.GetDataReaderValue(seleDob);
lbNp.Text = sqlHelper.GetDataReaderValue(seleNp);
lbCollege.Text = sqlHelper.GetDataReaderValue(seleCg);
lbMajor.Text = sqlHelper.GetDataReaderValue(seleMj);
}