旧版报表、仓库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

453 lines
17 KiB

using JHReport.DAL;
using System.Collections.Generic;
using System.Data;
namespace JHReport.BLL
{
public class ReportService
{
public DataTable JKQueryInfo(string saleorder, string lot)
{
return new ReportDal().JKQueryInfo(saleorder,lot);
}
public IEnumerable<dynamic> JKQueryInfoAPI(string saleorder, string lot)
{
return new ReportDal().JKQueryInfoAPI(saleorder, lot);
}
public DataTable TestDataDetailQueryInfo(string lot, string wo, string bt, string et, string workshop,string pallet_nb, string sale_order, string containerno, string check_nbr)
{
return new ReportDal().TestDataDetailQueryInfo(lot, wo, bt, et, workshop,pallet_nb,sale_order,containerno,check_nbr);
}
public DataTable PressureResistantInfo(string lot, string bt, string et)
{
return new ReportDal().PressureResistantInfo(lot, bt, et);
}
//九江正泰衰减数据
public DataTable TestDataDetailQueryInfoFake(string lot, string wo, string bt, string et, string workshop, string pallet_nb, string sale_order, string containerno, string check_nbr)
{
return new ReportDal().TestDataDetailQueryInfoFake(lot, wo, bt, et, workshop, pallet_nb, sale_order, containerno, check_nbr);
}
public DataTable MultipleTestDetailQueryInfo(string lot, string wo, string bt, string et, string workshop)
{
return new ReportDal().MultipleTestDetailQueryInfo(lot, wo, bt, et, workshop);
}
public DataTable QCQueryInfo(string bt, string et, string lot, string workshop, string workorder, string station)
{
return new ReportDal().QCQueryInfo( bt, et, lot, workshop, workorder,station);
}
public DataTable PackOutputQueryInfo(string workshop, string bt, string et, string lot, string container, string pallet, string check,string workorder)
{
return new ReportDal().PackOutputQueryInfo(workshop, bt, et, lot, container, pallet, check,workorder);
}
//组件班组产量表
public DataTable ShiftProduction(string workshop, string begintime, string endtime, string station, string workorder)
{
return new ReportDal().ShiftProductionDT(workshop, begintime, endtime, station, workorder);
}
//英利包装详情信息
public DataTable PackOutputDetailQueryInfo(string workshop, string bt, string et, string lot, string container, string pallet, string check, string workorder)
{
return new ReportDal().PackOutputDetailQueryInfo(workshop, bt, et, lot, container, pallet, check, workorder);
}
#region 组件电子流转单
//装框线盒
public IEnumerable<dynamic> FrameBoxQueryInfo(string lot)
{
return new ReportDal().FrameBoxQueryInfo(lot);
}
//叠层背板
public IEnumerable<dynamic> LaminationBackQueryInfo(string lot)
{
return new ReportDal().LaminationBackQueryInfo(lot);
}
//叠层EVA
public IEnumerable<dynamic> LaminationEVAQueryInfo(string lot)
{
return new ReportDal().LaminationEVAQueryInfo(lot);
}
//叠层玻璃
public IEnumerable<dynamic> LaminationGlassQueryInfo(string lot)
{
return new ReportDal().LaminationGlassQueryInfo(lot);
}
//叠层高透玻璃
public IEnumerable<dynamic> LaminationHighEVAQueryInfo(string lot)
{
return new ReportDal().LaminationHighEVAQueryInfo(lot);
}
//层压前EL
public IEnumerable<dynamic> ELBeforeLayupQueryInfo(string lot)
{
return new ReportDal().ELBeforeLayup(lot);
}
//测试后EL
public IEnumerable<dynamic> ELAfterTestQueryInfo(string lot)
{
return new ReportDal().ELAfterTest(lot);
}
//清洗
public IEnumerable<dynamic> CleanQueryInfo(string lot)
{
return new ReportDal().CleanQueryInfo(lot);
}
//IV
public IEnumerable<dynamic> IVQueryInfo(string lot)
{
return new ReportDal().IVQueryInfo(lot);
}
//包装
public IEnumerable<dynamic> PackQueryInfo(string lot)
{
return new ReportDal().PackQueryInfo(lot);
}
//层压后检验
public IEnumerable<dynamic> QCAfterLayupInfo(string lot)
{
return new ReportDal().QCAfterLayup(lot);
}
//功率后EL
public IEnumerable<dynamic> ELAfterIVInfo(string lot)
{
return new ReportDal().ELAfterIV(lot);
}
#endregion
#region 工单达成情况
public IEnumerable<dynamic> WOFinishStatusInfo(string wo, string sales, string customer, string bt, string et)
{
return new ReportDal().WOFinishStatus(wo, sales, customer, bt, et);
}
#endregion
#region 工单状态
public IEnumerable<dynamic> WOStatusInfo(string wo,string sales)
{
return new ReportDal().WOStatus(wo,sales);
}
public DataTable WOStatusInfoDT(string wo,string sales)
{
return new ReportDal().WOStatusDT(wo,sales);
}
//出货datatable
public DataTable ShipmentsReportDT(string StartDateTime, string EndDateTime, string WorkShop, string product_code, string power_grade, string containerno)
{
return new ReportDal().ShipmentsReportDT(StartDateTime, EndDateTime, WorkShop, product_code, power_grade, containerno);
}
//生产在制统计datatable
public DataTable StationNbrAndGoingDT(string StartDateTime, string EndDateTime, string WorkShop, string Station, string WorkOrder, string SaleOrder, string WorkTime)
{
return new ReportDal().StationNbrAndGoingDT(StartDateTime, EndDateTime, WorkShop, Station, WorkOrder, SaleOrder, WorkTime);
}
//组件产能
public DataTable ShiftProductionDT(string WorkShop, string StartDateTime, string EndDateTime, string Station, string WorkOrder,string type,string mod)
{
return new ReportDal().ShiftProductionDT(WorkShop, StartDateTime, EndDateTime, Station, WorkOrder,type,mod);
}
public DataTable StationDetailedDT(string StartDateTime, string EndDateTime, string WorkShop, string Station, string Workorder,string Machine, string Saleorder, string WorkTime)
{
return new ReportDal().StationDetailedDT(StartDateTime, EndDateTime, WorkShop, Station, Workorder,Machine, Saleorder, WorkTime);
}
#endregion
#region 包装删除记录
public IEnumerable<dynamic> PackDelHistoryQueryInfo(string lot)
{
return new ReportDal().PackDelHistoryQueryInfo(lot);
}
public DataTable PackDelHistoryQueryInfoDT(string lot)
{
return new ReportDal().PackDelHistoryQueryInfoDT(lot);
}
#endregion
#region 工单各站点在制
public IEnumerable<dynamic> WOprocessQueryInfo(string wo)
{
return new ReportDal().WOprocessQueryInfo(wo);
}
public DataTable WOprocessQueryInfoDT(string wo)
{
return new ReportDal().WOprocessQueryInfoDT(wo);
}
#endregion
#region 各站点产量
public DataTable SitecapacityQueryInfo(string bt, string et, string lot, string workshop, string status)
{
return new ReportDal().SitecapacityQueryInfo(bt, et, lot, workshop, status);
}
#endregion
#region 库存报表导出
public DataTable InventoryDT(string locationname,string name)
{
return new ReportDal().InventoryDT(locationname,name);
}
#endregion
#region 库存JY报表导出
public DataTable InventoryJYDT(string locationname, string name)
{
return new ReportDal().InventoryJYDT(locationname, name);
}
#endregion
#region 库存JY报表详细导出
public DataTable InventoryDetailedJYDT(string locationname, string name)
{
return new ReportDal().InventoryDetailedJYDT(locationname, name);
}
#endregion
#region 入库报表导出
public DataTable StorageDT(string bt, string et, string name, string locationname, string containerno, string palletno, string final_grade, string power_grade,string workorder, string saleorder,string area_code,string serial)
{
return new ReportDal().StorageDT(bt, et, name, locationname, containerno, palletno, final_grade, power_grade,workorder,saleorder,area_code,serial);
}
#endregion
#region 发料报表导出
public DataTable StoreIssueDT(string bt, string et, string part_nbr, string workorder, string lot_nbr)
{
return new ReportDal().StoreIssueDT(bt, et, part_nbr, workorder, lot_nbr);
}
#endregion
#region 材料追溯报表导出
public DataTable MaterialTraceabilityDT(string lot_nbr, string orig_batch_nbr, string serial_nbr, string bt, string et, string wks_desc, string area_code)
{
return new ReportDal().MaterialTraceabilityDT(lot_nbr, orig_batch_nbr, serial_nbr, bt, et, wks_desc, area_code);
}
#endregion
#region CTM报表导出
public DataTable FinalTestRoomDataDT(string bt, string et, string workshop, string workorder)
{
return new ReportDal().FinalTestRoomDataDT(bt, et, workshop, workorder);
}
#endregion
//WorkLotDT(sale_order, workorder)
#region 工单条码报表导出
public DataTable WorkLotDT(string bt, string et, string workshop, string sale_order, string workorder)
{
return new ReportDal().WorkLotDT(bt,et,workshop, sale_order, workorder);
}
#endregion
#region 订单符合报表导出
public DataTable BarCodeAndQualityRateDT(string sale_order, string workorder,string station)
{
return new ReportDal().BarCodeAndQualityRateDT(sale_order, workorder,station);
}
#endregion
#region 结批率导出
public DataTable BatchRateDT(string sale_order, string workorder, string workshop)
{
return new ReportDal().BatchRateDT(sale_order, workorder,workshop);
}
#endregion
#region 线边仓物料导出
public DataTable SuppliesConsumedDT(string sale_order, string workorder, string station)
{
return new ReportDal().SuppliesConsumedDT(sale_order, workorder, station);
}
#endregion
#region 原料线边仓导出
public DataTable LinePositionsDT(string sale_order, string workorder)
{
return new ReportDal().LinePositionsDT(sale_order, workorder);
}
#endregion
#region 成品线边仓导出
public DataTable FinishProductLinePositionsDT(string area_code, string sale_order, string stations, string WorkOrder, string Container, string Palletnbr, string Serialnbr)
{
return new ReportDal().FinishProductLinePositionsDT(area_code, sale_order, stations, WorkOrder, Container, Palletnbr, Serialnbr);
}
#endregion
#region 电池片结批率导出
public DataTable CellBatchRateDT(string sale_order, string workorder,string area_code)
{
return new ReportDal().CellBatchRateDT(sale_order, workorder,area_code);
}
#endregion
#region 返修换片报表导出
public DataTable RepairDT(string bt, string et, string sale_order, string workorder)
{
return new ReportDal().RepairDT(bt, et, sale_order, workorder);
}
#endregion
#region 收发存报表导出
public DataTable ReceivedAndDepositDT(string bt, string et, string name, string locationname, string sale_order)
{
return new ReportDal().receivedanddepositDT(bt, et, name, locationname, sale_order);
}
#endregion
#region 工单达成情况报表导出
public DataTable WOFinishStatusDT(string wo, string sales, string customer, string bt, string et)
{
return new ReportDal().WOFinishStatusDT(wo, sales, customer, bt, et);
}
#endregion
#region 结批率详细导出
public DataTable PopoutDataDT(string workshop, string workorder, string field)
{
return new ReportDal().PopoutDataDT(workshop, workorder, field);
}
#endregion
#region 机台详细导出
public DataTable ProduincDT(string workshop, string workorder,string saleorder,string station,string wksid,string bt,string et, string field, string worktime)
{
return new ReportDal().ProduincDT2(workshop,workorder,saleorder,station,wksid,bt,et,field, worktime);
}
#endregion
#region 站点详细导出
public DataTable ProduincStationDT(string workshop, string workorder, string saleorder, string station, string bt, string et, string field, string worktime)
{
return new ReportDal().ProduincDT(workshop, workorder, saleorder,station,bt, et, field, worktime);
}
#endregion
#region 包装产能统计
public DataTable PackCapacityDT(string workshop, string workorder, string saleorder)
{
return new ReportDal().PackCapacityDT(workshop, workorder, saleorder);
}
#endregion
#region 每日投产包装完成率
public DataTable DayPackCompleteDT(string workshop, string workorder, string saleorder)
{
return new ReportDal().DayPackCompleteDT(workshop, workorder, saleorder);
}
#endregion
#region 生码未包装组件查询
public DataTable UnPackComponentDT(string workshop, string workorder, string saleorder)
{
return new ReportDal().UnPackComponentDT(workshop, workorder, saleorder);
}
#endregion
#region 材料批号查询
public DataTable MaterialBatchNumberDT(string workorder)
{
return new ReportDal().MaterialBatchNumberDT(workorder);
}
#endregion
#region 本月每天各工位产能
public DataTable CurEverydayStationCapacityDT(string workshop,string station,string year,string month)
{
return new ReportDal().CurEverydayStationCapacityDT(workshop,station,year,month);
}
#endregion
#region 永臻晶科报表导出
public DataTable YongzhenJinkeDT(string bt,string et,string PalletLot)
{
return new ReportDal().YongzhenJinkeDT(bt,et,PalletLot);
}
#endregion
#region 一次碎片率报表导出
public DataTable FragmentationDT(string machine, string workshop,string bt,string et)
{
return new ReportDal().FragmentationDT(machine,workshop,bt,et);
}
#endregion
#region 一次成型率报表导出
public DataTable MoldingDT(string machine,string workshop,string bt,string et)
{
return new ReportDal().MoldingDT(machine,workshop, bt ,et);
}
#endregion
#region 数据查询报表导出
public DataTable QueryDT(string wo, string bt,string et,string text)
{
return new ReportDal().QueryDT(wo,bt,et,text);
}
#endregion
#region 上当率报表导出
public DataTable UpshiftDT(string wo, string bt, string et)
{
return new ReportDal().UpshiftDT(wo,bt,et);
}
#endregion
#region 分档机组件查询报表导出
public DataTable StepperDT(string wo, string bt, string et)
{
return new ReportDal().StepperDT(wo, bt, et);
}
#endregion
#region 车间质量问题报表导出
public DataTable QualityDT(string wo, string bt,string et)
{
return new ReportDal().QualityDT(wo, bt,et);
}
#endregion
#region 泛海CTM报表导出
public DataTable CTMReportDT(string sn, string wo, string bt, string et, string pallet)
{
return new ReportDal().CTMReportInfo(sn, wo, bt, et, pallet);
}
#endregion
#region 条码补打报表导出
public DataTable MaterialLotDT(string workorder, string orignbr, string lotnbr)
{
return new ReportDal().MaterialLotInfo(orignbr, lotnbr, workorder);
}
#endregion
#region 条码补打报表导出
public DataTable ReprintDT(string wo, string sn, string bt, string et)
{
return new ReportDal().ReprintDT(wo, sn, bt, et);
}
#endregion
}
}