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.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import com.mandi.fendan.util.persist.Serviceenum;
|
|
public interface BusinessMapper {
|
|
/**
|
* 存在发卡
|
*/
|
@Select({" select top 1 * from bussinesssheet where exists( ",
|
" select top 1 * from ACT_HI_TASKINST where NAME_ = 'issue_card' and PROC_INST_ID_ = instanceId and (DELETE_REASON_ ='completed' or end_time_ is not null) " ,
|
" ) and bussinessNo in(${bussinessNos}) "
|
})
|
public Map<String,Object> existsIssueCardByNos(@Param("bussinessNos") String bussinessNos);
|
|
/**
|
* 取销售在用卡
|
* @param cardno
|
* @param numberplates
|
* @param sdepartNo
|
* @return
|
*/
|
@Select({"<script>" +
|
"select top 1 bussinessNo from bussinesssheet " +
|
"<where>",
|
"cardno=#{cardno} and sstatus='在办' and numberplates = #{numberplates} " ,
|
"<if test=\"sdepartNo!='' and sdepartNo!=null\">",
|
" and sdepartNo=#{sdepartNo}",
|
"</if>",
|
// "and btid=3", //3为成品销售
|
"</where>",
|
" order by indx",
|
"</script>" })
|
public String getBusinessNoByCardNo(@Param("cardno") String cardno,@Param("numberplates") String numberplates,@Param("sdepartNo")String sdepartNo);
|
|
@Deprecated
|
@Select("select top 1 * from bussinesssheet a left join gbusi_type b on a.btid=b.id where b.businesstypeNo=#{btNo} and a.numberplates=#{vehicleID} and a.sstatus=#{sstatus} and a.sdepartNo=#{sdepartNo} ")
|
public Map<String, Object> getbsbyBt(@Param("vehicleID") String vehicleID,@Param("btNo")String btNo,@Param("sstatus")Serviceenum sstatus,@Param("sdepartNo")String sdepartNo);
|
|
|
/**
|
* 分页获取已建的分单
|
* @param mp
|
* @return
|
*/
|
public List<Map<String, Object>> getbslist(Map<String, Object> mp);
|
public int getbspages(Map<String, Object> mp);
|
|
@Deprecated
|
@Select("select top 1 * from bussinesssheet where bussinessNo=#{bussinessNo}")
|
public Map<String, Object> getBsheet(String bussinessNo);
|
|
@Deprecated
|
@Update("update bussinesssheet set invitecode=#{invitecode} where numberplates=#{vehicleID} and sstatus=#{sstatus} and sdepartNo=#{sdepartNo} ")
|
public int updateMsg(@Param("invitecode") String invitecode,@Param("vehicleID") String vehicleID,@Param("sstatus") Serviceenum sstatus,@Param("sdepartNo") String sdepartNo);
|
@Deprecated
|
@Update("update bussinesssheet set sstatus=#{sstatus} where bussinessNo=#{bussinessNo} ")
|
public int endBsheet(@Param("bussinessNo") String bussinessNo,@Param("sstatus") Serviceenum sstatus);
|
|
@Deprecated
|
@Select("select top 1 * from bussinesssheet where invitecode=#{invitecode} and sstatus=#{sstatus} order by ctime desc")
|
public Map<String, Object> getBsheetByInviteCodeNoSdNo(@Param("invitecode") String invitecode,@Param("sstatus")Serviceenum sstatus);
|
@Deprecated
|
@Insert("insert into bussinessitems "
|
+ "(id,bussinessNo,cdepart,cdepartid,cname,createid,ctime,fachang,factory,fcnum,loadbuild,materielNo,name,norms,note,num,reserved11,"
|
+ "reserved12,reserved13,reserved14,reserved15,reserved16,product_billNo,product_serialNo,product_otherNo,weight,price,preweight,hejin,pici,"
|
+ "gross,taotong,taotongWeight,money,product_ywrq,product_flh,unitname,recompany,reID,decompany,deID,frombatch,jsnum,rcompany,rID,forshowindx,barcode) values "
|
+ "(#{id},#{bussinessNo},#{cdepart},#{cdepartid},#{cname},#{createid},#{ctime},#{fachang},#{factory},#{fcnum},#{loadbuild},"
|
+ "#{materielNo},#{name},#{norms},#{note},#{num},#{reserved11},#{reserved12},#{reserved13},#{reserved14},#{reserved15},#{reserved16}"
|
+ ",#{product_billNo},#{product_serialNo},#{product_otherNo},#{weight},#{price},#{preweight},#{hejin},#{pici},#{gross},#{taotong},#{taotongWeight},"
|
+ "#{money},#{product_ywrq},#{product_flh},#{unitname},#{recompany},#{reID},#{decompany},#{deID},#{frombatch},#{jsnum},#{rcompany},#{rID},#{forshowindx},#{barcode})")
|
public int insertBsi(Map<String, Object> wxst);
|
@Deprecated
|
@Insert("update bussinessitems set "
|
+ "bussinessNo=#{bussinessNo},cdepart=#{cdepart},cdepartid=#{cdepartid},cname=#{cname},createid=#{createid},ctime=#{ctime},"
|
+ "fachang=#{fachang},factory=#{factory},fcnum=#{fcnum},loadbuild=#{loadbuild},materielNo=#{materielNo},name=#{name},norms=#{norms},"
|
+ "note=#{note},num=#{num},reserved11=#{reserved11},"
|
+ "reserved12=#{reserved12},reserved13=#{reserved13},reserved14=#{reserved14},reserved15=#{reserved15},reserved16=#{reserved16},"
|
+ "product_billNo=#{product_billNo},product_serialNo=#{product_serialNo},"
|
+ "product_otherNo=#{product_otherNo},weight=#{weight},price=#{price},preweight=#{preweight},hejin=#{hejin},pici=#{pici},"
|
+ "gross=#{gross},taotong=#{taotong},taotongWeight=#{taotongWeight},money=#{money},product_ywrq=#{product_ywrq},product_flh=#{product_flh},"
|
+ "unitname=#{unitname},recompany=#{recompany},reID=#{reID},decompany=#{decompany},"
|
+ "deID=#{deID},frombatch=#{frombatch},jsnum=#{jsnum},rcompany=#{rcompany},rID=#{rID},forshowindx=#{forshowindx},barcode=#{barcode} where id=#{id} ")
|
public int updateBsi(Map<String, Object> wxst);
|
@Deprecated
|
@Select("select * from bussinessitems where bussinessNo=#{bussinessNo} and pici=#{pici} ")
|
public Map<String, Object> getbsi(@Param("pici")String pici,@Param("bussinessNo")String bussinessNo);
|
@Deprecated
|
@Select("select * from bussinessitems where bussinessNo=#{bussinessNo}")
|
public List<Map<String, Object>> getbsibyNo(@Param("bussinessNo")String bussinessNo);
|
@Deprecated
|
@Delete("delete from bussinessitems where bussinessNo=#{bussinessNo} and barcode=#{barcode} ")
|
public int delbysibyBarcode(@Param("barcode")String barcode,@Param("bussinessNo")String bussinessNo);
|
@Deprecated
|
@Delete("delete from bussinessitems where bussinessNo=#{bussinessNo} and pici=#{pici} ")
|
public int delbypchandNo(@Param("pici")String pici,@Param("bussinessNo")String bussinessNo);
|
@Deprecated
|
@Delete("delete from bussinessitems where bussinessNo=#{bussinessNo}")
|
public int delbydNo(@Param("bussinessNo")String bussinessNo);
|
@Deprecated
|
@Update("update bussinesssheet set driver=#{driver},phone=#{phone},numberplates=#{numberplates} where bussinessNo=#{bussinessNo}")
|
public int changeVehicle(Map<String, Object> mp);
|
|
@Select("SELECT count(1) from weight_doc where vehicleID=#{vehicleID} and businessNo=#{businessNo} and wdstate='正常' ")
|
public int getweightDoc(@Param("vehicleID")String vehicleID,@Param("businessNo")String businessNo);
|
|
@Select("SELECT count(1) from weight_doc where vehicleID=#{vehicleID} and businessNo=#{businessNo} and wdstate='正常' and gross>0 ")
|
public int getgrosstDoc(@Param("vehicleID")String vehicleID,@Param("businessNo")String businessNo);
|
|
@Update("update weight_doc set canfub=1 where vehicleID=#{vehicleID} and businessNo=#{businessNo} and wdstate='正常' and gross>0 ")
|
public int updatecanFb(@Param("vehicleID")String vehicleID,@Param("businessNo")String businessNo);
|
|
|
@Deprecated
|
@Delete("delete from vehicle_queuing where numberplates=#{vehicleID}")
|
public int delvehicleQ(@Param("vehicleID")String vehicleID);
|
@Select("select count(1) from vehicle_queuing where numberplates=#{vehicleID}")
|
public int getvehicleQ(@Param("vehicleID")String vehicleID);
|
|
@Select("select top 1 ipadd from print_ipadd where addtype='分单打印地址' and state=1 ")
|
public String getUsedbyAdd();
|
|
|
|
@Update("update xs_taskmonitor set firstzxhtime=#{firstzxhtime},lastzxhtime=#{lastzxhtime} where businessNo=#{businessNo} ")
|
public int updateTaskTime(Map<String, Object> xstm);
|
|
@Select("select * from xs_taskmonitor where businessNo=#{businessNo} ")
|
public Map<String, Object> selectTaskTime(String businessNo);
|
|
@Update("update xs_taskmonitor set zcWc=#{zcWc},zcwcTime=#{zcwcTime} where businessNo=#{businessNo} ")
|
public int updateZcWcTime(Map<String, Object> xstm);
|
|
@Update("update xs_taskmonitor set canCm=#{canCm} where businessNo=#{businessNo} ")
|
public int updateCanCm(Map<String, Object> xstm);
|
|
|
|
}
|
