CCN.Modules.Car.DataAccess.CarDataAccess.GetFinanceProgramme C# (CSharp) Метод

        public IEnumerable<FinanceProgrammeViewModel> GetFinanceProgramme(FinanceProgrammeModel query)
        {
            StringBuilder sql = new StringBuilder(@"select `innerid`, `amount`, `coty`, `mileage`, `loanterm`, `interestrate`,
                                `customerpro`, `applicant`, `applytime`, `mobile`, `modifiedid`, `modifiedtime`, `createdid`, `createdtime`,
                                `identitypic`, `driverspic`, `bankpic`,`drivinglicensepic`,`certificatepic`
                                 from finance_programme
                                where 1=1 ");
            if (!string.IsNullOrWhiteSpace(query.innerid))
            {
                sql.Append($" and innerid='{query.innerid}' ");
            }
            sql.Append($" order by applytime asc; ");

            try
            {
                var list = Helper.Query<FinanceProgrammeViewModel>(sql.ToString());
                return list;
            }
            catch (Exception ex)
            {
                return null;
            }
        }