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