package com.mandi.fendan.mapper;

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

import com.mandi.fendan.persist.BsheetEcgb;

public interface BsheetEcgbMapper {
	
	@Select("select * from bsheet_ecgb where bsNo=#{bsNo} ")
	public BsheetEcgb getbyNo(String bsNo);
	
	@Insert("insert into bsheet_ecgb (bsNo,ctime,cname,sate) values (#{bsNo},#{ctime},#{cname},#{sate})")
	public int insert(BsheetEcgb be);
	
	@Delete("delete from bsheet_ecgb where bsNo=#{bsNo} ")
	public int delbyNo(String bsNo);
	
}