private void Button_Click_24(object sender, RoutedEventArgs e)
{
role r = UserRole.SelectByGuid("278c6576-8051-4d6d-afff-2b6cfb7dbfa3");
r.roleName = "王八蛋";
MessageBox.Show(UserRole.Update(r).ToString());
}
private List <UserModel> getuerlist(List <users> userlist)
{
List <UserModel> _usermodellist = new List <UserModel>();
try
{
if (userlist != null && userlist.Count > 0)
{
int count = 0;
foreach (users u in userlist)
{
if (u != null)
{
count++;
UserModel um = new UserModel();
um.id = count;
um.username = u.username;
um.empID = u.empID;
um.cardID = u.cardID;
um.is_staff = u.is_staff;
um.password = u.password;
um.phoneNumber = u.phoneNumber;
um.comment = u.comment;
um.guid = u.guid;
// um.joinDate = u.joinDate.ToString ().Replace('T', ' ')+"1";
um.joinDate = u.joinDate;
List <QDDL.Model.UserToRoleModel.usertorole> ul = new List <UserToRoleModel.usertorole>();
role r = new role();
ul = UserToRole.selectbyuserid(u.guid);
if (ul.Count > 0)
{
r = _UserRole.SelectByGuid(ul.FirstOrDefault().role);
um.roleName = r.roleName;
um.roleID = r.guid;
}
um.departName = _Department.SelectByGuid(u.department).departmentName;
um.department = u.department;
_usermodellist.Add(um);
}
}
}
else
{
MessageAlert.Alert("所查信息不存在！");
}
return(_usermodellist);
}
catch (Exception ex) {
return(_usermodellist);
}
}
public List <UserModel> GetUserModel()
{
List <UserModel> uml = new List <UserModel>();
List <QDDL.Model.UserToRoleModel.usertorole> utr = new List <UserToRoleModel.usertorole>();
try
{
int count = 0;
utr = GetUserToRole(programname);
foreach (QDDL.Model.UserToRoleModel.usertorole ur in utr)
{
count++;
users us = User.SelectByguid(ur.user);
role r = UserRole.SelectByGuid(ur.role);
department d = Department.SelectByGuid(us.department);
duties du = new duties();
du = UserDuty.SelectByGuid((us == null || us.duties == null) ? "" : us.duties);
uml.Add(new UserModel()
{
username = us.username,
id = count,
password = us.password,
is_superuser = us.is_superuser,
is_staff = us.is_staff,
//joinDate =us.joinDate.Replace ('T',' ') ,
joinDate = us.joinDate,
duties = us.duties,
empID = us.empID,
cardID = us.cardID,
phoneNumber = us.phoneNumber,
IDNum = us.IDNum,
mail = us.mail,
department = us.department,
comment = us.comment,
guid = us.guid,
departName = (d == null || d.departmentName == null) ? "" : d.departmentName,
roleName = (r == null || r.roleName == null) ? "" : r.roleName,
roleID = (r == null || r.roleDM == null) ? "" : r.guid,
dutyname = (du == null || du.dutiesName == null) ? "" : du.dutiesName
});
}
}
catch (Exception ep) { return(uml = null); }
return(uml);
}
