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());
}
