コード例 #1
0
        public ActionResult Search(int pageSize, int pageIndex = 0, string orderBy = "", bool desc = false)
        {
            //if (DateTime.Now <= Convert.ToDateTime("2017-12-31"))
            //{
            //    if (StringHelper.isNullOrEmpty(orderBy))
            //    {
            //        orderBy = "UpdateTime";
            //        desc = true;
            //    }
            //    int recordCount = 0;
            //    LotQuery queryFromRequest = QueryUtility.GetQueryFromRequest(base.Request, BaseController.CurrentUserInfo.UserID);
            //    if ((BaseController.CurrentUserInfo.Role == UserRoles.OSAT) || (BaseController.CurrentUserInfo.Role == UserRoles.OSATAdmin))
            //    {
            //        queryFromRequest.Osat = BaseController.CurrentUserInfo.BUName;
            //    }
            //    IList<LotView> list = LotService.GetLotViews(queryFromRequest, orderBy, desc, pageIndex, pageSize, out recordCount);
            //    string s = JsonConvert.SerializeObject(new { currentPage = pageIndex, totalPages = PagerUtility.GetPageCount(recordCount, pageSize), rows = list });
            //    base.Response.Write(s);
            //}
            //return null;
            if (StringHelper.isNullOrEmpty(orderBy))
            {
                orderBy = "UpdateTime";
                desc    = true;
            }
            int      recordCount      = 0;
            LotQuery queryFromRequest = QueryUtility.GetQueryFromRequest(base.Request, BaseController.CurrentUserInfo.UserID);

            if (BaseController.CurrentUserInfo.Role == UserRoles.OSAT || BaseController.CurrentUserInfo.Role == UserRoles.OSATAdmin)
            {
                queryFromRequest.Osat = BaseController.CurrentUserInfo.BUName;
            }
            IList <LotView> lotViews = LotService.GetLotViews(queryFromRequest, orderBy, desc, pageIndex, pageSize, out recordCount);

            foreach (LotView lv in lotViews)
            {
                lv.HoldReason = lv.HoldReason.Replace("failed sublot:", "");
            }
            string s = JsonConvert.SerializeObject(new
            {
                currentPage = pageIndex,
                totalPages  = PagerUtility.GetPageCount(recordCount, pageSize),
                rows        = lotViews
            });

            base.Response.Write(s);
            return(null);
        }
コード例 #2
0
        public ActionResult ExportLots(string orderBy, bool desc)
        {
            int    recordCount = 0;
            string xlsName     = string.Format("LOTS_{0}", DateTime.Now.ToString("yyyyMMdd_hhmmss"));

            if (StringHelper.isNullOrEmpty(orderBy))
            {
                orderBy = "CreateTime";
                desc    = true;
            }
            IList <LotView> tList       = LotService.GetLotViews(QueryUtility.GetQueryFromRequest(base.Request, BaseController.CurrentUserInfo.UserID), orderBy, desc, 0, 0xf423f, out recordCount);
            string          nextUrl     = Exporthelper.GetExport <LotView>("LOTS", tList, "/Export/Excels/Lots/", "/Content/Exports/ExportLots.xml", xlsName, 0, 0);
            ResponseTypes   redirect    = ResponseTypes.Redirect;
            TipTypes        information = TipTypes.Information;

            base.Response.Write(new HandlerResponse("0", "导出Excel文件", redirect.ToString(), information.ToString(), nextUrl, "", "").GenerateJsonResponse());
            return(null);
        }