if (FuncBroker.Func.ID <>'SALES_REVIEW_APPLY') then
begin
IF DataSetBrokerEMPLOYEE_REVIEW_REQ_DTS.DataSet.Active =false then
begin
DataSetBrokerEMPLOYEE_REVIEW_REQ_DTS.DataSet.Open;
end;
if (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('userid').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_1').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_2').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_3').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_4').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_5').IsNull) and (not DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_6').IsNull) then
begin
sQuery.Close;
sQuery.CommandText:='SELECT USERID, AMT_TRAIL1, AMT_TRAIL2, AMT_TRAIL3, AMT_TRAIL4, AMT_TRAIL5, AMT_TRAIL6, THRIRD_QTY, SECOND_QTY, DEEP_QTY FROM STAFF_ADJUST WHERE STAFF_ADJUST.AUDIT_RESULT = ''同意'' AND STAFF_ADJUST.ADJ_TYPE = ''入职'''+' and userid='+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('userid').AsString;
sQuery.Open;
i:=sQuery.FieldByName('AMT_TRAIL1').AsInteger
+sQuery.FieldByName('AMT_TRAIL2').AsInteger
+sQuery.FieldByName('AMT_TRAIL3').AsInteger
+sQuery.FieldByName('AMT_TRAIL4').AsInteger
+sQuery.FieldByName('AMT_TRAIL5').AsInteger
+sQuery.FieldByName('AMT_TRAIL6').AsInteger;
j:= DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_1').AsInteger
+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_2').AsInteger
+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_3').AsInteger
+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_4').AsInteger
+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_5').AsInteger
+DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('ACT_INDEX_6').AsInteger ;
//sQuery.FieldByName('THRIRD_QTY').AsInteger
// +sQuery.FieldByName('SECOND_QTY').AsInteger
// +sQuery.FieldByName('DEEP_QTY').AsInteger;
DataSetBrokerSALES_REVIEW_DTM.DataSet.FieldByName('SPEED').AsFloat= i / j;
// jsDialogs.ShowMsg(i.ToString,'');
// jsDialogs.ShowMsg(j.ToString,'');
end;
end; |