Пример #1
0
 public JResult UpdateFinanceProgramme(FinanceProgrammeModel model)
 {
     return _carervice.UpdateFinanceProgramme(model);
 }
Пример #2
0
 public JResult AddFinanceProgramme(FinanceProgrammeModel model)
 {
     return _carervice.AddFinanceProgramme(model);
 }
Пример #3
0
        /// <summary>
        /// 金融方案修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateFinanceProgramme(FinanceProgrammeModel model)
        {
            var sql = new StringBuilder("update `finance_programme` set ");
            sql.Append(Helper.CreateField(model).Trim().TrimEnd(','));

            sql.Append(" where innerid = @innerid");
            int result;
            try
            {
                result = Helper.Execute(sql.ToString(), model);
            }
            catch (Exception ex)
            {
                LoggerFactories.CreateLogger().Write("金融方案修改:", TraceEventType.Error, ex);
                result = 0;
            }
            return result;
        }
Пример #4
0
        /// <summary>
        /// 金融方案新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public string AddFinanceProgramme(FinanceProgrammeModel model)
        {
            const string sql = @"INSERT INTO `finance_programme`
                                (`innerid`, `amount`, `coty`, `mileage`, `loanterm`, `interestrate`, `customerpro`, `applicant`, `applytime`, `mobile`, `modifiedid`, `modifiedtime`, `createdid`, `createdtime`, `identitypic`, `driverspic`, `bankpic`,`drivinglicensepic`,`certificatepic`)
                                VALUES
                                (@innerid, @amount, @coty, @mileage, @loanterm, @interestrate, @customerpro, @applicant, @applytime, @mobile, @modifiedid, now(), @createdid, now(), @identitypic, @driverspic, @bankpic,@drivinglicensepic,@certificatepic);";

            using (var conn = Helper.GetConnection())
            {
                string result = string.Empty;
                try
                {
                    if (conn.Execute(sql, model) == 1)
                    {
                        result = model.innerid;
                    }
                    else
                    {
                        result = "0";
                    }

                }
                catch (Exception ex)
                {
                    LoggerFactories.CreateLogger().Write("金融方案新增:", TraceEventType.Information, ex);
                    result = "0";
                }

                return result;
            }
        }
Пример #5
0
        /// <summary>
        /// 获取金融方案相关信息
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        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;
            }
        }