public bool DeleteTimeSeries(DateTime start, DateTime end, int variableID, int siteID)
{
string delcmd = "delete from " + Configuration.DataValuesTableName + " where VariableID =" + variableID + " and SiteID=" + siteID
+ " and " + DBFieldFormater.FormatDateTime("DateTimeUTC", start, end, mDbase.DBKind);
return(mDbase.CreateNonQueryCommand(delcmd));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Drainage](");
strSql.Append("Drainage,Basin");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + Drainage + "',");
strSql.Append("'" + Basin + "'");
strSql.Append(")");
mDbase.CreateNonQueryCommand(strSql.ToString());
}
