public JResult UpdateFinanceProgrammeDetail(FinanceProgrammeDetailModel model)
{
return _carervice.UpdateFinanceProgrammeDetail(model);
}
/// <summary>
/// 经融方案明细新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string AddFinanceProgrammeDetail(FinanceProgrammeDetailModel model)
{
const string sql = @"INSERT INTO `finance_programme_detail`
(`innerid`, `financeid`, `interestrate`, `type`, `status`, `remark`, `describepic`,`bankpic`, `modifiedid`, `modifiedtime`, `createdid`, `createdtime`)
VALUES
(uuid(), @financeid, @interestrate, @type, @status, @remark, @describepic,@bankpic, @modifiedid, now(), @createdid, now());";
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;
}
}
public JResult AddFinanceProgrammeDetail(FinanceProgrammeDetailModel model)
{
return _carervice.AddFinanceProgrammeDetail(model);
}
/// <summary>
/// 金融方案明细修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateFinanceProgrammeDetail(FinanceProgrammeDetailModel model)
{
var sql = new StringBuilder("update `finance_programme_detail` 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;
}
