package restful type User struct { Id int `xorm:"not null pk autoincr INT(10)"` Username string `xorm:"default '''' comment('账号') VARCHAR(50)"` Password string `xorm:"default '''' comment('密码') VARCHAR(50)"` Empid int `xorm:"default -1 INT(11)"` Sort int `xorm:"default 0 INT(11)"` Enable int `xorm:"default 1 TINYINT(4)"` CreatedOn int `xorm:"default NULL comment('创建时间') INT(11)"` ModifiedOn int `xorm:"default NULL comment('更新时间') INT(11)"` DeletedOn int `xorm:"default 0 comment('删除时间戳') INT(11)"` } /* type UserRole struct { Id int `xorm:"not null pk autoincr INT(10)"` UserId int `xorm:"default NULL comment('用户ID') INT(11)"` RoleId int `xorm:"default NULL comment('角色ID') INT(11)"` DeletedOn int `xorm:"default 0 comment('删除时间戳') INT(11)"` } type Role struct { Id int `xorm:"not null pk autoincr INT(10)"` Name string `xorm:"default '''' comment('名字') VARCHAR(50)"` Sort int `xorm:"default 0 INT(11)"` Enable int `xorm:"default 1 TINYINT(4)"` CreatedOn int `xorm:"default NULL comment('创建时间') INT(11)"` ModifiedOn int `xorm:"default NULL comment('更新时间') INT(11)"` DeletedOn int `xorm:"default 0 comment('删除时间戳') INT(11)"` } */ func CheckUser(username, password string) (bool, error) { return true, nil } func GetUserInfo(username string) map[string]interface{} { valuesMap := make([]map[string]interface{}, 1) valuesMap2 := make([]map[string]interface{}, 1) tqueryData, err := Dbs.Queryx("SELECT * FROM `user` WHERE `username` = ? and `enable` >0 ", username) if err != nil { return nil } valuesMap, err = rows2mapObjects(tqueryData) if err != nil { return nil } if len(valuesMap) > 0 { tqueryData2, err := Dbs.Queryx("SELECT r.`name`,r.`id` FROM `user` u JOIN `user_role` ur ON u.`id`=ur.`user_id` JOIN `role` r ON r.id=ur.`role_id` WHERE r.`enable`>0 AND u.username=?", username) if err == nil { valuesMap2, err = rows2mapObjects(tqueryData2) if err == nil { valuesMap[0]["role"] = valuesMap2 } } return valuesMap[0] } return nil }