示例#1
0
func (this *OrganizationController) Add() {
	pid, err := this.GetInt("pid")
	unitname := this.GetString("UnitName")
	sortrank, _ := this.GetInt("SortRank")
	remark := this.GetString("Remark")

	o := orm.NewOrm()
	qs := o.QueryTable("organization_unit")

	num, _ := qs.Filter("unitname", unitname).Count()
	if num > 0 {
		this.Data["json"] = &Rsp{Success: false, Msg: "已有相同名称的学校!"}
		this.ServeJson()
		return
	}

	var organization models.OrganizationUnit
	organization.UnitName = unitname
	organization.Pid = int(pid)
	organization.SortRank = uint8(sortrank)
	organization.Remark = remark
	organization.Status = 1

	_, err = o.Insert(&organization)
	if err != nil {
		beego.Error(err)
		this.Data["json"] = &Rsp{Success: false, Msg: "新建学校失败!"}
		this.ServeJson()
		return
	}

	this.Data["json"] = &Rsp{Success: true, Msg: "新建学校成功!"}
	this.ServeJson()
}
示例#2
0
func (this *OrganizationController) Modify() {
	id, err := this.GetInt("id")
	beego.Info(id)
	pid, err := this.GetInt("Pid")
	unitname := this.GetString("UnitName")
	sortrank, err := this.GetInt("SortRank")
	remark := this.GetString("Remark")

	o := orm.NewOrm()
	qs := o.QueryTable("organization_unit")

	num, _ := qs.Filter("id", id).Count()
	if num != 1 {
		this.Data["json"] = &Rsp{Success: false, Msg: "找不到此组织机构,无法修改!"}
		this.ServeJson()
		return
	}

	var organization models.OrganizationUnit
	err = qs.Filter("id", id).One(&organization)
	if err != nil {
		this.Data["json"] = &Rsp{Success: false, Msg: "读取组织机构信息出错!"}
		this.ServeJson()
		return
	}
	organization.Pid = int(pid)
	organization.UnitName = unitname
	organization.SortRank = uint8(sortrank)
	organization.Remark = remark
	organization.Status = 1

	_, err = o.Update(&organization)
	if err != nil {
		beego.Error(err)
		this.Data["json"] = &Rsp{Success: false, Msg: "无法修改组织机构,插入数据有错!"}
		this.ServeJson()
		return
	}

	//更新有子节点的status状态为0,无子结点的状态为1
	_, err = o.Raw("update `organization_unit` a inner join (select id from `organization_unit` where id in (select distinct pid from `organization_unit`)) b on a.id=b.id set status=0").Exec()
	if err != nil {
		beego.Error(err)
	}
	_, err = o.Raw("update `organization_unit` a inner join (select id from `organization_unit` where id not in (select distinct pid from `organization_unit`)) b on a.id=b.id set status=1").Exec()
	if err != nil {
		beego.Error(err)
	}

	this.Data["json"] = &Rsp{Success: true, Msg: "成功修改组织机构!"}
	this.ServeJson()
}