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);
        }
Esempio n. 3
0
        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));
        }
Esempio n. 4
0
 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));
 }