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)
{ }
}
