/// <summary>
/// 根据时间编号获取Id
/// </summary>
/// <param name="type">类型</param>
/// <param name="timeTag">时间Code</param>
/// <returns>Id</returns>
private int GetDateTimeId(AggType type, string timeTag)
{
string sql = String.Format(@"select top 1 DATETIME_ID from T_DIM_DATETIME where {0} = '{1}' order by DATETIME_ID", this.DataTimeTableColNames[type], timeTag);
try
{
DataSet ds = this.helper.Query(sql);
if (ds == null || ds.Tables.Count != 1 || ds.Tables[0].Rows.Count != 1)
{
return(-1);
}
int id = Convert.ToInt32(ds.Tables[0].Rows[0]["DATETIME_ID"]);
return(id);
}
catch (Exception e)
{
Log.ErrorFormat(
"获取DateTimeId失败,Type:{0},code:{1},sql:{2}, error:{3},trace{4}",
type.ToString(),
timeTag,
sql,
e.Message,
e.StackTrace);
return(-1);
}
}
