|
|
- // Copyright (c) Shenyang Leading Edge Intelligent Technology Co., Ltd. All rights reserved.
-
- package implments
-
- import (
- "LAPP_GAAS_GFrame_BACKEND/grmi"
- meta "LAPP_GAAS_GFrame_BACKEND/meta/base"
- model "LAPP_GAAS_GFrame_BACKEND/models/base"
- "fmt"
- "github.com/go-xorm/xorm"
- "xorm.io/core"
- )
-
- /******************************************************************************
- *
- * @Struct Name : CodeParserDAOImplement
- *-----------------------------------------------------------------------------
- *
- * @Description : CodeParser的数据访问对象实现
- *
- * @Author : 代码生成器创建
- *
- * @Date : 2021-04-19 12:11:47
- *
- ******************************************************************************/
- type CodeParserDAOImplement struct {
- session *xorm.Session
- meta *grmi.Entity
- plantNr int
- userid string
- }
-
- /******************************************************************************
- *
- * @Function Name : NewCodeParserDAOImplement
- *-----------------------------------------------------------------------------
- *
- * @Description : 创建一个CodeParserDAOImplement实例
- *
- * @Function Parameters : xorm会话
- *
- * @Function Parameters : 基本主键
- *
- * @Return Value : CodeParserDAOImplement实例
- *
- * @Author : 代码生成器创建
- *
- * @Date : 2021-04-19 12:11:47
- *
- ******************************************************************************/
- func NewCodeParserDAOImplement(session *xorm.Session, plantNr int, userid string) *CodeParserDAOImplement {
- return &CodeParserDAOImplement{session, &meta.CodeParser, plantNr, userid}
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.InsertOne
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) InsertOne(entity *model.CodeParser) error {
- entity.PlantNr = impl.plantNr
- entity.LastUser = impl.userid
- _, err := impl.session.Table(impl.meta.TableName).Insert(entity)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.DeleteOne
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) DeleteOne(parserId string) error {
- _, err := impl.session.Table(impl.meta.TableName).ID(core.PK{impl.plantNr, parserId}).Delete(impl.meta.Indicator)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
-
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.SelectOne
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) SelectOne(parserId string) (*model.CodeParser, error) {
- var data model.CodeParser
- ok, err := impl.session.Table(impl.meta.TableName).ID(core.PK{impl.plantNr, parserId}).Get(&data)
- if err != nil {
- return nil, grmi.NewDataBaseError(err)
- }
- if !ok {
- return nil, nil
- }
- return &data, nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.UpdateOne
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) UpdateOne(entity *model.CodeParser) error {
- entity.PlantNr = impl.plantNr
- entity.LastUser = impl.userid
- _, err := impl.session.Table(impl.meta.TableName).Cols(impl.meta.UpdatingMembers...).ID(entity.GetKey()).Update(entity)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.Insert
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) Insert(entities *[]model.CodeParser) error {
- for i := 0; i < len(*entities); i++ {
- entity := &(*entities)[i]
- entity.PlantNr = impl.plantNr
- entity.LastUser = impl.userid
- }
- _, err := impl.session.Table(impl.meta.TableName).Insert(entities)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.Delete
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) Delete(entities *[]model.CodeParser) error {
- for _, entity := range *entities {
- entity.PlantNr = impl.plantNr
- _, err := impl.session.Table(impl.meta.TableName).ID(entity.GetKey()).Delete(impl.meta.Indicator)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.DeleteWhere
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) DeleteWhere(predicates []grmi.Predicate) error {
-
- parameters := []interface{}{impl.plantNr}
- where := fmt.Sprintf("%s = ?", meta.CodeParser_PlantNr.ColumnName)
-
- session := impl.session.Table(impl.meta.TableName)
- if predicates != nil {
- for _, predicate := range predicates {
- where += predicate.Build()
- parameters = append(parameters, predicate.Values...)
- }
- session = session.Where(where, parameters...)
- } else {
- session = session.Where(where, parameters...)
- }
-
- _, err := session.Delete(impl.meta.Indicator)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.Select
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) Select(predicates []grmi.Predicate, orderByFields []grmi.Field) ([]model.CodeParser, error) {
-
- parameters := []interface{}{impl.plantNr}
- where := fmt.Sprintf("%s = ?", meta.CodeParser_PlantNr.ColumnName)
-
- session := impl.session.Table(impl.meta.TableName)
- if predicates != nil {
- for _, predicate := range predicates {
- where += predicate.Build()
- parameters = append(parameters, predicate.Values...)
- }
- session = session.Where(where, parameters...)
- } else {
- session = session.Where(where, parameters...)
- }
-
- session = session.OrderBy(meta.CodeParser_PlantNr.ColumnName)
- if orderByFields != nil {
- for _, field := range orderByFields {
- session = session.OrderBy(field.ColumnName)
- }
- }
-
- data := make([]model.CodeParser, 0, 10)
- err := session.Find(&data)
- if err != nil {
- return nil, grmi.NewDataBaseError(err)
- }
- return data, nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.SelectAndPaging
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) SelectAndPaging(paging *grmi.Paging, predicates []grmi.Predicate, orderByFields []grmi.Field) (grmi.PagingResult, error) {
-
- parameters := []interface{}{impl.plantNr}
- where := fmt.Sprintf("%s = ?", meta.CodeParser_PlantNr.ColumnName)
-
- session := impl.session.Table(impl.meta.TableName)
- if predicates != nil {
- for _, predicate := range predicates {
- where += predicate.Build()
- parameters = append(parameters, predicate.Values...)
- }
- session = session.Where(where, parameters...)
- } else {
- session = session.Where(where, parameters...)
- }
-
- count, err := session.Count(impl.meta.Indicator)
- if err != nil {
- return grmi.EmptyPagingResult, err
- }
-
- orderBy := " order by " + meta.CodeParser_PlantNr.ColumnName
- if orderByFields != nil {
- for _, field := range orderByFields {
- orderBy += ", " + field.ColumnName
- }
- }
- parameters = append(parameters, paging.Offset(), paging.Size)
- data := make([]model.CodeParser, 0, 10)
- if where != "" {
- where = " where " + where
- }
- err = impl.session.Table(impl.meta.TableName).SQL("select * from "+impl.meta.TableName+where+orderBy+" offset ? row fetch next ? row only", parameters...).Find(&data)
- if err != nil {
- return grmi.EmptyPagingResult, err
- }
- return grmi.PagingResult{Records: data, Count: count, PageNumber: paging.Number, PageSize: paging.Size}, nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.Update
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) Update(entities *[]model.CodeParser) error {
- for i := 0; i < len(*entities); i++ {
- entity := &(*entities)[i]
- entity.PlantNr = impl.plantNr
- entity.LastUser = impl.userid
- _, err := impl.session.Table(impl.meta.TableName).Cols(impl.meta.UpdatingMembers...).ID(entity.GetKey()).Update(entity)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- }
- return nil
- }
-
- /******************************************************************************
- *
- * @Reference LAPP_GAAS_GFrame_BACKEND/dao/base/CodeParserDAO.UpdateWhere
- *
- ******************************************************************************/
- func (impl *CodeParserDAOImplement) UpdateWhere(predicates []grmi.Predicate, entity *model.CodeParser, columns ...string) error {
-
- parameters := []interface{}{impl.plantNr}
- where := fmt.Sprintf("%s = ?", meta.CodeParser_PlantNr.ColumnName)
-
- session := impl.session.Table(impl.meta.TableName)
- if predicates != nil {
- for _, predicate := range predicates {
- where += predicate.Build()
- parameters = append(parameters, predicate.Values...)
- }
- session = session.Where(where, parameters...)
- } else {
- session = session.Where(where, parameters...)
- }
-
- columns = append(columns, meta.CodeParser_LastUser.ColumnName)
- entity.LastUser = impl.userid
- _, err := impl.session.Table(impl.meta.TableName).Cols(columns...).Update(entity)
- if err != nil {
- return grmi.NewDataBaseError(err)
- }
- return nil
- }
|