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); }
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); }