/// <summary> /// 保存用户分数 /// </summary> private void setUserTest(int score) { string sql = "select ID,Score from tbl_User_Test where testId=" + testId.ToString() + " and userId=" + userId.ToString(); DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { int Id = (int)ds.Tables[0].Rows[0]["ID"]; int total = score + (int)ds.Tables[0].Rows[0]["Score"]; sql = "update tbl_User_Test set Score = " + total + " where Id=" + Id.ToString(); if (!db.ExeSQL(sql)) { MessageBox.Show("分数更新失败!"); } else { lblScore.Text = total.ToString() + "分"; } } else { sql = "insert into tbl_User_Test(userId,testId,Score) values( " + "" + userId + "" + "," + testId + "" + "," + score + ")"; if (!db.ExeSQL(sql)) { MessageBox.Show("分数更新失败!"); } else { lblScore.Text = score.ToString(); } } }
/// <summary> /// 用户注册 /// </summary> private void regist() { string userName = txtUserName.Text; string password = txtPassword.Text; string birthday = "2016/01/01";//dtpBirthday.Value.ToShortDateString(); bool sex = true; //if (rdoWoman.Checked) sex = false; string mail = txtMail.Text; string tel = txtTel.Text; string address = txtAddress.Text; if (userId > 0) { string sql = "update [tbl_User] set " + "[UserName] ='" + userName + "'" + ",[Password]='" + password + "'" + ",[Birthday]=" + birthday + "" + ",[Sex]=" + sex + "" + ",[Mail]='" + mail + "'" + ",[Tel]='" + tel + "'" + ",[Address]='" + address + "'" + " where id=" + userId; bool ret = db.ExeSQL(sql); if (ret) { MessageBox.Show("更新成功!"); Close(); } else { MessageBox.Show("更新失败!"); } } else { string sql = "insert into [tbl_User]([UserName],[Password],[Birthday],[Sex],[Mail],[Tel],[Address],[IsAdmin]) values(" + "'" + userName + "'" + ",'" + password + "'" + "," + birthday + "" + "," + sex + "" + ",'" + mail + "'" + ",'" + tel + "'" + ",'" + address + "'" + ",False)"; bool ret = db.ExeSQL(sql); if (ret) { MessageBox.Show("注册成功!"); Close(); } else { MessageBox.Show("注册失败!"); } } }
/// <summary> /// 确定用户排名 /// </summary> public void btn_OnClick(object sender, EventArgs e) { string sql = "select ID,userId,Score from tbl_User_Test where testId=" + testId.ToString() + " order by Score desc"; DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { int prevScore = -1; int rank = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int Id = (int)ds.Tables[0].Rows[i]["ID"]; int userId = (int)ds.Tables[0].Rows[i]["userId"]; int Score = (int)ds.Tables[0].Rows[i]["Score"]; if (Score != prevScore) { rank++; prevScore = Score; } sql = "update tbl_User_Test set rank = " + rank + " where Id=" + Id.ToString(); if (!db.ExeSQL(sql)) { MessageBox.Show("排名更新失败!"); } for (int j = 0; j < userTests.Length; j++) { if (userTests[j].getUserId() == userId) { userTests[j].setRank(rank); break; } } } } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { string id = dgvUser.SelectedRows[0].Cells[0].Value.ToString(); string sql = "delete from tbl_test where id=" + id; if (db.ExeSQL(sql)) { sql = "delete from tbl_Test_Detail where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除会议答题选题失败!"); return; } sql = "delete from tbl_Test_User where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除会议参赛者失败!"); return; } sql = "delete from tbl_User_Test where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除参赛排名失败!"); return; } sql = "delete from tbl_User_Test_Detail where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除参赛答题详细失败!"); return; } MessageBox.Show("清除成功!"); getAllTest(); } else { MessageBox.Show("删除失败!"); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { string id = dgvUser.SelectedRows[0].Cells[0].Value.ToString(); string sql = "delete from tbl_User where id=" + id; if (db.ExeSQL(sql)) { getAllTest(); } else { MessageBox.Show("删除失败!"); } }
/// <summary> /// 更新当前记录 /// </summary> private void update() { int id = Convert.ToInt32(lblNo.Text); string content = txtContent.Text; string answerA = txtA.Text; string answerB = txtB.Text; string answerC = txtC.Text; string answerD = txtD.Text; int score = (int)nudScore.Value; string answer = "A"; if (rdoB.Checked) { answer = "B"; } else if (rdoC.Checked) { answer = "C"; } else if (rdoD.Checked) { answer = "D"; } string sql = "update tbl_Question_Single set " + "Content='" + content + "'" + ",SelectionA='" + answerA + "'" + ",SelectionB='" + answerB + "'" + ",SelectionC='" + answerC + "'" + ",SelectionD='" + answerD + "'" + ",Score=" + score + "" + ",Answer='" + answer + "'" + " where ID=" + id.ToString(); bool ret = db.ExeSQL(sql); if (ret) { MessageBox.Show("更新成功!"); } else { MessageBox.Show("更新失败!"); } }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnConfirm_Click(object sender, EventArgs e) { if (check()) { if (id > -1)//更新 { string sql = "delete from tbl_test where id=" + id; if (db.ExeSQL(sql)) { sql = "delete from tbl_Test_Detail where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除会议答题选题失败!"); return; } sql = "delete from tbl_Test_User where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除会议参赛者失败!"); return; } sql = "delete from tbl_User_Test where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除参赛排名失败!"); return; } sql = "delete from tbl_User_Test_Detail where testid=" + id; if (!db.ExeSQL(sql)) { MessageBox.Show("清除参赛答题详细失败!"); return; } } } if (CreateTest()) { int testId = getTestId(); if (testId > 0) { if (CreateTestUser(testId)) { MessageBox.Show("会议创建成功!"); } else { MessageBox.Show("会议参赛人员添加失败!"); } if (CreateTestDetail(testId)) { MessageBox.Show("选题成功!"); Close(); } else { MessageBox.Show("选题失败!"); } } else { MessageBox.Show("会议创建失败!"); } } else { MessageBox.Show("会议创建失败!"); } } }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void newpasswordConfirm_Click(object sender, EventArgs e) { string sql = "select * from tbl_User where Mail='" + txtUserId.Text + "' and password='******'"; DataSet ds = db.ReturnDataSet(sql); //判断四个文本框内是否有空项没填写 if (txtPassword.Text.Trim().Length == 0) { MessageBox.Show("请输入旧密码!"); txtPassword.Focus(); return; } else if (newTxtPassword.Text.Trim().Length == 0) { MessageBox.Show("请输入新密码!"); newTxtPassword.Focus(); return; } else if (newPWordConfirmagain.Text.Trim().Length == 0) { MessageBox.Show("请输入确认密码!"); newPWordConfirmagain.Focus(); return; } //判断两次输入的新密码是否一致 if (newTxtPassword.Text.Trim() != newPWordConfirmagain.Text.Trim()) { MessageBox.Show("新密码和确认密码不一致!"); return; } //判断新旧密码是否相同 if (txtPassword.Text.Trim() == newPWordConfirmagain.Text.Trim()) { MessageBox.Show("旧密码与新密码相同!"); return; } //写入新密码 if (ds.Tables[0].Rows.Count == 1) { sql = "update tbl_User set [password] = '" + newTxtPassword.Text + "' where Mail='" + txtUserId.Text + "';"; if (db.ExeSQL(sql)) { MessageBox.Show("密码更新成功!"); DialogResult = DialogResult.OK; } else { MessageBox.Show("密码更新失败!"); } } else { sql = "select * from tbl_User where Mail='" + txtUserId.Text + "'"; ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count == 1) { MessageBox.Show("旧密码不正确!"); } else { MessageBox.Show("用户不存在!"); } } }