public static bool LoadTrendCount(int callstack_uid, short fromDate, short toDate, ForEachTrendCount func) { if (fromDate <= 0) fromDate = (short)kSampleBegin; if (toDate < 0) toDate = (short)kSampleEnd; using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); SqlCommand cmd1 = new SqlCommand("usp_select_daily_count_per_version", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@callstack_uid", callstack_uid); cmd1.Parameters.AddWithValue("@day_from", fromDate); cmd1.Parameters.AddWithValue("@day_to", toDate); SqlDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string version = reader.GetString(0); string date = reader.GetString(1); int count = reader.GetInt32(2); func(version, date, count); } reader.Close(); } catch (System.Exception) { return false; } } return true; }
public static bool LoadTrendCount(int callstack_uid, short fromDate, short toDate, ForEachTrendCount func) { if (fromDate <= 0) { fromDate = (short)kSampleBegin; } if (toDate < 0) { toDate = (short)kSampleEnd; } using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); SqlCommand cmd1 = new SqlCommand("usp_select_daily_count_per_version", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@callstack_uid", callstack_uid); cmd1.Parameters.AddWithValue("@day_from", fromDate); cmd1.Parameters.AddWithValue("@day_to", toDate); SqlDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string version = reader.GetString(0); string date = reader.GetString(1); int count = reader.GetInt32(2); func(version, date, count); } reader.Close(); } catch (System.Exception) { return(false); } } return(true); }