/// <summary>
/// 发送即时通讯提醒
/// </summary>
/// <param name="id">主键</param>
/// <param name="auditStatus">审核状态</param>
/// <param name="auditIdea">审核意见</param>
/// <param name="userId">发送给用户主键</param>
/// <param name="roleId">发送给角色主键</param>
/// <returns>影响行数</returns>
public int SendRemindMessage(string id, AuditStatus auditStatus, string auditIdea, string[] userIds, string[] organizeIds, string[] roleIds)
{
int returnValue = 0;
// 发送请求审核的信息
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.Id = BaseBusinessLogic.NewGuid();
// 这里是回调的类，用反射要回调的
messageEntity.FunctionCode = this.GetType().ToString();
messageEntity.ObjectId = id;
// 这里是网页上的显示地址
// messageEntity.Title = this.GetUrl(id);
// messageEntity.Content = BaseBusinessLogic.GetAuditStatus(auditStatus) + "：" + this.GetEntity(id).Title + " 请查收"
// + Environment.NewLine
// + this.GetUrl(id)
// + auditIdea;
messageEntity.IsNew = 1;
messageEntity.ReadCount = 0;
messageEntity.Enabled = 1;
messageEntity.DeletionStateCode = 0;
BaseMessageManager messageManager = new BaseMessageManager(this.UserInfo);
returnValue = messageManager.BatchSend(userIds, organizeIds, roleIds, messageEntity, false);
return(returnValue);
}
public int SendGroupMessage(BaseUserInfo userInfo, string organizeId, string roleId, string contents)
{
int result = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
// 发给角色里所有的
BaseMessageEntity entity = new BaseMessageEntity();
//messageEntity.Id = Guid.NewGuid().ToString("N");
entity.CategoryCode = MessageCategory.Send.ToString();
if (!string.IsNullOrEmpty(organizeId))
{
entity.FunctionCode = MessageFunction.OrganizeMessage.ToString();
entity.ObjectId = organizeId;
}
if (!string.IsNullOrEmpty(roleId))
{
entity.FunctionCode = MessageFunction.RoleMessage.ToString();
entity.ObjectId = roleId;
}
entity.Contents = contents;
entity.IsNew = (int)MessageStateCode.New;
entity.ReadCount = 0;
entity.DeletionStateCode = 0;
var manager = new BaseMessageManager(dbHelper, userInfo);
manager.Identity = true;
result = manager.BatchSend(string.Empty, organizeId, roleId, entity, false);
});
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页显示</param>
/// <param name="whereClause">条件</param>
/// <param name="dbParameters">参数</param>
/// <param name="order">排序</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByPage(BaseUserInfo userInfo, out int recordCount, int pageIndex, int pageSize, string whereClause, List <KeyValuePair <string, object> > dbParameters, string order = null)
{
var result = new DataTable(BaseMessageEntity.TableName);
int myRecordCount = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
if (SecretUtil.IsSqlSafe(whereClause))
{
var messageManager = new BaseMessageManager(dbHelper, userInfo);
result = messageManager.GetDataTableByPage(out myRecordCount, pageIndex, pageSize, whereClause, dbHelper.MakeParameters(dbParameters), order);
result.TableName = BaseMessageEntity.TableName;
// FileUtil.WriteMessage("userInfo1:" + userInfo.Serialize() + " " + whereClause, "D:/Web/DotNet.CommonV4.2/DotNet.WCFService/Log/" + "SqlSafe" + DateTime.Now.ToString(BaseSystemInfo.DateFormat) + ".txt");
// FileUtil.WriteMessage("userInfo2:" + userInfo.Serialize() + " " + whereClause, System.Web.HttpContext.Current.Server.MapPath("~/Log/") + "SqlSafe" + DateTime.Now.ToString(BaseSystemInfo.DateFormat) + ".txt");
}
else
{
if (System.Web.HttpContext.Current != null)
{
// 记录注入日志
FileUtil.WriteMessage("userInfo:" + userInfo.Serialize() + " " + whereClause, System.Web.HttpContext.Current.Server.MapPath("~/Log/") + "SqlSafe" + DateTime.Now.ToString(BaseSystemInfo.DateFormat) + ".txt");
}
}
});
recordCount = myRecordCount;
return(result);
}
/// <summary>
/// 缓存预热,强制重新缓存
/// </summary>
/// <returns>影响行数</returns>
public static int CachePreheating()
{
int result = 0;
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseMessageEntity.FieldCategoryCode, MessageCategory.Receiver.ToString()));
parameters.Add(new KeyValuePair <string, object>(BaseMessageEntity.FieldIsNew, (int)MessageStateCode.New));
parameters.Add(new KeyValuePair <string, object>(BaseMessageEntity.FieldDeletionStateCode, 0));
// 2015-09-27 吉日嘎拉 把所有的未阅读的消息都缓存起来的代码。
BaseMessageManager manager = new BaseMessageManager();
using (IDataReader dataReader = manager.ExecuteReader(parameters, BaseMessageEntity.FieldCreateOn))
{
while (dataReader.Read())
{
BaseMessageEntity entity = BaseEntity.Create <BaseMessageEntity>(dataReader, false);
// 2015-09-30 吉日嘎拉 两个月以上的信息，意义不大了，可以考虑不缓存了
if (entity != null)
{
manager.CacheProcessing(entity);
result++;
// System.Console.WriteLine(result.ToString() + " : " + entity.Contents);
}
}
dataReader.Close();
}
return(result);
}
/// <summary>
/// 广播消息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="message">消息内容</param>
/// <returns>主键</returns>
public int Broadcast(BaseUserInfo userInfo, string message)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
int returnValue = 0;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
string[] receiverIds = null;
BaseUserManager userManager = new BaseUserManager(dbHelper, userInfo);
receiverIds = userManager.GetIds(new KeyValuePair <string, object>(BaseUserEntity.FieldEnabled, 1), new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.Id = BaseBusinessLogic.NewGuid();
messageEntity.FunctionCode = MessageFunction.Remind.ToString();
messageEntity.Contents = message;
messageEntity.IsNew = 1;
messageEntity.ReadCount = 0;
messageEntity.Enabled = 1;
messageEntity.DeletionStateCode = 0;
returnValue = messageManager.BatchSend(receiverIds, string.Empty, string.Empty, messageEntity, false);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.MessageService_BatchSend, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 获取用户的新信息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="openId">单点登录标识</param>
/// <returns>数据表</returns>
public DataTable GetDataTableNew(BaseUserInfo userInfo, out string openId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
openId = userInfo.OpenId;
DataTable dataTable = new DataTable(BaseMessageEntity.TableName);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
if (!BaseSystemInfo.CheckOnLine)
{
BaseUserManager userManager = new BaseUserManager(dbHelper, userInfo);
openId = userManager.GetProperty(userInfo.Id, BaseUserEntity.FieldOpenId);
}
if (userInfo.OpenId.Equals(openId))
{
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
dataTable = messageManager.GetDataTableNew();
dataTable.TableName = BaseMessageEntity.TableName;
}
// BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, "获取用户的新信息", MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(dataTable);
}
/// <summary>
/// 发送系统提示消息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="userId">接收者主键</param>
/// <param name="contents">内容</param>
/// <returns>主键</returns>
public string Remind(BaseUserInfo userInfo, string userId, string contents)
{
string result = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var manager = new BaseMessageManager(dbHelper, userInfo);
result = manager.Remind(userId, contents);
});
return(result);
}
/// <summary>
/// 发送系统提示消息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverId">接收者主键</param>
/// <param name="contents">内容</param>
/// <returns>主键</returns>
public string Remind(BaseUserInfo userInfo, string receiverId, string contents)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
string returnValue = string.Empty;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseMessageEntity entity = new BaseMessageEntity();
entity.Id = Guid.NewGuid().ToString();
entity.CategoryCode = MessageCategory.Receiver.ToString();
entity.FunctionCode = MessageFunction.Remind.ToString();
entity.ReceiverId = receiverId;
entity.Contents = contents;
entity.IsNew = (int)MessageStateCode.New;
entity.ReadCount = 0;
entity.DeletionStateCode = 0;
entity.Enabled = 1;
BaseMessageManager manager = new BaseMessageManager(dbHelper, userInfo);
returnValue = manager.Add(entity);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.MessageService_Send, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 广播消息
/// 2015-09-29 吉日嘎拉 改进发送消息功能
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="allcompany">是否发全公司</param>
/// <param name="roleIds">角色主键</param>
/// <param name="areaIds">区域主键</param>
/// <param name="companyIds">公司主键</param>
/// <param name="subCompany">发下属公司</param>
/// <param name="departmentIds">部门主键数组</param>
/// <param name="subDepartment">发下属部门</param>
/// <param name="userIds">用户主键数组</param>
/// <param name="message">消息内容</param>
/// <param name="onlineOnly">只发送给在线用户</param>
/// <returns>影响行数</returns>
public int Broadcast(BaseUserInfo userInfo, bool allcompany, string[] roleIds, string[] areaIds, string[] companyIds, bool subCompany, string[] departmentIds, bool subDepartment, string[] userIds, string message, bool onlineOnly)
{
int result = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var manager = new BaseMessageManager(userInfo);
result = manager.Broadcast(userInfo.SystemCode, allcompany, roleIds, areaIds, companyIds, subCompany, departmentIds, subDepartment, userIds, message, onlineOnly);
});
return(result);
}
public static string[] GetUserByOrganizeByCache(string companyId, string departmentId = null)
{
string[] result = null;
if (string.IsNullOrEmpty(companyId))
{
return(result);
}
string key = string.Empty;
string users = string.Empty;
if (string.IsNullOrEmpty(departmentId))
{
departmentId = string.Empty;
key = "OU:" + companyId;
}
else
{
key = "OU:" + companyId + ":" + departmentId;
}
using (var redisClient = PooledRedisHelper.GetReadOnlyClient())
{
users = redisClient.Get <string>(key);
if (!string.IsNullOrEmpty(users))
{
result = users.Split(',');
}
}
if (result == null)
{
BaseMessageManager manager = new BaseMessageManager();
result = manager.GetUserByOrganize(companyId, departmentId);
// 若是空的不用缓存，继续读取实体
if (result != null)
{
users = string.Join(",", result);
using (var redisClient = PooledRedisHelper.GetClient())
{
redisClient.Set <string>(key, users, DateTime.Now.AddDays(1));
}
}
}
return(result);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="userInfo">用户信息</param>
/// <param name="entity">用户实体</param>
/// <param name="userContactEntity">用户联系方式</param>
/// <param name="statusCode">状态码</param>
/// <param name="statusMessage">状态信息</param>
/// <returns>主键</returns>
public string CreateUser(IDbHelper dbHelper, BaseUserInfo userInfo, BaseUserEntity entity, BaseUserContactEntity userContactEntity, out string statusCode, out string statusMessage)
{
string result = string.Empty;
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
BaseSystemInfo.IsAuthorized(userInfo);
#endif
var userManager = new BaseUserManager(dbHelper, userInfo);
result = userManager.Add(entity);
statusCode = userManager.StatusCode;
statusMessage = userManager.GetStateMessage();
// 20140219 JiRiGaLa 添加成功的用户才增加联系方式
if (!string.IsNullOrEmpty(result) && statusCode.Equals(Status.OKAdd.ToString()) && userContactEntity != null)
{
// 添加联系方式
userContactEntity.Id = result;
var userContactManager = new BaseUserContactManager(dbHelper, userInfo);
userContactEntity.CompanyId = entity.CompanyId;
userContactManager.Add(userContactEntity);
}
// 自己不用给自己发提示信息，这个提示信息是为了提高工作效率的，还是需要审核通过的，否则垃圾信息太多了
if (entity.Enabled == 0 && statusCode.Equals(Status.OKAdd.ToString()))
{
// 不是系统管理员添加
if (!userInfo.IsAdministrator)
{
// 给超级管理员群组发信息
BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo);
string[] roleIds = roleManager.GetIds(new KeyValuePair <string, object>(BaseRoleEntity.FieldCode, "Administrators"));
string[] userIds = userManager.GetIds(new KeyValuePair <string, object>(BaseUserEntity.FieldCode, "Administrator"));
// 发送请求审核的信息
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.FunctionCode = MessageFunction.WaitForAudit.ToString();
// Pcsky 2012.05.04 显示申请的用户名
messageEntity.Contents = userInfo.RealName + "(" + userInfo.IPAddress + ")" + AppMessage.UserService_Application + entity.UserName + AppMessage.UserService_Check;
//messageEntity.Contents = result.RealName + "(" + result.IPAddress + ")" + AppMessage.UserService_Application + userEntity.RealName + AppMessage.UserService_Check;
var messageManager = new BaseMessageManager(dbHelper, userInfo);
messageManager.BatchSend(userIds, null, roleIds, messageEntity, false);
}
}
return(result);
}
/// <summary>
/// 获取特定用户的新信息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverId">当前交互的用户</param>
/// <returns>数据表</returns>
public DataTable ReadFromReceiver(BaseUserInfo userInfo, string receiverId)
{
var dt = new DataTable(BaseMessageEntity.TableName);
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var messageManager = new BaseMessageManager(dbHelper, userInfo);
dt = messageManager.ReadFromReceiver(receiverId);
dt.TableName = BaseMessageEntity.TableName;
});
return(dt);
}
/// <summary>
/// 批量发送站内信息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverIds">接受者主键数组</param>
/// <param name="ids">组织机构主键数组</param>
/// <param name="roleIds">角色主键数组</param>
/// <param name="messageEntity">消息内容</param>
/// <returns>影响行数</returns>
public int BatchSend(BaseUserInfo userInfo, string[] receiverIds, string[] organizeIds, string[] roleIds, BaseMessageEntity messageEntity)
{
int result = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var manager = new BaseMessageManager(dbHelper, userInfo);
//manager.Identity = false;
result = manager.BatchSend(receiverIds, organizeIds, roleIds, messageEntity, true);
});
return(result);
}
/// <summary>
/// 发送消息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverId">接收者主键</param>
/// <param name="contents">内容</param>
/// <param name="functionCode">内容</param>
/// <returns>主键</returns>
public string Send(BaseUserInfo userInfo, string receiverId, string contents, string functionCode)
{
string result = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var manager = new BaseMessageManager(dbHelper, userInfo);
BaseMessageEntity entity = manager.Send(receiverId, contents, functionCode);
result = entity.Id;
});
return(result);
}
/// <summary>
/// 按组织机构获取用户列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="companyId">组织机构主键</param>
/// <param name="departmentId">部门主键</param>
/// <returns>数据表</returns>
public string[] GetUserByOrganize(BaseUserInfo userInfo, string companyId, string departmentId = null)
{
string[] result = null;
//var parameter = ServiceParameter.CreateWithMessage(userInfo
// , MethodBase.GetCurrentMethod()
// , this.serviceName
// , AppMessage.MessageService_GetUserDTByDepartment);
//ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
//{
result = BaseMessageManager.GetUserByOrganizeByCache(companyId, departmentId);
//});
return(result);
}
/// <summary>
/// 阅读消息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="id">主键</param>
public int Read(BaseUserInfo userInfo, string id)
{
int result = 0;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessMessageDb(userInfo, parameter, (dbHelper) =>
{
var messageManager = new BaseMessageManager(dbHelper, userInfo);
if (messageManager.Read(id, true) != null)
{
result++;
}
});
return(result);
}
/// <summary>
/// 获取消息状态
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="onLineState">用户在线状态</param>
/// <param name="lastChekDate">最后检查日期</param>
/// <returns>消息状态数组</returns>
public string[] MessageChek(BaseUserInfo userInfo, int onLineState, string lastChekDate)
{
string[] result = null;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) =>
{
// 设置为在线状态
var userLogOnManager = new BaseUserLogOnManager(dbHelper, userInfo);
userLogOnManager.OnLine(userInfo.Id, onLineState);
// 读取信息状态
var messageManager = new BaseMessageManager(userInfo);
result = messageManager.MessageChek();
});
return(result);
}
/// <summary>
/// 获取消息状态
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="onLineState">用户在线状态</param>
/// <param name="lastChekDate">最后检查日期</param>
/// <returns>消息状态数组</returns>
public string[] MessageChek(BaseUserInfo userInfo, int onLineState, string lastChekDate)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
string[] returnValue = null;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
// 设置为在线状态
BaseUserManager userManager = new BaseUserManager(dbHelper, userInfo);
userManager.OnLine(userInfo.Id, onLineState);
// 读取信息状态
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
returnValue = messageManager.MessageChek();
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.MessageService_MessageChek, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 发送即时通讯提醒
/// </summary>
/// <param name="workFlowCurrentEntity">当前审核流实体信息</param>
/// <param name="auditStatus">审核状态</param>
/// <param name="auditIdea">审核意见</param>
/// <param name="userIds">发送给用户主键</param>
/// <param name="roleIds">发送给角色主键</param>
/// <returns>影响行数</returns>
public virtual int SendRemindMessage(BaseWorkFlowCurrentEntity workFlowCurrentEntity, AuditStatus auditStatus, string[] userIds, string organizeId, string roleId)
{
// string currentId, string objectId, string objectFullName
int returnValue = 0;
// 不用给自己发消息了，消息多了也烦恼
userIds = StringUtil.Remove(userIds, this.UserInfo.Id);
// BaseUserEntity userEntity = userManager.GetEntity(userId);
// 发送请求审核的信息
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.Id = BaseBusinessLogic.NewGuid();
// 这里是回调的类，用反射要回调的
messageEntity.FunctionCode = MessageFunction.Remind.ToString();
// messageEntity.FunctionCode = this.GetType().ToString();
messageEntity.ObjectId = workFlowCurrentEntity.ObjectId;
// 这里是网页上的显示地址
// messageEntity.Title = this.GetUrl(id);
string auditIdea = string.Empty;
if (!string.IsNullOrEmpty(workFlowCurrentEntity.AuditIdea))
{
auditIdea = " 批示: " + workFlowCurrentEntity.AuditIdea;
}
// messageEntity.Contents = userEntity.DepartmentName + " " + userEntity.RealName
messageEntity.Contents
= workFlowCurrentEntity.CreateBy + " 发出审批申请： " + "<a title='点击这里，直接查看单据' target='_blank' href='" + this.GetUrl(workFlowCurrentEntity.Id) + "'>" + workFlowCurrentEntity.ObjectFullName + "</a> "
+ Environment.NewLine
+ this.UserInfo.RealName + " " + BaseBusinessLogic.GetAuditStatus(auditStatus) + " "
+ Environment.NewLine
+ auditIdea;
messageEntity.Contents = "有单据" + BaseBusinessLogic.GetAuditStatus(auditStatus);
messageEntity.IsNew = 1;
messageEntity.ReadCount = 0;
messageEntity.Enabled = 1;
messageEntity.DeletionStateCode = 0;
BaseMessageManager messageManager = new BaseMessageManager(this.UserInfo);
returnValue = messageManager.BatchSend(userIds, organizeId, roleId, messageEntity, false);
return(returnValue);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="userInfo">用户信息</param>
/// <param name="userEntity">用户实体</param>
/// <param name="statusCode">状态码</param>
/// <param name="statusMessage">状态信息</param>
/// <returns>主键</returns>
public string AddUser(IDbHelper dbHelper, BaseUserInfo userInfo, BaseUserEntity userEntity, out string statusCode, out string statusMessage)
{
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
BaseSystemInfo.IsAuthorized(userInfo);
#endif
string returnValue = string.Empty;
BaseUserManager userManager = new BaseUserManager(dbHelper, userInfo);
// 若是系统需要用加密的密码，这里需要加密密码。
if (BaseSystemInfo.ServerEncryptPassword)
{
userEntity.UserPassword = userManager.EncryptUserPassword(userEntity.UserPassword);
// 安全通讯密码、交易密码也生成好
userEntity.CommunicationPassword = userManager.EncryptUserPassword(userEntity.CommunicationPassword);
}
returnValue = userManager.Add(userEntity, out statusCode);
statusMessage = userManager.GetStateMessage(statusCode);
// 自己不用给自己发提示信息，这个提示信息是为了提高工作效率的，还是需要审核通过的，否则垃圾信息太多了
if (userEntity.Enabled == 0 && statusCode.Equals(StatusCode.OKAdd.ToString()))
{
// 不是系统管理员添加
if (!userInfo.IsAdministrator)
{
// 给超级管理员群组发信息
BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo);
string[] roleIds = roleManager.GetIds(new KeyValuePair <string, object>(BaseRoleEntity.FieldCode, "Administrators"));
string[] userIds = userManager.GetIds(new KeyValuePair <string, object>(BaseUserEntity.FieldCode, "Administrator"));
// 发送请求审核的信息
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.FunctionCode = MessageFunction.WaitForAudit.ToString();
// Pcsky 2012.05.04 显示申请的用户名
messageEntity.Contents = userInfo.RealName + "(" + userInfo.IPAddress + ")" + AppMessage.UserService_Application + userEntity.UserName + AppMessage.UserService_Check;
//messageEntity.Contents = userInfo.RealName + "(" + userInfo.IPAddress + ")" + AppMessage.UserService_Application + userEntity.RealName + AppMessage.UserService_Check;
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
messageManager.BatchSend(userIds, null, roleIds, messageEntity, false);
}
}
return(returnValue);
}
/// <summary>
/// 获取特定用户的新信息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverId">当前交互的用户</param>
/// <returns>数据表</returns>
public DataTable ReadFromReceiver(BaseUserInfo userInfo, string receiverId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = new DataTable(BaseMessageEntity.TableName);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
dataTable = messageManager.ReadFromReceiver(receiverId);
dataTable.TableName = BaseMessageEntity.TableName;
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.MessageService_ReadFromReceiver, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(dataTable);
}
/// <summary>
/// 批量发送站内信息
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="receiverIds">接受者主键数组</param>
/// <param name="organizeIds">组织机构主键数组</param>
/// <param name="roleIds">角色主键数组</param>
/// <param name="messageEntity">消息内容</param>
/// <returns>影响行数</returns>
public int BatchSend(BaseUserInfo userInfo, string[] receiverIds, string[] organizeIds, string[] roleIds, BaseMessageEntity messageEntity)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
int returnValue = 0;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
returnValue = messageManager.BatchSend(receiverIds, organizeIds, roleIds, messageEntity, true);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.MessageService_BatchSend, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 发送文件
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="fileName">文件名</param>
/// <param name="file">文件内容</param>
/// <param name="toUserId">发送给谁主键</param>
/// <returns>文件主键</returns>
public string Send(BaseUserInfo userInfo, string fileName, byte[] file, string toUserId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
string returnValue = string.Empty;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseFolderEntity folderEntity = new BaseFolderEntity();
BaseFolderManager folderManager = new BaseFolderManager(dbHelper, userInfo);
// 检查相应的系统必备文件夹
folderManager.FolderCheck();
BaseUserEntity userEntity = new BaseUserManager(dbHelper, userInfo).GetEntity(toUserId);
if (!string.IsNullOrEmpty(userEntity.Id))
{
// 04:判断发送者的空间是否存在？
// 05:判断已收文件夹是否存在？
if (!folderManager.Exists(userEntity.Id.ToString()))
{
folderEntity.FolderName = userEntity.RealName + AppMessage.FileService_File;
folderEntity.ParentId = "UserSpace";
folderEntity.Id = userEntity.Id.ToString();
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddEntity(folderEntity);
}
// 06:判断来自谁的文件夹是否存在？
// 07:判断发给谁的文件夹是否存在？
if (!folderManager.Exists(toUserId + "_Receive"))
{
folderEntity.FolderName = AppMessage.FileService_ReceiveFile;
folderEntity.ParentId = toUserId;
folderEntity.Id = toUserId + "_Receive";
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddEntity(folderEntity);
}
if (!folderManager.Exists(userInfo.Id + "_Send_" + toUserId))
{
folderEntity.FolderName = userEntity.RealName + "(" + userEntity.UserName + ")";
folderEntity.ParentId = userInfo.Id + "_Send";
folderEntity.Id = userInfo.Id + "_Send_" + toUserId;
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddEntity(folderEntity);
}
if (!folderManager.Exists(toUserId + "_Receive_" + userInfo.Id))
{
folderEntity.FolderName = userInfo.RealName + "(" + userInfo.UserName + ")";
folderEntity.ParentId = toUserId + "_Receive";
folderEntity.Id = toUserId + "_Receive_" + userInfo.Id;
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddEntity(folderEntity);
}
// 08:已发送文件夹多一个文件。
// 09:已接收文件夹多一个文件。
BaseFileEntity fileEntity = new BaseFileEntity();
fileEntity.FileName = fileName;
fileEntity.Contents = file;
fileEntity.Enabled = 1;
fileEntity.ReadCount = 0;
fileEntity.FolderId = userInfo.Id + "_Send_" + toUserId;
// 把修改人显示出来
fileEntity.ModifiedBy = userInfo.RealName;
fileEntity.ModifiedUserId = userInfo.Id;
fileEntity.ModifiedOn = DateTime.Now;
BaseFileManager fileManager = new BaseFileManager(dbHelper, userInfo);
fileManager.AddEntity(fileEntity);
fileEntity.FolderId = toUserId + "_Receive_" + userInfo.Id;
returnValue = fileManager.AddEntity(fileEntity);
// string webHostUrl = BaseSystemInfo.WebHostUrl;
// if (string.IsNullOrEmpty(webHostUrl))
// {
// webHostUrl = "WebHostUrl";
// }
// 10:应该还发一个短信提醒一下才对。
BaseMessageEntity messageEntity = new BaseMessageEntity();
messageEntity.Id = Guid.NewGuid().ToString();
messageEntity.CategoryCode = MessageCategory.Send.ToString();
messageEntity.FunctionCode = MessageFunction.Message.ToString();
messageEntity.ObjectId = returnValue;
messageEntity.ReceiverId = toUserId;
// target=\"_blank\"
messageEntity.Contents = AppMessage.FileService_SendFileFrom + " <a href={WebHostUrl}Download.aspx?Id=" + returnValue + ">" + fileName + "</a>" + AppMessage.FileService_CheckReceiveFile;
messageEntity.IsNew = (int)MessageStateCode.New;
messageEntity.ReadCount = 0;
messageEntity.DeletionStateCode = 0;
messageEntity.Enabled = 1;
BaseMessageManager messageManager = new BaseMessageManager(dbHelper, userInfo);
returnValue = messageManager.Add(messageEntity);
}
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 发送文件
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="fileName">文件名</param>
/// <param name="file">文件内容</param>
/// <param name="toUserId">发送给谁主键</param>
/// <returns>文件主键</returns>
public string Send(BaseUserInfo userInfo, string fileName, byte[] file, string toUserId)
{
string result = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) =>
{
BaseFolderEntity folderEntity = new BaseFolderEntity();
var folderManager = new BaseFolderManager(dbHelper, userInfo);
// 检查相应的系统必备文件夹
folderManager.FolderCheck();
BaseUserEntity userEntity = new BaseUserManager(dbHelper, userInfo).GetObject(toUserId);
if (!string.IsNullOrEmpty(userEntity.Id))
{
// 04:判断发送者的空间是否存在？
// 05:判断已收文件夹是否存在？
if (!folderManager.Exists(userEntity.Id))
{
folderEntity.FolderName = userEntity.RealName + AppMessage.FileService_File;
folderEntity.ParentId = "UserSpace";
folderEntity.Id = userEntity.Id;
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddObject(folderEntity);
}
// 06:判断来自谁的文件夹是否存在？
// 07:判断发给谁的文件夹是否存在？
if (!folderManager.Exists(toUserId + "_Receive"))
{
folderEntity.FolderName = AppMessage.FileService_ReceiveFile;
folderEntity.ParentId = toUserId;
folderEntity.Id = toUserId + "_Receive";
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddObject(folderEntity);
}
if (!folderManager.Exists(userInfo.Id + "_Send_" + toUserId))
{
folderEntity.FolderName = userEntity.RealName + "(" + userEntity.UserName + ")";
folderEntity.ParentId = userInfo.Id + "_Send";
folderEntity.Id = userInfo.Id + "_Send_" + toUserId;
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddObject(folderEntity);
}
if (!folderManager.Exists(toUserId + "_Receive_" + userInfo.Id))
{
folderEntity.FolderName = userInfo.RealName + "(" + userInfo.UserName + ")";
folderEntity.ParentId = toUserId + "_Receive";
folderEntity.Id = toUserId + "_Receive_" + userInfo.Id;
folderEntity.Enabled = 1;
folderEntity.DeletionStateCode = 0;
folderManager.AddObject(folderEntity);
}
// 08:已发送文件夹多一个文件。
// 09:已接收文件夹多一个文件。
BaseFileEntity fileEntity = new BaseFileEntity();
fileEntity.FileName = fileName;
fileEntity.Contents = file;
fileEntity.Enabled = 1;
fileEntity.ReadCount = 0;
fileEntity.FolderId = userInfo.Id + "_Send_" + toUserId;
// 把修改人显示出来
fileEntity.ModifiedBy = userInfo.RealName;
fileEntity.ModifiedUserId = userInfo.Id;
fileEntity.ModifiedOn = DateTime.Now;
var fileManager = new BaseFileManager(dbHelper, userInfo);
fileManager.AddObject(fileEntity);
fileEntity.FolderId = toUserId + "_Receive_" + userInfo.Id;
result = fileManager.AddObject(fileEntity);
// string webHostUrl = BaseSystemInfo.WebHost;
// if (string.IsNullOrEmpty(webHostUrl))
// {
// webHostUrl = "WebHostUrl";
// }
// 10:应该还发一个短信提醒一下才对。
BaseMessageEntity messageEntity = new BaseMessageEntity();
//messageEntity.Id = Guid.NewGuid().ToString("N");
messageEntity.CategoryCode = MessageCategory.Send.ToString();
messageEntity.FunctionCode = MessageFunction.Message.ToString();
messageEntity.ObjectId = result;
messageEntity.ReceiverId = toUserId;
// target=\"_blank\"
messageEntity.Contents = AppMessage.FileService_SendFileFrom + " <a href={WebHostUrl}Download.aspx?Id=" + result + ">" + fileName + "</a>" + AppMessage.FileService_CheckReceiveFile;
messageEntity.IsNew = (int)MessageStateCode.New;
messageEntity.ReadCount = 0;
messageEntity.DeletionStateCode = 0;
var messageManager = new BaseMessageManager(dbHelper, userInfo);
messageManager.Identity = true;
result = messageManager.Add(messageEntity);
}
});
return(result);
}
/// <summary>
/// 发送即时通讯提醒
/// </summary>
/// <param name="workFlowCurrentEntity">当前审核流实体信息</param>
/// <param name="auditStatus">审核状态</param>
/// <param name="auditIdea">审核意见</param>
/// <param name="userIds">发送给用户主键</param>
/// <param name="roleIds">发送给角色主键</param>
/// <returns>影响行数</returns>
public virtual int SendMessage(BaseWorkFlowCurrentEntity workFlowCurrentEntity, AuditStatus auditStatus, string[] userIds, string organizeId, string roleId)
{
// 这里是考虑了，同时发给多个人的情况
List <string> userList = new List <string>();
foreach (var userid in userIds)
{
if (!string.IsNullOrEmpty(userid))
{
if (userid.IndexOf(',') > 0)
{
string[] users = userid.Split(',').Distinct <string>().Where(t => !string.IsNullOrEmpty(t)).ToArray();
foreach (var id in users)
{
if (!string.IsNullOrEmpty(id))
{
userList.Add(id);
}
}
}
else
{
userList.Add(userid);
}
}
}
userIds = userList.ToArray();
// string currentId, string objectId, string objectFullName
int result = 0;
// 不用给自己发消息了，消息多了也烦恼
userIds = StringUtil.Remove(userIds, this.UserInfo.Id);
// BaseUserEntity userEntity = userManager.GetObject(userId);
// 发送请求审核的信息
BaseMessageEntity messageEntity = new BaseMessageEntity();
//messageEntity.Id = BaseBusinessLogic.NewGuid();
// 这里是回调的类，用反射要回调的
messageEntity.FunctionCode = MessageFunction.Remind.ToString();
// messageEntity.FunctionCode = this.GetType().ToString();
messageEntity.ObjectId = workFlowCurrentEntity.ObjectId;
// 这里是网页上的显示地址
// messageEntity.Title = this.GetUrl(id);
string auditIdea = string.Empty;
if (!string.IsNullOrEmpty(workFlowCurrentEntity.AuditIdea))
{
auditIdea = " 批示: " + workFlowCurrentEntity.AuditIdea;
}
// messageEntity.Contents = userEntity.DepartmentName + " " + userEntity.RealName
if (!BaseSystemInfo.SimpleReminders)
{
messageEntity.Contents
= workFlowCurrentEntity.CreateBy + " 发出审批申请： " + "<a title='点击这里，直接查看单据' target='_blank' href='" + this.GetUrl(workFlowCurrentEntity.Id) + "'>" + workFlowCurrentEntity.ObjectFullName + "</a> "
+ Environment.NewLine
+ this.UserInfo.RealName + " " + BaseBusinessLogic.GetAuditStatus(auditStatus) + " "
+ Environment.NewLine
+ auditIdea;
}
else
{
messageEntity.Contents = "有单据" + BaseBusinessLogic.GetAuditStatus(auditStatus);
}
messageEntity.IsNew = 1;
messageEntity.ReadCount = 0;
messageEntity.DeletionStateCode = 0;
BaseMessageManager messageManager = new BaseMessageManager(this.UserInfo);
messageManager.Identity = true;
result = messageManager.BatchSend(userIds, organizeId, roleId, messageEntity, false);
return(result);
}
