private void BindImageData()
{
int type = Globals.RequestQueryNum("type");
this.pageIndex = this.pager.PageIndex;
this.orderby = Globals.RequestQueryNum("orderby");
switch (this.orderby)
{
case 0:
case 1:
case 2:
case 3:
case 4:
case 5:
case 6:
case 7:
this.ImageOrder.SelectedValue = new int?(this.orderby);
break;
}
PhotoListOrder order = (PhotoListOrder)Enum.ToObject(typeof(PhotoListOrder), this.orderby);
DbQueryResult result = GalleryHelper.GetPhotoList(this.keyWordIName, this.typeId, this.pageIndex, order, type, 0x12);
this.rptList.DataSource = result.Data;
this.rptList.DataBind();
this.pager.TotalRecords = result.TotalRecords;
this.lblImageData.Text = this.pager.TotalRecords.ToString();
}
public string GetListJson(HttpContext context)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("{\"status\":1,");
stringBuilder.Append("\"data\":[");
int num = 1;
PhotoListOrder order = PhotoListOrder.UpdateTimeDesc;
if (!string.IsNullOrEmpty(context.Request.Form["sortby"]))
{
order = (PhotoListOrder)Enum.Parse(typeof(PhotoListOrder), context.Request.Form["sortby"]);
}
int supplierId = 0;
if (!string.IsNullOrEmpty(context.Request.Form["supplierId"]))
{
supplierId = context.Request.Form["supplierId"].ToInt(0);
}
DbQueryResult photoList = GalleryHelper.GetPhotoList(context.Request.Form["file_Name"], context.Request.Form["id"].ToInt(0), context.Request.Form["p"].ToInt(0), 36, order, supplierId);
int pageCount = TemplatePageControl.GetPageCount(photoList.TotalRecords, 36);
stringBuilder.Append(this.GetImgItemsJson(photoList, context));
string str = stringBuilder.ToString().TrimEnd(',');
str += "],";
str = str + "\"page\": \"" + this.GetPageHtml(pageCount, context) + "\",";
str += "\"msg\": \"\"";
return(str + "}");
}
private void BindImageData()
{
this.pageIndex = this.pager.PageIndex;
PhotoListOrder order = PhotoListOrder.UploadTimeDesc;
DbQueryResult photoList = GalleryHelper.GetPhotoList(this.keyWordIName, this.typeId, this.pageIndex, order, 0, 20);
this.photoDataList.DataSource = photoList.Data;
this.photoDataList.DataBind();
this.pager.TotalRecords = photoList.TotalRecords;
}
public static DbQueryResult GetPhotoList(string keyword, int? categoryId, int pageIndex, PhotoListOrder order)
{
Pagination page = new Pagination {
PageSize = 20,
PageIndex = pageIndex,
IsCount = true
};
switch (order)
{
case PhotoListOrder.UploadTimeDesc:
page.SortBy = "UploadTime";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UploadTimeAsc:
page.SortBy = "UploadTime";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.NameAsc:
page.SortBy = "PhotoName";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.NameDesc:
page.SortBy = "PhotoName";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UpdateTimeDesc:
page.SortBy = "LastUpdateTime";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UpdateTimeAsc:
page.SortBy = "LastUpdateTime";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.SizeDesc:
page.SortBy = "FileSize";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.SizeAsc:
page.SortBy = "FileSize";
page.SortOrder = SortAction.Asc;
break;
}
return new PhotoGalleryDao().GetPhotoList(keyword, categoryId, page);
}
private void BindImageData()
{
this.pageIndex = this.pager.PageIndex;
PhotoListOrder uploadTimeDesc = PhotoListOrder.UploadTimeDesc;
if (this.enumOrder.HasValue)
{
uploadTimeDesc = (PhotoListOrder)Enum.ToObject(typeof(PhotoListOrder), this.enumOrder.Value);
}
DbQueryResult result = GalleryHelper.GetPhotoList(this.keyWordIName, this.typeId, this.pageIndex, uploadTimeDesc);
this.photoDataList.DataSource = result.Data;
this.photoDataList.DataBind();
this.pager.TotalRecords = result.TotalRecords;
this.lblImageData.Text = "共" + this.pager.TotalRecords + "张";
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, int pageSize, PhotoListOrder order, int type)
{
Pagination pagination = new Pagination()
{
PageSize = pageSize,
PageIndex = pageIndex,
IsCount = true
};
switch (order)
{
case PhotoListOrder.UploadTimeDesc:
{
pagination.SortBy = "UploadTime";
pagination.SortOrder = SortAction.Desc;
break;
}
case PhotoListOrder.UploadTimeAsc:
{
pagination.SortBy = "UploadTime";
pagination.SortOrder = SortAction.Asc;
break;
}
case PhotoListOrder.NameAsc:
{
pagination.SortBy = "PhotoName";
pagination.SortOrder = SortAction.Asc;
break;
}
case PhotoListOrder.NameDesc:
{
pagination.SortBy = "PhotoName";
pagination.SortOrder = SortAction.Desc;
break;
}
case PhotoListOrder.UpdateTimeDesc:
{
pagination.SortBy = "LastUpdateTime";
pagination.SortOrder = SortAction.Desc;
break;
}
case PhotoListOrder.UpdateTimeAsc:
{
pagination.SortBy = "LastUpdateTime";
pagination.SortOrder = SortAction.Asc;
break;
}
case PhotoListOrder.SizeDesc:
{
pagination.SortBy = "FileSize";
pagination.SortOrder = SortAction.Desc;
break;
}
case PhotoListOrder.SizeAsc:
{
pagination.SortBy = "FileSize";
pagination.SortOrder = SortAction.Asc;
break;
}
}
return((new PhotoGalleryDao()).GetPhotoList(keyword, categoryId, pagination, type));
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, PhotoListOrder order, int type, int pagesize = 20)
{
DbQueryResult photoList = GalleryHelper.GetPhotoList(keyword, categoryId, pageIndex, pagesize, order, type);
return(photoList);
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, PhotoListOrder order, int type, int pagesize = 20)
{
return(GetPhotoList(keyword, categoryId, pageIndex, pagesize, order, type));
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, PhotoListOrder order, int type, [Optional, DefaultParameterValue(20)] int pagesize)
{
return(GetPhotoList(keyword, categoryId, pageIndex, pagesize, order, type));
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, int pageSize, PhotoListOrder order, int supplierId = 0)
{
Pagination pagination = new Pagination();
pagination.PageSize = pageSize;
pagination.PageIndex = pageIndex;
pagination.IsCount = true;
switch (order)
{
case PhotoListOrder.NameAsc:
pagination.SortBy = "PhotoName";
pagination.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.NameDesc:
pagination.SortBy = "PhotoName";
pagination.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.SizeAsc:
pagination.SortBy = "FileSize";
pagination.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.SizeDesc:
pagination.SortBy = "FileSize";
pagination.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UpdateTimeAsc:
pagination.SortBy = "LastUpdateTime";
pagination.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.UpdateTimeDesc:
pagination.SortBy = "LastUpdateTime";
pagination.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UploadTimeAsc:
pagination.SortBy = "UploadTime";
pagination.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.UploadTimeDesc:
pagination.SortBy = "UploadTime";
pagination.SortOrder = SortAction.Desc;
break;
}
return(new PhotoGalleryDao().GetPhotoList(keyword, categoryId, pagination, supplierId));
}
private DataGridViewModel <Dictionary <string, object> > GetListPhoto(string keyWordName, int typeId, int pageIndex, int pageSize, PhotoListOrder enumOrd)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
DbQueryResult photoList = GalleryHelper.GetPhotoList(keyWordName, typeId, pageIndex, pageSize, enumOrd, 0);
List <Dictionary <string, object> > list = DataHelper.DataTableToDictionary(photoList.Data);
foreach (Dictionary <string, object> item in list)
{
PhotoGalleryInfo photoGalleryInfo = item.ToObject <PhotoGalleryInfo>();
item.Add("Globals", Globals.GetImageServerUrl());
item.Add("SubPhotoName", GalleryHelper.TruncStr(photoGalleryInfo.PhotoName, 20));
}
dataGridViewModel.rows = list;
dataGridViewModel.total = photoList.TotalRecords;
return(dataGridViewModel);
}
public static DbQueryResult GetPhotoList(string keyword, int?categoryId, int pageIndex, PhotoListOrder order)
{
Pagination page = new Pagination();
page.PageSize = 20;
page.PageIndex = pageIndex;
page.IsCount = true;
switch (order)
{
case PhotoListOrder.UploadTimeDesc:
page.SortBy = "UploadTime";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UploadTimeAsc:
page.SortBy = "UploadTime";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.NameAsc:
page.SortBy = "PhotoName";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.NameDesc:
page.SortBy = "PhotoName";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UpdateTimeDesc:
page.SortBy = "LastUpdateTime";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.UpdateTimeAsc:
page.SortBy = "LastUpdateTime";
page.SortOrder = SortAction.Asc;
break;
case PhotoListOrder.SizeDesc:
page.SortBy = "FileSize";
page.SortOrder = SortAction.Desc;
break;
case PhotoListOrder.SizeAsc:
page.SortBy = "FileSize";
page.SortOrder = SortAction.Asc;
break;
}
return(GalleryProvider.Instance().GetPhotoList(keyword, categoryId, page));
}
