public void ReturnInvalidIfNotValidSqlConnectionString()
{
//Arrange
var connectionString = "foo";
string provider = "System.Data.SqlClient";
DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
string result = "";
var ex = new Exception();
//Act
try
{
var dalfactory = new ConnectionStringFactory(connectionString);
result = dalfactory.Create();
}
catch (System.Exception e)
{
ex = e;
}
//Assert
Assert.AreNotEqual(new Exception(), ex);
Assert.AreNotEqual(string.Empty, ex.Message);
Assert.AreEqual(string.Empty, result);
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString(); //填写链接字符串
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
//conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [key_id],[vDate],[CementFirstTeam],[CementSecondTeam],[CementThirdTeam],[CementAmountto],[PackagingTransportationFirstTeam],[PackagingTransportationSecondTeam],[PackagingTransportationThirdTeam],[PackagingTransportationAmountto],[DailyFirstTeam],[DailySecondTeam],[DailyThirdTeam],[DailyAmountto] FROM [CementMillProductionLineMonthlyElectricityConsumption]"; //填写查询语句
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "日期", "水泥制备甲班", "水泥制备乙班", "水泥制备丙班", "水泥制备合计", "水泥包装与输送甲班", "水泥包装与输送乙班", "水泥包装与输送丙班", "水泥包装与输送合计", "合计电量甲班", "合计电量乙班", "合计电量丙班", "合计电量合计" }, //填写表头及宽度
ColumnWidth = new int[] { 10, 60, 80, 80, 80, 80, 120, 120, 120, 120, 80, 80, 80, 80 },
ColumnType = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public async Task ReadBoxInfoOnConnectEnabled()
{
using (var box = await Client.Box.Connect(ConnectionStringFactory.GetReplicationSource_1_7()))
{
box.Info.ShouldNotBeNull();
}
}
public async Task return_null_v1_6_should_not_throw()
{
using (var tarantoolClient = await Client.Box.Connect(ConnectionStringFactory.GetReplicationSource_1_7()))
{
await Should.ThrowAsync <ArgumentException>(async() => await tarantoolClient.Call_1_6 <TarantoolTuple <string, int> >("return_null"));
}
}
public static DbConnection connect(sqlservers server, string database = null)
{
var con = new DbConnectionFactory(server, ConnectionStringFactory.CreateConnectionString(server, database)).Create();
con.Open();
return(con);
}
public IEnumerable <DataItem> GetPlaybackDatas(DateTime myTime, string organizationId, IList <string> variableNames)
{
IList <DataItem> result = new List <DataItem>();
string ammeterConn = ConnectionStringFactory.GetAmmeterConnectionString(organizationId);
_dataFactory = new SqlServerDataFactory(ammeterConn);
IDictionary <string, List <FieldInformation> > fieldInformations = GetFeildInformation(organizationId, variableNames, "History");
DataTable table = GetDataItemTable(myTime, fieldInformations);
string[] idList = GetTableColumnName(table);
foreach (var item in idList)
{
string t_value = "0";
if (_type == "RunningState")
{
t_value = table.Rows[0][item] is DBNull ? "NULL" : Convert.ToDecimal(table.Rows[0][item]).ToString().Trim();
}
else
{
t_value = table.Rows[0][item] is DBNull ? "0" : Convert.ToDecimal(table.Rows[0][item]).ToString("#").Trim();
}
result.Add(new DataItem
{
ID = organizationId + ">" + item + ">" + _type,
Value = t_value//table.Rows[0][item] is DBNull ? "0" : Convert.ToDecimal(table.Rows[0][item]).ToString("#").Trim()
});
}
return(result);
}
public async Task Test()
{
const string spaceName = "primary_only_index";
using (var tarantoolClient = await Client.Box.Connect(ConnectionStringFactory.GetReplicationSource_1_7()))
{
var schema = tarantoolClient.GetSchema();
var space = schema[spaceName];
try
{
await space.Insert((2u, "Music", 0.0f));
}
catch (ArgumentException)
{
await space.Delete <ValueTuple <uint>, ValueTuple <uint, string, double> >(ValueTuple.Create(2u));
await space.Insert((2u, "Music", 0.0f));
}
await space.Select <ValueTuple <uint>, ValueTuple <uint, string, double> >(ValueTuple.Create(2u));
await space.Replace((2u, "Car", -24.5));
await space.Update <ValueTuple <uint>, ValueTuple <uint, string, double> >(
ValueTuple.Create(2u),
new UpdateOperation[] { UpdateOperation.CreateAddition(1, 2) });
await space.Upsert(
(5u, "Test", 20),
new UpdateOperation[] { UpdateOperation.CreateAssign(1, 1) });
}
}
public async Task Create()
{
var factory = new ConnectionStringFactory(this._configuration);
var repo = new TuningRepository(factory, this._logger);
var parameterHelper = new TestParameterHelper
{
Id = "123Id",
Number1 = 1,
Number2 = 920,
Date1 = DateTime.Now,
Date2 = DateTime.Now.AddDays(-5),
TunedParameter = new TunedParameter <string>(
"base-1",
"base-2",
"a-param",
"b100",
"b100-a-param",
TuningDirection.Positive,
TuningStrength.Medium)
};
var tuningPair = new TuningRepository.TuningPair(
parameterHelper.TunedParameter,
JsonConvert.SerializeObject(parameterHelper));
await repo.SaveTasks(new[] { tuningPair });
Assert.IsTrue(true);
}
public void Create_NullOrder_DoesNotThrow()
{
var factory = new ConnectionStringFactory(this._configuration);
var repo = new OrdersRepository(factory, this._marketRepository, this._orderBrokerRepository, this._logger);
Assert.DoesNotThrowAsync(() => repo.Create(null));
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString(); //填写链接字符串
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
//conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT key_id,ClinkerAmountto,ClinkerFirstTeam,ClinkerSecondTeam,ClinkerThirdTeam,CoalDustAmountto,CoalDustFirstTeam,CoalDustSecondTeam,CoalDustThirdTeam,PowerGenerationAmountto,PowerGenerationFirstTeam,PowerGenerationhSecondTeam,PowerGenerationThirdTeam,RawBatchAmountto,RawBatchFirstTeam,RawBatchSecondTeam,RawBatchThirdTeam,vDate from ClinkerProductionLineMonthlyOutput"; //填写查询语句
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "日期", "甲班生料生产", "乙班生料生产", "丙班生料生产", "合计生料生产", "甲班熟料生产", "乙班熟料生产", "丙班熟料生产", "合计熟料生产", "甲班发电量", "乙班发电量", "丙班发电量", "合计发电量", "甲班煤粉产量", "乙班煤粉产量", "丙班煤粉产量", "合计煤粉产量" }, //填写表头及宽度
ColumnWidth = new int[] { 10, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100 },
ColumnType = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public BaseService()
{
var connectionString = new ConnectionStringFactory();
var mongoRepository = new MongoRepositoryFactory(connectionString);
Logger = new Logger(mongoRepository);
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString(); //填写链接字符串
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
//conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT key_id,vDate,ClinkerFirstTeam,ClinkerSecondTeam,ClinkerThirdTeam,ClinkerAmountto,DailyFirstTeam,DailySecondTeam,DailyThirdTeam,DailyAmountto,RawBatchFirstTeam,RawBatchSecondTeam,RawBatchThirdTeam,RawBatchAmountto FROM ClinkerProductionLineMonthlyElectricityConsumption"; //填写查询语句
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "日期", "甲班生料制备", "乙班生料制备", "丙班生料制备", "合计生料制备", "甲班熟料制备", "乙班熟料制备", "丙班熟料制备", "合计熟料制备", "甲班合计电量", "乙班合计电量", "丙班合计电量", "合计电量" }, //填写表头及宽度
ColumnWidth = new int[] { 10, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100 },
ColumnType = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "" }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public void Does_SaveNull_DoesNotThrow()
{
var factory = new ConnectionStringFactory(this._configuration);
var repo = new RuleAnalyticsAlertsRepository(factory, this._logger);
Assert.DoesNotThrowAsync(() => repo.Create(null));
}
public static DataTable GetHandoverLogByHandoverLogId(int handoverLogId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = @"SELECT WorkingTeamShiftLog.*,
StaffInfo.Name AS ChargeManName, ProductLine.Name AS ProductLineName,
WorkingTeam.Name AS WorkingTeamName
FROM WorkingTeam INNER JOIN
StaffInfo INNER JOIN
WorkingTeamShiftLog ON StaffInfo.ID = WorkingTeamShiftLog.ChargeManID INNER JOIN
ProductLine ON WorkingTeamShiftLog.ProductLineID = ProductLine.ID ON
WorkingTeam.ID = WorkingTeamShiftLog.WorkingTeamID
WHERE (WorkingTeamShiftLog.ID = @workingTeamShiftLogID)";
command.Parameters.Add(new SqlParameter("workingTeamShiftLogID", handoverLogId));
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
}
return(ds.Tables[0]);
}
public async Task Update_Operation_AddsToDb()
{
var connFactory = new ConnectionStringFactory(this._config);
var parentRepository = new SystemProcessRepository(connFactory, this._processLogger);
var repository = new SystemProcessOperationRepository(connFactory, this._operationLogger);
var systemProcess = new SystemProcess
{
MachineId = Environment.MachineName,
ProcessId = Process.GetCurrentProcess().Id.ToString(),
InstanceInitiated = DateTime.UtcNow,
Heartbeat = DateTime.UtcNow,
SystemProcessType = SystemProcessType.DataImportService
};
systemProcess.Id = systemProcess.GenerateInstanceId();
await parentRepository.Create(systemProcess);
var systemProcessOperation = new SystemProcessOperation
{
SystemProcessId = systemProcess.Id,
OperationStart = DateTime.UtcNow,
OperationState = OperationState.InProcess
};
await repository.Create(systemProcessOperation);
systemProcessOperation.OperationEnd = DateTime.UtcNow;
await repository.Update(systemProcessOperation);
Assert.IsTrue(true);
}
public async Task Create_Creates_AsExpected()
{
var connectionStringFactory = new ConnectionStringFactory(this._configuration);
var repo = new RuleBreachRepository(connectionStringFactory, this._logger);
var caseMessage = new RuleBreach(
100,
"rule-1",
"correlation-id",
true,
DateTime.UtcNow,
"case-title",
"case-description",
"xlon",
DateTime.UtcNow,
DateTime.UtcNow,
"entspb",
"RD00",
"0",
0,
"1",
true,
new int[0]);
var result = await repo.Create(caseMessage);
}
public async Task TreeIndexMethods()
{
const string spaceName = "space_TreeIndexMethods";
await ClearDataAsync(spaceName);
using (var tarantoolClient = await Client.Box.Connect(ConnectionStringFactory.GetReplicationSource_1_7()))
{
var schema = tarantoolClient.GetSchema();
var space = schema[spaceName];
var index = space["treeIndex"];
var min2 = await index.Min <TarantoolTuple <int, int, int>, TarantoolTuple <int> >(TarantoolTuple.Create(3));
min2.ShouldBe(null);
var min = await index.Min <TarantoolTuple <int, string, double> >();
min.ShouldBe(null);
var max = await index.Max <TarantoolTuple <int, int, int> >();
max.ShouldBe(min2);
var max2 = await index.Max <TarantoolTuple <int, string, double>, TarantoolTuple <int> >(TarantoolTuple.Create(1));
max2.ShouldBe(min);
}
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString();
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [key_id],VMonth,ElectricityConsumption,CoalDust,Qnet,Diesel,ResidualHeatSupply,ResidualHeatProduction,ResidualHeatSelfUse,ClinkerOutput,ClinkerIntensity,ClinkerIntensityCorrectionFactor,ComprehensiveECC,ComparableComprehensiveECC,ComprehensiveStandardCCC,ComparableComprehensiveStandardCCC,ComprehensiveDCC,ConversionResidualHeatSupply,ComprehensiveEnCC,ComparableComprehensiveEnCC FROM [ClinkerYeldPerUnitDistributionEnergyConsumptionYearly]";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "月份", "熟料用电量 ", "入窑煤粉量", "煤粉空干基低位发热量", "点火用油", "余热供电量", "余热发电量", "余热自用电", "熟料产量", "熟料强度", "熟料强度修正系数", "熟料综合电耗", "可比熟料综合电耗", "熟料综合煤耗", "可比熟料综合煤耗", "熟料油耗", "余热供电折标", "熟料综合能耗", "可比熟料综合能耗" }, //填写表头及宽度
ColumnWidth = new int[] { 10, 40, 70, 70, 130, 60, 70, 70, 70, 60, 60, 110, 80, 110, 80, 110, 60, 80, 80, 110 },
ColumnType = new string[] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public async Task Get_AdhocRequests()
{
var connectionStringFactory = new ConnectionStringFactory(this._configuration);
var repo = new TaskSchedulerRepository(connectionStringFactory, this._logger);
var result = await repo.ReadUnprocessedTask(DateTime.UtcNow);
}
public void CreateConnectionString_ReturnsConnectionString()
{
var connectionStringFactory = new ConnectionStringFactory();
var connectionString = connectionStringFactory.CreateConnectionString();
Assert.That(connectionString, Does.StartWith(@"Data Source=(localdb)\MSSQLLocalDB"));
}
public async Task LongTest()
{
const string spaceName = "primary_only_index";
using (var tarantoolClient = new Client.Box(new ClientOptions(ConnectionStringFactory.GetReplicationSource_1_7(), new StringWriterLog())))
{
await tarantoolClient.Connect();
var schema = tarantoolClient.GetSchema();
var space = schema[spaceName];
var longString = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec condimentum pharetra porta. Aliquam ullamcorper ex quis mi aliquet egestas. Suspendisse dui nunc, tincidunt mattis purus ac, fringilla porttitor turpis. Nunc nunc turpis, accumsan eu mi et, scelerisque ultrices orci. Maecenas sed ornare risus. Nam ut luctus ante, id tincidunt diam. Vestibulum maximus non quam molestie rutrum. Phasellus faucibus nunc eu sapien posuere, sed imperdiet quam sollicitudin. Donec nec dui ullamcorper, tincidunt sem eget, egestas lorem. Proin egestas, sem a malesuada sodales, risus sapien aliquet leo, non commodo sem ante et tellus. Donec vel ex et elit pellentesque iaculis faucibus vel lacus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam fermentum dui at ligula luctus faucibus. Nunc congue placerat dignissim. Quisque odio ipsum, viverra id faucibus sed, pellentesque id velit. Etiam a nibh non lorem vulputate volutpat.";
try
{
await space.Insert((222u, longString, 0.0f));
}
catch (ArgumentException)
{
await space.Delete <ValueTuple <uint>, ValueTuple <uint, string, double> >(ValueTuple.Create(222u));
await space.Insert((222u, longString, 0.0f));
}
var selectResponse = await space.Select <ValueTuple <uint>, ValueTuple <uint, string, double> >(ValueTuple.Create(222u));
selectResponse.Data.Single().Item2.ShouldBe(longString);
}
}
public static int Main(string[] args)
{
var connectionString = ConnectionStringFactory.GetConnectionString(args);
var isDryRun = args.Contains("dryRun");
var preDeployResult = PerformUpgrade(connectionString, EnvironmentFilter.GetPreDeployFilter(args), isDryRun);
if (!preDeployResult.Successful)
{
return(ResultReporter.ReportResult(preDeployResult));
}
ResultReporter.ReportResult(preDeployResult);
var result = PerformUpgrade(connectionString, EnvironmentFilter.GetFilter(args), isDryRun);
if (!result.Successful)
{
return(ResultReporter.ReportResult(result));
}
ResultReporter.ReportResult(result);
var postDeployResult = PerformUpgrade(connectionString, EnvironmentFilter.GetPostDeployFilter(args), isDryRun);
return(ResultReporter.ReportResult(postDeployResult));
}
public async Task return_nothing_v1_6_should_not_throw()
{
using (var tarantoolClient = await Client.Box.Connect(ConnectionStringFactory.GetReplicationSource_1_7()))
{
Should.NotThrow(async() => await tarantoolClient.Call_1_6("return_nothing"));
}
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString(); //填写链接字符串
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
//conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT key_id,vDate,ConsumptionFirstTeam,ConsumptionSecondTeam,ConsumptionThirdTeam,ConsumptionAmountto FROM CementMillProductionLineMonthlyOutput"; //填写查询语句
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "日期", "甲班", "乙班", "丙班", "合计" }, //填写表头及宽度
ColumnWidth = new int[] { 10, 100, 100, 100, 100, 100 },
ColumnType = new string[] { "", "", "", "", "", "" }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public async Task Bulk_Then_Get_Rows_Returns_Expected()
{
var factory = new ConnectionStringFactory(this._configuration);
var repo = new OrderAllocationRepository(factory, this._logger);
var orderAllocation1 = new OrderAllocation(
null,
"order-1",
"my-fund",
"my-strategy",
"my-account",
"my-allocation",
1000,
DateTime.UtcNow);
var orderAllocation2 = new OrderAllocation(
null,
"order-2",
"my-fund",
"my-strategy",
"my-account",
"my-allocation",
1000,
DateTime.UtcNow);
var allocations = new List <OrderAllocation> {
orderAllocation1, orderAllocation2
};
await repo.Create(allocations);
var orderId = new List <string> {
"order-1", "order-2"
};
var result = await repo.Get(orderId);
Assert.AreEqual(result.Count, 2);
}
public async Task Get_Creates_AsExpected()
{
var connectionStringFactory = new ConnectionStringFactory(this._configuration);
var repo = new RuleBreachOrdersRepository(connectionStringFactory, this._logger);
var result = await repo.Get("20");
}
public static IConnectionString GetConnectionString(string dataStoreKey)
{
string connectionString = ConfigurationManager.ConnectionStrings[dataStoreKey].ConnectionString;
IConnectionString connection = ConnectionStringFactory.Build(connectionString);
return(connection);
}
public static string GetCompanyData()
{
string connString = ConnectionStringFactory.GetNXJCConnectionString(); //填写链接字符串
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connString))
{
//conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [key_id],VMonth,CementTypes,Output,ElectricityConsumption,DistributionPowerConsumption,ConversionDistributionPowerConsumption FROM [CementYeldPerUnitDistributionPowerConsumptionYearly]";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
DataGridColumnType columnType = new DataGridColumnType
{
ColumnText = new string[] { "ID", "月份", "水泥品种", "产量", "用电量", "分步电耗", "折算P.O42.5分布电耗", },
ColumnWidth = new int[] { 10, 40, 60, 40, 50, 60, 140 },
ColumnType = new string[] { "", "", "", "", "", "", "" }
};
string result = DataGridTemplateHelper.GetDataGridTemplate(dt, columnType);
return(result);
}
public async Task Save()
{
var factory = new ConnectionStringFactory(this._configuration);
var repo = new ReddeerMarketDailySummaryRepository(factory, this._logger);
var items = new List <FactsetSecurityDailyResponseItem>
{
new FactsetSecurityDailyResponseItem
{
Figi = "BBG000C6K6G9",
ClosePrice = 0m,
Currency = "usd",
DailyVolume = 2,
Epoch = DateTime.UtcNow.AddDays(1),
HighIntradayPrice = 3,
LowIntradayPrice = 4,
MarketCapitalisationUsd = 5,
OpenPrice = 6,
MarketCapitalisation = 7
}
};
await repo.Save(items);
Assert.IsTrue(true);
}
public UserRegistrationService(IUserRepository userRepository)
{
_userRepository = userRepository;
var connectionString = new ConnectionStringFactory();
var mongoRepository = new MongoRepositoryFactory(connectionString);
_logger = new Logger(mongoRepository);
}
