using Newtonsoft.Json;
using StackExchange.Redis;
using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;
namespace WorkSample.StackExchange.Redis
{
class Program
{
// static readonly ConcurrentQueue<VehicleStationStatement> vehicleStationStatementsCenter = new ConcurrentQueue<VehicleStationStatement>();
static void Main(string[] args)
{
// 1 001 广州东东信息技术有限公司
// 2 002 广州西西信息技术有限公司
var settlementCompanies = new List<SettlementCompany> {
new SettlementCompany {
Id = 1,
Code = "001",
Name = "广州东东信息技术有限公司"
},
new SettlementCompany {
Id = 2,
Code = "002",
Name = "广州西西信息技术有限公司"
}
};
// 汽车站场信息
// 1 001 东站 conn001token12
// 2 002 西站 conn002token12
var vehicleStations = new List<VehicleStation> {
new VehicleStation {
Id = 1,
Code = "001",
Name = "东站",
Token = @"
Data Source = (localdb)\MSSQLLocalDB;
Initial Catalog = VehicleStationEast;
Integrated Security = True;
Connect Timeout = 30;
Encrypt = False;
TrustServerCertificate = False;
ApplicationIntent = ReadWrite;
MultiSubnetFailover = False"
},
new VehicleStation {
Id = 2,
Code = "002",
Name = "西站",
Token = @"
Data Source = (localdb)\MSSQLLocalDB;
Initial Catalog = VehicleStationWest;
Integrated Security = True;
Connect Timeout = 30;
Encrypt = False;
TrustServerCertificate = False;
ApplicationIntent = ReadWrite;
MultiSubnetFailover = False"
}
};
// 校准配置信息
// 1 001 东站 001 广州东东信息技术有限公司 00010 东东
// 2 001 东站 002 广州西西信息技术有限公司 00012 西西
// 3 002 西站 001 广州东东信息技术有限公司 00001 广州东东信息技术有限公司
// 4 002 西站 002 广州西西信息技术有限公司 00002 广州西西信息技术有限公司
var correctionConfigurations = new List<CorrectionConfiguration> {
new CorrectionConfiguration {
Id = 1,
VehicleStationCode = "001",
VehicleStationName = "东站",
SettlementCompanyCode = "001",
SettlementCompanyName = "广州东东信息技术有限公司",
CorrectionSettlementCompanyCode = "00010",
CorrectionSettlementCompanyName = "东东"
},
new CorrectionConfiguration {
Id = 2,
VehicleStationCode = "001",
VehicleStationName = "东站",
SettlementCompanyCode = "002",
SettlementCompanyName = "广州西西信息技术有限公司",
CorrectionSettlementCompanyCode = "00012",
CorrectionSettlementCompanyName = "西西"
},
new CorrectionConfiguration {
Id = 3,
VehicleStationCode = "002",
VehicleStationName = "西站",
SettlementCompanyCode = "001",
SettlementCompanyName = "广州东东信息技术有限公司",
CorrectionSettlementCompanyCode = "00001",
CorrectionSettlementCompanyName = "广州东东信息技术有限公司"
},
new CorrectionConfiguration {
Id = 4,
VehicleStationCode = "002",
VehicleStationName = "西站",
SettlementCompanyCode = "002",
SettlementCompanyName = "广州西西信息技术有限公司",
CorrectionSettlementCompanyCode = "00002",
CorrectionSettlementCompanyName = "广州西西信息技术有限公司"
},
};
// 东站结算信息
// 1 [东站。100.0。东东] 00010 东东 2018-08-24 01:01 null
// 2 [东站。123.0。西西] 00012 西西 2018-08-24 01:02 null
/*
var vehicleStationStatementsEast = new List<VehicleStationStatement> {
new VehicleStationStatement {
Id = 1,
Detail = "[东站。100.0。东东]",
Code = "00010",
Name = "东东",
CreateTime = DateTime.Parse("2018-08-24 01:01:00"),
UpdateTime = DateTime.Parse("2018-08-24 01:05:00")
},
new VehicleStationStatement {
Id = 2,
Detail = "[东站。123.0。西西]",
Code = "00012",
Name = "西西",
CreateTime = DateTime.Parse("2018-08-24 01:02:00"),
UpdateTime = DateTime.Parse("2018-08-24 01:05:00")
}
};
*/
// 西站结算信息
// 1 [西站。101.0。广州东东信息技术有限公司] 00001 广州东东信息技术有限公司 2018-08-24 01:04 null
// 2 [西站。124.0。广州西西信息技术有限公司] 00002 广州西西信息技术有限公司 2018-08-24 01:03 null
/*
var vehicleStationStatementsWest = new List<VehicleStationStatement> {
new VehicleStationStatement {
Id = 1,
Detail = "[西站。101.0。广州东东信息技术有限公司]",
Code = "00001",
Name = "广州东东信息技术有限公司",
CreateTime = DateTime.Parse("2018-08-24 01:04:00"),
UpdateTime = DateTime.Parse("2018-08-24 01:05:00")
},
new VehicleStationStatement {
Id = 2,
Detail = "[西站。124.0。广州西西信息技术有限公司]",
Code = "00002",
Name = "广州西西信息技术有限公司",
CreateTime = DateTime.Parse("2018-08-24 01:03:00"),
UpdateTime = DateTime.Parse("2018-08-24 01:05:00")
}
};
*/
/*
Parallel.Invoke(
() =>
{
// 1 [东站。99。东东] 00010 东东 2018-08-24 01:01:00 2018-08-24 01:01:00
var code = "00010";
var name = "东东";
for (var i = 0; i < 10000; i++)
{
using (var connection = new SqlConnection(vehicleStations[0].Token))
{
var command = new SqlCommand(@"
INSERT INTO [VehicleStationStatement](Detail,Code,Name,CreateTime,UpdateTime)
VALUES(@Detail,@Code,@Name,@CreateTime,@UpdateTime)
", connection);
command.Parameters.AddWithValue("Detail", $"[{vehicleStations[0].Name}。{new Random().Next(1, 100)}。{name}。{i}]");
command.Parameters.AddWithValue("Code", code);
command.Parameters.AddWithValue("Name", name);
command.Parameters.AddWithValue("CreateTime", DateTime.Now);
command.Parameters.AddWithValue("UpdateTime", DateTime.Now);
connection.Open();
command.ExecuteNonQuery();
}
}
},
() =>
{
// 2 [东站。99。西西] 00012 西西 2018-08-24 01:01:00 2018-08-24 01:01:00
var code = "00012";
var name = "西西";
for (var i = 0; i < 20000; i++)
{
using (var connection = new SqlConnection(vehicleStations[0].Token))
{
var command = new SqlCommand(@"
INSERT INTO [VehicleStationStatement](Detail,Code,Name,CreateTime,UpdateTime)
VALUES(@Detail,@Code,@Name,@CreateTime,@UpdateTime)
", connection);
command.Parameters.AddWithValue("Detail", $"[{vehicleStations[0].Name}。{new Random().Next(1, 100)}。{name}。{i}]");
command.Parameters.AddWithValue("Code", code);
command.Parameters.AddWithValue("Name", name);
command.Parameters.AddWithValue("CreateTime", DateTime.Now);
command.Parameters.AddWithValue("UpdateTime", DateTime.Now);
connection.Open();
command.ExecuteNonQuery();
}
}
},
() =>
{
// 1 [西站。99。广州东东信息技术有限公司] 00001 广州东东信息技术有限公司 2018-08-24 01:01:00 2018-08-24 01:01:00
var code = "00001";
var name = "广州东东信息技术有限公司";
for (var i = 0; i < 30000; i++)
{
using (var connection = new SqlConnection(vehicleStations[1].Token))
{
var command = new SqlCommand(@"
INSERT INTO [VehicleStationStatement](Detail,Code,Name,CreateTime,UpdateTime)
VALUES(@Detail,@Code,@Name,@CreateTime,@UpdateTime)
", connection);
command.Parameters.AddWithValue("Detail", $"[{vehicleStations[1].Name}。{new Random().Next(1, 100)}。{name}。{i}]");
command.Parameters.AddWithValue("Code", code);
command.Parameters.AddWithValue("Name", name);
command.Parameters.AddWithValue("CreateTime", DateTime.Now);
command.Parameters.AddWithValue("UpdateTime", DateTime.Now);
connection.Open();
command.ExecuteNonQuery();
}
}
},
() =>
{
// 2 [西站。99。广州西西信息技术有限公司] 00002 广州西西信息技术有限公司 2018-08-24 01:01:00 2018-08-24 01:01:00
var code = "00002";
var name = "广州西西信息技术有限公司";
for (var i = 0; i < 40000; i++)
{
using (var connection = new SqlConnection(vehicleStations[1].Token))
{
var command = new SqlCommand(@"
INSERT INTO [VehicleStationStatement](Detail,Code,Name,CreateTime,UpdateTime)
VALUES(@Detail,@Code,@Name,@CreateTime,@UpdateTime)
", connection);
command.Parameters.AddWithValue("Detail", $"[{vehicleStations[1].Name}。{new Random().Next(1, 100)}。{name}。{i}]");
command.Parameters.AddWithValue("Code", code);
command.Parameters.AddWithValue("Name", name);
command.Parameters.AddWithValue("CreateTime", DateTime.Now);
command.Parameters.AddWithValue("UpdateTime", DateTime.Now);
connection.Open();
command.ExecuteNonQuery();
}
}
}
);
*/
var database = RedisHelper.GetConnectionMultiplexer().GetDatabase();
Parallel.ForEach(vehicleStations, (vehicleStation) =>
{
var connection = new SqlConnection(vehicleStation.Token);
var command = new SqlCommand(@"
SELECT Id,Detail,Code,Name,CreateTime,UpdateTime
FROM [VehicleStationStatement]", connection);
connection.Open();
using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
var id = reader.GetInt32(0);
var detail = reader.GetString(1);
var code = reader.GetString(2);
var name = reader.GetString(3);
var createTime = reader.GetDateTime(4);
var updateTime = reader.GetDateTime(5);
var config = correctionConfigurations.SingleOrDefault(v => v.VehicleStationCode == vehicleStation.Code && v.CorrectionSettlementCompanyCode == code);
if (config == null)
break;
// vehicleStationStatementsCenter.Enqueue(new VehicleStationStatement
// {
// Id = 0,
// Detail = detail,
// Code = config.SettlementCompanyCode,
// Name = config.SettlementCompanyName,
// CreateTime = createTime,
// UpdateTime = updateTime
// });
database.ListRightPush("VehicleStationStatement", JsonConvert.SerializeObject(new VehicleStationStatement
{
Id = 0,
Detail = detail,
Code = config.SettlementCompanyCode,
Name = config.SettlementCompanyName,
CreateTime = createTime,
UpdateTime = updateTime
}));
}
}
});
// Console.WriteLine(vehicleStationStatementsCenter.Count);
Console.WriteLine(database.ListLength("VehicleStationStatement"));
Parallel.Invoke(
() =>
{
while (database.ListLength("VehicleStationStatement") > 0)
{
Console.WriteLine($"[01] {database.ListLeftPop("VehicleStationStatement")}");
}
},
() =>
{
while (database.ListLength("VehicleStationStatement") > 0)
{
Console.WriteLine($"[02] {database.ListLeftPop("VehicleStationStatement")}");
}
},
() =>
{
while (database.ListLength("VehicleStationStatement") > 0)
{
Console.WriteLine($"[03] {database.ListLeftPop("VehicleStationStatement")}");
}
}
);
}
}
public class SettlementCompany
{
public int Id { get; set; }
public string Code { get; set; }
public string Name { get; set; }
}
public class VehicleStation
{
public int Id { get; set; }
public string Code { get; set; }
public string Name { get; set; }
public string Token { get; set; }
}
public class CorrectionConfiguration
{
public int Id { get; set; }
public string VehicleStationCode { get; set; }
public string VehicleStationName { get; set; }
public string SettlementCompanyCode { get; set; }
public string SettlementCompanyName { get; set; }
public string CorrectionSettlementCompanyCode { get; set; }
public string CorrectionSettlementCompanyName { get; set; }
}
public class VehicleStationStatement
{
public int Id { get; set; }
public string Detail { get; set; }
public string Code { get; set; }
public string Name { get; set; }
public DateTime CreateTime { get; set; }
public DateTime? UpdateTime { get; set; }
}
public static class RedisHelper
{
private static readonly ConcurrentDictionary<string, ConnectionMultiplexer> _connectionMultiplexers = new ConcurrentDictionary<string, ConnectionMultiplexer>();
private static readonly object _locker = new object();
private static ConnectionMultiplexer _connectionMultiplexer;
public static ConnectionMultiplexer GetConnectionMultiplexer(string connectionString = "localhost")
{
if (_connectionMultiplexer == null)
{
lock (_locker)
{
if (_connectionMultiplexer == null || _connectionMultiplexer.IsConnected == false)
{
if (_connectionMultiplexers.ContainsKey(connectionString) == false)
{
var connectionMultiplexer = ConnectionMultiplexer.Connect(connectionString);
connectionMultiplexer.ConfigurationChanged += ConfigurationChanged;
connectionMultiplexer.ConfigurationChangedBroadcast += ConfigurationChangedBroadcast;
connectionMultiplexer.ConnectionFailed += ConnectionFailed;
connectionMultiplexer.ConnectionRestored += ConnectionRestored;
connectionMultiplexer.ErrorMessage += ErrorMessage;
connectionMultiplexer.HashSlotMoved += HashSlotMoved;
connectionMultiplexer.InternalError += InternalError;
_connectionMultiplexers[connectionString] = connectionMultiplexer;
}
_connectionMultiplexer = _connectionMultiplexers[connectionString];
}
}
}
return _connectionMultiplexer;
}
private static void ConfigurationChanged(object sender, EndPointEventArgs e)
{
Console.WriteLine($"ConfigurationChanged"); // e.EndPoint
}
private static void ConfigurationChangedBroadcast(object sender, EndPointEventArgs e)
{
Console.WriteLine($"ConfigurationChangedBroadcast");
}
private static void ConnectionFailed(object sender, ConnectionFailedEventArgs e)
{
Console.WriteLine($"ConnectionFailed");
}
private static void ConnectionRestored(object sender, ConnectionFailedEventArgs e)
{
Console.WriteLine($"ConnectionRestored");
}
private static void ErrorMessage(object sender, RedisErrorEventArgs e)
{
Console.WriteLine($"ErrorMessage");
}
private static void HashSlotMoved(object sender, HashSlotMovedEventArgs e)
{
Console.WriteLine($"HashSlotMoved");
}
private static void InternalError(object sender, InternalErrorEventArgs e)
{
Console.WriteLine($"InternalError");
}
}
}
// Install-Package StackExchange.Redis
// Install-Package Newtonsoft.Json
浙公网安备 33010602011771号