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