From 36c6614cc0b8fc830b8ab66995bee6dc14c54dd1 Mon Sep 17 00:00:00 2001
From: gigibox <gigibox@163.com>
Date: 星期五, 09 六月 2023 01:19:27 +0800
Subject: [PATCH] 完成订单和库存的查询
---
models/icInventory.go | 10 +++-------
1 files changed, 3 insertions(+), 7 deletions(-)
diff --git a/models/icInventory.go b/models/icInventory.go
index 7320a1b..68e06eb 100644
--- a/models/icInventory.go
+++ b/models/icInventory.go
@@ -1,7 +1,5 @@
package models
-import "fmt"
-
type Inventory struct {
FNumber string `gorm:"column:FNumber" json:"FNumber"` // 鐗╂枡浠ｇ爜
FName string `gorm:"column:FName" json:"FName"` // 鐗╂枡鍚嶇О
@@ -16,10 +14,8 @@
}
func FindICInventory() []Inventory {
- fmt.Printf("inventory===========\n")
-
sql := `
- SELECT
+ SELECT
TOP (100) PERCENT item.FNumber AS FNumber,
item.FName AS FName,
item.FModel AS FModel,
@@ -47,8 +43,8 @@
//var result []map[string]interface{}
db.Raw(sql).Debug().Scan(&result)
- rows, _ := db.Raw(sql).Debug().Rows()
- fmt.Println(rows.Columns())
+ //rows, _ := db.Raw(sql).Debug().Rows()
+ //fmt.Println(rows.Columns())
return result
}
--
Gitblit v1.8.0