test

        <pre name="code" class="csharp">        /// <summary>
        /// 根据条件获取公司级别实际完成接替率
        /// </summary>
        /// <param name="startYear">起始年份</param>
        /// <param name="endYear">终止年份</param>
        /// <returns>实际完成接替率数据</returns>
        private List<ReplacementRateModel> GetCompanyActualReplacementRateBy(int startYear, int endYear)
        {
            List<ReplacementRateModel> models = new List<ReplacementRateModel>();//ReplacementRateModel是一个视图模型
            string sqlOil = GetSqlFromXml.GetSqlBy("GetCompanyActualReplacementRateBy", fileName, "select");//通过xml找到对应的sql语句
            string sqlOilSelect = string.Format(sqlOil, startYear, endYear);//将对应的参数填充到sql语句中去
            DataTable dtCompany = helper.ExecDataTable(sqlOilSelect);//执行sql语句
            foreach (DataRow row in dtCompany.Rows)//验证数据并做运算处理
            {
                int year = CommOp.ToInt(row["ACTIVITYYEAR"]);
                if(year==startYear)
                {
                    continue;
                }
                DataRow tempRow = year == 0 ? null : PerformanceTransfer.GetLastReserves(year, dtCompany);
                double lastOilReserves = tempRow == null ? 0 : CommOp.ToDouble(tempRow["OILRESERVES"]);
                double lastGasReserves = tempRow == null ? 0 :CommOp.ToDouble(tempRow["GASRESERVES"]);
                double dangOilReserves = CommOp.ToDouble(row["OILRESERVES"]);
                double oilProduction = CommOp.ToDouble(row["OILSJNCL"]);
                double dangGasReserves = CommOp.ToDouble(row["GASRESERVES"]);
                double gasProduction = CommOp.ToDouble(row["GASJNCL"]);
                models.Add(new ReplacementRateModel
                {
                    Year = year,
                    DangOilReserves = Math.Round(dangOilReserves,2),
                    OilProduction = Math.Round(oilProduction,2),
                    LastOilReserves =Math.Round( lastOilReserves,2),
                    OilAddReserves = Math.Round(dangOilReserves + oilProduction - lastOilReserves, 2),//石油新增证实储量
                    OilReplacementRate = oilProduction == 0 ? 0.00 : Math.Round((dangOilReserves + oilProduction - lastOilReserves) / oilProduction,2),
                    DangGasReserves = Math.Round(dangGasReserves,2),
                    GasProduction = Math.Round(gasProduction,2),
                    LastGasReserves =Math.Round( lastGasReserves,2),
                    GasAddReserves = Math.Round(dangGasReserves + gasProduction - lastGasReserves, 2),//天然气新增证实储量
                    GasReplacementRate = gasProduction == 0 ? 0.00 : Math.Round((dangGasReserves + gasProduction - lastGasReserves) / gasProduction, 2)
                });
            }
            return models;//返回视图模型，以供页面显示
        }