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