public static PagingDataSet <ArticleAttachment> GetAttachments(AttachmentQuery query) { int totalRecods; List <ArticleAttachment> attachmentList = ArticleAttachmentProvider.Instance.GetAllArticleAttachments(query, out totalRecods); PagingDataSet <ArticleAttachment> articles = new PagingDataSet <ArticleAttachment>(); articles.Records = attachmentList; articles.TotalRecords = totalRecods; return(articles); }
public TList <Attachment> GetAttachmentByFormID(string FormID) { AttachmentService rs = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); query.AppendEquals(string.Empty, AttachmentColumn.FormId, FormID); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(rs.Find(query.GetParameters(), sort.GetSortColumns())); }
public TList <Attachment> GetAttachmentByFormID(string FormID, Pkurg.PWorld.Entities.Employee currentEmployee) { AttachmentService rs = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); query.AppendEquals(string.Empty, AttachmentColumn.FormId, FormID); query.AppendEquals("and", AttachmentColumn.CreateByUserCode, currentEmployee.EmployeeCode); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(rs.Find(query.GetParameters(), sort.GetSortColumns())); }
private void BindArticleAttachment() { AttachmentQuery aq = new AttachmentQuery(); PagingDataSet <ArticleAttachment> items = ArticleAttachments.GetAttachments(aq); ddlArticleImages.DataTextField = "Name"; ddlArticleImages.DataValueField = "ID"; ddlArticleImages.DataSource = items.Records; ddlArticleImages.DataBind(); try { ddlArticleImages.Items.Insert(0, new ListItem(string.Empty, string.Empty)); ddlArticleImages.SelectedIndex = 0; } catch { } }
/// <summary> /// 得到附件信息列表 /// </summary> /// <returns></returns> public TList <Attachment> GetAttachmentList() { AttachmentService service = new AttachmentService(); AttachmentQuery query = new AttachmentQuery(); query.Clear(); SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>(); sort.AppendASC(AttachmentColumn.CreateAtTime); return(service.Find(query.GetParameters(), sort.GetSortColumns())); }
public override List <ArticleAttachment> GetAllArticleAttachments(AttachmentQuery query, out int totalRecord) { ELParameter[] elParameters = new ELParameter[] { new ELParameter("@PageIndex", DbType.Int32, DataHelper.GetSafeSqlInt(query.PageIndex)), new ELParameter("@PageSize", DbType.Int32, DataHelper.GetSafeSqlInt(query.PageSize)), new ELParameter("@SqlPopulate", DbType.String, QueryGenerator.BuildAttachmentQuery(query)) }; using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleAttachments_Get", elParameters)) { List <ArticleAttachment> attachmentList = new List <ArticleAttachment>(); while (dr.Read()) { attachmentList.Add(ArticleReaderConverter.ParseArticleAttachment(dr)); } dr.NextResult(); dr.Read(); totalRecord = DataRecordHelper.GetInt32(dr, 0); return(attachmentList); } }
void WritePics() { AttachmentQuery aq = new AttachmentQuery(); List <ArticleAttachment> items = ArticleAttachments.GetAttachments(aq).Records; if (items != null && items.Count > 0) { StringBuilder sb = new StringBuilder(); foreach (ArticleAttachment a in items) { if (a.IsRemote) { sb.Append("item" + a.ID.ToString() + ":'" + a.FileName + "',"); } else { sb.Append("item" + a.ID.ToString() + ":'" + a.GetDefaultImageUrl(40, 40) + "',"); } } ArticleAttachment aa = items[0]; imgTitleImg.ImageUrl = (aa.IsRemote ? aa.FileName : aa.GetDefaultImageUrl(40, 40)); base.ExecuteJs("var titlePics = {" + sb.ToString().Remove(sb.ToString().Length - 1) + "};", true); } }
private void BindData() { AttachmentQuery query = AttachmentQuery.GetQueryFromQueryString(Request.QueryString); btnAll.CssClass = string.Empty; lblTip.Text = string.Empty; // 判断名称 if (!string.IsNullOrEmpty(query.Name)) { lblTip.Text = "名称中包含“" + query.Name + "”"; } // 判断大小 if (query.ContentStartSize.HasValue) { if (!string.IsNullOrEmpty(lblTip.Text)) { lblTip.Text += ";"; } lblTip.Text += "大小大于" + query.ContentStartSize.Value + "字节"; } if (query.ContentEndSize.HasValue) { if (!string.IsNullOrEmpty(lblTip.Text)) { lblTip.Text += ";"; } lblTip.Text += "大小小于" + query.ContentEndSize.Value + "字节"; } // 判断日期 if (query.CreateStartTime.HasValue) { if (!string.IsNullOrEmpty(lblTip.Text)) { lblTip.Text += ";"; } lblTip.Text += "上传日期从“" + query.CreateStartTime.Value.ToShortDateString() + "”开始"; } if (query.CreateEndTime.HasValue) { if (!string.IsNullOrEmpty(lblTip.Text)) { lblTip.Text += ";"; } lblTip.Text += "上传日期到“" + query.CreateEndTime.Value.ToShortDateString() + "”截止"; } if (string.IsNullOrEmpty(lblTip.Text)) { lblTip.Text = "全部"; btnAll.CssClass = "active"; } query.PageSize = egvAttachments.PageSize; query.PageIndex = egvAttachments.PageIndex; PagingDataSet <ArticleAttachment> products = ArticleAttachments.GetAttachments(query); egvAttachments.DataSource = products.Records; egvAttachments.DataBind(); }
public abstract List <ArticleAttachment> GetAllArticleAttachments(AttachmentQuery query, out int totalRecord);
public static string BuildAttachmentQuery(AttachmentQuery query) { StringBuilder sb = new StringBuilder(); sb.Append("SET Transaction Isolation Level Read UNCOMMITTED "); SelectQueryBuilder builder = new SelectQueryBuilder(); builder.SelectFromTable("NAttachment"); builder.SelectColumns("AttachmentID"); builder.AddWhere("AttachmentStatus", Comparison.GreaterThan, 0); if (query.Name != null) { builder.AddWhere("AttachmentName", Comparison.Like, "%" + query.Name + "%"); } if (query.ContentType != null) { builder.AddWhere("ContentType", Comparison.Like, "%" + query.ContentType + "%"); } if (query.ContentStartSize.HasValue) { builder.AddWhere("ContentSize", Comparison.GreaterOrEquals, query.ContentStartSize); } if (query.ContentEndSize.HasValue) { builder.AddWhere("ContentSize", Comparison.LessOrEquals, query.ContentEndSize); } if (query.CreateStartTime.HasValue) { builder.AddWhere("CreateTime", Comparison.GreaterOrEquals, query.CreateStartTime); } if (query.CreateEndTime.HasValue) { builder.AddWhere("CreateTime", Comparison.LessOrEquals, query.CreateEndTime); } // 添加OrderBy switch (query.AttachmentOrderBy) { case HHOnline.News.enums.AttachmentOrderBy.ContentSize: builder.AddOrderBy("ContentSize", (Sorting)query.SortOrder); break; case HHOnline.News.enums.AttachmentOrderBy.ContentType: builder.AddOrderBy("ContentType", (Sorting)query.SortOrder); break; case HHOnline.News.enums.AttachmentOrderBy.CreateTime: builder.AddOrderBy("CreateTime", (Sorting)query.SortOrder); break; case HHOnline.News.enums.AttachmentOrderBy.Name: builder.AddOrderBy("Name", (Sorting)query.SortOrder); break; case HHOnline.News.enums.AttachmentOrderBy.UpdateTime: builder.AddOrderBy("UpdateTime", (Sorting)query.SortOrder); break; } return(builder.BuildQuery()); }