|
|
package com.dsideal.FengHuang.BaseClass.model;
|
|
|
|
|
|
import com.alibaba.fastjson.JSONObject;
|
|
|
import com.jfinal.kit.Kv;
|
|
|
import com.jfinal.plugin.activerecord.Db;
|
|
|
import com.jfinal.plugin.activerecord.Page;
|
|
|
import com.jfinal.plugin.activerecord.Record;
|
|
|
import com.jfinal.plugin.activerecord.SqlPara;
|
|
|
|
|
|
/**
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
*/
|
|
|
public class BaseClassModel {
|
|
|
|
|
|
/**
|
|
|
* 功能：增加班级
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
* @return
|
|
|
*/
|
|
|
public int addBaseClass(String class_name,String altas_name,int class_num,char class_code,int stage_id,int entry_year,int school_length,int b_use,char city_id,char area_id,char main_school_id,char bureau_id,char org_id,datetime create_time,timestamp update_ts,int id_int,char operator,bigint ip_address)
|
|
|
{
|
|
|
Record record=new Record();
|
|
|
|
|
|
record.set("class_name",class_name);
|
|
|
record.set("altas_name",altas_name);
|
|
|
record.set("class_num",class_num);
|
|
|
record.set("class_code",class_code);
|
|
|
record.set("stage_id",stage_id);
|
|
|
record.set("entry_year",entry_year);
|
|
|
record.set("school_length",school_length);
|
|
|
record.set("b_use",b_use);
|
|
|
record.set("city_id",city_id);
|
|
|
record.set("area_id",area_id);
|
|
|
record.set("main_school_id",main_school_id);
|
|
|
record.set("bureau_id",bureau_id);
|
|
|
record.set("org_id",org_id);
|
|
|
record.set("create_time",create_time);
|
|
|
record.set("update_ts",update_ts);
|
|
|
record.set("id_int",id_int);
|
|
|
record.set("operator",operator);
|
|
|
record.set("ip_address",ip_address);
|
|
|
Db.save("t_base_class","class_id",record);
|
|
|
return record.getInt("class_id");
|
|
|
}
|
|
|
/**
|
|
|
* 功能：修改班级
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
* @return
|
|
|
*/
|
|
|
public void updateBaseClass(char class_id,String class_name,String altas_name,int class_num,char class_code,int stage_id,int entry_year,int school_length,int b_use,char city_id,char area_id,char main_school_id,char bureau_id,char org_id,datetime create_time,timestamp update_ts,int id_int,char operator,bigint ip_address)
|
|
|
{
|
|
|
Record record = Db.findById("t_base_class", "class_id", class_id);
|
|
|
|
|
|
record.set("class_name",class_name);
|
|
|
record.set("altas_name",altas_name);
|
|
|
record.set("class_num",class_num);
|
|
|
record.set("class_code",class_code);
|
|
|
record.set("stage_id",stage_id);
|
|
|
record.set("entry_year",entry_year);
|
|
|
record.set("school_length",school_length);
|
|
|
record.set("b_use",b_use);
|
|
|
record.set("city_id",city_id);
|
|
|
record.set("area_id",area_id);
|
|
|
record.set("main_school_id",main_school_id);
|
|
|
record.set("bureau_id",bureau_id);
|
|
|
record.set("org_id",org_id);
|
|
|
record.set("create_time",create_time);
|
|
|
record.set("update_ts",update_ts);
|
|
|
record.set("id_int",id_int);
|
|
|
record.set("operator",operator);
|
|
|
record.set("ip_address",ip_address);
|
|
|
Db.update("t_base_class","class_id",record);
|
|
|
}
|
|
|
/**
|
|
|
* 功能：删除班级
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
* @return
|
|
|
*/
|
|
|
public void deleteBaseClassById(char class_id)
|
|
|
{
|
|
|
Record record = Db.findById("t_base_class", "class_id", class_id);
|
|
|
record.set("b_use",0);
|
|
|
Db.update("t_base_class","class_id",record);
|
|
|
//Db.deleteById("t_base_class","class_id",class_id);
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* 功能：获取班级分页数据
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
* @return
|
|
|
*/
|
|
|
public Page<Record> getBaseClassPage(int page,int limit)
|
|
|
{
|
|
|
//Kv kv=Kv.by("startDate",startDate).set("endDate",endDate);
|
|
|
SqlPara sqlPara = Db.getSqlPara("BaseClass.getBaseClassPage");
|
|
|
String sql = sqlPara.getSql();
|
|
|
String totalRowSql = "select count(*) from (" + sql + " ) as t100";
|
|
|
String findSql = "select * from (" + sql + " ) as t100 ";
|
|
|
Page<Record> pageRecord = Db.paginateByFullSql(page, limit, totalRowSql, findSql);
|
|
|
return pageRecord;
|
|
|
}
|
|
|
/**
|
|
|
* 功能：获取班级某一条记录信息
|
|
|
* 作者：黄海
|
|
|
* 时间：2022-07-23
|
|
|
* @return
|
|
|
*/
|
|
|
public Record getBaseClassById(char class_id) {
|
|
|
return Db.findById("t_base_class","class_id",class_id);
|
|
|
}
|
|
|
}
|
