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