IList <ManagerUser> IManagerUserManager.GetManagerUserList(
IManagerUserStorage pStorage,
QueryManagerUser pQueryManagerUser)
{
IList <ManagerUser> response = null;
try
{
#region Verify argument
Verify.ArgumentNotNull(pStorage, "pStorage");
Verify.ArgumentNotNull(pQueryManagerUser, "pQueryManagerUser");
#endregion
response =
pStorage.ListManagerUser(pQueryManagerUser);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
return(response);
}
IList <ManagerUser> IManagerUserStorage.ListManagerUser(
QueryManagerUser pQueryManagerUser)
{
List <ManagerUser> managerUserList = null;
SqlConnection conn;
IDataReader reader;
try
{
Verify.ArgumentNotNull(pQueryManagerUser, "pQueryManagerUser");
conn = new SqlConnection(
ConfigurationManager
.ConnectionStrings["DEFAULT"].ToString());
conn.Open();
reader = ManagerUserSelectWrapper.ExecuteReader(
conn,
pQueryManagerUser);
if (reader != null)
{
managerUserList = new List <ManagerUser>();
while (reader.Read())
{
ManagerUser myManagerUser = DAUtil.ReadManagerUser(
reader);
managerUserList.Add(myManagerUser);
}
}
conn.Close();
}
catch (Exception ex)
{
switch (ex.GetType().FullName)
{
case "System.ArgumentNullException":
{
throw new ArgumentNullException(ex.Message);
}
case "System.ArgumentException":
{
throw new ArgumentException(ex.Message);
}
default:
throw new Exception(ex.Message);
}
}
return(managerUserList);
}
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 static SqlDataReader ExecuteReader(
SqlConnection connection,
QueryManagerUser pQueryManagerUser)
{
SqlDataReader reader;
SqlCommand cmd = null;
SqlParameter p;
try
{
cmd = new SqlCommand();
cmd.CommandText = "spManagerUserSelect";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = connection;
//******* UseerID *******
object val;
if (pQueryManagerUser.UserID == null)
{
val = DBNull.Value;
}
else
{
val = pQueryManagerUser.UserID;
}
p = new SqlParameter("@pUserID", SqlDbType.Int);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* UserName *******
if (pQueryManagerUser.UserName == null ||
pQueryManagerUser.UserName == "")
{
val = DBNull.Value;
}
else
{
val = pQueryManagerUser.UserName;
}
p = new SqlParameter("@pUserName", SqlDbType.VarChar, 20);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
////******* UserPassword *******
//if (pQueryManagerUser.UserPassword == null
// || pQueryManagerUser.UserPassword == "")
// val = DBNull.Value;
//else
// val = pQueryManagerUser.UserPassword;
//p = new SqlParameter("@pUserPassword", SqlDbType.VarChar, 50);
//p.Direction = ParameterDirection.Input;
//p.Value = val;
//cmd.Parameters.Add(p);
//******* UserSort *******
if (pQueryManagerUser.UserSort == null ||
pQueryManagerUser.UserSort == "")
{
val = DBNull.Value;
}
else
{
val = pQueryManagerUser.UserSort;
}
p = new SqlParameter("@pUserSort", SqlDbType.VarChar, 50);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
reader = cmd.ExecuteReader();
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
}
return(reader);
}
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);
}
