public DataTable Trach_Lot(int typeSearch, string Input) { string Condition = string.Empty; if (typeSearch == 1) { Condition = " ti.InvoiceId LIKE '" + Input + "'"; } else if (typeSearch == 2) { Condition = " ct.Lotnumber LIKE '%" + Input + "%'"; } else if (typeSearch == 3) { Condition = " ct.BatchID LIKE '" + Input + "'"; } else if (typeSearch == 4) { Condition = " od.OrderID LIKE '" + Input + "'"; } else if (typeSearch == 5) { Condition = " od.PurchaseOrderID LIKE '" + Input + "'"; } else { Condition = " ti.InvoiceId LIKE '" + Input + "'"; } return(Reports_DL.Trach_Lot(Condition)); }
public DataTable GetInvoiceList_Farmer(string FarmerID, string ProductID) { return(Reports_DL.GetInvoiceList_Farmer(FarmerID, ProductID)); }
public DataTable GetReports() { return(Reports_DL.GetReports()); }
public DataTable GeDispatchDetails(string ProductID) { return(Reports_DL.GeDispatchDetails(ProductID)); }
public DataTable GetFreezeDetails() { return(Reports_DL.GetFreezeDetails()); }
public DataTable GetAFLReportData(string ICSCode, string Year) { return(Reports_DL.GetAFLReportData(ICSCode, Year)); }
public DataTable GetAFLTotalProduction(string ICSCode, string Year, int ProductID) { return(Reports_DL.GetAFLTotalProduction(ICSCode, Year, ProductID)); }
public DataTable GetProduction(string ProductID, DateTime Date, string Year) { return(Reports_DL.GetProduction(ProductID, Date, Year)); }
public DataTable GetNewallcollectionList(string code) { return(Reports_DL.GetNewallcollectionList(code)); }
public DataTable GetSelectedBlendnDate(string Date, int productID) { return(Reports_DL.GetSelectedBlendnDate(Date, productID)); }
public DataTable GetSelectedBlendQty(string Code, int productID) { return(Reports_DL.GetSelectedBlendQty(Code, productID)); }
public DataTable GetSelectedCollectionDate(string Date, int productID, string Code) { return(Reports_DL.GetSelectedCollectionDate(Date, productID, Code)); }
public DataTable GetAllProducDetails() { return(Reports_DL.GetAllProducDetails()); }
public DataTable GetCollectionDates(int productID, string code) { return(Reports_DL.GetCollectionDates(productID, code)); }
public bool OrderReportsPathInsertandUpdate(int OrderID, int BranchOrderID, string Path, string CreatedBy, string ModifiedBy, int TypeOfOperation) { return(Reports_DL.OrderReportsPathInsertandUpdate(OrderID, BranchOrderID, Path, CreatedBy, ModifiedBy, TypeOfOperation)); }
public DataTable GetBlendDetails(string ProductID) { return(Reports_DL.GetBlendDetails(ProductID)); }
public DataTable OrderReportsPathGetDetails(int OrderID) { return(Reports_DL.OrderReportsPathGetDetails(OrderID)); }
public DataTable GePackingDetails(string ProductID) { return(Reports_DL.GePackingDetails(ProductID)); }
public DataTable GetAFLReportProduction(string ICSCode) { return(Reports_DL.GetAFLReportProduction(ICSCode)); }
public DataTable GetAFLReportProductionEstimation(string ICSCode, string Year) { return(Reports_DL.GetAFLReportProductionEstimation(ICSCode, Year)); }