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