public bool CheckExistanceOfTimeSeries(int variableID, int siteID, DateTime start, DateTime end) { string slctcmd = "select ValueID from " + Configuration.DataValuesTableName + " where VariableID =" + variableID + " and SiteID=" + siteID + " and " + DBFieldFormater.FormatDateTime("DateTimeUTC", start, end, mDbase.DBKind); return(mDbase.Exists(slctcmd)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists() { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from [Drainage]"); strSql.Append("where Basin='" + Basin + "'and Drainage='" + Drainage + "'"); return(mDbase.Exists(strSql.ToString())); }