我现在select * from v_bcode_detail where code ='BC00793934'
这段sql 数据库查出来的 tz_code 是 BCTZ2509100001 和 BCTZ2508280005 但是 我这段代码<DBHibernateDataSet name="dsBCode"
query="from com.erry.jnjhoco.payment.entity.BCodeDetail as bcodeD order by bcodeD.id"
columns="bcodeD(id,code,bcStatus,refCode,refType,tzCode,companyCode,companyFullName,budgetYear,budgetMonth,
creatorUserName,creatorRealName,proposerUserName,proposerRealName,
createDate,cusCode,cusName,dugCode,cusNKAName,directCusCode,soldToCode,soldToNameCn,
payCode,payNameCn,vendorCode,vendorNameCn,payLinkCode,payLinkName,
customerAccount,bu,brand,expLV3,expLV2,expLV1,lineFromDate,lineToDate,shipmentBeginDate,shipmentEndDate,hyperActCode,hyperActName,tpCode,tpName,cpCode,cpName,
close,block,needFD,
lockAuto,lockKC,lockAlloc,lockFD,lockDZ,lockSA,lockDebatableTP,lockOffInv,lockNeg,
remark,currencyCode,bcPlan,bcAct,bcRev,bcInPP,bcPP,bcInPC,bcInNPC,bcInRev,matchAmount,matchStatus,
approveDate,amountApproveDate,prAppType,userFDCode,fdFromDate,fdToDate,fdCostType,fdBrands),
bcodeD.createDate as createDateFrom,
bcodeD.createDate as createDateTo">
<DBColumn name="bcodeD.expLV3" width="50"/>
<DBColumn name="bcodeD.expLV2" width="25"/>
<DBColumn name="bcodeD.expLV1" width="20"/>
<DBColumn name="bcodeD.createDate" displayMask="yyyy-MM-dd"/>
<DBColumn name="bcodeD.lineFromDate" displayMask="yyyy-MM-dd"/>
<DBColumn name="bcodeD.lineToDate" displayMask="yyyy-MM-dd"/>
<DBColumn name="bcodeD.shipmentBeginDate" width="30" caption="${model.tpline.shipment_start_date}(TP)" displayMask="yyyy-MM-dd"/>
<DBColumn name="bcodeD.shipmentEndDate" width="30" caption="${model.tpline.shipment_end_date}(TP)" displayMask="yyyy-MM-dd"/>
<DBPickList columns="bcodeD.bcStatus" pickListColumns="co.cKey"
pickListDisplayColumns="co.cnValue" lookupDisplayColumn="co.cnValue"
pickListDataSet="dsBcStatus" insertNull="false" />
<DBPickList columns="bcodeD.matchStatus" pickListColumns="co.cKey"
pickListDisplayColumns="co.cnValue" lookupDisplayColumn="co.cnValue"
pickListDataSet="dsMatchStatus" insertNull="false" />
<DBPickList
columns="bcodeD.expLV1"
pickListColumns="exp.code" pickListDisplayColumns="exp.code"
lookupDisplayColumn="exp.code" pickListDataSet="dsExp1" insertNull="true"/>
<DBPickList columns="bcodeD.companyCode"
pickListColumns="company.code" pickListDisplayColumns="company.code"
lookupDisplayColumn="company.code" pickListDataSet="dsCompany"
insertNull="true"/>
<DBPickList columns="bcodeD.currencyCode"
pickListColumns="currency.code" pickListDisplayColumns="currency.code,currency.name"
lookupDisplayColumn="currency.code" pickListDataSet="dsCurrency"
insertNull="true"/>
<DBPickList columns="bcodeD.prAppType" pickListColumns="co.cKey"
pickListDisplayColumns="co.cnValue" lookupDisplayColumn="co.cnValue"
pickListDataSet="dsPrAppType" insertNull="true" />
<!--<DBColumn name="bcodeD.prAppType" width="30"/>-->
<DBColumn name="bcodeD.lockAlloc" visible="false"/>
<DBColumn name="createDateFrom" dataType="date" visible="false" displayMask="yyyy-MM-dd"/>
<DBColumn name="createDateTo" dataType="date" visible="false" displayMask="yyyy-MM-dd"/>
</DBHibernateDataSet>跑出来却是BCTZ2509100001 和 BCTZ2509100001,这是为什么
最新发布