Exemplos de RiskMonitor OracleDataBaseConnect.clearQuery em C# (CSharp)

Exemplo n.º 1

Arquivo: MROParameterDataLoader.cs Projeto: minikie/OTCDerivativesCalculatorModule

        private void positionLoad()
        {
            this.PositionList_ = new List <string>();

            QueryStr queryStr = new QueryStr(this.positionInfo_);

            queryStr.VariableMap_.Add("STD_DATE", this.ReferenceDate_.ToString("yyyyMMdd"));
            queryStr.VariableMap_.Add("FUND_CODE", "A27212','A27211','A27214");

            conn_.clearQuery();
            conn_.addQuery("position", queryStr.getQuery());
            conn_.excute();

            DataTable tb = conn_.ResultDataSet_.Tables["position"];

            foreach (DataRow item in tb.Rows)
            {
                this.PositionList_.Add(item["KR_CODE"].ToString());
            }
        }