public IList <AttributeInfo> GetAttributes(AttributeUseageMode attributeUseageMode) { IList <AttributeInfo> list = new List <AttributeInfo>(); string text = (attributeUseageMode != AttributeUseageMode.Choose) ? "UsageMode <> 2" : "UsageMode = 2"; DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT * FROM Hishop_Attributes WHERE " + text + " ORDER BY DisplaySequence Desc SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes Where " + text + " ) ORDER BY DisplaySequence Desc"); using (DataSet dataSet = base.database.ExecuteDataSet(sqlStringCommand)) { foreach (DataRow row in dataSet.Tables[0].Rows) { AttributeInfo attributeInfo = new AttributeInfo(); attributeInfo.AttributeId = (int)row["AttributeId"]; attributeInfo.AttributeName = (string)row["AttributeName"]; attributeInfo.DisplaySequence = (int)row["DisplaySequence"]; attributeInfo.TypeId = (int)row["TypeId"]; attributeInfo.UsageMode = (AttributeUseageMode)(int)row["UsageMode"]; attributeInfo.UseAttributeImage = (bool)row["UseAttributeImage"]; if (dataSet.Tables[1].Rows.Count > 0) { DataRow[] array = dataSet.Tables[1].Select("AttributeId=" + attributeInfo.AttributeId.ToString()); DataRow[] array2 = array; foreach (DataRow dataRow2 in array2) { AttributeValueInfo attributeValueInfo = new AttributeValueInfo(); attributeValueInfo.ValueId = (int)dataRow2["ValueId"]; attributeValueInfo.AttributeId = attributeInfo.AttributeId; attributeValueInfo.ValueStr = (string)dataRow2["ValueStr"]; attributeInfo.AttributeValues.Add(attributeValueInfo); } } list.Add(attributeInfo); } } return(list); }
public IList <AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { IList <AttributeInfo> list = new List <AttributeInfo>(); string text; if (attributeUseageMode == AttributeUseageMode.Choose) { text = "UsageMode = 2"; } else { text = "UsageMode <> 2"; } DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Concat(new string[] { "SELECT * FROM Ecshop_Attributes WHERE TypeId = @TypeId AND ", text, " ORDER BY DisplaySequence Desc SELECT * FROM Ecshop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Ecshop_Attributes WHERE TypeId = @TypeId AND ", text, " ) ORDER BY DisplaySequence Desc" })); this.database.AddInParameter(sqlStringCommand, "TypeId", DbType.Int32, typeId); using (DataSet dataSet = this.database.ExecuteDataSet(sqlStringCommand)) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { AttributeInfo attributeInfo = new AttributeInfo(); attributeInfo.AttributeId = (int)dataRow["AttributeId"]; attributeInfo.AttributeName = (string)dataRow["AttributeName"]; attributeInfo.DisplaySequence = (int)dataRow["DisplaySequence"]; attributeInfo.TypeId = (int)dataRow["TypeId"]; attributeInfo.UsageMode = (AttributeUseageMode)((int)dataRow["UsageMode"]); attributeInfo.UseAttributeImage = (bool)dataRow["UseAttributeImage"]; if (dataSet.Tables[1].Rows.Count > 0) { DataRow[] array = dataSet.Tables[1].Select("AttributeId=" + attributeInfo.AttributeId.ToString()); DataRow[] array2 = array; for (int i = 0; i < array2.Length; i++) { DataRow dataRow2 = array2[i]; AttributeValueInfo attributeValueInfo = new AttributeValueInfo(); attributeValueInfo.ValueId = (int)dataRow2["ValueId"]; attributeValueInfo.AttributeId = attributeInfo.AttributeId; if (dataRow2["ImageUrl"] != DBNull.Value) { attributeValueInfo.ImageUrl = (string)dataRow2["ImageUrl"]; } attributeValueInfo.ValueStr = (string)dataRow2["ValueStr"]; attributeInfo.AttributeValues.Add(attributeValueInfo); } } list.Add(attributeInfo); } } return(list); }
public IList <AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { string str; IList <AttributeInfo> list = new List <AttributeInfo>(); if (attributeUseageMode == AttributeUseageMode.Choose) { str = "UsageMode = 2"; } else { str = "UsageMode <> 2"; } DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ORDER BY DisplaySequence Desc SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ) ORDER BY DisplaySequence Desc"); this.database.AddInParameter(sqlStringCommand, "TypeId", DbType.Int32, typeId); using (DataSet set = this.database.ExecuteDataSet(sqlStringCommand)) { foreach (DataRow row in set.Tables[0].Rows) { AttributeInfo item = new AttributeInfo { AttributeId = (int)row["AttributeId"], AttributeName = (string)row["AttributeName"], DisplaySequence = (int)row["DisplaySequence"], TypeId = (int)row["TypeId"], UsageMode = (AttributeUseageMode)((int)row["UsageMode"]), UseAttributeImage = (bool)row["UseAttributeImage"] }; if (set.Tables[1].Rows.Count > 0) { DataRow[] rowArray = set.Tables[1].Select("AttributeId=" + item.AttributeId.ToString()); foreach (DataRow row2 in rowArray) { AttributeValueInfo info2 = new AttributeValueInfo { ValueId = (int)row2["ValueId"], AttributeId = item.AttributeId }; if (row2["ImageUrl"] != DBNull.Value) { info2.ImageUrl = (string)row2["ImageUrl"]; } info2.ValueStr = (string)row2["ValueStr"]; item.AttributeValues.Add(info2); } } list.Add(item); } } return(list); }
public static IList <AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { return(new AttributeDao().GetAttributes(typeId, attributeUseageMode)); }
public static IList <AttributeInfo> GetAttributes(AttributeUseageMode attributeUseageMode) { return(new AttributeDao().GetAttributes(attributeUseageMode)); }
public static IList <AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { return(ProductProvider.Instance().GetAttributes(typeId, attributeUseageMode)); }
public IList<AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { string str; IList<AttributeInfo> list = new List<AttributeInfo>(); if (attributeUseageMode == AttributeUseageMode.Choose) { str = "UsageMode = 2"; } else { str = "UsageMode <> 2"; } DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ORDER BY DisplaySequence Desc SELECT * FROM Hishop_AttributeValues WHERE AttributeId IN (SELECT AttributeId FROM Hishop_Attributes WHERE TypeId = @TypeId AND " + str + " ) ORDER BY DisplaySequence Desc"); this.database.AddInParameter(sqlStringCommand, "TypeId", DbType.Int32, typeId); using (DataSet set = this.database.ExecuteDataSet(sqlStringCommand)) { foreach (DataRow row in set.Tables[0].Rows) { AttributeInfo item = new AttributeInfo { AttributeId = (int) row["AttributeId"], AttributeName = (string) row["AttributeName"], DisplaySequence = (int) row["DisplaySequence"], TypeId = (int) row["TypeId"], UsageMode = (AttributeUseageMode) ((int) row["UsageMode"]), UseAttributeImage = (bool) row["UseAttributeImage"] }; if (set.Tables[1].Rows.Count > 0) { DataRow[] rowArray = set.Tables[1].Select("AttributeId=" + item.AttributeId.ToString()); foreach (DataRow row2 in rowArray) { AttributeValueInfo info2 = new AttributeValueInfo { ValueId = (int) row2["ValueId"], AttributeId = item.AttributeId }; if (row2["ImageUrl"] != DBNull.Value) { info2.ImageUrl = (string) row2["ImageUrl"]; } info2.ValueStr = (string) row2["ValueStr"]; item.AttributeValues.Add(info2); } } list.Add(item); } } return list; }
public static IList<AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { return ProductProvider.Instance().GetAttributes(typeId, attributeUseageMode); }
public abstract IList <AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode);
public static IList<AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode) { return new AttributeDao().GetAttributes(typeId, attributeUseageMode); }
public abstract IList<AttributeInfo> GetAttributes(int typeId, AttributeUseageMode attributeUseageMode);
public abstract IList <AttributeInfo> GetAttributes(AttributeUseageMode attributeUseageMode);