/// <summary>
/// 找到当年SQL数据对应标的的最后一条数据的时间。为了插入新的数据做准备。
/// </summary>
/// <param name="code"></param>
/// <param name="currentTime"></param>
/// <returns></returns>
private DateTime GetLatestTimeFromSql(string code, DateTime currentTime)
{
DateTime latest = default(DateTime);
var sqlStr = string.Format(@"declare @date date,@tb_name nvarchar(60), @index int,@latest_date datetime,@sqlStr nvarchar(300),@tem_date datetime
set @date ='{0}-01-01'
set @index =1
while @index <=12
begin
set @tb_name='[StockMinuteTransaction'+datename(year,@date)+'].dbo.[Transaction'+ datename(year,@date)+'-'+datename(month,@date)+']'
set @sqlStr ='select @tem_date=max([DateTime]) from '+@tb_name+' where code=''{1}'''
if object_id(@tb_name) is not null
begin
exec sp_executesql @sqlStr,N'@tem_date datetime output',@tem_date output;
if @tem_date is not null
begin
set @latest_date=@tem_date
end
end
set @date = dateadd(month,1,@date)
set @index=@index+1
end
select @latest_date", currentTime.Year, code.ToUpper());
latest = sqlReader.ExecuteScriptScalar <DateTime>(sqlStr);
return(latest);
}
/// <summary>
/// 找到当月SQL数据对应标的的最后一条数据的时间。为了插入新的数据做准备。
/// </summary>
/// <param name="code"></param>
/// <param name="currentTime"></param>
/// <returns></returns>
private DateTime GetLatestTimeOfMonthFromSql(string code, DateTime currentTime)
{
DateTime latest = default(DateTime);
var sqlStr = string.Format(@"SELECT max([DateTime])
FROM [StockMinuteTransaction{0}].[dbo].[Transaction{1}] where Code='{2}'", currentTime.Year, currentTime.ToString("yyyy-MM"), code.ToUpper());
latest = sqlReaderLocal.ExecuteScriptScalar <DateTime>(sqlStr);
return(latest);
}
private bool ExistInSqlServer(string indexCode, string parameters)
{
var sqlScript = string.Format(@"use master
if db_id('Basis{0}') is not null
begin
if object_id('[Basis{0}].dbo.[{1}]') is not null
begin
select 1 from [Basis{0}].dbo.[{1}]
end
end
else
begin
select 0
end ", indexCode, parameters);
var res = sqlReader.ExecuteScriptScalar <int>(sqlScript);
return(res > default(int));
}
private bool ExistInSqlServer(string code, DateTime date)
{
var sqlScript = string.Format(@"use master
if db_id('StockTickTransaction{0}') is not null
begin
if object_id('[StockTickTransaction{0}].dbo.[{1}]') is not null
begin
select 1 from [StockTickTransaction{0}].dbo.[{1}] where rtrim(stkcd)='{2}'
end
end
else
begin
select 0
end ", date.Year, date.ToString("yyyy-MM-dd"), code.ToUpper());
var res = sqlReader.ExecuteScriptScalar <int>(sqlScript);
return(res > default(int));
}
private bool ExistInSqlServer(string code, DateTime date)
{
var sqlScript = string.Format(@"use master
if db_id('StockInfo') is not null
begin
if object_id('[StockInfo].dbo.[BasicInfoDaily{0}]') is not null
begin
select 1 from [StockInfo].dbo.[BasicInfoDaily{0}] where rtrim(Code)='{1}'
end
end
else
begin
select 0
end ", date.Year, code);
var res = sqlReader.ExecuteScriptScalar <int>(sqlScript);
return(res > default(int));
}
private bool ExistInSqlServer(DateTime date)
{
var sqlScript = string.Format(@"use master
if db_id('ivix{0}') is not null
begin
if object_id('[ivix{0}].dbo.[{1}]') is not null
begin
select 1 from [ivix{0}].dbo.[{1}]
end
end
else
begin
select 0
end ", date.Year, date.ToString("yyyy"));
var res = sqlReader.ExecuteScriptScalar <int>(sqlScript);
return(res > default(int));
}
private bool ExistInSqlServer(string databaseName, string tableName)
{
var sqlScript = string.Format(@"use master
if db_id('{0}') is not null
begin
if object_id('[{0}].dbo.[{1}]') is not null
begin
select 1 from [{0}].dbo.[{1}]
end
end
else
begin
select 0
end ", databaseName, tableName);
var res = sqlReader.ExecuteScriptScalar <int>(sqlScript);
return(res > default(int));
}