From 5d16fa127ab2005b56ddb9c8d8c2ff1ff0f5826d Mon Sep 17 00:00:00 2001
From: lazhen <17772815105@139.com>
Date: 星期二, 22 十月 2024 17:47:43 +0800
Subject: [PATCH] 发动机物流成本报表导入报错处理

---
 _Main/BL/Type_FinancialSalesSource/Method_AfterImport.qbl |   10 +++++-----
 1 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/_Main/BL/Type_FinancialSalesSource/Method_AfterImport.qbl b/_Main/BL/Type_FinancialSalesSource/Method_AfterImport.qbl
index 36d1094..43dbe28 100644
--- a/_Main/BL/Type_FinancialSalesSource/Method_AfterImport.qbl
+++ b/_Main/BL/Type_FinancialSalesSource/Method_AfterImport.qbl
@@ -25,7 +25,7 @@
         if( isnull( unitrow ) ){
           unitrow           := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := unit.Value() );
         }
-        allrow  := selectobject( table, FinancialSalesRow, allrow, allrow.Name() = product.Value() and allrow.Unit() = allunit );
+        allrow              := selectobject( table, FinancialSalesRow, allrow, allrow.Name() = product.Value() and allrow.Unit() = allunit );
         if( isnull( unitrow ) ){
           allrow            := table.FinancialSalesRow( relnew, Name := product.Value(), Unit := allunit );
         }
@@ -41,7 +41,7 @@
           if( isnull( tablecolumn ) ){
             tablecolumn   := table.FinancialSalesColumn( relnew, Name := periodname, Period := yearday.Date() );
           }
-          unitcell := selectobject( unitrow, FinancialSalesCell, unitcell, unitcell.FinancialSalesColumn().Name() = column.Name() );
+          unitcell := selectobject( unitrow, FinancialSalesCell, unitcell, unitcell.FinancialSalesColumn() = tablecolumn );
           if( isnull( unitcell ) ){
             unitcell        := tablecolumn.FinancialSalesCell( relnew, Value := cell.Value() );
             unitrow.FinancialSalesCell( relinsert, unitcell );
@@ -51,12 +51,12 @@
               previouscell  := selectobject( row, FinancialSalesCell, previouscell, previouscell.FinancialSalesColumn() = previouscolumn );
               quantity      := [Real]cell.Value() + [Real]previouscell.Value();
               if( [Real]unitcell.Value() <> quantity ){
-                unitcell.Value( [String]( [Number]cell.Value() ) );
+                unitcell.Value( [String]( [Number]quantity ) );
                 unitcell.IsUpdate( true );
               }
             }
           }
-          allcell  := selectobject( allrow, FinancialSalesCell, allcell, allcell.FinancialSalesColumn().Name() = column.Name() );
+          allcell  := selectobject( allrow, FinancialSalesCell, allcell, allcell.FinancialSalesColumn() = tablecolumn  );
           if( isnull( unitcell ) ){
             allcell         := tablecolumn.FinancialSalesCell( relnew, Value := cell.Value() );
             allrow.FinancialSalesCell( relinsert, allcell );
@@ -66,7 +66,7 @@
               previouscell  := selectobject( row, FinancialSalesCell, previouscell, previouscell.FinancialSalesColumn() = previouscolumn );
               quantity      := [Real]cell.Value() + [Real]previouscell.Value();
               if( [Real]allcell.Value() <> quantity ){
-                allcell.Value( [String]( [Number]cell.Value() ) );
+                allcell.Value( [String]( [Number]quantity ) );
                 allcell.IsUpdate( true );
               }
             }

--
Gitblit v1.9.3