public async Task <SMessageTypeListener> QueryByTypeRelation(Guid typeId, Guid id)
{
SMessageTypeListener listener = null;
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _messageQueueConnectionFactory.CreateReadForMessageQueueMain(), async (conn, transaction) =>
{
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
Transaction = sqlTran,
CommandText = string.Format(@"select {0},{1} from SMessageTypeListener as listener join SMessageExecuteType as mtype on listener.messagetypeid=mtype.id where listener.[id]=@id and mtype.[id]=@typeid", StoreHelper.GetSMessageTypeListenerSelectFields("listener"), StoreHelper.GetSMessageExecuteTypeSelectFields("mtype"))
})
{
var parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
{
Value = id
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@typeid", SqlDbType.UniqueIdentifier)
{
Value = typeId
};
commond.Parameters.Add(parameter);
await commond.PrepareAsync();
SqlDataReader reader = null;
await using (reader = await commond.ExecuteReaderAsync())
{
if (await reader.ReadAsync())
{
listener = new SMessageTypeListener();
StoreHelper.SetSMessageTypeListenerSelectFields(listener, reader, "listener");
listener.MessageType = new SMessageExecuteType();
StoreHelper.SetSMessageExecuteTypeSelectFields(listener.MessageType, reader, "mtype");
}
await reader.CloseAsync();
}
}
});
return(listener);
}
/// <summary>
/// 为消息执行类型监听从DbDataReader中赋值
/// </summary>
/// <param name="listener"></param>
/// <param name="reader"></param>
/// <param name="prefix"></param>
public static void SetSMessageTypeListenerSelectFields(SMessageTypeListener listener, DbDataReader reader, string prefix)
{
listener.ID = (Guid)reader[string.Format("{0}id", prefix)];
if (reader[string.Format("{0}name", prefix)] != DBNull.Value)
{
listener.Name = reader[string.Format("{0}name", prefix)].ToString();
}
if (reader[string.Format("{0}queuegroupname", prefix)] != DBNull.Value)
{
listener.QueueGroupName = reader[string.Format("{0}queuegroupname", prefix)].ToString();
}
if (reader[string.Format("{0}mode", prefix)] != DBNull.Value)
{
listener.Mode = (int)reader[string.Format("{0}mode", prefix)];
}
if (reader[string.Format("{0}listenerfactorytype", prefix)] != DBNull.Value)
{
listener.ListenerFactoryType = reader[string.Format("{0}listenerfactorytype", prefix)].ToString();
}
if (reader[string.Format("{0}listenerfactorytypeusedi", prefix)] != DBNull.Value)
{
listener.ListenerFactoryTypeUseDI = (bool)reader[string.Format("{0}listenerfactorytypeusedi", prefix)];
}
if (reader[string.Format("{0}listenerweburl", prefix)] != DBNull.Value)
{
listener.ListenerWebUrl = reader[string.Format("{0}listenerweburl", prefix)].ToString();
}
if (reader[string.Format("{0}listenerwebsignature", prefix)] != DBNull.Value)
{
listener.ListenerWebSignature = reader[string.Format("{0}listenerwebsignature", prefix)].ToString();
}
if (reader[string.Format("{0}createtime", prefix)] != DBNull.Value)
{
listener.CreateTime = (DateTime)reader[string.Format("{0}createtime", prefix)];
}
if (reader[string.Format("{0}modifytime", prefix)] != DBNull.Value)
{
listener.ModifyTime = (DateTime)reader[string.Format("{0}modifytime", prefix)];
}
}
public ISMessageTypeListenerPostContext Create(SMessageTypeListener listener, SMessage message, Exception executeException, Dictionary <string, object> parameters)
{
SMessageTypeListenerPostContext context = new SMessageTypeListenerPostContext()
{
MessageId = message.ID,
MessageKey = message.Key,
MessageType = message.Type,
MessageData = message.Data,
ExecuteException = executeException,
ListenerId = listener.ID,
ListenerName = listener.Name
};
return(context);
}
public async Task UpdateByTypeRelation(SMessageTypeListener listener)
{
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _messageQueueConnectionFactory.CreateAllForMessageQueueMain(), async (conn, transaction) =>
{
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
Transaction = sqlTran,
CommandText = @"update SMessageTypeListener set [name]=@name,[mode]=@mode,[listenerfactorytype]=@listenerfactorytype,[listenerfactorytypeusedi]=@listenerfactorytypeusedi,[listenerweburl]=@listenerweburl,[listenerwebsignature]=@listenerwebsignature where [id]=@id and messagetypeid=@messagetypeid"
})
{
var parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
{
Value = listener.ID
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@messagetypeid", SqlDbType.UniqueIdentifier)
{
Value = listener.MessageType.ID
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@name", SqlDbType.VarChar, 150)
{
Value = listener.Name
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@mode", SqlDbType.Int)
{
Value = listener.Mode
};
commond.Parameters.Add(parameter);
if (listener.ListenerFactoryType != null)
{
parameter = new SqlParameter("@listenerfactorytype", SqlDbType.VarChar, 150)
{
Value = listener.ListenerFactoryType
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerfactorytype", SqlDbType.VarChar, 150)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerFactoryTypeUseDI != null)
{
parameter = new SqlParameter("@listenerfactorytypeusedi", SqlDbType.Bit)
{
Value = listener.ListenerFactoryTypeUseDI
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerfactorytypeusedi", SqlDbType.Bit)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerWebUrl != null)
{
parameter = new SqlParameter("@listenerweburl", SqlDbType.VarChar, 200)
{
Value = listener.ListenerWebUrl
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerweburl", SqlDbType.VarChar, 200)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerWebSignature != null)
{
parameter = new SqlParameter("@listenerwebsignature", SqlDbType.VarChar, 150)
{
Value = listener.ListenerWebSignature
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerwebsignature", SqlDbType.VarChar, 150)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
await commond.PrepareAsync();
await commond.ExecuteNonQueryAsync();
}
});
}
public async Task <QueryResult <SMessageTypeListener> > QueryByType(Guid typeId, int page, int pageSize)
{
QueryResult <SMessageTypeListener> result = new QueryResult <SMessageTypeListener>();
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _messageQueueConnectionFactory.CreateReadForMessageQueueMain(), async (conn, transaction) =>
{
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
Transaction = sqlTran,
CommandText = string.Format(@"set @currentpage=@page
select @count= count(*) from SMessageTypeListener where messagetypeid=@typeid
if @pagesize*@page>=@count
begin
set @currentpage= @count/@pagesize
if @count%@pagesize<>0
begin
set @currentpage=@currentpage+1
end
if @currentpage=0
set @currentpage=1
end
else if @page<1
begin
set @currentpage=1
end
select {0},{1} from SMessageTypeListener as listener join SMessageExecuteType as mtype where listener.messagetypeid=@typeid
order by listener.[sequence]
offset (@pagesize * (@currentpage - 1)) rows
fetch next @pagesize rows only;" , StoreHelper.GetSMessageTypeListenerSelectFields("listener"), StoreHelper.GetSMessageExecuteTypeSelectFields("mtype"))
})
{
var parameter = new SqlParameter("@page", SqlDbType.Int)
{
Value = page
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@pagesize", SqlDbType.Int)
{
Value = pageSize
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@typeid", SqlDbType.UniqueIdentifier)
{
Value = typeId
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@count", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@currentpage", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
commond.Parameters.Add(parameter);
await commond.PrepareAsync();
SqlDataReader reader = null;
await using (reader = await commond.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
var listener = new SMessageTypeListener();
StoreHelper.SetSMessageTypeListenerSelectFields(listener, reader, "listener");
listener.MessageType = new SMessageExecuteType();
StoreHelper.SetSMessageExecuteTypeSelectFields(listener.MessageType, reader, "mtype");
result.Results.Add(listener);
}
await reader.CloseAsync();
result.TotalCount = (int)commond.Parameters["@count"].Value;
result.CurrentPage = (int)commond.Parameters["@currentpage"].Value;
}
}
});
return(result);
}
public async Task QueryByType(Guid typeId, Func <SMessageTypeListener, Task> callback)
{
List <SMessageTypeListener> listenerList = new List <SMessageTypeListener>();
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, true, false, _messageQueueConnectionFactory.CreateReadForMessageQueueMain(), async (conn, transaction) =>
{
Int64?sequence = null;
int pageSize = 500;
while (true)
{
listenerList.Clear();
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
Transaction = sqlTran
})
{
if (!sequence.HasValue)
{
commond.CommandText = string.Format(@"select top (@pagesize) {0},{1} from SMessageTypeListener as listener join SMessageExecuteType as mtype on listener.messagetypeid=mtype.id where mtype.id=@typeid order by listener.[sequence]", StoreHelper.GetSMessageTypeListenerSelectFields("listener"), StoreHelper.GetSMessageExecuteTypeSelectFields("mtype"));
}
else
{
commond.CommandText = string.Format(@"select top (@pagesize) {0},{1} from SMessageTypeListener as listener join SMessageExecuteType as mtype on listener.messagetypeid=mtype.id where mtype.id=@typeid and listener.[sequence]>@sequence order by listener.[sequence]", StoreHelper.GetSMessageTypeListenerSelectFields("listener"), StoreHelper.GetSMessageExecuteTypeSelectFields("mtype"));
}
var parameter = new SqlParameter("@typeid", SqlDbType.UniqueIdentifier)
{
Value = typeId
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@pagesize", SqlDbType.Int)
{
Value = pageSize
};
commond.Parameters.Add(parameter);
if (sequence.HasValue)
{
parameter = new SqlParameter("@sequence", SqlDbType.BigInt)
{
Value = sequence
};
commond.Parameters.Add(parameter);
}
await commond.PrepareAsync();
SqlDataReader reader = null;
await using (reader = await commond.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
var listener = new SMessageTypeListener();
StoreHelper.SetSMessageTypeListenerSelectFields(listener, reader, "listener");
sequence = (Int64)reader["listenersequence"];
listener.MessageType = new SMessageExecuteType();
StoreHelper.SetSMessageExecuteTypeSelectFields(listener.MessageType, reader, "mtype");
listenerList.Add(listener);
}
await reader.CloseAsync();
}
}
foreach (var listenerItem in listenerList)
{
await callback(listenerItem);
}
if (listenerList.Count != pageSize)
{
break;
}
}
});
}
public async Task Add(SMessageTypeListener listener)
{
await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _messageQueueConnectionFactory.CreateAllForMessageQueueMain(), async (conn, transaction) =>
{
SqlTransaction sqlTran = null;
if (transaction != null)
{
sqlTran = (SqlTransaction)transaction;
}
await using (SqlCommand commond = new SqlCommand()
{
Connection = (SqlConnection)conn,
CommandType = CommandType.Text,
Transaction = sqlTran
})
{
if (listener.ID == Guid.Empty)
{
commond.CommandText = @"insert into SMessageTypeListener([id],[messagetypeid],[name],[queuegroupname],[mode],[listenerfactorytype],[listenerfactorytypeusedi],[listenerweburl],[listenerwebsignature],[createtime],[modifytime])
values(default,@messagetypeid,@name,@queuegroupname,@mode,@listenerfactorytype,@listenerfactorytypeusedi,@listenerweburl,@listenerwebsignature,getutcdate(),getutcdate());
select @newid=[id] from SMessageTypeListener where [sequence]=SCOPE_IDENTITY()";
}
else
{
commond.CommandText = @"insert into SMessageTypeListener([id],[messagetypeid],[name],[queuegroupname],[mode],[listenerfactorytype],[listenerfactorytypeusedi],[listenerweburl],[listenerwebsignature],[createtime],[modifytime])
values(@id,@messagetypeid,@name,@queuegroupname,@mode,@listenerfactorytype,@listenerfactorytypeusedi,@listenerweburl,@listenerwebsignature,getutcdate(),getutcdate())";
}
SqlParameter parameter;
if (listener.ID != Guid.Empty)
{
parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier)
{
Value = listener.ID
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@newid", SqlDbType.UniqueIdentifier)
{
Direction = ParameterDirection.Output
};
commond.Parameters.Add(parameter);
}
parameter = new SqlParameter("@messagetypeid", SqlDbType.UniqueIdentifier)
{
Value = listener.MessageType.ID
};
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@name", SqlDbType.VarChar, 150)
{
Value = listener.Name
};
commond.Parameters.Add(parameter);
if (listener.QueueGroupName != null)
{
parameter = new SqlParameter("@queuegroupname", SqlDbType.VarChar, 150)
{
Value = listener.Name
};
}
else
{
parameter = new SqlParameter("@queuegroupname", SqlDbType.VarChar, 150)
{
Value = DBNull.Value
};
}
commond.Parameters.Add(parameter);
parameter = new SqlParameter("@mode", SqlDbType.Int)
{
Value = listener.Mode
};
commond.Parameters.Add(parameter);
if (listener.ListenerFactoryType != null)
{
parameter = new SqlParameter("@listenerfactorytype", SqlDbType.VarChar, 150)
{
Value = listener.ListenerFactoryType
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerfactorytype", SqlDbType.VarChar, 150)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerFactoryTypeUseDI != null)
{
parameter = new SqlParameter("@listenerfactorytypeusedi", SqlDbType.Bit)
{
Value = listener.ListenerFactoryTypeUseDI
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerfactorytypeusedi", SqlDbType.Bit)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerWebUrl != null)
{
parameter = new SqlParameter("@listenerweburl", SqlDbType.VarChar, 200)
{
Value = listener.ListenerWebUrl
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerweburl", SqlDbType.VarChar, 200)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
if (listener.ListenerWebSignature != null)
{
parameter = new SqlParameter("@listenerwebsignature", SqlDbType.VarChar, 150)
{
Value = listener.ListenerWebSignature
};
commond.Parameters.Add(parameter);
}
else
{
parameter = new SqlParameter("@listenerwebsignature", SqlDbType.VarChar, 150)
{
Value = DBNull.Value
};
commond.Parameters.Add(parameter);
}
await commond.PrepareAsync();
await commond.ExecuteNonQueryAsync();
if (listener.ID == Guid.Empty)
{
listener.ID = (Guid)commond.Parameters["@newid"].Value;
}
}
});
}
