| File was renamed from models/icInventory.go |
| | |
|---|
| | | package models |
|---|
| | | package kingdee |
|---|
| | | |
|---|
| | | type Inventory struct { |
|---|
| | | FNumber string `gorm:"column:FNumber" json:"FNumber"` // 物料代码 |
|---|
| | |
|---|
| | | FQty float64 `gorm:"column:FQty" json:"FQty"` // 常用计量单位数量 |
|---|
| | | } |
|---|
| | | |
|---|
| | | func FindICInventory() []Inventory { |
|---|
| | | func ICInventory() []Inventory { |
|---|
| | | sql := ` |
|---|
| | | SELECT |
|---|
| | | TOP (100) PERCENT item.FNumber AS FNumber, |
|---|
| | |
|---|
| | | 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()) |
|---|
| | | |
|---|
