/// <summary>
/// 将数据加入临时表
/// </summary>
/// <param name="dataList"></param>
/// <returns></returns>
public static bool InsertDataToTempTable(List <Model_NodeHistoryData> dataList)
{
try
{
StringBuilder sql = new StringBuilder("insert into history_data_waithandle (pointId,`data`,`isAlarm`,`dataTime`,`retryCount`) values");
for (int i = 0; i < dataList.Count; i++)
{
Model_NodeHistoryData data = dataList[i];
sql.AppendLine(string.Format("('{0}','{1}','{2}','{3}',0)", data.PointId, data.Data, (int)data.IsAlarm, data.DataTime.ToString("yyyy-MM-dd HH:mm:ss")));
if (i != dataList.Count - 1)
{
sql.Append(",");
}
}
return(_SqlHelp.ExecuteNonQuery(sql.ToString()) == dataList.Count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入历史数据
/// </summary>
/// <param name="data"></param>
/// <param name="coldstorage_ID"></param>
/// <returns></returns>
public static bool InsertPointData(Model_NodeHistoryData data, int coldstorage_ID)
{
bool result = false;
string tableName = "history_data_" + coldstorage_ID;
string sql = string.Format("insert into {0} (pointId,`data`,`isAlarm`,`dataTime`) values('{1}','{2}','{3}','{4}')", tableName, data.PointId, data.Data, (int)data.IsAlarm, data.DataTime.ToString("yyyy-MM-dd HH:mm:ss"));
try
{
result = _SqlHelp.ExecuteNonQuery(sql) == 1;
}
catch (Exception ex)
{
throw new Exception("插入数据时出错:" + ex.Message);
}
finally
{
try
{
string stateSql = string.Empty;
if (result)
{
stateSql = string.Format("delete from history_data_waithandle where id='{0}'", data.Id);
}
else
{
stateSql = "update history_data_waithandle set retryCount=retryCount+1";
}
_SqlHelp.ExecuteNonQuery(stateSql);
}
catch (Exception ex)
{
throw new Exception("更新临时数据状态时出错:" + ex.Message);
}
}
return(result);
}
