/// <summary> /// 添加Player /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddPlayer(CrowdPlayerModel model) { const string sql = @"INSERT INTO activity_crow_player (innerid, flagcode, gradeid, totalfee, openid, mobile, wechatnick, wechatheadportrait, orderno, ispay, isenabled, remark, createrid, createdtime) VALUES (@innerid, @flagcode, @gradeid, @totalfee, @openid, @mobile, @wechatnick, @wechatheadportrait, @orderno, @ispay, @isenabled, @remark, @createrid, @createdtime);"; using (var conn = Helper.GetConnection()) { int result; try { result = conn.Execute(sql, model); } catch (Exception ex) { LoggerFactories.CreateLogger().Write("AddPlayer异常:", TraceEventType.Error, ex); result = 0; } return result; } }
/// <summary> /// UpdatePlayer /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdatePlayer(CrowdPlayerModel model) { var sql = new StringBuilder("update activity_crow_player set "); sql.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sql.Append(" where orderno = @orderno"); int result; try { result = Helper.Execute(sql.ToString(), model); } catch (Exception ex) { result = 0; LoggerFactories.CreateLogger().Write("UpdatePlayer:", TraceEventType.Error, ex); } return result; }