/// <summary>
/// 获取标准车型有效品牌
/// </summary>
/// <returns></returns>
public IList <VWTreeCTBrandEntity> GetStandardTreeCTB(int isstand)
{
string where = " where IsActive=1 ";
if (isstand != -1)
{
where = " where IsStandardBrand=@IsStandardBrand ";
}
string sql = @"SELECT [Id], [BrandName],[PYFirst],[PicUrl],Sort,ParentId,IsStandardBrand from dbo.[CarTypeBrand] WITH(NOLOCK) " + where + " Order By Sort ";
IList <VWTreeCTBrandEntity> entityList = new List <VWTreeCTBrandEntity>();
DbCommand cmd = db.GetSqlStringCommand(sql);
if (isstand != -1)
{
db.AddInParameter(cmd, "@IsStandardBrand", DbType.Int32, isstand);
}
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
VWTreeCTBrandEntity entity = new VWTreeCTBrandEntity();
entity.Id = StringUtils.GetDbInt(reader["Id"]);
entity.Name = StringUtils.GetDbString(reader["BrandName"]);
entity.PYFirst = StringUtils.GetDbString(reader["PYFirst"]);
entity.Sort = StringUtils.GetDbInt(reader["Sort"]);
entity.PicUrl = StringUtils.GetDbString(reader["PicUrl"]);
entity.ParentId = StringUtils.GetDbInt(reader["ParentId"]);
entity.IsStandardBrand = StringUtils.GetDbInt(reader["IsStandardBrand"]);
entityList.Add(entity);
}
}
return(entityList);
}
public IList <VWTreeCTBrandEntity> GetTreeCarTypeBrand(int isstand = 1)
{
IList <VWTreeCTBrandEntity> resultlist = new List <VWTreeCTBrandEntity>();
string _cachekey = "GetTreeCarTypeBrand_" + isstand;
object obj = MemCache.GetCache(_cachekey);
if (obj == null)
{
IList <VWTreeCTBrandEntity> list = null;
list = CarTypeBrandDA.Instance.GetStandardTreeCTB(isstand);
if (list != null && list.Count > 0)
{
//string[] firstletter = new Array();
ArrayList firstletter = new ArrayList();
foreach (VWTreeCTBrandEntity entity in list)
{
if (!firstletter.Contains(entity.PYFirst))
{
firstletter.Add(entity.PYFirst);
}
firstletter.Sort();
}
foreach (string letter in firstletter)
{
VWTreeCTBrandEntity entity = new VWTreeCTBrandEntity();
entity.PYFirst = letter;
resultlist.Add(entity);
}
foreach (VWTreeCTBrandEntity entity in list)
{
foreach (VWTreeCTBrandEntity entity2 in resultlist)
{
if (entity.PYFirst == entity2.PYFirst)
{
if (entity2.Children == null)
{
entity2.Children = new List <VWTreeCTBrandEntity>();
}
entity2.Children.Add(entity);
break;
}
}
}
}
MemCache.AddCache(_cachekey, resultlist);
}
else
{
resultlist = (IList <VWTreeCTBrandEntity>)obj;
}
return(resultlist);
}
