public List<ClusterInfo> GetListCluster() { List<ClusterInfo> list = new List<ClusterInfo>(); string sql = "SELECT clusterID FROM [RS].[USER_CLUSTER_TBL]"; SqlDataReader dr = executeReader(sql); ClusterInfo cluster = new ClusterInfo(); while (dr.Read()) { cluster.ClusterID = dr.GetString(dr.GetOrdinal("ClusterID")); list.Add(cluster); } dr.Close(); return list; }
public List<ClusterInfo> getClusterInfo_BySubCategory(string U_SubCategoryID) { string strSelect = "SELECT [ClusterID] ,count(*) as 'Count' FROM [RS].[PARTION_TBL], [RS].[USER_TBL] WHERE [PARTION_TBL].[UserID] = [USER_TBL].[UserID] and [USER_TBL].U_SubCategoryID = @U_SubCategoryID group by [ClusterID] order by [ClusterID] ASC"; Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("@U_SubCategoryID", U_SubCategoryID); SqlDataReader dr = executeReader(strSelect, parameters); List<ClusterInfo> list = new List<ClusterInfo>(); while (dr.Read()) { ClusterInfo obj = new ClusterInfo(); obj.ClusterID = dr.GetString(dr.GetOrdinal("ClusterID")); obj.Count = dr.GetInt32(dr.GetOrdinal("Count")); list.Add(obj); } dr.Close(); return list; }