/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
userBase.UserList.Clear();
List <WMS_User_Model> list = new List <WMS_User_Model>();
DataTable dt = WMS_User_Bll.Select_User(" LoginName = '" + SearchText.Text.Trim() + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_User_Model wms_User_Model = new WMS_User_Model
{
LoginName = dt.Rows[i]["LoginName"].ToString(),
LoginPassword = dt.Rows[i]["LoginPassword"].ToString(),
PrivilegeLevel = dt.Rows[i]["PrivilegeLevel"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_User_Model);
}
foreach (var model in list)
{
userBase.UserList.Add(model);
}
this.UserDataGrid.ItemsSource = userBase.UserList;
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Delete_Click(object sender, RoutedEventArgs e)
{
foreach (var name in selectLoginName)
{
WMS_User_Bll.Delete_User(" LoginName = '" + name + "'");
}
Page_Frush();
}
/// <summary>
/// 保存按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Save_Click(object sender, RoutedEventArgs e)
{
if (editFlag == 1)
{
WMS_User_Bll.Insert_User(wMS_User_Model);
}
else if (editFlag == 2)
{
WMS_User_Bll.Update_User(wMS_User_Model, " LoginName = '" + wMS_User_Model.LoginName + "'");
}
editFlag = 0;
Page_Frush();
UserDataGrid.CanUserAddRows = false;
UserDataGrid.IsReadOnly = true;
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <returns></returns>
public static List <WMS_User_Model> GetUserList()
{
List <WMS_User_Model> list = new List <WMS_User_Model>();
DataTable dt = WMS_User_Bll.Select_User(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_User_Model wms_User_Model = new WMS_User_Model
{
LoginName = dt.Rows[i]["LoginName"].ToString(),
LoginPassword = dt.Rows[i]["LoginPassword"].ToString(),
PrivilegeLevel = dt.Rows[i]["PrivilegeLevel"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_User_Model);
}
return(list);
}
private bool LoginCheck(string loginName, string password)
{
DataTable dataTable = WMS_User_Bll.Select_User(" LoginName = '" + loginName + "'");
if (dataTable.Rows.Count != 1)
{
MessageBox.Show("用户数量错误");
return(false);
}
else
{
if (dataTable.Rows[0]["LoginPassword"].ToString() == password)
{
return(true);
}
else
{
MessageBox.Show("密码错误");
return(false);
}
}
}
