本文整理汇总了Golang中github.com/hjqhezgh/commonlib.PutRecord函数的典型用法代码示例。如果您正苦于以下问题:Golang PutRecord函数的具体用法?Golang PutRecord怎么用?Golang PutRecord使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了PutRecord函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Golang代码示例。
示例1: getParentIdByPhone
//根据电话获取parent表的id
func getParentIdByPhone(phone string) (int64, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select pid from parent where telephone=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, phone)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
var id int64
if rows.Next() {
err = commonlib.PutRecord(rows, &id)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
}
return id, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:31,代码来源:parent.go
示例2: getNewestFreeScheduleIdByChildId
func getNewestFreeScheduleIdByChildId(childId string) (scheduleId, classId string, err error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select schedule_detail_id,wyclass_id from schedule_detail_child where child_id=? and is_free=1 order by id desc "
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, childId)
if err != nil {
lessgo.Log.Error(err.Error())
return "", "", err
}
if rows.Next() {
err = commonlib.PutRecord(rows, &scheduleId, &classId)
if err != nil {
lessgo.Log.Error(err.Error())
return "", "", err
}
}
return scheduleId, classId, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:25,代码来源:scheduleChild.go
示例3: FindAudioById
//根据id查找视频
func FindAudioById(id int) (*Audio, error) {
baseSql := "select aid,cid,start_time,end_time,filename,localphone,remotephone,seconds,`inout` from audio where aid=? "
lessgo.Log.Debug(baseSql)
db := lessgo.GetMySQL()
defer db.Close()
rows, err := db.Query(baseSql, id)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, err
}
audio := new(Audio)
if rows.Next() {
err := commonlib.PutRecord(rows, &audio.Aid, &audio.Cid, &audio.StartTime, &audio.EndTime, &audio.Filename, &audio.LocalPhone, &audio.RemotePhone, &audio.Seconds, &audio.Inout)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, err
}
}
return audio, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:30,代码来源:audio.go
示例4: getVaildNumOfContract
//获取指定合同的有效上课次数,这里的有效指的是正常上课和旷课
func getVaildNumOfContract(id string) (int, error) {
sql := `select count(1) from sign_in where contract_id=? and (type=1 or type=3) `
lessgo.Log.Debug(sql)
db := lessgo.GetMySQL()
defer db.Close()
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
num := 0
if rows.Next() {
err = commonlib.PutRecord(rows, &num)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
}
return num, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:30,代码来源:contract.go
示例5: LoadCourseware
//修改表单数据读取
func LoadCourseware(id string) (loadFormObjects []lessgo.LoadFormObject, err error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select id,name,intro from courseware where id=? "
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
var name, intro string
if rows.Next() {
err := commonlib.PutRecord(rows, &id, &name, &intro)
if err != nil {
lessgo.Log.Warn(err.Error())
return nil, err
}
}
h1 := lessgo.LoadFormObject{"id", id}
h2 := lessgo.LoadFormObject{"name", name}
h3 := lessgo.LoadFormObject{"intro", intro}
loadFormObjects = append(loadFormObjects, h1)
loadFormObjects = append(loadFormObjects, h2)
loadFormObjects = append(loadFormObjects, h3)
return loadFormObjects, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:31,代码来源:courseware.go
示例6: FindChildById
func FindChildById(id string) (Child, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select cid,name,card_id,pid,sex,birthday,hobby,center_id,avatar from child where cid=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Warn(err.Error())
return Child{}, err
}
child := Child{}
if rows.Next() {
err = commonlib.PutRecord(rows, &child.Cid, &child.Name, &child.CardId, &child.Pid, &child.Sex, &child.Birthday, &child.Hobby, &child.CenterId, &child.Avatar)
if err != nil {
lessgo.Log.Warn(err.Error())
return Child{}, err
}
}
return child, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:28,代码来源:child.go
示例7: FindEmployeeById
//根据id获取员工信息
func FindEmployeeById(id int) (Employee, error) {
var employee Employee
db := lessgo.GetMySQL()
defer db.Close()
sql := "select user_id,username,really_name,department_id,center_id from employee where user_id=?"
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Error(err.Error())
return employee, err
}
if rows.Next() {
err := commonlib.PutRecord(rows, &employee.UserId, &employee.UserName, &employee.ReallyName, &employee.DepartmentId, &employee.CenterId)
if err != nil {
lessgo.Log.Error(err.Error())
return employee, err
}
}
return employee, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:26,代码来源:employee.go
示例8: checkScheduleExist
func checkScheduleExist(centerId, roomId, timeId, dayDate string) (flag bool, err error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select id from class_schedule_detail where center_id=? and room_id=? and time_id=? and day_date=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, centerId, roomId, timeId, dayDate)
if err != nil {
lessgo.Log.Error(err.Error())
return false, err
}
scheduleDetailId := 0
if rows.Next() {
err = commonlib.PutRecord(rows, &scheduleDetailId)
if err != nil {
lessgo.Log.Error(err.Error())
return false, err
}
}
if scheduleDetailId == 0 {
return false, nil
}
return true, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:31,代码来源:scheduleDetail.go
示例9: FindClassById
func FindClassById(id string) (WyClass, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select wc.class_id,wc.assistant_id,wc.name,wc.course_id,wc.center_id,wc.child_num,wc.end_time,wc.deadline,wc.max_child_num,wc.teacher_id,c.is_probation from wyclass wc left join course c on wc.course_id=c.cid where wc.class_id=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Warn(err.Error())
return WyClass{}, err
}
class := WyClass{}
if rows.Next() {
err = commonlib.PutRecord(rows, &class.ClassId, &class.AssistantId, &class.Name, &class.CourseId, &class.CenterId, &class.ChildNum, &class.EndTime, &class.DeadLine, &class.MaxChildNum, &class.TeacherId, &class.IsProbation)
if err != nil {
lessgo.Log.Warn(err.Error())
return WyClass{}, err
}
}
return class, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:28,代码来源:wyclass.go
示例10: GetNewsById
func GetNewsById(id string) (*News, string, error) {
sql := "select title, news_content, preview_image, preview_text, is_carousel, carousel_image, upload_time from news where id=?;"
lessgo.Log.Debug(sql, id)
rows, err := DBSelect(sql, id)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, "查询用户信息出错", err
}
news := new(News)
news.Id, _ = strconv.Atoi(id)
if rows.Next() {
err = commonlib.PutRecord(rows, &news.Title, &news.NewsContent, &news.PreviewImage,
&news.PreviewText, &news.IsCarousel, &news.CarouselImage, &news.UploadTime)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, "封装用户信息出错", err
}
news.UploadTime = TimeFormat(news.UploadTime)
}
lessgo.Log.Debug(news)
return news, "处理成功", nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:25,代码来源:news.go
示例11: getContractIdByChildIdAndScheduleId
/*
select id,child_id,apply_time,contract_no,parent_id,price,employee_id,center_id,course_id,left_lesson_num,type,status,expire_date from contract where id=?
*/
func getContractIdByChildIdAndScheduleId(childId, scheduleId string) (contractId, isFree string, err error) {
sql := `select contract_id,is_free from schedule_detail_child where child_id=? and schedule_detail_id=?`
lessgo.Log.Debug(sql)
db := lessgo.GetMySQL()
defer db.Close()
rows, err := db.Query(sql, childId, scheduleId)
if err != nil {
lessgo.Log.Error(err.Error())
return "0", "", err
}
if rows.Next() {
err = commonlib.PutRecord(rows, &contractId, &isFree)
}
if err != nil {
lessgo.Log.Error(err.Error())
return "0", "", err
}
return contractId, isFree, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:29,代码来源:contract.go
示例12: getChildByParentId
//todo 目前只返回第一个孩子的id,逻辑有待优化
func getChildByParentId(pid string) (int64, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select cid from child where pid=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, pid)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
var id int64
if rows.Next() {
err = commonlib.PutRecord(rows, &id)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
}
return id, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:31,代码来源:child.go
示例13: getChildByConsumerId
//todo 目前只返回第一个孩子的id,逻辑有待优化
func getChildByConsumerId(consumerId string) (int64, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select ch.cid from child ch left join consumer_new cons on cons.parent_id=ch.pid where cons.id=?"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, consumerId)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
var id int64
if rows.Next() {
err = commonlib.PutRecord(rows, &id)
if err != nil {
lessgo.Log.Error(err.Error())
return 0, err
}
}
return id, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:31,代码来源:child.go
示例14: checkScheduleTempChildExist
func checkScheduleTempChildExist(childId, scheduleTempId string) (flag bool, err error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := " select count(1) from schedule_template_child where child_id=? and schedule_template_id=? "
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, childId, scheduleTempId)
if err != nil {
lessgo.Log.Error(err.Error())
return false, err
}
num := 0
if rows.Next() {
err = commonlib.PutRecord(rows, &num)
if err != nil {
lessgo.Log.Error(err.Error())
return false, err
}
}
if num > 0 {
return true, nil
}
return false, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:34,代码来源:scheduleTemp.go
示例15: FindLessonById
func FindLessonById(id string) (Lesson, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select lid,course_id,caption,teacher_id,keystone,lesson_time,order_no,is_last from lesson where lid=? "
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Warn(err.Error())
return Lesson{}, err
}
lesson := Lesson{}
if rows.Next() {
err = commonlib.PutRecord(rows, &lesson.Lid, &lesson.CourseId, &lesson.Caption, &lesson.TeacherId, &lesson.KeyStone, &lesson.LessonTime, &lesson.OrderNo, &lesson.IsLast)
if err != nil {
lessgo.Log.Warn(err.Error())
return Lesson{}, err
}
}
return lesson, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:29,代码来源:lesson.go
示例16: FindTimeSectionById
func FindTimeSectionById(id string) (TimeSection, error) {
db := lessgo.GetMySQL()
defer db.Close()
sql := "select id,center_id,start_time,end_time,lesson_no from time_section where id=? "
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
if err != nil {
lessgo.Log.Warn(err.Error())
return TimeSection{}, err
}
timeSection := TimeSection{}
if rows.Next() {
err = commonlib.PutRecord(rows, &timeSection.Id, &timeSection.CenterId, &timeSection.StartTime, &timeSection.EndTime, &timeSection.LessonNo)
if err != nil {
lessgo.Log.Warn(err.Error())
return TimeSection{}, err
}
}
return timeSection, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:29,代码来源:time_section.go
示例17: getFurtherScheduleIds
func getFurtherScheduleIds(timeId, roomId, week, startTime, courseId string) ([]string, error) {
sql := `
select id from class_schedule_detail where time_id=? and room_id=? and week=? and start_time>=? and course_id=?`
lessgo.Log.Debug(sql)
db := lessgo.GetMySQL()
defer db.Close()
rows, err := db.Query(sql, timeId, roomId, week, startTime, courseId)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, err
}
ids := []string{}
for rows.Next() {
id := ""
err := commonlib.PutRecord(rows, &id)
if err != nil {
lessgo.Log.Error(err.Error())
return nil, err
}
ids = append(ids, id)
}
return ids, nil
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:33,代码来源:scheduleDetail.go
示例18: EmployeeListByRoleIdAction
//根据角色ID获取员工列表
func EmployeeListByRoleIdAction(w http.ResponseWriter, r *http.Request) {
m := make(map[string]interface{})
err := r.ParseForm()
if err != nil {
m["success"] = false
m["code"] = 100
m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
commonlib.OutputJson(w, m, " ")
return
}
id := r.FormValue("id")
db := lessgo.GetMySQL()
defer db.Close()
sql := "select e.user_id,e.really_name from (select distinct(user_id) uid from employee_role where role_id =?) a left join employee e on a.uid = e.user_id"
lessgo.Log.Debug(sql)
rows, err := db.Query(sql, id)
if err != nil {
m["success"] = false
m["code"] = 100
m["msg"] = "出现错误,请联系IT部门,错误信息:" + err.Error()
commonlib.OutputJson(w, m, " ")
return
}
employees := []lessgo.Employee{}
for rows.Next() {
employee := lessgo.Employee{}
err := commonlib.PutRecord(rows, &employee.UserId, &employee.ReallyName)
if err != nil {
lessgo.Log.Warn(err.Error())
m["success"] = false
m["code"] = 100
m["msg"] = "系统发生错误,请联系IT部门"
commonlib.OutputJson(w, m, " ")
return
}
employees = append(employees, employee)
}
m["success"] = true
m["code"] = 200
m["datas"] = employees
commonlib.OutputJson(w, m, " ")
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:58,代码来源:employee.go
示例19: FindById
//根据id查找对象
func FindById(entity Entity, id string) (*Model, error) {
dataSql := "select " + entity.Pk + ","
for index, field := range entity.Fields {
dataSql += field.Name
if index < len(entity.Fields)-1 {
dataSql += ","
}
}
dataSql += " from " + entity.Id + " where " + entity.Pk + "=?"
Log.Debug(dataSql)
db := DBPool{}.getMySQL()
defer db.Close()
rows, err := db.Query(dataSql, id)
if err != nil {
Log.Warn(err.Error())
return nil, err
}
model := new(Model)
model.Entity = entity
model.Id = 0
model.Props = []*Prop{}
if rows.Next() {
fillObjects := []interface{}{}
fillObjects = append(fillObjects, &model.Id)
for _, field := range entity.Fields {
prop := new(Prop)
prop.Name = field.Name
prop.Value = ""
fillObjects = append(fillObjects, &prop.Value)
model.Props = append(model.Props, prop)
}
err = commonlib.PutRecord(rows, fillObjects...)
if err != nil {
return nil, err
}
}
return model, nil
}
开发者ID:huangjq,项目名称:lessgo,代码行数:54,代码来源:server.go
示例20: CheckPwd
func CheckPwd(username, password string) (bool, lessgo.Employee, string) {
var employee lessgo.Employee
var dbPwd string
db := lessgo.GetMySQL()
defer db.Close()
sql := "select user_id,username,password,really_name,department_id from employee where username=?"
rows, err := db.Query(sql, username)
if err != nil {
lessgo.Log.Error(err.Error())
return false, employee, " 数据库异常!"
}
if rows.Next() {
err := rows.Scan(&employee.UserId, &employee.UserName,
&dbPwd, &employee.ReallyName, &employee.DepartmentId)
if err != nil {
lessgo.Log.Error(err.Error())
return false, employee, " 数据库异常!"
}
}
if password != dbPwd {
lessgo.Log.Warn("密码错误:", username, " : ", password)
return false, employee, "密码错误"
}
sql = "select r.role_id,r.level,r.code from employee_role er left join role r on r.role_id=er.role_id where er.user_id=?"
rows, err = db.Query(sql, employee.UserId)
if err != nil {
lessgo.Log.Error(err.Error())
return false, employee, " 数据库异常!"
}
var roleId, roleCode, roleLevel string
for rows.Next() {
err := commonlib.PutRecord(rows, &roleId, &roleLevel, &roleCode)
if err != nil {
lessgo.Log.Error(err.Error())
return false, employee, " 数据库异常!"
}
employee.RoleId += roleId + ","
employee.RoleCode += roleCode + ","
employee.RoleLevel += roleLevel + ","
}
lessgo.Log.Info(employee)
return true, employee, ""
}
开发者ID:hjqhezgh,项目名称:wooyou-admin,代码行数:49,代码来源:employee.go
注:本文中的github.com/hjqhezgh/commonlib.PutRecord函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论