From ff3cadba4a63cd1b63cd0e36358f49ccedb88bef Mon Sep 17 00:00:00 2001
From: gigibox <gigibox@163.com>
Date: 星期四, 15 六月 2023 10:02:20 +0800
Subject: [PATCH] 完成基本功能
---
kingdee/icInventory.go | 12 +++++++-----
1 files changed, 7 insertions(+), 5 deletions(-)
diff --git a/models/icInventory.go b/kingdee/icInventory.go
similarity index 90%
rename from models/icInventory.go
rename to kingdee/icInventory.go
index 68e06eb..bd824a5 100644
--- a/models/icInventory.go
+++ b/kingdee/icInventory.go
@@ -1,4 +1,4 @@
-package models
+package kingdee
type Inventory struct {
FNumber string `gorm:"column:FNumber" json:"FNumber"` // 鐗╂枡浠ｇ爜
@@ -8,12 +8,12 @@
FStockNo string `gorm:"column:FStockNo" json:"FStockNo"` // 浠撳簱浠ｇ爜
FStockName string `gorm:"column:FStockName" json:"FStockName"` // 浠撳簱鍚嶇О
FUnit string `gorm:"column:FUnit" json:"FUnit"` // 鍩烘湰璁￠噺鍗曚綅
- FUnitQty float64 `gorm:"column:FUnitQty" json:"FUnitQty"` //鍩烘湰璁￠噺鍗曚綅鏁伴噺
+ FUnitQty float64 `gorm:"column:FUnitQty" json:"FUnitQty"` // 鍩烘湰璁￠噺鍗曚綅鏁伴噺
FSec string `gorm:"column:FSec" json:"FSec"` // 甯哥敤璁￠噺鍗曚綅
FQty float64 `gorm:"column:FQty" json:"FQty"` // 甯哥敤璁￠噺鍗曚綅鏁伴噺
}
-func FindICInventory() []Inventory {
+func ICInventory() []Inventory {
sql := `
SELECT
TOP (100) PERCENT item.FNumber AS FNumber,
@@ -40,9 +40,11 @@
item.FNumber
`
var result []Inventory
- //var result []map[string]interface{}
- db.Raw(sql).Debug().Scan(&result)
+ db.Raw(sql).Scan(&result)
+ //db.Raw(sql).Debug().Scan(&result)
+
+ // 鎵撳嵃鍒楀悕绉版祴璇�
//rows, _ := db.Raw(sql).Debug().Rows()
//fmt.Println(rows.Columns())
--
Gitblit v1.8.0