From 6e8718ed56b53419c946102bb4e20a978e32e27c Mon Sep 17 00:00:00 2001 From: wangpengfei <274878379@qq.com> Date: 星期四, 13 七月 2023 15:13:10 +0800 Subject: [PATCH] add --- model/customerServiceSheet.go | 58 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 57 insertions(+), 1 deletions(-) diff --git a/model/customerServiceSheet.go b/model/customerServiceSheet.go index 1fb8026..0a91f29 100644 --- a/model/customerServiceSheet.go +++ b/model/customerServiceSheet.go @@ -1,6 +1,9 @@ package model -import "gorm.io/gorm" +import ( + "aps_crm/pkg/mysqlx" + "gorm.io/gorm" +) type ( CustomerServiceSheet struct { @@ -18,3 +21,56 @@ Orm *gorm.DB } ) + +func (CustomerServiceSheet) TableName() string { + return "customer_service_sheet" +} + +func NewCustomerServiceSheetSearch() *CustomerServiceSheetSearch { + return &CustomerServiceSheetSearch{ + Orm: mysqlx.GetDB(), + } +} + +func (css *CustomerServiceSheetSearch) build() *gorm.DB { + var db = css.Orm.Model(&CustomerServiceSheet{}) + if css.Id != 0 { + db = db.Where("id = ?", css.Id) + } + + return db +} + +func (css *CustomerServiceSheetSearch) Create(record *CustomerServiceSheet) error { + var db = css.build() + return db.Create(record).Error +} + +func (css *CustomerServiceSheetSearch) Update(record *CustomerServiceSheet) error { + var db = css.build() + return db.Updates(record).Error +} + +func (css *CustomerServiceSheetSearch) Delete() error { + var db = css.build() + return db.Delete(&CustomerServiceSheet{}).Error +} + +func (css *CustomerServiceSheetSearch) Find() (*CustomerServiceSheet, error) { + var db = css.build() + var record = &CustomerServiceSheet{} + err := db.First(record).Error + return record, err +} + +func (css *CustomerServiceSheetSearch) FindAll() ([]*CustomerServiceSheet, error) { + var db = css.build() + var records = make([]*CustomerServiceSheet, 0) + err := db.Find(&records).Error + return records, err +} + +func (css *CustomerServiceSheetSearch) SetId(id int) *CustomerServiceSheetSearch { + css.Id = id + return css +} -- Gitblit v1.8.0