supplier_system/src/dashoo.cn/backend/api/business/tmpzcgf/tmpCertSubSession.go

package tmpzcgf

//import (
//	"dashoo.cn/backend/api/business/oilsupplier/suppliercertsub"
//	"dashoo.cn/backend/api/controllers/tmpzcgf"
//	. "dashoo.cn/backend/api/mydb"
//	"github.com/go-xorm/xorm"
//
//
//)
//
//type TmpCertSession struct {
//	MySessionBase
//}
//
//type SubClassId struct{
//	id int
//}
//
//type AllId struct{
//	Id int
//}
//
//func GetTmpCertService(session *xorm.Session) *TmpCertSession {
//	s := new(TmpCertSession)
//	s.Session = session
//	return s
//}
//
////获取tmp_zcgf所有Id
//func (s *TmpCertSession) GetAllId() []AllId{
//	var ids []AllId
//	sql := `SELECT
//				id
//			FROM
//				tmp_zcgf`
//	s.Session.SQL(sql).Find(&ids)
//	return ids
//}
//
////从tmp_zcgf获取一条数据
//func (s *TmpCertSession) SelectOne(id int) tmpzcgf.TmpCertController {
//	var one tmpzcgf.TmpCertController
//	sql := `SELECT
//				a.准入范围 AccessRange,
//				c.id SupplierCertId,
//				c.SupplierTypeCode SupplierTypeCode
//			FROM
//				tmp_zcgf a
//				LEFT JOIN oilsupplier b ON a.企业名称 = b.SupplierName
//				JOIN oilsuppliercert c ON b.id = c.SupplierId
//				AND a.准入类别 = c.SupplierTypeName
//			WHERE
//				a.id =` + string(id)
//	 s.Session.SQL(sql).Find(&one)
//	return one
//}
//
//
////获取subClassId
//func (s *TmpCertSession) GetSubClassId(code string, supplierTypeCode string) int{
//	//var subClassName
//	var id SubClassId
//	var tableName string
//	switch supplierTypeCode{
//	case "01":
//		tableName = "OilGoodsAptitudeClass"
//		//subClassName = []goodsaptitudeclass.OilGoodsAptitudeClass
//	case "02":
//		tableName = "OilBasisBuild"
//		//subClassName = []basisbuild.OilBasisBuild
//	case "03":
//		tableName = "OilTechnologyServiceClass"
//		//subClassName = []technologyserviceclass.OilTechnologyServiceClass
//	}
//	var sql = `SELECT id FROM`+tableName+`WHERE	1 = 1 AND code =`+ code
//
//	s.Session.SQL(sql).Find(&id)
//	return id.id
//
//}
//
//func (s *TmpCertSession) InsertSupplierCertSub(sub suppliercertsub.OilSupplierCertSub) error {
//	var supplierId = string(sub.SupplierId)
//	var	supplierCertId = string(sub.SupplierCertId)
//	var	supplierTypeCode = sub.SupplierTypeCode
//	var	subClassId = string(sub.SubClassId)
//	var	code = sub.Code
//	var	name = sub.Name
//	sql := `INSERT INTO OilSupplierCertSub ( SupplierId, SupplierCertId, SupplierTypeCode, SubClassId, CODE, NAME )
//	VALUES ( ’`	+ supplierId+`‘,‘`+supplierCertId+`','`+supplierTypeCode+`','`+subClassId+`','`+code+`','`+name+`')`
//
//	_,err := s.Session.Query(sql)
//	return err
//}