/// <summary> /// »ñµÃÊý¾ÝÁбí /// </summary> public List <Model.article_albums> GetList(int article_id, int Top) { List <Model.article_albums> modelList = new List <Model.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" id,article_id,thumb_path,original_path,remark,add_time,link_url "); strSql.Append(" FROM " + databaseprefix + "article_albums "); strSql.Append(" where article_id=" + article_id); strSql.Append(" order by add_time desc"); DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0]; int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.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[n]["link_url"] != null && dt.Rows[n]["link_url"].ToString() != "") { model.link_url = dt.Rows[n]["link_url"].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.article_albums> GetList(int article_id) { List<Model.article_albums> modelList = new List<Model.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.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.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.article_albums> GetList(int article_id) { List <Model.article_albums> modelList = new List <Model.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,big_img,small_img,remark "); strSql.Append(" FROM dt_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.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.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]["big_img"] != null && dt.Rows[n]["big_img"].ToString() != "") { model.big_img = dt.Rows[n]["big_img"].ToString(); } if (dt.Rows[n]["small_img"] != null && dt.Rows[n]["small_img"].ToString() != "") { model.small_img = dt.Rows[n]["small_img"].ToString(); } if (dt.Rows[n]["remark"] != null && dt.Rows[n]["remark"].ToString() != "") { model.remark = dt.Rows[n]["remark"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 将对象转换实体 /// </summary> public Model.article_albums DataRowToModel(DataRow row) { Model.article_albums model = new Model.article_albums(); if (row != null) { //利用反射获得属性的所有公共属性 Type modelType = model.GetType(); for (int i = 0; i < row.Table.Columns.Count; i++) { //查找实体是否存在列表相同的公共属性 PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName); if (proInfo != null && row[i] != DBNull.Value) { proInfo.SetValue(model, row[i], null);//用索引值设置属性值 } } } return(model); }
/// <summary> /// 返回对象实体 /// </summary> public Model.article_albums GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,thumb_path,original_path,remark,add_time,category_id,img_size "); strSql.Append(" FROM dt_article_albums where article_id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.article_albums model = new Model.article_albums(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { string original_path = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model.id = int.Parse(ds.Tables[0].Rows[i]["id"].ToString()); model.article_id = int.Parse(ds.Tables[0].Rows[i]["article_id"].ToString()); model.thumb_path = ds.Tables[0].Rows[i]["thumb_path"].ToString(); original_path += ds.Tables[0].Rows[i]["original_path"].ToString() + ","; if (ds.Tables[0].Rows[i]["remark"].ToString() != "") { model.remark = ds.Tables[0].Rows[i]["remark"].ToString(); } if (ds.Tables[0].Rows[i]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[i]["add_time"].ToString()); } model.category_id = int.Parse(ds.Tables[0].Rows[i]["category_id"].ToString()); model.img_size = ds.Tables[0].Rows[i]["img_size"].ToString(); } model.original_path = original_path.Substring(0, original_path.Length - 1); return(model); } else { return(null); } }
/// <summary> /// »ñµÃÊý¾ÝÁбí /// </summary> public List<Model.article_albums> GetList(int article_id) { List<Model.article_albums> modelList = new List<Model.article_albums>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,article_id,big_img,small_img,remark "); strSql.Append(" FROM dt_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.article_albums model; for (int n = 0; n < rowsCount; n++) { model = new Model.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]["big_img"] != null && dt.Rows[n]["big_img"].ToString() != "") { model.big_img = dt.Rows[n]["big_img"].ToString(); } if (dt.Rows[n]["small_img"] != null && dt.Rows[n]["small_img"].ToString() != "") { model.small_img = dt.Rows[n]["small_img"].ToString(); } if (dt.Rows[n]["remark"] != null && dt.Rows[n]["remark"].ToString() != "") { model.remark = dt.Rows[n]["remark"].ToString(); } modelList.Add(model); } } return modelList; }