コード例 #1
0
        public List<InventoryStockReport> GetInventoryStockReportBetweenDate(DateTime fromdate, DateTime todate)
        {
            List<InventoryStockReport> aInventoryStockReports = new List<InventoryStockReport>();
            try
            {
                this.OpenConnection();
                string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetInventoryStockReportBetweenDate), fromdate,
                                               todate);
                IDataReader aReader = this.ExecuteReader(sqlComm);
                if (aReader != null)
                {
                    while (aReader.Read())
                    {
                        InventoryStockReport aReport = new InventoryStockReport();
                        aReport = ReaderToReadAllStock(aReader);
                        aInventoryStockReports.Add(aReport);
                    }
                }

            }
            catch (Exception ex)
            {

                throw new Exception("GetInventoryStockReportBetweenDate()", ex);
            }
            finally
            {
                this.CloseConnection();
            }
            return aInventoryStockReports;
        }
コード例 #2
0
ファイル: StockDAO.cs プロジェクト: Jusharra/RMS
        public List<InventoryStockReport> GetAllKitchenStockForReport()
        {
            List<InventoryStockReport> aReports = new List<InventoryStockReport>();
               try
               {
               this.OpenConnection();
               string sqlComm = String.Format(SqlQueries.GetQuery(Query.AllInventoryKitchenStock));
               IDataReader aReader = this.ExecuteReader(sqlComm);
               if (aReader != null)
               {
                   while (aReader.Read())
                   {
                       InventoryStockReport aReport = new InventoryStockReport();
                       aReport = ReaderToReadAllStock(aReader);
                       aReports.Add(aReport);
                   }
               }

               }
               catch (Exception ex)
               {

               throw new Exception("GetAllKitchenStockForReport()", ex);
               }
               finally
               {
               this.CloseConnection();
               }
               return aReports;
        }
コード例 #3
0
        private InventoryStockReport ReaderToReadAllStock(IDataReader aReader)
        {
            InventoryStockReport aStockReport = new InventoryStockReport();
            try
            {
                aStockReport.CategoryId = Convert.ToInt32(aReader["category_id"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.CategoryName = (aReader["category_name"]).ToString();
            }
            catch
            {
            }
            try
            {
                aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.ItemName = (aReader["item_name"]).ToString();
            }
            catch
            {
            }

            try
            {
                aStockReport.BalanceQty = Convert.ToDouble(aReader["balance"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.SendQty = Convert.ToDouble(aReader["send"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.ReceivedQty = Convert.ToDouble(aReader["received"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.DamageQty = Convert.ToDouble(aReader["damage"]);
            }
            catch
            {
            }
            try
            {
                aStockReport.Date = Convert.ToDateTime(aReader["date"]);
            }
            catch
            {
            }

            return aStockReport;
        }
コード例 #4
0
 private InventoryStockReport ReaderToReadSaleReport(IDataReader aReader)
 {
     InventoryStockReport aStockReport = new InventoryStockReport();
        try
        {
        aStockReport.Date = Convert.ToDateTime(aReader["date"]);
        }
        catch
        {
        }
        try
        {
        aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
        }
        catch
        {
        }
        try
        {
        aStockReport.SaleQty = Convert.ToDouble(aReader["item_qty"]);
        }
        catch
        {
        }
        try
        {
        aStockReport.Price = Convert.ToDouble(aReader["sale_price"]);
        }
        catch
        {
        }
        return aStockReport;
 }
コード例 #5
0
ファイル: StockDAO.cs プロジェクト: Jusharra/RMS
        private InventoryStockReport ReaderToReadAllStock(IDataReader aReader)
        {
            InventoryStockReport aStockReport=new InventoryStockReport();
               try
               {
               aStockReport.CategoryId = Convert.ToInt32(aReader["category_id"]);
               }
               catch
               {
               }
               try
               {
               aStockReport.CategoryName = (aReader["category_name"]).ToString();
               }
               catch
               {
               }
               try
               {
               aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
               }
               catch
               {
               }
               try
               {
               aStockReport.ItemName = (aReader["item_name"]).ToString();
               }
               catch
               {
               }

               try
               {
               aStockReport.BalanceQty= Convert.ToDouble(aReader["stock"]);
               }
               catch
               {
               }
               try
               {
               aStockReport.Unit = (aReader["unit"]).ToString();
               }
               catch
               {
               }
               try
               {
               aStockReport.UnitPrice = Convert.ToDouble(aReader["unit_price"]);
               }
               catch
               {
               }
               return aStockReport;
        }