public bool Delete(UserQueryForm user)
{
ISqlMapper mapper = Common.GetMapperFromSession();
UserDao userdao = new UserDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
UserQueryForm uform = new UserQueryForm
{
ID = user.ID
};
userdao.Delete(uform);
UserInfoQueryForm uiform = new UserInfoQueryForm
{
ID = user.ID,
};
uidao.Delete(uiform);
User_RoleQueryForm urform = new User_RoleQueryForm
{
UserID = user.ID,
};
urdao.Delete(urform);
SOAFramework.Library.WeiXin.WeiXinApi.User.Delete(user.Name);
return(true);
}
public bool Update(User user, UserInfo ui, List<Role> roles)
{
ISqlMapper mapper = MapperHelper.GetMapper();
UserDao dao = new UserDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
var updateuser = GetUserFormCache();
dao.Update(new UserUpdateForm
{
Entity = new User
{
Enabled = user.Enabled,
LastUpdateTime = DateTime.Now,
LastUpdator = updateuser?.User.ID,
},
UserQueryForm = new UserQueryForm { ID = user.ID }
});
if (ui != null)
{
if (uidao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault() == null)
{
ui.ID = user.ID;
uidao.Add(ui);
}
else
{
uidao.Update(new UserInfoUpdateForm
{
Entity = ui,
UserInfoQueryForm = new UserInfoQueryForm { ID = user.ID }
});
}
}
urdao.Delete(new User_RoleQueryForm { UserID = user.ID });
if (roles != null)
{
foreach (var role in roles)
{
urdao.Add(new User_Role { UserID = user.ID, RoleID = role.ID });
}
}
return true;
}
public bool Update(Model.User user, UserInfo ui, List<string> roleidlist)
{
#region risk update
ISqlMapper mapper = Common.GetMapperFromSession();
UserDao udao = new UserDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
if (user != null)
{
Model.User entity = new User
{
ID = user.ID,
Enabled = user.Enabled,
};
udao.Update(new UserUpdateForm { Entity = entity, UserQueryForm = new UserQueryForm { ID = user.ID } });
}
if (ui != null)
{
uidao.Update(new UserInfoUpdateForm { Entity = ui, UserInfoQueryForm = new UserInfoQueryForm { ID = ui.ID } });
}
if (roleidlist != null)
{
User_RoleDao urdao = new User_RoleDao(mapper);
urdao.Delete(new User_RoleQueryForm { UserID = user.ID });
foreach (var role in roleidlist)
{
User_Role ur = new User_Role { RoleID = role, UserID = user.ID };
urdao.Add(ur);
}
}
#endregion
#region weixin api
RoleDao roledao = new RoleDao(mapper);
var roles = roledao.Query(new RoleQueryForm { IDs = roleidlist });
var weixinids = (from r in roles
where !string.IsNullOrEmpty(r.WeiXinID)
select Convert.ToInt32(r.WeiXinID)).ToArray();
var user_temp = udao.Query(new UserQueryForm { ID = user.ID }).FirstOrDefault();
var ui_temp = uidao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
try
{
SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
mobile = ui_temp.Mobile,
name = ui_temp.CnName,
weixinid = ui_temp.WX,
userid = user_temp.Name,
enable = 1,
});
}
catch (SOAFramework.Library.WeiXin.WeiXinException ex)
{
switch (ex.Code)
{
case "60111"://如果微信上不存在用户，就新建
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
enable = 1,
userid = user_temp.Name,
name = ui_temp.CnName,
mobile = ui_temp.Mobile,
weixinid = ui_temp.WX,
department = weixinids,
});
break;
default:
throw ex;
}
}
#endregion
return true;
}
public bool Delete(UserQueryForm user)
{
ISqlMapper mapper = Common.GetMapperFromSession();
UserDao userdao = new UserDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
UserQueryForm uform = new UserQueryForm
{
ID = user.ID
};
userdao.Delete(uform);
UserInfoQueryForm uiform = new UserInfoQueryForm
{
ID = user.ID,
};
uidao.Delete(uiform);
User_RoleQueryForm urform = new User_RoleQueryForm
{
UserID = user.ID,
};
urdao.Delete(urform);
SOAFramework.Library.WeiXin.WeiXinApi.User.Delete(user.Name);
return true;
}
public bool Update(Model.User user, UserInfo ui, List <string> roleidlist)
{
#region risk update
ISqlMapper mapper = Common.GetMapperFromSession();
UserDao udao = new UserDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
if (user != null)
{
Model.User entity = new User
{
ID = user.ID,
Enabled = user.Enabled,
};
udao.Update(new UserUpdateForm {
Entity = entity, UserQueryForm = new UserQueryForm {
ID = user.ID
}
});
}
if (ui != null)
{
uidao.Update(new UserInfoUpdateForm {
Entity = ui, UserInfoQueryForm = new UserInfoQueryForm {
ID = ui.ID
}
});
}
if (roleidlist != null)
{
User_RoleDao urdao = new User_RoleDao(mapper);
urdao.Delete(new User_RoleQueryForm {
UserID = user.ID
});
foreach (var role in roleidlist)
{
User_Role ur = new User_Role {
RoleID = role, UserID = user.ID
};
urdao.Add(ur);
}
}
#endregion
#region weixin api
RoleDao roledao = new RoleDao(mapper);
var roles = roledao.Query(new RoleQueryForm {
IDs = roleidlist
});
var weixinids = (from r in roles
where !string.IsNullOrEmpty(r.WeiXinID)
select Convert.ToInt32(r.WeiXinID)).ToArray();
var user_temp = udao.Query(new UserQueryForm {
ID = user.ID
}).FirstOrDefault();
var ui_temp = uidao.Query(new UserInfoQueryForm {
ID = user.ID
}).FirstOrDefault();
try
{
SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
mobile = ui_temp.Mobile,
name = ui_temp.CnName,
weixinid = ui_temp.WX,
userid = user_temp.Name,
enable = 1,
});
}
catch (SOAFramework.Library.WeiXin.WeiXinException ex)
{
switch (ex.Code)
{
case "60111": //如果微信上不存在用户，就新建
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
enable = 1,
userid = user_temp.Name,
name = ui_temp.CnName,
mobile = ui_temp.Mobile,
weixinid = ui_temp.WX,
department = weixinids,
});
break;
default:
throw ex;
}
}
#endregion
return(true);
}