public DataTable GetMultiBomShortageData(List <string> pintWODetailId)
{
var dsReport = new C1PrintPreviewDialogDS();
DataTable dtbTemp = dsReport.GetMultiBomShortageData(pintWODetailId);
return(dtbTemp);
}
public DataTable GetItemCostDetailedByElementAndProductionLineData(string pstrCCNID, string pstrYear, string pstrMonth, string pstrListDepartmentID, string pstrListProductionLineID, string pstrListCategoryID, string pstrListProductID, int pintMakeItem)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetItemCostDetailedByElementAndProductionLineData(pstrCCNID, pstrYear, pstrMonth, pstrListDepartmentID,
pstrListProductionLineID, pstrListCategoryID, pstrListProductID, pintMakeItem));
}
public DataTable GetSalvagingMaterialData(string pstrCCNID, string pstrYear, string pstrMonth, string pstrListDepartmentID, string pstrListProductionLineID, string pstrListCategoryID, string pstrListProductID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetSalvagingMaterialData(pstrCCNID, pstrYear, pstrMonth, pstrListDepartmentID,
pstrListProductionLineID, pstrListCategoryID, pstrListProductID));
}
public DataTable GetBOMShortageData(List <string> pintWODetailId, decimal pdecCompletedQty)
{
var dsReport = new C1PrintPreviewDialogDS();
DataTable dtbTemp = dsReport.GetBOMShortageData(pintWODetailId, pdecCompletedQty);
return(dtbTemp);
}
public DataTable GetDetailedItemCostByMonthData(string pstrCCNID, string pstrYear, string pstrListDepartmentID, string pstrListProductionLineID, string pstrListCategoryID, string pstrListProductID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetDetailedItemCostByMonthData(pstrCCNID, pstrYear, pstrListDepartmentID,
pstrListProductionLineID, pstrListCategoryID, pstrListProductID));
}
/// <summary>
/// Get In-Out Stock data
/// </summary>
/// <returns></returns>
/// <author> Tuan TQ, 16 Jan, 2006</author>
public DataTable GetInOutStockData(string pstrCCNID,
string pstrMasterLocID,
string pstrLocationID,
string pstrBinType,
string pstrBinID,
DateTime pdtmFromDate,
DateTime pdtmToDate,
string pstrCategoryID,
string pstrProductSourceID,
string pstrModel,
string pstrProductID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetInOutStockData(pstrCCNID, pstrMasterLocID, pstrLocationID, pstrBinType,
pstrBinID, pdtmFromDate, pdtmToDate, pstrCategoryID, pstrProductSourceID,
pstrModel, pstrProductID));
}
/// <summary>
/// THACHNN : 08/11/2005
/// Return data for rendering CPO Report,
/// </summary>
/// <param name="pstrPlanType">MPS or MRP string</param>
/// <param name="pnCCNID"></param>
/// <param name="pnMonth"></param>
/// <param name="pnYear"></param>
/// <param name="pnCycle"></param>
/// <param name="pnProductionLineID"></param>
/// <param name="pnMasterLocationID"></param>
/// <param name="pnCategoryID"></param>
/// <returns></returns>
public DataTable GetCPOReportData(string pstrPlanType, int pnCCNID, int pnMonth, int pnYear, int pnCycle,
int pnProductionLineID, int pnMasterLocationID, int pnCategoryID,
int pnVendorID, int pnProductID, string pstrModel)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
pstrPlanType = pstrPlanType.Trim();
if (pstrPlanType == PlanTypeEnum.MPS.ToString())
{
return(objDS.GetMPS_CPOReportData(pnCCNID, pnMonth, pnYear, pnCycle, pnProductionLineID,
pnMasterLocationID, pnCategoryID, pnVendorID, pnProductID, pstrModel));
}
else if (pstrPlanType == PlanTypeEnum.MRP.ToString())
{
return(objDS.GetMRP_CPOReportData(pnCCNID, pnMonth, pnYear, pnCycle, pnProductionLineID,
pnMasterLocationID, pnCategoryID, pnVendorID, pnProductID, pstrModel));
}
else
{
return(new DataTable());
}
}
/// <summary>
/// Get PO Summary data
/// </summary>
/// <param name="pintWODetailId"></param>
/// <returns></returns>
/// <author> Tuan TQ, 30 Dec, 2005</author>
public DataTable GetPOSummaryData(int pintPOId, DateTime pdtmOrderDate)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetPOSummaryData(pintPOId, pdtmOrderDate));
}
/// <summary>
/// Get PO Invoice data
/// </summary>
/// <param name="pintWODetailId"></param>
/// <returns></returns>
/// <author> Tuan TQ, 05 Jan, 2006</author>
public DataTable GetPOInvoiceData(int pintInvoiceMasterId)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetPOInvoiceData(pintInvoiceMasterId));
}
/// <summary>
/// Get Delivery To Outsourcing Vendor data
/// </summary>
/// <param name="pintWODetailId"></param>
/// <returns></returns>
/// <author> Tuan TQ, 29 Dec, 2005</author>
public DataTable GetDelivery2OutsourcingData(int pintIssueMasterialMasterId, string pstrMaxRow)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetDelivery2OutsourcingData(pintIssueMasterialMasterId, pstrMaxRow));
}
/// <summary>
/// Get Destroy Slip data
/// </summary>
/// <param name="pintWODetailId"></param>
/// <returns></returns>
/// <author> Tuan TQ, 14 Mar, 2006</author>
public DataTable GetDestroySlipData(int pintIssueMasterialMasterId, string pstrMaxRow)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetDestroySlipData(pintIssueMasterialMasterId, pstrMaxRow));
}
public string GetVendorInfo(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetVendorInfo(pnID));
}
/// <summary>
/// Return data for SO Invoice report
/// </summary>
/// <returns></returns>
/// <author>Tuan TQ. Oct 28, 2005</author>
public DataTable GetSaleOrderCommitData(int pintSOCommitMasterID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetSaleOrderCommitData(pintSOCommitMasterID));
}
public DataTable GetPOSlipDatavedor(int pintPOReceiptMasterID)
{
C1PrintPreviewDialogDS dsReport = new C1PrintPreviewDialogDS();
return(dsReport.GetPOSlipDatavedor(pintPOReceiptMasterID));
}
public DataTable GetDestroyMaterialData(string pstrCCNID, string pstrYear, string pstrMonth, string pstrListDepartmentID, string pstrListProductionLineID, string pstrListCategoryID, string pstrListProductID)
{
C1PrintPreviewDialogDS dsPrint = new C1PrintPreviewDialogDS();
return(dsPrint.GetDestroyMaterialData(pstrCCNID, pstrYear, pstrMonth, pstrListDepartmentID, pstrListProductionLineID, pstrListCategoryID, pstrListProductID));
}
public DataTable GetDelivery2CustomerData(int pintSaleOrderMasterId)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetDelivery2CustomerData(pintSaleOrderMasterId));
}
/// <summary>
/// GetReturnGoodsReceiptByMasterID
/// </summary>
/// <param name="pintReturnGoodsReceiptMasterID"></param>
/// <returns></returns>
/// <author>Trada</author>
/// <date>Monday, Mar 13 2006</date>
public DataTable GetReturnGoodsReceiptByMasterID(int pintReturnGoodsReceiptMasterID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetReturnGoodsReceiptByMasterID(pintReturnGoodsReceiptMasterID));
}
/// <summary>
/// Get max lead time of a product in a specific category
/// </summary>
/// <param name="pintCategoryID"></param>
/// <param name="pstrListOfProducts"></param>
/// <returns></returns>
public DataTable GetProductCapacityOfCategory(string pstrCategoryID, string pstrListOfProducts)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetProductCapacityOfCategory(pstrCategoryID, pstrListOfProducts));
}
/// <summary>
/// Return Order Summary Report
/// </summary>
/// <param name="pintCCNID"></param>
/// <param name="pintYear"></param>
/// <param name="pstrOtherCondition"></param>
/// <returns></returns>
/// <author>Tuan TQ. Nov 21, 2005</author>
public DataTable GetOrderSummaryData(int pintCCNID, int pintYear, string pstrOtherCondition)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetOrderSummaryData(pintCCNID, pintYear, pstrOtherCondition));
}
public DataTable GetSaleOrderInvoiceData(int pintSOInvoiceMasterID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetSaleOrderInvoiceData(pintSOInvoiceMasterID));
}
/// <summary>
/// Get PO Invoice data
/// </summary>
/// <returns></returns>
/// <author> Tuan TQ, 06 Apr, 2006</author>
public DataTable GetPOBOMShortageData(DateTime pdtmPostDate, int pintProductionLineID, string pstrPONo, string pstrProductIDList)
{
C1PrintPreviewDialogDS dsReport = new C1PrintPreviewDialogDS();
return(dsReport.GetPOBOMShortageData(pdtmPostDate, pintProductionLineID, pstrPONo, pstrProductIDList));
}
public string GetCategoryCodeFromID(string pstrID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetCategoryCodeFromID(pstrID));
}
/// <summary>
/// Thachnn 10/11/2005
/// </summary>
/// <param name="pnID"></param>
/// <returns></returns>
public string GetVendorNameFromID(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetVendorNameFromID(pnID));
}
/// <summary>
/// Thachnn 06/02/2006
/// </summary>
/// <param name="pnID"></param>
/// <returns></returns>
public string GetWorkOrderMasterNoFromID(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetWorkOrderMasterNoFromID(pnID));
}
public string GetItemInfor(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetItemInfor(pnID));
}
/// <summary>
/// Thachnn 10/11/2005
/// </summary>
/// <param name="pnID"></param>
/// <returns></returns>
public string GetProductCodeFromID(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetProductCodeFromID(pnID));
}
//**************************************************************************
/// <Description>
/// Get CategoryName From Line And WorkOrderNo
/// </Description>
/// <Inputs>
/// Line
/// </Inputs>
/// <Inputs>
/// WOrk Order No
/// </Inputs>
/// <Returns>
/// string Category Name
/// </Returns>
/// <Authors>
/// Thachnn
/// </Authors>
/// <History>
/// 28-10-2005
/// </History>
/// <Notes>
/// </Notes>
//**************************************************************************
public string GetCategoryNameFromLineAndWorkOrderNo(int pnLine, string pstrWONo)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetCategoryNameFromLineAndWorkOrderNo(pnLine, pstrWONo));
}
/// <summary>
/// Thachnn 10/03/2006
/// </summary>
/// <param name="pnID"></param>
/// <returns></returns>
public string GetPurchaseOrderMasterCodeFromID(int pnID)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetPurchaseOrderMasterCodeFromID(pnID));
}
public DataTable GetSOInvoiceDetailData4ImportInvoice(int pintSOInvoiceMasterID)
{
C1PrintPreviewDialogDS dsReport = new C1PrintPreviewDialogDS();
return(dsReport.GetSOInvoiceDetailData4ImportInvoice(pintSOInvoiceMasterID));
}
public DataTable GetWOCompletionData(int pintWOCompletionId)
{
C1PrintPreviewDialogDS objDS = new C1PrintPreviewDialogDS();
return(objDS.GetWOCompletionData(pintWOCompletionId));
}
