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;
}
}
