private void btnModfiy_Click(object sender, EventArgs e) { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser managerUser = new ManagerUser(); if (textUserName.Text.Trim() == "" || textUserPassword.Text.Trim() == "" || cmbUserSort.Text == "") { MessageBox.Show("请双击选择需要修改的记录!"); } else { managerUser.UserName = textUserName.Text; managerUser.UserPassword = textUserPassword.Text; managerUser.UserSort = cmbUserSort.Text; managerUser.UserID = Convert.ToInt32(dgvManagerUser[0, dgvManagerUser.CurrentCell.RowIndex].Value.ToString()); managerUserStorage.UpdateManagerUser(managerUser); MessageBox.Show("更新成功!"); textUserName.Text = ""; textUserPassword.Text = ""; cmbUserSort.Text = ""; } }
public void ManagerUserUpdateSuccessThree() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户5", "123456", "系统管理员"); ManagerUser createdManagerUser = managerUserStorage.CreateManagerUser(myManagerUser); Assert.AreNotEqual( 0, createdManagerUser.UserID, string.Format("Could not create ManagerUser:{0}", createdManagerUser.UserID)); myManagerUser.UserSort = "系统操作员"; managerUserStorage.UpdateManagerUser(myManagerUser); ManagerUser updatedManagerUser = managerUserStorage.ReadManagerUser( createdManagerUser.UserID); AssertManagerUserItemEqual(myManagerUser, updatedManagerUser); }
public void ManagerUserCreateFailureUserNameArgumentNullException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( null, "123456", "系统管理员"); managerUserStorage.CreateManagerUser(myManagerUser); }
public void ManagerUserCreateFailureUserPasswordArgumentNullException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户3", null, "系统管理员"); managerUserStorage.CreateManagerUser(myManagerUser); }
private void btnSelect_Click(object sender, EventArgs e) { IList <ManagerUser> managerUserList = new List <ManagerUser>(); IManagerUserStorage managerUserStorage = new ManagerUserStorage(); QueryManagerUser queryManagerUser = new QueryManagerUser(); if (textUserPassword.Text.Trim() != "") { MessageBox.Show("无法通过密码查询!"); } else { if (cmbUserSort.Text.Trim() == "" || cmbUserSort.Text.Trim() == "全部") { queryManagerUser.UserName = textUserName.Text.Trim(); } else { queryManagerUser.UserName = textUserName.Text.Trim(); queryManagerUser.UserSort = cmbUserSort.Text.Trim(); } managerUserList = managerUserStorage.ListManagerUser(queryManagerUser); dgvManagerUser.AutoGenerateColumns = false; DataTable dt = new DataTable(); dt.Columns.Add("UserID", typeof(System.Int32)); dt.Columns.Add("UserName", typeof(System.String)); dt.Columns.Add("UserPassword", typeof(System.String)); dt.Columns.Add("UserSort", typeof(System.String)); dgvManagerUser.DataSource = managerUserList; foreach (ManagerUser user in managerUserList) { dt.Rows.Add( user.UserID, user.UserName, user.UserPassword, user.UserSort); } BindingSource source = new BindingSource(); source.DataSource = dt; dgvManagerUser.DataSource = source; } }
public void ManagerUserReadFailureUserIdArgumentException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); //ManagerUser myManagerUser = CreateManagerUserForTest( // "用户5", // "123456", // "系统管理员"); //ManagerUser createdManagerUser = //managerUserStorage.CreateManagerUser(myManagerUser); managerUserStorage.ReadManagerUser(-1); }
public void ManagerUserUpdateFailureUserIdArgumentException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户6", "123456", "系统管理员"); managerUserStorage.CreateManagerUser(myManagerUser); myManagerUser.UserID = int.MaxValue; managerUserStorage.UpdateManagerUser(myManagerUser); }
public void ManagerUserUpdateFailureUserPasswordArgumentNullException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户6", "123456", "系统管理员"); managerUserStorage.CreateManagerUser(myManagerUser); myManagerUser.UserPassword = null; managerUserStorage.UpdateManagerUser(myManagerUser); }
public void ManagerUserCreateSuccess() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户1", "123456", "系统管理员"); ManagerUser createdManagerUser = managerUserStorage.CreateManagerUser(myManagerUser); Assert.AreNotEqual( 0, createdManagerUser.UserID, string.Format("Could not create ManagerUser:{0}", createdManagerUser.UserID)); AssertManagerUserItemEqual(myManagerUser, createdManagerUser); }
private void btnAdd_Click(object sender, EventArgs e) { ManagerUser managerUser = new ManagerUser(); IManagerUserStorage managerUserStorage = new ManagerUserStorage(); if (textUserName.Text.Trim() == "" || textUserPassword.Text.Trim() == "" || cmbUserSort.Text == "") { MessageBox.Show("请输入全部信息,不要有遗漏。"); } else { managerUser.UserName = textUserName.Text.Trim(); managerUser.UserPassword = textUserPassword.Text.Trim(); managerUser.UserSort = cmbUserSort.Text.Trim(); switch (cmbUserSort.SelectedIndex) { case 1: managerUser.UserSort = "系统管理员"; break; case 2: managerUser.UserSort = "系统操作员"; break; default: managerUser.UserSort = null; break; } managerUserStorage.CreateManagerUser(managerUser); MessageBox.Show("增加成功!"); textUserName.Text = ""; textUserPassword.Text = ""; cmbUserSort.Text = ""; } }
private void btnLogin_Click(object sender, EventArgs e) { IList <ManagerUser> managerUserList = new List <ManagerUser>(); //IManagerUserManager managerUserManager = new ManagerUserManager(); /*IManagerUserManager用于处理逻辑,界面可不使用*/ IManagerUserStorage managerUserStorage = new ManagerUserStorage(); QueryManagerUser queryManagerUser = new QueryManagerUser(); if (txtUserName.Text.Trim() == "" || txtUserPassword.Text.Trim() == "") { MessageBox.Show("请输入用户名和密码"); } else { queryManagerUser.UserID = null; /*对应数据库中的查询存储过程*/ queryManagerUser.UserName = txtUserName.Text.Trim(); queryManagerUser.UserPassword = txtUserPassword.Text.Trim(); queryManagerUser.UserSort = null; /*managerUserList = managerUserManager.GetManagerUserList( //对应上述的managerUserManager * managerUserStorage, * queryManagerUser);*/ managerUserList = managerUserStorage.ListManagerUser( /*调用managerUserList,将集合(数组)取到*/ queryManagerUser); if (managerUserList.Count == 1) /*一条记录符合,跳转到主界面*/ { this.Hide(); MainForm mainFrom = new MainForm(); mainFrom.ShowDialog(); } else { MessageBox.Show("账号或密码不正确"); } } }
//这个属性其实非常有用处,它表明这个函数会抛出一个预期的异常。 public void ManagerUserCreateFailureManagerUserArgumentNullException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); managerUserStorage.CreateManagerUser(null); }
public void ManagerUserListFailureManagerUserArgumentNullException() { IManagerUserStorage managerUserStorage = new ManagerUserStorage(); managerUserStorage.ListManagerUser(null); }
public void ManagerUserListSuccess() { List <ManagerUser> managerUserList = new List <ManagerUser>(); IManagerUserStorage managerUserStorage = new ManagerUserStorage(); ManagerUser myManagerUser = CreateManagerUserForTest( "用户7", "123456", "系统管理员"); ManagerUser createdManagerUser = managerUserStorage.CreateManagerUser(myManagerUser); managerUserList.Add(createdManagerUser); myManagerUser = CreateManagerUserForTest( "用户8", "123456", "系统操作员"); createdManagerUser = managerUserStorage.CreateManagerUser(myManagerUser); managerUserList.Add(createdManagerUser); myManagerUser = CreateManagerUserForTest( "用户9", "123456", "系统操作员"); createdManagerUser = managerUserStorage.CreateManagerUser(myManagerUser); managerUserList.Add(createdManagerUser); QueryManagerUser queryManagerUser = new QueryManagerUser(); queryManagerUser.UserID = null; queryManagerUser.UserName = null; queryManagerUser.UserPassword = null; queryManagerUser.UserSort = null; IList <ManagerUser> readedManagerUserList = managerUserStorage.ListManagerUser(queryManagerUser); AssertManagerUserListsEqual(managerUserList, readedManagerUserList); managerUserList.RemoveAt(0); queryManagerUser = new QueryManagerUser(); queryManagerUser.UserID = null; queryManagerUser.UserName = null; queryManagerUser.UserPassword = null; queryManagerUser.UserSort = "系统操作员"; readedManagerUserList = managerUserStorage.ListManagerUser(queryManagerUser); AssertManagerUserListsEqual(managerUserList, readedManagerUserList); managerUserList.RemoveAt(0); queryManagerUser = new QueryManagerUser(); queryManagerUser.UserID = null; queryManagerUser.UserName = "******"; queryManagerUser.UserPassword = null; queryManagerUser.UserSort = null; readedManagerUserList = managerUserStorage.ListManagerUser(queryManagerUser); AssertManagerUserListsEqual(managerUserList, readedManagerUserList); }