private void GetList(HttpContext context) { int num = 1; int num2 = 10; num = base.GetIntParam(context, "page", false).Value; if (num < 1) { num = 1; } num2 = base.GetIntParam(context, "rows", false).Value; if (num2 < 1) { num2 = 10; } MarketingImagesQuery marketingImagesQuery = new MarketingImagesQuery(); marketingImagesQuery.ImageName = context.Request["ImageName"]; marketingImagesQuery.PageIndex = num; marketingImagesQuery.PageSize = num2; marketingImagesQuery.SortBy = "ImageId"; marketingImagesQuery.SortOrder = SortAction.Desc; DataGridViewModel <MarketingImagesInfo> dataList = this.GetDataList(marketingImagesQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
private DataGridViewModel <MarketingImagesInfo> GetDataList(MarketingImagesQuery query) { DataGridViewModel <MarketingImagesInfo> dataGridViewModel = new DataGridViewModel <MarketingImagesInfo>(); if (query != null) { PageModel <MarketingImagesInfo> marketingImages = MarketingImagesHelper.GetMarketingImages(query); dataGridViewModel.rows = marketingImages.Models.ToList(); dataGridViewModel.total = marketingImages.Total; } return(dataGridViewModel); }
public PageModel <MarketingImagesInfo> GetMarketingImages(MarketingImagesQuery query) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendFormat(" 1 = 1 "); if (!string.IsNullOrEmpty(query.ImageName)) { stringBuilder.AppendFormat(" AND (ImageName LIKE '%{0}%' OR Description LIKE '%{0}%')", DataHelper.CleanSearchString(query.ImageName)); } string selectFields = "*"; return(DataHelper.PagingByRownumber <MarketingImagesInfo>(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Hishop_MarketingImages", "ImageId", stringBuilder.ToString(), selectFields)); }
public override void OnLoad(HttpContext context) { base.OnLoad(context); if (context.Request["flag"] == "Select") { int storeId = base.CurrentManager.StoreId; int num = context.Request["pageIndex"].ToInt(0); if (num <= 0) { num = 1; } int num2 = context.Request["pageSize"].ToInt(0); if (num2 < 1) { num2 = 10; } MarketingImagesQuery marketingImagesQuery = new MarketingImagesQuery(); marketingImagesQuery.PageIndex = num; marketingImagesQuery.PageSize = num2; marketingImagesQuery.SortOrder = SortAction.Desc; marketingImagesQuery.SortBy = "ImageId"; PageModel <MarketingImagesInfo> marketingImages = MarketingImagesHelper.GetMarketingImages(marketingImagesQuery); string s = JsonConvert.SerializeObject(new { Result = new { RecordCount = marketingImages.Total, List = from i in marketingImages.Models select new { ImageId = i.ImageId, ImageName = i.ImageName, ImageUrl = this.GetImageFullPath(i.ImageUrl), Description = i.Description } } }); context.Response.Write(s); context.Response.End(); } if (context.Request["flag"] == "Mdy") { int storeId2 = base.CurrentManager.StoreId; int imageId = context.Request["ImageId"].ToInt(0); string idList = context.Request["ProductIds"].ToNullString(); MarketingImagesInfo marketingImagesInfo = MarketingImagesHelper.GetMarketingImagesInfo(imageId); if (marketingImagesInfo == null) { context.Response.Write(this.GetErrorJosn(701, ((Enum)(object)ApiErrorCode.ImageIdNotExists_Error).ToDescription())); } else { idList = Globals.GetSafeIDList(idList, ',', true); if (string.IsNullOrEmpty(idList)) { context.Response.Write(this.GetErrorJosn(101, ((Enum)(object)ApiErrorCode.Paramter_Error).ToDescription())); } else { StoreMarketingImagesInfo storeMarketingImagesInfo = MarketingImagesHelper.GetStoreMarketingImages(storeId2, imageId); string text = ""; if (storeMarketingImagesInfo != null) { string safeIDList = Globals.GetSafeIDList(storeMarketingImagesInfo.ProductIds, ',', true); if (safeIDList != "") { string[] array = idList.Split(','); foreach (string str in array) { if (!("," + safeIDList + ",").Contains("," + str + ",")) { text = text + str + ","; } } } } else { storeMarketingImagesInfo = new StoreMarketingImagesInfo(); storeMarketingImagesInfo.StoreId = storeId2; storeMarketingImagesInfo.ImageId = imageId; } if (!string.IsNullOrEmpty(text)) { StoreMarketingImagesInfo storeMarketingImagesInfo2 = storeMarketingImagesInfo; storeMarketingImagesInfo2.ProductIds += ("," + text).TrimEnd(','); } else { storeMarketingImagesInfo.ProductIds = idList.TrimEnd(','); } MarketingImagesHelper.UpdateStoreMarketingImages(storeMarketingImagesInfo); string s2 = JsonConvert.SerializeObject(new { Result = new { Success = new { Status = true, Msg = string.Empty } } }); context.Response.Write(s2); context.Response.End(); } } } }
public static PageModel <MarketingImagesInfo> GetMarketingImages(MarketingImagesQuery query) { return(new MarketingImagesDao().GetMarketingImages(query)); }