コード例 #1
0
        public void Save(GmConnection conn)
        {
            GmCommand cmd = conn.CreateCommand();

            cmd.AddInt("Id", id);
            cmd.AddInt("UserId", userId);
            cmd.AddString("Name", name);
            cmd.AddString("Data", data.GetXmlString());

            if (id == 0)
            {
                cmd.CommandText = "insert into WatchingSchemes values (@UserId,@Name,@Data) select @@Identity";
                id = (int)(decimal)cmd.ExecuteScalar();
            }
            else
            {
                cmd.CommandText = "update WatchingSchemes set UserId=@UserId,Name=@Name,Data=@Data where Id=@Id";
                cmd.ExecuteNonQuery();
            }
        }