ValidtimeState
若表属性 Valid Time State Field Type 属性不为空,则对应行在ValidFrom、ValidTo时间外不可被选中,需要加入
ValidtimeState(dateMin,dateMax)越过此限制。
select validtimeState(dateMin,dateMax) tb;
若表属性 Valid Time State Field Type 属性不为空,则对应行在ValidFrom、ValidTo时间外不可被选中,需要加入
ValidtimeState(dateMin,dateMax)越过此限制。
select validtimeState(dateMin,dateMax) tb;
inventJorunalTransFirst.clear();
inventJorunalTransFirst.data(inventJorunalTrans);
inventJorunalTransFirst.JournalId = headerTb.JournalId;
inventJorunalTransFirst.RecId = 0;
inventJorunalTransFirst.InventTransId = '';
//inventJorunalTransFirst.LineNum = InventJournalTrans::lastLineNum(journalId)+1;
inventJorunalTransFirst.insert();
update_recordset prodJournalBOM setting IWS_InventJournalId = headerTb.JournalId,IWS_InventTransId = inventJorunalTransFirst.InventTransId
where prodJournalBOM.IWS_InventJournalId == inventJorunalTrans.JournalId
&& prodJournalBOM.IWS_InventTransId == inventJorunalTrans.InventTransId;
inventJorunalTrans.doDelete();
InventUpd_Reservation::newMovement(inventJorunalTransFirst.inventMovement(),inventJorunalTransFirst.Qty,true).updateNow();
Args args;
FormDataSource fds ;
MultiSelectionHelper multiSelectionHelper;
//
Tb lineTb;
args= this.args();
fds = args.record().dataSource();
multiSelectionHelper = MultiSelectionHelper::construct();
multiSelectionHelper.parmDatasource(fds);
lineTb = multiSelectionHelper.getFirst();
while (lineTb)
{
//lineTmp.clear();
lineTmp.LineRecId = lineTb.RecId;
lineTmp.Insert();
lineTb = multiSelectionHelper.getNext();
}
IWS_SalesContrctReleaseTmp.linkPhysicalTableInstance(lineTmp);
MultiSelectionHelper selectionHelper = MultiSelectionHelper::construct();
Set selectedRecords = new Set(Types::Record);
MyTable myTable;
super();
selectionHelper.parmDataSource(MyTable_DS);
myTable = selectionHelper.getFirst();
if (myTable.RecId)
{
while (myTable)
{
selectedRecords.add(myTable);
info(strFmt("Selected record is %1",myTable.myField));//Display selected record
myTable = selectionHelper.getNext();
}
}
_record.skipDatabaseLog(true);
_record.skipDataMethods(true);
_record.skipEvents(true);