예제 #1
0
        public override long Insert(object values)
        {
            cnn.Open();
            ThingsToDo Input = (ThingsToDo)values;

            cmd.Parameters["$Name"].Value       = Input.name;
            cmd.Parameters["$Status"].Value     = Input.status;
            cmd.Parameters["$lastupdate"].Value = Input.lastUpDate.ToString("yyyy'-'MM'-'dd HH:mm:ss");
            cmd.ExecuteNonQuery();
            long x = GetLastInsertID();

            cnn.Close();
            return(x);
            //Program.manager.InsertTo();
        }
예제 #2
0
        public override long Insert(object values)
        {
            cnn.Open();
            ThingsToDo input = (ThingsToDo)values;

            cmd.CommandText = "insert into TTD_Stats values($TTDID,$StatName,$Score)";
            cmd.Parameters["$TTDID"].Value = input.id;
            foreach (var x in input.score)
            {
                if (x.Value != 0)
                {
                    cmd.Parameters["$StatName"].Value = x.Key;
                    cmd.Parameters["$Score"].Value    = x.Value;
                    cmd.ExecuteNonQuery();
                }
            }
            cnn.Close();
            return(0);
        }