/// <summary> /// »ñµÃÊý¾ÝÁбí /// </summary> public List <Model.contents.article_albums> GetList(int article_id) { List <Model.contents.article_albums> modelList = new List <Model.contents.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,thumb_path,original_path,remark,add_time "); strSql.Append(" FROM " + databaseprefix + "article_albums "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.contents.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.contents.article_albums(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["thumb_path"] != null && dt.Rows[n]["thumb_path"].ToString() != "") { model.thumb_path = dt.Rows[n]["thumb_path"].ToString(); } if (dt.Rows[n]["original_path"] != null && dt.Rows[n]["original_path"].ToString() != "") { model.original_path = dt.Rows[n]["original_path"].ToString(); } if (dt.Rows[n]["remark"] != null && dt.Rows[n]["remark"].ToString() != "") { model.remark = dt.Rows[n]["remark"].ToString(); } if (dt.Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(dt.Rows[0]["add_time"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// ��������б� /// </summary> public List<Model.contents.article_albums> GetList(int article_id) { List<Model.contents.article_albums> modelList = new List<Model.contents.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,thumb_path,original_path,remark,add_time "); strSql.Append(" FROM " + databaseprefix + "article_albums "); strSql.Append(" where article_id=" + article_id); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.contents.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.contents.article_albums(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["article_id"] != null && dt.Rows[n]["article_id"].ToString() != "") { model.article_id = int.Parse(dt.Rows[n]["article_id"].ToString()); } if (dt.Rows[n]["thumb_path"] != null && dt.Rows[n]["thumb_path"].ToString() != "") { model.thumb_path = dt.Rows[n]["thumb_path"].ToString(); } if (dt.Rows[n]["original_path"] != null && dt.Rows[n]["original_path"].ToString() != "") { model.original_path = dt.Rows[n]["original_path"].ToString(); } if (dt.Rows[n]["remark"] != null && dt.Rows[n]["remark"].ToString() != "") { model.remark = dt.Rows[n]["remark"].ToString(); } if (dt.Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(dt.Rows[0]["add_time"].ToString()); } modelList.Add(model); } } return modelList; }