/**
* 按主键查找一条数据
*
* @param dbManager DB管理器
* @param userNo 户号
* @param flag 标志
* @return lwTownProrateAppendDto lwTownProrateAppendDto
* @throws Exception
*/
public LwTownProrateAppendDto findByPrimaryKey(DBManager dbManager, String userNo, String flag)
throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
// 声明DTO
LwTownProrateAppendDto lwTownProrateAppendDto = null;
// 查询数据,赋值给DTO
lwTownProrateAppendDto = dbLwTownProrateAppend.findByPrimaryKey(userNo, flag);
return lwTownProrateAppendDto;
}
/**
* 查询满足模糊查询条件的记录数
*
* @param dbManager DB管理器
* @param conditions 模糊查询条件
* @return 满足模糊查询条件的记录数
* @throws Exception
*/
public int getCount(DBManager dbManager, String conditions) throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
int count = dbLwTownProrateAppend.getCount(conditions);
return count;
}
/**
* 按条件查询多条数据
*
* @param dbManager DB管理器
* @param conditions 查询条件
* @return Collection 包含lwTownProrateAppendDto的集合
* @throws Exception
*/
public Collection findByConditions(DBManager dbManager, String conditions) throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
Collection collection = new ArrayList();
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
collection = dbLwTownProrateAppend.findByConditions(conditions);
return collection;
}
/**
* 按条件查询多条数据
*
* @param dbManager DB管理器
* @param conditions 查询条件
* @param pageNo 页号
* @param rowsPerPage 每页的行数
* @return PageRecord 查询的一页的结果
* @throws Exception
*/
public PageRecord findByConditions(
DBManager dbManager, String conditions, int pageNo, int rowsPerPage) throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
Collection collection = new ArrayList();
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
int count = dbLwTownProrateAppend.getCount(SqlUtils.getWherePartForGetCount(conditions));
collection = dbLwTownProrateAppend.findByConditions(conditions, pageNo, rowsPerPage);
PageRecord pageRecord = new PageRecord(count, pageNo, 1, rowsPerPage, collection);
return pageRecord;
}
/**
* 按主键更新一条数据(主键本身无法变更)
*
* @param dbManager DB管理器
* @param lwTownProrateAppendDto lwTownProrateAppendDto
* @throws Exception
*/
public void update(DBManager dbManager, LwTownProrateAppendDto lwTownProrateAppendDto)
throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
// 更新记录
dbLwTownProrateAppend.update(lwTownProrateAppendDto);
}
/**
* 按条件删除数据
*
* @param dbManager DB管理器
* @param conditions 删除条件
* @throws Exception
*/
public void deleteByConditions(DBManager dbManager, String conditions) throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
// 按条件删除记录
dbLwTownProrateAppend.deleteByConditions(conditions);
}
/**
* 按主键删除一条数据
*
* @param dbManager DB管理器
* @param userNo 户号
* @param flag 标志
* @throws Exception
*/
public void delete(DBManager dbManager, String userNo, String flag) throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
// 删除记录
dbLwTownProrateAppend.delete(userNo, flag);
}
/**
* 插入一条数据
*
* @param dbManager DB管理器
* @param lwTownProrateAppendDto lwTownProrateAppendDto
* @throws Exception
*/
public void insert(DBManager dbManager, LwTownProrateAppendDto lwTownProrateAppendDto)
throws Exception {
DBLwTownProrateAppend dbLwTownProrateAppend = new DBLwTownProrateAppend(dbManager);
// 插入记录
dbLwTownProrateAppend.insert(lwTownProrateAppendDto);
}