Git.Storage.Web/Areas/Report/Controllers/ReportAjaxController.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Git.Framework.Controller;
using Git.Storage.Entity.Store;
using Git.Storage.Provider.Store;
using Git.Storage.Web.Lib.Filter;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Git.Framework.DataTypes.ExtensionMethods;
using Git.Framework.ORM;
using Git.Framework.DataTypes;
using Git.Framework.Json;
using Git.Storage.Web.Lib;
using System.Data;
using Git.Storage.Common.Excel;
using Git.Framework.Controller.Mvc;
using Git.Storage.Provider;
using Git.Storage.Common;
using Storage.Common;
using System.Xml;
using Git.Storage.Entity.InStorage;
using Git.Storage.Provider.InStorage;
using Git.Storage.Entity.OutStorage;
using Git.Storage.Provider.OutStorage;
using Git.Storage.Provider.Client;
using Git.Storage.Entity.Bad;
using Git.Storage.Provider.Bad;
using Git.Storage.Provider.Returns;
using Git.Storage.Entity.Return;
using Aspose.Cells;
using System.Text;
using Git.Storage.Entity.Report;
using Git.Framework.Cache;

namespace Git.Storage.Web.Areas.Report.Controllers
{
    public class ReportAjaxController : AjaxPage
    {
        /// <summary>
        /// 查询产品类别分页
        /// </summary>
        /// <returns></returns>
        [LoginAjaxFilter]
        public ActionResult ProductReportList()
        {
            string searchKey = WebUtil.GetFormValue<string>("ProductName", string.Empty);
            string beginTime = WebUtil.GetFormValue<string>("BeginTime", string.Empty);
            string endTime = WebUtil.GetFormValue<string>("EndTime", string.Empty);
            int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 0);
            int pageSize = WebUtil.GetFormValue<int>("pageSize", 0);
            string storageNum = this.DefaultStore;
            ProductProvider provider = new ProductProvider();
            ProductEntity entity = new ProductEntity();
            entity.StorageNum = storageNum;
            if (!searchKey.IsEmpty())
            {
                entity.Begin<ProductEntity>()
                 .Where<ProductEntity>("ProductName", ECondition.Like, "%" + searchKey + "%")
                 .Or<ProductEntity>("SnNum", ECondition.Like, "%" + searchKey + "%")