예제 #1
0
        public DataTable GetPurchaseRecordsApprovalListByWarehouse(string warehouseId)
        {
            PurchaseRecordDAL purchaseRecord = new PurchaseRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = purchaseRecord.GetPurchaseRecordsApprovalListByWarehouse(warehouseId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRecord = null;
            }
        }
예제 #2
0
        public DataTable GetPurchaseRecordsListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status)
        {
            PurchaseRecordDAL purchaseRecord = new PurchaseRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = purchaseRecord.GetPurchaseRecordsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRecord = null;
            }
        }
예제 #3
0
        public string SavePurchaseRecord(DataTable dtPrdList)
        {
            PurchaseRecordDAL purchaseRecord = new PurchaseRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                string Id = purchaseRecord.SavePurchaseRecord(this, dtPrdList, db);
                db.Stop();

                return Id;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRecord = null;
                dtPrdList = null;
            }
        }
예제 #4
0
        public DataTable GetPurchaseRecordProductListByIdForReturn(string purchaseRecordId)
        {
            PurchaseRecordDAL purchaseRecord = new PurchaseRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = purchaseRecord.GetPurchaseRecordProductListByIdForReturn(purchaseRecordId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRecord = null;
            }
        }
예제 #5
0
        public void ApprovePurchaseRecord(string warehouseId, string purchaseRecordId)
        {
            PurchaseRecordDAL purchaseRecord = new PurchaseRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                purchaseRecord.ApprovePurchaseRecord(warehouseId, purchaseRecordId, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRecord = null;
            }
        }