package goodsaptitude

import (
	. "dashoo.cn/backend/api/mydb"
	"fmt"
	"github.com/go-xorm/xorm"
)

type OilGoodsAptitudeSession struct {
	MySessionBase
}

func GetOilGoodsAptitudeSession(session *xorm.Session) *OilGoodsAptitudeSession {
	s := new(OilGoodsAptitudeSession)
	s.Session = session
	return s
}

func (s *OilGoodsAptitudeSession) InstrOilGoodsAptitudeClass(cellsArr []interface{}) {

	for i := 0; i < len(cellsArr); i++ {

	}

	fmt.Println(cellsArr, "==== ")

}

func (s *OilGoodsAptitudeSession) SelectGoodsAptitudeClassCode(code string) string {
	sql := "select Id from tmp_OilGoodsAptitudeClass where Code='" + code + "'"
	id, _ := s.Session.QueryString(sql)
	if id == nil {
		return ""
	}
	return id[0]["Id"]
}

func (s *OilGoodsAptitudeSession) InsertGoodsAptitude(parentId, fcode, val string) error {
	sql := "INSERT INTO `tmp_OilGoodsAptitude` (ClassId," + fcode + ") "
	sql += " VALUES ("+ parentId +"," + val + ")"
	_, err := s.Session.Query(sql)
	return err
}