public static XElement CreateCategoryInfo(CategoryInfo info) { return new XElement("Item", new XAttribute("ID", info.ID), new XAttribute("Name", info.Name == null ? "" : info.Name), new XAttribute("Place", info.Place), new XAttribute("Remark", info.Remark == null ? "" : info.Remark)); }
public CategoryInfo[] GetAllCategory() { List<CategoryInfo> infos = new List<CategoryInfo>(); SqlDataReader reader = null; try { db.GetReader(ref reader, "SP_Items_Category_All"); while (reader.Read()) { CategoryInfo info = new CategoryInfo(); info.ID = (int)reader["ID"]; info.Name = reader["Name"] == null ? "" : reader["Name"].ToString(); info.Place = (int)reader["Place"]; info.Remark = reader["Remark"] == null ? "" : reader["Remark"].ToString(); infos.Add(info); } } catch (Exception e) { if (log.IsErrorEnabled) log.Error("Init", e); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } return infos.ToArray(); }