企业库数据库封装类使用

 /// <summary>
        /// 批量查询手续费分成设置
        /// </summary>
        public SfaCommroInfo GetSfaCommro(string fundId, string seatNo, string apkind)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT T1.* ,T2.FUNDID,T2.SEATNO,T2.APKIND FROM SFACOMMRO T1, SFAPKIND  T2 WHERE T1.SFANO = T2.SFANO");
            strSql.Append(" AND T2.FUNDID=:FUNDID AND T2.SEATNO=:SEATNO AND T2.APKIND=:APKIND");
            DBParameter[] paras = {
                                     new DBParameter(":FUNDID",fundId),
                                     new DBParameter(":SEATNO",seatNo),
                                     new DBParameter(":APKIND",apkind)
                                    };
            SfaCommroInfo model ;
            IDataReader dataReader = DBCommon.ExecuteReader(strSql.ToString(),paras);
            SmartDataReader smartDataReader = new SmartDataReader(dataReader);
            if (dataReader.Read())
            {
                model = new SfaCommroInfo()
                {
                    FundId = smartDataReader.GetString("FUNDID"),
                    SeatNo = smartDataReader.GetString("SEATNO"),
                    Apkind = smartDataReader.GetString("APKIND"),
                    StartDt = smartDataReader.GetDateTime("STARTDT"),
                    EndDt = smartDataReader.GetDateTime("ENDDT"),
                    DownRate = smartDataReader.GetDecimal("DOWNRATE"),
                    UpRate = smartDataReader.GetDecimal("UPRATE")
                };
            }
            else
            {
                model = null;
            }
            dataReader.Close();
            return model;
        }