public virtual ProductTypeInfo GetProductTypeByID(int ID)
{
ProductTypeInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM ProductType WHERE ProductType_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ProductTypeInfo();
entity.ProductType_ID = Tools.NullInt(RdrList["ProductType_ID"]);
entity.ProductType_Name = Tools.NullStr(RdrList["ProductType_Name"]);
entity.ProductType_Sort = Tools.NullInt(RdrList["ProductType_Sort"]);
entity.ProductType_IsActive = Tools.NullInt(RdrList["ProductType_IsActive"]);
entity.ProductType_Site = Tools.NullStr(RdrList["ProductType_Site"]);
}
RdrList.Close();
RdrList = null;
if (entity != null)
{
entity.BrandInfos = GetProductBrands(entity.ProductType_ID);
entity.ProductTypeExtendInfos = MyProductTypeExtend.GetProductTypeExtends(entity.ProductType_ID);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
//获取产品类型所属扩展属性
public string GetProductTypeExtends(int ID)
{
IList <ProductTypeExtendInfo> ProductTypeExtends = MyBLL.GetProductTypeExtends(ID);
if (ProductTypeExtends != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":1,\"total\":" + ProductTypeExtends.Count + ",\"records\":" + ProductTypeExtends.Count + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (ProductTypeExtendInfo entity in ProductTypeExtends)
{
jsonBuilder.Append("{\"ProductType.ProductType_ID\":" + entity.ProductType_Extend_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.ProductType_Extend_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.ProductType_Extend_Name);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
switch (entity.ProductType_Extend_Display.ToLower())
{
case "select":
jsonBuilder.Append("下拉菜单");
break;
case "text":
jsonBuilder.Append("文本框");
break;
case "html":
jsonBuilder.Append("HTML");
break;
default:
jsonBuilder.Append("--");
break;
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (entity.ProductType_Extend_IsSearch == 0)
{
jsonBuilder.Append("否");
}
else
{
jsonBuilder.Append("是");
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.ProductType_Extend_Sort);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append("<img src=\\\"/images/icon_edit.gif\\\"> <a href=\\\"producttypeExtend_edit.aspx?extend_id=" + entity.ProductType_Extend_ID + "\\\" title=\\\"修改\\\">修改</a> <img src=\\\"/images/icon_del.gif\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('producttypeextend_do.aspx?action=move&extend_id=" + entity.ProductType_Extend_ID + "')\\\" title=\\\"删除\\\">删除</a>");
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
