package models
|
|
import (
|
"github.com/astaxie/beego/orm"
|
)
|
|
type User struct {
|
Id string `orm:"pk;size(50);column(id)" json:"id"`
|
Username string `orm:"size(250);column(username)" json:"username"`
|
PhoneNum string `orm:"size(20);column(phoneNum)" json:"phoneNum"` //手机号
|
Password string `orm:"size(50);column(password)" json:"password"`
|
TrueName string `orm:"size(250);column(trueName)" json:"trueName"` //真实姓名
|
Gender int `orm:"size(1);column(gender)" json:"gender"` //性别
|
IdCard string `orm:"size(250);column(idCard)" json:"idCard"` //身份证号
|
Age int `orm:"size(8);column(age)" json:"age"` //年龄
|
Address string `orm:"size(200);column(address)" json:"gender"` //地址
|
|
Email string `orm:"size(200);column(email)" json:"email"` //邮箱
|
IsDelete bool `orm:"size(1);default(0);column(isDelete)" json:"isDelete"`
|
}
|
|
func (u *User) TableName() string {
|
return "sys_user"
|
}
|
|
func (u *User) Insert() (int64,error) {
|
o := orm.NewOrm()
|
return o.Insert(u)
|
}
|
|
func (u *User) SelectById(uid string) error {
|
o := orm.NewOrm()
|
err := o.QueryTable(u.TableName()).Filter("id", uid).One(u)
|
return err
|
}
|
|
func (u *User) SelectByPhoneNum(phoneNum string) error {
|
o := orm.NewOrm()
|
err := o.QueryTable(u.TableName()).Filter("phoneNum", phoneNum).One(u)
|
return err
|
}
|
|
func (u *User) GetAllUsers() (all []User,err error) {
|
o := orm.NewOrm()
|
_, err = o.QueryTable(u.TableName()).All(&all)
|
if err != nil {
|
return nil, err
|
}
|
return all,nil
|
}
|
|
func (u *User) GetAllMap() (map[string]User) {
|
idM := make(map[string]User)
|
all, _ := u.GetAllUsers()
|
if all !=nil {
|
for _,p := range all {
|
idM[p.Id] = p
|
}
|
}
|
return idM
|
}
|
|
func (u *User) Update() (int64, error) {
|
o := orm.NewOrm()
|
return o.Update(u)
|
}
|
|
func (u *User) UpdatePhoneNum(phoneNum string, hikPersonId string) (int64, error) {
|
o := orm.NewOrm()
|
res, err := o.Raw("update sys_user set phoneNum=? where id=?", phoneNum, hikPersonId).Exec()
|
if err != nil {
|
return 0, err
|
}
|
return res.RowsAffected()
|
}
|
|
func Login(username, password string) bool {
|
|
return false
|
}
|
|
func (u *User) DeleteById() (int64, error) {
|
o := orm.NewOrm()
|
return o.Update(u, "isDelete")
|
}
|
|
func (u *User) Delete(id string) (int64, error) {
|
o := orm.NewOrm()
|
res, err := o.Raw("delete from sys_user where id=?", id).Exec()
|
if err != nil {
|
return 0, err
|
}
|
return res.RowsAffected()
|
}
|
