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