public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string productCode = Request.QueryString["productCode"] ?? ""; decimal minLimited = 100000; decimal maxLimited = 100000; decimal assemblyTime = 3600; if (Request.QueryString["minLimited"] != null && Request.QueryString["minLimited"] != "") { minLimited = decimal.Parse(Request.QueryString["minLimited"]); } if (Request.QueryString["maxLimited"] != null && Request.QueryString["maxLimited"] != "") { maxLimited = decimal.Parse(Request.QueryString["maxLimited"]); } if (Request.QueryString["assemblyTime"] != null && Request.QueryString["assemblyTime"] != "") { assemblyTime = decimal.Parse(Request.QueryString["assemblyTime"]); } ExportParam ep = new ExportParam(); ep.DT1 = ProductWarningService.GetProductWarning(page, rows, productCode, minLimited, maxLimited, assemblyTime); ep.HeadTitle1 = "产品预警信息设置"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string unitListCode = Request.QueryString["unitListCode"]; string unitListName = Request.QueryString["unitListName"]; string uniformCode = Request.QueryString["uniformCode"]; string unitCode1 = Request.QueryString["unitCode1"]; string unitCode2 = Request.QueryString["unitCode2"]; string unitCode3 = Request.QueryString["unitCode3"]; string unitCode4 = Request.QueryString["unitCode4"]; string isActive = Request.QueryString["isActive"]; UnitList unitlist = new UnitList(); unitlist.UnitListCode = unitListCode; unitlist.UnitListName = unitListName; unitlist.UniformCode = uniformCode; unitlist.UnitCode01 = unitCode1; unitlist.UnitCode02 = unitCode2; unitlist.UnitCode03 = unitCode3; unitlist.UnitCode04 = unitCode4; unitlist.IsActive = isActive; ExportParam ep = new ExportParam(); ep.DT1 = UnitListService.GetUnitList(page, rows, unitlist); ep.HeadTitle1 = "单位系列"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string orderId = Request.QueryString["orderId"]; ExportParam ep = new ExportParam(); ep.DT1 = SortOrderDetailService.GetSortOrderDetail(page, rows, orderId); ep.HeadTitle1 = "分拣订单管理"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string type = Request.QueryString["type"]; string id = Request.QueryString["id"]; ExportParam ep = new ExportParam(); ep.DT1 = CargospaceService.GetCargospace(page, rows, type, id); ep.HeadTitle1 = "货位库存查询"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string queryString = Request.QueryString["queryString"]; string value = Request.QueryString["value"]; ExportParam ep = new ExportParam(); ep.DT1 = CellService.GetCellByE(page, rows, queryString, value); ep.HeadTitle1 = "储位卷烟预设"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string orderDate = Request.QueryString["orderDate"]; string sortingLineCode = Request.QueryString["sortingLineCode"]; ExportParam ep = new ExportParam(); ep.DT1 = SortOrderDispatchService.GetSortOrderDispatch(page, rows, orderDate, sortingLineCode); ep.HeadTitle1 = "分拣线路调度"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string jobCode = Request.QueryString["jobCode"]; string jobName = Request.QueryString["jobName"]; string isActive = Request.QueryString["isActive"]; ExportParam ep = new ExportParam(); ep.DT1 = JobService.GetJob(page, rows, jobCode, jobName, isActive); ep.HeadTitle1 = "岗位信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string supplierCode = Request.QueryString["supplierCode"]; string supplierName = Request.QueryString["supplierName"]; string isActive = Request.QueryString["isActive"]; ExportParam ep = new ExportParam(); ep.DT1 = SupplierService.GetSupplier(page, rows, supplierCode, supplierName, isActive); ep.HeadTitle1 = "厂商信息"; return PrintService.Print(ep); }
public static FileStreamResult Print(ExportParam ep) { try { MemoryStream ms = ExportExcel.ExportDT(ep); return new FileStreamResult(ms, ep.StreamType); } catch (Exception) { return new FileStreamResult(new MemoryStream(), ep.StreamType); } }
// /ExceptionalLog/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string catchTime = Request.QueryString["catchTime"]; string moduleName = Request.QueryString["moduleName"]; string functionName = Request.QueryString["functionName"]; ExportParam ep = new ExportParam(); ep.DT1 = ExceptionalLogService.GetExceptionalLog(page, rows, catchTime, moduleName, functionName); ep.HeadTitle1 = "错误日志信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string brandCode = Request.QueryString["brandCode"]; string brandName = Request.QueryString["brandName"]; string isActive = Request.QueryString["isActive"]; ExportParam ep = new ExportParam(); ep.DT1 = BrandService.GetBrand(page, rows, brandCode, brandName, isActive); ep.HeadTitle1 = "卷烟品牌"; return PrintService.Print(ep); }
// /LoginLog/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string loginPC = Request.QueryString["loginPC"]; string loginTime = Request.QueryString["loginTime"]; string logoutTime = Request.QueryString["logoutTime"]; ExportParam ep = new ExportParam(); ep.DT1 = LoginLogService.GetLoginLog(page, rows, loginPC, loginTime, logoutTime); ep.HeadTitle1 = "登录日志信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string userName = Request.QueryString["userName"] ?? ""; string chineseName = Request.QueryString["chineseName"] ?? ""; string meMo = Request.QueryString["meMo"] ?? ""; ExportParam ep = new ExportParam(); ep.DT1 = UserService.GetUser(page, rows, userName, chineseName, meMo); ep.HeadTitle1 = "用户信息"; return PrintService.Print(ep); }
// GET: /Stockledger/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string warehouseCode = Request.QueryString["warehouseCode"]; string productCode = Request.QueryString["productCode"]; string settleDate = Request.QueryString["settleDate"]; ExportParam ep = new ExportParam(); ep.DT1 = StockledgerService.GetInfoDetail(page, rows, warehouseCode, productCode, settleDate); ep.HeadTitle1 = "库存历史总账明细"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string unitCode = Request.QueryString["unitCode"]; string unitName = Request.QueryString["unitName"]; string isActive = Request.QueryString["isActive"]; ExportParam ep = new ExportParam(); ep.DT1 = UnitService.GetUnit(page, rows, unitCode, unitName, isActive); ep.HeadTitle1 = "计量单位"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string roleName = Request.QueryString["roleName"] ?? ""; string meMo = Request.QueryString["meMo"] ?? ""; string isLock = Request.QueryString["isLock"] ?? ""; ExportParam ep = new ExportParam(); ep.DT1 = RoleService.GetRoleConten(page, rows, roleName, meMo, isLock); ep.HeadTitle1 = "角色信息"; return PrintService.Print(ep); }
// GET: /CellHistorical/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string beginDate = "null01"; string endDate = "null02"; string type = Request.QueryString["type"]; string id = Request.QueryString["id"]; ExportParam ep = new ExportParam(); ep.DT1 = CellHistoricalService.GetCellHistory(page, rows, beginDate, endDate, type, id); ep.HeadTitle1 = "货位历史明细"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string companyCode = Request.QueryString["companyCode"] ?? ""; string companyName = Request.QueryString["companyName"] ?? ""; string companyType = Request.QueryString["companyType"] ?? ""; string isActive = Request.QueryString["isActive"] ?? ""; ExportParam ep = new ExportParam(); ep.DT1 = CompanyService.GetCompany(page, rows, companyCode, companyName, companyType, isActive); ep.HeadTitle1 = "公司信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string sortingLineCode = Request.QueryString["sortingLineCode"]; string sortingLineName = Request.QueryString["sortingLineName"]; string sortingLineType = Request.QueryString["SortingLineType"]; string isActive = Request.QueryString["IsActive"]; ExportParam ep = new ExportParam(); ep.DT1 = SortingLineService.GetSortingLine(page, rows, sortingLineCode, sortingLineName, sortingLineType, isActive); ep.HeadTitle1 = "分拣线信息设置"; return PrintService.Print(ep); }
// GET: /HistoricalDetail/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string warehouseCode = Request.QueryString["warehouseCode"] ?? ""; string productCode = Request.QueryString["productCode"] ?? ""; string beginDate = Request.QueryString["beginDate"] ?? ""; string endDate = Request.QueryString["endDate"] ?? ""; ExportParam ep = new ExportParam(); ep.DT1 = HistoricalDetailService.GetHistoryDetail(page, rows, warehouseCode, productCode, beginDate, endDate); ep.HeadTitle1 = "库存历史明细"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string type = Request.QueryString["type"]; string id = Request.QueryString["id"]; string unitType = Request.QueryString["unitType"]; string productCode = Request.QueryString["productCode"]; ExportParam ep = new ExportParam(); ep.DT1 = DistributionService.GetDistribution(page, rows, type, id, unitType, productCode); ep.HeadTitle1 = "库存分布查询"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string productCode = Request.QueryString["productCode"]; string unitCode = Request.QueryString["unitCode"]; decimal minLimited = 100000; decimal maxLimited = 100000; ExportParam ep = new ExportParam(); ep.DT1 = ProductWarningService.GetQuantityLimitsDetail(page, rows, productCode, minLimited, maxLimited,unitCode); ep.HeadTitle1 = "产品超储短缺查询"; return PrintService.Print(ep); }
// /Size/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; int SizeID = Convert.ToInt32(Request.QueryString["ID"]); string SizeName = Request.QueryString["SizeName"]; Size size = new Size(); size.ID = SizeID; size.SizeName = SizeName; ExportParam ep = new ExportParam(); ep.DT1 = SizeService.GetSize(page, rows, size); ep.HeadTitle1 = "件烟尺寸信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string departmentCode = Request.QueryString["departmentCode"]; string departmentName = Request.QueryString["departmentName"]; string departmentLeaderId = Request.QueryString["departmentLeaderId"]; string companyId = Request.QueryString["companyId"]; ExportParam ep = new ExportParam(); ep.DT1 = DepartmentService.GetDepartment(page, rows, departmentCode, departmentName, departmentLeaderId, companyId); ep.HeadTitle1 = "部门信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string billTypeCode = Request.QueryString["billTypeCode"]; string billTypeName = Request.QueryString["billTypeName"]; string billClass = "0001"; string isActive = Request.QueryString["isActive"]; ExportParam ep = new ExportParam(); ep.DT1 = BillTypeService.GetBillType(page, rows, billTypeCode, billTypeName, billClass, isActive); ep.HeadTitle1 = "入库类型设置"; return PrintService.Print(ep); }
// /SystemEventLog/CreateExcelToClient/ public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string eventLogTime = Request.QueryString["eventLogTime"]; string eventName = Request.QueryString["eventName"]; string fromPC = Request.QueryString["fromPC"]; string operateUser = Request.QueryString["operateUser"]; string targetSystem = Request.QueryString["targetSystem"]; ExportParam ep = new ExportParam(); ep.DT1 = SystemEventLogService.GetSystemEventLog(page, rows, eventLogTime, eventName, fromPC, operateUser, targetSystem); ep.HeadTitle1 = "业务日志信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string AlarmCode = Request.QueryString["alarmCode"]; string Description = Request.QueryString["description"]; AlarmInfo alarmInfo=new AlarmInfo (); alarmInfo.AlarmCode = AlarmCode; alarmInfo.Description = Description; ExportParam ep = new ExportParam(); ep.DT1 = AlarmInfoService.GetAlarmInfo(page, rows, alarmInfo); ep.HeadTitle1 = "报警信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string sortingLineCode = Request.QueryString["sortingLineCode"]; string sortingLineName = Request.QueryString["sortingLineName"]; string productName = Request.QueryString["productName"]; string productCode = Request.QueryString["productCode"]; string isActive = Request.QueryString["IsActive"]; ExportParam ep = new ExportParam(); ep.DT1 = SortingLowerlimitService.GetSortingLowerlimit(page, rows, sortingLineCode, sortingLineName, productName,productCode, isActive); ep.HeadTitle1 = "备货区下限设置"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; int CellPositionID = Convert.ToInt32(Request.QueryString["ID"]); string CellCode = Request.QueryString["CellCode"]; string CellName = Request.QueryString["CellName"]; CellPosition cp = new CellPosition(); cp.ID = CellPositionID; cp.CellCode = CellCode; ExportParam ep = new ExportParam(); ep.DT1 = CellPositionService.GetCellPosition(page, rows, cp); ep.HeadTitle1 = "货位位置信息"; return PrintService.Print(ep); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string contentCode = Request.QueryString["contentCode"] ?? ""; string contentName = Request.QueryString["contentName"] ?? ""; string nodeType = Request.QueryString["nodeType"] ?? ""; string fatherNodeID = Request.QueryString["fatherNodeID"] ?? ""; string moduleID = Request.QueryString["moduleID"] ?? ""; string isActive = Request.QueryString["isActive"] ?? ""; ExportParam ep = new ExportParam(); ep.DT1 = HelpContentService.GetHelpConten(page, rows, contentCode, contentName, nodeType, fatherNodeID, moduleID, isActive); ep.HeadTitle1 = "帮助目录"; return PrintService.Print(ep); }