CCN.Modules.Activity.DataAccess.ActivityDataAccess.ResetDraw C# (CSharp) Метод

        public int ResetDraw(string innerid)
        {
            const string sqlA = @"update activity_crow_info set `status`=3 where innerid=@innerid;";
            const string sqlB = @"update activity_crow_player set `iswinning`=0 where flagcode=@flagcode;";
            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    var activityModel = GetCrowdInfoById(innerid);
                    conn.Execute(sqlA, new {innerid}, tran);
                    conn.Execute(sqlB, new {flagcode = activityModel.Flagcode}, tran);
                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    LoggerFactories.CreateLogger().Write("结束抽奖记录异常：", TraceEventType.Error, ex);
                    return 0;
                }
            }
        }