2025-02-10

Java代碼 
public List<BillMain> retrieve(BillMain billMain) { 
        Criteria criteria = billMainDAO.getSession().createCriteria( 
                BillMain.class); 
        if (!StringUtil.isEmpty(billMain.getCustomerAdd())) { 
            criteria.add(Restrictions.like("customerAdd", "%" 
                    + billMain.getCustomerAdd().trim() + "%")); 
        } 
        // 根據公司名稱查詢 
        /*
         * if (!StringUtil.isEmpty(billMain.getCustomerName())) {
         * criteria.add(Restrictions.like("customerName", "%" +
         * billMain.getCustomerName().trim() + "%")); }
         */ 
        if (!StringUtil.isEmpty(billMain.getEntryId())) { 
            criteria.add(Restrictions.like("entryId", "%" 
                    + billMain.getEntryId().trim() + "%")); 
        } 
        if (!StringUtil.isEmpty(billMain.getOperator())) { 
            criteria.add(Restrictions.like("operator", "%" 
                    + billMain.getOperator().trim() + "%")); 
        } 
        if (null != billMain.getOperaTime()) { 
            criteria 
                    .add(Restrictions 
                            .sqlRestriction(" convert(varchar(10),this_.operaTime,120) like '%" 
                                    + billMain.getOperaTime().toString() 
                                            .substring(0, 10) + "%'")); 
        } 
        criteria.add(Property.forName("state").eq("N")).addOrder( 
                Order.desc("id")); 
 
        return criteria.list(); 
    } 

作者“qiaolevip”
 

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *