public JResult UpdateCarLoan(CarLoanModel model) { return _carervice.UpdateCarLoan(model); }
/// <summary> /// 车贷修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateCarLoan(CarLoanModel model) { var sql = new StringBuilder("update `car_loan` 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; }
public JResult AddCarLoan(CarLoanModel model) { return _carervice.AddCarLoan(model); }
/// <summary> /// 车贷申请 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddCarLoan(CarLoanModel model) { const string sql = @"INSERT INTO `car_loan` (`innerid`, `contacts`, `mobile`, `term`, `instruction`,`amount`,`status`, `modifiedid`, `modifiedtime`, `createdid`, `createdtime`) VALUES (uuid(), @contacts, @mobile, @term, @instruction,@amount,0, @modifiedid, now(), @createdid, now());"; using (var conn = Helper.GetConnection()) { int result; try { result = conn.Execute(sql, model); } catch (Exception ex) { LoggerFactories.CreateLogger().Write("车贷申请信息异常:", TraceEventType.Information, ex); result = 0; } return result; } }