/// <summary>
/// 添加档次
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddGrade(CrowdGradeModel model)
{
const string sql = @"INSERT INTO activity_crow_grade
(innerid, flagcode, totalfee, description, isenabled, photo, remark, createrid, createdtime)
VALUES
(@innerid, @flagcode, @totalfee, @description, @isenabled, @photo, @remark, @createrid, @createdtime);";
using (var conn = Helper.GetConnection())
{
int result;
try
{
result = conn.Execute(sql, model);
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("AddGrade异常：", TraceEventType.Error, ex);
result = 0;
}
return result;
}
}
/// <summary>
/// 修改档次
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateGrade(CrowdGradeModel model)
{
var sql = new StringBuilder("update activity_crow_grad 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)
{
result = 0;
LoggerFactories.CreateLogger().Write("UpdateGrade异常：", TraceEventType.Error, ex);
}
return result;
}
