代码提交

liusheng

2023-09-28 8aaffe80f14469a81d0c1c54a3a60908de66ce37

代码提交

 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetail.java

@@ -347,5 +347,12 @@
    @ApiModelProperty("绩效日期")
    private String jxrq;


    /**
     * 项目名称说明
     */
    @ApiModelProperty("项目名称说明")
    private String itemdescribe;

}


 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailShared.java

@@ -2,6 +2,7 @@

import java.math.BigDecimal;
import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
@@ -13,273 +14,393 @@

/**
 * 费用申请明细对象 service_funddetail_shared
 * 
 *
 * @author ruoyi
 * @date 2023-04-20
 */
@Data
@ApiModel("费用申请明细")
public class ServiceFunddetailShared extends BaseEntity
{
public class ServiceFunddetailShared extends BaseEntity {
    private static final long serialVersionUID = 1L;

    /** 主键ID */
    /**
     * 主键ID
     */
    @ApiModelProperty("主键ID")
    //数据库自增改成@TableId(type = IdType.AUTO)
    @TableId(type = IdType.AUTO)
    private Long id;

    /** 资金申请主表ID */
    /**
     * 资金申请主表ID
     */
    @ApiModelProperty("资金申请主表ID")
    @Excel(name = "资金申请主表ID")
    private Long fundid;

    /** 对应的service_funddetail表的ID */
    /**
     * 对应的service_funddetail表的ID
     */
    @ApiModelProperty("对应的service_funddetail表的ID")
    @Excel(name = "对应的service_funddetail表的ID")
    private Long fdid;

    /** 顺序号 */
    /**
     * 顺序号
     */
    @ApiModelProperty("顺序号")
    @Excel(name = "顺序号")
    private Integer orderno;

    /** 项目ID */
    /**
     * 项目ID
     */
    @ApiModelProperty("项目ID")
    @Excel(name = "项目ID")
    private Long itemid;

    /** 费用项目标号 */
    /**
     * 费用项目标号
     */
    @ApiModelProperty("费用项目标号")
    @Excel(name = "费用项目标号")
    private String itemcode;

    /** 项目名称 */
    /**
     * 项目名称
     */
    @ApiModelProperty("项目名称")
    @Excel(name = "项目名称")
    private String itemname;

    /** 项目类别 */
    /**
     * 项目类别
     */
    @ApiModelProperty("项目类别")
    @Excel(name = "项目类别")
    private String itemtype;

    /** 资金类别 */
    /**
     * 资金类别
     */
    @ApiModelProperty("资金类别")
    @Excel(name = "资金类别")
    private String applytype;

    /** 资金类别名称 */
    /**
     * 资金类别名称
     */
    @ApiModelProperty("资金类别名称")
    @Excel(name = "资金类别名称")
    private String applytypename;

    /** 收益人姓名 家属或专家 */
    /**
     * 收益人姓名 家属或专家
     */
    @ApiModelProperty("收益人姓名 家属或专家")
    @Excel(name = "收益人姓名 家属或专家")
    private String beneficiaryname;

    /** 收益人编号 */
    /**
     * 收益人编号
     */
    @ApiModelProperty("收益人编号")
    @Excel(name = "收益人编号")
    private String beneficiaryno;

    /** 附件表 */
    /**
     * 附件表
     */
    @ApiModelProperty("附件表")
    @Excel(name = "附件表")
    private String annexfiles;

    /** 工作单位 */
    /**
     * 工作单位
     */
    @ApiModelProperty("工作单位")
    @Excel(name = "工作单位")
    private String unitname;

    /** 工作单位编号 */
    /**
     * 工作单位编号
     */
    @ApiModelProperty("工作单位编号")
    @Excel(name = "工作单位编号")
    private String unitno;

    /** 工作单位用户编号 */
    /**
     * 工作单位用户编号
     */
    @ApiModelProperty("工作单位用户编号")
    @Excel(name = "工作单位用户编号")
    private String unituserno;

    /** 职称,见字典sys_professionaltitle */
    /**
     * 职称,见字典sys_professionaltitle
     */
    @ApiModelProperty("职称,见字典sys_professionaltitle")
    @Excel(name = "职称,见字典sys_professionaltitle")
    private String title;

    /** 证件类型 根据字典sys_IDType */
    /**
     * 证件类型 根据字典sys_IDType
     */
    @ApiModelProperty("证件类型 根据字典sys_IDType")
    @Excel(name = "证件类型 根据字典sys_IDType")
    private Long idcardtype;

    /** 证件号码 */
    /**
     * 证件号码
     */
    @ApiModelProperty("证件号码")
    @Excel(name = "证件号码")
    private String idcardno;

    /** 性别 根据字典sys_user_sex */
    /**
     * 性别 根据字典sys_user_sex
     */
    @ApiModelProperty("性别 根据字典sys_user_sex")
    @Excel(name = "性别 根据字典sys_user_sex")
    private String sex;

    /** 与捐赠者关系 根据字典sys_FamilyRelation */
    /**
     * 与捐赠者关系 根据字典sys_FamilyRelation
     */
    @ApiModelProperty("与捐赠者关系 根据字典sys_FamilyRelation")
    @Excel(name = "与捐赠者关系 根据字典sys_FamilyRelation")
    private String familyrelations;

    /** 联系电话 */
    /**
     * 联系电话
     */
    @ApiModelProperty("联系电话")
    @Excel(name = "联系电话")
    private String phone;

    /** 开户银行 */
    /**
     * 开户银行
     */
    @ApiModelProperty("开户银行")
    @Excel(name = "开户银行")
    private String depositbank;

    /** 卡号 */
    /**
     * 卡号
     */
    @ApiModelProperty("卡号")
    @Excel(name = "卡号")
    private String bankcardno;

    /** 支行名称 */
    /**
     * 支行名称
     */
    @ApiModelProperty("支行名称")
    @Excel(name = "支行名称")
    private String branchbankname;

    /** 银行卡照片路径 多个用;分开 */
    /**
     * 银行卡照片路径 多个用;分开
     */
    @ApiModelProperty("银行卡照片路径 多个用;分开")
    @Excel(name = "银行卡照片路径 多个用;分开")
    private String annexbankcard;

    /** 登记表照片路径 多个用;分开 */
    /**
     * 登记表照片路径 多个用;分开
     */
    @ApiModelProperty("登记表照片路径 多个用;分开")
    @Excel(name = "登记表照片路径 多个用;分开")
    private String annexregistform;

    /** 数量 */
    /**
     * 数量
     */
    @ApiModelProperty("数量")
    @Excel(name = "数量")
    private Double quantity;

    /** 价格 */
    /**
     * 价格
     */
    @ApiModelProperty("价格")
    @Excel(name = "价格")
    private Double price;

    /** 申请金额 */
    /**
     * 申请金额
     */
    @ApiModelProperty("申请金额")
    @Excel(name = "申请金额")
    private Double amount;

    /** 扣税金额 */
    /**
     * 扣税金额
     */
    @ApiModelProperty("扣税金额")
    @Excel(name = "扣税金额")
    private Double taxamount;

    /** 税后金额 */
    /**
     * 税后金额
     */
    @ApiModelProperty("税后金额")
    @Excel(name = "税后金额")
    private Double taxedamount;

    /** 预支金额 */
    /**
     * 预支金额
     */
    @ApiModelProperty("预支金额")
    @Excel(name = "预支金额")
    private Double prepaidamount;

    /** 付款金额 */
    /**
     * 付款金额
     */
    @ApiModelProperty("付款金额")
    @Excel(name = "付款金额")
    private Double paidamount;

    /** 付款时间 */
    /**
     * 付款时间
     */
    @ApiModelProperty("付款时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "付款时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date paidtime;

    /** 付款方式 */
    /**
     * 付款方式
     */
    @ApiModelProperty("付款方式")
    @Excel(name = "付款方式")
    private String payterm;

    /** 发票张数 */
    /**
     * 发票张数
     */
    @ApiModelProperty("发票张数")
    @Excel(name = "发票张数")
    private Long invoicecount;

    /** 附件张数 */
    /**
     * 附件张数
     */
    @ApiModelProperty("附件张数")
    @Excel(name = "附件张数")
    private Long attachcount;

    /** 捐献ID */
    /**
     * 捐献ID
     */
    @ApiModelProperty("捐献ID")
    @Excel(name = "捐献ID")
    private Long infoid;

    /** 捐献编号 */
    /**
     * 捐献编号
     */
    @ApiModelProperty("捐献编号")
    @Excel(name = "捐献编号")
    private String donorno;

    /** 捐献者姓名 */
    /**
     * 捐献者姓名
     */
    @ApiModelProperty("捐献者姓名")
    @Excel(name = "捐献者姓名")
    private String donorname;

    /** 记录状态 */
    /**
     * 记录状态
     */
    @ApiModelProperty("记录状态")
    @Excel(name = "记录状态")
    private String recordstatus;

    /** 上传标志 */
    /**
     * 上传标志
     */
    @ApiModelProperty("上传标志")
    @Excel(name = "上传标志")
    private String uploadflag;

    /** 上传时间 */
    /**
     * 上传时间
     */
    @ApiModelProperty("上传时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "上传时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    private Date uploadtime;

    /** $column.columnComment */
    /**
     * $column.columnComment
     */
    @ApiModelProperty("$column.columnComment")
    @Excel(name = "上传时间")
    private String servicesscope;

    /** $column.columnComment */
    /**
     * $column.columnComment
     */
    @ApiModelProperty("$column.columnComment")
    @Excel(name = "上传时间")
    private String servicesscopename;

    /** $column.columnComment */
    /**
     * $column.columnComment
     */
    @ApiModelProperty("$column.columnComment")
    @Excel(name = "上传时间")
    private String servicetype;

    /** $column.columnComment */
    /**
     * $column.columnComment
     */
    @ApiModelProperty("$column.columnComment")
    @Excel(name = "上传时间")
    private String servicetypename;

    /** $column.columnComment */
    /**
     * $column.columnComment
     */
    @ApiModelProperty("$column.columnComment")
    @Excel(name = "上传时间")
    private Double reimbursementamount;

    /** 金额 */
    /**
     * 金额
     */
    @ApiModelProperty("金额")
    @Excel(name = "金额")
    private String jine;

    /** 理由 */
    /**
     * 理由
     */
    @ApiModelProperty("理由")
    @Excel(name = "理由")
    private String liyou;

    /**
     * 计算税费时间
     */
    @ApiModelProperty("计算税费时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date taxTime;

    /**
     * 绩效日期
     */
    @ApiModelProperty("绩效日期")
    private String jxrq;

    /**
     * 项目名称说明
     */
    @ApiModelProperty("项目名称说明")
    private String itemdescribe;

}


 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailVO.java

@@ -338,5 +338,24 @@
    @ApiModelProperty("附件文件地址")
    private String annexfiles;

    /**
     * 计算税费时间
     */
    @ApiModelProperty("计算税费时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date taxTime;

    /**
     * 绩效日期
     */
    @ApiModelProperty("绩效日期")
    private String jxrq;

    /**
     * 项目名称说明
     */
    @ApiModelProperty("项目名称说明")
    private String itemdescribe;

}


 ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailMapper.xml

@@ -59,6 +59,7 @@
        <result property="annexfiles" column="AnnexFiles"/>
        <result property="taxTime" column="tax_time"/>
        <result property="jxrq" column="jxrq"/>
        <result property="itemdescribe" column="ItemDescribe"/>
    </resultMap>

    <sql id="selectServiceFunddetailVo">
@@ -115,7 +116,8 @@
               subjecttypename,
               AnnexFiles,
               tax_time,
               jxrq
               jxrq,
               ItemDescribe
        from service_funddetail
    </sql>

@@ -263,7 +265,7 @@
        where fundID &lt; #{fundID}
          and tax_time &lt; #{taxTime}
          and tax_time >= #{firstDay}
          and IDCardNo=#{IDCard}
          and IDCardNo = #{IDCard}
          and ApplyType in (1, 2)
    </select>


 ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailSharedMapper.xml

@@ -1,123 +1,191 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.project.mapper.ServiceFunddetailSharedMapper">
    

    <resultMap type="com.ruoyi.project.domain.ServiceFunddetailShared" id="ServiceFunddetailSharedResult">
        <result property="id"    column="ID"    />
        <result property="fundid"    column="fundID"    />
        <result property="orderno"    column="OrderNo"    />
        <result property="itemid"    column="ItemID"    />
        <result property="itemcode"    column="ItemCode"    />
        <result property="itemname"    column="ItemName"    />
        <result property="itemtype"    column="ItemType"    />
        <result property="applytype"    column="ApplyType"    />
        <result property="applytypename"    column="ApplyTypeName"    />
        <result property="beneficiaryname"    column="BeneficiaryName"    />
        <result property="beneficiaryno"    column="BeneficiaryNo"    />
        <result property="unitname"    column="UnitName"    />
        <result property="unitno"    column="UnitNo"    />
        <result property="unituserno"    column="UnitUserNo"    />
        <result property="title"    column="Title"    />
        <result property="idcardtype"    column="IDCardType"    />
        <result property="idcardno"    column="IDCardNo"    />
        <result property="sex"    column="Sex"    />
        <result property="familyrelations"    column="FamilyRelations"    />
        <result property="phone"    column="Phone"    />
        <result property="depositbank"    column="DepositBank"    />
        <result property="bankcardno"    column="BankCardNo"    />
        <result property="branchbankname"    column="BranchBankName"    />
        <result property="annexbankcard"    column="AnnexBankCard"    />
        <result property="annexregistform"    column="AnnexRegistForm"    />
        <result property="quantity"    column="Quantity"    />
        <result property="price"    column="Price"    />
        <result property="amount"    column="Amount"    />
        <result property="taxamount"    column="TaxAmount"    />
        <result property="taxedamount"    column="TaxedAmount"    />
        <result property="prepaidamount"    column="PrepaidAmount"    />
        <result property="paidamount"    column="paidAmount"    />
        <result property="paidtime"    column="paidTime"    />
        <result property="payterm"    column="payTerm"    />
        <result property="invoicecount"    column="InvoiceCount"    />
        <result property="attachcount"    column="AttachCount"    />
        <result property="remark"    column="Remark"    />
        <result property="infoid"    column="InfoId"    />
        <result property="donorno"    column="DonorNo"    />
        <result property="donorname"    column="DonorName"    />
        <result property="recordstatus"    column="RecordStatus"    />
        <result property="del_flag"    column="del_flag"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
        <result property="updateTime"    column="update_time"    />
        <result property="uploadflag"    column="uploadflag"    />
        <result property="uploadtime"    column="uploadtime"    />
        <result property="servicesscope"    column="SERVICESSCOPE"    />
        <result property="servicesscopename"    column="SERVICESSCOPENAME"    />
        <result property="servicetype"    column="SERVICETYPE"    />
        <result property="servicetypename"    column="SERVICETYPENAME"    />
        <result property="reimbursementamount"    column="REIMBURSEMENTAMOUNT"    />
        <result property="jine"    column="jine"    />
        <result property="liyou"    column="liyou"    />
        <result property="id" column="ID"/>
        <result property="fundid" column="fundID"/>
        <result property="orderno" column="OrderNo"/>
        <result property="itemid" column="ItemID"/>
        <result property="itemcode" column="ItemCode"/>
        <result property="itemname" column="ItemName"/>
        <result property="itemtype" column="ItemType"/>
        <result property="applytype" column="ApplyType"/>
        <result property="applytypename" column="ApplyTypeName"/>
        <result property="beneficiaryname" column="BeneficiaryName"/>
        <result property="beneficiaryno" column="BeneficiaryNo"/>
        <result property="unitname" column="UnitName"/>
        <result property="unitno" column="UnitNo"/>
        <result property="unituserno" column="UnitUserNo"/>
        <result property="title" column="Title"/>
        <result property="idcardtype" column="IDCardType"/>
        <result property="idcardno" column="IDCardNo"/>
        <result property="sex" column="Sex"/>
        <result property="familyrelations" column="FamilyRelations"/>
        <result property="phone" column="Phone"/>
        <result property="depositbank" column="DepositBank"/>
        <result property="bankcardno" column="BankCardNo"/>
        <result property="branchbankname" column="BranchBankName"/>
        <result property="annexbankcard" column="AnnexBankCard"/>
        <result property="annexregistform" column="AnnexRegistForm"/>
        <result property="quantity" column="Quantity"/>
        <result property="price" column="Price"/>
        <result property="amount" column="Amount"/>
        <result property="taxamount" column="TaxAmount"/>
        <result property="taxedamount" column="TaxedAmount"/>
        <result property="prepaidamount" column="PrepaidAmount"/>
        <result property="paidamount" column="paidAmount"/>
        <result property="paidtime" column="paidTime"/>
        <result property="payterm" column="payTerm"/>
        <result property="invoicecount" column="InvoiceCount"/>
        <result property="attachcount" column="AttachCount"/>
        <result property="remark" column="Remark"/>
        <result property="infoid" column="InfoId"/>
        <result property="donorno" column="DonorNo"/>
        <result property="donorname" column="DonorName"/>
        <result property="recordstatus" column="RecordStatus"/>
        <result property="del_flag" column="del_flag"/>
        <result property="createBy" column="create_by"/>
        <result property="createTime" column="create_time"/>
        <result property="updateBy" column="update_by"/>
        <result property="updateTime" column="update_time"/>
        <result property="uploadflag" column="uploadflag"/>
        <result property="uploadtime" column="uploadtime"/>
        <result property="servicesscope" column="SERVICESSCOPE"/>
        <result property="servicesscopename" column="SERVICESSCOPENAME"/>
        <result property="servicetype" column="SERVICETYPE"/>
        <result property="servicetypename" column="SERVICETYPENAME"/>
        <result property="reimbursementamount" column="REIMBURSEMENTAMOUNT"/>
        <result property="jine" column="jine"/>
        <result property="liyou" column="liyou"/>
        <result property="itemdescribe" column="ItemDescribe"/>
    </resultMap>

    <sql id="selectServiceFunddetailSharedVo">
        select ID, fundID, OrderNo, ItemID, ItemCode, ItemName, ItemType, ApplyType, ApplyTypeName, BeneficiaryName, BeneficiaryNo, UnitName, UnitNo, UnitUserNo, Title, IDCardType, IDCardNo, Sex, FamilyRelations, Phone, DepositBank, BankCardNo, BranchBankName, AnnexBankCard, AnnexRegistForm, Quantity, Price, Amount, TaxAmount, TaxedAmount, PrepaidAmount, paidAmount, paidTime, payTerm, InvoiceCount, AttachCount, Remark, InfoId, DonorNo, DonorName, RecordStatus, del_flag, create_by, create_time, update_by, update_time, uploadflag, uploadtime, SERVICESSCOPE, SERVICESSCOPENAME, SERVICETYPE, SERVICETYPENAME, REIMBURSEMENTAMOUNT, jine, liyou from service_funddetail_shared
        select ID,
               fundID,
               OrderNo,
               ItemID,
               ItemCode,
               ItemName,
               ItemType,
               ApplyType,
               ApplyTypeName,
               BeneficiaryName,
               BeneficiaryNo,
               UnitName,
               UnitNo,
               UnitUserNo,
               Title,
               IDCardType,
               IDCardNo,
               Sex,
               FamilyRelations,
               Phone,
               DepositBank,
               BankCardNo,
               BranchBankName,
               AnnexBankCard,
               AnnexRegistForm,
               Quantity,
               Price,
               Amount,
               TaxAmount,
               TaxedAmount,
               PrepaidAmount,
               paidAmount,
               paidTime,
               payTerm,
               InvoiceCount,
               AttachCount,
               Remark,
               InfoId,
               DonorNo,
               DonorName,
               RecordStatus,
               del_flag,
               create_by,
               create_time,
               update_by,
               update_time,
               uploadflag,
               uploadtime,
               SERVICESSCOPE,
               SERVICESSCOPENAME,
               SERVICETYPE,
               SERVICETYPENAME,
               REIMBURSEMENTAMOUNT,
               jine,
               liyou,
               ItemDescribe
        from service_funddetail_shared
    </sql>

    <select id="selectServiceFunddetailSharedList" parameterType="com.ruoyi.project.domain.ServiceFunddetailShared" resultMap="ServiceFunddetailSharedResult">
    <select id="selectServiceFunddetailSharedList" parameterType="com.ruoyi.project.domain.ServiceFunddetailShared"
            resultMap="ServiceFunddetailSharedResult">
        <include refid="selectServiceFunddetailSharedVo"/>
        <where>
            <if test="fundid != null "> and fundID = #{fundid}</if>
            <if test="orderno != null "> and OrderNo = #{orderno}</if>
            <if test="itemid != null "> and ItemID = #{itemid}</if>
            <if test="itemcode != null  and itemcode != ''"> and ItemCode = #{itemcode}</if>
            <if test="itemname != null  and itemname != ''"> and ItemName like concat('%', #{itemname}, '%')</if>
            <if test="itemtype != null  and itemtype != ''"> and ItemType = #{itemtype}</if>
            <if test="applytype != null  and applytype != ''"> and ApplyType = #{applytype}</if>
            <if test="applytypename != null  and applytypename != ''"> and ApplyTypeName like concat('%', #{applytypename}, '%')</if>
            <if test="beneficiaryname != null  and beneficiaryname != ''"> and BeneficiaryName like concat('%', #{beneficiaryname}, '%')</if>
            <if test="beneficiaryno != null  and beneficiaryno != ''"> and BeneficiaryNo = #{beneficiaryno}</if>
            <if test="unitname != null  and unitname != ''"> and UnitName like concat('%', #{unitname}, '%')</if>
            <if test="unitno != null  and unitno != ''"> and UnitNo = #{unitno}</if>
            <if test="unituserno != null  and unituserno != ''"> and UnitUserNo = #{unituserno}</if>
            <if test="title != null  and title != ''"> and Title = #{title}</if>
            <if test="idcardtype != null "> and IDCardType = #{idcardtype}</if>
            <if test="idcardno != null  and idcardno != ''"> and IDCardNo = #{idcardno}</if>
            <if test="sex != null  and sex != ''"> and Sex = #{sex}</if>
            <if test="familyrelations != null  and familyrelations != ''"> and FamilyRelations = #{familyrelations}</if>
            <if test="phone != null  and phone != ''"> and Phone = #{phone}</if>
            <if test="depositbank != null  and depositbank != ''"> and DepositBank = #{depositbank}</if>
            <if test="bankcardno != null  and bankcardno != ''"> and BankCardNo = #{bankcardno}</if>
            <if test="branchbankname != null  and branchbankname != ''"> and BranchBankName like concat('%', #{branchbankname}, '%')</if>
            <if test="annexbankcard != null  and annexbankcard != ''"> and AnnexBankCard = #{annexbankcard}</if>
            <if test="annexregistform != null  and annexregistform != ''"> and AnnexRegistForm = #{annexregistform}</if>
            <if test="quantity != null "> and Quantity = #{quantity}</if>
            <if test="price != null "> and Price = #{price}</if>
            <if test="amount != null "> and Amount = #{amount}</if>
            <if test="taxamount != null "> and TaxAmount = #{taxamount}</if>
            <if test="taxedamount != null "> and TaxedAmount = #{taxedamount}</if>
            <if test="prepaidamount != null "> and PrepaidAmount = #{prepaidamount}</if>
            <if test="paidamount != null "> and paidAmount = #{paidamount}</if>
            <if test="paidtime != null "> and paidTime = #{paidtime}</if>
            <if test="payterm != null  and payterm != ''"> and payTerm = #{payterm}</if>
            <if test="invoicecount != null "> and InvoiceCount = #{invoicecount}</if>
            <if test="attachcount != null "> and AttachCount = #{attachcount}</if>
            <if test="remark != null  and remark != ''"> and Remark = #{remark}</if>
            <if test="infoid != null "> and InfoId = #{infoid}</if>
            <if test="donorno != null  and donorno != ''"> and DonorNo = #{donorno}</if>
            <if test="donorname != null  and donorname != ''"> and DonorName like concat('%', #{donorname}, '%')</if>
            <if test="recordstatus != null  and recordstatus != ''"> and RecordStatus = #{recordstatus}</if>
            <if test="uploadflag != null  and uploadflag != ''"> and uploadflag = #{uploadflag}</if>
            <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if>
            <if test="servicesscope != null  and servicesscope != ''"> and SERVICESSCOPE = #{servicesscope}</if>
            <if test="servicesscopename != null  and servicesscopename != ''"> and SERVICESSCOPENAME like concat('%', #{servicesscopename}, '%')</if>
            <if test="servicetype != null  and servicetype != ''"> and SERVICETYPE = #{servicetype}</if>
            <if test="servicetypename != null  and servicetypename != ''"> and SERVICETYPENAME like concat('%', #{servicetypename}, '%')</if>
            <if test="reimbursementamount != null "> and REIMBURSEMENTAMOUNT = #{reimbursementamount}</if>
            <if test="jine != null  and jine != ''"> and jine = #{jine}</if>
            <if test="liyou != null  and liyou != ''"> and liyou = #{liyou}</if>
            <if test="fundid != null ">and fundID = #{fundid}</if>
            <if test="orderno != null ">and OrderNo = #{orderno}</if>
            <if test="itemid != null ">and ItemID = #{itemid}</if>
            <if test="itemcode != null  and itemcode != ''">and ItemCode = #{itemcode}</if>
            <if test="itemname != null  and itemname != ''">and ItemName like concat('%', #{itemname}, '%')</if>
            <if test="itemtype != null  and itemtype != ''">and ItemType = #{itemtype}</if>
            <if test="applytype != null  and applytype != ''">and ApplyType = #{applytype}</if>
            <if test="applytypename != null  and applytypename != ''">and ApplyTypeName like concat('%',
                #{applytypename}, '%')
            </if>
            <if test="beneficiaryname != null  and beneficiaryname != ''">and BeneficiaryName like concat('%',
                #{beneficiaryname}, '%')
            </if>
            <if test="beneficiaryno != null  and beneficiaryno != ''">and BeneficiaryNo = #{beneficiaryno}</if>
            <if test="unitname != null  and unitname != ''">and UnitName like concat('%', #{unitname}, '%')</if>
            <if test="unitno != null  and unitno != ''">and UnitNo = #{unitno}</if>
            <if test="unituserno != null  and unituserno != ''">and UnitUserNo = #{unituserno}</if>
            <if test="title != null  and title != ''">and Title = #{title}</if>
            <if test="idcardtype != null ">and IDCardType = #{idcardtype}</if>
            <if test="idcardno != null  and idcardno != ''">and IDCardNo = #{idcardno}</if>
            <if test="sex != null  and sex != ''">and Sex = #{sex}</if>
            <if test="familyrelations != null  and familyrelations != ''">and FamilyRelations = #{familyrelations}</if>
            <if test="phone != null  and phone != ''">and Phone = #{phone}</if>
            <if test="depositbank != null  and depositbank != ''">and DepositBank = #{depositbank}</if>
            <if test="bankcardno != null  and bankcardno != ''">and BankCardNo = #{bankcardno}</if>
            <if test="branchbankname != null  and branchbankname != ''">and BranchBankName like concat('%',
                #{branchbankname}, '%')
            </if>
            <if test="annexbankcard != null  and annexbankcard != ''">and AnnexBankCard = #{annexbankcard}</if>
            <if test="annexregistform != null  and annexregistform != ''">and AnnexRegistForm = #{annexregistform}</if>
            <if test="quantity != null ">and Quantity = #{quantity}</if>
            <if test="price != null ">and Price = #{price}</if>
            <if test="amount != null ">and Amount = #{amount}</if>
            <if test="taxamount != null ">and TaxAmount = #{taxamount}</if>
            <if test="taxedamount != null ">and TaxedAmount = #{taxedamount}</if>
            <if test="prepaidamount != null ">and PrepaidAmount = #{prepaidamount}</if>
            <if test="paidamount != null ">and paidAmount = #{paidamount}</if>
            <if test="paidtime != null ">and paidTime = #{paidtime}</if>
            <if test="payterm != null  and payterm != ''">and payTerm = #{payterm}</if>
            <if test="invoicecount != null ">and InvoiceCount = #{invoicecount}</if>
            <if test="attachcount != null ">and AttachCount = #{attachcount}</if>
            <if test="remark != null  and remark != ''">and Remark = #{remark}</if>
            <if test="infoid != null ">and InfoId = #{infoid}</if>
            <if test="donorno != null  and donorno != ''">and DonorNo = #{donorno}</if>
            <if test="donorname != null  and donorname != ''">and DonorName like concat('%', #{donorname}, '%')</if>
            <if test="recordstatus != null  and recordstatus != ''">and RecordStatus = #{recordstatus}</if>
            <if test="uploadflag != null  and uploadflag != ''">and uploadflag = #{uploadflag}</if>
            <if test="uploadtime != null ">and uploadtime = #{uploadtime}</if>
            <if test="servicesscope != null  and servicesscope != ''">and SERVICESSCOPE = #{servicesscope}</if>
            <if test="servicesscopename != null  and servicesscopename != ''">and SERVICESSCOPENAME like concat('%',
                #{servicesscopename}, '%')
            </if>
            <if test="servicetype != null  and servicetype != ''">and SERVICETYPE = #{servicetype}</if>
            <if test="servicetypename != null  and servicetypename != ''">and SERVICETYPENAME like concat('%',
                #{servicetypename}, '%')
            </if>
            <if test="reimbursementamount != null ">and REIMBURSEMENTAMOUNT = #{reimbursementamount}</if>
            <if test="jine != null  and jine != ''">and jine = #{jine}</if>
            <if test="liyou != null  and liyou != ''">and liyou = #{liyou}</if>
        </where>
    </select>