/// <summary>
/// 读取北京失败期列表
/// </summary>
/// <returns></returns>
public List<CollectResultEntity> GetBeijingFailPeriodList()
{
List<CollectResultEntity> result = null;
string sql = @"SELECT [PeriodNum],[RetTime] FROM [Helpmate].[dbo].[SourceData_28_Beijing] WHERE [Status] = -1";
DBHelper db = new DBHelper();
try
{
DataTable dt = db.ExeSqlDataAdapter(CommandType.Text, sql);
if (dt != null && dt.Rows.Count > 0)
{
result = new List<CollectResultEntity>();
foreach (DataRow row in dt.Rows)
{
CollectResultEntity item = new CollectResultEntity();
item.PeriodNum = long.Parse(row["PeriodNum"].ToString());
item.RetTime = DateTime.Parse(row["RetTime"].ToString());
result.Add(item);
}
}
}
catch (Exception ex)
{
WriteLog.Write(string.Format("GetBeijingFailPeriodList读取SQL Server数据库失败期列表失败，sql：{0}，错误信息：{1}", sql, ex.ToString()));
}
finally
{
db.Dispose();
}
return result;
}
/// <summary>
/// 读取北京下期期号
/// </summary>
/// <returns></returns>
public CollectResultEntity GetBeijingNextPeriodNum()
{
CollectResultEntity result = new CollectResultEntity();
string sql = @"SELECT TOP 1 [PeriodNum],[RetTime] FROM [Helpmate].[dbo].[SourceData_28_Beijing] ORDER BY [PeriodNum] DESC";
DBHelper db = new DBHelper();
try
{
DataTable dt = db.ExeSqlDataAdapter(CommandType.Text, sql);
if (dt != null && dt.Rows.Count > 0)
{
result.PeriodNum = long.Parse(dt.Rows[0]["PeriodNum"].ToString()) + 1;
result.RetTime = DateTime.Parse(dt.Rows[0]["RetTime"].ToString());
//到23:55当天开奖就结束了，下一期在第二天9:05
if (result.RetTime.Hour == 23 && result.RetTime.Minute == 55)
result.RetTime = DateTime.Parse(string.Format("{0} 9:05", result.RetTime.ToShortDateString())).AddDays(1);
else
result.RetTime = result.RetTime.AddMinutes(5);
}
else
{
result.PeriodNum = 0;
}
}
catch (Exception ex)
{
WriteLog.Write(string.Format("GetBeijingNextPeriodNum读取SQL Server数据库期号失败，sql：{0}，错误信息：{1}", sql, ex.ToString()));
}
finally
{
db.Dispose();
}
return result;
}
/// <summary>
/// 读取加拿大下期期号
/// </summary>
/// <returns></returns>
public CollectResultEntity GetCanadanNextPeriodNum()
{
CollectResultEntity result = new CollectResultEntity();
string sql = @"SELECT TOP 1 [PeriodNum],[RetTime] FROM [Helpmate].[dbo].[SourceData_28_Canada] ORDER BY [PeriodNum] DESC";
DBHelper db = new DBHelper();
try
{
DataTable dt = db.ExeSqlDataAdapter(CommandType.Text, sql);
if (dt != null && dt.Rows.Count > 0)
{
result.PeriodNum = long.Parse(dt.Rows[0]["PeriodNum"].ToString()) + 1;
result.RetTime = DateTime.Parse(dt.Rows[0]["RetTime"].ToString());
result.RetTime = result.RetTime.AddMinutes(4);
}
else
{
result.PeriodNum = 0;
}
}
catch (Exception ex)
{
WriteLog.Write(string.Format("GetCanadanNextPeriodNum读取SQL Server数据库期号失败，sql：{0}，错误信息：{1}", sql, ex.ToString()));
}
finally
{
db.Dispose();
}
return result;
}
