package com.mandi.fendan.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.mandi.fendan.persist.Fd_Erpconfig;


public interface Fd_ErpconfigMapper {
	@Select("select a.* from fd_erpconfig a where a.id=#{id}")
	public Fd_Erpconfig get(String id);
	
	@Delete("delete from fd_erpconfig where id=#{id}")
	public int del(String id);
	
	@Update("update fd_erpconfig set db=#{db},dbsign=#{dbsign},note=#{note},post=#{post},pwd=#{pwd},uri=#{uri},username=#{username},ztsign=#{ztsign},ztval=#{ztval} where id=#{id}")
	public int update(Fd_Erpconfig fd_erpconfig);
	@Insert("insert into fd_erpconfig(id,db,dbsign,note,post,pwd,uri,username,ztsign,ztval) values (#{id},#{db},#{dbsign},#{note},#{post},#{pwd},#{uri},#{username},#{ztsign},#{ztval})")
	public int insert(Fd_Erpconfig fd_erpconfig);
	public List<Fd_Erpconfig> getList1(Map<String, Object> map);
	
	@Select("select top 1 * from fd_erpconfig where dbsign=#{dbsign}")
	public Fd_Erpconfig getbySign(String dbsign);
	@Select("select * from fd_erpconfig ")
	public List<Fd_Erpconfig> getall();
	
	public List<Fd_Erpconfig> getList(Map<String, Object> mp);
	public int getPages(Map<String, Object> mp);
}