package com.fgkj.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.fgkj.actions.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.CallBack;
import com.fgkj.dao.DAOHelper;
import com.fgkj.db.DBUtil;
import com.fgkj.db.IDatabaseName;
import com.fgkj.dto.Custompage;

public class CustompageImpl extends ActionUtil implements BaseDAO,CallBack {

	public List getResults(ResultSet rs) {
		List list=new ArrayList();
		try {
			while(rs.next()){
				Custompage cpage=new Custompage();
				
				cpage.setNum(rs.getInt("num"));
				cpage.setNavigate(rs.getString("navigate"));
				cpage.setNavigate_order(rs.getInt("navigate_order"));
				cpage.setSubmenu(rs.getString("submenu"));
				cpage.setSubflag(rs.getInt("subflag"));
				cpage.setSublink(rs.getString("sublink"));
				cpage.setSubenable(rs.getInt("subenable"));
				cpage.setSubjudge(rs.getInt("subjudge"));
				if(cpage.getSubjudge()==2){
					cpage.setSubname(getText(cpage.getNavigate()));					
				}else if(cpage.getSubjudge()==1){
					cpage.setSubname(getText(cpage.getSubmenu()));
				}else{
					cpage.setSubname(rs.getString("subname"));
				}
				cpage.setPage_order(rs.getInt("page_order"));
				//System.out.println(cpage);
				list.add(cpage);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
    //页面定制下添加导航或者子页面
	public boolean add(Object obj) {
		Custompage cpage=(Custompage) obj;
		String sql="insert into web_site.tb_custompage(navigate,navigate_order,submenu,subflag,sublink,subenable,subname,subjudge,page_order) values(?,?,?,?,?,?,?,?,?)";
		Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{
			cpage.getNavigate(),cpage.getNavigate_order(),cpage.getSubmenu(),cpage.getSubflag()
			,cpage.getSublink(),cpage.getSubenable(),cpage.getSubname(),cpage.getSubjudge()
			,cpage.getPage_order()});
		return bl;
	}
    //页面定制可以看到的子菜单和子模块
	public boolean update(Object obj) {
		Custompage cpage=(Custompage) obj;
		String sql="update web_site.tb_custompage set subflag=? where num=? ";
		Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{
			cpage.getSubflag(),cpage.getNum()});
		return bl;
	}
	//页面定制修改主导航下子页面的顺序
	public boolean updateOrder(Object obj) {
		Custompage cpage=(Custompage) obj;
		String sql="update web_site.tb_custompage set page_order=? where num=? ";
		Boolean bl=DAOHelper.executeUpdate( DBUtil.getConn(),sql, new Object[]{
			cpage.getPage_order(),cpage.getNum()});
		return bl;
	}
    
	public boolean del(Object obj) {
		// TODO Auto-generated method stub
		return false;
	}
	
    //查询所有的菜单(页面定制可以看到的子菜单和子模块)
	public List searchAll() {
		String sql="select num,navigate,navigate_order,submenu,subflag,sublink,page_order," +
				"subenable,subname,subjudge from web_site.tb_custompage order by navigate_order,page_order ";
	    List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CustompageImpl());	    
		return list;
	}

	//根据页面查询子模块
	public List serchByCondition(Object obj) {
		Custompage cpage=(Custompage) obj;
		String sql="select  num,navigate,navigate_order,submenu,subflag,sublink,page_order," +
				"subenable,subname,subjudge from web_site.tb_custompage where navigate=? and subjudge=? order by page_order";
		List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cpage.getNavigate() ,cpage.getSubjudge()},new CustompageImpl());
		return list;
	}
    //根据主导航的名字查询所有的子页面
	public List serchByInfo(Object obj) {
		Custompage cpage=(Custompage) obj;
		String sql="select num,navigate,navigate_order,submenu,subflag,sublink,page_order," +
				"subenable,subname,subjudge from web_site.tb_custompage where navigate=?  order by navigate_order,page_order ";
	    List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{cpage.getNavigate()}, new CustompageImpl());	    
		return list;
	}
	public static void main(String[] args) {
		CustompageImpl cimpl=new CustompageImpl();
		Custompage cpage=new Custompage();
		cpage.setNum(25);
		cpage.setNavigate_order(5);
		cpage.setSubflag(1);
		cpage.setSubenable(0);
		cpage.setSubjudge(1);
		List<Custompage> list=cimpl.searchAll();
		for (Custompage c : list) {
			System.out.println(c);
		}
		//Boolean bl=cimpl.update(cpage);
		//System.out.println(bl);
	}
}