/// <summary>
/// 缓存预热,强制重新缓存
/// </summary>
/// <returns>影响行数</returns>
public static int CachePreheating()
{
int result = 0;
// 把所有的数据都缓存起来的代码
BaseUserManager manager = new BaseUserManager();
using (IDataReader dataReader = manager.ExecuteReader(0, BaseUserEntity.FieldId))
{
while (dataReader.Read())
{
BaseUserEntity entity = BaseEntity.Create <BaseUserEntity>(dataReader, false);
BaseUserManager.SetCache(entity);
result++;
}
dataReader.Close();
}
return(result);
}
/// <summary>
/// 缓存预热,强制重新缓存
/// </summary>
/// <returns>影响行数</returns>
public static int CachePreheating()
{
var result = 0;
// 把所有的数据都缓存起来的代码
var manager = new BaseUserManager();
var dataReader = manager.ExecuteReader(0, BaseUserEntity.FieldId);
if (dataReader != null && !dataReader.IsClosed)
{
while (dataReader.Read())
{
var entity = BaseEntity.Create <BaseUserEntity>(dataReader, false);
SetCache(entity);
result++;
}
dataReader.Close();
}
return(result);
}
public int BroadcastProcess(string systemCode, bool allcompany, string[] roleIds, string[] areaIds, string[] companyIds, bool subCompany, string[] departmentIds, bool subDepartment, string[] userIds, string message, bool onlineOnly, MessageFunction functionCode = MessageFunction.SystemPush, DateTime?expireAt = null)
{
int result = 0;
// 1: 这里需要生成一个sql语句。
// 2: 只发给中天客户端，中天客户端有登录过的用户？
// 3: 一边读取一边执行发送指令，马上能见效。
// 4: 节约数据库资源，节约服务器资源。
// 5: 广播提醒，过期时间1周就可以了，太时间了，浪费内存资源。
// 2015-09-29 吉日嘎拉 从最高到最低的顺序判断
string commandText = " SELECT " + BaseUserEntity.FieldId
+ " FROM " + BaseUserEntity.TableName
+ " WHERE " + BaseUserEntity.FieldEnabled + " = 1 "
+ " AND " + BaseUserEntity.FieldDeletionStateCode + " = 0 "
+ " AND " + BaseUserEntity.FieldUserFrom + " = 'Base' ";
if (allcompany)
{
// 什么都不过滤
}
if (areaIds != null)
{
// 这个需要进行叠加处理
commandText += " AND " + BaseUserEntity.FieldCompanyId + " IN ( "
+ " SELECT " + BaseOrganizeEntity.FieldId
+ " FROM " + BaseOrganizeEntity.TableName
+ " WHERE " + BaseOrganizeEntity.FieldEnabled + " = 1 "
+ " AND " + BaseOrganizeEntity.FieldDeletionStateCode + " = 0 "
+ " AND (" + BaseOrganizeEntity.FieldProvinceId + " IN (" + StringUtil.ArrayToList(areaIds) + ")"
+ " OR " + BaseOrganizeEntity.FieldCityId + " IN (" + StringUtil.ArrayToList(areaIds) + ")"
+ " OR " + BaseOrganizeEntity.FieldStreetId + " IN (" + StringUtil.ArrayToList(areaIds) + ")"
+ " OR " + BaseOrganizeEntity.FieldDistrictId + " IN (" + StringUtil.ArrayToList(areaIds) + ")) )";
}
if (subCompany)
{
commandText += " AND " + BaseUserEntity.FieldCompanyId + " IN ( "
+ " SELECT " + BaseOrganizeEntity.FieldId
+ " FROM " + BaseOrganizeEntity.TableName
+ " WHERE " + BaseOrganizeEntity.FieldEnabled + " = 1 "
+ "AND " + BaseOrganizeEntity.FieldDeletionStateCode + " = 0 "
+ "AND " + BaseOrganizeEntity.FieldId + " IN (" + StringUtil.ArrayToList(companyIds) + ") UNION "
+ " SELECT " + BaseOrganizeEntity.FieldId
+ " FROM " + BaseOrganizeEntity.TableName
+ " WHERE " + BaseOrganizeEntity.FieldEnabled + " = 1 "
+ "AND " + BaseOrganizeEntity.FieldDeletionStateCode + " = 0 "
+ " START WITH " + BaseOrganizeEntity.FieldParentId + " IN (" + StringUtil.ArrayToList(companyIds) + ") "
+ " CONNECT BY PRIOR " + BaseOrganizeEntity.FieldId + " = " + BaseOrganizeEntity.FieldParentId + ")";
}
if (companyIds != null && companyIds.Length > 0)
{
commandText += " AND " + BaseUserEntity.FieldCompanyId + " IN (" + StringUtil.ArrayToList(companyIds) + ")";
}
if (subDepartment)
{
commandText += " AND " + BaseUserEntity.FieldDepartmentId + " IN ( "
+ " SELECT " + BaseDepartmentEntity.FieldId
+ " FROM " + BaseDepartmentEntity.TableName
+ " WHERE " + BaseDepartmentEntity.FieldEnabled + " = 1 "
+ " AND " + BaseDepartmentEntity.FieldDeletionStateCode + " = 0 "
+ " AND " + BaseOrganizeEntity.FieldDeletionStateCode + " = 0 "
+ "AND " + BaseDepartmentEntity.FieldId + " IN (" + StringUtil.ArrayToList(departmentIds) + ") UNION "
+ " SELECT " + BaseDepartmentEntity.FieldId
+ " FROM " + BaseDepartmentEntity.TableName
+ " WHERE " + BaseDepartmentEntity.FieldEnabled + " = 1 "
+ " AND " + BaseDepartmentEntity.FieldDeletionStateCode + " = 0 "
+ " AND " + BaseOrganizeEntity.FieldDeletionStateCode + " = 0 "
+ " START WITH " + BaseDepartmentEntity.FieldParentId + " IN (" + StringUtil.ArrayToList(departmentIds) + ") "
+ " CONNECT BY PRIOR " + BaseDepartmentEntity.FieldId + " = " + BaseDepartmentEntity.FieldParentId + ") ";
}
if (departmentIds != null && departmentIds.Length > 0)
{
commandText += " AND " + BaseUserEntity.FieldDepartmentId + " IN (" + StringUtil.ArrayToList(departmentIds) + ")";
}
if (roleIds != null && roleIds.Length > 0)
{
string tableName = systemCode + "UserRole";
commandText += " AND " + BaseUserEntity.FieldId + " IN ( SELECT UserId FROM " + tableName + " WHERE RoleId IN (" + StringUtil.ArrayToList(roleIds) + "))";
}
if (userIds != null && userIds.Length > 0)
{
commandText += " AND " + BaseUserEntity.FieldId + " IN (" + StringUtil.ArrayToList(userIds) + ")";
}
using (var redisClient = PooledRedisHelper.GetMessageClient())
{
var userManager = new BaseUserManager(this.UserInfo);
using (IDataReader dataReader = userManager.ExecuteReader(commandText))
{
while (dataReader.Read())
{
string[] receiverIds = new string[] { dataReader[BaseUserEntity.FieldId].ToString() };
BaseMessageEntity entity = new BaseMessageEntity();
// entity.Id = BaseBusinessLogic.NewGuid();
entity.FunctionCode = functionCode.ToString();
// entity.FunctionCode = MessageFunction.SystemPush.ToString();
// entity.FunctionCode = MessageFunction.Remind.ToString();
entity.Contents = message;
entity.CreateCompanyId = this.UserInfo.CompanyId;
entity.CreateCompanyName = this.UserInfo.CompanyName;
entity.CreateDepartmentId = this.UserInfo.DepartmentId;
entity.CreateDepartmentName = this.UserInfo.DepartmentName;
entity.CreateUserId = this.UserInfo.Id;
entity.CreateBy = this.UserInfo.RealName;
entity.IPAddress = this.UserInfo.IPAddress;
entity.CreateOn = DateTime.Now;
entity.IsNew = 1;
entity.ReadCount = 0;
entity.DeletionStateCode = 0;
if (!expireAt.HasValue)
{
expireAt = DateTime.Now.AddDays(5);
}
result = Send(redisClient, entity, receiverIds, false, expireAt);
}
}
}
return(result);
}
