public UserInfoDao selectUserInfoWithNameAndPwd(string user, string pwd)
{
string tablename = "t_user";
string sql = "select a.*,b.itemname as usertypename,c.groupname as groupname" +
" from " + tablename + " a " +
" left join t_itemcollection b on b.itemtype='UserType' and b.itemvalue=a.usertype " +
" left join t_group c on a.group=c.id " +
" where name='" + user + "' ";
if (pwd != "")
{
sql += " and password='******' ";
}
DataTable _dt = this.SelectQuery(sql);
if (_dt == null || _dt.Rows.Count <= 0)
{
return(null);
}
else
{
UserInfoDao info = new UserInfoDao();
info.Id = Convert.ToInt32(_dt.Rows[0]["id"].ToString());
info.Name = _dt.Rows[0]["name"].ToString();
info.Usertype = _dt.Rows[0]["usertypename"].ToString();
return(info);
}
}
public DeleteUserInfoResponse Process(DeleteUserInfoRequest request)
{
try
{
if (request.UserId == 0)
{
}
var userDao = new UserInfoDao();
bool result = userDao.DeleteUser(request.UserId);
return(new DeleteUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.OK
});
}
catch (Exception ex)
{
Log.Error(ex);
return(new DeleteUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.Error
});
}
}
public Pegawai(Connection conn)
{
InitializeComponent();
userinfoDao = new UserInfoDao(conn.getConnection());
loadDataPegawai();
}
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 Login()
{
InitializeComponent();
conn = Connection.GetInstance();
userInfoDao = new UserInfoDao(conn.getConnection());
}
public GetUserInfoResponse Process(GetUserInfoRequest request)
{
try
{
if (request.UserId == 0)
{
}
UserInfo userInfo = null;
var dao = new UserInfoDao();
var userData = dao.GetUser(request.UserId);
if (userData != null)
{
userInfo = UserInfoMapper.ToModel(userData);
}
return(new GetUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.OK, UserInfo = userInfo
});
}
catch (Exception ex)
{
Log.Error(ex);
return(new GetUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.Error
});
}
}
public UserInfoDao selectUserInfoWithId(string id)
{
string tablename = "t_user";
string sql = "select a.*,b.itemname as usertypename,d.itemname as userstatus" +
" from " + tablename + " a " +
" left join t_itemcollection b on b.itemtype='UserType' and b.itemvalue=a.usertype " +
" left join t_itemcollection d on d.itemtype='UserStatus' and d.itemvalue=a.status " +
" where a.id='" + id + "' ";
DataTable _dt = this.SelectQuery(sql);
if (_dt == null || _dt.Rows.Count <= 0)
{
return(null);
}
else
{
UserInfoDao info = new UserInfoDao();
info.Id = Convert.ToInt32(_dt.Rows[0]["id"].ToString());
info.Name = _dt.Rows[0]["name"].ToString();
info.Usertype = _dt.Rows[0]["usertypename"].ToString();
info.State = _dt.Rows[0]["userstatus"].ToString();
return(info);
}
}
public GetAllUsersResponse Process(GetAllUsersRequest request)
{
try
{
var users = new List <UserInfo>();
var userData = new UserInfoDao().GetAllUsers(true);
if (userData != null)
{
userData.ForEach(x => users.Add(UserInfoMapper.ToUserSummaryDto(x)));
}
return(new GetAllUsersResponse()
{
Token = request.Token, ResultType = ResultType.OK, Users = users
});
}
catch (Exception ex)
{
Log.Error(ex);
return(new GetAllUsersResponse()
{
Token = request.Token, ResultType = ResultType.Error
});
}
}
public LogonResultForm GetUserInfo(string userid)
{
var mapper = Common.GetMapperFromSession();
UserDao userdao = new UserDao(mapper);
var user = userdao.Query(new UserQueryForm { Name = userid }).FirstOrDefault();
if (user == null) throw new Exception("用户：" + userid + "在系统中不存在！");
if (user.Enabled == 0) throw new Exception("该用户已被禁用，请联系管理员！");
LogonResultForm result = new LogonResultForm();
UserInfoDao userInfoDao = new UserInfoDao(mapper);
RoleDao roleDao = new RoleDao(mapper);
LogonHistoryDao historyDao = new LogonHistoryDao(mapper);
string token = Guid.NewGuid().ToString().Replace("-", "");
var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
UserEntireInfo u = new UserEntireInfo { User = user };
if (userinfo != null) u.UserInfo = userinfo;
u.Role = roleDao.QueryRoleByUserID(u.User.ID);
CacheItem item = new CacheItem(token, u);
LogonHistory history = new LogonHistory
{
LogonTime = DateTime.Now,
Token = token,
UserID = user.ID,
ActiveTime = DateTime.Now,
};
historyDao.Add(history);
result.token = token;
result.UserInfo = userinfo;
cache.AddItem(item, 30 * 60);
MenuBLL menubll = new MenuBLL();
result.Menu = menubll.GetCurrentUserMenu(result.token);
return result;
}
public LoginResultForm Login(string username, string password)
{
LoginResultForm result = new LoginResultForm();
ISqlMapper mapper = MapperHelper.GetMapper();
UserDao userdao = new UserDao(mapper);
UserInfoDao userInfoDao = new UserInfoDao(mapper);
RoleDao roleDao = new RoleDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
LogonHistoryDao historyDao = new LogonHistoryDao(mapper);
MenuDao menudao = new MenuDao(mapper);
Menu_RoleDao mrdao = new Menu_RoleDao(mapper);
var user = userdao.Query(new UserQueryForm { Name = username, Password = password }).FirstOrDefault();
if (user != null)
{
if (user.Enabled == 0) throw new Exception("该用户已被禁用，请联系管理员！");
string token = Guid.NewGuid().ToString().Replace("-", "");
var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault();
var ur = urdao.Query(new User_RoleQueryForm { UserID = user.ID });
List<string> roleidlist = new List<string>();
ur.ForEach(t =>
{
roleidlist.Add(t.RoleID);
});
var roles = roleDao.Query(new RoleQueryForm { IDs = roleidlist });
var mrs = mrdao.Query(new Menu_RoleQueryForm { RoleIDs = roleidlist });
var menuids = (from mr in mrs select mr.MenuID).Distinct().ToList();
result.Menu = menudao.Query(new MenuQueryForm { IDs = menuids, Enabled = 1 });
UserEntireInfo u = new UserEntireInfo
{
User = user,
UserInfo = userinfo,
Role = roles,
};
CacheItem item = new CacheItem(token, u);
LogonHistory history = new LogonHistory
{
LogonTime = DateTime.Now,
Token = token,
UserID = user.ID,
ActiveTime = DateTime.Now,
};
historyDao.Add(history);
result.User = u;
result.token = token;
cache.AddItem(item, 1800);
//MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "login user:"******",token:" + token }, SOAFramework.Library.CacheEnum.FormMonitor);
return result;
}
else
{
throw new Exception("用户名或者密码错误！请输入正确的用户名和密码！");
}
}
public LogonResultForm GetUserInfo(string userid)
{
var mapper = Common.GetMapperFromSession();
UserDao userdao = new UserDao(mapper);
var user = userdao.Query(new UserQueryForm {
Name = userid
}).FirstOrDefault();
if (user == null)
{
throw new Exception("用户：" + userid + "在系统中不存在！");
}
if (user.Enabled == 0)
{
throw new Exception("该用户已被禁用，请联系管理员！");
}
LogonResultForm result = new LogonResultForm();
UserInfoDao userInfoDao = new UserInfoDao(mapper);
RoleDao roleDao = new RoleDao(mapper);
LogonHistoryDao historyDao = new LogonHistoryDao(mapper);
string token = Guid.NewGuid().ToString().Replace("-", "");
var userinfo = userInfoDao.Query(new UserInfoQueryForm {
ID = user.ID
}).FirstOrDefault();
UserEntireInfo u = new UserEntireInfo {
User = user
};
if (userinfo != null)
{
u.UserInfo = userinfo;
}
u.Role = roleDao.QueryRoleByUserID(u.User.ID);
LogonHistory history = new LogonHistory
{
LogonTime = DateTime.Now,
Token = token,
UserID = user.ID,
ActiveTime = DateTime.Now,
};
historyDao.Add(history);
result.token = token;
result.UserInfo = userinfo;
cache.AddItem(token, u, 30 * 60);
MenuBLL menubll = new MenuBLL();
result.Menu = menubll.GetCurrentUserMenu(result.token);
return(result);
}
public UpdateUserInfoResponse Process(UpdateUserInfoRequest request)
{
try
{
if (request.UserInfo == null)
{
}
var userEnrollInfoDao = new UserEnrollInfoDao();
var userDao = new UserInfoDao();
var enroll = new Enroll()
{
DIN = (UInt64)request.UserInfo.UserId, Fingerprint = new byte[Zd2911Utils.MaxFingerprintLength * 10]
};
var deviceUser = new User()
{
DIN = (UInt64)request.UserInfo.UserId, Enrolls = new List <Enroll> {
enroll
}
};
if (request.UserInfo.CredentialServices != null)
{
var originalEnroll = userEnrollInfoDao.GetEnroll(request.UserInfo.UserId);
if (originalEnroll != null)
{
enroll.EnrollType = originalEnroll.EnrollType;
}
}
UserInfoMapper.UpdateSystemInfo(ref deviceUser, request.UserInfo);
bool result = userDao.SaveOrUpdateUser(deviceUser);
return(new UpdateUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.OK
});
}
catch (Exception ex)
{
Log.Error(ex);
return(new UpdateUserInfoResponse()
{
Token = request.Token, ResultType = ResultType.Error
});
}
}
protected void btnSignUp_Click(object sender, EventArgs e)
{
try
{
UserInfo objUserInfo = new UserInfo();
objUserInfo.FullName = txtName.Text;
objUserInfo.EmailId = txtEmail.Text;
objUserInfo.Company = txtCompanyName.Text;
objUserInfo.PhoneNum = txtPhoneNum.Text;
objUserInfo.Skype = txtSkype.Text;
AddressInfo objAddressInfo = new AddressInfo()
{
AddressLine1 = txtAddressLine1.Text,
AddressLine2 = txtAddressLine2.Text,
CountryId = (ddlCountry.SelectedIndex > 0) ? ddlCountry.SelectedItem.Value : null,
State = txtState.Text,
MainAddress = true,
EmailId = txtEmail.Text,
};
LoginInfo objLoginInfo = new LoginInfo()
{
EmailId = txtEmail.Text,
Password = txtPassword.Text,
UserType = (rbAdvertiser.Checked) ? rbAdvertiser.Text : rbPublisher.Text
};
if (UserInfoDao.GetUserInfo(txtEmail.Text) != null)
{
Response.Write(AdManagementUtility.GetAlertMessage("User already exist"));
}
else
{
if (UserInfoDao.SaveUserInfo(objUserInfo, objAddressInfo, objLoginInfo))
{
Response.Write(AdManagementUtility.GetRedirectMessage(Request.Path, "User registered successfully"));
}
else
{
Response.Write(AdManagementUtility.GetAlertMessage("Error while registering the user"));
}
}
}
catch (Exception)
{
Response.Write(AdManagementUtility.GetAlertMessage("Error while registering the user. Invalid data."));
}
}
public OpenIMTribeChatLogsResult GetChatLogs(OpenIMChatLogsTribeRequestInfo chatLogsRequestInfo)
{
chatLogsRequestInfo = Config.Attribute.ConvertObjectWithDateTime <OpenIMChatLogsTribeRequestInfo>(chatLogsRequestInfo);
chatLogsRequestInfo.EndTime = chatLogsRequestInfo.EndTime.Value.AddHours(1);
//OpenimTribelogsGetResponse.TribeMessageResultDomain chatLogs = IopenIMGroupInfo.GetChatLogs(chatLogsRequestInfo);
//chatLogs.Messages = chatLogs.Messages.OrderBy(o => o.Time).ToList<OpenimTribelogsGetResponse.TribeMessageDomain>();
OpenIMTribeChatLogsResult result = new OpenIMTribeChatLogsResult();
//result.NextKey = chatLogs.NextKey;
result.Messages = new List <TribeChatLogsMessageItem>();
List <string> fromids = new List <string>();
//foreach (var item in chatLogs.Messages)
//{
// fromids.Add(item.FromId.Uid);
// result.Messages.Add(new TribeChatLogsMessageItem()
// {
// Content = item.Content,
// FromUserID = item.FromId.Uid,
// Time = item.Time,
// Type = item.Type,
// Uuid = item.Uuid
// });
//}
IUserInfo IuserInfo = new UserInfoDao(false);
List <SimplePersonUserView> persons = IuserInfo.GetSimplePersonUserInfos(fromids);
foreach (var item in result.Messages)
{
foreach (SimplePersonUserView sub in persons.AsEnumerable())
{
if (item.FromUserID.ToUpper() == sub.UserID.ToUpper())
{
item.FromUserName = sub.UserName;
item.FromUserType = sub.UserType;
item.FromUserUrl = CommonService.GetManageFullUrl(sub.UserUrl);
item.FromUserLevel = sub.UserLevel;
}
}
}
return(result);
}
public MiicConditionCollections visitor(UserInfoDao userInfoDao)
{
MiicConditionCollections result = new MiicConditionCollections();
//关键字
MiicConditionCollections keywordCondition = new MiicConditionCollections(MiicDBLogicSetting.No);
MiicCondition socialCode = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.SocialCode),
this.Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.No, socialCode));
MiicCondition userName = new MiicCondition(Config.Attribute.GetSqlColumnNameByPropertyName <Miic.Friends.User.SimpleUserView, string>(o => o.UserName),
this.Keyword,
DbType.String,
MiicDBOperatorSetting.Like);
keywordCondition.Add(new MiicConditionLeaf(MiicDBLogicSetting.Or, userName));
result.Add(keywordCondition);
return(result);
}
public UserEntireInfo GetCurrentUser(string token = null)
{
ISqlMapper mapper = Common.GetMapperFromSession();
if (string.IsNullOrEmpty(token))
{
token = ServiceSession.Current.Context.Parameters["token"].ToString();
}
var u = GetUserEntireInfoFromCache(token);
if (u == null)
{
MonitorCache.GetInstance().PushMessage(new CacheMessage {
Message = "user is null"
}, SOAFramework.Library.CacheEnum.FormMonitor);
UserDao userdao = new UserDao(mapper);
RoleDao roledao = new RoleDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
LogonHistoryDao lhdao = new LogonHistoryDao(mapper);
var logonhistory = lhdao.Query(new LogonHistoryQueryForm {
Token = token
}).FirstOrDefault();
string userid = logonhistory.UserID;
var user = userdao.Query(new UserQueryForm {
ID = userid
}).FirstOrDefault();
var userinfo = uidao.Query(new UserInfoQueryForm {
ID = userid
}).FirstOrDefault();
var roles = roledao.QueryRoleByUserID(userid);
u = new UserEntireInfo
{
User = user,
Role = roles,
UserInfo = userinfo,
};
}
return(u);
}
public string Add(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);
string id = dao.Add(user);
if (ui != null)
{
ui.ID = id;
uidao.Add(ui);
}
if (roles != null)
{
foreach (var role in roles)
{
urdao.Add(new User_Role { UserID = id, RoleID = role.ID });
}
}
return id;
}
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 List <InitApprovalResultForm> Query(List <string> projectids, List <string> taskids, string currentuserid)
{
#region init dao
List <InitApprovalResultForm> result = new List <InitApprovalResultForm>();
if (projectids == null || projectids.Count == 0)
{
return(new List <InitApprovalResultForm>());
}
ISqlMapper mapper = Common.GetMapperFromSession();
ProjectDao dao = new ProjectDao(mapper);
Customer_ProjectDao cpdao = new Customer_ProjectDao(mapper);
Customer_AssetDao cadao = new Customer_AssetDao(mapper);
Asset_ProjectDao apdao = new Asset_ProjectDao(mapper);
WorkflowDao workflowdao = new WorkflowDao(mapper);
ActivityDao activitydao = new ActivityDao(mapper);
ApprovalDao appvoraldao = new ApprovalDao(mapper);
TaskDao taskdao = new TaskDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
User_RoleDao urdao = new User_RoleDao(mapper);
TrackingChangeOwnerDao tcodao = new TrackingChangeOwnerDao(mapper);
TrackingMortgageDao tmdao = new TrackingMortgageDao(mapper);
LinkDao linkdao = new LinkDao(mapper);
Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper);
ReturnBackConfirmDao rbcdao = new ReturnBackConfirmDao(mapper);
CreditReceiverInfoDao cridao = new CreditReceiverInfoDao(mapper);
#endregion
#region 查询数据
List <Customer_Project> cps = new List <Customer_Project>();
List <Customer_Asset> cas = new List <Customer_Asset>();
List <Asset_Project> aps = new List <Asset_Project>();
List <Activity> activities = new List <Activity>();
List <Approval> approvals = new List <Approval>();
List <Task> tasks = new List <Task>();
List <TrackingChangeOwner> tco = new List <TrackingChangeOwner>();
List <TrackingMortgage> tm = new List <TrackingMortgage>();
List <string> projectidlist = new List <string>();
List <string> workflowids = new List <string>();
List <CreditReceiverInfo> criList = new List <CreditReceiverInfo>();
List <Link> links = new List <Link>();
List <ReturnBackConfirm> returnBackMoneyInfo = new List <ReturnBackConfirm>();
List <Workflow> workflows = null;
List <Project> list = null;
var rma = rmadao.Query(new Role_Module_ActionQueryForm {
});
if (taskids != null && taskids.Count > 0)
{
tasks = taskdao.Query(new TaskQueryForm {
IDs = taskids
});
workflowids = (from t in tasks
select t.WorkflowID).Distinct().ToList();
workflows = workflowdao.Query(new WorkflowQueryForm {
IDs = workflowids
});
activities = activitydao.Query(new ActivityQueryForm {
WorkflowIDs = workflowids
});
approvals = appvoraldao.Query(new ApprovalQueryForm {
WorkflowIDs = workflowids
});
projectidlist = (from w in workflows
select w.ProcessID).ToList();
list = dao.Query(new ProjectQueryForm {
IDs = projectidlist
});
}
else if (projectids != null && projectids.Count > 0)
{
list = dao.Query(new ProjectQueryForm {
IDs = projectids
});
projectidlist = (from p in list
select p.ID).ToList();
workflows = workflowdao.Query(new WorkflowQueryForm {
ProcessIDs = projectidlist
});
workflowids = (from w in workflows
select w.ID).ToList();
if (workflowids.Count > 0)
{
activities = activitydao.Query(new ActivityQueryForm {
WorkflowIDs = workflowids
});
approvals = appvoraldao.Query(new ApprovalQueryForm {
WorkflowIDs = workflowids
});
tasks = taskdao.Query(new TaskQueryForm {
WorkflowIDs = workflowids
});
}
}
else
{
return(result);
}
if (projectidlist.Count > 0)
{
cps = cpdao.Query(new Customer_ProjectQueryForm {
ProjectIDs = projectidlist
});
cas = cadao.Query(new Customer_AssetQueryForm {
ProjectIDs = projectidlist
});
aps = apdao.Query(new Asset_ProjectQueryForm {
ProjectIDs = projectidlist
});
}
var users = uidao.Query(new UserInfoQueryForm {
});
var userroles = urdao.Query(new User_RoleQueryForm {
});
criList = cridao.Query(new CreditReceiverInfoQueryForm {
ProjectIDs = projectids
});
tco = tcodao.Query(new TrackingChangeOwnerQueryForm {
ProjectIDs = projectidlist
});
tm = tmdao.Query(new TrackingMortgageQueryForm {
ProjectIDs = projectidlist
});
returnBackMoneyInfo = rbcdao.Query(new ReturnBackConfirmQueryForm {
ProjectIDs = projectidlist
});
//从缓存中取得
var customers = TableCacheHelper.GetDataFromCache <Customer>(typeof(CustomerDao));
var assets = TableCacheHelper.GetDataFromCache <Asset>(typeof(AssetDao));
#endregion
#region 处理废单权限
//处理废单权限
var hasDisplayDiscard = (from ur in userroles
join r in rma on ur.RoleID equals r.RoleID
where r.ModuleID == "4" && r.ActionID == "4" && ur.UserID == currentuserid
select r).FirstOrDefault();
#endregion
foreach (Project project in list)
{
var data = QueryDetail(project, customers, assets, cps, cas, aps, workflows, activities, approvals, tasks, users, userroles,
tco, tm, returnBackMoneyInfo, criList, currentuserid);
if (hasDisplayDiscard != null)
{
data.DisplayDiscard = true;
}
result.Add(data);
}
return(result);
}
public string Add(Model.User user, UserInfo ui, List <string> roleidlist)
{
#region risk user
ISqlMapper mapper = Common.GetMapperFromSession();
if (user == null)
{
throw new Exception("user不能为null！");
}
UserDao dao = new UserDao(mapper);
var exist = dao.Query(new UserQueryForm {
Name = user.Name
});
if (exist.Count > 0)
{
throw new Exception("已存在用户名：" + user.Name);
}
if (string.IsNullOrEmpty(ui.WX) && string.IsNullOrEmpty(ui.Mobile))
{
throw new Exception("微信号或者手机不能为空");
}
string id = dao.Add(user);
if (ui == null)
{
ui = new UserInfo();
}
UserInfoDao infodao = new UserInfoDao(mapper);
ui.ID = id;
infodao.Add(ui);
if (roleidlist == null)
{
return(id);
}
User_RoleDao urdao = new User_RoleDao(mapper);
foreach (var role in roleidlist)
{
User_Role ur = new User_Role {
RoleID = role, UserID = user.ID
};
urdao.Add(ur);
}
#endregion
#region weixin user
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();
try
{
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
enable = 1,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
}
catch (SOAFramework.Library.WeiXin.WeiXinException ex)
{
switch (ex.Code)
{
case "60004":
case "60003":
foreach (var role in roles)
{
//部门不存在就新建部门
Role parentrole = null;
if (!string.IsNullOrEmpty(role.ParentID))
{
roledao.Query(new RoleQueryForm {
ID = role.ParentID
}).FirstOrDefault();
}
var department = new SOAFramework.Library.WeiXin.Department
{
name = role.Name,
};
if (parentrole != null)
{
department.parentid = parentrole.WeiXinID;
}
var response = SOAFramework.Library.WeiXin.WeiXinApi.Department.Create(department);
roledao.Update(new RoleUpdateForm
{
Entity = new Role {
WeiXinID = response.id
},
RoleQueryForm = new RoleQueryForm {
ID = role.ID
},
});
}
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
enable = 1,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
break;
case "60102": //用户已存在
SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
break;
default:
throw ex;
}
}
#endregion
return(id);
}
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 UserEntireInfo GetCurrentUser(string token = null)
{
ISqlMapper mapper = MapperHelper.GetMapper();
if (string.IsNullOrEmpty(token)) token = ServiceSession.Current.Context.Parameters["token"].ToString();
var u = GetUserEntireInfoFromCache(token);
if (u == null)
{
MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "user is null" }, SOAFramework.Library.CacheEnum.FormMonitor);
UserDao userdao = new UserDao(mapper);
RoleDao roledao = new RoleDao(mapper);
UserInfoDao uidao = new UserInfoDao(mapper);
LogonHistoryDao lhdao = new LogonHistoryDao(mapper);
var logonhistory = lhdao.Query(new LogonHistoryQueryForm { Token = token }).FirstOrDefault();
if (logonhistory == null) throw new Exception("获取当前用户信息时发生错误，用户不存在");
string userid = logonhistory.UserID;
var user = userdao.Query(new UserQueryForm { ID = userid }).FirstOrDefault();
var userinfo = uidao.Query(new UserInfoQueryForm { ID = userid }).FirstOrDefault();
var roles = roledao.QueryRoleByUserID(userid);
u = new UserEntireInfo
{
User = user,
Role = roles,
UserInfo = userinfo,
};
}
return u;
}
public string Add(Model.User user, UserInfo ui, List<string> roleidlist)
{
#region risk user
ISqlMapper mapper = Common.GetMapperFromSession();
if (user == null)
{
throw new Exception("user不能为null！");
}
UserDao dao = new UserDao(mapper);
var exist = dao.Query(new UserQueryForm { Name = user.Name });
if (exist.Count > 0) throw new Exception("已存在用户名：" + user.Name);
if (string.IsNullOrEmpty(ui.WX) && string.IsNullOrEmpty(ui.Mobile)) throw new Exception("微信号或者手机不能为空");
string id = dao.Add(user);
if (ui == null)
{
ui = new UserInfo();
}
UserInfoDao infodao = new UserInfoDao(mapper);
ui.ID = id;
infodao.Add(ui);
if (roleidlist == null) return id;
User_RoleDao urdao = new User_RoleDao(mapper);
foreach (var role in roleidlist)
{
User_Role ur = new User_Role { RoleID = role, UserID = user.ID };
urdao.Add(ur);
}
#endregion
#region weixin user
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();
try
{
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
enable = 1,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
}
catch (SOAFramework.Library.WeiXin.WeiXinException ex)
{
switch (ex.Code)
{
case "60004":
case "60003":
foreach (var role in roles)
{
//部门不存在就新建部门
Role parentrole = null;
if (!string.IsNullOrEmpty(role.ParentID)) roledao.Query(new RoleQueryForm { ID = role.ParentID }).FirstOrDefault();
var department = new SOAFramework.Library.WeiXin.Department
{
name = role.Name,
};
if (parentrole != null) department.parentid = parentrole.WeiXinID;
var response = SOAFramework.Library.WeiXin.WeiXinApi.Department.Create(department);
roledao.Update(new RoleUpdateForm
{
Entity = new Role { WeiXinID = response.id },
RoleQueryForm = new RoleQueryForm { ID = role.ID },
});
}
SOAFramework.Library.WeiXin.WeiXinApi.User.Create(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
enable = 1,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
break;
case "60102"://用户已存在
SOAFramework.Library.WeiXin.WeiXinApi.User.Update(new SOAFramework.Library.WeiXin.User
{
department = weixinids,
mobile = ui.Mobile,
name = ui.CnName,
weixinid = ui.WX,
userid = user.Name,
});
break;
default:
throw ex;
}
}
#endregion
return id;
}
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;
}
