private void btnDelete_Click(object sender, EventArgs e) { FrmProjectNew projectNew = new FrmProjectNew(); DataTable dt; dt = ClsSQLMethod.SearchProject(); DataGridViewRow item = dgvProjectList.CurrentRow; if (item == null || item.Tag == null) { return; } projectNew.Project.intProjectID = (int)item.Tag; try { if (MessageBox.Show("确认删除项目:" + projectNew.Project.intProjectID + "?", "删除项目", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { foreach (DataRow row in dt.Rows) { if ((int)item.Tag == int.Parse(row[0].ToString())) { break; } } //this.DialogResult = DialogResult.OK; ClsSQLMethod.DeleteProject(projectNew.Project); LoadProjectInfo(); } } catch (Exception ex) { MessageBox.Show("删除失败!", "删除项目"); } }
private void btn_TaskDelete_Click(object sender, EventArgs e) { FrmTaskNew frmTaskNew = new FrmTaskNew(); DataTable dt; dt = ClsSQLMethod.SearchTask(); DataGridViewRow item = dgvTaskList.CurrentRow; if (item == null) { return; } frmTaskNew.ClsTask.strTaskName = item.Cells[0].Value.ToString(); frmTaskNew.ClsTask.TaskID = (int)item.Tag; try { if (MessageBox.Show("确认删除任务:" + frmTaskNew.ClsTask.strTaskName + "?", "删除任务", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { foreach (DataRow row in dt.Rows) { if (((int)item.Tag == int.Parse(row[0].ToString()))) { break; } } ClsSQLMethod.DeleteTask(frmTaskNew.ClsTask); //this.DialogResult = DialogResult.OK; LoadTaskInfo(); } } catch (Exception ex) { MessageBox.Show("删除失败!", "删除任务"); } }
private void button1_Click_1(object sender, EventArgs e) { if (_user.UserName != null) { try { #region 修改用户 string info = Info(); if (info != "") { MessageBox.Show(info); return; } else { User.Contact = txt_contact.Text.Trim(); User.TrueName = txt_Name.Text.Trim(); User.UserName = txt_userName.Text.Trim(); User.Description = txt_description.Text.Trim(); User.PassWord = txt_password.Text.Trim(); User.Authority = (EnumUserAutho)(Enum.Parse(typeof(EnumUserAutho), comb_authority.Text.Trim())); User.UserID = ClsSQLMethod.ModifyUser(User); this.Close(); } } catch (Exception ex) { MessageBox.Show("用户修改失败\r\n" + ex.Message); } #endregion } else { #region 新建用户 try { string info = Info(); if (info != "") { MessageBox.Show(info); } else { Save(); this.Close(); } } catch (Exception ex) { MessageBox.Show("保存失败!" + "/r/n" + ex.Message); } #endregion } }
private void LoadUserInfo() { DataTable dt; dt = ClsSQLMethod.SearchUser(); if (curUser.Authority == EnumUserAutho.管理员) { dataGridView.Rows.Clear(); DataGridViewRow dgvRow; foreach (DataRow row in dt.Rows) { dgvRow = new DataGridViewRow(); dgvRow.CreateCells(dataGridView); dgvRow.Cells[0].Value = row[1].ToString(); dgvRow.Cells[1].Value = row[2].ToString(); dgvRow.Cells[2].Value = (EnumUserAutho)(Enum.Parse(typeof(EnumUserAutho), row[3].ToString())); dgvRow.Cells[3].Value = row[4].ToString(); dgvRow.Cells[4].Value = row[5].ToString(); dgvRow.Cells[5].Value = row[6].ToString(); dgvRow.Tag = row[0]; dataGridView.Rows.Add(dgvRow); } } if (curUser.Authority == EnumUserAutho.普通用户) { btn_newUser.Enabled = false; btn_modifyUser.Enabled = false; btn_deleteUser.Enabled = false; users.Clear(); CUser user; foreach (DataRow row in dt.Rows) { user = new CUser(); user.UserID = curUser.UserID; if (user.UserID == int.Parse(row[0].ToString())) { user.UserName = row[1].ToString(); user.PassWord = row[2].ToString(); user.Authority = (EnumUserAutho)(Enum.Parse(typeof(EnumUserAutho), row[3].ToString())); user.Description = row[4].ToString(); user.Contact = row[5].ToString(); user.TrueName = row[6].ToString(); users.Add(user); } } } }
public string Login(string sqlIP, int sqlPort, string userName, string passWord) { string info = string.Empty; try { info = login.Login(sqlIP, sqlPort, userName, passWord); curUser = login.curUser; sqlMethod = login.sqlMethod; frmMain.curUser = curUser; //taskCfg.curUser = curUser; } catch (Exception ex) { throw new Exception(ex.Message); } return(info); }
private void Save() { try { CUser user = new CUser(); user.UserName = txt_userName.Text.Trim(); user.Description = txt_description.Text.Trim(); user.Contact = txt_contact.Text.Trim(); user.TrueName = txt_Name.Text.Trim(); user.PassWord = txt_password.Text.Trim(); user.Authority = (EnumUserAutho)(Enum.Parse(typeof(EnumUserAutho), comb_authority.Text.Trim())); user.UserID = ClsSQLMethod.AddUser(user); } catch (Exception ex) { MessageBox.Show("用户注册失败\r\n" + ex.Message); } }
public string Info() { StringBuilder strBuilder = new StringBuilder(); DataTable dt = new DataTable(); dt = ClsSQLMethod.SearchProject(); if (textProjectName.Text == "") { strBuilder.Append("请输入项目名称!"); } foreach (DataRow row in dt.Rows) { if (textProjectName.Text == row[1].ToString()) { strBuilder.Append("此项目已存在!"); } } return(strBuilder.ToString()); }
public string Info() { StringBuilder strBuilder = new StringBuilder(); DataTable dt = new DataTable(); dt = ClsSQLMethod.SearchTask(); if (curTask.strTaskName == "") { strBuilder.Append("请输入任务名称!"); } foreach (DataRow row in dt.Rows) { if (curTask.strTaskName == row[2].ToString()) { strBuilder.Append("此任务已存在!"); } } return(strBuilder.ToString()); }
public string Info() { DataTable dt; dt = ClsSQLMethod.SearchUser(); StringBuilder strBuilder = new StringBuilder(); if (_user == null) { CUser user; foreach (DataRow row in dt.Rows) { user = curUser; if (txt_Name.Text == row[1].ToString()) { strBuilder.Append("该用户已存在!"); } } } if (comb_authority.Text != "管理员" && comb_authority.Text != "普通用户") { strBuilder.Append("未设置用户权限!"); } if (txt_Name.Text == "") { strBuilder.AppendLine("用户名不能为空!"); } if (txt_password.Text == "") { strBuilder.AppendLine("密码不能为空!"); } if (6 > txt_password.Text.Length || txt_password.Text.Length >= 18) { strBuilder.Append("密码长度应介于6-18位!"); } if (txt_password.Text != txt_passwordAgain.Text) { strBuilder.Append("两次输入密码不一致!"); } return(strBuilder.ToString()); }
private void btn_deleteUser_Click(object sender, EventArgs e) { DataTable dt; FrmUserNew frmUserNew = new FrmUserNew(); dt = ClsSQLMethod.SearchUser(); DataGridViewRow item = dataGridView.CurrentRow; if (item == null || item.Tag == null) { return; } if (curUser.Authority != EnumUserAutho.管理员) { MessageBox.Show("你没有此权限!"); return; } frmUserNew.User.UserID = (int)item.Tag; try { if (MessageBox.Show("确认删除用户:" + frmUserNew.User.UserID + "?", "删除用户", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { foreach (DataRow row in dt.Rows) { if (frmUserNew.User.UserID == int.Parse(row[0].ToString())) { break; } } ClsSQLMethod.DeleteUser(frmUserNew.User); LoadUserInfo(); } } catch (Exception ex) { MessageBox.Show("删除失败!"); } }
private void FrmTaskMng_Load(object sender, EventArgs e) { FrmTaskNew frmTaskNew = new FrmTaskNew(); txt_projectID.Text = ClsTask.ProjectID.ToString(); projectName = ClsTask.ProjectName; frmTaskNew.ClsTask.ProjectID = Convert.ToInt32(txt_projectID.Text); dgvTaskList.Rows.Clear(); DataTable dt; dt = ClsSQLMethod.SearchTask(); DataGridViewRow dgvRow; FrmTaskMng frmTaskMng = new FrmTaskMng(); curTask = new ClsTask(); curTask.ProjectID = frmTaskNew.ClsTask.ProjectID; foreach (DataRow row in dt.Rows) { if (row[1].ToString() == curTask.ProjectID.ToString()) { dgvRow = new DataGridViewRow(); dgvRow.CreateCells(dgvTaskList); dgvRow.Cells[0].Value = row[2].ToString(); dgvRow.Cells[1].Value = row[3].ToString(); dgvRow.Cells[2].Value = row[4].ToString(); dgvRow.Cells[3].Value = row[5].ToString(); dgvRow.Tag = row[0]; dgvTaskList.Rows.Add(dgvRow); } } //DataGridViewRow item = dgvTaskList.CurrentRow; //taskName = item.Cells[3].Value.ToString(); if (dgvTaskList.CurrentRow != null) { dgvTaskList.CurrentRow.Selected = true; } }
private void LoadProjectInfo() { try { dgvProjectList.Rows.Clear(); DataTable dt; dt = ClsSQLMethod.SearchProject(); DataGridViewRow dgvRow; foreach (DataRow row in dt.Rows) { dgvRow = new DataGridViewRow(); dgvRow.CreateCells(dgvProjectList); dgvRow.Cells[0].Value = row[1].ToString(); dgvRow.Cells[1].Value = row[2].ToString(); dgvRow.Cells[2].Value = row[3].ToString(); dgvRow.Cells[3].Value = row[4].ToString(); dgvRow.Tag = row[0]; dgvProjectList.Rows.Add(dgvRow); } } catch (Exception) { } }
private void LoadTaskInfo() { dgvTaskList.Rows.Clear(); DataTable dt; dt = ClsSQLMethod.SearchTask(); DataGridViewRow dgvRow; foreach (DataRow row in dt.Rows) { if (row[1].ToString() == curTask.ProjectID.ToString()) { dgvRow = new DataGridViewRow(); dgvRow.CreateCells(dgvTaskList); dgvRow.Cells[0].Value = row[2].ToString(); dgvRow.Cells[1].Value = row[3].ToString(); dgvRow.Cells[2].Value = row[4].ToString(); dgvRow.Cells[3].Value = row[5].ToString(); dgvRow.Tag = row[0]; dgvTaskList.Rows.Add(dgvRow); } } }
public void refreshProjectTree() { try { treeView1.Nodes.Clear(); treeView1.ShowLines = true; treeView1.ImageList = imageList1; DataTable dt1, dt2; dt1 = ClsSQLMethod.SearchProject(); dt2 = ClsSQLMethod.SearchTask(); TreeNode node1 = treeView1.Nodes.Add("A", "项目列表", 1, 2); foreach (DataRow row in dt1.Rows) { TreeNode newNode1 = new TreeNode("项目:" + row[1].ToString(), 3, 4); newNode1.Nodes.Add("A", "测试人员:" + row[3].ToString(), 7, 8); newNode1.Nodes.Add("A", "测试时间:" + row[2].ToString(), 9, 10); newNode1.Nodes.Add("A", "备注:" + row[4].ToString(), 11, 12); foreach (DataRow row1 in dt2.Rows) { if (row[0].ToString() == row1[1].ToString()) { TreeNode node2 = newNode1.Nodes.Add("A", "任务:" + row1[2].ToString(), 1, 2); //node2.Nodes.Add("A", "任务名称:" + row1[2].ToString(), 3, 4); node2.Nodes.Add("A", "物理硬盘:" + row1[3].ToString(), 5, 6); node2.Nodes.Add("A", "起始位置:" + row1[4].ToString(), 7, 8); node2.Nodes.Add("A", "备注:" + row1[5].ToString(), 9, 10); } } node1.Nodes.Add(newNode1); } node1.Expand(); } catch (Exception) { } }