/// <summary> /// 得到一个对象实体 /// </summary> public ResultGallery DataRowToModel(DataRow row, string resouces) { ResultGallery model = new ResultGallery(); if (row != null) { if (row["Callery_ID"] != null && row["Callery_ID"].ToString() != "") { model.id = int.Parse(row["Callery_ID"].ToString()); } if (row["Callery_Customer_ID"] != null && row["Callery_Customer_ID"].ToString() != "") { model.customerId = int.Parse(row["Callery_Customer_ID"].ToString()); } if (row["Callery_Size"] != null) { model.size = row["Callery_Size"].ToString(); } if (row["Callery_Name"] != null) { model.name = row["Callery_Name"].ToString(); } if (row["Callery_ThumbnailPic"] != null) { model.thumbPicUri = row["Callery_ThumbnailPic"].ToString(); model.thumbPicUrl = resouces + model.thumbPicUri; } if (row["Callery_SmallPic"] != null) { model.smallPicUri = row["Callery_SmallPic"].ToString(); model.smallPicUrl = resouces + model.smallPicUri; } if (row["Callery_BigPic"] != null) { model.bigPicUri = row["Callery_BigPic"].ToString(); model.bigPicUrl = resouces + model.bigPicUri; } if (row["Callery_Time"] != null && row["Callery_Time"].ToString() != "") { model.createTime = DateTime.Parse(row["Callery_Time"].ToString()); } if (row["Photo_FatherID"] != null && row["Photo_FatherID"].ToString() != "") { model.groupId = int.Parse(row["Photo_FatherID"].ToString()); } } return(model); }
public HotPageData <ResultGallery[]> GetPhotoList(int customerId, int groupId, string name, int page, int pageSize) { //PdMallSystemConfigModel configModel = PdMallSystemConfigProvider.Instance.GetCurrentConfig(); //todo string resourceSiteAddr = ""; string where = ""; if (!string.IsNullOrEmpty(name)) { where += " and Callery_Name like '%" + name + "%'"; } // string sql = string.Format(@"select Callery_ID,Callery_Customer_ID,Callery_Size,Callery_Name,Callery_ThumbnailPic,Callery_SmallPic,Callery_BigPic, // Callery_Time,Callery_UpdateTime,Photo_FatherID from HQ_Gallery where Callery_Customer_ID={0} and Photo_FatherID={1} {2} order by Callery_Time desc", customerId, groupId, where); string sql = string.Format(@"select Callery_ID,Callery_Customer_ID,Callery_Size,Callery_Name,Callery_ThumbnailPic,Callery_SmallPic,Callery_BigPic, Callery_Time,Callery_UpdateTime,Photo_FatherID from HQ_Gallery where Callery_Customer_ID={0} and Photo_FatherID={1} {2} order by Callery_ID desc", customerId, groupId, where); List <ResultGallery> list = new List <ResultGallery>(); HotPageData <ResultGallery[]> dataPager = null; HotPageData <DataTable> pager = base.getPageData(sql, page, pageSize); if (pager != null) { DataTable dt = pager.Rows; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ResultGallery model = DataRowToModel(row, resourceSiteAddr); list.Add(model); } } dataPager = new HotPageData <ResultGallery[]>(); dataPager.PageCount = pager.PageCount; dataPager.PageIndex = pager.PageIndex; dataPager.PageSize = pager.PageSize; dataPager.Total = pager.Total; dataPager.Rows = list.Count > 0 ? list.ToArray() : null; } return(dataPager); }