| | |
| | | package models |
| | | |
| | | import ( |
| | | "errors" |
| | | "vamicro/extend/util" |
| | | ) |
| | | |
| | | type SysUser struct { |
| | | Id string `gorm:"column:id;primary_key;type:varchar(50);unique;not null;" json:"id"` |
| | | Username string `gorm:"column:username;type varchar(100);unique_index" json:"username"` |
| | | Password string `gorm:"column:password;type:varchar(100);" json:"password"` |
| | | Sort int `gorm:"column:sort;default:1;" json:"sort"` |
| | | Nickname string `gorm:"column:nickname;type varchar(100);default:'';" json:"nickname"` |
| | | HeadPic string `gorm:"column:headpic;type varchar(100);default:'';" json:"headpic"` |
| | | BackgroundPic string `gorm:"column:backgroundpic;type varchar(100);default:'';" json:"backgroundpic"` |
| | | |
| | | UseIconType int `gorm:"column:useIconType;default:1;" json:"useIconType"` |
| | | } |
| | | |
| | | const ( |
| | | RecordNotFound = "record not found" |
| | | DefaultBgPic = "/images/desktop/background.png" |
| | | ) |
| | | |
| | | func (SysUser) TableName() string { |
| | | return "sys_user" |
| | | } |
| | | |
| | | func (su *SysUser) FindByName(username string) (rows int64,err error){ |
| | | result := db.Table("sys_user").Where("username=?",username).First(&su) |
| | | if result.Error !=nil && result.Error.Error() != RecordNotFound { |
| | | return 0,result.Error |
| | | } |
| | | return result.RowsAffected,nil |
| | | } |
| | | |
| | | func (su *SysUser) SelectById(id string) (rows int64,err error) { |
| | | result := db.Table("sys_user").Where("id=?",id).First(&su) |
| | | if result.Error !=nil { |
| | | return 0,err |
| | | } |
| | | return result.RowsAffected,nil |
| | | } |
| | | |
| | | func (su *SysUser) UpdatePwd(userId string, encryPwd string) bool { |
| | | result := db.Exec("update sys_user set password=? where id=?",encryPwd,userId) |
| | | if result.Error ==nil &&result.RowsAffected >0 { |
| | | return true |
| | | } |
| | | return false |
| | | } |
| | | |
| | | func (su *SysUser) FindAll() (list []SysUser,err error) { |
| | | err = db.Table("sys_user").Order("sort asc").Find(&list).Error |
| | | if err !=nil { |
| | | return nil,err |
| | | } else { |
| | | return list,nil |
| | | } |
| | | } |
| | | |
| | | func (su *SysUser) Insert()(bool,error){ |
| | | if su.Id == ""{ |
| | | su.Id = util.PseudoUuid() |
| | | } |
| | | result:=db.Table("sys_user").Create(&su) |
| | | if result.Error !=nil { |
| | | return false,result.Error |
| | | } |
| | | return result.RowsAffected>0,nil |
| | | } |
| | | |
| | | func (su *SysUser) DeleteById(id string) (bool,error) { |
| | | result := db.Exec("delete from "+su.TableName()+" where id=?", id) |
| | | if result.Error != nil { |
| | | return false, result.Error |
| | | } |
| | | if result.RowsAffected >0 { |
| | | return true, nil |
| | | } |
| | | return false, errors.New("del user err") |
| | | package models
|
| | |
|
| | | import (
|
| | | "errors"
|
| | | "vamicro/extend/util"
|
| | | )
|
| | |
|
| | | type SysUser struct {
|
| | | Id string `gorm:"column:id;primary_key;type:varchar(50);unique;not null;" json:"id"`
|
| | | Username string `gorm:"column:username;type varchar(100);unique_index" json:"username"`
|
| | | Password string `gorm:"column:password;type:varchar(100);" json:"password"`
|
| | | Sort int `gorm:"column:sort;default:1;" json:"sort"`
|
| | | Nickname string `gorm:"column:nickname;type varchar(100);default:'';" json:"nickname"`
|
| | | HeadPic string `gorm:"column:headpic;type varchar(100);default:'';" json:"headpic"`
|
| | | BackgroundPic string `gorm:"column:backgroundpic;type varchar(100);default:'';" json:"backgroundpic"`
|
| | |
|
| | | UseIconType int `gorm:"column:useIconType;default:1;" json:"useIconType"`
|
| | | }
|
| | |
|
| | | const (
|
| | | RecordNotFound = "record not found"
|
| | | DefaultBgPic = "/images/desktop/background.png"
|
| | | )
|
| | |
|
| | | func (SysUser) TableName() string {
|
| | | return "sys_user"
|
| | | }
|
| | |
|
| | | func (su *SysUser) FindByName(username string) (rows int64,err error){
|
| | | result := db.Table("sys_user").Where("username=?",username).First(&su)
|
| | | if result.Error !=nil && result.Error.Error() != RecordNotFound {
|
| | | return 0,result.Error
|
| | | }
|
| | | return result.RowsAffected,nil
|
| | | }
|
| | |
|
| | | func (su *SysUser) SelectById(id string) (rows int64,err error) {
|
| | | result := db.Table("sys_user").Where("id=?",id).First(&su)
|
| | | if result.Error !=nil {
|
| | | return 0,err
|
| | | }
|
| | | return result.RowsAffected,nil
|
| | | }
|
| | |
|
| | | func (su *SysUser) UpdatePwd(userId string, encryPwd string) bool {
|
| | | result := db.Exec("update sys_user set password=? where id=?",encryPwd,userId)
|
| | | if result.Error ==nil &&result.RowsAffected >0 {
|
| | | return true
|
| | | }
|
| | | return false
|
| | | }
|
| | |
|
| | | func (su *SysUser) FindAll() (list []SysUser,err error) {
|
| | | err = db.Table("sys_user").Order("sort asc").Find(&list).Error
|
| | | if err !=nil {
|
| | | return nil,err
|
| | | } else {
|
| | | return list,nil
|
| | | }
|
| | | }
|
| | |
|
| | | func (su *SysUser) Insert()(bool,error){
|
| | | if su.Id == ""{
|
| | | su.Id = util.PseudoUuid()
|
| | | }
|
| | | result:=db.Table("sys_user").Create(&su)
|
| | | if result.Error !=nil {
|
| | | return false,result.Error
|
| | | }
|
| | | return result.RowsAffected>0,nil
|
| | | }
|
| | |
|
| | | func (su *SysUser) DeleteById(id string) (bool,error) {
|
| | | result := db.Exec("delete from "+su.TableName()+" where id=?", id)
|
| | | if result.Error != nil {
|
| | | return false, result.Error
|
| | | }
|
| | | if result.RowsAffected >0 {
|
| | | return true, nil
|
| | | }
|
| | | return false, errors.New("del user err")
|
| | | } |