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()); }