package com.fgkj.services;

import java.util.List;

import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.dao.impl.Database_backupImpl;
import com.fgkj.dto.Database_backup;
import com.fgkj.dto.ServiceModel;

public class Database_backupService {
	private ServiceModel model;
	private BaseDAO dao;
	
	public Database_backupService() {
		super();
		model=new ServiceModel();
		dao=BaseDAOFactory.getBaseDAO(BaseDAO.DATABASE_BACKUP);
	}
	
	//根据数据库名和表名修改备份数据库的使能(多笔记录)
	public ServiceModel updatePro(Object obj) {
		boolean bl=((Database_backupImpl)dao).updatePro(obj);
		if(bl){
			model.setCode(1);
			model.setMsg("修改成功!");
		}else{
			model.setCode(0);
			model.setMsg("修改失败!");
		}
		return model;
	}
	//根据数据库名和表名修改备份数据库的使能(一键修改)
	public ServiceModel updateProAll() {
		boolean bl=((Database_backupImpl)dao).updateProAll();
		if(bl){
			model.setCode(1);
			model.setMsg("修改成功!");
		}else{
			model.setCode(0);
			model.setMsg("修改失败!");
		}
		return model;
	}
	    
	
	
	//查询所有数据库备份信息
	public ServiceModel searchAll() {
		List list=dao.searchAll();
		if(list!=null&&list.size()>0){
			model.setData(list);
			model.setCode(1);
			model.setMsg("查询成功！");
		}else{
			model.setCode(0);
			model.setMsg("查询失败！");
		}
		return model;
	}
	
	//查询数据库备份表中所有的数据库
	public ServiceModel searchAllDatabase() {
		List list=((Database_backupImpl)dao).searchAllDatabase();
		if(list!=null&&list.size()>0){
			model.setData(list);
			model.setCode(1);
			model.setMsg("查询成功！");
		}else{
			model.setCode(0);
			model.setMsg("查询失败！");
		}
		return model;
	}

	//根据数据库名查询所有的表
	public ServiceModel searchAllTable(Object obj) {
		List list=((Database_backupImpl)dao).searchAllTable(obj);
		if(list!=null&&list.size()>0){
			model.setData(list);
			model.setCode(1);
			model.setMsg("查询成功！");
		}else{
			model.setCode(0);
			model.setMsg("查询失败！");
		}
		return model;
	}
	//查询个数
	public ServiceModel searchNum() {
		Database_backup baseup=new Database_backup();
		//总数
		baseup.setNum(0);
		int sum=((Database_backupImpl)dao).searchNum(baseup);
		//处于备份的数目
		baseup.setNum(1);
		int baseup_num=((Database_backupImpl)dao).searchNum(baseup);
		model.setSum(sum);
		model.setNewsum(baseup_num);
		return model;
	}
}